Clean out Old Vendor Addresses

(0) Share

Report

Posted on by Robyn

1,753

We have a desire to clean out and remove old Vendor addresses. So any address that has not been used in the last year we would like to remove. Step one of this to us was to run a report and look at the addresses used for the transactions in the PM30200 table. We were focusing on remittances at first so I ran a select * from PM30200 where doctype = 6 to see what fields I wanted to grab. I could not find any addresses in the table. I see the VADCDTRO field but it is blank for all my checks. Ran were doctype <> 6 and they are mostly populated. So does GP not capture the address of the check itself of where it was sent? Where is the address ID used for the actual purchase? Is it not tracked at all once a document is paid?

How would one go about getting a report of when an Address was last used for anything for a Vendor?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Heather Roggeveen 9,144 on at

Like (0)

Report

RE: Clean out Old Vendor Addresses

Hi

I don't think it does capture it at a check level. When you enter an invoice, the remit to is populated at that stage.

In the check creation process, it looks at the remit-to address. If you have two invoices for the same vendor, with two different remit-to addresses, two checks will be created.

So I think you only need to look at invoices.

Cheers

Heather