• Publish date: August 31, 2021

  • Last update: October 01, 2021

Available languages

English, Vietnamese, Chinese

Deepen your Infor Q&A skills with IQA-2, where you will explore Infor Q&A's advanced features, such as Ledger Import, Excel field mapping, and Drill Down function. Start your journey towards becoming proficient today!

About IQA-2- Infor Q&A 11 Advanced

This course focuses on equipping you with the skills and techniques needed to maximise the full potential of Infor Q&A for advanced reporting and analysis.

  • In the previous lessons, we learned all the fundamental yet essential features of Infor Query & Analysis (Q&A).

  • In this IQA-2 Infor Q&A Advanced course, get ready to up the ante and deepen your Infor Q&A skills as we dive deeper into the advanced.

  • During this course, you will explore more complex features and functionalities of Infor Q&A and harness its advanced capabilities, such as Ledger Import to validate and post journals, mapping Excel fields to SunSystems Ledger Entry fields, and using the Drill Down function in data extraction queries.

  • It also covers Infor Q&A utilities such as Breakout, Expand, and Drill Path Manager.

Don't miss out on the opportunity to enhance your skills. Enrol in the IQA-2 today!

Who should take this course?

  • Fundamental Concepts

    IQA-2 Infor Q&A Advanced is designed for individuals who have completed the IQA-1 Infor Q&A Foundation course or possess a solid understanding of the fundamental concepts and functionalities of Infor Q&A.

  • SunSystem Users

    Similar to IQA-1, IQA-2 is a great complement to SunSystems-related courses or for SunSystems users, as it covers more fundamental and advanced knowledge in depth. All aim to help accountants work more efficiently.

In this course, you will learn…

To import various types of data into SunSystems, such as Chart of Accounts Codes, Analysis Codes, and transactional data, it is essential to have multiple import templates. In this course, you will learn to achieve that goal, plus learn how to customise import files, drill down in reports, and utilise various utilities to make generating reports or importing data into SunSystems even more convenient.
  • 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 – Data Send

    This chapter covers how you can leverage our provided templates and the Send Data function to send multiple types of data from an Excel spreadsheet directly into SunSystems.

  • Chapter 4 – Drill Down

    This chapter introduces you to how to do Summary and Transaction drill downs as well as what else you can do with the Drill Down function in Infofr Q&A.

  • Chapter 5 – Macros

    This chapter focuses on Macros, what types of Macros are supported in Infor Q&A, and how to create and run them.

Don't miss out on the opportunity to enhance your skills. Enrol in the IQA-2 today!

Why take this course?

  • Infor Q&A offers powerful tools for data extraction and import directly into SunSystems, including the Data Send function for sending multiple data types.

  • You will learn all the steps needed to achieve that and more. For instance, customising import files, creating import templates, Excel spreadsheet mapping, and drilling down to any amount, just to name a few.

  • Explore the convenience of Infor Q&A and get used to the increased productivity you will soon witness by enrolling and completing IQA-2 today!

Courses to take after completing IQA-2

  • Learn more about Infor Q&A:

    • 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