Hello, I am trying to find or create a report that shows our on time delivery to our customers. does anyone know if epicor comes with a report or has created something?

No. Don’t think so. I had to create the Dispatch in full on time report. I can’t say it is Delivery in full on time report because once the goods are on the truck, it is out of our hands and we do not record the actual delivered date. Create a BAQ report and compare the Ship By (Sales Order) and th…

Because most companies measure OTD differently, this is best done from a dashboard with your own BAQ. Questions: What dates are we comparing? Is the whole order either on time or late OR each line? Do you have grace days?

the ship by date, by release we only give our selves 1 day grace period, any thoughts?

You should be able to compare the Release’s ShipByDate to the ShipHead.ShipDate (assuming that your users don’t back date it) though the ShipDtl table in a BAQ then.

There is an executive dashboard under Executive Analysis > ShopVision, called Customer Shipping Performance. You could run the process that updates the dashboard and then see if the graphs and data look like it will meet your expectations.

We designed our own BAQ and Dashboard. The dashboard also prepares the chart as shown below. If you want I can load it on the site. Vinay Kamboj [image001.jpg]

looks nice, would you be able to share the BAQ file?

BAQ attached. Version 10.1.600 OnTimeShipment.baq (9.5 KB)

this is awesome thank you very much! it worked great

On time delivery report

Epicor ERP 10

Vinaykamboj (Vinay Kamboj) October 9, 2019, 5:16pm 13

Hi John,

Dashboard Definition attached. Ver 10.1.600.19

Vinay Kamboj

OnTimeShipmentTrackerDashboard.dbd (386.8 KB)

On Time Dashboard Different in Assembly

Topic		Replies	Views
On Time Shipments Epicor ERP 10 e10	3	761	September 29, 2020
Creating an on time delivery report BAQ? Epicor ERP 10 baq	7	7104	November 20, 2019
Epicor 9.05 On Time Shipping Delivery report Yahoo Archive	0	735	August 3, 2016
Supplier on time & score Epicor ERP 9	16	5981	July 31, 2020
OpenOrders With Parts and Earliest Due Date Epicor ERP 10 e10 , epicor , bpm , customization , baq , rest , ssrs , reports , dashboard	4	1449	March 22, 2022

On time delivery report

Related topics