Hi, we have been trying to create a Crystal Report that reports scrap details by date. When entering scrap in Inventory Adjustments, we use the Reference field for the scrap code, and we are now using the Reason field to enter the shift code.

To build the Crystal Report, we used the ICW65 Items, the ICW80 Transaction History, and the ICW65 Adjustments databases. We've tried a few different table linking configurations. We managed to get all fields show up on the report with the exception of the Reason field from the Adjustments table. How do we get this field to show up?

We are running Crystal Reports 8.5 for Adagio, and Adagio Inventory 8.1B (100310).

Thanks!