Hi Al,

If you want the on hand qty correct in the subtotals, choose min(or max or avg) at the summary functions for that column.

Kind regards


At 15:42 02-08-06 -0700, you wrote:
Hi David Unwin:

Thank you for your reply to my July 20, 2006 posting.

I tried following your instructions and I didn't have
any good results.

I was a little confused about your comment how the
printed report will look different that the report
displayed on the screen.

Also, do the settings of Select Sort Field and Select
Report Summary Functions have an affect on the

Perhaps you could run a simple Query and mail me a
copy of the printed Query definition?

Any assistance you can provide would be greatly

Al Gershen
Cost Accountant Lead
ECS Composites
3560 Rogue River Hwy
Grants Pass, OR 97527
Tele (541) 476-8871, x272
Fax (541) 474-2479

--- "Unwin, David" <dunwin@xxxxxxxxxx> wrote on Fri,
21 Jul 2006 11:16:52 +0100:

> Hi,
> Select the fields you need, e.g. Item, Description,
> Quantity On Hand, CO
> Number, sort by Item, and CO Number, and then put a
> break level of 1 in
> for the Item, Description and Quantity.
> When you print the report it will not repeat the
> Item, Description, and
> Quantity lines (although it does show them if you
> display the report to
> screen).
> Regards,
> David.

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Best Regards,

A good player makes himself look good;
a great player makes the team look good.

L. Geheniau M.I.S. supervisor / Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@xxxxxxxxxxxxxxxxxx
sms: No phone!  0645886969

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.