{"id":19033,"date":"2026-06-16T11:23:10","date_gmt":"2026-06-16T11:23:10","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=19033"},"modified":"2026-08-20T10:26:55","modified_gmt":"2026-08-20T10:26:55","slug":"how-to-process-payments-using-payment-selection-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-process-payments-using-payment-selection-in-idempiere\/","title":{"rendered":"How to Process Payments Using Payment Selection in iDempiere"},"content":{"rendered":"\n

Payment Selection is the iDempiere process used to identify invoices eligible for payment, group them into a batch, and generate vendor payments. In retail operations, it bridges Accounts Payable invoices and actual vendor settlement, supporting payment methods such as Check, Direct Deposit, and Direct Debit.<\/p>\n\n\n\n

Once processed, the selected Invoice is automatically allocated against the generated payment and marked as Paid, directly impacting vendor balances and cash management.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Invoice must be Completed and Posted before it qualifies for payment.<\/li>\n\n\n\n
  • Invoice must have an outstanding balance to be selected.<\/li>\n\n\n\n
  • Invoice Payment Rule must match the Payment Selection Payment Rule.<\/li>\n\n\n\n
  • Payment Selection Lines are generated only for eligible invoices.<\/li>\n\n\n\n
  • Prepared Payments must be generated before Payment Print\/Export.<\/li>\n\n\n\n
  • Check payments require a Bank Account Document configuration.<\/li>\n\n\n\n
  • Payment Print\/Export creates the actual Payment records.<\/li>\n\n\n\n
  • Successful payment processing automatically updates the invoice Paid status.<\/li>\n\n\n\n
  • Processed Payment Selection Lines become read-only.<\/li>\n\n\n\n
  • One Payment Per Invoice creates a separate payment for each invoice.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n

    Ensure the following configurations are completed:<\/p>\n\n\n\n

      \n
    • Vendor (Business Partner) configured.<\/li>\n\n\n\n
    • Purchase Order completed.<\/li>\n\n\n\n
    • Material Receipt completed.<\/li>\n\n\n\n
    • Invoice completed and posted.<\/li>\n\n\n\n
    • Vendor Payment Rule configured.<\/li>\n\n\n\n
    • Bank Account configured.<\/li>\n\n\n\n
    • Payment Rule available for the selected Bank Account.<\/li>\n\n\n\n
    • Bank Account Document configured for Check payments.<\/li>\n<\/ul>\n\n\n\n

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

      Step 1: Create Payment Selection<\/strong><\/h3>\n\n\n\n

      Create a New Payment Selection document that will be used to collect and process vendor invoices for payment.<\/p>\n\n\n\n

        \n
      • Open the Payment Selection window and click New Record. <\/li>\n\n\n\n
      • Select Organization, Bank Account, and Payment Date, then save to generate the document<\/li>\n<\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Header Configuration<\/strong><\/h3>\n\n\n\n
        Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
        Organization<\/td>CDC<\/td>Yes<\/td>Organization processing the payment<\/td><\/tr>
        Bank Account<\/td>Vendor Payment_123456<\/td>Yes<\/td>Source account used for payment<\/td><\/tr>
        Payment Date<\/td>16-Jun-2026<\/td>Yes<\/td>Date the payment batch is processed<\/td><\/tr>
        One Payment Per Invoice<\/td>Unchecked<\/td>No<\/td>Creates a separate payment per invoice when enabled<\/td><\/tr>
        Total Amount<\/td>Auto Calculated<\/td>Auto<\/td>Sum of selected invoice amounts<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Save the record.<\/p>\n\n\n\n

        A new Payment Selection document is successfully created.<\/p>\n\n\n\n

        Step 2: Generate Payment Selection Lines (Create From)<\/strong><\/h3>\n\n\n\n

        Create From retrieves vendor invoices that are eligible for payment based on the configured filters.<\/p>\n\n\n\n

          \n
        • Click Create From on the Payment Selection header.<\/li>\n\n\n\n
        • Set filters such as Only Due, Only Positive Balance, and Payment Rule, then click OK to pull eligible invoices.<\/li>\n<\/ul>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Create From Parameters<\/strong><\/h3>\n\n\n\n
          Field<\/th>Sample Value<\/th>Description<\/th><\/tr><\/thead>
          Business Partner Group<\/td>Blank<\/td>Restrict vendor group<\/td><\/tr>
          Business Partner<\/td>Blank<\/td>Restrict specific vendor<\/td><\/tr>
          Only Discount<\/td>Unchecked<\/td>Select discount-eligible invoices only<\/td><\/tr>
          Only Due<\/td>Checked<\/td>Select invoices currently due<\/td><\/tr>
          Due Date<\/td>Current Date<\/td>Due date filter<\/td><\/tr>
          Include Disputed<\/td>Unchecked<\/td>Include disputed invoices<\/td><\/tr>
          Match Requirement<\/td>None<\/td>Invoice matching requirement<\/td><\/tr>
          Payment Rule<\/td>Check<\/td>Invoice payment method<\/td><\/tr>
          Only Positive Balance<\/td>Checked<\/td>Select invoices with balance due<\/td><\/tr>
          Document Type<\/td>Blank<\/td>Restrict invoice document type<\/td><\/tr>
          Run as Job<\/td>Unchecked<\/td>Background execution<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          Eligible Invoice records are added as Payment Selection Lines.<\/p>\n\n\n\n

          Step 3: Review Payment Selection Line<\/strong><\/h3>\n\n\n\n

          Reviewing the line confirms invoice and payment details before payment preparation.<\/p>\n\n\n\n

            \n
          • Open the generated Payment Selection Line and verify Invoice, Payment Rule, Open Amount, and Payment Amount before proceeding.<\/li>\n<\/ul>\n\n\n\n
            Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
            Invoice<\/td>1000006_06\/16\/2026_14602.50<\/td>Auto<\/td>Selected invoice reference<\/td><\/tr>
            Payment Rule<\/td>Check<\/td>Yes<\/td>Payment method applied to the line<\/td><\/tr>
            Open Amount<\/td>14,602.50<\/td>Auto<\/td>Outstanding invoice amount<\/td><\/tr>
            Payment Amount<\/td>14,602.50<\/td>Yes<\/td>Amount to be paid<\/td><\/tr>
            Discount Amount<\/td>0.00<\/td>No<\/td>Discount applied to the payment<\/td><\/tr>
            Write-off Amount<\/td>0.00<\/td>No<\/td>Amount written off, if any<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Step 4: Prepare Payments<\/strong><\/h3>\n\n\n\n

            Prepare Payment converts the selection line into a payment instruction prior to actual payment generation.<\/p>\n\n\n\n

              \n
            • Click Prepare Payment on the Payment Selection header.<\/li>\n\n\n\n
            • Leave Override Payment Rule blank unless changing the method, then click OK.<\/li>\n<\/ul>\n\n\n\n

              Prepare Payment Parameters<\/strong><\/h3>\n\n\n\n
              Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
              Override Payment Rule<\/td>Blank<\/td>No<\/td>Replaces the invoice payment rule if set<\/td><\/tr>
              Run as Job<\/td>Unchecked<\/td>No<\/td>Runs the process in the background<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              The system creates Prepared Payment records.<\/p>\n\n\n\n

              Step 5: Review Prepared Payment<\/strong><\/h3>\n\n\n\n

              The Prepared Payment confirms the payment instruction before the actual payment is generated.<\/p>\n\n\n\n

                \n
              • Open the Prepared Payment tab and verify Business Partner, Payment Rule, and Payment Amount.<\/li>\n\n\n\n
              • Processed and Printed remain unchecked at this stage.<\/li>\n<\/ul>\n\n\n\n
                Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
                Business Partner<\/td>HAVELLS INDIA MART<\/td>Auto<\/td>Vendor receiving the payment<\/td><\/tr>
                Payment Rule<\/td>Check<\/td>Auto<\/td>Payment method carried from the line<\/td><\/tr>
                Payment Amount<\/td>14,602.50<\/td>Auto<\/td>Amount to be paid to the vendor<\/td><\/tr>
                Document No<\/td>1000000<\/td>Auto<\/td>Prepared Payment reference number<\/td><\/tr>
                Processed<\/td>Unchecked<\/td>Auto<\/td>Updates after Payment Print\/Export<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                At this stage, no actual payment exists yet. Prepared Payment exists and is awaiting payment generation.<\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                Step 6: Configure Bank Account Document<\/strong><\/h3>\n\n\n\n

                A valid check sequence must exist before checks can be generated for the bank account.<\/p>\n\n\n\n

                  \n
                • Navigate to Bank Account Document under Cash Management.<\/li>\n\n\n\n
                • Create a record with Payment Rule set to Check and assign a Current Next number for the Bank Account.<\/li>\n<\/ul>\n\n\n\n
                  Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
                  Name<\/td>Vendor Check Series<\/td>Yes<\/td>Identifies the check document series<\/td><\/tr>
                  Payment Rule<\/td>Check<\/td>Yes<\/td>Restricts the series to check payments<\/td><\/tr>
                  Current Next<\/td>1000<\/td>Yes<\/td>Next check number to be issued<\/td><\/tr>
                  Bank Account<\/td>Vendor Payment_123456<\/td>Yes<\/td>Bank account linked to the series<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n

                  Step 7: Execute Payment Print\/Export<\/strong><\/h3>\n\n\n\n

                  This step generates the actual Payment from the Prepared Payment and assigns check numbers.<\/p>\n\n\n\n

                    \n
                  • Navigate to Payment Print\/Export, select the Payment Selection, and confirm the prompt to create and complete payments.<\/li>\n<\/ul>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
                    Prompt<\/td>Is the payment print correct?<\/td>Confirmation shown before payment creation<\/td><\/tr>
                    Action<\/td>Click Yes<\/td>Creates and completes the Payment<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n

                    Step 8: Verify the Generated Payment<\/strong><\/h3>\n\n\n\n

                    Confirms the payment document was created and posted correctly against the vendor.<\/p>\n\n\n\n

                      \n
                    • Open the generated Payment document and verify Document Type, Payment Amount, Tender Type, Check No, and Document Status.<\/li>\n<\/ul>\n\n\n\n
                      Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
                      Document Type<\/td>Payment<\/td>Auto<\/td>Identifies the payment document type<\/td><\/tr>
                      Payment Amount<\/td>14,602.50<\/td>Auto<\/td>Amount paid to the vendor<\/td><\/tr>
                      Tender Type<\/td>Check<\/td>Auto<\/td>Payment method used<\/td><\/tr>
                      Check No<\/td>1000001<\/td>Auto<\/td>Generated check number<\/td><\/tr>
                      Document Status<\/td>Completed<\/td>Auto<\/td>Confirms the payment is finalized<\/td><\/tr>
                      Posted<\/td>Yes<\/td>Auto<\/td>Confirms accounting entries are posted<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                      \"\"<\/figure>\n\n\n\n

                      Step 9: Verify Invoice Settlement<\/strong><\/h3>\n\n\n\n

                      Confirms the invoice is fully settled once the payment has been allocated.<\/p>\n\n\n\n

                        \n
                      • Open the Invoice and confirm the Paid checkbox is enabled, with Document Status remaining Completed and Posted.<\/li>\n<\/ul>\n\n\n\n
                        Field<\/strong><\/td>Sample Value<\/strong><\/td>Mandatory<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
                        Invoice<\/td>1000006<\/td>Auto<\/td>Settled invoice reference<\/td><\/tr>
                        Grand Total<\/td>14,602.50<\/td>Auto<\/td>Total invoice amount<\/td><\/tr>
                        Paid<\/td>Checked<\/td>Auto<\/td>Confirms the invoice is fully settled<\/td><\/tr>
                        Document Status<\/td>Completed<\/td>Auto<\/td>Confirms the invoice remains finalized<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                        The Invoice is fully paid and removed from outstanding payables.<\/p>\n\n\n\n

                        \"\"<\/figure>\n\n\n\n

                        Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
                        Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
                        No Payment Selection Lines generated<\/td>Invoice not eligible for payment<\/td>Verify invoice status, due date, balance, and payment rule.<\/td><\/tr>
                        Payment Selection Line not created<\/td>Payment Rule mismatch<\/td>Ensure Invoice Payment Rule matches Payment Selection Payment Rule.<\/td><\/tr>
                        Prepared Payment not generated<\/td>No Payment Selection Lines available<\/td>Generate Payment Selection Lines first.<\/td><\/tr>
                        \u201cNo Bank Account Documents (Checks)\u201d error<\/td>Missing Bank Account Document configuration<\/td>Create a Bank Account Document with the Check payment rule.<\/td><\/tr>
                        Payment not created after Prepare Payment<\/td>Payment Print\/Export not executed<\/td>Execute Payment Print\/Export.<\/td><\/tr>
                        Invoice remains unpaid<\/td>Payment not completed or allocated<\/td>Verify the Payment document status and allocation.<\/td><\/tr>
                        Check number not assigned<\/td>Bank Account Document sequence exhausted<\/td>Update Current Next on the Bank Account Document.<\/td><\/tr>
                        Payment Selection Line is read-only<\/td>Line has already been processed<\/td>Create a new Payment Selection for additional invoices.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

                        Continue periodic payment processing using Payment Selection.<\/p>\n\n\n\n

                          \n
                        • Verify Payment accounting entries.<\/li>\n\n\n\n
                        • Reconcile the payment with the bank statement.<\/li>\n\n\n\n
                        • Review vendor account balances.<\/li>\n\n\n\n
                        • Monitor and maintain Bank Account Document sequences.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                          Payment Selection is the iDempiere process used to identify invoices eligible for payment, group them into a batch, and generate […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-19033","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19033","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=19033"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19033\/revisions"}],"predecessor-version":[{"id":27981,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19033\/revisions\/27981"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=19033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=19033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=19033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}