web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Report.dic

(0) ShareShare
ReportReport
Posted on by 1,065

I am experiencing something very strange. A vendor's address have been updated to reflect changes in  printing 1099's in GP. Every part of the vendor's address have been updated but the state. I verified the vendor table PM00200 and the change are reflected there. Any ideas please?

Thanks 

 

*This post is locked for comments

I have the same question (0)
  • 26P2ER Profile Picture
    1,775 on at

    Was GP used to update the address fields? If via SSMS or Analyzer did you check PM00300 table as well?

  • cynthia dappah Profile Picture
    1,065 on at

    Yes, changes were done directly in GP, table PM00200 and PM00300 reflects the changes correctly

  • L Vail Profile Picture
    65,271 on at

    Have you looked at the report in Report Writer to make sure no changes have been made to where that field pulls its data? Also, as for the address you changed, is that the address that is on the face of the vendor card?

    Kind regards,

    Leslie

  • cynthia dappah Profile Picture
    1,065 on at

    Yes the address is on the face of the vendor card in GP correctly. We have made many changes to vendor addresses to reflect changes in 1099's. I have made changes to the 1099 miscellaneous report in GP and any address change have been done successfully. The vendor whole address was changed and everything changed except for the state will not change

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    If you're using GP2013, there's a new field in the lower left-hand corner address ID block that says '1099'. This is the address that the system will use to print 1099s. Is this ID set to the desired address ID (with the right state?)

    You can modify the RW 1099 report and drag over the State field from the Vendor Master instead of the state field from the temp file they use.

    Kind regards,

    Leslie

  • cynthia dappah Profile Picture
    1,065 on at

    Am on GP 10 SP5

  • L Vail Profile Picture
    65,271 on at

    Then I'd go for the RW modification. I know that doesn't answer your question, but it may solve the problem.

    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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans