Events
Interested in learning more? Take a look at the schedule of upcoming events we have planned. If you can’t attend an event in person, we regularly host webinars to share our knowledge and experience with Epicor Kinetic ERP and how together we can help your business. Hope to see you soon!
- This event has passed.
Event Navigation
Six S Partners Online Classroom Training – Advanced BAQ’s and Dashboards « July 9, 2020 @ 12:30 pm - 4:30 pm EDT
$295Register Here
Six S Partners is pleased to offer Advanced BAQ’s and Dashboard online classroom training.
Need to get information from your ERP system that you can’t find on any reports? Would you rather have a view tailored to your role in real time instead of a static report? Need a way to get this data out for further analysis?
Tap into the most valuable tools that came with your Epicor system – Business Activity Query (BAQ) and Dashboards.
Our BAQ foundations course was a huge sucess and there were many requests to do an ADVANCED course.
This advanced class is designed for users who have already been exposed to BAQ’s and are ready to use Epicor’s built in tools to data mine those hidden secrets.
Agenda includes:
1. Advanced (compound) Criteria
2. Calculated Fields
3. Grouping / Aggregates
4. Advanced Relationships (casting)
5. SubQueries
- Basics
- SubQuery Options (Result Set Rows, Top Clause / Distinct / Ties, Offset / Fetch, Subquery type: toplevel and inner, Unions, CTE
- SubQuery Criteria (Having clause)
- Pivots
- Updatable Queries
- Overview
- Column Mapping
- BPM update (Selecting Business Object, Selecting Tables)
- Adding BPM logic
- Advanced BPM Update
- Actions
- Add New Record
- MultiRow Update