You can do it easily with AS/400 Query, over the RCM, SIH and SIL files
Tom Molyneux
NOV Mono
MIS Department
Tel. +44 (161) 214 2142
Fax. +44 (161) 214 2344
E:mail Tom.Molyneux@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of John Quirk
Sent: 04 March 2010 15:21
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Query
We do not have SQL...standard BPCS
John
-----Original Message-----
From: bpcs-l-bounces+jquirk=bsmpump.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+jquirk=bsmpump.com@xxxxxxxxxxxx] On Behalf Of Carr,
Wally
Sent: Thursday, March 04, 2010 10:14 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Query
John,
What do you have by way of query tools?
-----Original Message-----
From: bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx] On
Behalf Of John Quirk
Sent: Thursday, March 04, 2010 8:19 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Query
Running BPCS405cd
Looking to query the following.
Customers invoiced to the state of MI
Sales to invoice to customer(ID#) with state code MI
Breakdown by ID #
Any info would be helpful..
Best
John
BSM PUMP CORP
BSM Pump Corp
180 Frenchtown Road
North Kingstown RI 02852
401 471-6391
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: wallyc@xxxxxxxxxxxxxxxxxxxx
CONFIDENTIALITY NOTICE: The information contained in this e-mail and any
attachments is confidential, may
be legally privileged, and is intended only for the use of the party named
above. If you are not the intended
recipient you are hereby notified that any distribution, dissemination or
other use of, this message, in any form,
is strictly prohibited. If you have received this message in error, please
immediately notify the sender and
destroy this communication.
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: Jquirk@xxxxxxxxxxx
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2721 - Release Date: 03/03/10
14:34:00
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
