Inventory Valuation Report v/s GL Control Account

kwajahathydro · 2012-03-02

Hi,

I have a strange question which I would like to know the answer for it. After I run adjust cost item entries batch job for the month of feb 2012, when print inventory valuation report and compare it with g/l control account it doesnt tie. Infact the valuation report shows higher figure and g/l control account has a lower value in it.

What I would like to know is in what cases the valuation report is high and gl is low. How do I start to check where it went wrong. I would like to know if there is any starting point for me to investigate the above matter.

Pls do let me know on how to start looking into this issue as I have never seen like this earlier in my navision experience

Regards

David_Singleton · 2012-03-02

Popular question this week...

viewtopic.php?f=23&t=52112&p=252615#p252615

Resender · 2012-03-05

After reading this and the exellent explanation on how to avoid or correct the issue I'm wondering If there isn't a way to left Navision do this automaticlly.

Alex_Chow · 2012-03-05

Resender wrote:

After reading this and the exellent explanation on how to avoid or correct the issue I'm wondering If there isn't a way to left Navision do this automaticlly.

You need a developer involved.

But really, Microsoft should make the automation an option out of the box without a developer involved.

David_Singleton · 2012-03-05

Alex Chow wrote:

...

But really, Microsoft should make the automation an option out of the box without a developer involved.

It is, you just need to select the option in Inventory Setup

. But there is of course the performance overhead when posting.

"Automatic Cost Adjustment" --> Always.

Alex_Chow · 2012-03-06

David Singleton wrote:
"Automatic Cost Adjustment" --> Always.

Oh man... That doesn't count. This is one of those features that causes more problems than it solves.

Even if you set it to Always, you still have to run the Adjust Cost - Item Entries process. This gives me a topic for a new blog article.

Resender · 2012-03-07

Alex Chow wrote:
David Singleton wrote:
"Automatic Cost Adjustment" --> Always.
Oh man... That doesn't count. This is one of those features that causes more problems than it solves.

Even if you set it to Always, you still have to run the Adjust Cost - Item Entries process. This gives me a topic for a new blog article.

Ok, so it's kind of possible to automate it, but I had hoped you could have sheduled it so that it runs every so often.

Inventory Valuation Report v/s GL Control Account

Comments

Categories