This set of columns provides the organization, item and cost control information. You can type or paste in the relevant values, straight into Excel. No validation is performed until you run the upload program. Alternatively, you can use the Item Cost Header form.
Double-click in one of the Header worksheet cells to open the form, or alternatively click on the ‘Forms’ icon and select ‘Header Form’ on the Item Cost Wizard ribbon.
The ‘Item Cost Header’ form will display:
The form functionality mimics that of the standard transaction forms in Oracle Applications.
Data Entry Fields:
Inventory Org Code
This is the organization code you want to use when loading the header. You can have multiple organization loads on the one worksheet.
Cost Type
This is the Cost Type you want to create or update.
Item
This is the inventory item you are creating or updating the costs for.
Cost Controls - Based On Rollup
Indicate whether costs are based on a roll up of the item’s bill of material and routing. This determines if the structure of the item is exploded during the cost rollup process. Turn this off for the assembly for which you do not want to change the cost. Generally, assemblies (make items) have this control turned on, and buy items have this control turned off. You can freeze the cost of an assembly (for example, for an obsolete item) for the current cost type by turning this off after performing a cost rollup. Future cost rollups do not change the cost for this item.
Cost Controls - Lot Size
Use this to determine the unit cost of sub elements with a basis type of Lot. The Costing Lot Size is separate from the planning lead time Lot Size.
Cost Controls - MFG (Manufacturing) Shrinkage
The cost rollup uses the value you enter here to determine the incremental component requirements due to the assembly shrinkage of the current item.
Stored Cost Information:
To make the Item Cost Wizard easier to use, More4Apps has added to the spreadsheet Cost Information (for information purposes only).
They are not required, validated or loaded by the Wizard. When downloading transactions these fields (excluding ‘Last PO Number’ and ‘Invoice Price’, which are optional) are downloaded as well. If you upload/validate the cost load then the above fields (excluding ‘Last PO Number’ and ‘Invoice Price’) are updated on the spreadsheet.
Note: If you enter your own data into any of these columns it will be over-written when opening the form or validating/creating transaction data.
In the ‘Item Cost Header’ form once you have entered your data, click the ‘Ok’ button to transfer the information back to Excel, click the ‘Cancel’ button if you wish to revert to the old values or click the ‘Cost Details>>’ button to take you to the ‘Item Cost Elements’ form.
Refer to section:
