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.

JDEtips University Registration and Course Pricing: Next available date: April 13-17, 2009.  Register Now.  Or contact Lori Stone, Training Administrator: 1.877.832.2594 ext 150 or Lori.Stone@ERPtips.com.

Onsite Courses: Available upon request. Please contact Sandy Acker, ERP Solutions Manager at 1.877.832.2594 ext 140 or Sandy.Acker@ERPtips.com.

CPE / CMA / CEU credits:  24-40 hours

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

Go to www.JDEtips.com/Register.asp to register for the next JDEtips University public class.

For more information on JDEtips training, please contact our ERP Solutions Manager, Sandy Acker, at Sandy.Acker@ERPtips.com or call Sandy Toll-Free (US and Canada): 1.877.832.2594 ext 140 or International: 1.972.964.1969.
 

If you have a general scheduling or Admin question about your class, please contact our Training Coordinator, Lori Stone, at Lori.Stone@ERPtips.com or call Lori at 1.877.832.2594 ext 150.