Invoice Clearing Details

[Former Member]

Hi,

I would like to know if anybody know how to build a list as follows:

invoice_no, cleared doc, cleared amount, cleared date

cleared doc like incoming payment, down payment and credit memo

full settlement for the invoice is not necessary

Thanks a lot,

Vicki

[vinod_vemuru2]

Hi,

These details are available in BSAD table for customer invoice,

BSAK table for vendor invoice.

Pass the accounting doc as reference document to these tables and fetch all related(Clearing/Credit memos) documents.

All fields u require are also available in same tables.

Thanks,

Vinod.