Line item fill rate reporting

(0) Share

Report

Posted on by Community Member

I am attempting to find a way in AX 2012 r2 with Omnica to report on line item fill rate.

The amount of order lines shipped on the initial shipment versus the amount of lines ordered.

I am also looking to report on order fill rate, on-time delivery.

Has anyone had any experience with these reports in AX?

Thank you,

Andi

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

Hi Andi,

I noticed the 'Warehouse manager' role center has a Shipped In Full On Time report.

msdn.microsoft.com/.../hh289353(v=ax.50).aspx

The data in the report comes from the standard AX Sales cube. This blog explains a bit about it, and how to use that data in an Excel report.

blogs.msdn.com/.../warehouse-key-performance-indicators-in-microsoft-dynamics-ax-2012-r3.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your reply. This is great! Unfortunately, we are running r2. I have a few avenues I am trying but had really hopes AX would have the answer built in!

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Andi,

I think the Warehouse manager role center is in AX 2012 R2, and I think the cubes in R2 contain the KPIs that the SIFOT report uses.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

So apart from what was already mentioned, there's no built in SSRS report that would do this huh?

Any idea if there are third party reporting solutions for this kind of stuff?

Was this reply helpful? Yes No
RamK 2,580 on at

Like (1)

Report

Refer Sales Cube which has calculated measures like % Sales order lines not shipped in full, % Sales order lines shipped in full and many more. Refer technet.microsoft.com/.../jj710394.aspx

Was this reply helpful? Yes No