NexCommand AINexCom Knowledge Base
Field reference

Payment Entry

How to use Payment Entry 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 internal/admin record 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: Series, Payment Type, Posting Date, Company, Account Paid From, Account Paid To, Paid Amount, Source Exchange Rate, Received Amount, Target Exchange Rate.

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

  1. Open Payment Entry from Finance & Accounting → Banking & Payments, or use ERP Search.
  2. Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
  3. 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.
  4. Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
  5. Save the record and address validation messages. Reload and verify the saved values and relationships.
  6. When the draft is complete and you are authorized, submit it through the available approval process. Submission can create operational or accounting effects. Use the permitted cancellation/amendment process for later corrections.

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.

FieldType / behaviorHow to use it
Seriesnaming_seriesSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • ACC-PAY-.YYYY.-
Payment Typepayment_typeSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Receive
  • Pay
  • Internal Transfer
Posting Dateposting_dateDate
Required
Choose the business date required for this field. Confirm its relationship to other dates on the record.
CompanycompanyLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Company

Mode of Paymentmode_of_paymentLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Mode of Payment

Party Typeparty_typeLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: DocType

PartypartyDynamic Link
Optional
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Party Nameparty_nameData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Book Advance Payments in Separate Party Accountbook_advance_payments_in_separate_party_accountCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Consider for Tax Withholdingapply_tdsCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Tax Withholding Categorytax_withholding_categoryLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Tax Withholding Category

Company Bank Accountbank_accountLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Bank Account

Party Bank Accountparty_bank_accountLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Bank Account

Contactcontact_personLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Contact

Emailcontact_emailData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Account Paid Frompaid_fromLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

Account Currency (From)paid_from_account_currencyLink
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: Currency

Account Paid Topaid_toLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

Account Currency (To)paid_to_account_currencyLink
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: Currency

Paid Amountpaid_amountCurrency
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Source Exchange Ratesource_exchange_rateFloat
Required
Enter a numeric value using the required unit and precision.
Paid Amount (Company Currency)base_paid_amountCurrency
Required · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Received Amountreceived_amountCurrency
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Target Exchange Ratetarget_exchange_rateFloat
Required
Enter a numeric value using the required unit and precision.
Received Amount (Company Currency)base_received_amountCurrency
Required · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Payment ReferencesreferencesTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Payment Entry Reference

Total Allocated Amounttotal_allocated_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Total Allocated Amount (Company Currency)base_total_allocated_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Unallocated Amountunallocated_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Difference Amount (Company Currency)difference_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Purchase Taxes and Charges Templatepurchase_taxes_and_charges_templateLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Purchase Taxes and Charges Template

Sales Taxes and Charges Templatesales_taxes_and_charges_templateLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Sales Taxes and Charges Template

Advance Taxes and ChargestaxesTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Advance Taxes and Charges

Total Taxes and Charges (Company Currency)base_total_taxes_and_chargesCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Total Taxes and Chargestotal_taxes_and_chargesCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Payment Deductions or LossdeductionsTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Payment Entry Deduction

Tax Withholding Grouptax_withholding_groupLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Tax Withholding Group

Ignore Tax Withholding Thresholdignore_tax_withholding_thresholdCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Edit Tax Withholding Entriesoverride_tax_withholding_entriesCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Tax Withholding Entriestax_withholding_entriesTable
Optional
Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Tax Withholding Entry

Cheque/Reference Noreference_noData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Cheque/Reference Datereference_dateDate
Optional
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Clearance Dateclearance_dateDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
ProjectprojectLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Project

Cost Centercost_centerLink
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

StatusstatusSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Draft
  • Submitted
  • Cancelled
Custom Remarkscustom_remarksCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
RemarksremarksSmall Text
Optional
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
In Words (Company Currency)base_in_wordsSmall Text
Optional · Read-only
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Is Openingis_openingSelect
Optional
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • No
  • Yes
Letter Headletter_headLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Letter Head

Print Headingprint_headingLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Print Heading

BankbankRead Only
Optional
System-provided value; correct its source record or calculation rather than overwriting the displayed result.
Bank Account Nobank_account_noRead Only
Optional
System-provided value; correct its source record or calculation rather than overwriting the displayed result.
Payment Orderpayment_orderLink
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: Payment Order

In Wordsin_wordsSmall Text
Optional · Read-only
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Amended Fromamended_fromLink
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: Payment Entry

