{"id":20093,"date":"2026-07-31T07:00:43","date_gmt":"2026-07-31T07:00:43","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20093"},"modified":"2026-08-21T08:15:43","modified_gmt":"2026-08-21T08:15:43","slug":"how-to-use-the-order-batch-process-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-the-order-batch-process-in-idempiere\/","title":{"rendered":"How to Use the Order Batch Process in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Order Batch Process window in iDempiere lets staff select many Sales or Purchase Orders using filter criteria and apply one Document Action to all of them at once.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because each order is processed and committed independently, the window keeps order status, delivery, invoicing, and reporting accurate even when part of a batch fails.<\/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-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"377\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch-1024x377.png\" alt=\"\" class=\"wp-image-22383\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch-1024x377.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch-300x110.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch-768x283.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch-1536x566.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-OrderBatch.png 1662w\" 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>Target Document Type and Document Status are mandatory before the process can run.<\/li>\n\n\n\n<li>A valid Document Action must be selected; it must fit the current document lifecycle.<\/li>\n\n\n\n<li>Only orders matching the selected Document Type and Document Status are retrieved.<\/li>\n\n\n\n<li>Business Partner filter restricts the batch to one customer or vendor.<\/li>\n\n\n\n<li>Self-Service filter separates web or kiosk orders from counter or normal orders.<\/li>\n\n\n\n<li>Date Ordered From\/To restricts the batch to orders placed within a specific period.<\/li>\n\n\n\n<li>The process reports the total number of successfully updated and failed orders.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Document Type configured for the order category (e.g., Standard Order).<\/li>\n\n\n\n<li>Sales or Purchase Orders already created and saved in the relevant status.<\/li>\n\n\n\n<li>Business Partner configured, if filtering by a specific customer or vendor.<\/li>\n\n\n\n<li>Document workflow and validation rules configured for the selected Document Action.<\/li>\n\n\n\n<li>User role has process permission for the Sales Order or Purchase Order window.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Menu Path: Quote-to-Invoice (Sales) \u2192 Sales Orders \u2192 Order Batch Process<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-1024x530.png\" alt=\"\" class=\"wp-image-20100\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-1024x530.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-300x155.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-768x398.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-1536x795.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Sales-OrderBatch-Process-2048x1060.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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: Select the Target Document Type<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Order Batch Process. In Target Document Type, select the order type to process, for example Standard Order.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Set the Document Status Filter<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Set Document Status to the current state of the orders you want to process, for example Drafted or Completed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Filter by Business Partner (Optional)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Leave blank to include all partners, or select one customer\/vendor to narrow the batch.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Apply Self-Service Filter (Optional)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Set Self-Service to Yes or No to isolate web\/kiosk orders, or leave blank to include both.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Set Delivered and Invoiced Filters (Optional)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Set Delivered and Invoiced to Yes to include only fully completed lines, or No to catch pending orders.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Set the Date Ordered Range (Optional)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enter a From date, a To date, or both to limit orders to the required period.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 7: Select the Document Action<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Choose the Document Action to apply, for example Complete, and confirm it fits the selected Document Status.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 8: Run the Batch<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Optionally check Run as Job for large batches, then click OK. Review the process log for updated and error counts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Field Reference Table<\/strong><\/h2>\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>Target Document Type<\/td><td>Standard Order<\/td><td>Order category the batch will search<\/td><\/tr><tr><td>Document Status<\/td><td>Completed<\/td><td>Current status orders must be in to qualify<\/td><\/tr><tr><td>Business Partner<\/td><td>ABC Retail Customer<\/td><td>Restricts batch to one customer or vendor<\/td><\/tr><tr><td>Self-Service<\/td><td>Blank<\/td><td>Filters self-service (web\/kiosk) or normal orders<\/td><\/tr><tr><td>Delivered<\/td><td>Yes<\/td><td>Filters by fully delivered order lines<\/td><\/tr><tr><td>Invoiced<\/td><td>Yes<\/td><td>Filters by fully invoiced order lines<\/td><\/tr><tr><td>Date Ordered (From\/To)<\/td><td>07\/01\/2026 \u2013 07\/07\/2026<\/td><td>Restricts batch to a date range<\/td><\/tr><tr><td>Document Action<\/td><td>Complete<\/td><td>Action performed on every selected order<\/td><\/tr><tr><td>Run as Job<\/td><td>Unchecked<\/td><td>Runs the batch in the background for large volumes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Note: <\/strong>For large retail catalogs or period-end runs with many orders, enable Run as Job so the batch executes in the background without tying up the user session.<\/td><\/tr><\/tbody><\/table><\/figure>\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>Document Type Not Found error<\/td><td>Target Document Type left blank<\/td><td>Select a valid Target Document Type before running<\/td><\/tr><tr><td>No orders are processed<\/td><td>Document Status does not match actual order status<\/td><td>Verify the current status of target orders matches the filter<\/td><\/tr><tr><td>Order fails with &#8216;Order has no lines&#8217;<\/td><td>Selected order has no order lines<\/td><td>Add order lines or exclude the order from the batch<\/td><\/tr><tr><td>Expected orders missing from Delivered batch<\/td><td>Delivered filter checks line quantities, not header flag<\/td><td>Confirm every line has QtyDelivered equal to QtyOrdered<\/td><\/tr><tr><td>Document Action fails to apply<\/td><td>Action not valid for current document status<\/td><td>Choose a Document Action that fits the order&#8217;s current status<\/td><\/tr><tr><td>Batch runs slowly on large volumes<\/td><td>Large order set processed in foreground<\/td><td>Enable Run as Job for large batch runs<\/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>Review the Sales Order window to inspect individual orders after the batch run.<\/li>\n\n\n\n<li>Check the Document Type window to confirm workflow and action rules.<\/li>\n\n\n\n<li>Set up Business Partner records if filtering batches by customer or vendor.<\/li>\n\n\n\n<li>Review the Process Log to audit successful and failed order counts.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Order Batch Process window in iDempiere lets staff select many Sales or Purchase Orders using filter criteria and apply [&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,78],"tags":[],"class_list":["post-20093","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-sales"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20093","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=20093"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20093\/revisions"}],"predecessor-version":[{"id":28335,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20093\/revisions\/28335"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}