We help IT Professionals succeed at work.

Dynamics GP: Remit To Address ID

Software Engineer
Software Engineer used Ask the Experts™
on
Hi:

A Microsoft Dynamics GP 2018 end user showed me where the "Remit To" Address ID in a posted payables invoice is not showing the same Remit To ID as what is showing in Vendor Maintenance.

She says that she does not know of anyone making any changes to the invoice once entered in Payables Transaction Entry or in the Edit Payables Transaction window after entry.

Are there any other ways where the incorrect Remit To Address ID could have been derived?

Thanks!

Software Engineer
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner / Dynamics GP Consultant
Commented:
Is it possible that the remit to address on the Vendor Maintenance changed after the invoice was posted? Out of the box GP does not keep track of specific changes to fields, but there is a modified date (MODIFDT) and also the last date anything on the vendor record was changed (DEX_ROW_TS) in the PM00200 table that you can check to see how recently changes to the vendor record were made.

I decided to check on our data if this was an issue with any invoices, below is a little query I put together for that. I did get a few results, but they were all prior to 2006. I believe that the remit to address was not in GP originally and was added a number of versions ago, not sure what year or version, so I would only look at results with a recent DOCDATE.

select t.VENDORID, t.DOCNUMBR, t.DOCDATE, t.VADCDTRO, v.VADCDTRO
from PM30200 t 
inner join PM00200 v
	on t.VENDORID = v.VENDORID
where t.DOCTYPE = 1 and t.VADCDTRO <> v.VADCDTRO and t.DOCDATE > v.MODIFDT
order by t.DOCDATE desc

Open in new window

Author

Commented:
Thank you, Victoria!  Great insights, as usual!

John