Symptom
When filtering for a specific Tax Jurisdiction Code in the Tax Jurisdiction Work Center, the system is not fetching the information.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Order Work Center.
- Go to the Tax Jurisdiction View.
- In the Tax Jurisdiction Code column, filter for /VERTEX/ZZZZ (where ZZZZ represents the Tax Jurisdiction Code).
No results are displayed.
Cause
Currently all Views in the system, only displays the first 10,000 records are displayed.
The reason the Tax Jurisdiction Code /VERTEX/ZZZZ is not retrieved when filtering in the Tax Jurisdiction View is because the code /VERTEX/ZZZZ is not included within the first 10,000 records. To locate the Tax Jurisdiction Code /VERTEX/ZZZZ, a more refined search using the advanced filter functionality is necessary.
Resolution
In case a search is required to be performed to locate the Tax Jurisdiction Code /VERTEX/ZZZZ using the Advance filter, the following steps can be performed to enhance and speed up the search process:
- Go to the Sales Order Work Center.
- Go to the Tax Jurisdiction View.
- Select the Advance Search.
- In the Tax Jurisdiction Code, enter /VERTEX/ZZZZ (Do not select the option from the drop down of the field).
- Select Go.
The system should take a while to load the desired Tax Jurisdiction Code information.
See Also
KBA 1913181 - Slow Performance While Executing the Activities Query
KBA 3555292 - How to Correct the Postal Code Region Mismatch Error through the Tax Jurisdiction View
Keywords
tax jurisdiction code, performance, issue, dump, column , KBA , AP-SLO-SO , Sales Order , Known Error
SAP Knowledge Base Article - Public