Issue:
Unable to validate invoice where the item line has a withholding tax group due to:
APP-SQLAP-10000: ORA-01403: no data found occurred in
with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs.
Solution:-
This error is caused because when the invoice is validated the system tries to create the automatic withholding invoice yet there is no Payment Term associated with the Supplier (Tax Authority) site. Since the invoice could not be created without this, the validation fails.
1. Navigate to Supplier form
Payables > Suppliers > Entry
2. Query the Supplier/Tax Authority linked to the withholding group on the problematic invoice
Click Update
Select the Key Payment Setup tab
3. Scroll to the Payment terms section and add a Payment Term to the Tax Authority for that Vendor Site.
4. Retest the issue
Unable to validate invoice where the item line has a withholding tax group due to:
APP-SQLAP-10000: ORA-01403: no data found occurred in
with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs.
Solution:-
This error is caused because when the invoice is validated the system tries to create the automatic withholding invoice yet there is no Payment Term associated with the Supplier (Tax Authority) site. Since the invoice could not be created without this, the validation fails.
1. Navigate to Supplier form
Payables > Suppliers > Entry
2. Query the Supplier/Tax Authority linked to the withholding group on the problematic invoice
Click Update
Select the Key Payment Setup tab
3. Scroll to the Payment terms section and add a Payment Term to the Tax Authority for that Vendor Site.
4. Retest the issue