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
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