Duration between sales order statuses

[emayhand]

Hello All,

We are having a devil of a time trying to figure out where the logjames in the Sales Order Activity rules are occuring and prohibitng our oders from getting to a next status of 560 (Ship Confirmation). Any ideas on how we might create a report that would indicte how much time an order or line on an order is spending at a given sales order status. The thinking is if we can identify where the orders are getting stuck, we can begin to drill into the possible problems

 

[Oliver]

Hi,

If i understand you correctly, you can enable P40204 (Order Activity Rules) > Ledger (Y/N)...this will write records for every movement of statuses in Sales Order to F42199.

With that, you can create custom reports and use the audit fields to check transaction originator (TORG), user (USER), Program ID (PID), Date Updated (UPMJ) and Time of Day (TDAY).

Hope this helps.

 

[JMast]

I agree with Oliver for the detail of who did what and how much time a line has spent at a status.

Something else we did years ago when we first moved to JDE was create an Access query which shows a count of lines at each status and a count of orders that have at least one line at each status. We did this to comfort management that orders were moving through the new system. They have kept it and learned what "normal" is at each status, so they notice unusual numbers.

If they have questions, detail queries can be run on a particular status looking at order dates, request dates, holds... to understand what is happening.

Jer