Supplier OTIF Enquiry
This enquiry shows how well your suppliers are performing with regards to delivering your orders on time, and in full (OTIF).
Use the Supplier and Enquiry Criteria sections to determine which supplier you wish to enquire upon, and over what period you are interested
Supplier: Select the supplier account that you want to enquire on.
Document date from/to: The Purchase Order date range you want to enquire on.
Include archived orders: Default setting determined in Cim200 Settings. Determines whether the enquiry will include archived purchase orders or not.
Only show fully received lines: Default setting determined in Cim200 Settings. Determines whether only order lines that have been fully received are included in the enquiry results or not.
Include free text lines: Default setting determined in Cim200 Settings. Determines whether free text order lines are included, or only stock item lines.
Exclude orders with no requested date: Default setting determined in Cim200 Settings, determines whether order lines with no requested date are included in the enquiry results or not.
Note: When order lines have no requested date, and have been delivered, the enquiry will consider them as being delivered on time regardless of when you actually wanted/needed them.
All Items: All order lines raised to that supplier will be included in the enquiry results.
Supplier supplied items: Only stock items which have this supplier associated with them will be included in the enquiry results.
Single item: Select a single item to include in the enquiry results.
Once you have entered all the relevant criteria you require, press Display to process the OTIF enquiry.
Enquiry Results
There are 2 tabs available on the enquiry results
Order Lines
This list shows all the order lines processed by that supplier. Detailing the order details, quantity that was ordered and received, what date the line was requested and when the latest receipt was processed.
The Overdue/Late flag shows whether the item is currently overdue or was received late.
The OTIF % column shows the percentage score for that order line, with the score calculated based on how much of the order line was received on time.
Example Scenario: An order line has an order quantity of 1000, and a due date of 01/02/2025. 2 receipts are processed for that order line. 600 on 31/01/2025 and 400 on 02/02/2025. The OTIF % score for this order would be 60%, as 60% of the quantity required were received on time.
Stock Items
The stock items tab shows a list of each stock item ordered from that supplier (considering the criteria in place when setting up the enquiry).
This shows the item code and description, along with the number of deliveries received from the supplier for that item, how many were ordered, how many were delivered late, what the price variance was between those orders, the overall OTIF % for that item, and the average number of days late across all deliveries.
View Order: This button will load the purchase order for the selected order line in the Order Lines list.
View Receipts: This button will load an delivery history enquiry screen, which shows the relevant receipts for that order line or stock item, depending on which list you open the enquiry screen from.
Supplier OTIF Summary
At the top of the screen an overall summary of that suppliers performance is displayed.
Requested Deliveries: Shows the number of order lines raised to the supplier.
Late Deliveries: Shows how many receipts were processed after the PO/Order Line requested delivery date.
Average Days Late: Shows the average number of days after the requested delivery date those late deliveries were received.
OTIF %: Shows the overall OTIF percentage score for that supplier across all orders/deliveries.
