tracking invoices

(0) Share

Report

Posted on by Community Member Microsoft Employee

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.

Best regards

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: tracking invoices

Thanks a lot!, it worked perfectly as I wanted.

Best regards
Verified answer

Barry Flynn 3,090 on at

Like (0)

Report

RE: tracking invoices

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.

Barry