Generate a Sales and Use Tax Report
Purpose: Use this document as a reference for how to run the Sales and Use Tax Query in ctcLink. The report will show accrued tax information.
Audience: Accounts Payable Staff
You must have at least one of these local college managed security roles:
- ZD_DS_QUERY_VIEWER
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
Generating a Sales and Use Tax Report
Navigation: Reporting Tools > Query > Query Viewer
- On the Query Viewer search page, enter Query Name in the Search By field.
- Enter QFS_AP_SUT_DETAIL_REPORT in the begins with field.
- Select Search. The Query page will display.
![Query Viewer page](https://media.screensteps.com/image_assets/assets/003/354/050/original/3f73e69a-a49a-4e3d-a198-61268b9716eb.png)
- On the Query Viewer page, select either the HTML or Excel link for the query named QFS_AP_SUT_DETAIL_REPORT. The QFS_AP_SUT_DETAIL_REPORT - Sales and Use Tax Report page will display.
![Query page](https://media.screensteps.com/image_assets/assets/003/354/052/original/b0f84f88-4e03-4107-afd1-f2437ed658b3.png)
- On the QFS_AP_SUT_DETAIL_REPORT - Sales and Use Tax Report page, enter or select the Business Unit.
- Enter the From Date.
- Enter the To Date.
- Select View Results.
![Parameter Entry page](https://media.screensteps.com/image_assets/assets/003/354/054/original/bf2f7f29-1263-4807-895d-1e97da286e6e.png)
- Vouchers that match your search criteria will be displayed along with a Sales and Use Tax Code, Tax Rate, Amount, and Description.
![Query results](https://media.screensteps.com/image_assets/assets/003/354/056/original/9ffc5375-f7c5-45c3-9e8f-268f9b1da9f5.png)
- Process complete.
0 Comments
Add your comment