{"id":19678,"date":"2026-07-06T09:46:31","date_gmt":"2026-07-06T09:46:31","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=19678"},"modified":"2026-08-20T09:43:47","modified_gmt":"2026-08-20T09:43:47","slug":"how-to-configure-invoice-payment-schedule-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-invoice-payment-schedule-in-idempiere\/","title":{"rendered":"How to Configure Invoice Payment Schedule in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Invoice Payment Schedule window in iDempiere records due dates, discount dates, and amounts for each invoice, supporting Payment Rules such as Mixed POS Payment and Immediate terms.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It directly affects receivables aging, discount calculations, and payment allocation accuracy, keeping cash flow reporting reliable across stores and organizations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"526\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Invoice_Payment_Schedule-ProcessFlow.png\" alt=\"TenthPlanet-iDempiere-Sales-Invoice_Payment_Schedule-ProcessFlow\" class=\"wp-image-27909\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Invoice_Payment_Schedule-ProcessFlow.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Invoice_Payment_Schedule-ProcessFlow-300x154.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Invoice_Payment_Schedule-ProcessFlow-768x395.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Active payment schedule lines are used for due date and discount tracking on an invoice.<\/li>\n\n\n\n<li>Each schedule line belongs to one invoice and cannot be reused across invoices.<\/li>\n\n\n\n<li>Due Date and Discount Date are mandatory fields before a line can be validated.<\/li>\n\n\n\n<li>The Validate action confirms a schedule line is correctly configured and ready for use.<\/li>\n\n\n\n<li>The Valid checkbox reflects whether the schedule line has passed the validation check.<\/li>\n\n\n\n<li>Sum of all schedule line amounts should reconcile with the invoice Grand Total.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Review Invoice Header Details<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open the invoice, e.g., Document No 1000001 for ALPHA RETAIL SOLUTIONS. Verify Payment Rule is Mixed POS Payment and Grand Total is 991.20 INR before proceeding.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Business Partner<\/td><td>ALPHA RETAIL SOLUTIONS<\/td><td>Retail partner linked to the invoice<\/td><\/tr><tr><td>Payment Rule<\/td><td>Mixed POS Payment<\/td><td>Determines how payment schedule lines are split<\/td><\/tr><tr><td>Payment Term<\/td><td>Immediate<\/td><td>Default payment terms applied to the invoice<\/td><\/tr><tr><td>Grand Total<\/td><td>991.20<\/td><td>Total invoice amount to reconcile with schedule lines<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"664\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-1-.png\" alt=\"Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-1\" class=\"wp-image-27917\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-1-.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-1--300x195.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-1--768x498.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Open the Payment Schedule Tab<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Scroll to the Payment Schedule tab under the invoice. If no lines exist, the grid shows &#8220;No Records Found,&#8221; meaning a new line must be created.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Create a New Payment Schedule Line<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click the (+) New icon in the Payment Schedule tab. The system auto-fills Tenant, Organization, and Invoice reference, e.g., 1000001_07\/02\/2026_991.20.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"447\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-2-2.png\" alt=\"Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-2\" class=\"wp-image-27916\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-2-2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-2-2-300x131.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/Tenthplanet-iDempiere-Sales-Invoice-Payment-Schedule-2-2-768x335.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Enter Due Date and Discount Date<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enter Due Date, e.g., 20\/02\/2026, and Discount Date, e.g., 12\/02\/2026. Both fields are required (shown in red) before the line can be validated.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Enter Amount Due and Discount Amount<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enter Amount due, e.g., 991.20, and Discount Amount, e.g., 20.00, if an early payment discount applies to this schedule line.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Due Date<\/td><td>20\/02\/2026<\/td><td>Date payment is due for this schedule line<\/td><\/tr><tr><td>Discount Date<\/td><td>12\/02\/2026<\/td><td>Last date a discount applies<\/td><\/tr><tr><td>Amount due<\/td><td>991.20<\/td><td>Payable amount for this schedule line<\/td><\/tr><tr><td>Discount Amount<\/td><td>20.00<\/td><td>Discount value if paid before Discount Date<\/td><\/tr><tr><td>Active<\/td><td>Checked<\/td><td>Marks the schedule line as usable<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Validate the Payment Schedule Line<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click the Validate button. The system checks Due Date, Discount Date, and Amount fields, then enables the Valid checkbox once the data is correct.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 7: Save and Confirm Valid Status<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click Save. Confirm the Valid checkbox is ticked; if not, review Due Date and Amount due before re-validating.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Payment Schedule tab shows No Records Found<\/td><td>No schedule line created yet for the invoice<\/td><td>Click (+) New to add a schedule line manually<\/td><\/tr><tr><td>Valid checkbox stays unchecked<\/td><td>Amount due is 0.00 or dates are invalid<\/td><td>Enter correct Amount due and valid dates, then re-validate<\/td><\/tr><tr><td>Amount due does not match Grand Total<\/td><td>Manual entry error when splitting Payment<\/td><td>Recalculate schedule amounts to match the invoice Grand Total<\/td><\/tr><tr><td>Payment Schedule dropdown is empty<\/td><td>No schedule template linked to Payment Term<\/td><td>Configure schedule templates in the Payment Term window<\/td><\/tr><tr><td>Cannot edit schedule line on completed invoice<\/td><td>Document status restricts changes<\/td><td>Reverse or reactivate the invoice before editing<\/td><\/tr><tr><td>Discount Amount always shows 0.00<\/td><td>No discount percentage defined in Payment Term<\/td><td>Set discount percentage and days in the Payment Term configuration<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure Payment Term<\/li>\n\n\n\n<li>Set up Dunning Letter rules for overdue payment schedules.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Invoice Payment Schedule window in iDempiere records due dates, discount dates, and amounts for each invoice, supporting Payment Rules [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,87],"tags":[],"class_list":["post-19678","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-partner-relations"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19678","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=19678"}],"version-history":[{"count":11,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19678\/revisions"}],"predecessor-version":[{"id":27919,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19678\/revisions\/27919"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=19678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=19678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=19678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}