D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Inventory Value Report Storage Not Allowing Filter By Location

  • 1.  Inventory Value Report Storage Not Allowing Filter By Location

    TOP CONTRIBUTOR
    Posted 15 days ago
    I'm having an issue with the new Inventory Value Report Storage report (and I think this was an issue in AX2012 as well). The Location field is available as a filter and display on the report, but it displays blank and any filter used on results in the report returning no data. There is data in the Location field in the Inventory table, I can see it via Atlas query, but the stock D365 report doesn't seem to see it.

    We've been using this report without filtering by it for a year, but we're at our fiscal year end and need to be able to run it for specific locations for audit test counts. Is there something we need to do to make this dimension available to the report?

    D365 Finance & Operations Installed product version : 10.0.20 (10.0.886.114)

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------


  • 2.  RE: Inventory Value Report Storage Not Allowing Filter By Location

    TOP CONTRIBUTOR
    Posted 14 days ago
    I believe the only inventory dimensions that can be used on that report are those that are financially valued in the dimension setup.  I am absolutely certain you cannot get accurate reporting on a dimension that is not financially valued.

    ------------------------------
    Kevin McLean
    Strategic Solutions NW
    Beaverton OR
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role