web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / inventory valuation re...
Microsoft Dynamics NAV (Archived)

inventory valuation report

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

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

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • TWBlaisdell Profile Picture
    TWBlaisdell Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans