Adempiere3.4.0/en/ManPageW ProductCosts olh
Contents
Window: Product Costs
Description : Maintain Product Costs
Help : Maintain Product Cost Elements
Tab: Select Product
Description : Select the product
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 |
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 |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
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 |
Product Type | Type of product | The type of product also determines accounting consequences. | ProductType
CHAR(1) List |
UPC/EAN | Bar Code (Universal Product Code or its superset European Article Number) | Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) | UPC
VARCHAR2 String |
SKU | Stock Keeping Unit | The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. | SKU
VARCHAR2 String |
UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID
NUMBER(10) TableDir |
Stocked | Organization stocks this product | The Stocked check box indicates if this product is stocked by this Organization. | IsStocked
CHAR(1) YesNo |
Company Agent | Purchase or Company Agent | Purchase agent for the document. Any Sales Rep must be a valid internal user. | SalesRep_ID
NUMBER(10) Table |
Tab: Product Costs
Description : Maintain Product Costs
Help :
Table Name : M_Cost
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 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
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 |
Cost Type | Type of Cost (e.g. Current, Plan, Future) | You can define multiple cost types. A cost type selected in an Accounting Schema is used for accounting. | M_CostType_ID
NUMBER(10) TableDir |
Cost Element | Product Cost Element | M_CostElement_ID
NUMBER(10) TableDir | |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) Text |
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 |
Current Cost Price | The currently used cost price | CurrentCostPrice
NUMBER CostsPrices | |
Current Quantity | Current Quantity | CurrentQty
NUMBER Quantity | |
Future Cost Price | FutureCostPrice
NUMBER CostsPrices | ||
Percent | Percentage | The Percent indicates the percentage used. | Percent
NUMBER(10) Integer |
Accumulated Amt | Total Amount | Sum of all amounts | CumulatedAmt
NUMBER Amount |
Accumulated Qty | Total Quantity | Sum of the quantities | CumulatedQty
NUMBER Quantity |
Tab: Cost Details
Description : View Product Cost Details
Help :
Table Name : M_CostDetail
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 |
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 |
Cost Element | Product Cost Element | M_CostElement_ID
NUMBER(10) TableDir | |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | Qty
NUMBER Quantity |
Amount | Amount | Amount | Amt
NUMBER Amount |
Delta Quantity | Quantity Difference | DeltaQty
NUMBER Quantity | |
Delta Amount | Difference Amount | DeltaAmt
NUMBER Amount | |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Created | Date this record was created | The Created field indicates the date that this record was created. | Created
DATE DateTime |
Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | C_OrderLine_ID
NUMBER(10) Search |
Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID
NUMBER(10) Search |
Receipt Line | Line on Receipt document | M_InOutLine_ID
NUMBER(10) Search | |
Move Line | Inventory Move document Line | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLine_ID
NUMBER(10) Search |
Phys.Inventory Line | Unique line in an Inventory document | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | M_InventoryLine_ID
NUMBER(10) Search |
Project Issue | Project Issues (Material, Labor) | Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. | C_ProjectIssue_ID
NUMBER(10) Search |
Production Line | Document Line representing a production | The Production Line indicates the production document line (if applicable) for this transaction | M_ProductionLine_ID
NUMBER(10) Search |
Sales Transaction | This is a Sales Transaction | The Sales Transaction checkbox indicates if this item is a Sales Transaction. | IsSOTrx
CHAR(1) YesNo |
Tab: Cost Queue
Description : Cost Queue for Lifo/Fifo
Help : Note thet the cost queue may not be the same as the physical movement cost queue due to differences in costing level and warehouse priority.
Table Name : M_CostQueue
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 |
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 |
Cost Type | Type of Cost (e.g. Current, Plan, Future) | You can define multiple cost types. A cost type selected in an Accounting Schema is used for accounting. | M_CostType_ID
NUMBER(10) TableDir |
Cost Element | Product Cost Element | M_CostElement_ID
NUMBER(10) TableDir | |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
Current Cost Price | The currently used cost price | CurrentCostPrice
NUMBER CostsPrices | |
Current Quantity | Current Quantity | CurrentQty
NUMBER Quantity |
Tab: Costing (old)
Description : Old Product Costing Info
Help :
Table Name : M_Product_Costing
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 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
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 |
Current Cost Price | The currently used cost price | CurrentCostPrice
NUMBER CostsPrices | |
Average Cost | Weighted average costs | Weighted average (actual) costs | CostAverage
NUMBER CostsPrices |
Average Cost Amount Sum | Cumulative average cost amounts (internal) | Current cumulative costs for calculating the average costs | CostAverageCumAmt
NUMBER CostsPrices |
Average Cost Quantity Sum | Cumulative average cost quantities (internal) | Current cumulative quantity for calculating the average costs | CostAverageCumQty
NUMBER Quantity |
Standard Cost | Standard Costs | Standard (plan) costs. | CostStandard
NUMBER CostsPrices |
Future Cost Price | FutureCostPrice
NUMBER CostsPrices | ||
Std PO Cost Amount Sum | Standard Cost Purchase Order Amount Sum (internal) | Current cumulative amount for calculating the standard cost difference based on (planned) purchase order price | CostStandardPOAmt
NUMBER CostsPrices |
Std PO Cost Quantity Sum | Standard Cost Purchase Order Quantity Sum (internal) | Current cumulative quantity for calculating the standard cost difference based on (planned) purchase order price | CostStandardPOQty
NUMBER Quantity |
Std Cost Amount Sum | Standard Cost Invoice Amount Sum (internal) | Current cumulative amount for calculating the standard cost difference based on (actual) invoice price | CostStandardCumAmt
NUMBER CostsPrices |
Std Cost Quantity Sum | Standard Cost Invoice Quantity Sum (internal) | Current cumulative quantity for calculating the standard cost difference based on (actual) invoice price | CostStandardCumQty
NUMBER Quantity |
Last PO Price | Price of the last purchase order for the product | The Last PO Price indicates the last price paid (per the purchase order) for this product. | PriceLastPO
NUMBER CostsPrices |
Last Invoice Price | Price of the last invoice for the product | The Last Invoice Price indicates the last price paid (per the invoice) for this product. | PriceLastInv
NUMBER CostsPrices |
Total Invoice Amount | Cumulative total lifetime invoice amount | The cumulative total lifetime invoice amount is used to calculate the total average price | TotalInvAmt
NUMBER Amount |
Total Invoice Quantity | Cumulative total lifetime invoice quantity | The cumulative total lifetime invoice quantity is used to calculate the total average price | TotalInvQty
NUMBER Quantity |