D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Report/View for All Items in a Location?

  • 1.  Report/View for All Items in a Location?

    Posted Jan 22, 2019 12:48 PM
    Hi all,

    I have used these forums for a long time now, and have been to many AXUG events. I know this may seem very basic to some of you, but in preparing to set Cycle Count Thresholds, I was trying to figure out how to see all on-hand inventory for all of the locations in a warehouse.

    I have played around with the On-Hand menu items trying to get the location to populate but so far a report either times out or a grid won't populate the location and says 'unretrieved' in the column if I add it via personalization.

    Can anyone recommend the best/easiest way to see everything in a location that is on-hand?


    ------------------------------
    Scott Pollard
    Sunny Delight Beverages
    Cincinnati OH
    ------------------------------


  • 2.  RE: Report/View for All Items in a Location?

    SILVER CONTRIBUTOR
    Posted Jan 23, 2019 08:28 AM
    In the on-hand inquiry click on Inventory button > Dimensions display.  Select location from here.  Personalizing inventory dimensions does not work out very well as some entries are aggregated (that's why you get "Unretrieved")​ via dimension display.​
    Dimensions display

    ------------------------------
    Richard Wehmeyer
    PlayCore
    Chattanooga TN
    ------------------------------



  • 3.  RE: Report/View for All Items in a Location?

    Posted Jan 23, 2019 11:46 AM
    Thank you Richard, I appreciate it.

    ------------------------------
    Scott Pollard
    Sunny Delight Beverages
    Cincinnati OH
    ------------------------------



  • 4.  RE: Report/View for All Items in a Location?

    TOP CONTRIBUTOR
    Posted Jan 23, 2019 02:44 PM
    Hi Scott.  I concur with Richard.  Additionally, you can select Location when running On-Hand Inventory Report.



    ------------------------------
    Lori Holmes
    Hamamatsu Corporation
    Bridgewater, NJ
    ------------------------------



  • 5.  RE: Report/View for All Items in a Location?

    TOP CONTRIBUTOR
    Posted Jan 30, 2019 01:29 PM
    Hi Scott, judging by the fact you're using Cycle count thresholds, you're using AX2012 R3 or D365FO Warehouse Management. There is a form called On-hand by location in Warehouse Management > Inquiries and Reports > On-hand by location.

    With the other on-hand forms, as others have mentioned, use the Dimensions display to show location when and where needed.

    ------------------------------
    Andrew Lencsak
    Senior Application Consultant/Solution Architect
    eBECS Limited
    Atlanta GA
    ------------------------------



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