{"id":17980,"date":"2026-01-30T12:29:42","date_gmt":"2026-01-30T12:29:42","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17980"},"modified":"2026-01-30T12:29:43","modified_gmt":"2026-01-30T12:29:43","slug":"how-auto-allocation-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-auto-allocation-works-in-idempiere\/","title":{"rendered":"How Auto Allocation Works in iDempiere"},"content":{"rendered":"\n

Auto Allocation is the mechanism iDempiere uses to automatically match completed <\/strong>p<\/strong>ayments\/<\/strong>r<\/strong>eceipts with open <\/strong>i<\/strong>nvoices<\/strong> for the same business partner. Its goal is to close the financial loop cleanly\u2014ensuring invoices move to p<\/em>aid<\/em> status without manual line-by-line allocation.<\/p>\n\n\n\n

Starting Point (Preconditions)<\/strong><\/h2>\n\n\n\n

Auto allocation only works when financial documents are already in a stable state.
A Sales invoice (AR)<\/strong> must be completed & posted<\/em>, and a corresponding payment \/ receipt<\/strong> must also be completed & posted<\/em>. Both must belong to the same business partner<\/strong> and be in the same currency<\/strong>.<\/p>\n\n\n\n

At this stage:<\/p>\n\n\n\n

    \n
  • The invoice shows o<\/strong>pen<\/strong> \/ <\/strong>u<\/strong>npaid<\/strong><\/li>\n\n\n\n
  • The payment exists but is not yet allocated<\/strong><\/li>\n<\/ul>\n\n\n\n

    Launching Auto Allocation<\/strong><\/h2>\n\n\n\n

    Auto allocation is triggered from p<\/strong>ayment<\/strong> and <\/strong>r<\/strong>eceipt \u2192 <\/strong>a<\/strong>uto <\/strong>a<\/strong>llocation<\/strong>.
    Here, the user defines how<\/em> the system should search and match documents.<\/p>\n\n\n\n

    Key inputs guide the allocation logic:<\/p>\n\n\n\n

      \n
    • Business <\/strong>p<\/strong>artner <\/strong>g<\/strong>roup<\/strong> or specific <\/strong>b<\/strong>usiness <\/strong>p<\/strong>artner<\/strong><\/li>\n\n\n\n
    • AP \/ AR scope<\/strong> (Receivables only, Payables only, or both)<\/li>\n\n\n\n
    • Optional a<\/strong>llocate <\/strong>o<\/strong>ldest <\/strong>f<\/strong>irst<\/strong><\/li>\n\n\n\n
    • Optional r<\/strong>un<\/strong> as <\/strong>j<\/strong>ob<\/strong> for background processing<\/li>\n<\/ul>\n\n\n\n

      Once confirmed, iDempiere scans all eligible invoices and payments under those rules.<\/p>\n\n\n\n

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

      Allocation Logic (What the System Does Internally)<\/strong><\/h2>\n\n\n\n

      The system applies a deterministic matching sequence. It does not guess<\/strong>.<\/p>\n\n\n\n

      First, it checks whether the payment explicitly references an invoice<\/strong>.
      If not, it then matches by exact amount<\/strong> between open invoices and available payments.
      If a<\/em>llocate <\/em>o<\/em>ldest <\/em>f<\/em>irst<\/em> is enabled, invoices are consumed chronologically.<\/p>\n\n\n\n

      Important behaviors:<\/p>\n\n\n\n

        \n
      • Allocation is amount-based<\/strong>, not line-based<\/li>\n\n\n\n
      • Partial allocations are allowed<\/li>\n\n\n\n
      • Over\/Under payments are recorded explicitly (no silent adjustments)<\/li>\n<\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Allocation Document Creation<\/strong><\/h2>\n\n\n\n

        When matching succeeds, iDempiere automatically creates a payment allocation document<\/strong>.<\/p>\n\n\n\n

        This document:<\/p>\n\n\n\n

          \n
        • Has its own document no<\/strong><\/li>\n\n\n\n
        • Is c<\/strong>ompleted<\/strong> & <\/strong>p<\/strong>osted<\/strong><\/li>\n\n\n\n
        • Contains allocation lines<\/strong> linking:\n
            \n
          • Business Partner<\/li>\n\n\n\n
          • Payment<\/li>\n\n\n\n
          • Invoice<\/li>\n\n\n\n
          • Allocated Amount<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n

            This allocation document becomes the audit bridge<\/strong> between invoice and payment.<\/p>\n\n\n\n

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

            Impact on Invoice and Payment<\/strong><\/h2>\n\n\n\n

            After allocation:<\/p>\n\n\n\n

              \n
            • The Invoice<\/strong> is marked p<\/strong>aid<\/strong><\/li>\n\n\n\n
            • The Payment<\/strong> shows allocation references<\/li>\n\n\n\n
            • The Allocation tab<\/strong> in the Invoice displays the linked payment and amount<\/li>\n<\/ul>\n\n\n\n

              Financial integrity is preserved\u2014no balances disappear, everything is traceable.<\/p>\n\n\n\n

              Sales Order (50007) \u2192 Shipment (500006) \u2192 Invoice (1000003) \u2192 Payment (4000007) \u2192 Auto <\/strong>a<\/strong>llocated to <\/strong>i<\/strong>nvoice.<\/strong><\/p>\n\n\n\n

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

              Accounting & Controls<\/strong><\/h2>\n\n\n\n

              From an accounting perspective:<\/p>\n\n\n\n

                \n
              • AR clearing is resolved<\/li>\n\n\n\n
              • Customer balance is updated correctly<\/li>\n\n\n\n
              • No extra journal entries are created beyond the allocation logic<\/li>\n<\/ul>\n\n\n\n

                If allocation cannot be completed (amount mismatch, currency mismatch, missing documents), the system fails safely<\/strong> and leaves documents untouched.<\/p>\n\n\n\n

                Why Auto Allocation Matters<\/strong><\/h2>\n\n\n\n

                Auto allocation removes repetitive finance work while enforcing strict accounting rules.
                It is especially critical in high-volume environments where manual allocation would be error-prone and slow.<\/p>\n\n\n\n

                Used correctly, it ensures:<\/p>\n\n\n\n

                  \n
                • Faster month-end closing<\/li>\n\n\n\n
                • Accurate customer balances<\/li>\n\n\n\n
                • Clean audit trails<\/li>\n<\/ul>\n\n\n\n

                  Summary Flow<\/strong><\/h2>\n\n\n\n
                    \n
                  • Invoice completed \u2192 payment received<\/li>\n\n\n\n
                  • Auto allocation executed<\/li>\n\n\n\n
                  • Allocation document created<\/li>\n\n\n\n
                  • Invoice marked paid \u2192 books stay balanced<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                    Auto Allocation is the mechanism iDempiere uses to automatically match completed payments\/receipts with open invoices for the same business partner. […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[33],"tags":[],"class_list":["post-17980","post","type-post","status-publish","format-standard","hentry","category-purchase"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17980","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17980"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17980\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}