{"id":20122,"date":"2026-07-10T11:18:30","date_gmt":"2026-07-10T11:18:30","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20122"},"modified":"2026-09-25T11:16:08","modified_gmt":"2026-09-25T11:16:08","slug":"how-to-execute-the-product-organization-process-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-execute-the-product-organization-process-in-idempiere\/","title":{"rendered":"How to Execute the Product Organization Process in iDempiere"},"content":{"rendered":"\n

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

Product Organization is a system process in iDempiere that reassigns or verifies the organization ownership of a Product and its dependent records, including BOM & Formula, BOM Lines, Purchase Orders, Accounting Schema data, and Language translations.<\/p>\n\n\n\n

It is used in multi-organization retail deployments where products are first created in a shared or central organization, such as a Central Distribution Center (CDC), before being aligned with individual store or business unit organizations.<\/p>\n\n\n\n

Correct organization assignment ensures accurate reporting, org-level security, and proper document routing across purchasing, costing, and inventory transactions.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempeire-Process-ProductOrganization-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Organization is a mandatory parameter; the process cannot run without it.<\/li>\n\n\n\n
  • Selecting a Product Category updates all products within that category.<\/li>\n\n\n\n
  • Selecting a specific Product limits the process to that product only.<\/li>\n\n\n\n
  • Run as Job executes the process in the background for large catalogs.<\/li>\n\n\n\n
  • The process updates dependent entities: BOM, Substitute, Replenish, Purchasing, BP Info, Costing.<\/li>\n\n\n\n
  • Only active organizations are available for reassignment.<\/li>\n\n\n\n
  • Result grid displays record counts updated per dependent entity table.<\/li>\n\n\n\n
  • Language and Accounting Schema records are re-owned along with the product.<\/li>\n\n\n\n
  • A zero count indicates no matching dependent records exist for that entity.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Organization configured under Client setup.<\/li>\n\n\n\n
    • Product Category configured, if reassigning by category.<\/li>\n\n\n\n
    • Product created and active in the system.<\/li>\n\n\n\n
    • Role has process access rights to Product Organization.<\/li>\n\n\n\n
    • Dependent records (BOM, Purchasing, Costing) exist if reassignment of dependents is expected.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 <\/strong>Material Management and Pricing \u2192 Material Management Rules \u2192 Product Organization<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-ProductOrganization-1\"<\/figure>\n\n\n\n

      Opening the window displays a parameter form requesting Organization, Product Category, Product, and a Run as Job checkbox, along with OK and Cancel buttons.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-ProductOrganization-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Target Organization<\/strong><\/h3>\n\n\n\n
      The process needs a destination organization before it can reassign ownership of any product record.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open the Product Organization window. Select the Organization to which products should be reassigned from the Organization dropdown. This field is mandatory.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/td>CDC<\/td>Target organization for ownership reassignment<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Choose Product Category or Specific Product<\/strong><\/h3>\n\n\n\n
      This step defines the scope of the process: an entire category of products, or a single product.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Select a Product Category to update all products in that category, or select a single Product using the search icon. Leave the other field blank.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product Category<\/td>Beverages<\/td>Category-level reassignment scope<\/td><\/tr>
      Product<\/td>(blank)<\/td>Single-product reassignment scope<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Enable Run as Job for Large Catalogs<\/strong><\/h3>\n\n\n\n
      Bulk category updates on large catalogs can take time; running as a background job prevents session timeouts.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Check Run as Job when reassigning a large product category. The process then runs asynchronously and notifies the user on completion.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Run as Job<\/td>Checked<\/td>Executes the process as a background job<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Execute and Review the Result Grid<\/strong><\/h3>\n\n\n\n
      The result grid confirms which dependent entities were updated and how many records changed.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click OK to execute the process. Review the result grid showing record counts for Product, Accounting Schema, BOM & Formula, BOM Line, PO, and Language.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-ProductOrganization-3\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Count of records<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product<\/td>4<\/td>Number of products reassigned<\/td><\/tr>
      Accounting Schema<\/td>4<\/td>Accounting schema records reassigned<\/td><\/tr>
      BOM & Formula<\/td>1<\/td>BOM header records reassigned<\/td><\/tr>
      BOM Line<\/td>1<\/td>BOM line records reassigned<\/td><\/tr>
      PO<\/td>2<\/td>Purchasing info records reassigned<\/td><\/tr>
      Language<\/td>4<\/td>Language translation records reassigned<\/td><\/tr><\/tbody><\/table><\/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>
      Mandatory field error on Organization<\/td>Organization field left blank<\/td>Select a valid organization before clicking OK<\/td><\/tr>
      All result counts show 0<\/td>Product or category already belongs to selected organization<\/td>Verify current ownership before running the process<\/td><\/tr>
      Process times out on large category<\/td>Run as Job not enabled for bulk update<\/td>Enable Run as Job and rerun the process<\/td><\/tr>
      Access denied when opening process<\/td>Role lacks process access to Product Organization<\/td>Grant access via Role \u2192 Process Access<\/td><\/tr>
      Product Category not listed in dropdown<\/td>Category is inactive or not linked to the client<\/td>Activate the category in the Product Category window<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Configure the Business Partner Organization process for BP ownership alignment.<\/li>\n\n\n\n
      • Review Warehouse Organization assignments for inventory consistency.<\/li>\n\n\n\n
      • Verify Product Category setup for correct category-level grouping.<\/li>\n\n\n\n
      • Check Accounting Schema and Costing records after reassignment.<\/li>\n<\/ul>\n\n\n\n