Product Category (Window ID-144)

From iDempiere en

Table of Contents

Window: Product Category

Description: Maintain Product Categories

Help: The Product Category allows you to define different groups of products. These groups can be used in generating Price Lists, defining margins and for easily assigning different accounting parameters for products.

Tab: Product Category

Description: Define Product Category

Help: The Product Category defines unique groupings of products. Product categories can be used in building price lists.

Product Category - Product Category - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_Category.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product_Category.AD_Org_ID
numeric(10)
Table Direct
Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

M_Product_Category.Value
character varying(40)
String
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. M_Product_Category.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. M_Product_Category.Description
character varying(255)
String
Parent Product Category M_Product_Category.M_Product_Category_Parent_ID
numeric(10)
Table
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

M_Product_Category.IsActive
character(1)
Yes-No
Material Policy Material Movement Policy The Material Movement Policy determines how the stock is flowing (FiFo or LiFo) if a specific Product Instance was not selected. The policy can not contradict the costing method (e.g. FiFo movement policy and LiFo costing method). M_Product_Category.MMPolicy
character(1)
List
Default Default value The Default Checkbox indicates if this record will be used as a default value. M_Product_Category.IsDefault
character(1)
Yes-No
Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. M_Product_Category.IsSelfService
character(1)
Yes-No
Planned Margin % Project's planned margin as a percentage The Planned Margin Percentage indicates the anticipated margin percentage for this project or project line M_Product_Category.PlannedMargin
numeric
Number
Asset Group Group of Assets The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset. M_Product_Category.A_Asset_Group_ID
numeric(10)
Table Direct
Print Color Color used for printing and display Colors used for printing and display M_Product_Category.AD_PrintColor_ID
numeric(10)
Table Direct

Tab: Accounting

Description: Accounting Parameters

Help: The Accounting Tab defines default accounting parameters. Any product that uses a product category can inherit its default accounting parameters. If the Costing method is not defined, the default costing method of the accounting schema is used.

Product Category - Accounting - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_Category_Acct.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product_Category_Acct.AD_Org_ID
numeric(10)
Table Direct
Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_Acct.M_Product_Category_ID
numeric(10)
Table Direct
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar M_Product_Category_Acct.C_AcctSchema_ID
numeric(10)
Table Direct
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

M_Product_Category_Acct.IsActive
character(1)
Yes-No
Costing Method Indicates how Costs will be calculated The Costing Method indicates how costs will be calculated (Standard, Average, Lifo, FiFo). The default costing method is defined on accounting schema level and can be optionally overwritten in the product category. The costing method cannot conflict with the Material Movement Policy (defined on Product Category). M_Product_Category_Acct.CostingMethod
character(1)
List
Costing Level The lowest level to accumulate Costing Information If you want to maintain different costs per organization (warehouse) or per Batch/Lot, you need to make sure that you define the costs for each of the organizations or batch/lot. The Costing Level is defined per Accounting Schema and can be overwritten by Product Category and Accounting Schema. M_Product_Category_Acct.CostingLevel
character(1)
List
Product Asset Account for Product Asset (Inventory) The Product Asset Account indicates the account used for valuing this a product in inventory. M_Product_Category_Acct.P_Asset_Acct
numeric(10)
Account
Product Expense Account for Product Expense The Product Expense Account indicates the account used to record expenses associated with this product. M_Product_Category_Acct.P_Expense_Acct
numeric(10)
Account
Cost Adjustment Product Cost Adjustment Account Account used for posting product cost adjustments (e.g. landed costs) M_Product_Category_Acct.P_CostAdjustment_Acct
numeric(10)
Account
Inventory Clearing Product Inventory Clearing Account Account used for posting matched product (item) expenses (e.g. AP Invoice, Invoice Match). You would use a different account then Product Expense, if you want to differentiate service related costs from item related costs. The balance on the clearing account should be zero and accounts for the timing difference between invoice receipt and matching. M_Product_Category_Acct.P_InventoryClearing_Acct
numeric(10)
Account
Product COGS Account for Cost of Goods Sold The Product COGS Account indicates the account used when recording costs associated with this product. M_Product_Category_Acct.P_COGS_Acct
numeric(10)
Account
Product Revenue Account for Product Revenue (Sales Account) The Product Revenue Account indicates the account used for recording sales revenue for this product. M_Product_Category_Acct.P_Revenue_Acct
numeric(10)
Account
Purchase Price Variance Difference between Standard Cost and Purchase Price (PPV) The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price. M_Product_Category_Acct.P_PurchasePriceVariance_Acct
numeric(10)
Account
Invoice Price Variance Difference between Costs and Invoice Price (IPV) The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price. M_Product_Category_Acct.P_InvoicePriceVariance_Acct
numeric(10)
Account
Trade Discount Received Trade Discount Receivable Account The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices M_Product_Category_Acct.P_TradeDiscountRec_Acct
numeric(10)
Account
Trade Discount Granted Trade Discount Granted Account The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices M_Product_Category_Acct.P_TradeDiscountGrant_Acct
numeric(10)
Account
Rate Variance The Rate Variance account is the account used Manufacturing Order The Rate Variance is used in Standard Costing. It reflects the difference between the Standard Cost Rates and The Cost Rates of Manufacturing Order.

