Problems with Average ocst

spetouss

I have posted a credit memo without completing the Appl - to ID Item Entry box. This returned an invalid Average Cost figure for a substantial number of items, as the original purchase invoice included incorrect purchase prices. I want to know the best way to correct the average cost of those items.

Savatage

spetouss wrote:

I have posted a credit memo without completing the Appl - to ID Item Entry box. This returned an invalid Average Cost figure for a substantial number of items, as the original purchase invoice included incorrect purchase prices. I want to know the best way to correct the average cost of those items.

What to you mean invalid? Do you mean it has chnaged the costs and the cost are now wrong?

spetouss

I posted a purchase invoice incorrectly and this altered the Average Cost of many items. I have tried to correct the error with a credit memo, but the average cost of the items is still incorrect.

Alex_Chow

When you do the credit memo, you should've used the Applies to Entry field on the purchase line.

Another way is to use the item journal and do negative and positive until you get it to the proper cost before the purchase invoice.

If you don't want to do that, another more painful way, is to use the item charge function to apply to those receipts. The amount will be the difference between your vendor invoice and the invoice you posted into Navision. For the item details, you'll need to play with the percentages to get it as close a possible.

If you don't want to do that, then just use the revaluation journal.

make sure to run the adjust cost process each time.