Open Item Account is not populated for Stale Payments in VCHR_ACCTG_LINE
On : 9.2 version, Payment ACTUAL BEHAVIOR --------------- Open Item Key is not populated for Stale Payments in VCHR_ACCTG_LINESTEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Setup Account with OIK . 2. Identify Unclaimed check SELECT PYMNT_ID, PYMNT_ID_REF, REMIT_VENDOR, PYMNT_DT, PYMNT_AMT, PYMNT_STATUS, RECON_STATUS FROM PS_PAYMENT_TBL AND RECON_STATUS <> 'REC' . 3. Run Mass Cancellation Process . 4. Verify Payment Status is updated from ‘P’ (Paid) to ‘L’ (Stale) . SELECT PYMNT_ID, PYMNT_ID_REF, REMIT_VENDOR, PYMNT_DT, PYMNT_AMT, PYMNT_STATUS, RECON_STATUS FROM PS_PAYMENT_TBL WHERE PYMNT_ID_REF in ('Mention Payment ID Reference'). |
0