hello friends I am facing one issue
i run the Payment Process Request And Select 9 invoice for payment.
ok
now i am not complete the request i terminate the request
after that when i show the invoice status is "Selected For Payment"
Can u Plz help me friends
THANKS
NILETRA
Payment Issue In R12
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
It happens in Release 12 environment often,
What actually happens is, even though from front end , you have submitted the request for Terminating the PPR, the process some how does not complete successfully, therefore back end data remains the same....
you can cross check the status of the PPR from the back end... and make it cancelled
so that your invoices will be released.
This can be achieved by datafixes.
First Check the Status of your Payment Process Request from table,
Select * from AP_INV_SELECTION_CRITERIA_ALL where Checkrun_name = 'Your PPR Name'
This will display the the details of the PPR, in which under the column STATUS , verify whether it is CANCELED or not, if it is not cancelled, then perform the below datafixes to make the PPR cancelled and release the invoices
First to Release the invoices,
Delete from AP_SELECTED_INVOICES_ALL where Checkrun_ID = 'Your check run id for the PPR'
Second to remove the Payment references saved to your selected invoices,
update AP_SCHEDULED_PAYMENTS_ALL set Checkrun_ID = NULL where Checkrun_ID = 'Your check run id for the PPR'
Finally to change the status of the PPR to cancelled,
Update AP_INV_SELECTION_CRITERIA_ALL set Status = 'CANCELED' where Checkrun_name = 'Your PPR Name'
Now check the status of the invoices....
What actually happens is, even though from front end , you have submitted the request for Terminating the PPR, the process some how does not complete successfully, therefore back end data remains the same....
you can cross check the status of the PPR from the back end... and make it cancelled
so that your invoices will be released.
This can be achieved by datafixes.
First Check the Status of your Payment Process Request from table,
Select * from AP_INV_SELECTION_CRITERIA_ALL where Checkrun_name = 'Your PPR Name'
This will display the the details of the PPR, in which under the column STATUS , verify whether it is CANCELED or not, if it is not cancelled, then perform the below datafixes to make the PPR cancelled and release the invoices
First to Release the invoices,
Delete from AP_SELECTED_INVOICES_ALL where Checkrun_ID = 'Your check run id for the PPR'
Second to remove the Payment references saved to your selected invoices,
update AP_SCHEDULED_PAYMENTS_ALL set Checkrun_ID = NULL where Checkrun_ID = 'Your check run id for the PPR'
Finally to change the status of the PPR to cancelled,
Update AP_INV_SELECTION_CRITERIA_ALL set Status = 'CANCELED' where Checkrun_name = 'Your PPR Name'
Now check the status of the invoices....
-
- Posts: 44
- Joined: Tue Sep 09, 2008 10:58 am
- Location: India
Thanks for update.
I am facing similar issue. But I am unable to terminate the request from front end. Every time I reprint and try to record the status, it shows error as 'Null'.
I am unable to use the document for paying other invoices.
How can I terminate this request from front end?
Thanks,
Narayan
I am facing similar issue. But I am unable to terminate the request from front end. Every time I reprint and try to record the status, it shows error as 'Null'.
I am unable to use the document for paying other invoices.
How can I terminate this request from front end?
Thanks,
Narayan
Who is online
Users browsing this forum: Ahrefs [Bot] and 5 guests