Discrepancy Report (ICR520)

Using reports

Use this program to obtain a report of all items that show a discrepancy between the on hand or available quantity at the time of capture and the physical count recorded.

Items with discrepancies print in the same order (item, alpha, vendor, item class, or location) as they appeared on the count sheets.

Report information includes the following: item number and description, primary and alternate bin locations, serial lot number (if applicable), physical count, captured count, discrepancy between physical and captured counts, stocking unit of measure, cost, costing unit of measure and cost discrepancy and physical extension. The total number of items listed is also included.

Multiple Bin Location Information

For items with multiple bin locations, this information applies:

When the Physical Inventory Order is not location, the items print by their selected sort order with the primary location on the main print line.
If the Physical Inventory Order is location, the items print by the primary location sort. Location information is included between the item description and physical count. If an item does not have alternate locations, no location information is included. If the item does have alternate locations and it is a serial or lot item, a second line prints immediately after showing all the alternate locations. When the serial/lot numbers print, they print in serial/lot number and location order.
If Physical Inventory Order is location and a lot item has alternate locations, it can have multiple records for the same lot number. In this case, the lot number, location and count quantity print each on a separate line. When there are no more records for the lot number, a total line prints with the accumulation of each location physical count, the lot’s capture information and the discrepancy information.
If the item is not a serial or lot item and it has alternate locations, only the item, description, primary location and physical count print on the main line. The alternate locations print on the next lines, maintaining their ordinal value, and will print the same information. When there are no more records for the item, a total line prints with the accumulation of each location physical count, the item’s capture information and the discrepancy information.

Printing Discrepancies only

If the IC Static Control F/M setting for Count Exceptions Only is set to No, then the any null count quantity for any location is considered zero. If the Count Exceptions Only flag is set to Yes, a null count quantity in the primary location record is considered equal to the capture quantity. A null quantity in any other location records is considered zero. This comes into effect when you select to print discrepancies only. Using the above rules, all location count quantities are summed and compared to the capture quantity. If they are equal, this is also not considered a discrepancy.

To access this program, click Inventory Control>Physical Inventory >Discrepancy Report.