iDempiere Vendor Payment and Receipt – Retail Business Scenarios

The Payment and Receipt window in iDempiere manages all outgoing financial transactions between a retail business and its suppliers. It is used in stores, warehouses, and head offices to record supplier payments, advance payments, partial payments, petty cash disbursements, and payment write-offs. Every AP transaction processed here directly impacts the supplier’s open balance, the general ledger, and the bank reconciliation process making it a critical window for day-to-day retail accounts payable operations.

Pay a Supplier for Inventory After Invoice Approval

Overview

Retail stores pay suppliers after receiving and verifying stock deliveries, once a supplier invoice has been approved in iDempiere and goods are confirmed as received. It typically occurs at the end of credit terms — for example, 30 days after invoice date.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Identifies this as an outgoing supplier payment
Business Partner	Britannia Distributor – Chennai	The supplier being paid for the delivered inventory
Invoice	1000001_06/12/2026_12980.00	The approved invoice being settled
Bank Account	Vendor Payment_Vendor Payment_123456	Account from which the payment is disbursed
Payment Amount	12,980.00	Full invoice value being paid
Currency	INR	Transaction currency matching the invoice
Tender Type	Check	Mode of payment — Check, Electronic Transfer, etc.
Account Date	06/17/2026	Date used to post the entry in the correct accounting period

Process Flow

1. Open the Payment and Receipt window and click New.
2. Set Document Type to AP Payment and select the Organization.
3. Select the Business Partner (supplier) and the Bank Account.
4. Select the approved supplier invoice in the Invoice field.
5. Enter the Payment Amount and set the Tender Type.
6. Set the Account Date and save. Then set Document Action to Complete.

System Behavior

• Reduces the outstanding AP balance for the supplier.
• Creates a debit to Accounts Payable and a credit to the bank account in the GL.
• Updates the invoice status to Paid once the payment is fully allocated.
• Sets the Allocated flag to checked on the payment record.
• Generates a payment journal entry dated to the Account Date.

Retail Example

Chennai Store receives inventory from Britannia Distributor – Chennai. After goods receipt and invoice verification, the finance team creates an AP Payment, selects Invoice 1000001_06/12/2026 for INR 12,980.00, sets Tender Type to Check, and completes the payment using Bank Account Vendor Payment_123456. The supplier balance drops to zero.

Outcome

• Supplier’s open invoice is closed.
• Bank account balance is reduced by the payment amount.
• Accounts payable ledger reflects the settled liability.
• Payment is available for bank reconciliation.

Make an Advance Payment to a Supplier

Overview

Some suppliers require an advance before dispatching goods, especially for seasonal stock or large orders. The Prepayment flag parks the payment as a credit with the supplier until a matching invoice arrives.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Outgoing payment to the supplier
Business Partner	CHENNAI SUPPLIERS	Supplier receiving the advance
Invoice	(blank)	No invoice exists at the time of advance
Prepayment	(checked)	Tells iDempiere to treat this as an advance, not an invoice payment
Bank Account	Vendor Payment_123456	Account from which advance is disbursed
Payment Amount	50,000.00	Advance amount agreed with the supplier
Tender Type	Electronic Transfer	Payment mode

Process Flow

1. Open the Payment and Receipt window and click New.
2. Set Document Type to AP Payment and select the Business Partner.
3. Leave the Invoice field blank.
4. Check the Prepayment flag.
5. Enter the Payment Amount and set Tender Type to Electronic Transfer.
6. Set the Account Date, save, and complete the document.

System Behavior

• Creates a debit to Supplier Prepayment account and credit to bank in the GL.
• Keeps the payment as open (unallocated) until an invoice is available.
• Does not immediately reduce the AP invoice balance.
• Prepayment appears as an open credit on the supplier’s account.

Retail Example

The finance team creates an AP Payment for CHENNAI SUPPLIERS with INR 50,000.00, sets Tender Type to Electronic Transfer, leaves the Invoice field blank, and checks the Prepayment flag. The document is completed and the advance is recorded as an open credit on the supplier’s account until the invoice arrives.

Outcome

• Advance is tracked as a supplier credit in the system.
• Bank cash position is accurately reduced.
• When the invoice arrives, the prepayment can be applied to reduce the payable amount.

Record a Partial Payment to a Supplier

Overview

