How to Configure AR Payment and Receipt in iDempiere

The Payment and Receipt window in iDempiere records customer payments against sales invoices and orders, capturing tender type, amount, and bank account for each transaction.

Every payment entered here drives accounts receivable balances, bank reconciliation, and daily sales reporting, making accurate configuration essential.

Process Flow

PaymentReceipt 1

Business Rules

  • Only Completed payments can be allocated to invoices or orders.
  • A single payment can be allocated across multiple invoices.
  • Receipt checkbox must be checked for incoming customer payments.
  • Tender Type determines whether the payment is Cash, Cheque, or Credit Card.
  • Bank Account controls the GL account used when the payment is posted.
  • Discount and Write-off amounts adjust the invoice balance during allocation.
  • Over/Under Payment flags any mismatch between payment and invoice amount.
  • Posted payments generate accounting entries and cannot be edited further.

Configuration Steps

Step 1: Create a New Payment or Receipt Document

Click New on the Payment and Receipt window; select Organization and Document Type “AR Receipt”; check Receipt so the record is treated as a customer receipt.

FieldSample ValueDescription
Document TypeAR ReceiptClassifies the transaction as a receipt
ReceiptCheckedMarks the record as an incoming payment
Tenthplanet iDempiere ARPayment Allocation 1
Tenthplanet iDempiere ARPayment 2

Step 2: Enter Reference Details

Select the Business Partner; choose the Invoice or Order to associate; confirm Transaction Date and Account Date default correctly.

FieldSample ValueDescription
Business PartnerFIVE TECHNOLOGIES PRIVATE LIMITEDIdentifies the paying customer
Invoice100001_07/01/2026_200.0Links payment to the outstanding invoice
Order60001_07/01/2026Links payment to the originating order
Transaction Date07/01/2026Date the payment was received

Step 3: Enter Payment Amounts

Enter the Payment amount; confirm Currency; adjust Discount Amount or Write-off Amount only where applicable.

FieldSample ValueDescription
Payment amount200.00Amount received from the customer
CurrencyINRCurrency used for the transaction
Discount Amount0.00Early-payment discount applied
Write-off Amount0.00Uncollectible balance written off

Step 4: Select Tender Type and Bank Account

Choose Tender type such as Cash; select the Bank Account for the collection point; enable Online Access when processed through a payment gateway.

FieldSample ValueDescription
Tender typeCashPayment method used by the customer
Bank AccountPOS UPI Collection_POS UPI_100002GL/bank account receiving the funds
Online AccessUncheckedEnables online gateway processing

Step 5: Complete and Post the Payment

Click Document Action and choose Complete; verify Document Status shows Completed; click Posted to confirm the accounting entries were generated.

FieldSample ValueDescription
Document StatusCompletedConfirms the document is finalized
PostedYesConfirms accounting entries were created

Step 6: Review or Create the Allocation

Open the Allocations tab; verify or create an allocation with Invoice, Order, and Amount; confirm the Allocated checkbox is set on the Payment tab.

FieldSample ValueDescription
Allocation490007Unique allocation record identifier
Amount200.00Amount allocated to the invoice
AllocatedCheckedConfirms the payment is matched to an invoice
Tenthplanet iDempiere ARPayment 1

Common Issues and Resolutions

IssueCauseResolution
Payment shows Allocated uncheckedNo allocation created against the invoiceOpen the Allocations tab and match the payment to the invoice
Over/Under Payment amount is not zeroPayment amount differs from invoice amountAdjust the allocation amount or apply Discount/Write-off
Posting fails with an accounting errorGL accounts not configured for the Bank AccountConfigure account mapping in the Bank Account window
Invoice not visible in the Invoice fieldInvoice not completed or belongs to a different Business PartnerComplete the invoice and confirm the matching Business Partner
Wrong Bank Account selected for a storeMultiple bank accounts not clearly labeledRename Bank Accounts to identify the store or collection point

Next Steps

  • Configure the Invoice (Customer) window for AR invoices.
  • Set up the Allocation window for multi-invoice matching.
  • Configure Bank Statement and Reconciliation.
  • Review the Cash Journal for POS cash drawer management.

Leave a Reply

Your email address will not be published. Required fields are marked *