Advanced Excelerator for Unit4 ERP

Duration: 1 Day

Level | Getting Advanced

This course builds on the Excelerator basics course by introducing additional functionality that enables you to improve the efficiency and use of Excelerator reports. The course covers topics such as templates, running reports on the server, output split and email split. Postback, pivot reports and creating mulit query reports and reports from an .RERX file.

Summary

This course is intended to provide you with an introduction to the advanced functionality of Excelerator for extracting data from Unit4 Business World and producing printed reports. It shows you how to create and run template reports, run reports on the server, produce multi query reports, produce reports from an .RERX file, how to split report output and how you can use the Post Back functionality to post transactions.

Learning outcomes

The objectives of the course are to help you:

• Develop an advanced understanding of the scope and functionality of Excelerator reports
• Understand the how to create, run, produce queries and reports from an .RERX file.
• Be able to split report outputs and how you can use the Post Back functionality to post transactions.

Delegate pre-requisites

Before starting this course, users should have an understanding of Excelerator basics.

Who is it for?

• Accounts Payable Clerk
• Accounts Payable Manager
• Accounts Receivable Clerk
• Sales Order Clerk
• HR Analyst
• System Administrator

Language

Interactive workshop with an experienced consultant. All Embridge Unit4 courses are currently delivered in English.

Course Structure

Session 1

Creating a report template and Management Report Pack

Session 2

Adding and Running a report from a Web Menu and Splitting the Output

This session demonstrates how to run an Excelerator report from within Unit4 ERP web, split the output and email the report.

Session 3

Creating an Excelerator from a.RERX file

This session we will create an information browser and generate a pivot table report.

Session 4

Create a pivot table report

In this session we will create an information browser and generate a pivot table report.

Session 5

Multi Query Reports

This session demonstrates the use of multi queries within one report. This enables you to display data in multiple ways or extract data from different sources.

Session 6

PostBack

Premium Education training subscription

Part of the College of Reporting and Technical

Premium Education training is a people-centric approach to driving training and development by always learning; learning all ways. Our subscription-based training services gives the employee and employer a suite of Unit4 training allowing the flexibility to empower your employees for effective, efficient, and proficient use of technology and solution platforms at their fingertips.

More details about Premium Education will be coming soon. Watch this space!

In the mean time if you would like to know more email enquiries@embridgeconsulting.com

Cancellation policy

All courses are delivered virtually, price per person plus VAT. On site training is available on request. Please read our cancellation policy and booking terms and conditions before checkout.