When cash flow is tight, retail businesses may pay only part of a supplier invoice and settle the balance later. iDempiere supports this by allowing a payment amount lower than the invoice total, leaving an open balance on the invoice.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Outgoing supplier payment
Business Partner	AKSHAYA AGENCIES	Supplier being partially paid
Invoice	INV_2026_0821_60000.00	The invoice being partially settled
Payment Amount	30,000.00	Partial amount being paid now
Over/Under Payment	(checked)	Required when payment does not match invoice total
Currency	INR	Transaction currency
Tender Type	Electronic Transfer	Payment mode

Process Flow

1. Open the Payment and Receipt window and click New.
2. Set Document Type to AP Payment and select the supplier (AKSHAYA AGENCIES).
3. Select the supplier invoice in the Invoice field.
4. Enter the partial Payment Amount (30,000.00).
5. Check the Over/Under Payment flag to allow the amount difference.
6. Save and complete the document.

System Behavior

• Reduces the invoice outstanding balance by the payment amount.
• Invoice status remains Open (partially paid) in iDempiere.
• GL entry posts the partial payment to AP and bank accounts.
• Allocated flag is not checked until the invoice is fully paid.

Retail Example

The finance team creates an AP Payment for AKSHAYA AGENCIES, selects Invoice INV_2026_0821_60000.00, and enters INR 30,000.00 as the Payment Amount via Electronic Transfer. The Over/Under Payment flag is checked. The payment is completed and the invoice shows INR 30,000.00 remaining open for the next payment cycle.

Outcome

• Supplier receives partial settlement promptly.
• Remaining liability is visible on the open payables report.
• Second payment can be made in the next cycle to fully close the invoice.

Settle Multiple Supplier Invoices with a Single Payment

Overview

At month-end, retail businesses consolidate payments to a single supplier to reduce bank transaction costs. One AP Payment is created, and multiple invoices are allocated to it using the Payment Allocation window after completion.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Single outgoing payment to the supplier
Business Partner	ANMOL TOYS	Supplier with multiple open invoices
Payment Amount	2,45,000.00	Sum of all invoices being settled
Invoice	(blank at entry)	Invoices are allocated after completion via Payment Allocation
Bank Account	Vendor Payment_123456	Disbursement account
Tender Type	Electronic Transfer	Payment mode
Currency	INR	Transaction currency

Process Flow

1. Open the Payment and Receipt window and click New.
2. Set Document Type to AP Payment and select Business Partner (ANMOL TOYS).
3. Leave the Invoice field blank.
4. Enter the combined Payment Amount (2,45,000.00).
5. Save and complete the document.
6. Navigate to Payment Allocation, select the supplier, and distribute the payment across all open invoices.

System Behavior

• One GL entry is created for the full payment amount.
• Payment Allocation creates individual allocation records for each invoice.
• Each invoice is marked as Paid once fully allocated.
• Allocated flag on the payment is checked after all invoices are matched.

Retail Example

The finance team creates a single AP Payment for ANMOL TOYS for INR 2,45,000.00 via Electronic Transfer using Bank Account Vendor Payment_123456, with the Invoice field left blank. After completing the payment, Payment Allocation is used to distribute the amount across all open invoices of ANMOL TOYS and close them in one step.

Outcome

• All three supplier invoices are closed in one transaction.
• Bank records one outgoing entry instead of three.
• Supplier account shows zero outstanding balance.

Handle Supplier Overpayments

Overview

A supplier is occasionally paid more than the invoice amount due to a calculation error or rounding. The excess is recorded as an open debit on the supplier account and applied to future invoices or refunded.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Outgoing supplier payment
Business Partner	ANNAM ENTERPRISES	Supplier who was overpaid
Invoice	INV_2026_0610_45,000.00	Original invoice being paid
Payment Amount	46,000.00	Amount actually paid — higher than invoice
Over/Under Payment	(checked)	Allows the payment to differ from invoice total
Currency	INR	Transaction currency
Tender Type	Electronic Transfer	Payment mode

Process Flow

1. Open the Payment and Receipt window and click New.
2. Select the Business Partner (ANNAM ENTERPRISES) and the invoice.
3. Enter the actual amount paid (46,000.00) in the Payment Amount field.
4. Check the Over/Under Payment flag.
5. Save and complete the payment.
6. In Payment Allocation, allocate INR 45,000 to the invoice. The remaining INR 1,000 stays as an open debit on the supplier account.

