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.
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.