Sage 500 ERP 1099 Tax Year 2020 Stand-Alone Updates - Refreshed

If you have previously downloaded this year's 1099 Stand-Alone Updates for Tax Year 2020 before 7:00 AM PST on December 28, 2020, then you should redownload them as a couple of things have changed.  Also, be sure to download and READ the release notes for the best experience.

Parents
  • TY 2020 1099 updates for MAS 500 ERP Version 2018 was downloaded and applied again on Jan 4 on both server and client workstation. Process was successful but Vendor 1099 Activity Report for NEC form does not show any vendor. However if amount in Edit Voucher 1099 Data is manually typed and saved then vendor data show up in above report. Our organization has numerous entities with lots of vendors, so manually editing each NEC vendor in each entity will be very time consuming. Do you have any solution to the problem? 

  • in reply to iubac-ASingh

    We can see the issue.  We hope to have a refresh shortly for those who have not downloaded the database portion of the stand-alone.  It is likely that a data fix will be provided to those that have already run it and applied it to their production database.  It turns out that when the process is run, the payment application records are not being updated with the form/box changes, so they refer to the original form/box combinations.  So on payment applications, if the payment application referenced 1099-MISC box 7 before the update, it will stay that way and not change to 1099-NEC box 1.  Similarly, if it referenced 1099-MISC box 10 before the update, it will stay the same and not change to 1099-MISC box 9, etc.

    At this point, we think it is more of a reporting issue involving payments to vendors, and not an issue that would cause 1099 amounts to be incorrect on 1099 forms.

    We are working on this with the highest priority.

  • in reply to John Lian @The ERP Group

    1) The 1099 TY 2020 Stand-Alone DB Install can be re-installed just like any other program.  So this should be done where ever it might be installed.  It is usually only installed on a single machine or two. 

    The 1099 update utility is separate from the actual servers or databases it acts upon.  Any database on a given server that has been updated previously, will not allow the update to be applied again.  If a customer has 10 databases on one or more servers, and two of those databases were updated using the previous version of the 1099 update utility, then those two could not be updated again and will return the already installed error message.  The remaining 8 could be updated if they had not previously been updated.  The updates apply to the database itself, not the SQL server. 

    Some will have a single server with a single database, so they would not be able run it again if the previous version was used.

    2)   If 1099 data has not been submitted for 2020, the data fix is still necessary if the previous version was used to update the database.  The latest update will prevent the data issue, independent of submission.  The issue is created upon updating the database and not related to submission.  It will not stop a submission, and does not affect the validity of the submission.  Submissions use voucher data, not associated payment data.  The issue breaks the link between the two, and the voucher data will have been correctly updated.  

  • in reply to John Lian @The ERP Group

    The refreshed links are now live as of today 1/8/2021 at about 11:30 AM.  Anyone going forward should use the refreshed links.

    As far as the voucher/payment links issue, I think it is actually an issue that has existed in the past but was made really obvious for tax year 2020.  The issue did not affect the validity of 1099 submissions.  It broke a link between vouchers and payments, specifically the tapVendPmtAppl table.  During the update process, a lot of tables get updated when they store a reference to a V1099form or a V1099Box.  The update triggers fire and update all those tables.  It appears that tapVendPmtAppl is not in that list, so it kept its references to the 1099 forms/boxes.  This issue would then show up when running the 

  • in reply to John Lian @The ERP Group

    The 1/8/2021 refreshes updated the database portion and the source code portion.  The client portion did not change (still the same exe/dll files), nor did the documents portion.

  • in reply to Ramon M.

    Ok, so what to do with databases that have been updated with either one of the two previous 1099 stand-alone updates for 2020?   Do they just need the data fix?    Or do any other database objects need to be updated?

    Either way, how exactly do we fix the databases that have been broken by previous updates?   I have two clients that have had previous update (the 2nd one) installed already.

  • in reply to Ramon M.

    hello Ramos,

    Reports, including Vendor 1099 Activity Report, are used for cross checking data validities. 1099 Activity Report is the only report that we can use to verify1099 data being send. Without this report, we are assuming that data to Atrix is accurate. In our case, database and client portion updates were applied two times- one original TY 2020 then after first refresh. We have one server with one database that already been upgraded. What are remedies for us? Do I need to apply TY 2020 server upgrade with 1/8/2021 refresh again? Or is there any query that should be run to resolve problem with report?   

  • in reply to Ramon M.

    Ramon - What exactly is the status of the 1099 updates now?  I saw on Friday that you told people to not process 1099s until further notice.  But that notice is now removed.  So does it mean it's safe to process, or should we wait for update 3?    Also, we still need answers to the question of how to apply the latest update on databases that have been updated by the 2 previous releases already.    Please advise so that I can answer my clients' questions.

  • in reply to John Lian @The ERP Group

    Should the existing releases on the Sage Knowledgebase be removed for now since they are incorrect?

  • in reply to John Lian @The ERP Group

    Sorry about the late response.  I had hoped to have refresh #3 today, but due to technical issues with my systems that started at midnight, I cannot get them built and out.  Refesh #2 an prior will create valid 1099 submissions, but do not handle history that well.  Refresh #3 will handle history better.

    While refresh #2 will generate correct 1099 submission data to Aatrix, if possible, I think waiting for #3 would be best if someone has not started the process yet.  There will be an updated data fix for prior versions that expands upon the one recently create in early January (that datafix is actually added to the installs to make refresh #3 happen before the fact rather than after the fact, which is better).  At the moment, I am waiting to get my systems problem resolved.  We recognize that time is of the essence, which is why I know the systems issues problem popped up after midnight earlier this morning.

  • in reply to Ramon M.

    I am not sure what you are referring to when you say "refresh #2" "refresh #3"

    is this problem part of the SAGE 500 -2020 Update ?    

  • in reply to Maria Murphy

    Maria, since the Original release of the standalone 1099 update for Sage 500, there have been 2 refreshes/fixes so far to that update.    The 3rd one (refresh #3) is imminent, as soon as Ramon's computer is fixed.    Hope this clarifies it.

Reply Children