Stein,
I take it you are handling the cash and GL transactions for the payments in
a way you already have set up. For the AP part of it, how ever you do it,
you want to end up with this data:
1) A record or records in F0414 (which is the data which appears on the
remittance advice of a check/other payment instrument), one record for each
voucher line you have in the F0411 vouchers table that you are paying;
2) A record in the F0413 table, one record for each payment going to each
vendor. Thus, one check/instrument paying one vendor for 5 invoices (5
vouchers in F0411, or one voucher with 5 lines, or some combination thereof)
would have 1 record in F0413 for the total $$ to that vendor, and 5 records
in F0414 which total to the amount of the F0413 record.
3) For each voucher line paid, update field PAAP ($$ unpaid) in F0411 by
setting it to $-0-, and update PST pay status to set it to "P" to show the
voucher "paid". (In F0413 and F0414, PAAP is "amount paid": a different use
of the field name.
I take it you already have some records in F0411 and F0413 and F0414 you can
look at. Look at the F0411 records you have to see what data gets passed to
the F0414 record. How ever you do it, make sure the records you create,
match in total the GL entries you are making.
Notes on fields in F0414 with poor descriptions by JDE:
1) RC5 is a serial number for each record in one payment going to one
vendor. So for one F0413 record with five F0414 records, the F0414 records
have RC5 values of 1 through 5.
2) SFX is the serial number for each line in the F0411 voucher record. So
one voucher in F0411 (one DOC number) with 5 lines/records have SFX values
of 001 through 005.
3) PYID is the key between F0413 and F0414. One PYID has one corresponding
check number.
4) DOC is the doc number in F0411 of the voucher being paid.
Dave Mallory Denver Water 7.332 SP 15.1 Oracle 8.1722 NT 4.0
