CloudERP IDL Standard Cost
Introduction
Standard cost of products is used for budgeting and planning, product pricing and inventory valuation.
Input file definition
| Field name | Type | Nullable | Description | Accepted values | Comment |
|---|---|---|---|---|---|
| Organization | String(40) | No | Indicates the organization to be used when processing documents. | Organization search key | |
| Product | String(40) | No | Identifies an item which is either purchased or sold in this organization. | Product Search Key | The product must exist in the database. |
| CostType | String(32) | No | Different types of cost | {'Average', 'Standard','Legacy Standard', 'Legacy Average'} | Release MP13 and not migrated to new costing engine uses 'Legacy Standard', 'Legacy Average' otherwise uses 'Standard', 'Average' |
| Cost | Number | No | A charge related to conducting business. | ||
| StartingDate | Date | No | A parameter stating the starting time range related to a specified request. | ||
| Ending ate | Date | No | A parameter stating the ending time range related for a specified request, query, etc. | ||
| Quantity | Number | Yes | The number of a certain item stored in the warehouse in the related transaction. | ||
| TotalMovementQuantity | Number | Yes | The quantity on stock before the related transaction. | ||
| Price | Number | Yes | The cost of the newly stored Quantity. | ||
| Warehouse | String(40) | Yes | The warehouse where the product is hold. | The warehouse must exist in the database.
Important!!!: new column added in IDL version 3.0.26 Version >= 3.0.28: from 3.0MP13 Warehouse is taken into account in the new costing calculation engine. | |
| Currency | String(3) | Yes | The currency of the cost. | The currency must exist in the database. If the value is null, the currency of the legal entity is taken, if the legal entity does not have a defined currency, it is taken from the client.
Important!!!: new column added in IDL version 3.0.26 Version >= 3.0.28: from 3.0MP13 Warehouse is taken into account in the new costing calculation engine. |
* This fields can be NULL if they have a default value associated.
Default Value definition
| Field name | Type | Accepted values | Examples |
|---|---|---|---|
| Organization | String(40) | [search_key] column from [AD_Org] table | |
| CostType | String(32) | [cost type] column from [m_product] table | Previous MP13 release: AV (Average) / ST (Standard) , MP13 or later release: AVA (Average) / STA (Standard) /AV (Legacy Average) / ST (Legacy Standard)
|
| StartingDate | Date | yyyy-MM-dd format. | |
| EndingDate | Date | yyyy-MM-dd format. |