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?
As mentioned above, you need to be on the year-end update (18.3.1200) where the utility is fixed.
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?
[/quote]The main window used to correct 1099 transactions in GP is the Update 1099 Information window FaceTime App.
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
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?
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
Jason,
you may end-up like in this forum thread by creating your own update script to put the right value into the tables
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?
Thanks Justin, I will do this and report back, thanks for weighing in!
Jason
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!
I know there is a 1099Fix.sql script that was release post-YE release as some issues were reported around 1099's.
also, this blog post could be useful: trainingbyamberbell.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148