COURSE OUTLINE:

COURSE: ACCPAC ERP : FINANCIAL REPORTER This course covers the reporting capabilities of the Financial Reporter and explains how to produce financial statements from the data stored in the general ledger. The Financial Reporter is a powerful reporting tool that uses Microsoft Excel to manipulate, format, graph, and print general ledger data. The Financial Reporter adds Sage Accpac-specific functions and commands to Excel which allows it to read General Ledger data. Once the data is in a worksheet, the Financial Reporter uses Excels Formatting and printing capabilities to produce the statement. TIMES: 09:00 - 16:00 DURATION: 1 Day VENUE: AccTech Academy : Rivonia COURSE TYPE: Hands-on, Instructor lead GROUP SIZE: Grouped according to skill level with a maximum number of 8 delegates COURSE DOCUMENTATION: Accpac ERP : Financial Reporter User guide User Competency Assessment Certificate of competence TARGET AUDIENCE: Not specified PREREQUISITES: Basic understanding of MS Excel 2007 and working knowledge of windows. INCLUSIONS: Light lunch and refreshments COST PER DELEGATE: (Group Max = 10) Group of 5:    ZAR 1500.00p/p FOR BOOKINGS: Contact Elmien Diedericks or Ronlee Amien training@acctech.biz HIGH LEVEL COURSE OUTLINE: Financial Reporter Features Report data Data selection criteria consolidating accounts Financial Reporter menu commands Financial reporter functions How to produce financial statements Editing and creating financial reports Using formulas to retrieve GL data Using Financial Reporter to insert formulas Writing report specifications Layout of a report specification Controlling overall financial statement formats Specifying GL Information in columns Specifying accounts and totals in statement lines Specifying selection criteria Consolidating account ranges Handling rounding on reports For more information please contact Elmien at our Centurion office +27 (12) 664 0200 or contact Ronlee at our Rivonia office +27 (11) 803 7327.

Print this page