ManPageW ProductCategory

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



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.

Table Name  : M_Product_Category

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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

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

Value

NVARCHAR2(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. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(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.

IsActive

CHAR(1)

YesNo

Parent Product Category M_Product_Category_Parent_ID

NUMBER(10)

Table

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). MMPolicy

CHAR(1)

List

Default Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault

CHAR(1)

YesNo

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

CHAR(1)

YesNo

Planned Margin % Project's planned margin as a percentage The Planned Margin Percentage indicates the anticipated margin percentage for this project or project line PlannedMargin

NUMBER

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

NUMBER(10)

TableDir

Print Color Color used for printing and display Colors used for printing and display AD_PrintColor_ID

NUMBER(10)

TableDir


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.

Table Name  : M_Product_Category_Acct

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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

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_ID

NUMBER(10)

TableDir

Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID

NUMBER(10)

TableDir

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.

IsActive

CHAR(1)

YesNo

Costing Method Indicates how Costs will be calculated The Costing Method indicates how costs will be calculated (Standard, Average, Lifo, FoFo). 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). CostingMethod

CHAR(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. CostingLevel

CHAR(1)

List

Product Asset Account for Product Asset (Inventory) The Product Asset Account indicates the account used for valuing this a product in inventory. P_Asset_Acct

NUMBER(10)

Account

Product Expense Account for Product Expense The Product Expense Account indicates the account used to record expenses associated with this product. P_Expense_Acct

NUMBER(10)

Account

Cost Adjustment Product Cost Adjustment Account Account used for posting product cost adjustments (e.g. landed costs) P_CostAdjustment_Acct

NUMBER(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 differentate 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. P_InventoryClearing_Acct

NUMBER(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. P_COGS_Acct

NUMBER(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. P_PurchasePriceVariance_Acct

NUMBER(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. P_InvoicePriceVariance_Acct

NUMBER(10)

Account

Trade Discount Received Trade Discount Receivable Account The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices P_TradeDiscountRec_Acct

NUMBER(10)

Account

Trade Discount Granted Trade Discount Granted Account The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices P_TradeDiscountGrant_Acct

NUMBER(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. P_Revenue_Acct

NUMBER(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. Processing

CHAR(1)

Button


Tab: Assigned Products

Description : Products assigned to Product Category

Help :

Table Name  : M_Product

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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

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_ID

NUMBER(10)

TableDir

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

Value

NVARCHAR2(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. Name

NVARCHAR2(510)

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.

IsActive

CHAR(1)

YesNo

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

CHAR(1)

YesNo

Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. Discontinued

CHAR(1)

YesNo

Product Type Type of product The type of product also determines accounting consequences. ProductType

CHAR(1)

List

Expense Type Expense report type S_ExpenseType_ID

NUMBER(10)

TableDir

Resource Resource S_Resource_ID

NUMBER(10)

TableDir

Featured in Web Store If selected, the product is displayed in the inital or any empy search In the display of products in the Web Store, the product is displayed in the inital view or if no search criteria are entered. To be displayed, the product must be in the price list used. IsWebStoreFeatured

CHAR(1)

YesNo

Contributions

Personal tools