{"id":15333,"date":"2025-07-17T11:40:24","date_gmt":"2025-07-17T11:40:24","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=15333"},"modified":"2026-09-04T11:05:05","modified_gmt":"2026-09-04T11:05:05","slug":"idempiere-product-master","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/idempiere-product-master\/","title":{"rendered":"iDempiere Product Master"},"content":{"rendered":"\n

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

The Product Master manages all product-related data in iDempiere. It is the foundation for sales, purchases, inventory, costing, and reporting.<\/p>\n\n\n\n

2. Navigation<\/strong><\/h2>\n\n\n\n

Menu \u2192 Material Management and Pricing \u2192 Product<\/p>\n\n\n\n

The Product Master<\/strong> window contains multiple tabs, each offering distinct functionalities.
Let’s explore them in the following order:<\/p>\n\n\n\n

Window Name: Product(AD_Window_ID =140)<\/p>\n\n\n\n

3. Tabs and Field Descriptions<\/strong><\/h2>\n\n\n\n

3.1 Product Tab<\/strong><\/h3>\n\n\n\n

The Product<\/strong> tab is used to define each product and make it available for use in price lists and transactions.<\/p>\n\n\n\n

Note: The Location<\/strong> field indicates the default storage location where the product will be received.<\/p>\n\n\n\n

Tab name: Product(AD_Tab_ID=180)<\/p>\n\n\n\n

Table Name: M_Product(AD_Table_ID=208)<\/p>\n\n\n\n

Field Name<\/strong><\/td>Description<\/strong><\/td>Column Name
DataType
Reference Type
AD_Column_ID<\/strong><\/td><\/tr>
Tenant<\/td>The client or business entity using the system<\/td>* AD_Client_ID
* numeric(10)
* Table Direct
* 1403<\/td><\/tr>
Organization<\/td>The specific organization or store location<\/td>* AD_Org_ID
* numeric(10)
* Table Direct
* 1404<\/td><\/tr>
Search Key<\/td>Unique internal product identifier (often used as SKU)<\/td>* Value
* character varying(510)
* String
* 2011<\/td><\/tr>
Version No<\/td>Version of the product, for variations or revisions<\/td>* VersionNo
* character varying(20)
* String
* 7973<\/td><\/tr>
Name<\/td>The name of the product<\/td>* Name
* character varying(255)
* String
* 1410<\/td><\/tr>
Description<\/td>A short description of the product<\/td>* Description
* character varying(255)
* String
* 1411<\/td><\/tr>
Comment\/Help<\/td>Internal comment or hint<\/td>* Help
* character varying(2000)
* Text
* 3015<\/td><\/tr>
Document Note<\/td>Notes shown on documents like invoices<\/td>* DocumentNote
* character varying(2000)
* Text
* 3014<\/td><\/tr>
UPC\/EAN<\/td>Universal\/EAN barcode number<\/td>* UPC
* character varying(30)
* String
* 2304<\/td><\/tr>
SKU<\/td>Alternate product code (may match Search Key)<\/td>* SKU
* character varying(30)
* String
* 2305<\/td><\/tr>
Active<\/td>If false, product is inactive and excluded from use<\/td>* IsActive
* character(1)
* Yes-No
* 1405<\/td><\/tr>
Summary Level<\/td>If checked, it’s a non-transactional grouping product<\/td>* IsSummary
* character(1)
* Yes-No
* 1413<\/td><\/tr>
Product Category<\/td>Logical grouping for price lists, reports<\/td>* M_Product_Category_ID
* numeric(10)
* Table Direct
* 2012<\/td><\/tr>
Classification<\/td>Additional internal categorization (e.g., brand, range)<\/td>* Classification
* character varying(12)
* String
* 3016<\/td><\/tr>
Tax Category<\/td>Defines which tax rules apply<\/td>* C_TaxCategory_ID
* numeric(10)
* Table Direct
* 2019<\/td><\/tr>
Revenue Recognition<\/td>Determines how revenue is deferred or recognized<\/td>* C_RevenueRecognition_ID
* numeric(10)
* Table Direct
* 3909<\/td><\/tr>
UOM<\/td>Unit of Measure (e.g., pieces, kg, liters)<\/td>* C_UOM_ID
* numeric(10)
* Table Direct
* 1760<\/td><\/tr>
Sales Representative<\/td>Salesperson associated with this product<\/td>* SalesRep_ID
* numeric(10)
* Table
* 3391<\/td><\/tr>
Product Type<\/td>Type: Item, Service, Resource, Expense<\/td>* ProductType
* character(1)
* List
* 7795<\/td><\/tr>
Mail Template<\/td>Default email template used for this product<\/td>* R_MailText_ID
* numeric(10)
* Table Direct
* 7972<\/td><\/tr>
Weight<\/td>Weight of one unit (used in logistics\/shipping)<\/td>* Weight
* numeric
* Amount
* 1767<\/td><\/tr>
Volume<\/td>Volume of one unit<\/td>* Volume
* numeric
* Amount
* 1766<\/td><\/tr>
Own Box<\/td>If checked, product requires its own box for shipping<\/td>* IsOwnBox
* character(1)
* Yes-No
* 201242<\/td><\/tr>
Customs Tariff Number<\/td>Code used in customs declaration<\/td>* CustomsTariffNumber
* character varying(20)
* String
* 214343<\/td><\/tr>
Freight Category<\/td>Used to group freight calculation types<\/td>* M_FreightCategory_ID
* numeric(10)
* Table Direct
* 9329<\/td><\/tr>
Drop Shipment<\/td>Ships directly from vendor to customer<\/td>* IsDropShip
* character(1)
* Yes-No
* 12147<\/td><\/tr>
Stocked<\/td>If checked, product is stocked and inventoried<\/td>* IsStocked
* character(1)
* Yes-No
* 1761<\/td><\/tr>
Manufactured<\/td>Indicates whether the product is manufactured in-house<\/td>* IsManufactured
* character(1)
* Yes-No
* 61997<\/td><\/tr>
Phantom<\/td>Used in BOM \u2013 not stocked, but part of structure<\/td>* IsPhantom
* character(1)
* Yes-No
* 200242<\/td><\/tr>
Kanban controlled<\/td>Enables Kanban-based replenishment<\/td>* IsKanban
* character(1)
* Yes-No
* 61996<\/td><\/tr>
Part Type<\/td>Further classification of part role<\/td>* M_PartType_ID
* numeric(10)
* Table Direct
* 61995<\/td><\/tr>
Locator<\/td>Default bin\/location in warehouse<\/td>* M_Locator_ID
* numeric(10)
* Locator (WH)
* 9420<\/td><\/tr>
Shelf Width<\/td>Width of product on shelf<\/td>* ShelfWidth
* numeric(10)
* Integer
* 2307<\/td><\/tr>
Shelf Height<\/td>Height of product on shelf<\/td>* ShelfHeight
* numeric
* Amount
* 2308<\/td><\/tr>
Shelf Depth<\/td>Depth of product on shelf<\/td>* ShelfDepth
* numeric(10)
* Integer
* 2309<\/td><\/tr>
Units Per Pallet<\/td>Total units that can be stacked per pallet<\/td>* UnitsPerPallet
* numeric
* Costs+Prices
* 2310<\/td><\/tr>
Bill of Materials<\/td>Indicates whether the product has a BOM<\/td>* IsBOM
* character(1)
* Yes-No
* 4708<\/td><\/tr>
Verified<\/td>If true, product details have been verified<\/td>* IsVerified
* character(1)
* Yes-No
* 4711<\/td><\/tr>
Verify BOM Structure<\/td>Process flag to check and validate BOM structure<\/td>* Processing
* character(1)
* Button
* 4712<\/td><\/tr>
Auto Produce<\/td>Product will be auto-generated during production<\/td>* IsAutoProduce
* character(1)
* Yes-No
* 214618<\/td><\/tr>
Print detail records on invoice<\/td>Shows individual BOM items on invoice<\/td>* IsInvoicePrintDetails
* character(1)
* Yes-No
* 4709<\/td><\/tr>
Print detail records on pick list<\/td>Shows individual BOM items on pick list<\/td>* IsPickListPrintDetails
* character(1)
* Yes-No
* 4710<\/td><\/tr>
Purchased<\/td>Indicates if product is procured externally<\/td>* IsPurchased
* character(1)
* Yes-No
* 1762<\/td><\/tr>
Sold<\/td>Indicates if product is available for sale<\/td>* IsSold
* character(1)
* Yes-No
* 1763<\/td><\/tr>
Discontinued<\/td>Marks the product as no longer available<\/td>* Discontinued
* character(1)
* Yes-No
* 2703<\/td><\/tr>
Discontinued At<\/td>Date on which the product was discontinued<\/td>* DiscontinuedAt
* timestamp without time zone
* Date
* 2704<\/td><\/tr>
Expense Type<\/td>Associated expense category<\/td>* S_ExpenseType_ID
* numeric(10)
* Table Direct
* 6771<\/td><\/tr>
Resource<\/td>Linked resource (machine, person, etc.)<\/td>* S_Resource_ID
* numeric(10)
* Table Direct
* 6773<\/td><\/tr>
Exclude Auto Delivery<\/td>Prevents product from being delivered in auto-generated shipments<\/td>* IsExcludeAutoDelivery
* character(1)
* Yes-No
* 14505<\/td><\/tr>
Subscription Type<\/td>Specifies type of subscription billing<\/td>* C_SubscriptionType_ID
* numeric(10)
* Table Direct
* 10919<\/td><\/tr>
Image URL<\/td>Web URL to product image<\/td>* ImageURL
* character varying(120)
* URL
* 7962<\/td><\/tr>
Description URL<\/td>Web URL to more product information<\/td>* DescriptionURL
* character varying(120)
* URL
* 7963<\/td><\/tr>
Guarantee Days<\/td>Days the product is under warranty\/guarantee<\/td>* GuaranteeDays
* numeric(10)
* Integer
* 7974<\/td><\/tr>
Min Guarantee Days<\/td>Minimum required guarantee duration<\/td>* GuaranteeDaysMin
* numeric(10)
* Integer
* 9889<\/td><\/tr>
Attribute Set<\/td>Group of attributes (e.g., color, size, expiry)<\/td>* M_AttributeSet_ID
* numeric(10)
* Table Direct
* 8417<\/td><\/tr>
Attribute Set Instance<\/td>Actual values for attribute set (per lot\/batch)<\/td>* M_AttributeSetInstance_ID
* numeric(10)
* Product Attribute
* 8418<\/td><\/tr>
Copy from product<\/td>Enables copying fields from another product<\/td>* CopyFrom
* character(1)
* Button
* 59231<\/td><\/tr>
Featured in Web Store<\/td>Marks product as a featured item in the online store<\/td>* IsWebStoreFeatured
* character(1)
* Yes-No
* 10260<\/td><\/tr>
Self-Service<\/td>Product is visible in self-service portal<\/td>* IsSelfService
* character(1)
* Yes-No
* 10261<\/td><\/tr>
Group1<\/td>Custom grouping tag 1 (e.g., Season)<\/td>* Group1
* character varying(255)
* String
* 52061<\/td><\/tr>
Group2<\/td>Custom grouping tag 2 (e.g., Gender, Department)<\/td>* Group2
* character varying(255)
* String
* 52062<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

1. Introduction The Product Master manages all product-related data in iDempiere. It is the foundation for sales, purchases, inventory, costing, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96],"tags":[],"class_list":["post-15333","post","type-post","status-publish","format-standard","hentry","category-idempiere-old"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15333","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=15333"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15333\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=15333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=15333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=15333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}