Sage 100

Scenario: Item X uses FIFO costing. There are 20 units on hand at $1.00 each. In PO user enters a PO and receives 100 without an invoice at an incorrect cost of $0.10 each. (They should have been received at $1.10 each.) We now have two FIFO layers: Layer 1: 20 @ $1.00$20 Layer 2: 100 @ $0.10$10 Total 120 units $30 ----- Problem: How can we fix the error? Issues: If the user returns the 100 units in PO, Sage 100 will pull the 20 Layer 1 units and 80 of the Layer 2 units. Creating a PO variance adjustment of $18. We also still have 20 units at the incorrect cost remaining in inventory. We can use an inventory transaction to remove the Layer 2 units, but then the PO remains incorrect in back order status. What is the best way to correct the user's error? Can it be done without using DFDM?

Remove layer 1 with an inventory adjustment (you can select the tier), process a return of goods for layer 2 against the PO, put layer 1 back in stock with an inventory adjustment (can post to the same FIFO tier in step 1), process a receipt of goods at the proper cost against the PO. A few steps in there but that should do it.

Agree with Bernie. Issue everything out Return po. And bring back in

Could you not process an inventory cost layer adjustment through inventory? The difference could be processed against the Purchase Price Variance account to net the adjustment created with the AP invoice was posted with a unit cost of $1.10 versus the cost on the PO Receipt of $.10. In the example provided, you would book $100 (100 units at $1 each) to the second cost layer and correct the inventory valuation and the PO variance at the same time.

I don't suppose anyone has written an enhancement that lets the user select the tier for returning in order to streamline this correction process?