D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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.​


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

Original Message:
Sent: 01-22-2019 12:48 PM
From: Scott Pollard
Subject: Report/View for All Items in a Location?

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
------------------------------

Thank you Richard, I appreciate it.

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

Original Message:
Sent: 01-23-2019 08:28 AM
From: Richard Wehmeyer
Subject: Report/View for All Items in a Location?

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.​


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

Original Message:
Sent: 01-22-2019 12:48 PM
From: Scott Pollard
Subject: Report/View for All Items in a Location?

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
------------------------------

Hi Scott.  I concur with Richard.  Additionally, you can select Location when running On-Hand Inventory Report.



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

Original Message:
Sent: 01-22-2019 12:48 PM
From: Scott Pollard
Subject: Report/View for All Items in a Location?

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
------------------------------

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
------------------------------

Original Message:
Sent: 01-22-2019 12:48 PM
From: Scott Pollard
Subject: Report/View for All Items in a Location?

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
------------------------------