good afternoon; please your help:
I need to prepare a report for auditing purposes, I export from Dynamics SL to excel all the purchases recorded in AP, this should match with another report, in the report I have to mention (among others) Invoice nbr, date, batch, etc., now auditors want I add a new data such as payment date, batch, etc.
my problem is, I cannot identify how to link the invoices and its payment, Is there any table that contains this kind of information?
I hope somebody can understand my problem and help me please.
The relationship between the vouchers and payments is a many-to-many relationship.
One voucher can be partially paid by multiple cheques.
And one cheque can pay many vouchers.
It is tracked in the APAdjust table.
The "adjd" columns refer to the "adjusted document" - ie the Voucher.
And the "adjg" columns (along with the BankAcct & Bank Sub columns) refer to the "adjusting document" - ie the cheque.
When joining to the cheques, make sure you use the Acct & Sub columns, as well as the "adjg" columns. It is legal to use the same cheque number multiple times for different bank accounts.
Thanks a lot!, it worked perfectly as I wanted.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13