Field reference
Payment Reconciliation
How to use Payment Reconciliation in Banking & Payments: access, working steps, fields, related records and troubleshooting.
Purpose and access
Record receipts, payments and transfers with the correct party, accounts, currency and allocation. Reconcile bank activity with ERP entries. A payment record is not a bank transfer instruction unless a separately configured integration performs that action.
This page is a settings page in Finance & Accounting → Banking & Payments. Use the link above to open the configured destination; permissions are checked by the destination service.
ERP links open in a new tab. Sign in with your own account; record visibility, actions and approval authority follow your assigned permissions. Screens can differ by company and configuration.
Before you start
Prepare the required information: Company, Party Type, Party, Receivable / Payable Account.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Payment Reconciliation from Finance & Accounting → Banking & Payments, or use ERP Search.
- Review the existing configuration before editing.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Companycompany | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Party Typeparty_type | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Partyparty | Dynamic Link Required | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Receivable / Payable Accountreceivable_payable_account | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Default Advance Accountdefault_advance_account | Link Optional | Only 'Payment Entries' made against this advance account are supported. Linked record: Account |
From Invoice Datefrom_invoice_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
From Payment Datefrom_payment_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Minimum Invoice Amountminimum_invoice_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Minimum Payment Amountminimum_payment_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
To Invoice Dateto_invoice_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
To Payment Dateto_payment_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Maximum Invoice Amountmaximum_invoice_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Maximum Payment Amountmaximum_payment_amount | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Invoice Limitinvoice_limit | Int Optional | System will fetch all the entries if limit value is zero. |
Payment Limitpayment_limit | Int Optional | System will fetch all the entries if limit value is zero. |
Bank / Cash Accountbank_cash_account | Link Optional | This filter will be applied to Journal Entry. Linked record: Account |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Projectproject | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Project |
Filter on Invoiceinvoice_name | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Invoicesinvoices | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Payment Reconciliation Invoice |
Filter on Paymentpayment_name | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Paymentspayments | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Payment Reconciliation Payment |
Allocationallocation | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Payment Reconciliation Allocation |
Child tables
Invoices — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Invoice Typeinvoice_type | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Invoice Numberinvoice_number | Dynamic Link Optional · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Invoice Dateinvoice_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Amountamount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Outstanding Amountoutstanding_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Payments — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Reference Typereference_type | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Reference Namereference_name | Dynamic Link Optional · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Posting Dateposting_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Amountamount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Difference Amountdifference_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Remarksremarks | Small Text Optional · Read-only | Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data. |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Allocation — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Reference Typereference_type | Link Required · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Reference Namereference_name | Dynamic Link Required · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Invoice Typeinvoice_type | Link Required · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Invoice Numberinvoice_number | Dynamic Link Required · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Allocated Amountallocated_amount | Currency Required | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Difference Amountdifference_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Difference Posting Dategain_loss_posting_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Debit / Credit Note Posting Datedebit_or_credit_note_posting_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Difference Accountdifference_account | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Exchange Rateexchange_rate | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.