I'm trying to print an inventory report that will show the total number of each item in inventory at each location. I know I can print this from either an Item Status report or an Item Valuation report, but they both product a huge report with us having over 6M items in inventory. I currently just use an F6 search and then export it to Excel so I can just have one line per item, but I cannot find a way to have each location total show up individually. When I try to enter the columns: qty at loc 1, 2 and 3 only loc 1 will give me a total even though I have inventory at all locations. Can anyone help?

Ally:

You will need to either keep doing what you are doing with the finder or have a custom report created. With a custom report the data can be presented any way you want.

If you need assistance with Adagio please call me in Winnipeg at 204 944 0302 extension 223.

Crystal Reports for Adagio will do the job. I am using it for
my client who shares your difficulty.