While generating standard Accounts payable ageing statement in Baan IV ), it gives BaaN document number for purchase invoices..It does not give Actual Purchase Invoice Number stored on tfacp200 table.

Would anybody please help to let me know the logic in which I can also print supplier purchase invoice number alongwith its corresponding baan document number in above statement.

Can you be more specific? Baan document number ( tfacp200.docn ) and invoice number supplier ( tfacp200.isup ) are both available in this table.

Thanks for your reply. In table tfacp200.docn & tfacp200.isup are caputred on two different records. For position 0, tfacp200.docn is there and tfacp200.isup is not captured in position 0. For position 1 tcacp200.isup is captured.

The original supplier invoice number is on the invoice record, not in payments records.
I dont remember the name of the fields, but you have to get only records with last 4 fields of the main index empty.

... where tfacp200._index1 = {:ttyp, :invn, 0, "", "", 0}

only on this record there is the isup filled

Thank you all for your valuable guidance.. Would look into it once I get my standard BaaN installed and then let u know.