We are in ERP Financials Cloud : we are designing the solution in Cash Management module for cash reconciliation between Bank Statement and AR Receipts. We want to use the autoreconciliation process as there are thousand of transactions to be reconciled.
The settlement number is the field that can be used to autoreconcile bank statements and AR Receipts. The issue is that we don't find a field to store the settlement number in AR Miscellaneous Receipt.
In the setup task "Manage Bank Statement Reconciliation Matching Rules" in the "advanced criteria", we use the "Statement.End to end ID" from bank statement to store the ID of settlement number (this is available in the FBDI file of bank statement import at line level). There is the "receipt batch number" that can be used to store the settlement number in AR Receipt and it is available in the "Advanced Criteria" of setup task "Manage Bank Statement Reconciliation Matching Rules"
But for AR receipt we are using webservice to generate the Miscellaneous receipt: in attachment the example of payload. Unfortunately the receipt batch number is not available in the pay load.
Which field can be used? we need a field available both in AR Miscellaneous Receipt payload and in the advanced criteria of "Manage Bank Statement Reconciliation Matching Rules" in Cash Management
Thanks, regards
Miscellaneous_Receipt_payload.txt (4.03 KB)