System Behavior

• Full payment amount is posted to the bank account.
• Invoice is fully allocated and closed.
• Excess INR 1,000 remains as an open unapplied debit on the supplier account.
• Debit can be applied to the next invoice through Payment Allocation.

Retail Example

ANNAM ENTERPRISES raises Invoice INV_2026_0610 for INR 45,000.00. The finance team mistakenly pays INR 46,000.00 via Electronic Transfer. The AP Payment is recorded with Over/Under Payment enabled. The invoice is fully allocated and closed, and INR 1,000.00 sits as an open debit on the ANNAM ENTERPRISES account to be offset against the next invoice.

Outcome

• Invoice is closed without manual adjustment.
• Supplier debit is tracked and visible on the account.
• Excess amount can be recovered by applying it to a future supplier invoice.

Record Daily Store Cash Payments to Petty Cash Suppliers

Overview

Retail stores make small cash disbursements for local purchases, repairs, or sundry supplies. These are recorded as AP Payments with Tender Type set to Cash, ensuring petty cash outflows are captured against the correct supplier and expense account.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Outgoing cash payment to a local supplier
Organization	Chennai Store	The store making the cash payment
Business Partner	ANSIO INDUSTRIES PVT LTD	Supplier receiving the cash payment
Bank Account	Petty Cash_Chennai Store	Petty cash account from which payment is made
Payment Amount	1,250.00	Cash amount paid for the purchase
Tender Type	Cash	Mode being used — cash disbursement
Transaction Date	06/16/2026	Date of the physical cash payment
Account Date	06/16/2026	Accounting date for the GL entry
Description	Stationery purchase – Chennai Store 16 June 2026	Reference for petty cash reconciliation

Process Flow

1. Open the Payment and Receipt window and click New.
2. Select the Organization as Chennai Store.
3. Set Document Type to AP Payment and Business Partner to ANSIO INDUSTRIES PVT LTD.
4. Select the Petty Cash_Chennai Store bank account.
5. Set Tender Type to Cash and enter the Payment Amount (1,250.00).
6. Enter a Description for reconciliation. Set Transaction Date and Account Date to 06/16/2026.
7. Save and complete the document.

System Behavior

• Creates a GL entry crediting the petty cash account and debiting the expense or AP account.
• Cash disbursement is captured as a payment record for petty cash reconciliation.
• Supplier balance is updated if linked to an invoice; otherwise recorded as a direct payment.

Retail Example

Chennai Store purchases stationery for INR 1,250 from ANSIO INDUSTRIES PVT LTD. The store manager creates an AP Payment with Tender Type: Cash, petty cash account selected, and Description: ‘Stationery purchase – Chennai Store 16 June 2026’. The entry is completed and the petty cash balance is reduced.

Outcome

• Cash disbursement is accurately reflected in the petty cash account.
• Petty cash and expense accounts reconcile at day-end.
• Audit trail is maintained for each cash payment.

Reverse an Incorrect AP Payment Transaction

Overview

When a payment is recorded with an incorrect amount, wrong supplier, or wrong bank account, it must be reversed rather than deleted. iDempiere creates an offsetting entry, keeping the audit trail intact.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Status	Completed	Payment must be in Completed status before reversal
Document Action	Reverse – Correct	Action selected to create the reversal entry
Business Partner	ARC FOODS AND BEVERAGES	The supplier on the incorrect payment
Document No	1000001	Original payment document being reversed
Reversal Document No	1000002	System-generated reversal document
Account Date	06/16/2026	Date the reversal is posted to the GL

Process Flow

1. Open the completed AP Payment in the Payment and Receipt window.
2. Verify the Document Status is Completed.
3. In Document Action, select Reverse – Correct.
4. Confirm the action when prompted.
5. iDempiere generates a new payment document (e.g., 1000002) with reversed values.
6. Create a new correct AP Payment with the right details.

System Behavior

• Creates a new payment document with reversed amounts (negative entries).
• Original GL entry is offset by the reversal entry.
• Supplier balance returns to the pre-payment position.
• Both original and reversal documents remain visible for audit.
• The Allocated flag on the original payment is unchecked after reversal.

Retail Example

