Introduction: Critical Inventory Report (02-08-31-04)

Overview

This selection produces a report which shows the steps that need to be taken for a customer order to be shipped in full. When the merchandise ordered by a customer cannot be completely supplied by the quantity on hand at the pickup location, the critical inventory report can be used to determine how the needed merchandise can be supplied.

If the Automatic Special Order feature is licensed and activated on your system (‘Auto Interface To P/O’ preference is set to Y in Trans Entry Pre-Prompt (02-18-01)), and the quantity on hand is insufficient, the system automatically determines whether the needed inventory should be transferred from the stock distribution center, attached to an existing purchase order, or added to a new purchase order.

How Tyler Meets Stock Demand

[View Infographic].

The system attempts to meet demand using the following process:

  1. The system looks at the inventory onhand at the pickup branch. If the onhand is sufficient, the ordered item(s) are satisfied from the pickup branch inventory.

  1. If the inventory onhand at the pickup branch is insufficient, the system examines the inventory onhand at the stock distribution center.

    If there is enough onhand at the stock distribution center, the system looks for an open transfer containing the item:

    1. If it finds one, the order line is attached to the transfer.
    2. If it does not find one, the system will satisfy demand for the item on a future transfer from the stock distribution center.

  1. If the inventory onhand at the stock distribution center does not satisfy the quantity ordered, the system looks at unattached purchase orders that will be received at the pickup location. If it finds one, the order line is attached to the purchase order.

  1. If the inventory cannot be satisfied from unattached purchase orders at the pickup location, the system looks for unattached purchase orders that will be received at the stock distribution center. If it finds one, the order line is attached to the purchase order.

  1. If demand is not satisfied by unattached purchase orders at the distribution center, a Purchase Order Request is created. The Purchase Order can be created automatically from the request by running the Auto Build of P/O’s selection (04-54-03).

Special Notes

  • The Supply quantity and Available quantity that display on the screen are calculated in the following manner:

    Supply = Quantity on hand – Quantity Committed – Quantity Damaged – Floor Model Quantity – Outbound Transfer Quantity + Quantity to Order + Inbound Transfer Quantity + Quantity Attached to P/O’s

    Available = Quantity on Hand – Quantity Committed – Quantity Damaged – Floor Model Quantity – Outbound Transfer Quantity

  • The Supply quantity should never be negative. The system will create a purchase order request when the quantity in the supply chain does not cover the quantity committed.
  • “Shipped line” displays when the customer order has been shipped before a transfer or purchase order, which includes the needed item, has been received. For example, the needed item is received on a P/O and immediately picked up by the customer before P/O Receiving is updated. “Shipped line” will also display if a needed item is shipped on a customer order other than the original order for which the quantity on hand was allocated. In either of the above situations, the next time the needed item is received on a P/O or transferred to the branch, the “Shipped lines” will be filled first.
Tags: