Compiere iDempiere

How to Import Payment in iDempiere

The Import Payment window allows importing payment transactions from external files into iDempiere. It is commonly used in retail for bank, POS, or payment gateway transactions and helps maintain accurate customer balances and financial reporting.

Process Flow

Import Payment Flow

Business Rules

  • Import file must follow the required template.
  • Business Partner must exist.
  • Currency should match payment data.
  • Duplicate payments should be avoided.
  • Payment amount cannot be zero.
  • Completed payments are available for allocation.

Prerequisites

  • Organization configured
  • Business Partner configured
  • Bank Account configured
  • Payment Method configured
  • Financial Period opened

Navigation

Menu → Financial Management → Import Payment

Configuration Steps

Step 1: Prepare Import File

Prepare the payment import template with Business Partner, Amount, Currency, Bank Account and Payment Date.

FieldSample ValueDescription
Business PartnerABC RetailCustomer/Vendor

Step 2: Import Records

Select the import file and execute the import process.

FieldSample ValueDescription
Business PartnerABC RetailCustomer/Vendor
Import Payment 1
Import Payment 2

Step 3: Validate Data

Review imported records and resolve validation errors.

FieldSample ValueDescription
Business PartnerABC RetailCustomer/Vendor

Step 4: Complete Import

Process validated records to create payment documents.

FieldSample ValueDescription
Business PartnerABC RetailCustomer/Vendor

Common Issues and Resolutions

IssueCauseResolution
Import failedInvalid formatUse supported template
Business Partner missingMaster data absentCreate Business Partner
Currency mismatchWrong currencyCorrect currency
Closed periodPeriod closedOpen financial period
Duplicate paymentAlready importedRemove duplicate

Next Steps

  • Verify payments
  • Allocate payments to invoices
  • Review customer balances
  • Run payment reports