I am using Navision 3.70B. I have created a Purchase Invoice with vendor currency = USD. I have posted with a wrong exchange rate, i.e. 3.328. The correct exchange rate is 3.189.
This purchase invoice consists of 3 items and an item charge. The item A has 39 quantity, Item B has 180 quantity and Item C has 26 quantity. The costing method is Average.
We have sold 20 units from Item B and 26 units for Item C. We have also used 60 units from Item B for production and posted the consumption journal.
The remaining quantity for Item A is 39, Item B is 100 and Item C is 0 (zero).
My questions are:-
How to correct only the Amount(LCY) in the vendor? The USD amount is correct?
Can we correct the item unit cost that have been sold or used in production?
How to correct the Total Purchase Value (LCY) in G/L?
The way I solved a similar problem was with the help of an item charge. I created an item charge named ‘correction’ and assigned the charge to the initial receipt lines using a purchase invoice.
Maybe this is not a scientific NAV solution but the advantage is that your costs and purchase value in the g/l are correct and the effort is minimal.
Yes, the credit memo is probably the best solution. But before doing it, you follow the exact reverse process of what was done earlier. I.e if you purchased->, then followed up with item charges, then first reverse (cr. Memo) the item charges and then reverse (cr. Memo) the purchase. Otherwise if you just do a cr. memo for purchase only, the item charges just sits in the inventory as the link to the item is lost.