I have a client that is trying to run the Update 1099 Information utility. However, when processing for Vendor and 1099 transactions, it will not update anything. The report prints but with no information, and no transactions have been moved to the new box as desired. This is after the YE update as the client is on 18.3.1173. Has anyone seen this issue since updating?
Hi,
Have you checked if any tips from this YE blog post would be helpful ?
community.dynamics.com/.../microsoft-dynamics-gp-year-end-update-2020-payables-management-new-1099-nec
I know there are some bugs reported about the 1099's after upgrades..
www.gpug.com/.../viewthread
Thanks for the link!
I have seen this and been through that before though. Specifically Question and Answer #9 from that article. My issue is that method is not working. This user, and myself are pretty familiar with how to update 1099 information using the tools in GP.
I noticed that the automatic update from 1099 MISC box 7 to 1099 NEC didn't work correctly either. And the Update 1099 Utility is not functioning as needed as well.
In the short term I think I can update SQL or create a macro to update on the front end, but this isn't something the end user wants to have to deal with in an ongoing basis.
Thanks for the response! I appreciate getting as many eyes on this issue as possible.
I know there is a 1099Fix.sql script that was release post-YE release as some issues were reported around 1099's.
mbs2.microsoft.com/.../
also, this blog post could be useful: trainingbyamberbell.com/.../
Hi JBurgess,
You state you are on 18.3.1173, but the year end update is 18.3.1200.
You should be good on 18.3.1173 as it should have the new reports, but based on your comments nothing was moved from Box 7. This points to the issue Beat was talking about as this first update didn't move everything that was needed:
community.dynamics.com/.../1099-misc-form-updates-for-tax-year-2020
I would start with the SQL Fix script and then go from there.
Thanks!
Thanks Justin, I will do this and report back, thanks for weighing in!
Jason
Running this script does not appear to have corrected the issues I'm seeing. The utility is not moving 1099 amounts, and vendors have not been correctly moved from 1099 MISC box 7 to 1099 MISC. Any other suggestions here?
Jason,
you may end-up like in this forum thread by creating your own update script to put the right value into the tables
community.dynamics.com/.../1099-update-for-gp-2013
Make a backup and the 1099 reconcile utility should update it correctly, so Misc box 7 moves to NEC box 1.
Cheryl Waswick
Microsoft Support
Hey Cheryl, thanks for reaching out. What kind of backup are you talking about? A database backup, or a backup of a table in SQL? The problem is that running the Update 1099 utility is NOT moving 1099 transactions like it should.
Do you mean running the regular reconcile or the update 1099 information utility?
Hello,
Just a backup of the company database or the PM00204 table really, just in case you need to restore it back for any reason.
There were issues in the October update (18.3.1173) with the utility and it was fixed in the YE update (18.3.1200) so if you install the latest patch, then it will work for you. On the October update, you also need to run the 1099FIX script noted above to populate the box numbers, and that was fixed n the YE update as well.
The purchasing reconcile utility for 1099 information should update the amounts to the right boxes too (from Box 7 on Misc form to Box 1 on NEC form). You can also edit by transaction in the Transactions | Purchasing | Edit 1099 information window. If Box 7 amounts are still showing in the 1099 Details window (in box 8 as a display issue), you can also run a script to update the PM00204 and set all type 4, box 7 to type 5, box 1.
Hope that helps,
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 734 Super User 2025 Season 2
CA Neeraj Kumar 636
Martin Dráb 553 Most Valuable Professional
