Crystal question re: IMINVLOC and OELINHST

[swords]

Our company has multiple locations set up in Macola. I have a Crystal report trying to show sales from OELINHST for various time periods by item number, by location.

The report shows item# (from IMINVLOC), location (from IMINVLOC), qty on hand (IMINVLOC), sales (using the Qty to Ship field from OELINHST). However, the data being pulled from OELINHST/Qty to Ship is repeating itself, from one location only, to all of the locations for that item. It seems that the loc field from IMINVOC is not linked to the loc field in OELINHST.

Any ideas or experience with this?
Thank you!
Randy

 

[dgillz]

You could link it if you feel thats the problem, however, I would write a record selection formula to restrict teh rport to only the location you are interested in. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com