To create an On Time Delivery Report, I need to look at multiple dates (Promised Date, Put into Stock Date, Actual Ship Date).
However, to compare these together, I'm challenged by quantities. We might promise 3 on one day, build 2 and only ship 1.
In order to manage this, I believe i need to split every date into a Qty of 1 - repeating the same data for the total roll up.
Is there a function, or workaround that would allow me to repeat each item until it totals the full quantity?
For example: 4 Widgets for Customer A shipped 1/15 would become:
1, Widget, A, 1/15
1, Widget, A, 1/15
1, Widget, A, 1/15
1, Widget, A, 1/15
This lets me compare each individual item against promise, inventory and actual in order.
I have 100's of these per month, so I can't do it manually. I've searched high and low for an answer and can't seem to find anyone with a similar problem and would greatly appreciate the help.