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