Auto Repeatauto_repeatLink
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: Auto Repeat

Child tables

Payment References — child-row fields
FieldType / behaviorHow to use it
Typereference_doctypeLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: DocType

Namereference_nameDynamic Link
Required
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Due Datedue_dateDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Supplier Invoice Nobill_noData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Payment Termpayment_termLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Payment Term

Payment Term Outstandingpayment_term_outstandingFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Account Typeaccount_typeData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Payment Typepayment_typeData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Reconcile Effect Onreconcile_effect_onDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
Grand Totaltotal_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Outstandingoutstanding_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Allocatedallocated_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Exchange Rateexchange_rateFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Exchange Gain/Lossexchange_gain_lossCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
AccountaccountLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

Payment Requestpayment_requestLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Payment Request

Payment Request Outstandingpayment_request_outstandingFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Advance Voucher Typeadvance_voucher_typeLink
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

Advance Voucher Noadvance_voucher_noDynamic Link
Optional · Read-only
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Advance Taxes and Charges — child-row fields
FieldType / behaviorHow to use it
Add Or Deductadd_deduct_taxSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Add
  • Deduct
Typecharge_typeSelect
Required
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Actual
  • On Paid Amount
  • On Previous Row Amount
  • On Previous Row Total
Reference Row #row_idData
Optional
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Account Headaccount_headLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

DescriptiondescriptionSmall Text
Required
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
Considered In Paid Amountincluded_in_paid_amountCheck
Optional
Enable or disable the named option only when it matches the intended record behavior.
Is Tax Withholding Accountis_tax_withholding_accountCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
Cost Centercost_centerLink
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

ProjectprojectLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Project

Tax RaterateFloat
Optional
Enter a numeric value using the required unit and precision.
Account CurrencycurrencyLink
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: Currency

Net Amountnet_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Amounttax_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
TotaltotalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Amount (Company Currency)base_tax_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Net Amount (Company Currency)base_net_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Total (Company Currency)base_totalCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Payment Deductions or Loss — child-row fields
FieldType / behaviorHow to use it
AccountaccountLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Account

Cost Centercost_centerLink
Required
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Cost Center

Amount (Company Currency)amountCurrency
Required
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Is Exchange Gain / Loss?is_exchange_gain_lossCheck
Optional · Read-only
Enable or disable the named option only when it matches the intended record behavior.
DescriptiondescriptionSmall Text
Optional
Provide concise contextual information relevant to the record. Avoid unrelated personal or confidential data.
DunningdunningLink
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: Dunning

Tax Withholding Entries — child-row fields
FieldType / behaviorHow to use it
CompanycompanyLink
Optional
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_typeLink
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

PartypartyDynamic Link
Optional · Read-only
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Tax IDtax_idData
Optional · Read-only
Enter the identifier or short text requested by the label. Preserve external reference numbers accurately.
Tax Withholding Categorytax_withholding_categoryLink
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: Tax Withholding Category

Tax Withholding Grouptax_withholding_groupLink
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: Tax Withholding Group

Base Taxable Amounttaxable_amountCurrency
Optional
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Tax Ratetax_ratePercent
Optional
Enter the percentage expected by the calculation and verify the resulting amount.
Base Tax Withheldwithholding_amountCurrency
Optional · Read-only
Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value.
Taxable Document Typetaxable_doctypeLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: DocType

Taxable Document Nametaxable_nameDynamic Link
Optional
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Taxable Datetaxable_dateDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
CurrencycurrencyLink
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: Currency

Exchange Rateconversion_rateFloat
Optional · Read-only
Enter a numeric value using the required unit and precision.
Under Withheld Reasonunder_withheld_reasonSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Threshold Exemption
  • Lower Deduction Certificate
Lower Deduction Certificatelower_deduction_certificateLink
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: Lower Deduction Certificate

Withholding Document Typewithholding_doctypeLink
Optional
Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: DocType

Withholding Document Namewithholding_nameDynamic Link
Optional
Select the record identified by the associated document-type field. Verify both the type and the linked record.
Withholding Datewithholding_dateDate
Optional · Read-only
Choose the business date required for this field. Confirm its relationship to other dates on the record.
StatusstatusSelect
Optional · Read-only
Choose one of the configured list values. Status fields may be controlled by the record workflow.
Available choices
  • Settled
  • Under Withheld
  • Over Withheld
  • Duplicate
  • Cancelled

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.