Navigating FMS nQuery - FTNQO

This course is a requirement for FMS Live reviewer certification. Get an introduction to FMS nQuery, UBC's read-only financial database. Delivered online through Connect, this course provides information and helpful hints on how to efficiently navigate within FMS nQuery. This course is available to staff with financial responsibilities in FMS certified and non-certified departments.

The course covers instructions on how to run ledger summaries, and how to look up information, such as:

  • chartfields, speedcharts and project/grants
  • vendor information
  • accounts payable transactions
  • Purchase Order details
  • general ledger transactions
  • payroll information.

Navigating FMS nQuery is available online through Canvas. You will need a CWL ID to access the course.

Registration is on a monthly basis. After registering for your chosen session, you will receive an automated confirmation email.

A second email will be sent to you from Finance Training after your registration is received from the system (usually within 24 hours). The second email contains your login instructions to Canvas.

Expect to take approximately 2 hours to complete the reading material, quiz and short survey. In order to receive credit for completing this course, participants must score 80% or better on the quiz.

Important: Please complete the quiz within the same month as your registration. For example, if you register in May, you must take the quiz in May. If you are unable to take the quiz in the same month as your registration, send an email to, asking to be dropped from the course.

Recommended reading prior to course:

Available to:

  • Personnel with reviewer responsibilities in FMS certified departments (required)
  • Personnel with financial responsibilities in non-certified departments (recommended)
  • Personnel interested in learning more about the FMS nQuery system, for professional development