If you change the Standard Rates then this variance is generate.

M_Product_Category_Acct.P_RateVariance_Acct
numeric(10)
Account
Average Cost Variance Average Cost Variance The Average Cost Variance is used in weighted average costing to reflect differences when posting costs for negative inventory. M_Product_Category_Acct.P_AverageCostVariance_Acct
numeric(10)
Account
Landed Cost Clearing Product Landed Cost Clearing Account Account used for posting of estimated and actual landed cost amount. The balance on the clearing account should be zero and accounts for the timing difference between material receipt and landed cost invoice. M_Product_Category_Acct.P_LandedCostClearing_Acct
numeric(10)
Account
Copy Accounts Copy and overwrite Accounts to Products of this category If you copy and overwrite the current default values, you may have to repeat previous updates (e.g. set the revenue account, ...). If no Accounting Schema is selected all Accounting Schemas will be updated / inserted for products of this category. M_Product_Category_Acct.Processing
character(1)
Button

Tab: Assigned Products

Description: Products assigned to Product Category

Help:

File:Product Category - Assigned Products - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product.AD_Org_ID
numeric(10)
Table Direct
Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product.M_Product_Category_ID
numeric(10)
Table Direct
Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

M_Product.Value
character varying(40)
String
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. M_Product.Name
character varying(255)
String
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

M_Product.IsActive
character(1)
Yes-No
Summary Level This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. M_Product.IsSummary
character(1)
Yes-No
Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. M_Product.Discontinued
character(1)
Yes-No
Product Type Type of product The type of product also determines accounting consequences. M_Product.ProductType
character(1)
List
Expense Type Expense report type M_Product.S_ExpenseType_ID
numeric(10)
Table Direct
Resource Resource M_Product.S_Resource_ID
numeric(10)
Table Direct
Featured in Web Store If selected, the product is displayed in the initial or any empty search In the display of products in the Web Store, the product is displayed in the initial view or if no search criteria are entered. To be displayed, the product must be in the price list used. M_Product.IsWebStoreFeatured
character(1)
Yes-No

Tab: Translation

Description:

Help:

File:Product Category - Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_Category_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product_Category_Trl.AD_Org_ID
numeric(10)
Table Direct
Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_Trl.M_Product_Category_ID
numeric(10)
Search
Language Language for this entity The Language identifies the language to use for display and formatting M_Product_Category_Trl.AD_Language
character varying(6)
Table
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

M_Product_Category_Trl.IsActive
character(1)
Yes-No
Translated This column is translated The Translated checkbox indicates if this column is translated. M_Product_Category_Trl.IsTranslated
character(1)
Yes-No
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. M_Product_Category_Trl.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. M_Product_Category_Trl.Description
character varying(255)
String


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.