Ordering Reference Data

The application provides a range of historical and product-specific data to assist in the creation of Master Orders, Vendor Orders, and Commissary Orders. This information is displayed for each product in each of the ordering screens.

For All Order Types

Last Order — Displays the most recent quantity purchased and reconciled for that product.
4-Week Average — The quantity of units ordered during the previous 28 days divided by the number of orders reconciled in that time frame.
Unit/Issue Price:

Master Orders - Unit Price: The price per inventory unit for the contracted vendor.
Vendor Orders - Unit Price: The bid/contract price per inventory or vendor unit for the selected vendor, depending on whether the order is placed in inventory or vendor units.
Commissary Orders - Issue Price: The supply location's Issue Price or Customer Order Pricing price, adjusted to include any customer and/or product mark-ups and product discounts.

Order Quantity — The quantity to order, entered by the user.
Order Units:

Master Orders: The order is placed using Inventory Units.
Vendor Orders: The order is placed using Vendor Units (default) or Inventory Units, depending on vendor settings in Enterprise Manager and whether the current user is authorized to change this setting when creating the order.
Commissary Orders: This will default to the product's Issue Unit 1; the drop-down will also include the product's inventory unit and any alternate count units defined for the supply location.

Recommended Order — The recommended quantity to order; calculated by the application using historical data, based on settings in the Update Recommended Order Setup screen.
Min Par — The lowest quantity of a product to have on hand at the location at any given time; configured in the Location Products screen.
Max Par — The highest quantity of a product to have on hand at the location at any given time; configured in the Location Products screen.
Available — The "On Hand" quantity of the product at the location minus the total quantity of the product on outgoing Commissary/Customer Orders from this location that have not yet been "Invoiced".
On Vendor Order — The total quantity that exists on one or more incoming commissary orders and vendor orders that have not yet been reconciled. This includes quantities on the current order.

For Vendor Orders & Master Orders

Vendor Conv. — The number of Inventory Units in 1 Vendor Unit.
Vendor/Inv. Unit:

Master Orders — Displays the Vendor Unit
Vendor Orders — If ordering in Vendor Units, displays the Inventory Unit. If ordering in Inventory Units, displays the Vendor Unit.

For Vendor Orders only - Hidden by default

Projected Consumption — Displays the Projected Consumption portion of the Recommended Order quantity; calculated using historical data, based on settings in the Update Recommended Order Setup screen. This value may also be imported, if flagged as such in that screen.
Min Days on Hand — This indicates the shortest number of days the product should be on-hand in the location. This will be added to Consumption Days when calculating the Recommended Order for the product.
Market — The Market from which the vendor price was derived. This could be the location's Primary Market or a Secondary Market (linked to the Primary in the Market setup screen in Enterprise Manager).
Product Brand — The Brand for the product, from the Vendor Bids screen.

For Master Orders only

On Customer Order — The total quantity that exists on one or more outgoing customer orders that have not yet been reconciled.
Extended Value — The total value of the product being ordered, calculated as [ Order Quantity x Unit Price ].