I need a report or generic inquiry to show customer lead time.
Our users need to be able to enter a Starting Date and Ending Date based on Invoice Date.
I would like to be able to run this report by selecting a single customer or all customers.
The lead time would be calculated by subtracting the Invoice Date - Sales Order Date.
I would prefer a report but I’m not familiar enough with the tables/relations yet to make this myself.
I see the GI DB Ship On Time, so maybe we could modify this GI…
I look forward to seeing what you guys and gals can show me.