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 3(optional) - Dimensions > Item >
Location 5(optional) - Dimensions > Item >
Popularity Code - Dimensions > Item >
Class Name(optional) - Dimensions > Item >
Class Code(optional) - Dimensions > Item >
Fineline Name(optional) - Dimensions > Item >
Fineline Code(optional) - Dimensions > Item >
Date Added(optional) - Dimensions > Item > Inventory >
Date Last Retail Change(optional) - Dimensions > Item >
Current Vendor Name(optional) - Dimensions > Item >
Current Vendor Code(optional) - Dimensions > Item >
Vendor Stock Number(optional) - Dimensions > Item > Inventory >
Retail Price - Dimensions > Item > Inventory >
Promotion Price - Dimensions > Item > Inventory >
Average Cost(optional) - 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 Name - Dimensions >
Department Code(optional) - 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
One Realtime report per store is the simplest setup, and what we recommend. For the Realtime report only (the ITR Journaling QOH-change feed described in this section — not the Daily report), FastQuery also accepts a single upload that covers several stores at once, so if you already manage your exports that way you can send one combined file instead of one per store. It changes nothing about the result. This is an advanced option — if combining the stores into one file isn’t already something you know how to do, you don’t need it. Keep one Realtime report per store, and keep the Daily report one per store regardless.
Inventory-update alerts (store hours)
Section titled “Inventory-update alerts (store hours)”FastQuery can alert you when the inventory feed goes quiet — no updates for longer than you’d expect. To keep those alerts honest, set them to your store’s real hours so you’re not pinged when the store is simply closed.
On the Epicor Eagle integration page, set:
- Open and close times — the hours your store is actually trading.
- Time zone — the store’s local time zone, so open and close are read correctly.
- Alert me if there are no updates for N minutes — how long the feed can stay quiet during open hours before FastQuery flags it.
Leave the “no updates for N minutes” field blank to turn these quiet-period alerts off entirely.
With this set, a closed or naturally quiet store won’t trigger a false “feed down” alert — you only hear about it when an update gap happens during the hours you’d expect data to be flowing.
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.