mibuso.com

Microsoft Business Solutions online community
It is currently Sat Aug 30, 2014 6:11 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Inventory Valuation Report v/s GL Control Account
PostPosted: Fri Mar 02, 2012 8:57 am 
Offline

Joined: Mon Jan 30, 2012 11:03 am
Posts: 71
Country: Singapore (sg)
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


Top
 Profile E-mail  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Fri Mar 02, 2012 9:31 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
Popular question this week...

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

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Mon Mar 05, 2012 12:01 pm 
Offline

Joined: Tue Oct 04, 2011 10:26 am
Posts: 94
Country: Belgium (be)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Mon Mar 05, 2012 9:21 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5012
Location: Los Angeles, CA
Country: United States (us)
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.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Mon Mar 05, 2012 9:34 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
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 :wink: . But there is of course the performance overhead when posting.
Code: Select all
"Automatic Cost Adjustment" --> Always.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Tue Mar 06, 2012 11:41 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5012
Location: Los Angeles, CA
Country: United States (us)
David Singleton wrote:

Code: Select all
"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.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: Inventory Valuation Report v/s GL Control Account
PostPosted: Wed Mar 07, 2012 9:46 am 
Offline

Joined: Tue Oct 04, 2011 10:26 am
Posts: 94
Country: Belgium (be)
Alex Chow wrote:
David Singleton wrote:

Code: Select all
"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.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: