Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory Value Report - How to exclude lines with both zero quantity and zero value

Posted on by 5

Our company is using AX 2012 R3 CU9.  We have inventory that is tracked by Batch Number. 

At month-end we run the Inventory Value report at the Batch Number level.  The report is showing all Item/Batch number combinations that have ever existed and is creating 10's of thousands of extra rows (essentially crashing the report)

I'm looking for a way to exclude Batch Numbers where the Inventory Quantity = 0 AND the Inventory Amount = 0. 

.pastedimage1588364798668v2.png

Above is a screenshot (maybe hard to read).  The first row, we'd like to continue to see.  It's the second and third row of data with 0's that we'd like to exclude.

Anyone have experience with this or have a better way to run the report?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report - How to exclude lines with both zero quantity and zero value

    Hello bellington,

    The inventory value report seems to be the proper one when it comes to financial and physical values.

    If the report takes to long or includes information that you don't need then let's have a developer a look at it to assess whether you can create a custom report that runs faster and includes only the data you are interested in.

    Alternatively, you can consider making use of the inventory value cube. The data available there might not be 'live' data and depend on the frequency the cube is refreshed but it might be a good alternative.

    Best regards,

    Ludwig

  • bellington Profile Picture
    bellington 5 on at
    RE: Inventory Value Report - How to exclude lines with both zero quantity and zero value

    Thanks Ludwig.

    The workaround you suggest is what we are doing today.  The problem is it's taking roughly 45 minutes to A) run the report and B) to filter it once in Excel.  The end result is only 20k rows of data.  

    Essentially what we're looking for is a License Plate level of detail for our inventory that ties to the GL.  Maybe there is a better report we should run?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report - How to exclude lines with both zero quantity and zero value

    Hello bellington,

    Filters for the physical/financial quantities and / or amounts don't seem to work on this report.

    What you can do as a workaround is generating the report and exporting it to excel where you filter the transactions for amounts and quantities of 0

    Best regards,

    Ludwig

  • RE: Inventory Value Report - How to exclude lines with both zero quantity and zero value

    You may refer to below article on how to user Inventory value report, hope it helps

    cloudblogs.microsoft.com/.../

    Abhishek Mehta

    Senior Support Engineer

    Dynamics 365 for Operations

    Customer Service and Support

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans