Vendor Payment Not Posted

Synopsis:  Payout is not processed for a specific vendor. Need to check data for more details

Example TIcket Regarding:

N/A

Solution:

Log into our DB2 system and check the invoice information.

Check that the invoices have been paid by querying the R60FILES.ZAPTRAN file. An invoice is paid if the AETYPE='PA'.

Review records by invoice or voucher for oddities. Compare to a processed record(example queries below)

//By Voucher #'s

SELECT * FROM R60FILES.ZAPTRAN  LEFT JOIN R60FILES.ZAPPAYB  on AFVOCH=AEVOCH LEFT JOIN R60MODSDTA.VXBLVTRN ON AEINV=LVINV# and AEVEND=LVVDR# WHERE AEVOCH in (5295696, 5291690,5291689);

//By Invoice #'s

SELECT * FROM R60FILES.ZAPTRAN  LEFT JOIN R60FILES.ZAPPAYB  on AFVOCH=AEVOCH LEFT JOIN R60MODSDTA.VXBLVTRN ON AEINV=LVINV# and AEVEND=LVVDR# WHERE AEINV in ('1074676','1065145','1064294');

If they have been paid the next thing to verify is that the EP contact exists if the payment type is CC

Next check if the vendor master and the voucher 1099 Flag [y/n] match. Which is required in order for the voucher to pay.