9.2 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.

AM100 Asset Management
CTC CNV ASSET VALIDATION Sample
CTC CNV DEPR VALIDATION Sample
AP100 Accounts Payable

 This course does not contain any queries.

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
AR200 Intermediate Accounts Receivable

 This course does not contain any queries.

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
BI200 Intermediate Billing
CTC PR OLT ROWS Sample
CN100 Customer Contracts
CTC PC PROJ RESOURCE Sample
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
EX100 Travel & Expenses: Traveler/General User

 This course does not contain any queries.

EX101 Travel & Expenses: Approver

 This course does not contain any queries.

EX102 Travel & Expenses:  Travel Admin/Finance

 This course does not contain any queries.

EX200 Intermediate Travel & Expenses: Travel/General User

 Coming Soon!

EX202 Intermediate Travel & Expenses: Travel Administrator

 Coming Soon!

GL100 General Ledger Basics
GLC7501 TOTALS Sample
LEDGER Sample
GL200 Intermediate General Ledger

 This course does not contain any queries.

GL300 Advanced General Ledger

 This course does not contain any queries.

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
GR200 Intermediate Grants
QCS SF STDNT GRP PAYMENT DETAILS Sample
KK100 Commitment Control Basics
QFS KK OPEN ENCUMBRANCE Sample
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
PU100 Purchasing - Requisitions

  This course does not contain any queries.

PU101 Purchasing - Purchase Orders

   This course does not contain any queries.

PU102 Purchasing - Receipts and Maintenance

    This course does not contain any queries.

PU103 Purchasing (P-Card)

   This course does not contain any queries.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

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