To run the Stock Availability Service Level Report:Use the Stock Availability Service Level Report to measure customer service performance of the inventory management system independent of customer required dates or shipping dates. This report indicates the percentage of times that the complete quantity ordered for a stock item is on the shelf when the customer orders it.
This report helps you answer the question "Would we have been able to fill the order at any point during the order process." The report shows a cumulative picture of the times that inventory checks took place for a product, and the inventory service level at the point in time that the inventory check took place.
We suggest you run this report in summary mode to find the lines where issues with inventory levels might exist. Then, tun the report in detail mode for those lines to find the specific items with issues.
|
Important: The data for this report is only gathered when the Stock Availability Service Level Tracking control maintenance record is set. |
To run the Stock Availability Service Level Report:
From the Reprts > End of Month Report #2 > Service Level Reports menu, select Stock Availability Service Level Report to display the Stock Availability Service Level Report screen.
In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Type All to run the report for all branches and territories.
In the Start Date field, enter the first date in a range of dates for which to view stock availability. This field supports variable dates.
In the End Date field, enter the end date in a range of dates for which to view stock availability. This field supports variable dates.
In the Select By field, select Buy Line or Buyer to limit the report by either selection. This selection determines the name of the next field.
In the next field, indicate the specific buy line or buyer by which you want to limit the report. Use the Multi hot key to select more than one buy line or buyer. *Multi* displays in the field.
In the Sort By field, indicate if you want to sort the items on the report by buy line or by product rank.
In the Summary/Detail field, indicate in which mode you want to run the report.
The report in summary mode sort by lines, such as buy line totals. Detail mode displays product-level data for every sales order that a product was entered on and totaled by sort by lines, such as buy line.
In the Items With SelCode (I/E/O) field, indicate if you want to include, exclude, or run the report for only items with a select code. The default is Include.
In the Nonstock At Order Time (I/E/O) field, indicate if you want to include, exclude, or run the report for only products that were considered non-stocks when ordered. The default is Exclude.
Use the Product Ranks hot key to limit the report by specific ranking methods.
The Stock Availability Service Level Report lists the following fields and columns of information:
|
Field/Column |
Description |
|
Product |
Product short description as listed in Product Maintenance. |
|
Ord# |
The order number on which the product is listed. |
|
Chg Date |
The date the last change was made to the order. |
|
Qty Ord |
The number of each product. The system lists them in highest package quantity, such as cs (case) or ea (each). This is the cumulative quantity of all the inventory checks for a particular product. |
|
Qty ISL |
The total quantity available at the time the report is run, divided by the total quantity ordered. |
|
Item Ord |
The number of inventory checks that took place for an item. Item Ord is the number of times that an item was ordered or the order was changed, prompting the system to do an inventory check. |
|
Item ISL |
The number of times an item quantity on an order was completely available, divided by the number of times the item was entered on an order. |
|
Buy Line |
The buy line in which the items on the order are contained. |
|
Rank |
The rank or ranks that have been applied to each buy line or products. |
For example, you have the following scenario:
An order is created with a single line item.
The quantity ordered is 1 and the available on hand is 10.
The same single line item order changes to increase the quantity ordered.
The quantity ordered is now 3 and the available on hand is 10.
The order is shipped, but quantity one of the line item has been sold on a different order prior to this order shipping. The
order quantity is the same, but now the on hand is different.
The quantity ordered is 3, but now the available on hand is 9.
In the above example, the Stock Available Service Level Report shows a Qty Ord of 7, and an Itm Ord of 3. The system checked inventory three times for a cumulative quantity of seven of the product.
See Also: