× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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. ---------------------------------------------------------------------------------------------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2024 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.