Another option would be to use MS Excel or MS Access if you are familiar. Both are capable of connecting to BPCS and do a superior job of querying in my opinion, and both will allow running the data through a pivot table to create your report. Further, I find that my Excel queries allow quicker turn around for custom report requests as many of the requests I receive rely on the similar data. Having all sales lines(with related transaction data) for a particular period for example allows me to meet a number of requests in a matter of a minute or two where generating something in BPCS would take me much longer.
Feel free to contact me if you need help with the connection.
-----Original Message-----
From: bpcs-l-bounces+brian_brosch=nkusa.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+brian_brosch=nkusa.com@xxxxxxxxxxxx] On Behalf Of Al
Sent: Friday, May 07, 2010 7:42 AM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Question about queries
You do not lose info on totals only query if you use that info as basis of
control break.
Sometimes I need to use an *OUTFILE to accept the data, then another query
to list the data so it is formatted user-friendly.
The info you are looking for, depending on your BPCS version, may already be
available in the sales history summary files.
Check out SSH and SSD. These files contain grand total shipped, with $
implications, by customer item combination.
Watch out for changes in sales person assigned. The data is summarized
based on the sales person assigned at the time of the sales. We sometimes
get new sales persons, adjust which ones handle which customers. A report
run today might not show all the data on a customer, just the stuff that was
done with the latest sales rep assigned to that customer.
There are manuals on BPCS, there are manuals on query, both available to
legitimate customers of BPCS and IBM. There are also combination manuals
only available to customers of particular consultants.
-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of
David.ANTONISSE@xxxxxxxxxxxxxxxx
Sent: Friday, May 07, 2010 8:30 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Question about queries
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
