Changing wrong Average Cost 3.01a

Hello, I know this has been asked, but the answers didn’t work for me. On an Item: I receive/invoice in a qty of 2 at $75, receive a qty of 3 and then sell of 1 of them at a cost of $75. My avg cost = $75 My qty on hand is 4 (2+3-1), My invoiced qty is 1 (2-1). My inventory valuation report shows 4 on hand, all at $75/each. I then used the Revaluation Journal to revalue the quantity (which came in at 2) to $100/ea. The entry into the Value Entry journal was for $50 (2 at $25each). The new average cost is $125 - not $100 as it should be. The revaluation journal does not take into account the sales entries. So - with all that said, any ideas on how to change an incorrect average cost of an item? Thanks Chris

Use Item Reclassification Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia

Wow! “ITEM REVALUATION” “Per Item Ledger Entry” Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia