Script to change the payment date for a PPR that is in status Review
Hello Experts;
Currently pen PPRs will prevent us from closing the period. we have to either complete the PPR or terminate it.
when closing period, we have around 425 invoices taht are in status selected for payment.
Payable clerk need to cancel theses PPR and re-enter thoses PPR manually. can we run un sql to update the Check_date ?
some think like: Update AP_INV_SELECTION_CRITERIA_ALL
SET CHECK_DATE = xxxx
where CHECKRUN_NAME like '%ESS BOA EUR 6-01-23 TM% and Status ='PREVIEW'
We only need to sweep period for PPR taht are in status Preview
0