Settlement of Invoices and payments in AX 4.0

somanagoudar

Hello,

I'm supposed to design a report which displays all the invoices of a particular vendor.
In addition to it, the report should also print the invoices which are settled with the payments.

for e.g. take two invoices with invoice voucher number and amount

inv_001 is of rs. 25000
inv_002 is of rs. 30000

and payment with payment voucher number and amount
pay_001 is 2500

now pay_001 is used to settle inv_001

so the report should print pay_001 and its settled invoice i.e. inv_001

so, how do I come to know which payment is settled against which invoice. and which table will give the details about settlements.

](*,) f1 f1

somanagoudar

On doing a bit of R&D got to know that, there is a vendsettlement table which stores information about which invoice is settled against which payment.