AP voucher archive related vouchers/journal vouchers not archiving issue
Hello, we are using the delivered AP Voucher Archive query AP_ARCHIVE_VOUCHER_BU in PS 9.1.
We have several vouchers not archiving that did not fall into any of the known archive exceptions, and a big chunk of them are Journal vouchers. We found that at least some of them have related vouchers, and this is how they are not getting picked up by the query:
SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, TO_CHAR(A.INVOICE_DT,'YYYY-MM-DD'), A.IN_PROCESS_FLG, A.MATCH_ACTION, A.MATCH_STATUS_VCHR |