Finance Training Course Query List (1/28/2021)

Purpose:  This document provides a list of queries that are mentioned in Finance Canvas training courses.

Audience:  Finance staff.

Each foldable section below corresponds to a single Finance Canvas training course.  

Within each foldable section, you'll find a list of hyperlinked query names, titles, and output samples. Click on the hyperlinked query name to open, in a new window, the Canvas course module that contains the query.

Expand or collapse content AM100 Asset Management
CTC CNV ASSET VALIDATION Sample
CTC CNV DEPR VALIDATION Sample
Expand or collapse content AP100 Accounts Payable

 This course does not contain any queries.

Expand or collapse content AR100 Accounts Receivable
AR SPEEDTYPES Sample
QFS AR DIRECT JOURNAL PAYMENTS Sample
QFS AR ITEM DST GL Sample
QFS AR PAYMENTS BI Sample
QFS AR PAYMENT STATUS Sample
QFS AR PENDING ITEMS Sample
QFS GL AR ACCTG LINE Sample
Expand or collapse content AR200 Intermediate Accounts Receivable

 This course does not contain any queries.

Expand or collapse content BI100 Billing
AR CUSTOMER ACTIVITY Sample
CTC AR AGING BY CUST NAME Sample
CTC JRNL LN PC ACT Sample
CTC PC PROJ RESOURCE Sample
CTC PR BILLABLE Sample
CTC PR BILLED Sample
CTC PR OLT ROWS Sample
QFS AR DIRECT JOURNAL PAYMENTS Sample
QFS AR ITEM DST GL Sample
QFS GL ACCT ANALYSIS Sample
QFS GL ACCT DETAILS Sample
QFS GL CAPC ACCTG LINE Sample
QFS GL CAPC ACCTG LINE EXCEPT Sample
QFS GL CA ACCTG LINE Sample
QFS GL AC ACCTG LINE SUM Sample
QFS GL LEDGER FOR PROJECT Sample
Expand or collapse content BI200 Intermediate Billing
CTC PR OLT ROWS Sample
Expand or collapse content CN100 Customer Contracts
CTC PC PROJ RESOURCE Sample
Expand or collapse content CT100 Treasury (Cash Management)
FG1004 HIGH VALUE PAYMENTS Sample
FG1003 PAYMENT TYPE STATISTICS Sample
FG1000 PAYMENT ACTIVITY Sample
FIN3004 ACCOUNT REGISTER Sample
FIN3002 AUTORECON ERRORS Sample
FIN3001 AUTORECON EXCEPTIONS Sample
TRC1000 ACCOUNTING ENTRIES Sample
TRX3008 RESETS Sample
Expand or collapse content EX100 Travel & Expenses: Traveler/General User

 This course does not contain any queries.

Expand or collapse content EX101 Travel & Expenses: Approver

 This course does not contain any queries.

Expand or collapse content EX102 Travel & Expenses:  Travel Admin/Finance

 This course does not contain any queries.

Expand or collapse content EX200 Intermediate Travel & Expenses: Travel/General User

 Coming Soon!

Expand or collapse content EX202 Intermediate Travel & Expenses: Travel Administrator

 Coming Soon!

Expand or collapse content GL100 General Ledger Basics
GLC7501 TOTALS Sample
LEDGER Sample
Expand or collapse content GL200 Intermediate General Ledger

 This course does not contain any queries.

Expand or collapse content GL300 Advanced General Ledger

 This course does not contain any queries.

Expand or collapse content GR100 Grants
CTC CO GRANT EXP RPT Sample
CTC CO GRANT EXP RPT1 Sample
QFS CO GRANT BY EMPLID Sample
QFS CO GRANT EXP RPT Sample
QFS CO HR ACCTG LINE EE DIST Sample
QFS CO HR ACCT LINE PAY PERIOD Sample
Expand or collapse content GR200 Intermediate Grants
QCS SF STDNT GRP PAYMENT DETAILS Sample
Expand or collapse content KK100 Commitment Control Basics
QFS KK OPEN ENCUMBRANCE Sample
Expand or collapse content PC100 Project Costing
CTC JRNL LN PC ACT Sample
CTC PC PROJ RESOURCE Sample
CTC PR BILLABLE Sample
CTC PR BILLED Sample
CTC PR OLT ROWS Sample
QFS GL LEDGER FOR PROJECT Sample
Expand or collapse content PU100 Purchasing - Requisitions

  This course does not contain any queries.

Expand or collapse content PU101 Purchasing - Purchase Orders

   This course does not contain any queries.

Expand or collapse content PU102 Purchasing - Receipts and Maintenance

    This course does not contain any queries.

Expand or collapse content PU103 Purchasing (P-Card)

   This course does not contain any queries.

0 Comments

Add your comment

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