You have nothing
in your basket

Sage 50 Accounts Report Designer training course

Sage 50 Accounts Report Designer is a two-day course. Our price is £279.00 (Sage's RRP is £535.00).

» Overview: Use Sage 50 Accounts Report Designer to fully customise your reports and layouts.

» What do I learn?

Become an expert at amending and creating reports/layouts, adding totals, filters and also ranges for more specific analysis.

» By the end of this course you will:

Know how to create new reports using the report wizard, amend fixed reports, select variables, sort information and amend the page layout
Be able to insert calculations into a report and change the presentation of information
Know how to improve presentation by adding sub-totals and grand totals
Understand how to add filters to a report to select specific information
Be able to split debits and credits and produce meaningful transaction totals
Know how to add ranges to a report
Be familiar with selection filters, advanced filters and advanced criteria
Know how to create overdue account letters and sales promotions using specific criteria and expressions
Know how to amend an existing invoice layout or create one from scratch

Create your own high-impact layouts that incorporate data from Sage 50 Accounts. This will ensure you can easily present vital information in ways that meet specific requirements. Also learn how to amend existing stationery layouts to fit in with your own business needs.

Who should attend? users of Sage 50 Accounts v2007(v13) and onwards (for those on Sage Line 50 v12 or below we suggest our onsite training).

» Detailed course content

Click to see the course content

Session 1 - Introduction To Report Design and Amending Existing Reports

Amending Existing Reports
Panes
Locating and adding variables
Using Active Complete
Saving Reports

Session 2 - Creating a New Report - Manually

The Design Screen
Resizing sections
Formatting and assigning styles
Editing in preview mode

Session 3 - Creating a New Report - Using the Wizard

Using the Design Wizard
Multiple Sorts

Session 4 - Expressions and Snippets

Wrapping Text and auto grow
Adding an Expression
Creating Snippets
Formatting Numeric Variables

Session 5 - Grouping and Totalling Data

Adding Groups
Adding Subtotals
The 'Keep Together' Function

Session 6 - Grouping Data Using the Wizard

Audit Header, Split and Usage Tables
Adding Groups and Totals Using the Wizard
Totalling an Expression
Suppressing Duplicates

Session 7 - Using Report Filters

Creating Filters
Shortening large filters
Using filters for checking purposes

Session 8 - Editing Group Functions

Character Breaks
Producing a Trial Balance
Filtering Zero Values

Session 9 - Adding Criteria

Using Criteria
Adding New Criteria
Printing Criteria on the Report
Adding a New Report Header
User Defined Criteria

Session 10 - Applying Multiple Sub-totals

Adding subtotals to additional groups
Dealing with unwanted sections
Utilising the count function
Moving groups

Session 11 - Conditional Properties

Conditional Formatting
Advanced Conditional Formatting
Creating drillable reports

Session 12 - Joining Tables

Adding Tables
Performing A Join
Adding Data From The New Table

Session 13 - Layouts and Letters

Invoice layouts
Inserting pictures
Emailing reports
Secure PDF
Creating letters
Bar code labels

Sage 50 Accounts Report Designer course Appendix

List of values for common coded variables

Book now

Course	Centre	Start date	Duration	Total places	Available places	Book
Sage 50 Accounts Report Design	Birmingham	13/02/2012	2 days	12	10
Sage 50 Accounts Report Design	N.London	21/02/2012	2 days	12	10
Sage 50 Accounts Report Design	Croydon	27/02/2012	2 days	12	3
Sage 50 Accounts Report Design	Glasgow	27/02/2012	2 days	12	9
Sage 50 Accounts Report Design	Manchester	08/03/2012	2 days	12	5
Sage 50 Accounts Report Design	N.London	15/03/2012	2 days	12	7
Sage 50 Accounts Report Design	Croydon	19/03/2012	2 days	12	10
Sage 50 Accounts Report Design	Newcastle	26/03/2012	2 days	12	10
Sage 50 Accounts Report Design	Bristol	29/03/2012	2 days	10	5
Sage 50 Accounts Report Design	Leeds	29/03/2012	2 days	12	11
Sage 50 Accounts Report Design	Birmingham	02/04/2012	2 days	12	12
Sage 50 Accounts Report Design	Croydon	10/04/2012	2 days	12	12
Sage 50 Accounts Report Design	Reading	12/04/2012	2 days	10	9
Sage 50 Accounts Report Design	N.London	23/04/2012	2 days	12	12

Sage 50 Accounts Report Designer is a two-day course. Our price is £279.00 (Sage's RRP is £535.00).

You can book your course in several ways:

Online: Just click the "Book now" button (your payment will only be processed after we have booked your course with Sage).
Phone: Just call 0845 009 3990 to pay by card or arrange BACS or cheque payments.
Use the contact form: Click here and fill out the contact form.

Important notes about booking your Sage classroom training course

When booking a course online, if the course is not for the paying cardholder, please enter the name it should be booked for in the notes section when paying.
If a vegetarian meal is required instead of the standard meal provided, please enter this in the notes section as well.
If a course is showing no availability it is still worth contacting us as there maybe cancellations or the possibility of switching the course to a bigger room.
Also note that the number of available places given is updated regularly, but it is not live, so it's always best to ask us for the latest availability if the number of available places is running low.
*for all courses except Instant Accounts, which is £215 and Payroll Year End, which is £190.

Sage 50 Accounts Report Designer training course

Book now

Other relevant links