Epicor Eagle Integration
FastQuery syncs with Epicor Eagle to give your team instant access to inventory data. This guide walks through the Compass report configuration that powers that sync.
FastQuery Daily Report
Section titled “FastQuery Daily Report”The daily report captures a full inventory snapshot. Set it up in Compass with the following columns:
- Dimensions >
Store(Click > Show Only > select your stores)
- Dimensions >
Item - Dimensions > Item >
UPC Code - Dimensions > Item >
Manufacturer - Dimensions > Item >
Mfg Part # - Dimensions > Item >
Tracula Rank(optional — required for Tracula integration) - Dimensions > Item >
Location - Dimensions > Item >
Location 2(optional) - Dimensions > Item >
Location 5(optional) - Dimensions > Item >
Popularity Code - Dimensions > Item >
Class Name(optional) - Dimensions > Item >
Current Vendor Name(optional) - Dimensions > Item >
Vendor Stock Number(optional) - Dimensions > Item > Inventory >
Retail Price - Dimensions > Item > Inventory >
Promotion Price - Dimensions > Item > Inventory >
Loyalty Promo Price(optional) - Dimensions > Item > Inventory >
Date Of Last Receipt - Dimensions > Item > Inventory >
Date Of Last Sale - Dimensions > Item > Inventory >
Date of Last Physical - Dimensions > Item > Inventory >
Order Point - Dimensions > Item > Inventory >
Minimum Order Point - Dimensions > Item > Inventory >
Maximum Stock Level - Dimensions > Item > Inventory >
Order Multiple(optional) - Dimensions > Item > Inventory >
Standard Package(optional) - Dimensions > Item > Inventory >
Discontinued Item? - Dimensions > Item > Inventory >
Store Closeout? - Dimensions >
Department - Dimensions > Item > Inventory >
Quantity On Hand - Measures > Inventory >
Quantity On Order - Measures > Inventory >
Quantity Committed(optional) - Measures > Inventory >
Last 12 Months Sales(optional)
FastQuery Realtime Report
Section titled “FastQuery Realtime Report”The realtime report tracks intraday QOH changes so FastQuery can reflect movements as they happen.
- Dimensions >
Store(Click > Show Only > select your stores)
- Dimensions >
Item - Dimensions > Item > Inventory >
Quantity On Hand
Filter
Section titled “Filter”- Measures > ITR Inventory >
QOH Change> Expression > Not Equal 0 > Add > Ok - Dimensions >
Date> Relative Dates > Today > Ok
Troubleshooting
Section titled “Troubleshooting”How to enable ITR Journaling
Section titled “How to enable ITR Journaling”ITR Journaling must be turned on for the realtime report to work.
How to enable the Compass Scheduler
Section titled “How to enable the Compass Scheduler”Your reports won’t run until the Compass Scheduler is started. See How to Enable the Compass Scheduler for a step-by-step walkthrough.