The Slow Moving Items report has useful data, but I find it too busy.
I would like to put something together using Gridview.
I especially want to display the “Days Between Shipments”, or to calculate Items that have been in stock for too long. (We will have to decide how to define this.)

Which tables would we find this information?

Hello Sam,

To answer a question like this one, you should use the Data Dictionary Exporter. The DataDictionaryExporter.exe is in the Softrak System folder.

The Data Dictionary Exporter (DDE) is a utility program to export Adagio's database description (data dictionary) tables. A data dictionary describes the tables in a module and the files that contain the actual data. For each table, each element in the record is described, including its name, data type and length. The field names are displayed in the Adagio Grid Editor and GridView.

Hi Samuel:

You're very nimble with Crystal Reports. How about modifying the existing report to simplify it - remove the portions you don't want? As long as you feel the calculations are accurate, you can let it do that work for you.

Or if you want the challenge of calculating the figures with a GridView report, I would start with "I/C Transaction History". It has both the inventory shipment and receipt transactions in one table.

Thank you Support (Terry) and Bruce for your recommendations.
I will look into this.