Tie between F0411 vouchers and F0413 checks

david_mallory

Well Known Member
Question for AP experts:

If I have an AP check, in table F0413, and I want to know what vouchers in
F0411 that the check is paying, what are the keys between those two tables?
Or same question in the opposite direction. I don't see a tie, by looking at
the fields in the tables. Does OW write nothing to F0411 vouchers when it
writes F0413 checks for the vouchers? Do I have to go to field PO purchase
order number and LNID purchase order line number? (Clumsy, and not cool if
have PO is received and vouched in partials.) That is the only answer I see.

Dave Mallory Denver Water Denver, Colorado, USA 7332 SP13 NT
4.0 Oracle 8.05
 
Hi,

Whenever I've been trying to sort out integrity problems with the AP files,
I've had to do the following:

Find the voucher number in the F0411
Search the F0414 for the voucher number, and note the payment ID number
Search the F0413 for the payment ID number
or vice versa.

Hence the tie is via the F0414 which provides a breakdown of all the
vouchers a payment in the F0413 is making.

Hope this helps,

Suzanne Main
QBE Insurance Europe





david mallory <[email protected]>@jdelist.com on 22/03/2001
22:01:24

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:

Subject: Tie between F0411 vouchers and F0413 checks


Question for AP experts:

If I have an AP check, in table F0413, and I want to know what vouchers in
F0411 that the check is paying, what are the keys between those two tables?
Or same question in the opposite direction. I don't see a tie, by looking
at
the fields in the tables. Does OW write nothing to F0411 vouchers when it
writes F0413 checks for the vouchers? Do I have to go to field PO purchase
order number and LNID purchase order line number? (Clumsy, and not cool if
have PO is received and vouched in partials.) That is the only answer I
see.

Dave Mallory Denver Water Denver, Colorado, USA 7332 SP13 NT
4.0 Oracle 8.05





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7832

+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +


________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp





________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp
 
In case others find this useful at some time, see below. Kumari Ou
[[email protected]] sent an e-mail to me and provided the essential
piece, and the answer is:

To get from voucher to check:
DOC (voucher num) in F0411 >>> DOC in F0414 >>> PYID in F0414 >>> PYID in
F0413 >>> DOCM (check num) in F0413
To get from check to voucher:
DOCM (check num) in F0413 >>> PYID in F0413 >>> PYID in F0414 >>> DOC in
F0414 >>> DOC (voucher num) in F0411

PYID payment ID ties F0413 checks and F0414 check detail together. F0414 has
the DOC (voucher number) but F0413 does not. So you go from voucher to check
detail to check, or the reverse.

Dave Mallory

>
 
David,

The F0413 is a header file that stores the total for a check to a particular payee. The RMPYID is the payment ID and the RMDOCM is the check #.

The F0414 is the detail file that stores all the vouchers paid on a particular check. It is joined to the F0413 by the RNPYID.

To see all vouchers on a particular check you could write a subquery similar to below:

select *
from jde_production.proddta.f0414
where rnpyid in (select rmpyid from jde_production.proddta.f0413
where rmdocm=yourcheck#)

The F0414 stores the AP document number in field RNDOC which ties to the F0411's RPDOC. (This is a little oversimpflied if you have multiple companies, make sure to join on the company and address # to be sure)
-------------------------------------------------
If you wanted to see the check for a particular voucher:

select *
from jde_production.proddta.f0413
where rmpyid in (select rnpyid from jde_production.proddta.f0414 where rndoc=theAPdocument#)

OneWorld will update the pay status to P (RPPST) in the F0411 once the check has been written and updated. It doesn't store the check# in the F0411.

Hopefully this helps some..

Eric
 
Back
Top