Product Costs (Window ID-344)

From iDempiere en
Jump to navigation Jump to search

Table of Contents

Window: Product Costs

Description: Maintain Product Costs

Help: Maintain Product Cost Elements

Tab: Select Product

Description: Select the product

Help:

Product Costs - Select Product - 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
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
Description Optional short description of the record A description is limited to 255 characters. M_Product.Description
character varying(255)
String
Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. M_Product.Help
character varying(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.M_Product_Category_ID
numeric(10)
Table Direct
Product Type Type of product The type of product also determines accounting consequences. M_Product.ProductType
character(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) M_Product.UPC
character varying(30)
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. M_Product.SKU
character varying(30)
String
UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure M_Product.C_UOM_ID
numeric(10)
Table Direct
Stocked Organization stocks this product The Stocked check box indicates if this product is stocked by this Organization. M_Product.IsStocked
character(1)
Yes-No
Company Agent Purchase or Company Agent Purchase agent for the document. Any Sales Rep must be a valid internal user. M_Product.SalesRep_ID
numeric(10)
Table

Tab: Product Costs

Description: Maintain Product Costs

Help:

Product Costs - Product Costs - 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_Cost.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_Cost.AD_Org_ID
numeric(10)
Table Direct
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Cost.M_Product_ID
numeric(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_Cost.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar M_Cost.C_AcctSchema_ID
numeric(10)
Table Direct
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_Cost.M_CostType_ID
numeric(10)
Table Direct
Cost Element Product Cost Element M_Cost.M_CostElement_ID
numeric(10)
Table Direct
Description Optional short description of the record A description is limited to 255 characters. M_Cost.Description
character varying(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.

M_Cost.IsActive
character(1)
Yes-No
Current Cost Price The currently used cost price M_Cost.CurrentCostPrice
numeric
Costs+Prices
Current Cost Price Lower Level Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level. Current Price Lower Level is used for get the total costs for lower level the a product manufactured.

The Current Price Lower Level always will be calculated.

You can see the Current Cost Price and Current Cost Price Lower Level with Cost Bill of Material & Formula Detail Report.

The sum the Current Cost Price + Current Cost Price Lower Level is the total cost to a product manufactured.

M_Cost.CurrentCostPriceLL
numeric
Costs+Prices
Future Cost Price M_Cost.FutureCostPrice
numeric
Costs+Prices
Future Cost Price Lower Level M_Cost.FutureCostPriceLL
numeric
Costs+Prices
Percent Percentage The Percent indicates the percentage used. M_Cost.Percent
numeric(10)
Integer
Current Quantity Current Quantity M_Cost.CurrentQty
numeric
Quantity
Cost Frozen Indicated that the Standard Cost is frozen M_Cost.IsCostFrozen
character(1)
Yes-No
Accumulated Amt Total Amount Sum of all amounts M_Cost.CumulatedAmt
numeric
Amount
Accumulated Qty Total Quantity Sum of the quantities M_Cost.CumulatedQty
numeric
Quantity

Tab: Cost Movement

Description: Show movement of cost by transaction

Help:

File:Product Costs - Cost Movement - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar M_CostMovement_v.C_AcctSchema_ID
numeric(10)
Table Direct
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_CostMovement_v.M_CostType_ID
numeric(10)
Table Direct
Cost Element Product Cost Element M_CostMovement_v.M_CostElement_ID
numeric(10)
Table Direct
Cost Detail Cost Detail Information M_CostMovement_v.M_CostDetail_ID
numeric(10)
Table Direct
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_CostMovement_v.M_Product_ID
numeric(10)
Table Direct
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_CostMovement_v.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Quantity Quantity The Quantity indicates the number of a specific product or item for this document. M_CostMovement_v.Qty
numeric
Quantity
Amount Amount Amount M_CostMovement_v.Amt
numeric
Amount
Delta Amount Difference Amount M_CostMovement_v.DeltaAmt
numeric
Amount
Delta Quantity Quantity Difference M_CostMovement_v.DeltaQty
numeric
Quantity
Old Current Quantity Old current quantity before the processing of M_CostDetail M_CostMovement_v.OldQty
numeric
Quantity
Old Current Cost Price Old current cost price before the processing of M_CostDetail M_CostMovement_v.OldCostPrice
numeric
Costs+Prices
Old Accumulated Qty Old accumulated qty before the processing of M_CostDetail M_CostMovement_v.OldCQty
numeric
Quantity
Old Accumulated Amt Old accumulated amt before the processing of M_CostDetail M_CostMovement_v.OldCAmt
numeric
Amount
New Current Quantity New current quantity after processing of M_CostDetail M_CostMovement_v.NewQty
numeric
Quantity
New Cost Price New current cost price after processing of M_CostDetail M_CostMovement_v.NewCostPrice
numeric
Costs+Prices
New Accumulated Qty New Accumulated Qty after processing of M_CostDetail M_CostMovement_v.NewCQty
numeric
Quantity
New Accumulated Amt Accumulated Amt after processing of M_CostDetail M_CostMovement_v.NewCAmt
numeric
Amount
Description Optional short description of the record A description is limited to 255 characters. M_CostMovement_v.Description
character varying(255)
String
Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_CostMovement_v.M_MovementLine_ID
numeric(10)
Table Direct
Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. M_CostMovement_v.C_InvoiceLine_ID
numeric(10)
Table Direct
Phys.Inventory Line Unique line in an Inventory document The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction M_CostMovement_v.M_InventoryLine_ID
numeric(10)
Table Direct
Production Line Document Line representing a production The Production Line indicates the production document line (if applicable) for this transaction M_CostMovement_v.M_ProductionLine_ID
numeric(10)
Table Direct
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. M_CostMovement_v.C_ProjectIssue_ID
numeric(10)
Table Direct
Purchase Order Line Purchase Order Line The Purchase Order Line is a unique identifier for a line in an order. M_CostMovement_v.C_OrderLine_ID
numeric(10)
Table Direct
Receipt Line Line on Receipt document M_CostMovement_v.M_InOutLine_ID
numeric(10)
Table Direct
Match Invoice Match Shipment/Receipt to Invoice M_CostMovement_v.M_MatchInv_ID
numeric(10)
Search

Tab: Cost Details

Description: View Product Cost Details

Help:

Product Costs - Cost Details - 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_CostDetail.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_CostDetail.AD_Org_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_CostDetail.C_AcctSchema_ID
numeric(10)
Table Direct
Cost Element Product Cost Element M_CostDetail.M_CostElement_ID
numeric(10)
Table Direct
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_CostDetail.M_Product_ID
numeric(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_CostDetail.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Quantity Quantity The Quantity indicates the number of a specific product or item for this document. M_CostDetail.Qty
numeric
Quantity
Amount Amount Amount M_CostDetail.Amt
numeric
Amount
Delta Quantity Quantity Difference M_CostDetail.DeltaQty
numeric
Quantity
Delta Amount Difference Amount M_CostDetail.DeltaAmt
numeric
Amount
Description Optional short description of the record A description is limited to 255 characters. M_CostDetail.Description
character varying(255)
String
Created Date this record was created The Created field indicates the date that this record was created. M_CostDetail.Created
timestamp without time zone
Date+Time
Purchase Order Line Purchase Order Line The Purchase Order Line is a unique identifier for a line in an order. M_CostDetail.C_OrderLine_ID
numeric(10)
Search
Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. M_CostDetail.C_InvoiceLine_ID
numeric(10)
Search
Receipt Line Line on Receipt document M_CostDetail.M_InOutLine_ID
numeric(10)
Search
Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_CostDetail.M_MovementLine_ID
numeric(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_CostDetail.M_InventoryLine_ID
numeric(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. M_CostDetail.C_ProjectIssue_ID
numeric(10)
Search
Production Line Document Line representing a production The Production Line indicates the production document line (if applicable) for this transaction M_CostDetail.M_ProductionLine_ID
numeric(10)
Search
Sales Transaction This is a Sales Transaction The Sales Transaction checkbox indicates if this item is a Sales Transaction. M_CostDetail.IsSOTrx
character(1)
Yes-No
Processed The document has been processed The Processed checkbox indicates that a document has been processed. M_CostDetail.Processed
character(1)
Yes-No
Current Cost Price The currently used cost price M_CostDetail.CurrentCostPrice
numeric
Costs+Prices
Current Quantity Current Quantity M_CostDetail.CurrentQty
numeric
Quantity
Accumulated Amt Total Amount Sum of all amounts M_CostDetail.CumulatedAmt
numeric
Amount
Accumulated Qty Total Quantity Sum of the quantities M_CostDetail.CumulatedQty
numeric
Quantity

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.

Product Costs - Cost Queue - 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_CostQueue.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_CostQueue.AD_Org_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_CostQueue.C_AcctSchema_ID
numeric(10)
Table Direct
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_CostQueue.M_CostType_ID
numeric(10)
Table Direct
Cost Element Product Cost Element M_CostQueue.M_CostElement_ID
numeric(10)
Table Direct
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_CostQueue.M_Product_ID
numeric(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_CostQueue.M_AttributeSetInstance_ID
numeric(10)
Product Attribute
Current Cost Price The currently used cost price M_CostQueue.CurrentCostPrice
numeric
Costs+Prices
Current Quantity Current Quantity M_CostQueue.CurrentQty
numeric
Quantity


Contributions / Posts