web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 1099 Misc Mass Update
Microsoft Dynamics GP (Archived)

1099 Misc Mass Update

(0) ShareShare
ReportReport
Posted on by Sunil Chhabra 1,958

We have several hundred 1099 Vendors that are setup in GP.

They are setup with the approriate taxid and are setup as MISC.

After running the 1099 report, it appears that we need to manually adjust several hundred of these records. I know we can do this one by one. But is there any way to integrate them.

In excel we have a list of VendorId and amounts mapped to the approriate boxes.

I realize the 1099  will not match the database, accounting records, but we will keep a backup to support our internal records.

Thanks

 

*This post is locked for comments

I have the same question (0)
  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,958 on at
    Re: 1099 Misc Mass Update

    Thanks for your feedback. Actually we will create a copy of the database and update the sql table pm00204 and run the 1099 out of the copy.  We will archive the copy of the database for audit purposes.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: 1099 Misc Mass Update

    Sunil,

    Yes, it's the PM00204 table. That is where the number comes from that prints on the 1099s (well, it adds the periods together). If you run a reconciliation sometime in the future it will change these numbers, but to get the 1099s out, that's what I would do. Remember, the table import utility will NOT update records, it will only add new records. Whatever you do  BACKUP, BACKUP, BACKUP, there's no turning back after you clear the table.

    Do you have a SQL dba on staff? A SQL update statement would be a lot cleaner.

    Kind regards,

    Leslie

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,958 on at
    Re: 1099 Misc Mass Update

    Leslie,  is that table PM00204?  Are there any other tables I need to update.

    Thanks

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: 1099 Misc Mass Update

    Hi Sunil,

    If your spreadsheet holds 100% of the information, you can delete all of the records in the 1099 detail table and then use the table import utility included with Dynamics GP to update the table.

    Kind regards,

    Leslie

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans