Product Category (Window ID-144)

⇐ 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.

Fields

Name	Description	Help	Technical Data
Tenant	Tenant for this installation.	A Tenant is a company or a legal entity. You cannot share data between Tenants.	M_Product_Category.AD_Client_ID numeric(10) Table Direct
Organization	Organizational entity within tenant	An organization is a unit of your tenant 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.

Fields

Name	Description	Help	Technical Data
Tenant	Tenant for this installation.	A Tenant is a company or a legal entity. You cannot share data between Tenants.	M_Product_Category_Acct.AD_Client_ID numeric(10) Table Direct
Organization	Organizational entity within tenant	An organization is a unit of your tenant 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:

Fields

Name	Description	Help	Technical Data
Tenant	Tenant for this installation.	A Tenant is a company or a legal entity. You cannot share data between Tenants.	M_Product.AD_Client_ID numeric(10) Table Direct
Organization	Organizational entity within tenant	An organization is a unit of your tenant 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(510) 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:

Fields

Name	Description	Help	Technical Data
Tenant	Tenant for this installation.	A Tenant is a company or a legal entity. You cannot share data between Tenants.	M_Product_Category_Trl.AD_Client_ID numeric(10) Table Direct
Organization	Organizational entity within tenant	An organization is a unit of your tenant 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