Does anyone have a good setup for an On Time Delivery Generic Inquiry? We are trying to decide the best way to do so and looking for ideas. Currently, I have a Shipment Performance generic inquiry that shows total days late for individual Sales Orders that have been completed, but I’m hoping to work in current open orders that are past due.
Solved
On Time Delivery Generic Inquiry
Best answer by Neil Cantral
Depending on what you consider a late shipment and if customer lead times are accurate you could use something like this:
=DateDiff('d', Today(), [SOOrder.ShipDate])
Anything with a positive value could be considered on-time, anythign negative would be late.
If wanted to combine the completed and open orders into a single on-time indicator you can wrap it into an IIF or Switch function using a field like SOOrder.ShipmentCntr.
=IIF([SOOrder.ShipmentCntr]>0, DateDiff('d', Today(), [SOOrder.ShipDate]), [Your current formula], 0)
+3Depending on what you consider a late shipment and if customer lead times are accurate you could use something like this:
=DateDiff('d', Today(), [SOOrder.ShipDate])
Anything with a positive value could be considered on-time, anythign negative would be late.
If wanted to combine the completed and open orders into a single on-time indicator you can wrap it into an IIF or Switch function using a field like SOOrder.ShipmentCntr.
=IIF([SOOrder.ShipmentCntr]>0, DateDiff('d', Today(), [SOOrder.ShipDate]), [Your current formula], 0)
Would you consider sharing the OTD GI? We are migrating to Acumatica and am in need of a quick solution for this problem.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.