Thank you for taking the time to answer each question.

Two more, have you tried opening sample data (SOFTRAK\ICWIN\Samdata folder) and printing both of the reports? Do the reports (a) print or (b) give you the same progress bar and screen flash?

6/26 Good call. Both of the I/C reports in question run just fine with the sample data and with any selected variable. This should confirm that the software (or workstations) are not at fault.
Knowing this, we've gone back and tried to compare as many options as we could find or think of for the two data sets.

We've been able to run the Item Status Reports from the main data when either "Total quantities" or "Quantities by location" were selected. The report will not run if both options are selected.

Also, I don't believe your DIC errors are related. They are more probably related to the uom being changed on an item and that item having been sold previously using an old uom that is sitting in history.
06/26 thanks we'll keep checking

Sorry, I'm not completely following:
A. there is only one location in use. "1" is in the Loc field. Under Item Inquiry nothing looks out of order in the Quantities screen. I'm not sure what we're looking for.

B. From our side we don't see values of any kind under the Item Inquiry screen. Are you perhaps referring to the "Item Inquiry with Sales and Costs" screen?
If so, valuations are found in the "Costing" screen (tab).
In the Costing screen 5 locations are listed, with only Lot 1 having quantities and values. (Why does this screen refer to this as Lot?) If you provide your e-mail we can send an image.

Here's something to try. Use the Item Inquiry function and open up an item. Go to the Quantities screen. This shows the quantities allowed at each location and the respective values.

We've seen data corruption in the ICILOC file cause problems with reports such as the Item Valuation. It was a different error than what you reported. PErhaps run a Data Integrity Check on your data, just to be sure.

6/26 DIC is showing numerous errors with I/C, but no problems with locations. (pasted from DIC)
Application Integrity Phase

Loading Account Sets ... OK
Loading Locations ... OK <-- **
Loading Categories ... OK
Loading Price Lists ... OK
Loading Tax Groups ... OK
Company Profile ... Checked OK

The problems all have to do with pricing and costing units: eg.
Item XX/XXX-FG350 pricing unit is not valid.
Item XX/XXX-FG350 costing unit is not valid.


See this previous posting here for more information.
Corrupt ICILOC data file