Crystal Reports/Business Insights – Topic Details»
Crystal Reports (Intermediate) – Topic Details»
FRx Financial Reporter – Read more»
F9 Financial Reporter – Read more»
- Generating Business Insights Reports using Business Insights Reporter
- Modify Business Insights Reports and review Crystal layout
- Modify Existing MAS 90/200 Forms (AR Invoice) and Reports (AR Aging)
- Create New Reports using the Crystal Reports Wizard
- Create Selection Logic by date and customer
- Group Reports by Division, Salesperson, and Customer
- Create Sub-Totals by each Group
- Create Formulas for Gross Profit and Gross Profit Percentages
( This class expands on concepts covered in the basic Crystal Reports class and is only offered on demand. Special arrangements need to be made with Bennett/Porter).
- Grouping Report Data
- Applying Advanced Formulas
- Formatting and Conditionally Formatting Report Sections
- Parameter Masking
- File Linking
- Generating Sub-Reports
- Using Variables
(Financial Report Extender) FRx generates financial reports pulling Actual & Budget from MAS90/200/500. This course will instruct you to use rows which provide Titles, General Ledger accounts or segments, totals and calculations; columns which provide actual budget variance, %, Last year, divisions in columns, companies in columns, 12-month spreads of revenue, COGS, and expenses in columns & trees which provide roll-ups for any segments in any order. Budgets can be pulled from Excel and you can learn to export any report with transaction detail to Excel or other formats for distribution. We will review all of the features of the FRx Designer.
This class is offered on demand only and special arrangements need to be made with Bennett/Porter. This course is designed to provide attendees with an understanding of all of the functionality of the F9 program. Processes discussed in the class include GL and NGL Functions, BSPEC Functions, DESC and SDESC Functions, ACCTDATA and CODATA Functions, GLTRAN Functions. Additional tools include chart and list, zero suppress, analyze accounts, budget write-back and the Report Wizard. Excel commands that enhance F9 performance will also be discussed. These include check totals, charts and graphs, view manager, report manager, drop-down lists and simple macros.