You can calculate the lead time taken from one process to another process using the lead time statistics functionality at Purchase/Statistics/Lead time. The system will determine and calculate the lead time between the transactions selected in the start category to the transaction in the end category based on the transaction date.
You can obtain the statistics of lead time by specifying one or more of the following criteria. Based on the specified criteria, the lead time is calculated and shown in the Microsoft Excel spreadsheet when you click Display. A list of options is available if you click in the Warehouse, Project, and other boxes. From the list, make a selection and click Select.
Select a warehouse or a range of warehouses to calculate the lead time for purchase processes at the selected warehouse(s). Select the All check box to calculate the lead time for purchase processes at all warehouses.
Select a range of purchase order dates to calculate the lead time for purchase processes of orders within the selected dates. Select the All check box to calculate the lead time for purchase processes of orders with any date.
Note: Typing or selecting only the start date will calculate the lead time for purchase processes with orders created on the selected date and later dates. Typing or selecting only the end date will calculate the lead time for purchase processes with orders created on the selected date and earlier dates.
Select a project or a range of projects to calculate the lead time for purchase processes of orders linked to the selected project(s). Select the All check box to calculate the lead time for purchases processes of orders linked to any project.
Select a selection code or a range of selection codes to calculate the lead time for purchase processes of orders with the selected selection code(s). Select the All check box to calculate the lead time for purchase processes of orders with any selection code.
Select a cost center or a range of cost centers to calculate the lead time for purchase processes of orders created/handled by resource(s) linked to the selected cost center(s). Select the All check box to calculate the lead time for purchase processes for orders created/handled by resource(s) linked to any cost center.
Select a resource or a range of resources to calculate the lead time for purchase processes executed by the selected resource(s). Select the All check box to calculate the lead time for purchase processes executed by any resource.
Select a purchase order or a range of purchase orders to calculate the lead time for purchase processes of the selected purchase order(s). Select the All check box to calculate the lead time for purchase processes of all purchase orders.
Select a supplier or a range of suppliers to calculate the lead time for purchase processes of orders that are placed at the selected supplier(s). Select the All check box to calculate the lead time for purchase processes for orders that are placed at any supplier.
Select Order, Delivery, Receipt, or Invoicing to start the calculation of lead time from the respective purchase processes.
Select Delivery, Receipt, Invoicing, or Payment to end the calculation of lead time at the respective purchase processes.
Select First or Last to calculate the lead time by the selected order of date range based on the start and end processes specified in the Lead time section. Select First to calculate the lead time from the first line of transaction or select Last to calculate the lead time from the last line of transaction.
Click Advanced to view the advanced filter options in the Range section. Click Simple to hide the Range section; displaying only the General, Lead time, and Options sections.
Click Display to calculate and display the lead time based on the specified criteria in Microsoft Excel.
You can further select the filter options from this Microsoft Excel spreadsheet to obtain the lead time for the intended criteria.
Click Close to exit.
Currently there are no related documents.