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 Lucas 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 outcome? 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 appreciated. Regards, Al Gershen Cost Accountant Lead ECS Composites 3560 Rogue River Hwy Grants Pass, OR 97527 Tele (541) 476-8871, x272 Fax (541) 474-2479 aldg3@xxxxxxxxx --- "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 http://mail.yahoo.com _______________________________________________ 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.
www.viva-lancia.com Best Regards, Lucas 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 l.geheniau@xxxxxxxxx sms: No phone! 0645886969
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.