{"id":22412,"date":"2026-07-31T10:35:47","date_gmt":"2026-07-31T10:35:47","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=22412"},"modified":"2026-08-20T09:38:18","modified_gmt":"2026-08-20T09:38:18","slug":"how-to-import-payment-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-import-payment-in-idempiere\/","title":{"rendered":"How to Import Payment in iDempiere"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Import-Payment-WorkFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Import file must follow the required template.<\/li>\n\n\n\n
  • Business Partner must exist.<\/li>\n\n\n\n
  • Currency should match payment data.<\/li>\n\n\n\n
  • Duplicate payments should be avoided.<\/li>\n\n\n\n
  • Payment amount cannot be zero.<\/li>\n\n\n\n
  • Completed payments are available for allocation.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Organization configured<\/li>\n\n\n\n
    • Business Partner configured<\/li>\n\n\n\n
    • Bank Account configured<\/li>\n\n\n\n
    • Payment Method configured<\/li>\n\n\n\n
    • Financial Period opened<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n

      Menu \u2192 Financial Management \u2192 Import Payment<\/p>\n\n\n\n

      Configuration Steps<\/strong><\/h2>\n\n\n\n

      Step 1: Prepare Import File<\/strong><\/h3>\n\n\n\n

      Prepare the payment import template with Business Partner, Amount, Currency, Bank Account and Payment Date.<\/p>\n\n\n\n

      Field<\/th>Sample Value<\/th>Description<\/th><\/tr><\/thead>
      Business Partner<\/td>ABC Retail<\/td>Customer\/Vendor<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 2: Import Records<\/strong><\/h3>\n\n\n\n

      Select the import file and execute the import process.<\/p>\n\n\n\n

      Field<\/th>Sample Value<\/th>Description<\/th><\/tr><\/thead>
      Business Partner<\/td>ABC Retail<\/td>Customer\/Vendor<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-Import-Payment-1\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 3: Validate Data<\/strong><\/h3>\n\n\n\n

      Review imported records and resolve validation errors.<\/p>\n\n\n\n

      Field<\/th>Sample Value<\/th>Description<\/th><\/tr><\/thead>
      Business Partner<\/td>ABC Retail<\/td>Customer\/Vendor<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 4: Complete Import<\/strong><\/h3>\n\n\n\n

      Process validated records to create payment documents.<\/p>\n\n\n\n

      Field<\/th>Sample Value<\/th>Description<\/th><\/tr><\/thead>
      Business Partner<\/td>ABC Retail<\/td>Customer\/Vendor<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Common Issues and Resolutions<\/h2>\n\n\n\n
      Issue<\/th>Cause<\/th>Resolution<\/th><\/tr><\/thead>
      Import failed<\/td>Invalid format<\/td>Use supported template<\/td><\/tr>
      Business Partner missing<\/td>Master data absent<\/td>Create Business Partner<\/td><\/tr>
      Currency mismatch<\/td>Wrong currency<\/td>Correct currency<\/td><\/tr>
      Closed period<\/td>Period closed<\/td>Open financial period<\/td><\/tr>
      Duplicate payment<\/td>Already imported<\/td>Remove duplicate<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/h2>\n\n\n\n
        \n
      • Verify payments<\/li>\n\n\n\n
      • Allocate payments to invoices<\/li>\n\n\n\n
      • Review customer balances<\/li>\n\n\n\n
      • Run payment reports<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        The Import Payment window allows importing payment transactions from external files into iDempiere. It is commonly used in retail for […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22412","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22412"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22412\/revisions"}],"predecessor-version":[{"id":27187,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22412\/revisions\/27187"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}