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.

Dear Devon

Could this be related to your Day End processing having not been completed yet? I would suspect that any discrepancies could be due to IC not having been updated with all the sales/return information that is necessary to produce those figures for you.

The inquiry information fields are calculated fields based on "quantities shipped not costed" and temp file for items committed already. These fields add the value stored as Quantity on hand to the Quantity shipped but not costed.

If you want to reconcile QR to IC, you will have to run a Day End in OE or - use a formula to add Qty on hand to Qty shipped not costed.

If your Quantities do not reconcile after you have done this, then there is a problem in the OE/IC data.

*** In QR for DOS 6.1F and higher, this field is available from Other Data/Miscellaneous Data.

Hope this helps!
Regards

Softrak Support

[This message has been edited by Softrak Support (edited 05-29-2001).]