Average cost <> Unit cost

Please check the following:
1. what is the difference? Is it just the decimal places? If yes, try put the unit amount rounding precision to 5 decimal place.

What is Average cost calculation type (you can find in inventiry setup)?

I think it was changed manually. And now these items has 0 on inventory.
It will be recalculated if you post any positive transaction to this item.
But i can be wrong.

As a general rule, the only time unit cost and average cost should be unequal is when there is zero stock. At this time the average cost is also zero.

Have you run the ACIE immediately followed by "Post Cost to GL"? Navision seems to generate entries in the post cost (in respect of back dated entries for example), even if the Inventory is set to immediately update the GL. I always tell my customers to do both runs, one after the other, every day. This is the only way to get reasonably accurate profit figures. I also ask them to post to GL "per entry" as this makes it easier to trace system activity back to original documents.

Please also ensure that there are NO filter conditions set. It is quite easy to put a posting date in the filter tab of the Post Cost to GL rather than the option tab. This can produce very strange outcomes. Fortunately the system is self correcting once the filters are removed and the run repeated.

zoechiang wrote:

Good day,

I use Navision 3.7 W1, Costing Method= Average
I just discovered that the Unit cost <> Average cost (LCY), in some Items
I'd try to run ACIE for serveral times or Invoice all the Purchase
but the Unit cost still not equal to average cost,
Is anybody know what happen on that.

Thank you

Zoe

Make sure you run the Adjust Cost - Item Entries process. In 3.7, you have to run this process for the Unit Cost to be updated.