Armanino Blog
Article

Assessing On-Time Shipment in Dynamics AX 2012

January 17, 2014

The Shipment Details Report in Armanino's High Tech Industries for Dynamics AX 2012 is a great tool to help you assess your On Time Shipment—out of the box, with no modification necessary. You can find the report under Accounts Receivable > Reports > Bookings > Shipment Details Report.

Assessing 1 Click to enlarge image.

Specifying, the Ship Date can help you calculate OTS per shipping day. To calculate total On Time Shipment, you can leave the Ship Date field blank and run the report. The resulting report shows shipment information by Sales Order number.

Assessing 2 Click to enlarge image

From here, you can export to Excel and add a column for Days Late. A simple formula comparing the Requested Ship Date with the Ship Date (which pulls from the packlist lines) will reveal your Days Late.

Next, you can manipulate the data in Excel to determine which customers frequently receive late shipments, identify any consistently late products, and even determine an OTS percentage (using Excel formulas).

Assessing 3 Click to enlarge image.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

GET EXPERT UPDATES
Resources
Related News & Insights
Ready or Not: Gain the AI Advantage Before Your Rivals Do
Event
AI isn’t coming. It’s already here. Join us in Chicago, IL for a panel discussion with finance and business leaders.

October 15, 2026 | 01:00 PM - 04:00 PM PT
Ready or Not: Gain the AI Advantage Before Your Rivals Do
Event
Don't wait for AI's next wave, it's already here. Join finance and business leaders for a panel discussion in Denver.

September 29, 2026 | 02:00 PM - 05:00 PM PT
The Story Continues: Evolve with Sage Intacct
Webinar
Hands-on learning for Sage Intacct users ready to own their tools.

September 17, 2026 | 10:00 AM - 10:45 AM PT