Enterprise Report Writing I -3-5 days
This 3-5 day JDEtips workshop allows power users to gain an in-depth understanding of the functionality of the EnterpriseOne ERW report writing tool. Students will learn the basics of how to work within OMW (Object Management Workbench), and be able to create simple reports. An introduction to event rules is also included. Day 4 is optional and includes the features of Financial Report Writer, described below. An optional 5th day covers advanced ERW features
Required for
- Enterprise Report Writing II - 3 Days
Course Detail
Basic ERW –Topics Covered (Days 1-3)
Overview and introduction to RDA (Report Design Aid) tool and the 7 different section types
- Introduction to OMW (Object Management Workbench)
- Creating and modifying Columnar sections
- Creating and modifying Group sections
- Creating Level Break Headers
- Creating Level Break Footers
- Creating Report Headers and Footers
- Creating Sub-Section Joins
- Understanding Version Overrides and Version Design
- Check in and Check out, report template and versions
- Creating Event rules for Columnar and Group sections
- Creating a Tabular section in a non-financial application
- Enabling Drill down within a tabular section (non-financial)
- Creating Event rules for Tabular Sections
FRW -- Financial Report Writing -- optional add on to ERW I (Day 4)
Prerequisite: ERW – Basic Report Writing
Expectation: Upon completion of this additional day, the accounting & finance users will be able to write financial reports utilizing: Smart Fields (for year to date and period activity totals), Level of Detail roll-up, Drill Down, and be able to work with the Standard Financial Processing Option Template.
Topics Covered
- Introduction to Smart Fields and the Financial Wizard
- Setting level of detail roll-up
- Setting Financial Drill Down
- Creating special interim totals utilizing AAI’s
- Creating rolling monthly spreadsheets
- Utilizing a business function within event rules to create date titles
- Creating hard coded rows manually
- Creating hard coded rows by utilizing ‘auto row generation’
- Creating cell override calculations
Advanced ERW Topics – optional add on (Day 5)
- Create Custom Processing Option Templates
- Create Event Rule logic to support the processing option template
- Create Business Views, single table and multiple table joins
- Conditional sections
- Utilizing Table I/O functionality
- Advanced Event Rule logic utilizing System Functions, Business functions, Event rule variables
Topics Covered
- Introduction to Smart Fields and the Financial Wizard
- Setting level of detail roll-up
- Setting Financial Drill Down
- Creating special interim totals utilizing AAI’s
- Creating rolling monthly spreadsheets
- Utilizing a business function within event rules to create date titles
- Creating hard coded rows manually
- Creating hard coded rows by utilizing ‘auto row generation’
- Creating cell override calculations
Dates for this topic
| Date | Place | Vacancies | Registration |
|---|---|---|---|
| 27.–29.09.2010 | Utrecht - Netherlands | 8 | Register now |
| 27.–29.09.2010 | Hannover - Germany | 5 | Register now |