{"id":20662,"date":"2026-07-15T05:32:39","date_gmt":"2026-07-15T05:32:39","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20662"},"modified":"2026-08-20T08:39:28","modified_gmt":"2026-08-20T08:39:28","slug":"how-to-process-a-dunning-run-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-process-a-dunning-run-in-idempiere\/","title":{"rendered":"How to Process a Dunning Run in iDempiere"},"content":{"rendered":"\n

The Dunning Run process evaluates outstanding invoices and payments against a configured Dunning Level and builds Dunning Run Entries and Lines for qualifying business partners.<\/p>\n\n\n\n

It is run periodically to identify overdue customer balances and organize them for the next step, printing reminder letters, without sending anything itself.<\/p>\n\n\n\n

The process only prepares collection data; it does not modify invoices, create payments, or change any document status.<\/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
  • The Dunning Run header defines Organization, Dunning Date, Dunning Definition, and Dunning Level as one processing batch.<\/li>\n\n\n\n
  • Creating the Dunning Run deletes any existing entries for that run before generating new ones.<\/li>\n\n\n\n
  • Organization, Sales Representative, and Currency are mandatory process parameters.<\/li>\n\n\n\n
  • Only Completed or Closed invoices that are unpaid with a nonzero open amount are considered.<\/li>\n\n\n\n
  • An invoice is skipped if its Dunning Grace date is later than the Dunning Run date.<\/li>\n\n\n\n
  • An invoice is skipped when Days Due is below the level’s Days After Due, unless Show All Due is enabled.<\/li>\n\n\n\n
  • Disputed invoices are excluded unless Include Disputed is enabled.<\/li>\n\n\n\n
  • Sequential Dunning Levels require earlier levels to be satisfied before an invoice reaches a higher level.<\/li>\n\n\n\n
  • Days Between Dunning prevents an invoice from being dunned again before the waiting period elapses.<\/li>\n\n\n\n
  • Invoices are grouped into one Dunning Run Entry per Business Partner, Currency, Sales Representative, and Dunning Level.<\/li>\n\n\n\n
  • AP invoice amounts appear as negative values on the Dunning Run Line.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Dunning Definition and Levels configured.<\/li>\n\n\n\n
    • Business Partner assigned to the same Dunning Definition as the selected level.<\/li>\n\n\n\n
    • Sales Representative and Currency available for the process parameters.<\/li>\n\n\n\n
    • Invoices completed with an open, unpaid balance.<\/li>\n<\/ul>\n\n\n\n

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

      Step 1: Create the Dunning Run Header<\/strong><\/h3>\n\n\n\n

      Create a new Dunning Run, select the Organization, Dunning Date, Dunning Definition, and Dunning Level, then save.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/td>CDC<\/td>Organization this dunning batch applies to<\/td><\/tr>
      Dunning Date<\/td>10\/08\/2026<\/td>Date used to calculate Days Due for every invoice<\/td><\/tr>
      Dunning<\/td>Standard Customer Dunning<\/td>Dunning Definition this run evaluates against<\/td><\/tr>
      Dunning Level<\/td>Friendly Reminder<\/td>Specific escalation level being processed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 2: Execute Create Dunning Run<\/strong><\/h3>\n\n\n\n

      Running the process is what actually scans invoices and payments against the configured rules; the header alone has no effect until executed.<\/p>\n\n\n\n

      Click Create Dunning Run, enter the process parameters, then click OK. Sales Representative and Currency are mandatory and stop the process if missing.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/td>CDC<\/td>Filters invoices to this organization<\/td><\/tr>
      Include Disputed<\/td>No<\/td>Excludes disputed invoices from this run<\/td><\/tr>
      Only Sales Invoices<\/td>No<\/td>Allows both AR and AP documents to qualify<\/td><\/tr>
      Default Sales Representative<\/td>Aravind Kumar<\/td>Required parameter; process stops with No SalesRep if blank<\/td><\/tr>
      Dunning Currency<\/td>USD<\/td>Required parameter; process stops with No Currency if blank<\/td><\/tr>
      Include All Currencies<\/td>No<\/td>Restricts the run to the selected Dunning Currency<\/td><\/tr>
      Business Partner<\/td>NextGen ERP Consulting LLC<\/td>Optional filter to run for one business partner only<\/td><\/tr>
      Note: <\/strong>Before creating new records, the process deletes any existing Dunning Run Entries for this run, preventing duplicate processing.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 3: Review the Dunning Run Entry<\/strong><\/h3>\n\n\n\n

      One entry is created per unique Business Partner, Currency, Sales Representative, and Dunning Level combination, giving a quick summary before drilling into individual invoices.<\/p>\n\n\n\n

      Open the Dunning Run and review each generated Dunning Run Entry.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Business Partner<\/td>NextGen ERP Consulting LLC<\/td>Partner this entry summarizes<\/td><\/tr>
      Currency<\/td>USD<\/td>Currency of the grouped invoices<\/td><\/tr>
      Total<\/td>-59,000<\/td>Combined open amount for this entry<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 4: Review the Dunning Run Line<\/strong><\/h3>\n\n\n\n

      Each qualifying invoice or payment becomes its own line, carrying the detail needed to print an accurate reminder.<\/p>\n\n\n\n

      Open a Dunning Run Entry and review its Dunning Run Lines for Invoice, Open Amount, Days Due, and Fee Amount.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Invoice<\/td>1000012<\/td>Invoice this line was generated from<\/td><\/tr>
      Amount<\/td>-59,000<\/td>Original invoice amount; negative because this is an AP invoice<\/td><\/tr>
      Open Amount<\/td>-59,000<\/td>Unpaid balance carried onto the line<\/td><\/tr>
      Days Due<\/td>7<\/td>Days between the Invoice Due Date and the Dunning Date<\/td><\/tr>
      Times Dunned<\/td>0<\/td>Number of previous Dunning Runs that already included this invoice<\/td><\/tr>
      Fee Amount<\/td>0<\/td>Fee added if the Dunning Level charges one<\/td><\/tr>
      Interest<\/td>0<\/td>Interest amount added, if configured<\/td><\/tr>
      Note: <\/strong>AP invoice amounts appear as negative values on the Dunning Run Line; this is standard behavior, not an error.<\/td><\/tr><\/tbody><\/table><\/figure>\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 Dunning Entries created<\/td>No qualifying overdue invoices<\/td>Confirm eligible invoices exist for the selected level and date<\/td><\/tr>
      Invoice not selected<\/td>Invoice is paid or has zero open amount<\/td>Verify the invoice is unpaid with a nonzero open balance<\/td><\/tr>
      Invoice excluded<\/td>Days Due is below the configured threshold<\/td>Wait until the invoice reaches the level’s Days After Due, or enable Show All Due<\/td><\/tr>
      Invoice excluded<\/td>Dunning Grace period is active<\/td>Wait until the Grace Date has passed, or clear the Grace Date<\/td><\/tr>
      Invoice excluded<\/td>A different Dunning Definition is assigned<\/td>Confirm the Business Partner uses the same Dunning Definition as the selected level<\/td><\/tr>
      Invoice excluded<\/td>Currency or Organization mismatch<\/td>Adjust the run filters or verify the invoice’s currency and organization<\/td><\/tr>
      Process error: No SalesRep<\/td>Sales Representative not supplied<\/td>Enter a Default Sales Representative before running the process<\/td><\/tr>
      Process error: No Currency<\/td>Currency not supplied<\/td>Enter a Dunning Currency before running the process<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Review all generated Dunning Run Entries and Lines.<\/li>\n\n\n\n
      • Execute the Print Dunning Letters process to generate customer reminder letters.<\/li>\n\n\n\n
      • Distribute the printed or emailed reminders to customers.<\/li>\n\n\n\n
      • Track payment and escalate to the next Dunning Level as needed.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        The Dunning Run process evaluates outstanding invoices and payments against a configured Dunning Level and builds Dunning Run Entries and […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20662","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20662","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=20662"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20662\/revisions"}],"predecessor-version":[{"id":27856,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20662\/revisions\/27856"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}