Correct the Last Purchase Price Indicated on Item Records

Symptoms/Details of Business Requirements/Any Additional Information:

Customer has a certain item which has a strange costing history. Back in March they adjusted its quantity to 700, though due to some rounding problems, it actually came out to 700.00000002 On Hand. Then in July and August inventory adjustments were entered to add inventory at enormous costs (one million dollars per item). This in turn could have cause the Last Purchase Price to be incorrect.

Solution/Workaround/Gotcha/Recommendation Details:

Create a new inventory worksheet (or two adjustments, but a worksheet is cleaner) to set the proper desired quantity for this item at the specific location and also the correct last purchase price.