If we issue a purchase order for an item that does not have a cost, Sage 100 automatically inserts $30.01 as the price. How can we change this value?
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 modules.
The Item Costing Hierarchy begins with (for Purchase Order module only):
Standard Valuation – The standard cost from the Inventory master file is used. If the standard cost is zero, the unit cost defaults to the last cost. If the last cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.
Average Valuation – The warehouse average cost from the Inventory master file is used. If the warehouse average cost is zero, the unit cost defaults to the item average cost. If the item average cost is zero, the unit cost defaults to the last cost. If the last cost is zero, the unit cost defaults to the standard cost.
FIFO/LIFO/Lot/Serial – The VENDOR last cost is used. If there is no vendor last cost, the last cost from the Item Costing file is used. If the last cost is zero, the unit cost defaults to the standard cost. If the standard cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.
Notes:
In the Inventory Module, the hierarchy determines the cost used in Inventory Transaction Entry for all transaction types.
Thank you so much!
*Community Hub is the new name for Sage City