If you find that the unit price of a Part is incorrect when disbursing the Part to a Work Order or while issuing the Part to an employee or asset, the pricing can be corrected. The correction can be done primarily through the Adjust Cost Per Unit toolkit found in Part History. The usage of the toolkit is dependent on which cost method is assigned to the Part. Listed below are use cases for correcting a Part's unit price for each cost method.
Note: The term "Active" used below means any (Part) History record where Current Quantity is greater than 0.
FIFO (First In First Out): Select the oldest (by date) active History record and run the toolkit. You will specify the correct unit cost in the toolkit dialog. That unit cost will then be applied to the History record. It is important to note that once that History record’s current quantity value goes to 0, the next History record (by date) will have its cost per unit used. If subsequent active History records have incorrect cost per unit values, then those will need to be updated via the toolkit as well.
LIFO (Last In First Out): Select the newest (by date) active History record and run the toolkit. You will specify the correct unit cost in the toolkit dialog. That unit cost will then be applied to the History record. It is important to note that once that History record’s current quantity value goes to 0, the next History record (by date) will have its cost per unit used. If subsequent active History records have incorrect cost per unit values, then those will need to be updated via the toolkit as well.
Average: The toolkit will need to be ran one at a time on each active History record. For each time you run the toolkit, you will specify the correct unit cost in the toolkit dialog. That unit cost will then be applied to the History record. Once all active History records have been updated, the calculated average cost will now be the desired cost per unit value.
Fixed: This cost method pulls the unit cost from the Fixed Unit Cost field found on the Part form. Edit the value in this field to change the unit cost for the Part.