We are trying to formulate a Stock in hand report for all the locations through QR 6.5A with IC 6.1 data. All the locations will come as column headings (through formula's to print qty on hand if the loc=x) and the issue is when we print the report some items of some locations (cannot find a basis, looks like a random error) not printing the correct qty on hand as appearing under IC Inquiries. We suspect the problem to be in some kind of refreshing mechanism to read the most recent data. We tried to print when all stations are out of Accpac, but still no luck. The item code is from the ICITEM'R and other details are from ICILOC'R and ICCATG'R (to obtain description of category read from ICITEM'R)

Any hints to make the QR refresh (or read as per IC inquiry's reported qty on hand) would be much appreciated.