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.