View source | Discuss this page | Page history | Printable version   

Modules: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.

Retrieved from "http://wiki.openbravo.com/wiki/Modules:IDL_Standard_Cost"

This page has been accessed 3,904 times. This page was last modified on 31 December 2012, at 17:21. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.