Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Update 1099 Information Utility Not Processing

Posted on by 70

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? 

  • RE: Update 1099 Information Utility Not Processing

    As mentioned above, you need to be on the year-end update (18.3.1200) where the utility is fixed.

  • Burleson547 Profile Picture
    Burleson547 5 on at
    RE: Update 1099 Information Utility Not Processing
    [quote user="JBurgess"]

    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.

  • RE: Update 1099 Information Utility Not Processing

    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

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: Update 1099 Information Utility Not Processing

    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?

  • RE: Update 1099 Information Utility Not Processing

    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

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Update 1099 Information Utility Not Processing

    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

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: Update 1099 Information Utility Not Processing

    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?

  • JBurgess Profile Picture
    JBurgess 70 on at
    RE: Update 1099 Information Utility Not Processing

    Thanks Justin, I will do this and report back, thanks for weighing in!

    Jason

  • Suggested answer
    RE: Update 1099 Information Utility Not Processing

    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!

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Update 1099 Information Utility Not Processing

    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/.../

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.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans