Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Change Vendor Remit Ad...
Microsoft Dynamics GP (Archived)

Change Vendor Remit Address on Posted Transactions

(0) ShareShare
ReportReport
Posted on by Jennifer Wheeler

We are on GP2010 R2 and we have some vendors who have changed the remit address where we send payments.  We have changed the remit address on the vendor card.  For transactions that we have already posted, the checks are still getting printed with the old remit address.  So, it seems that when the transactions are posted it must take whatever the current remit address is at that time and save it in the SQL tables.  I have looked and can't find anywhere in the SQL tables where the remit address is saved for posted transactions.  Since the invoices have been posted I can't open them up to change the remit address so if someone knows what SQL table holds this info if you could respond I would appreciate it.

Thanks
Jennifer

*This post is locked for comments

  • Jennifer Wheeler Profile Picture
    Jennifer Wheeler on at
    Re: Change Vendor Remit Address on Posted Transactions

    Hi Laura

    What I do is if we have to change the code we are using in the Remit To box on the vendor card, the user will let me know what they changed it to.  Then I just go into the PM20000 table and find any outstanding payments due to the vendor and change the vendor address code to match the new one for this vendor.  It is very rare for us to change the code used for the Remit To so doing it this way works for us.

    Thanks

    Jennifer

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    Re: Change Vendor Remit Address on Posted Transactions

    The table is the PM10300 table when you are setting up checks to be printed.  (Work payment table).  You would have to go into this table and update the address prior to printing.  But the issue is that the remit to is stored on the PM20000 in the Vendor Address Code VADCDTRO: So if you had MAIN as the address code and you added REMIT.  The original transaction was posted with MAIN, unless the main address is changed the previously posted transactions are going to the MAIN address and not the new REMIT address.    And unless you update the REMIT TO box on the Vendor Card with the new REMIT address it will continue to go to the wrong address.

  • l5145 Profile Picture
    l5145 160 on at
    Re: Change Vendor Remit Address on Posted Transactions

    Jennifer,

    We are running into the same issue on GP 2010 R2, were you able to come up with a solution?

    Thanks,

    Laura

  • Jennifer Wheeler Profile Picture
    Jennifer Wheeler on at
    Re: Change Vendor Remit Address on Posted Transactions

    Hi Susan

    Thanks for the reply.  For this particluar vendor, they were using the PRI address id for all addresses on the vendor card.  Then they added a new address id for the Remit To.  When they did that they already had posted transactions that hadn't been paid that had the PRI address id.  So, that is why they had checks printing with the old address.

    Thanks

    Jennifer

  • Verified answer
    sueconrod Profile Picture
    sueconrod 335 on at
    Re: Change Vendor Remit Address on Posted Transactions

    The address is based on what is showing in the Remit to Address on the Vendor Maintenance Card.  If you are changing this it should show up when you are printing checks.  Too many times I have seen exactly what you are running into and if I go to the Vendor Maintenance Card I am seeing that it still has the old address showing up there.  (On the bottom left:  Address ID's:  Purchase, Remit To, Ship to).  

    But the PM10300 table actually will show you the address that is going to be printed once you have chosen a batch.  And I would be looking at the address that it is picking up just before being printed.

    The PM20000 is the open table and will show you the Remit ID that was assigned when the voucher was posted in the system.  .  But it only has the remit to id and if you had changed that remit to address, then when it picks up the checks it picks up the right address.  The entire address is not stored with the PM Open Table.  

    This is unlike the SOP tables that actually store the address on the open transactions.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans