Run the below SQL Query. The invoice Status will be changed automatically to "Validated"
update ap.ap_payment_schedules_all
set checkrun_id =''
where invoice_id ='57553'-- Give your Invoice_ID
and checkrun_id ='34564'--- Give your Checkrun_ID
Now you cancel the invoice or You can make the Payment for the invoice.
update ap.ap_payment_schedules_all
set checkrun_id =''
where invoice_id ='57553'-- Give your Invoice_ID
and checkrun_id ='34564'--- Give your Checkrun_ID
Now you cancel the invoice or You can make the Payment for the invoice.
ReplyDeleteIt's very nice of you to share your knowledge through posts. I love to read stories about your experiences. They're very useful and interesting. I am excited to read the next posts. I'm so grateful for all that you've done. Keep plugging. Many viewers like me fancy your writing. Thank you for sharing precious information with us. Get for more information online invoice management software