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

  1. On the Query Viewer search page, enter Query Name in the Search By field.  
  2. Enter QFS_AP_SUT_DETAIL_REPORT in the begins with field.  
  3. Select Search. The Query page will display.
Query Viewer page
  1. 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
  1. On the  QFS_AP_SUT_DETAIL_REPORT - Sales and Use Tax Report page, enter or select the Business Unit.
  2. Enter the From Date.
  3. Enter the To Date.
  4. Select View Results.
Parameter Entry page
  1. Vouchers that match your search criteria will be displayed along with a Sales and Use Tax Code, Tax Rate, Amount, and Description.
Query results
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.