Re: SIL file, make subtotals on ILQTY without losing information of other files (like SSM and IIM)

In order to get multiple fields showing in your summary file, you need to sort by those fields and list all of them as #1 on your report breaks.

If you want, I'll take this on a private basis.

Dick Bailey
MCFA, Inc.

-----Original Message-----
From: bpcs-l-bounces+dick.bailey=mcfa.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+dick.bailey=mcfa.com@xxxxxxxxxxxx] On Behalf Of David.ANTONISSE@xxxxxxxxxxxxxxxx
Sent: Friday, May 07, 2010 8:53 AM
To: BPCS ERP System
Subject: [BPCS-L] SIL file, make subtotals on ILQTY without losing information of other files (like SSM and IIM)


Hello,

I am looking around for some BPCS Query help.

I am busy with a query for a sales person.

The problem I have now in the first query. I need to have a summary (total
quantity) of the sales, per period, per salesperson.
In the query I work with the SIL file, the SSM file and the IIM file.

I want to see only total lines per item and quantity. But there is more
information on the lines with should be still visible.

These are my field I want to see:
T01.ILQTY Quantity
T02.SSAL Salesman Number
T02.SNAME Salesman Name
T01.ILCUSB Billing Customer
T03.CNME Customer Name
T01.ILPROD Item
PIECE ilrev/ilqty
T04.IDESC Item Description
T04.IDSCE Extra Description

Now I want only sumarize this information on T01.ILQTY, but without
success. When I summarize I lose all other information. When I see the
total information, it is not summarized.
This is the first query from a serie of about 4 or 5 to add other
information later (about the inventory etc.)

Can you help me how I get the first query summarized?


Do you know where I can find a digital book Query User Manual for BPCS?

Thank you very much!

Rgds,

D APlease consider the environment before printing this e-mail. --------------------------------------------------------------------------------------------------------------------- Discover Impress on http://www.impressgroup.com The information contained in this e-mail and any attachments is strictly confidential and may be legally privileged.It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee, you are hereby notified that it is prohibited and may be unlawful to disclose, distribute, store, copy the information in any medium or usage for another purpose. ---------------------------------------------------------------------------------------------------------------------