An SIH invoice may have multiple SIL item lines, off of the same customer
order. So long as only one file in the query has multiple possibilities, no
problem, you get one line for each hit. But when 2 or more files in the
query have multiples, then the query finds one line for each combination
possibility.
4 item lines on one invoice on one order.
3 note lines on the order.
Query/400 generates 12 lines from this.
Some people might not want that excess.
Multiply this scenario with 20 separate invoices on the same order.
Some people might want to see notes associated with customer, other
criteria, in addition to the order. Frequently end users see the notes
various places, do not realize their BPCS association constraints.
If your query is displaying $ total, quantity total of invoice lines, the
lines repeating 3 times because of the notes, can lead to grand total on
bottom inflated tremendously, and horribly misleading.
In our reality,
* We have wanted to link additional ES* files for shipping carrier
information ... did this go UPS RED for example.
* Shipping personnel select cust #, ship to #, which displays default
name address, but then they can substitute something else. Not all BPCS
files get the substitution, but that info is in the ES* files.
* When IIM description gets displayed on ORD500, our people sometimes
change description to be different in ECL to incorporate customer tracking
wants, for which we do not have another convenient place. For example, some
customer count of model split, from their CPO release line # whatever. The
purpose of this is to have that info show up on shipping paperwork and
invoice received by customer.
Al Mac (WOW) = Alister William Macintyre
via WOW WAY.com ISP
2012 April I had a serious PC melt down, from which I am still recovering
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Bill
Sent: Wednesday, October 17, 2012 2:08 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] File for Customer Order Notes in Notes
MaintenanceORD140D2-01
On 10/17/2012 12:13 AM, ANTONISSE, David wrote:
Can someone tell me which file I need to use to download 'Customer Order
Notes' in ORD140D2-01 Notes maintenance?
I need to modify a query which uses the files SIH, SIL, RCM, IIM and SSM.
I need to add customer order notes in the output.
David,
As others have told you, it's the ESN file. Now, you're likely to run
into a problem adding it to your query that I had to educate many users
about. What if there's more than one note per order? Let's say there's
3 lines of notes for this order, that will triple the records returned
for this order's information.
Is this query an iSeries Query object, or are you doing something else
and just using the generic query term? If you are downloading direct to
a spreadsheet using MSQuery, I can give you a couple of ideas as to how
to address the problem.
Bill
midrange.com
