Location Details Summarized

[dtmb]

Hello,

**Spec**
Accpac 5.3a running on Pervasive V8

I have two locations numbered 1 & 2. I successfully created a market list in crystal reports, but have one problem, each item is printed twice due to the different locations. How can I get the quantities at both locations to be summarized so that each item will print only once?

Thanks

 

[ettienne]

Subtotal quantities by item on the report and then suppress the Details section.

 

[dtmb]

Thanks tried your suggestion and worked in one aspect but had data loss - prices, uom etc.

 

[ettienne]

Move the prices and other fields to the group footer.

 

[dtmb]

Thanks a million worked perfect. You guys are really great help!!!