Window: Product Costs
[Created: 24/04/2005 - Updated: 26/07/2005 ]
Description: Maintain Product Costs
Help: Maintain Product Cost Elements
Tab: Select Product
[Created: 24/04/2005 - Updated: 26/07/2005 ]
Description: Select the product
Help:
Tab Level: 0
Table 10: Select Product - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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 |
| 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_", 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 |
| 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
[Created: 24/04/2005 - Updated: 13/09/2005 ]
Description: Maintain Product Costs
Help:
Tab Level: 1
Table 20: Product Costs - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_cost.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_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
[Created: 08/03/2012 - Updated: 23/07/2013 ]
Description: Show movement of cost by transaction
Help:
Tab Level: 2
Table 30: Cost Movement - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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) Search | |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_costmovement_v.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_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 |
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | m_costmovement_v.DateAcct timestamp without time zone Date |
| Back-Date | m_costmovement_v.IsBackDate character(1) Yes-No | ||
| Back-Date Processed On | The date+time (expressed in decimal format) when the document has been processed | The ProcessedOn Date+Time save the exact moment (nanoseconds precision if allowed by the DB) when a document has been processed. | m_costmovement_v.BackDateProcessedOn timestamp without time zone Date+Time |
| 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) Search |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | m_costmovement_v.C_InvoiceLine_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_costmovement_v.M_InventoryLine_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_costmovement_v.M_ProductionLine_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_costmovement_v.C_ProjectIssue_ID numeric(10) Search |
| 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) Search |
| Receipt Line | Line on Receipt document | m_costmovement_v.M_InOutLine_ID numeric(10) Search | |
| Match Invoice | Match Shipment/Receipt to Invoice | m_costmovement_v.M_MatchInv_ID numeric(10) Search |
Tab: Cost Details
[Created: 26/07/2005 - Updated: 08/03/2012 ]
Description: View Product Cost Details
Help:
Tab Level: 1
Table 40: Cost Details - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_costdetail.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_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 |
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | m_costdetail.DateAcct timestamp without time zone Date |
| Back-Date | m_costdetail.IsBackDate character(1) Yes-No | ||
| 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 |
| Referenced Cost Detail | m_costdetail.Ref_CostDetail_ID numeric(10) ID | ||
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | m_costdetail.Processed character(1) Yes-No |
| Back-Date Processed On | The date+time (expressed in decimal format) when the document has been processed | The ProcessedOn Date+Time save the exact moment (nanoseconds precision if allowed by the DB) when a document has been processed. | m_costdetail.BackDateProcessedOn timestamp without time zone Date+Time |
| 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
[Created: 18/09/2005 - Updated: 08/03/2012 ]
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.
Tab Level: 1
Table 50: Cost Queue - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_costqueue.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_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 |