PO Unit Cost Not Correct

[Toad75]

I am having a problem with my unit cost in PO. It is pulling a completely random number (to me, at least) and using it for the cost.

We are on average costing. I VI'd a new price file for the line, replacing EVERY possible cost (landed, average, allocated, standard)with the same value, yet I am still getting a different cost. I'm sure this is a calc somewhere in the PO Setup screen, but I've tried changing it from Allocated Cost to non-Allocated Cost, and it still pulls this strange number.

I know that previous to my VI, the price it's using now is most likely the old average cost. My question is twofold: is there a way to tell the PO module to use the standard cost (if we're on average costing), or a specific cost? Second, is there a way to tell where this number is coming from?

Thanks!

 

[BigLouie]

This is detailed in the Help files.

The valuation method of an item affects the order in which each type of cost is used in the Sales Order, Purchase Order, and Inventory Management modules.

In the Purchase Order module, the valuation method of an item determines what cost is used in Automatic Reorder Selection, Auto Generate Orders Selection, Purchase Order Entry, Receipt of Goods Entry, Return of Goods Entry, and Material Requisition Issue Entry. In the Purchase Order Module, the hierarchy begins with vendor prices levels. If vendor price levels do not exist, then the Vendor Last Cost in Inventory is used. If the Vendor Last Cost is zero or no vendor is assigned to the item, then the Last Cost is used. If the Last Cost is zero, then the cost hierarchy specified for each valuation method is followed.

NOTE For standard and average cost items in Purchase Order Entry, Receipt of Goods Entry, Return of Goods Entry (no purchase order specified), the cost hierarchy for each valuation method is followed. In Material Requisition Issue Entry (one-step) and material requisitions entered in Purchase Order Entry, the cost hierarchy for each valuation method is followed.