Background: Inventory Deviation Listing

Use the Inventory Deviation Listing (HDL) program to print the quantity on-hand, quantity counted, deviation, and cost variance for items with a deviation. See Road Map for work flow.

This topic has these subtopics:

Deviation Listing
Voided
Totals

Deviation Listing

After you enter the physical counts, you must print the Inventory Deviation Listing. This listing compares system on hand and obligated quantities at the time you entered the count with the count that you entered and records a "deviation" or difference. It also reports items that with an obligated quantity that is greater than the entered count.

The listing prints in warehouse and bin location sequence unless you select other Sort options. The listing includes:

• Cycle number followed by Annual if this is an annual physical inventory count

• Branch

• Requested by

• Warehouse if the item is warehouse/bin controlled or if you have entered locations in the Primary whse field of the Branch Item Maintenance (IMB) program

• Bin location if the item is warehouse/bin controlled or if you have entered locations in the Primary bin loc field of the Branch Item Maintenance (IMB) program

• ABC class

• Item number

• Stocking unit of measure

• Standard unit cost

• System on hand quantity at the time you entered the count or created the cycle (based on whether or not you selected Upd cycle on hand qty at time of count? in Cycle Count Preparation).

• Quantity obligated

• On hand: The count you entered

• Deviation quantity: On hand - Sys on hand

• The program prints *** VOIDED *** if you clicked Void in the Physical Count Entry (HCE) program.
  
  *** VOIDED *** does not print if you clicked Void to void a tag in the Alternate Physical Count Entry (HAE) program.

• Deviation cost: Standard unit cost x Deviation quantity

• Line number

• Control number: Serial or lot number for a controlled item

• Item description

• Remarks if entered in Physical Count Entry

• Qty counted is less than qty obligated, qty will not be accepted message: Either the count quantity has to be increased to at least the quantity obligated or the obligation needs to be removed. The counted quantity cannot be less than the obligated quantity for the cycle to process.

The listing includes this information if you selected the Include tag numbers? Program option

• Tag number

• Quantity entered

• Warehouse

• Bin location

• Serial or lot control number

• Sts: V: This tag is voided.

• User who entered this tag

The listing includes these totals:

• Items in cycle: Total number of items that were included in the cycle

• Items with increased qtys: Count entered is greater than the system on-hand

• Items with decreased qtys: Count entered is less than the system on-hand

• Items at zero cost: The number of items have no cost

• Items voided: The number of items that were voided

• Items with insufficient qtys: You selected N, B, or C for the Negative inventory allowed option in the System Options Maintenance (XM) program (Inventory Control Options) and the count entered is less than quantity obligated

• Items open: The number of items that do not have counts entered

• Beginning cost of the items counted

• Upward revision value: Standard unit cost x Deviation quantity for items whose quantity increased

• Downward revision value: Standard unit cost x Deviation quantity for items whose quantity decreased

• Net (Ending) cost: Beginning cost + Upward revision value - Downward revision value

You should check this listing for large deviations that may require recounting or investigation. Then use the Physical Count Entry (HCE) or Alternate Physical Count Entry (HAE) program to enter changes to the counts. If you make changes, you must reprint the deviation listing before you can run the Physical Inventory Update (HCU) program.

Voided

If you clicked Void for items in the Physical Count Entry (HCE) program, the Inventory Deviation Listing displays * * * VOIDED * * * across the On hand and Deviation quantity columns. Voided items are not to be counted.

* * * VOIDED * * * does not print if you clicked Void for a tag in the Alternate Physical Count Entry (HAE) program.

Totals

The program prints totals for items and not for counts. For example:       

Copyright © Qantel Technologies, Inc. 2025