• Publish date: August 31, 2021

  • Last update: October 01, 2021

Available languages

English, Vietnamese, Chinese

If you are seeking to gain a more practical understanding of Infor Query & Analysis, this course is for you. Learn how to effortlessly create reports, import data, and dive into essential areas of this powerful reporting and querying tool in this course.

About IQA-1- Infor Q&A 11 Basic

  • Infor Q&A is a business intelligence software solution capable of enabling users to access, analyse, and report on enterprise data. It is designed to help users make informed business decisions by providing easy-to-use tools for querying, analysing, and visualising data from multiple sources.

  • This IQA-1 course covers all the basics of Infor Q&A, including logging in and out, using extraction definitions to create basic and templated reports, and importing data using templates.

Who should take this course?

  • SunSystems Users

    Infor Q&A is a SunSystems component. Learners who use SunSystems and have taken related courses should also consider taking Infor Q&A courses to gain a deeper understanding.

  • Accountants

    Infor Q&A courses are similarly beneficial to other GEN courses for accountants who use SunSystems frequently.

In this course, you will learn…

Upon completion, you will have the ability to effortlessly log in and out of Q&A, utilise its four extraction definitions to generate basic reports, execute templated reports, and use the import template with ease.
  • Chapter 1 – Welcome

  • Chapter 2 – Foundation

    This chapter delves into the fundamentals, from logging in and out of the system to resetting your password and other nifty tricks.

  • Chapter 3 – Extracting Data

    In this chapter, you will learn how to extract data from a source using four methods: Summary Link, Summary Report, Detail Report, and Reference Link; each has a unique function. The chapter also includes downloadable template reports with Infor Q&A formulas.

  • Chapter 4 – Running Reports

    In this lesson, learners will learn to use two standard Excel functions, Macros and Recalculate, to recalculate debtor inquiries and produce various critical financial reports.

  • Chapter 5 – Import Templates

    This chapter focuses on two ways to import your own report templates into Infor Q&A and two processing modes: real-time and manual.

Why take this course?

This course is fundamental for building up your knowledge and getting you ready for more advanced courses in the future.

  • For any accountant seeking to extract, analyse, and visualise data for informed decision-making, Infor Query and Analysis is an indispensable tool.

  • Infor Q&A's Recalculate tool streamlines recurring tasks and ensures accurate and timely reports. Additionally, the course also covers importing report templates such as Ledger Import and Budget Import.

  • This course is fundamental for building up your knowledge and getting you ready for more advanced courses in the future.

Courses to take after completing IQA-1

  • Learn more about Infor Q&A:

    • IQA-2 Infor Q&A 11 Advanced

    • IQA-3 Infor Q&A: Setting up Web-enabled User Management

    • IQA-4 Infor Q&A: Setting up DataLink Server

  • Courses about Financial Management:

    • GEN-2 Infor SunSystems V6.4 Login/Logout or GEN-22 Infor SunSystems Cloud Foundation

    • GEN-3 Infor SunSystems V6.4 Financials GL or GEN-23 Infor SunSystems Cloud Financials GL

  • More Courses about Financial Management:

    • GEN-4 Infor SunSystems V6.4 Financials Accounts Payable or GEN-24 Infor SunSystems Cloud Financials Accounts Payable

    • GEN-5 Infor SunSystems V6.4 Financials Accounts Receivable or GEN-25 Infor SunSystems Cloud Financials Accounts Receivable

  • Learn more about TRG Academy:

    TRGA-01 TRG Academy

Course curriculum