{"id":18879,"date":"2026-06-10T10:36:07","date_gmt":"2026-06-10T10:36:07","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18879"},"modified":"2026-06-10T10:37:53","modified_gmt":"2026-06-10T10:37:53","slug":"how-to-configure-product-in-idempiere-for-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-product-in-idempiere-for-retail\/","title":{"rendered":"How to Configure Product in iDempiere for Retail"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Product window is the central master data window in iDempiere for defining all products and services used across retail operations. Every purchase order line, sales order, goods receipt, shipment, invoice, and inventory transaction references a product record created in this window.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In retail businesses, the Product window manages the complete product catalogue \u2014 from nutritional supplements and packaged foods to general merchandise. It controls product identification, pricing, inventory tracking, vendor sourcing, bill of materials (BOM) for kits and bundles, replenishment rules, accounting GL assignments, UOM conversions, and transaction history. Accurate product setup is foundational to every operational and financial workflow in iDempiere.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Configuring products in iDempiere, ensure the following master data and system setup is complete:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Initial Tenant (Client) Setup completed \u2014 Tenant name, currency, and base language configured<\/li>\n\n\n\n<li>Accounting Schema and Chart of Accounts set up and activated<\/li>\n\n\n\n<li>Product Category created (e.g., Biscuits \/ FMCG \/ Retail goods)<\/li>\n\n\n\n<li>Tax Category configured with applicable GST, VAT, or exempt rates<\/li>\n\n\n\n<li>Unit of Measure (UOM) records available \u2014 e.g., Each, Box, Pack<\/li>\n\n\n\n<li>Warehouse and Locator records configured for physical storage locations<\/li>\n\n\n\n<li>Business Partner (Vendor) records available for purchasing tab configuration<\/li>\n\n\n\n<li>Price List and Price List Version created to link product pricing<\/li>\n\n\n\n<li>Attribute Set configured if batch\/lot or serial number tracking is needed<\/li>\n\n\n\n<li>Freight Category available if shipping weight-based pricing is used<\/li>\n\n\n\n<li>Logged in with a Role that has Product window read\/write access rights<\/li>\n<\/ul>\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><strong>Product Must Be in a Price List to Appear at POS<\/strong> A product only appears at the POS checkout or on a sales order when it is added to an active Price List Version. The Product window creates the product record \u2014 pricing is assigned separately in the Price List window.<\/li>\n\n\n\n<li><strong>Multiple Price Lists:<\/strong> The system must maintain distinct pricing records across three separate active <strong>Price List<\/strong> profiles (<em>Retail-POS, E-Commerce, and Wholesale B2B<\/em>), automatically switching the active list based on the chosen Customer or Sales Channel.<\/li>\n\n\n\n<li><strong>Tax Category Determines GST\/VAT on Every Transaction<\/strong> The Tax Category field links the product to its applicable tax rate. The system uses this to auto-calculate GST or VAT on every sales and purchase transaction line. If this field is empty, no tax is calculated for that product.<\/li>\n\n\n\n<li>Replenishment suggestions are generated by running the Replenishment process (manually or via a scheduled job) when stock drops below the Minimum Level. These suggestions are then used to create Purchase Orders.<\/li>\n\n\n\n<li><strong>Product Category Assigns Default Accounts Automatically<\/strong> Every product must have a Product Category. This drives the automatic inheritance of default GL accounts (inventory, COGS, revenue) and tax groupings \u2014 so you don&#8217;t need to manually configure accounting on every product.<\/li>\n\n\n\n<li><strong>Item Type<\/strong> &#8211; Inventory-managed retail products should be configured using the Item Product Type. Service Product Type should be used only for non-stock operational or service-based transactions.Product Type should be selected correctly during Product creation because it impacts inventory and accounting behavior.<\/li>\n\n\n\n<li><strong>Classification<\/strong> &#8211; Product Classification values should follow standardized naming conventions to maintain consistent product grouping and reporting. Classification should be used only for business reference or reporting purposes and not as a replacement for Product Category structure.<\/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\">Open the Product window in iDempiere using the following menu path:<\/p>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Menu  \u2192  Material Management and Pricing  \u2192  Material Management Rules  \u2192  Product<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"429\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-1024x429.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-1\" class=\"wp-image-18881\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-1024x429.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-300x126.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-768x322.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-1536x644.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-1-2048x858.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>Alternatively, use the global Search Bar (Alt+G or the magnifying glass icon) and type Product to locate the window directly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step-by-Step Configuration<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Open the Product Window<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Product window opens in list view, displaying all existing product records. To create a new product, click the New Record button in the toolbar.<\/p>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>New Record  ( + )  button in the toolbar  or  Alt+N<\/strong><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Configure the Product Tab<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Product tab is the primary tab. All mandatory fields must be completed here before saving.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"1024\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-752x1024.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-2\" class=\"wp-image-18883\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-752x1024.png 752w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-220x300.png 220w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-768x1046.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-1128x1536.png 1128w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-1503x2048.png 1503w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-2-1-scaled.png 1879w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Complete Field Reference \u2014 Product Tab<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes has-small-font-size\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description \/ Retail Usage<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant<\/td><td>POTS<\/td><td>Auto-populated from your logged-in tenant. Do not change.<\/td><\/tr><tr><td>Organization<\/td><td>*<\/td><td>Set to * (All) for shared products across branches, or select a specific org.<\/td><\/tr><tr><td>Search Key<\/td><td>BRI-GDBC-200<\/td><td>Unique short code for the product \u2014 used in all transaction lookups (e.g., BRI-GDBC).<\/td><\/tr><tr><td>Version No<\/td><td>&#8211;<\/td><td>Optional version tracking for product revisions (e.g., formula changes for supplements).<\/td><\/tr><tr><td>Name<\/td><td>Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Full product name displayed in all transactions, reports, and customer documents.<\/td><\/tr><tr><td>Description<\/td><td>Crunchy butter cookies, 200 g pack \u2014 shelf-stable snack<\/td><td>Short business description of the product \u2014 appears on printed documents.<\/td><\/tr><tr><td>Comment \/ Help<\/td><td>&#8211;<\/td><td>Internal notes and help text for users \u2014 not printed on documents.<\/td><\/tr><tr><td>Document Note<\/td><td>&#8211;<\/td><td>Additional notes printed on purchase\/sales documents for this product.<\/td><\/tr><tr><td>UPC\/EAN<\/td><td>8901063050013<\/td><td>13-digit barcode (EAN) or 12-digit barcode (UPC) for retail POS scanning.<\/td><\/tr><tr><td>SKU<\/td><td>ADS01<\/td><td>Internal Stock Keeping Unit code used in warehouse management.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Checked = product is available in all transactions. Uncheck to deactivate.<\/td><\/tr><tr><td>Summary Level<\/td><td>N<\/td><td>Checked = defines a grouping or category record, not an actual product; cannot be used in sales, purchase, or inventory transactions.<\/td><\/tr><tr><td>Product Category<\/td><td>Biscuits &amp; Cookies<\/td><td>Links to the product category for reporting and accounting defaults.<\/td><\/tr><tr><td>Classification<\/td><td>&#8211;<\/td><td>Used for secondary classification of products (e.g., A, B, C category).<\/td><\/tr><tr><td>Tax Category<\/td><td>GST 18%<\/td><td>Determines the applicable tax rate (GST\/VAT) on this product.<\/td><\/tr><tr><td>Revenue Recognition<\/td><td>&#8211;<\/td><td>For subscription or deferred revenue products \u2014 links recognition schedule.<\/td><\/tr><tr><td>UOM<\/td><td>Each<\/td><td>Base Unit of Measure for this product \u2014 e.g., Each, Box, Kg.<\/td><\/tr><tr><td>Sales Representative<\/td><td>&#8211;<\/td><td>Assigns a default sales rep for this product if applicable.<\/td><\/tr><tr><td>Product Type<\/td><td>Item<\/td><td>Item = physical stocked product. Service = non-stocked service. Expense = expense type. Resource = labour\/machine.<\/td><\/tr><tr><td>Mail Template<\/td><td>&#8211;<\/td><td>Template for automated email notifications related to this product.<\/td><\/tr><tr><td>Weight<\/td><td>0.220<\/td><td>Product weight (used for freight cost calculation and shipping).<\/td><\/tr><tr><td>Volume<\/td><td>0.0008<\/td><td>Product volume (used in warehouse storage planning and shipping).<\/td><\/tr><tr><td>Own Box<\/td><td>Y<\/td><td>Check if the product ships in its own dedicated box\/packaging.<\/td><\/tr><tr><td>Customs Tariff Number<\/td><td>&#8211;<\/td><td>HS code or customs tariff reference for import\/export products.<\/td><\/tr><tr><td>Freight Category<\/td><td>&#8211;<\/td><td>Groups product by freight class for carrier rate selection.<\/td><\/tr><tr><td>Drop Shipment<\/td><td>&#8211;<\/td><td>Check if this product is shipped directly from vendor to customer.<\/td><\/tr><tr><td>Stocked<\/td><td>Y<\/td><td>Must be checked for products tracked in inventory (on-hand qty managed).<\/td><\/tr><tr><td>Manufactured<\/td><td>&#8211;<\/td><td>Check if this product is manufactured internally (Manufacturing module).<\/td><\/tr><tr><td>Phantom<\/td><td>&#8211;<\/td><td>For BOM products: phantom BOMs are exploded in orders but not stocked.<\/td><\/tr><tr><td>Kanban Controlled<\/td><td>&#8211;<\/td><td>For Kanban-based replenishment workflows (Manufacturing).<\/td><\/tr><tr><td>Part Type<\/td><td>&#8211;<\/td><td>Used in manufacturing: Part, Planning, Phantom, Reference, Variant.<\/td><\/tr><tr><td>Locator<\/td><td>&#8211;<\/td><td>Default storage locator for this product when receiving into warehouse.<\/td><\/tr><tr><td>Shelf Width \/ Height \/ Depth<\/td><td>&#8211;<\/td><td>Physical shelf dimensions for planogram\/space planning in retail.<\/td><\/tr><tr><td>Units Per Pallet<\/td><td>&#8211;<\/td><td>Number of units in a standard pallet \u2014 used for logistics planning.<\/td><\/tr><tr><td>Bill of Materials<\/td><td>&#8211;<\/td><td>Check if this product is a BOM\/kit product assembled from components.<\/td><\/tr><tr><td>Verified<\/td><td>&#8211;<\/td><td>System flag \u2014 set after BOM structure is verified. Do not manually change.<\/td><\/tr><tr><td>Verify BOM Structure<\/td><td>&#8211;<\/td><td>Click button to validate BOM component structure.<\/td><\/tr><tr><td>Auto Produce<\/td><td>&#8211;<\/td><td>Automatically trigger production when sales order is created.<\/td><\/tr><tr><td>Calculate BOM price if Zero<\/td><td>&#8211;<\/td><td>Dynamically calculates BOM product price from component prices if price is 0.<\/td><\/tr><tr><td>Print detail records on Invoice<\/td><td>&#8211;<\/td><td>Check to print BOM component lines on customer invoices.<\/td><\/tr><tr><td>Print detail on Pick List<\/td><td>&#8211;<\/td><td>Check to print BOM component lines on warehouse pick lists.<\/td><\/tr><tr><td>Purchased<\/td><td>Y<\/td><td>Check if this product is procured from external vendors.<\/td><\/tr><tr><td>Sold<\/td><td>Y<\/td><td>Check if this product is sold to customers.<\/td><\/tr><tr><td>Discontinued<\/td><td>&#8211;<\/td><td>Check if the product is being phased out \u2014 blocks new orders.<\/td><\/tr><tr><td>Discontinued At<\/td><td>&#8211;<\/td><td>Date from which the product is discontinued.<\/td><\/tr><tr><td>Expense Type<\/td><td>&#8211;<\/td><td>For Expense product type \u2014 links to expense category.<\/td><\/tr><tr><td>Resource<\/td><td>&#8211;<\/td><td>For Resource product type \u2014 links to a specific resource record.<\/td><\/tr><tr><td>Exclude Auto Delivery<\/td><td>&#8211;<\/td><td>Prevents automatic delivery generation for this product.<\/td><\/tr><tr><td>Image URL<\/td><td>&#8211;<\/td><td>URL to the product image (used in web store or self-service portals).<\/td><\/tr><tr><td>Description URL<\/td><td>&#8211;<\/td><td>URL to the product&#8217;s detailed description page or data sheet.<\/td><\/tr><tr><td>Guarantee Days<\/td><td>&#8211;<\/td><td>Shelf life guarantee period in days (from production\/receipt date).<\/td><\/tr><tr><td>Min Guarantee Days<\/td><td>&#8211;<\/td><td>Minimum remaining shelf life days required when receiving from vendor.<\/td><\/tr><tr><td>Attribute Set<\/td><td>&#8211;<\/td><td>Links the product to an Attribute Set for batch\/lot or serial tracking.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>&#8211;<\/td><td>Specific instance of attribute values (batch no., expiry, serial).<\/td><\/tr><tr><td>Featured in Web Store<\/td><td>&#8211;<\/td><td>Check to feature this product on the iDempiere web store home page.<\/td><\/tr><tr><td>Self-Service<\/td><td>&#8211;<\/td><td>Allow customers to order via the self-service portal.<\/td><\/tr><tr><td>Group1 \/ Group2<\/td><td>&#8211;<\/td><td>Additional free-text grouping fields for custom retail classification.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Save the Product Record<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Save  \u2014  Alt+S  or  click the Save (floppy disk) icon in the toolbar<\/strong><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Product record saved successfully. The product is now available across iDempiere \u2014 in purchase orders, sales orders, price lists, inventory, and financial postings.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: BOM<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The BOM (Bill of Materials) tab is used when a product is defined as a bundle, kit, or case composed of multiple units of another product. In retail, this is commonly used for packaging configurations such as cartons, multi-packs, or promotional bundles.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, a <strong>case product<\/strong> is created for <em>Britannia Good Day Butter Cookies \u2014 Case of 12 x 200g<\/em>, which is composed of 12 individual cookie packs. The BOM tab defines the structure of this case, while the individual items are maintained in the <strong>Components<\/strong> section.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>When to Use<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use for retail packaging such as <strong>cases, cartons, and multi-pack products<\/strong><br>(e.g., 1 Case = 12 \u00d7 Britannia Good Day Butter Cookies 200g packs).<\/li>\n\n\n\n<li>Use when a product is <strong>logically grouped for sales, storage, or distribution<\/strong>, but physically consists of multiple units of another product<\/li>\n\n\n\n<li>Ensure <strong>\u201cBill of Materials\u201d is enabled in the main Product tab<\/strong> before configuring the BOM.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 BOM<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"562\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-1024x562.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-3\" class=\"wp-image-18888\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-1024x562.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-300x165.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-768x422.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-1536x843.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-3-2048x1124.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Field Reference \u2014 BOM Tab<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated. Set Organization to * for shared BOMs.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-CASE12_Britannia Good Day Butter Cookies \u2014 Case of 12 \u00d7 200g<\/td><td>Parent product this BOM belongs to \u2014 auto-populated.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>&#8211;<\/td><td>Optional \u2014 links BOM to a specific product attribute variant.<\/td><\/tr><tr><td>Search Key<\/td><td>BRI-GDBC-CASE12<\/td><td>Unique code for this BOM version (e.g., BRI-GDBC-CASE12).<\/td><\/tr><tr><td>Name<\/td><td>Britannia Good Day Butter Cookies \u2014 Case of 12 \u00d7 200g<\/td><td>Descriptive BOM name shown in production and kit assembly workflows.<\/td><\/tr><tr><td>Description<\/td><td>&#8211;<\/td><td>Business description of the BOM purpose.<\/td><\/tr><tr><td>Comment \/ Help<\/td><td>&#8211;<\/td><td>Internal notes about the BOM configuration.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Check to enable this BOM for use in production\/kit assembly.<\/td><\/tr><tr><td>Revision<\/td><td>&#8211;<\/td><td>Version or revision label for the BOM (e.g., Rev A, V2).<\/td><\/tr><tr><td>BOM Type<\/td><td>Current Active<\/td><td>Current (active BOM), Alternative, Make-to-Order, Repair.<\/td><\/tr><tr><td>BOM Use<\/td><td>Master<\/td><td>Manufacturing, Engineering, Master, Quality, or Planning.<\/td><\/tr><tr><td>Copy BOM Lines From<\/td><td>&#8211;<\/td><td>Click to copy component lines from another existing BOM.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Components (BOM Component Lines)<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Components tab is a child tab of the BOM tab and is used to define the individual component products that make up the final Bill of Materials (BOM). Each record in this tab represents one component and its required quantity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, for the product Britannia Good Day Butter Cookies \u2014 Case of 12 \u00d7 200g, the Components tab will include the base product Britannia Good Day Butter Cookies \u2014 200g pack as a component with a quantity of 12. This means that one case product is composed of 12 individual cookie packs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Points<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Each row represents a <strong>component product<\/strong> used in the BOM.<\/li>\n\n\n\n<li>The <strong>Quantity<\/strong> field defines how many units of the component are required.<\/li>\n\n\n\n<li>The component product should already be created in the Product window.<\/li>\n\n\n\n<li>Ensure consistency between <strong>UOM (Each)<\/strong> of the component and the defined BOM quantity.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Example<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BOM Product: Case of 12 \u00d7 200g Cookies<\/li>\n\n\n\n<li>Component:\n<ul class=\"wp-block-list\">\n<li>Product: Britannia Good Day Butter Cookies \u2014 200g<\/li>\n\n\n\n<li>Quantity: 12<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 BOM \u2192 Components<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"507\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-1024x507.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-4\" class=\"wp-image-18890\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-1024x507.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-300x148.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-768x380.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-1536x760.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-4-2048x1014.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Field Reference \u2014 Components Tab<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Line No<\/td><td>10<\/td><td>Sequence number for ordering components (e.g., 10, 20, 30).<\/td><\/tr><tr><td>BOM &amp; Formula<\/td><td><strong>BRI-GDBC-CASE12_Britannia Good Day Butter Cookies \u2014 Case of 12 \u00d7 200g<\/strong><\/td><td>Parent BOM record this component belongs to.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Component product \u2014 select from the product master.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>&#8211;<\/td><td>Specific batch\/lot of the component if attribute tracking is active.<\/td><\/tr><tr><td>Component Type<\/td><td>Component<\/td><td>Component (standard), Variant, Option, Phantom, Co Product, Scrap.<\/td><\/tr><tr><td>Description<\/td><td>&#8211;<\/td><td>Description of the component&#8217;s role in the assembly.<\/td><\/tr><tr><td>Comment \/ Help<\/td><td>&#8211;<\/td><td>Internal notes for the component line.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Check to include this component in BOM calculations.<\/td><\/tr><tr><td>Quantity<\/td><td>12<\/td><td>Quantity of the component required per 1 unit of the parent product.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Replenish<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Replenish tab is used to define stock replenishment rules for a product at each warehouse. It helps ensure that inventory levels are maintained within defined limits by generating replenishment suggestions when stock falls below a specified threshold.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, for the product <em>Britannia Good Day Butter Cookies \u2014 200g pack<\/em>, you can configure minimum and maximum stock levels for each store or warehouse. When the available quantity drops below the defined <strong>Minimum Level<\/strong>, the system can generate a replenishment document to restore stock up to the <strong>Maximum Level<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Replenish<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-1024x535.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-5\" class=\"wp-image-18891\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-1024x535.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-300x157.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-768x401.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-1536x802.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-5-2048x1070.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Replenish Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated from context.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Product for which the replenishment rule applies \u2014 auto-populated.<\/td><\/tr><tr><td>Warehouse<\/td><td>Chennai Selling Floor<\/td><td>The warehouse location this replenishment rule applies to.<\/td><\/tr><tr><td>Locator<\/td><td>Selling Locator<\/td><td>Optional \u2014 specific bin\/locator within the warehouse for replenishment.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Enable this replenishment rule.<\/td><\/tr><tr><td>Replenish Type<\/td><td>Reorder below Minimum Level<\/td><td>Do Not Replenish \/ Reorder below Minimum Qty \/ Maintain Maximum Qty. Also supports Custom class.<\/td><\/tr><tr><td>Minimum Level<\/td><td>10<\/td><td>On-hand quantity threshold that triggers replenishment.<\/td><\/tr><tr><td>Maximum Level<\/td><td>50<\/td><td>Target quantity to replenish to when triggered.<\/td><\/tr><tr><td>Source Warehouse<\/td><td>CDC Godown<\/td><td>For warehouse-to-warehouse transfers: source warehouse for stock movement.<\/td><\/tr><tr><td>Qty Batch Size<\/td><td>12<\/td><td>Order quantity will be rounded to a multiple of this value (e.g., 12 = order in case packs).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Purchasing<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Purchasing tab defines vendor-specific pricing, lead times, and ordering rules for this product. Each row represents a relationship between this product and one vendor (Business Partner), such as Britannia Distributor. Multiple vendors can be added\u2014mark one as Current Vendor for default PO (Purchase Order) creation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Purchasing<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"732\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-1024x732.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-6\" class=\"wp-image-18893\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-1024x732.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-300x214.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-768x549.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-1536x1098.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-6-2048x1463.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Purchasing Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated from context.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Auto-populated \u2014 the product this purchasing record belongs to.<\/td><\/tr><tr><td>Business Partner<\/td><td>Britannia Distributor \u2014 Chennai<\/td><td>The vendor\/supplier Business Partner record.<\/td><\/tr><tr><td>Quality Rating<\/td><td>95<\/td><td>Vendor quality score for this product (informational, 0\u2013100).<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Enable this vendor-product purchasing record.<\/td><\/tr><tr><td>Current Vendor<\/td><td>Y<\/td><td>Check to designate this vendor as the default for PO generation.<\/td><\/tr><tr><td>UPC\/EAN<\/td><td>&#8211;<\/td><td>Vendor&#8217;s own barcode for this product (may differ from retail barcode).<\/td><\/tr><tr><td>Currency<\/td><td>INR<\/td><td>Currency used for pricing with this vendor.<\/td><\/tr><tr><td>List Price<\/td><td>66.00<\/td><td>Vendor&#8217;s catalogue price for this product.<\/td><\/tr><tr><td>Price Effective<\/td><td>01\/01\/2026<\/td><td>Date from which the PO price is valid.<\/td><\/tr><tr><td>PO Price<\/td><td>45.00<\/td><td>Negotiated purchase order price (used on POs by default).<\/td><\/tr><tr><td>Royalty Amount<\/td><td>0<\/td><td>Royalty or licensing fee component of the purchase price.<\/td><\/tr><tr><td>Last PO Price<\/td><td>0<\/td><td>Auto-populated from the most recent completed purchase order.<\/td><\/tr><tr><td>Last Invoice Price<\/td><td>0<\/td><td>Auto-populated from the most recent vendor invoice received.<\/td><\/tr><tr><td>UOM<\/td><td>CASE<\/td><td>Unit of measure for purchasing (may differ from sales UOM \u2014 a UOM conversion is required).<\/td><\/tr><tr><td>Minimum Order Qty<\/td><td>12<\/td><td>Minimum quantity the vendor accepts per order.<\/td><\/tr><tr><td>Order Pack Qty<\/td><td>12<\/td><td>Vendor&#8217;s standard pack\/case quantity (orders rounded to this multiple).<\/td><\/tr><tr><td>Promised Delivery Time<\/td><td>7<\/td><td>Lead time in days from PO to expected goods receipt.<\/td><\/tr><tr><td>Actual Delivery Time<\/td><td>0<\/td><td>Auto-updated from historical delivery performance data.<\/td><\/tr><tr><td>Cost per Order<\/td><td>500<\/td><td>Fixed cost per purchase order (e.g., delivery\/handling charges).<\/td><\/tr><tr><td>Partner Product Key<\/td><td>Britannia Distributor \u2014 Chennai<\/td><td>Vendor&#8217;s own product code\/SKU for cross-referencing on POs.<\/td><\/tr><tr><td>Partner Category<\/td><td>BRI-GDBC-200<\/td><td>Vendor&#8217;s own category classification for this product.<\/td><\/tr><tr><td>Manufacturer<\/td><td>&#8211;<\/td><td>Manufacturer name if the vendor is a distributor, not the manufacturer.<\/td><\/tr><tr><td>Discontinued<\/td><td>&#8211;<\/td><td>Check if this vendor has discontinued supply of this product.<\/td><\/tr><tr><td>Discontinued At<\/td><td>&#8211;<\/td><td>Date from which the vendor discontinued this product.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Business Partner<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Business Partner tab stores product-specific information tied to each business partner (vendor or customer). Unlike the Purchasing tab (which strictly handles purchase order pricing), this tab manages additional reference, tracking, and compliance data per business partner relationship.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Business Partner<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"549\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-1024x549.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-7\" class=\"wp-image-18898\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-1024x549.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-300x161.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-768x412.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-1536x824.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-7-2048x1098.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Business Partner Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Auto-populated \u2014 the product this record belongs to.<\/td><\/tr><tr><td>Business Partner<\/td><td>Britannia Distributor \u2014 Chennai<\/td><td>The business partner (vendor or customer) for this product reference.<\/td><\/tr><tr><td>Description<\/td><td>&#8211;<\/td><td>Description of the relationship or special notes for this partner-product record.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Enable this business partner product record.<\/td><\/tr><tr><td>Partner Product Key<\/td><td>BRI-GDBC-200<\/td><td>The business partner&#8217;s own product code or SKU reference.<\/td><\/tr><tr><td>Partner Category<\/td><td>Biscuits &amp; Cookies<\/td><td>Business partner&#8217;s internal product category for this item.<\/td><\/tr><tr><td>Manufacturer<\/td><td>&#8211;<\/td><td>The product manufacturer \u2014 relevant when the BP is a distributor.<\/td><\/tr><tr><td>Quality Rating<\/td><td>95<\/td><td>Quality score assigned to this partner for this product.<\/td><\/tr><tr><td>Min Shelf Life %<\/td><td>0%<\/td><td>Minimum acceptable remaining shelf life as a percentage of total guarantee days.<\/td><\/tr><tr><td>Min Shelf Life Days<\/td><td>0<\/td><td>Minimum number of remaining shelf life days required when receiving this product.<\/td><\/tr><tr><td>Is Manufacturer<\/td><td>N<\/td><td>Check if this business partner is the actual manufacturer of the product.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Price<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Price tab provides a read-only view of all price list versions in which the product is included. It displays key pricing details such as <strong>List Price<\/strong>, <strong>Standard Price<\/strong>, and <strong>Limit Price<\/strong> for each price list version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Price<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"532\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-1024x532.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-8\" class=\"wp-image-18899\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-1024x532.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-300x156.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-768x399.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-1536x798.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-8-2048x1064.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Price Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated from context.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Auto-populated \u2014 the product these price records belong to.<\/td><\/tr><tr><td>Price List Version<\/td><td>Wholesale Sales Price List &#8211; 2026<\/td><td>The price list version this price record belongs to.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Indicates if this price record is currently active.<\/td><\/tr><tr><td>List Price<\/td><td>60<\/td><td>The published retail\/catalogue price (shown on quotes and invoices).<\/td><\/tr><tr><td>Standard Price<\/td><td>46<\/td><td>The standard purchase\/ selling price used for inventory valuation.<\/td><\/tr><tr><td>Limit Price<\/td><td>42<\/td><td>The minimum selling price \u2014 iDempiere will warn if selling below this price.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Accounting<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Accounting tab is one of the most critical tabs for financial accuracy in retail. It assigns General Ledger (GL) account codes for all automated financial entries involving this product\u2014including point-of-sale (POS) revenue, cost of goods sold (COGS), real-time inventory adjustments, and stock valuation. These specific account mappings override your general Product Category defaults for this high-value item.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Accounting<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"548\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-1024x548.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-9\" class=\"wp-image-18901\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-1024x548.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-300x161.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-768x411.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-1536x822.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-9-2048x1096.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Accounting Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>GL Account Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Accounting Schema<\/td><td>The Chart of Accounts \/ Accounting Schema these GL codes apply to.<\/td><\/tr><tr><td>Active<\/td><td>Enable this accounting configuration.<\/td><\/tr><tr><td>Product Asset<\/td><td>Inventory asset account \u2014 records the value of this product in stock (e.g., 1310 Merchandise Inventory).<\/td><\/tr><tr><td>Product Expense<\/td><td>Expense account for internal consumption of this product.<\/td><\/tr><tr><td>Cost Adjustment<\/td><td>Account for inventory cost adjustments (landed costs, variance corrections).<\/td><\/tr><tr><td>Inventory Clearing<\/td><td>Accrual clearing account for goods received but not invoiced.<\/td><\/tr><tr><td>Product COGS<\/td><td>Cost of Goods Sold account \u2014 debit when product is shipped to a customer (e.g., 5100 COGS).<\/td><\/tr><tr><td>Product Revenue<\/td><td>Sales revenue account \u2014 credit when product is invoiced to a customer (e.g., 4100 Sales Revenue).<\/td><\/tr><tr><td>Purchase Price Variance<\/td><td>Variance between standard cost and actual purchase price at goods receipt.<\/td><\/tr><tr><td>Invoice Price Variance<\/td><td>Variance between goods receipt value and vendor invoice value.<\/td><\/tr><tr><td>Trade Discount Received<\/td><td>Account for trade discounts received from vendors on purchase invoices.<\/td><\/tr><tr><td>Trade Discount Granted<\/td><td>Account for trade discounts given to customers on sales invoices.<\/td><\/tr><tr><td>Rate Variance<\/td><td>Currency exchange rate variance for foreign currency purchases.<\/td><\/tr><tr><td>Average Cost Variance<\/td><td>Variance account for average costing method.<\/td><\/tr><tr><td>Landed Cost Clearing<\/td><td>Clearing account for landed cost allocations (freight, duties, insurance).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Transactions<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Transactions tab provides a complete history of all inventory movements for the selected product across warehouses. It records every transaction that affects the product\u2019s stock levels.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, for <em>Britannia Good Day Butter Cookies \u2014 200g pack<\/em>, this tab will display records of goods receipts, sales shipments, inventory transfers, and stock adjustments.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This tab is read-only and is used for tracking and audit purposes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Transactions<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-1024x588.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-10\" class=\"wp-image-18902\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-1024x588.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-300x172.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-768x441.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-1536x883.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-10-2048x1177.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Transactions Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated from context.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated \u2014 the product these transactions belong to.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>The specific batch\/lot or serial number instance for this transaction.<\/td><\/tr><tr><td>Active<\/td><td>Record active flag.<\/td><\/tr><tr><td>Locator<\/td><td>The warehouse bin\/locator where this movement occurred.<\/td><\/tr><tr><td>Movement Quantity<\/td><td>Quantity moved \u2014 positive for receipts, negative for issues\/shipments.<\/td><\/tr><tr><td>Movement Date<\/td><td>Date and time of the inventory movement.<\/td><\/tr><tr><td>Movement Type<\/td><td>Type: Vendor Receipt, Customer Shipment, Inventory Move, Physical Inventory, Production Issue, etc.<\/td><\/tr><tr><td>Shipment\/Receipt Line<\/td><td>Links to the originating sales shipment or purchase receipt document line.<\/td><\/tr><tr><td>Physical Inventory Line<\/td><td>Links to a physical inventory count document if applicable.<\/td><\/tr><tr><td>Move Line<\/td><td>Links to a warehouse movement\/transfer document if applicable.<\/td><\/tr><tr><td>Production Line<\/td><td>Links to a manufacturing production document if applicable.<\/td><\/tr><tr><td>Project Issue<\/td><td>Links to a project issue document if applicable.<\/td><\/tr><tr><td>Manufacturing Cost Collector<\/td><td>Links to manufacturing cost collection if applicable.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Located At<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Located At tab shows the live, real-time stock breakdown of this product across every specific storage spot inside your business. It tells you exactly how many units of product are sitting on display racks, packed in the back stockroom, reserved for pending customer pickups, or currently in transit from your supplier.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Located At<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-1024x392.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-11\" class=\"wp-image-18903\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-1024x392.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-300x115.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-768x294.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-1536x587.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-11-2048x783.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Field Reference \u2014 Located At Tab<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Date Material Policy<\/td><td>Date used for FIFO\/LIFO inventory valuation policy.<\/td><\/tr><tr><td>Locator<\/td><td>The specific warehouse bin\/locator holding this stock.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>Batch\/lot or serial number instance for this stock quantity.<\/td><\/tr><tr><td>Active<\/td><td>Record active flag.<\/td><\/tr><tr><td>On Hand Quantity<\/td><td>Current confirmed stock quantity at this locator.<\/td><\/tr><tr><td>Date Last Inventory Count<\/td><td>Date of the most recent physical inventory count for this product\/locator.<\/td><\/tr><tr><td>Ordered Quantity<\/td><td>Quantity on open (not yet received) purchase orders.<\/td><\/tr><tr><td>Reserved Quantity<\/td><td>Quantity allocated to open sales orders not yet shipped.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:14px\"><code>Tip: The On Hand Quantity shown here is the definitive stock position. Available stock = On Hand Quantity minus Reserved Quantity. Use this tab to quickly verify stock availability before creating a sales order.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: UOM Conversion<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The UOM Conversion tab defines the exact math rules your system uses to convert the product&#8217;s stock numbers between your purchasing units and your storefront sales units. This is essential because you buy these shoes from vendor in bulk commercial boxes but sell them to everyday shoppers as individual pairs at your checkout counter.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code>Product \u2192 UOM Conversion<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-1024x392.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-12\" class=\"wp-image-18904\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-1024x392.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-300x115.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-768x294.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-1536x587.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-12-2048x783.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 UOM Conversion Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Example<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>POTS \/ *<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Product<\/td><td>BRI-GDBC-200_Britannia Good Day Butter Cookies \u2014 200g<\/td><td>Auto-populated \u2014 the product this conversion applies to.<\/td><\/tr><tr><td>Active<\/td><td>Y<\/td><td>Enable this UOM conversion.<\/td><\/tr><tr><td>UOM (From)<\/td><td>EACH<\/td><td>The source unit of measure for the conversion.<\/td><\/tr><tr><td>UoM To<\/td><td>CASE<\/td><td>The target unit of measure for the conversion.<\/td><\/tr><tr><td>Multiply Rate<\/td><td>0.083333333333<\/td><td>Multiply by this rate converts <strong>Each \u2192 Case.<\/strong><\/td><\/tr><tr><td>Divide Rate<\/td><td>12.0<\/td><td>Divide by this rate to convert converts <strong>Case \u2192 Each.<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Costs<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Costs tab displays the current, accumulated, and future cost data for each product under each Accounting Schema and Cost Element. In iDempiere, product costing drives inventory valuation and the COGS accounting entry when a product is shipped. This tab is read-only \u2014 costs are managed through cost run processes and goods receipt postings.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Costs<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"555\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-1024x555.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-13\" class=\"wp-image-18906\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-1024x555.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-300x162.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-768x416.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-1536x832.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-13-2048x1109.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Costs Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>Batch\/lot instance for which this cost applies.<\/td><\/tr><tr><td>Accounting Schema<\/td><td>The chart of accounts these cost values belong to.<\/td><\/tr><tr><td>Cost Type<\/td><td>Matches how your finance team values inventory<\/td><\/tr><tr><td>Cost Element<\/td><td>Standard Cost, Average Cost, or Last Invoice Price cost type.<\/td><\/tr><tr><td>Description<\/td><td>Cost element description.<\/td><\/tr><tr><td>Active<\/td><td>Record active flag.<\/td><\/tr><tr><td>Costing Method<\/td><td>Standard Costing, Average PO Price, Last PO Price, FIFO, LIFO, User-Defined.<\/td><\/tr><tr><td>Current Cost Price<\/td><td>Active cost price used for current inventory valuation and COGS postings.<\/td><\/tr><tr><td>Current Cost Price Lower Level<\/td><td>Cost from sub-assemblies\/components rolled into the current cost.<\/td><\/tr><tr><td>Future Cost Price<\/td><td>Planned\/budgeted cost price for the next period.<\/td><\/tr><tr><td>Future Cost Price Lower Level<\/td><td>Future lower-level component costs.<\/td><\/tr><tr><td>Percent<\/td><td>Cost percentage allocation for overhead or burden elements.<\/td><\/tr><tr><td>Current Quantity<\/td><td>Quantity used to calculate the current average cost.<\/td><\/tr><tr><td>Cost Frozen<\/td><td>Check to prevent further cost updates to this record.<\/td><\/tr><tr><td>Accumulated Amt<\/td><td>Total accumulated cost amount for this product.<\/td><\/tr><tr><td>Accumulated Qty<\/td><td>Total accumulated quantity used for cost calculation.<\/td><\/tr><tr><td>Processed<\/td><td>System flag indicating cost has been processed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Reserved Quantity Log<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Reserved Quantity Log tab acts as a real-time audit trail that tracks every single time a product quantity is reserved for a customer transaction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In retail, a shoe is placed on &#8220;Hold&#8221; or &#8220;Reserved&#8221; status the moment an online order is placed or a customer lays away an item, and it is instantly released from this log when the customer physically walks out of the store with their shoe box.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Product \u2192 Reserved Quantity Log<\/strong><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"466\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-1024x466.png\" alt=\"TenthPlanet-iDempiere-Masters-Product-14\" class=\"wp-image-18907\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-1024x466.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-300x136.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-768x349.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-1536x698.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-14-2048x931.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Reserved Quantity Log Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Warehouse<\/td><td>Warehouse where the reservation quantity change occurred.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated \u2014 the product for which this reservation log entry belongs.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>Batch\/lot instance involved in the reservation.<\/td><\/tr><tr><td>Document Type<\/td><td>The document type that triggered the reservation change (e.g., Sales Order).<\/td><\/tr><tr><td>Document No<\/td><td>The document number that triggered the reservation change.<\/td><\/tr><tr><td>Line<\/td><td>The document line number associated with the reservation change.<\/td><\/tr><tr><td>Table<\/td><td>The database table name of the source document.<\/td><\/tr><tr><td>Record ID<\/td><td>The internal ID of the source document record.<\/td><\/tr><tr><td>Old Current Quantity<\/td><td>Reserved quantity before this change event.<\/td><\/tr><tr><td>Delta Quantity<\/td><td>Change in reserved quantity (positive = new reservation, negative = reservation released).<\/td><\/tr><tr><td>New Current Quantity<\/td><td>Reserved quantity after this change event.<\/td><\/tr><tr><td>Created<\/td><td>Timestamp when this log entry was created.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Note: <\/strong>Reserved Quantity Log is available in iDempiere and is especially useful for diagnosing inventory allocation issues where products appear as reserved but shipments have already been processed.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tab: Ordered Quantity Log<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Ordered Quantity Log tab records every change to the product&#8217;s ordered quantity \u2014 the quantity on open (not yet received) purchase orders. It mirrors the Reserved Quantity Log structure but tracks the purchase-side quantity commitment.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Navigate to:<\/h3>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code>Product \u2192 Ordered Quantity Log<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-1024x472.png\" alt=\"\" class=\"wp-image-18909\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-1024x472.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-300x138.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-768x354.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-1536x708.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Masters-Product-15-2048x944.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Field Reference \u2014 Ordered Quantity Log Tab<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Tenant \/ Organization<\/td><td>Auto-populated.<\/td><\/tr><tr><td>Warehouse<\/td><td>Warehouse associated with the ordered quantity change.<\/td><\/tr><tr><td>Product<\/td><td>Auto-populated \u2014 the product for which this ordered quantity log applies.<\/td><\/tr><tr><td>Attribute Set Instance<\/td><td>Batch\/lot instance if applicable.<\/td><\/tr><tr><td>Document Type<\/td><td>Document type that triggered the ordered quantity change (e.g., Purchase Order).<\/td><\/tr><tr><td>Document No<\/td><td>Purchase order or other document number that created or changed the ordered quantity.<\/td><\/tr><tr><td>Line<\/td><td>Line number on the source document.<\/td><\/tr><tr><td>Table<\/td><td>Database table name of the source document.<\/td><\/tr><tr><td>Record ID<\/td><td>Internal ID of the source document record.<\/td><\/tr><tr><td>Old Current Quantity<\/td><td>Ordered quantity before this change event.<\/td><\/tr><tr><td>Delta Quantity<\/td><td>Change in ordered quantity (positive = new PO line, negative = PO cancelled or receipt processed).<\/td><\/tr><tr><td>New Current Quantity<\/td><td>Ordered quantity after this change event.<\/td><\/tr><tr><td>Created<\/td><td>Timestamp when this log entry was created.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:15px\"><code><strong>Note: <\/strong>Both the Reserved Quantity Log and Ordered Quantity Log provide the audit trail for the Available to Promise (ATP) quantity calculation in iDempiere.<\/code><\/pre>\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 is-style-stripes\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Product not in Sales Order dropdown<\/td><td>Sold = unchecked or Active = unchecked<\/td><td>Enable Sold and Active on main Product tab, then Save<\/td><\/tr><tr><td>Product not in Purchase Order dropdown<\/td><td>Purchased = unchecked<\/td><td>Enable Purchased on main Product tab<\/td><\/tr><tr><td>Inventory not tracked \u2014 zero on-hand after receipt<\/td><td>Stocked = unchecked or no Locator assigned<\/td><td>Enable Stocked and assign a default Locator on the main tab<\/td><\/tr><tr><td>Tax not calculated on order line<\/td><td>Tax Category not assigned or Tax Category has no active Tax record<\/td><td>Assign Tax Category on main tab; verify Tax window has an active rate<\/td><\/tr><tr><td>Price not found in Sales\/Purchase Order<\/td><td>Product not added to Price List Version<\/td><td>Open Price List window, add product to the relevant Price List Version<\/td><\/tr><tr><td>Replenishment not triggering purchase orders<\/td><td>Replenish Type = Do Not Replenish or Min Level not set<\/td><td>Set Replenish Type = Reorder below Minimum Qty and set Min Level<\/td><\/tr><tr><td>BOM product price shows 0.00<\/td><td>Product not in Price List or Calculate BOM price if Zero is unchecked<\/td><td>Add to Price List or enable Calculate BOM price if Zero on main tab<\/td><\/tr><tr><td>Accounting not posting to correct accounts<\/td><td>Accounting tab GL accounts not assigned or wrong schema selected<\/td><td>Open Accounting tab, select correct Accounting Schema, assign all accounts<\/td><\/tr><tr><td>UOM quantity mismatch between PO and inventory<\/td><td>UOM Conversion not configured<\/td><td>Add UOM Conversion row for the purchasing UOM to base UOM<\/td><\/tr><tr><td>Product not found after creation<\/td><td>Browser\/server cache not refreshed<\/td><td>Run Cache Reset (Menu \u2192 System Admin \u2192 General Rules \u2192 Cache Reset) and log in again<\/td><\/tr><tr><td>Mandatory field error on Save<\/td><td>Required fields left blank<\/td><td>Ensure Name, Search Key, UOM, Product Category, Tax Category are all filled<\/td><\/tr><tr><td>Substitute product not suggested in Sales Order<\/td><td>Substitute not configured or not Active<\/td><td>Open Substitute tab, add the substitute product, set Active = Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After completing the Product window configuration in iDempiere, continue with the following setup tasks to build a complete retail operating environment:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Price List \u2014 Add each product to the appropriate Price List Version with List, Standard, and Limit prices<\/li>\n\n\n\n<li>Warehouse and Locator \u2014 Assign or verify default locators for each product and warehouse combination<\/li>\n\n\n\n<li>Vendor Business Partner \u2014 Complete vendor records and verify Purchasing tab data aligns with vendor agreements<\/li>\n\n\n\n<li>Price List Update \u2014 Publish the Price List Version to make pricing active across all sales and purchase transactions<\/li>\n\n\n\n<li>Purchase Order Test \u2014 Create a test Purchase Order to validate product, UOM, pricing, and accounting integration<\/li>\n\n\n\n<li>Sales Order Test \u2014 Create a test Sales Order to validate product availability, tax calculation, and order confirmation<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction The Product window is the central master data window in iDempiere for defining all products and services used across [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[68,67],"tags":[],"class_list":["post-18879","post","type-post","status-publish","format-standard","hentry","category-masters","category-retail"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18879","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=18879"}],"version-history":[{"count":20,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18879\/revisions"}],"predecessor-version":[{"id":18917,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18879\/revisions\/18917"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}