An AP Payment (Document No. 1000001) was made to ARC FOODS AND BEVERAGES with an incorrect bank account. The finance manager opens the completed payment, selects Reverse – Correct from Document Action, and iDempiere generates Document No. 1000002 as the reversal dated 06/16/2026. The correct payment is then re-entered with the right bank account.

Outcome

• Incorrect payment is cancelled without data loss.
• Audit trail shows both original and reversal entries.
• Supplier’s balance is restored to its pre-payment state.
• Correct payment can be processed immediately after reversal.

Write Off Small Balance Differences on Supplier Invoices

Overview

After applying a supplier payment, small differences may remain on an invoice — caused by rounding, currency conversion, or minor discrepancies. iDempiere allows these to be written off using the Write-off Amount field instead of issuing a debit note.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	Outgoing supplier payment
Business Partner	ARROW TECHNOLOGIES PRIVATE LIMITED	Supplier with the small balance
Invoice	INV_2026_0544_25,000.50	Invoice with a minor outstanding balance after payment
Payment Amount	25,000.00	Amount actually paid
Write-off Amount	0.50	Small difference being written off to close the invoice
Discount Amount	0.00	No discount applicable here
Currency	INR	Transaction currency

Process Flow

1. Open the Payment and Receipt window and click New.
2. Select the Business Partner (ARROW TECHNOLOGIES PRIVATE LIMITED) and the invoice.
3. Enter the actual Payment Amount (25,000.00).
4. In the Write-off Amount field, enter 0.50 (the balance difference).
5. Confirm: Payment Amount + Write-off Amount = Invoice Total (25,000.50).
6. Save and complete the document.

System Behavior

• Posts the payment amount to the bank or AP account.
• Write-off amount is posted to the configured Write-off GL account.
• Invoice is marked as Paid and fully closed.
• No debit note is required for the small difference.

Retail Example

ARROW TECHNOLOGIES PRIVATE LIMITED raises Invoice INV_2026_0544 for INR 25,000.50. The finance team pays INR 25,000.00 and enters INR 0.50 in the Write-off Amount field. The total of Payment Amount plus Write-off Amount equals INR 25,000.50, fully closing the invoice. The 50 paise difference is posted to the write-off expense account.

Outcome

• Invoice is closed without issuing a debit note.
• Write-off amount is captured in the P&L as a minor expense.
• AP aging report no longer shows the invoice as outstanding.

Allocate an Unassigned AP Payment to a Supplier Invoice

Overview

AP Payments sometimes completed without linking to a specific invoice — such as advance payments or bulk payments — are matched to supplier invoices at a later stage using the Payment Allocation window.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Document Type	AP Payment	The unallocated payment to be matched
Business Partner	AW FABER CASTELL INDIA PRIVATE LIMITED	Supplier with an unmatched payment
Allocated	(unchecked)	Indicates the payment is not yet matched to an invoice
Invoice	(blank)	Will be assigned in Payment Allocation
Payment Amount	75,000.00	Amount sitting as unallocated
Document Status	Completed	Payment must be completed before allocation

Process Flow

1. Navigate to Financial Management → Accounts Payable → Payment Allocation.
2. Select the Business Partner (AW FABER CASTELL INDIA PRIVATE LIMITED).
3. The window displays open payments and open invoices for the supplier.
4. Select the unallocated payment (INR 75,000.00) and the matching supplier invoice.
5. Click Process to post the allocation.

System Behavior

• Payment Allocation window matches open AP payments to open supplier invoices.
• Once allocated, the Allocated flag on the payment is automatically checked.
• Invoice outstanding balance is reduced or closed.
• GL allocation entry is created to link the payment to the invoice.
• Supplier’s open balance is updated immediately.

Retail Example

An AP Payment of INR 75,000.00 was completed for AW FABER CASTELL INDIA PRIVATE LIMITED without linking an invoice. When the matching purchase invoice for INR 75,000.00 is confirmed, the finance team opens Payment Allocation, selects the open payment and the invoice for AW FABER CASTELL INDIA PRIVATE LIMITED, and posts the allocation. The invoice is closed and the Allocated flag is checked on the payment.

Outcome

• Previously unmatched payment is tied to the correct supplier invoice.
• Open payables report no longer shows the amount as outstanding.
• Allocated flag is updated on the payment record.
• Supplier’s balance reflects the correct settled position.