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 Ramon M.

    Hi Ramon,  Any luck with the refresh #3?  What's the ETA?

  • in reply to John Lian @The ERP Group

    Refresh #3 has been coded and will be built tonight.  Barring any hiccups, I would expect the new database install and the source code install to be posted Friday afternoon.  I will post a message when they are available from the portal.  Sorry for the delays and grief.

  • in reply to Ramon M.

    Thank you Ramon.

  • in reply to John Lian @The ERP Group

    yes, it clarifies it. Thank you.

  • in reply to Ramon M.

    Thanks Ramon.  Please include data fix script and instruction to apply refresh #3 on top of one of the previous refreshes as well.

  • in reply to John Lian @The ERP Group

    Is refresh #3 complete then?

  • in reply to Maria Reigle

    As of about Friday, January 15, 4 PM PST, the links for the downloads point to Refresh #3.  Only the DB install application and the source code changed.

  • in reply to Ramon M.

    Hi Ramon, thanks for getting this done.   Same 2 questions -

    1.  How do I apply this on sites that have had one of the previous 3 versions of 1099 updates already installed?   I just tried but got the "update already installed' error.   Or tell me what's changed exactly so that I can manually update.

    2.  Where is the data fix script?   I sort of figured it out already if the issue is only with tapVendPmtAppl flags, but would like an official one just in case I missed something.

  • in reply to John Lian @The ERP Group

    John, 

    Did you find solution or work around to re-apply 1099 Refreshed updates on server that already has TY 2020 patch? I also got the same message- "update already installed".

  • in reply to iubac-ASingh

    Not entirely.   There was an announcement posted yesterday about a resolution coming soon that affects history prior to 2020.   I did compare the DB scripts from refresh 3 with refresh 2 and didn't find any significant difference.

    For my clients who can't wait, I created and provided the following script to fix the form/box on tapVendPmtAppl table to match those on the vouchers.  Ramon was right about this being a prevalent issue.   What I found is that this problem actually caused the 1099 activity report and forms to not return any data for NEC form because they both look at tapVendPmtAppl.  So the problem was more serious than stated.   Anyway, with this fix, our clients haven't complained about the numbers reported, yet...  So fingers crossed.

    Update a set v1099form=v.V1099Form, V1099Box=v.V1099Box
    from tapVendPmtAppl a
    inner join tapvoucher v
    on a.applyToVouchKey=v.VoucherKey
    where ISNULL(a.v1099Form,0)<>ISNULL(v.v1099form,0)

Reply
  • in reply to iubac-ASingh

    Not entirely.   There was an announcement posted yesterday about a resolution coming soon that affects history prior to 2020.   I did compare the DB scripts from refresh 3 with refresh 2 and didn't find any significant difference.

    For my clients who can't wait, I created and provided the following script to fix the form/box on tapVendPmtAppl table to match those on the vouchers.  Ramon was right about this being a prevalent issue.   What I found is that this problem actually caused the 1099 activity report and forms to not return any data for NEC form because they both look at tapVendPmtAppl.  So the problem was more serious than stated.   Anyway, with this fix, our clients haven't complained about the numbers reported, yet...  So fingers crossed.

    Update a set v1099form=v.V1099Form, V1099Box=v.V1099Box
    from tapVendPmtAppl a
    inner join tapvoucher v
    on a.applyToVouchKey=v.VoucherKey
    where ISNULL(a.v1099Form,0)<>ISNULL(v.v1099form,0)

Children
  • in reply to John Lian @The ERP Group

    Friday's refresh (#3 January 15) was mostly about the way tapVendPMTAppl gets updated (it now does it only for 2020, whereas the prior version updated it for all years.  This was done in response to  requests about the history reports.  I am actively working on a script to restore of history prior to 2020 so the 1099 history reports will return again for past years for refresh #2 and prior to try and convert it to match refresh #3 style.  

    As to user iubac-ASingh's question, a database that has had the 1099 update applied already will not be able to be upgraded again.  So unless an unexpected situation has arisen where the tsmDBHistory  shows it being applied but it really wasn't, then any issues would need to be resolved outside of the install itself, such as the script I am working on to restore history prior to 2020 for prior versions of the script.

    If I have lost track of user iubac-ASingh's basic issue, I apologize.  Can I get reminded?