Reconcile Inventory Valuation report incorrectly

vandang

Dear Experts,

My customer is using NAV version 3.60 (5.0 SP1) with Incadea engine. They want to reconcile between Inventory Valuation report and GL Entry. After run Adjust Cost - Item Entry batch job, Inventory Valuation can shown value correctly in current. But in period in the past, it cannot.

This is an urgent task so could you please help me! Thanks!

vandang

We are using Average Costing Method for all items. Thanks!

David_Singleton

Just a couple of days ago in this thread ...

viewtopic.php?f=23&t=52022

Alex posted a link to what is probably the answer. The thread is still in the list of active topics, it's not as if it was years ago and hard to find ](*,)

http://www.dynamicsnavconsultant.com/20 ... -is-wrong/

David_Singleton

Actually this is probably a better link

http://www.dynamicsnavconsultant.com/ca ... inventory/

vandang

Thanks David Singleton for your replying! I know this issue which is not easy but customer don't know this. They make too pressure on me ](*,)

Alex_Chow

vandang wrote:

Thanks David Singleton for your replying! I know this issue which is not easy but customer don't know this. They make too pressure on me ](*,)

Any reason why you can't properly explain this to your customer to eliminate the pressure?

vandang

Dear Alex,

It is nice to see your reply! I'm reading some article from you and it help me much thanks!

Regarding to your question, my customer just want to get the same value between Inventory Valuation and GL Entry. They accept the different from between groups when run this report in period, but the total number (Expected Cost Included Total) should equal to GL Account ](*,) . I don't know should start from where now :?

On the other hand, audit department of government will come to our customer in middle of March, so they are so worry about this report to show.