Dynamics Community Forum Thread Details

inventory valuation report

I realised that in the Inventory Valuation Report (report ID 1001), the report is consolidating all the entrries till tO--date although I had specify a date range in the 'Starting Date' and 'Ending Date' field. For instance, I want a report with starting date' = 01 AUg 2012 and 'Ending Date' = 31st Aug 2012. However, when the report is being generated, it is also consolidating the value entries posted after 31st August 2012.

Please advise how can I go about fixing this problem.

Thanks.

Regards,

WIlson

Hello Wilson,

Thank you for posting on the Microsoft Dynamics NAV Forum. First, I must let you know that I work in the North America (NA) Support Region. In the NA Version, we don't use Report 1001. There are Localized North America Reports for Inventory Valuation (R10139), Inventory To G/L Reconcile (R10138), and Item Transaction Detail (R10136), which are the key reports to manage Inventory Reporting. You can download a North America Database from the 2009 R2 launch page for further review of the reports. If you are a NAV customer, you may have to work with your partner to look at these reports as possible optional reports. A partner would have to possibly renumber the Reports into a supported custom object range for your license.

Just to confirm though - Is the request that you only want to see the transactions for 8/1/2012 through 8/31/2012 and change/effect for the period - i.e. you don't want to see a balance as of 8/31/2012 but rather a change in quantity/value for the month?

You may look to the Inventory Analysis Reporting as an option. Under Financial Management > Inventory > Analysis & Reporting > Inventory Analysis By Dimensions, you can set up ranges where the system only show the net effect of the change to the inventory balances by quantity and value. This would give you a possible option in standard NAV to generate the results you are looking for.

I hope the information helps.
Best Regards,
Tom

Quick Links

Leaderboard