{"id":22178,"date":"2026-07-28T09:08:48","date_gmt":"2026-07-28T09:08:48","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=22178"},"modified":"2026-08-20T09:10:32","modified_gmt":"2026-08-20T09:10:32","slug":"how-to-configure-import-confirmations-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-import-confirmations-in-idempiere\/","title":{"rendered":"How to Configure Import Confirmations in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

Import Confirmations is a data import window in iDempiere used to bring shipment and receipt confirmation quantities into the system from an external file.<\/p>\n\n\n\n

It supports warehouse and logistics teams who confirm picked, packed, or received quantities in bulk, instead of updating each Ship\/Receipt Confirmation Line one at a time.<\/p>\n\n\n\n

Once processed, the imported quantities update the matching Confirmation Line, keeping shipment and receipt records accurate for inventory and reporting.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-SystemAdmin-ImportConfirmations-Process<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Import Confirmations only accepts lines linked to an existing Ship\/Receipt Confirmation Line.<\/li>\n\n\n\n
  • Confirmed Quantity plus Scrapped Quantity plus Difference Quantity must equal the Target Quantity.<\/li>\n\n\n\n
  • Records without a Confirmation No are rejected with an error message.<\/li>\n\n\n\n
  • Organization is set from the record if present, otherwise from the process parameter.<\/li>\n\n\n\n
  • Only records marked Imported = N are picked up by the Import Confirmations process.<\/li>\n\n\n\n
  • Successfully processed records are marked Imported and Processed, and are not reprocessed.<\/li>\n\n\n\n
  • Unmatched or invalid confirmation lines are flagged Imported = E with an error description.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Ship\/Receipt Confirmation Line already generated from a Shipment or Receipt.<\/li>\n\n\n\n
    • Import Loader Format created for the I_InOutLineConfirm table.<\/li>\n\n\n\n
    • Tenant and Organization configured for the importing company.<\/li>\n\n\n\n
    • Source file (CSV) prepared with confirmation data in the expected column sequence.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 System Admin \u2192 Data \u2192 Data Import \u2192 Import Confirmations<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-SystemAdmin-ImportConfirmations-1\"<\/figure>\n\n\n\n
      The window opens on the Confirmation Lines tab, listing every import record with its Imported and Processed status, linked Confirmation Line, quantities, and any Import Error Message.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-SystemAdmin-ImportConfirmations-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Create an Import Loader Format for Confirmation Data<\/strong><\/h3>\n\n\n\n
      This tells iDempiere how each column in the source file maps to the confirmation import table, so the file can be read correctly.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open Import Loader Format. Enter a Name and Description, select the I_InOutLineConfirm table, choose the Comma Separated format, and add one Format Field row per column in the file, in order.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Name<\/td>Import Confirmations<\/td>Identifies the format for reuse<\/td><\/tr>
      Table<\/td>I_InOutLineConfirm (Ship\/Receipt Confirmation Import Line)<\/td>Target import table for confirmation data<\/td><\/tr>
      Format<\/td>Comma Separated<\/td>File layout the loader expects<\/td><\/tr>
      Format Field 10<\/td>AD_Org_ID_Organization<\/td>Organization the confirmation belongs to<\/td><\/tr>
      Format Field 20<\/td>M_InOutLineConfirm_ID<\/td>Confirmation Line being updated<\/td><\/tr>
      Format Field 30<\/td>ConfirmationNo<\/td>Confirmation reference number<\/td><\/tr>
      Format Field 40<\/td>ConfirmedQty<\/td>Quantity confirmed as received or shipped<\/td><\/tr>
      Format Field 50<\/td>ScrappedQty<\/td>Quantity scrapped<\/td><\/tr>
      Format Field 60<\/td>DifferenceQty<\/td>Variance quantity<\/td><\/tr>
      Format Field 70<\/td>Description<\/td>Optional note on the confirmation<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Load the Confirmation File Using Import File Loader<\/strong><\/h3>\n\n\n\n
      This moves the confirmation data from the file into the import table, using the format created in Step 1.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open Import File Loader, select the saved Import Format, choose the file encoding, and load the CSV file. Confirm the parsed values on screen match the source row before saving.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Import Format<\/td>Import Confirmations<\/td>Format used to parse the uploaded file<\/td><\/tr>
      Encoding<\/td>UTF-8<\/td>Character set of the source file<\/td><\/tr>
      A – Org ID<\/td>1000001<\/td>Organization reference from the file<\/td><\/tr>
      B – Confirmation Line No<\/td>1000001<\/td>Confirmation Line to update<\/td><\/tr>
      C – Confirmation No<\/td>1000001<\/td>Confirmation number from the source system<\/td><\/tr>
      D – Confirmed Quantity<\/td>2<\/td>Quantity confirmed<\/td><\/tr>
      E – Scrapped Quantity<\/td>0<\/td>Quantity scrapped<\/td><\/tr>
      F – Difference<\/td>0<\/td>Variance quantity<\/td><\/tr>
      G – Description<\/td>IMP-Imported Using Import File Loader<\/td>Note carried into the confirmation line<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Review and Process Records in Import Confirmations<\/strong><\/h3>\n\n\n\n
      This gives a chance to check for errors before the confirmation quantities update live shipment or receipt records.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open Import Confirmations, Confirmation Lines tab. Review each record’s linked Confirmation Line, quantities, and Import Error Message. Correct any failed rows, then run the Import Confirmations process.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Ship\/Receipt Confirmation Line<\/td>10_2_AASH-ATTA-5KG_Aashirvaad Atta \u2013 5kg<\/td>The receipt or shipment line the record updates<\/td><\/tr>
      Confirmation No<\/td>1000001<\/td>Confirmation number carried from the file<\/td><\/tr>
      Confirmed Quantity<\/td>2<\/td>Quantity confirmed<\/td><\/tr>
      Scrapped Quantity<\/td>0<\/td>Quantity scrapped<\/td><\/tr>
      Difference<\/td>0<\/td>Variance between target and confirmed plus scrapped<\/td><\/tr>
      Description<\/td>IMP-Imported Using Import File Loader<\/td>Reference note<\/td><\/tr>
      Imported<\/td>Checked<\/td>Shows the record has been processed by the import<\/td><\/tr>
      Processed<\/td>Checked<\/td>Shows the confirmation update completed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"TenthPlanet-iDempiere-SystemAdmin-ImportConfirmations-3\"<\/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>
      Import Error Message shows Missing Confirmation No<\/td>ConfirmationNo left blank in the source file<\/td>Add a Confirmation No value and reload the file<\/td><\/tr>
      Record flagged as invalid confirmation line<\/td>Confirmation Line number does not exist<\/td>Verify the Line No against the correct Ship\/Receipt Confirmation<\/td><\/tr>
      Quantity mismatch error on process<\/td>Confirmed, Scrapped, and Difference do not equal Target Quantity<\/td>Recalculate quantities so they add up to the Target Quantity<\/td><\/tr>
      Records import into the wrong Organization<\/td>Org ID column left blank or incorrect<\/td>Set the correct Organization in the file or process parameter<\/td><\/tr>
      File does not load correctly<\/td>Wrong file encoding selected<\/td>Re-select UTF-8, or the encoding matching the source file<\/td><\/tr>
      Old records reappear after reimport<\/td>Previously imported rows not cleared<\/td>Enable the Delete Old Imported parameter before rerunning<\/td><\/tr>
      Columns map to the wrong fields<\/td>Format Field sequence does not match file column order<\/td>Align the Sequence numbers in Import Loader Format with the file layout<\/td><\/tr>
      Confirmation stays unprocessed<\/td>Record still marked Imported = N or E<\/td>Resolve the error shown and rerun the Import Confirmations process<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Ship-Receipt Confirm window \u2013 view the confirmation line updated by the import.<\/li>\n\n\n\n
      • Material Receipt or Material Shipment window \u2013 check the quantity impact on the transaction.<\/li>\n\n\n\n
      • Import Loader Format window \u2013 adjust or reuse the mapping for future confirmation files.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction Import Confirmations is a data import window in iDempiere used to bring shipment and receipt confirmation quantities into the […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22178","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22178","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=22178"}],"version-history":[{"count":4,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22178\/revisions"}],"predecessor-version":[{"id":27901,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22178\/revisions\/27901"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}