Al,
1) The ILSEQ Number on SIL should be the same line number that on the ECL
record for that order.
2) For the BIL600 issue on thing you may want to try is looking in RAR
depending on what information you are looking for. In RAR the ID field will
tell you if it was an invoice (RI) debit memo (RD) credit memo (RC) or a
payment (RP)
3) The invoice due date and Discount Due Date should both be on the RAR
record for that Invoice.
Hope this helps......
Maurice
-----Original Message-----
From: bpcs-l-bounces+mhastings=hbpi.net@xxxxxxxxxxxx
[
mailto:bpcs-l-bounces+mhastings=hbpi.net@xxxxxxxxxxxx] On Behalf Of
bpcs-l-request@xxxxxxxxxxxx
Sent: Wednesday, July 11, 2007 12:00 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 5, Issue 141
Send BPCS-L mailing list submissions to
bpcs-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
bpcs-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. (no subject) (Don Cavaiani)
2. Re: (no subject) Purchase Order Carrier (Al Mac)
3. SIL SIH Invoice History Navigation (Al Mac)
----------------------------------------------------------------------
message: 1
date: Wed, 11 Jul 2007 06:44:19 -0500
from: "Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
subject: [BPCS-L] (no subject)
Is there a quick and easy way ( I'm brainstorming) of getting our preferred
carrier on our purchase order?
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
------------------------------
message: 2
date: Wed, 11 Jul 2007 11:19:01 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: Re: [BPCS-L] (no subject) Purchase Order Carrier
We modified the layour of our Purchase Orders ... the program is PUR520 in
our version. We added such things as a line showing signature of the
buyer, fax # & request that the order be confirmed with assurance of
pricing and delivery dates within 1 business day. So logically you might
want to include
* preferred carrier
* your account # with that carrier, if the billing needs to go to you
rather than the shipper, or if that would expedite getting it delivered
correctly to you
* contact info on that carrier, just in case some of your vendors
unfamiliar with them
Is there a quick and easy way ( I'm brainstorming) of getting our
preferred carrier on our purchase order?
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
------------------------------
message: 3
date: Wed, 11 Jul 2007 11:47:03 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: [BPCS-L] SIL SIH Invoice History Navigation
I'm working on a billing history report where I need to access data not in
the invoice files (SIL detail lines SIH header summary). We're 405 CD.
Is SIL.ILSEQ, which immediately follows SIL.ILORD (original order#), the
line # on that order# (ECL file) corresponding to the shipment being billed?
Is there any code showing what is a credit from BIL600 that has no RMA# or
can I only go by whether $ total is positive or negative? What's needed is
to show which records from the invoice history files are real invoices and
which are actually credits.
Another thing they need is when the invoice was due (assuming no discount
taken, vs. when due if discount is taken) ... I can calculate that from the
terms, but I figure that data has got to be already someplace in Accounts
Receivable RAR detail file, if I can only figure out relevant linkage from
invoice # to whatever would be the correct type of record with that
data. I would prefer to copy it from RAR because our terms are
periodically changed, which impacts different orders, invoices, etc.
-
Al Mac
------------------------------
midrange.com
