ERPstuff - Oracle EBS Community

Hi,

For detailed payment matching criterian is.


Payment Number / invoice number and supplier bank account / invoice number and supplier name.
What is invoice number here? Is it invoice against payment made? HowBank Statement knows invoice number for matching?

Similarly for receipt what is invoice number?

What is reference number in available transactin search? Where do we capture in receipt?

I have not fully understood your requirement.

Are you looking for the reconciliation criteria?

You should have the following fields in your bank statement.

1. Bank statement number
2. Bank statement date
3. Bank/Branch/Account Number
4. GL Date
5. Transaction Code (Payment or Receipt, etc)
6. Cheque Number (Receipt Number in case of receipt)
7. Amount (Payment or Receipt Amount)

All other fields are optional.

<b>HowBank Statement knows invoice number for matching?
</b>

You don't need invoice number (Both AR and AP) in the bank statement for reconciliation.

I am not sure about the reference number (As per oracle doc, it is used for misc transactions). Will update you if I have more info on this.

Cheers,
Saravanan TG