Overview


The system allows you to download the Discrepancies Report where you can identify any discrepancy or physical overage between the Physical inventory and Komet's inventory. This report can be generated for the whole inventory or for specific rack positions.

After performing the Physical Inventory Reconciliation Process, this report will help you identify any discrepancies found in the inventory. The report can be downloaded as a PDF or Excel file and you can select different options to include.


Instructions

To download the report follow the steps below:

Go to Shipping > Inventory.

 Click on the "Actions" button, then select the Discrepancies Report option.

Select the format of the report you want to print and complete the rest of the fields required. Remember that if you want to run the report for specific rack positions you can enter the letters corresponding to those racks, separating each using the enter or space keys. Then click on Print. Companies with "Multiple locations" will have a Location filter to select the required location to print the "Discrepancy Report" for.  

Download here an example of this report.

 

Discrepancies Report Solutions:

The report will show two basic sections:

  • Inventory Items: Shows the details of all the boxes that are in the system's inventory, but were not scanned with the scan gun during the physical inventory process. 
  • Physical Overage: Shows the details of all the boxes that were scanned physically but were not in the system's inventory.

Inventory Items:

  1. The warehouse should be checked thoroughly to ensure the box is not there and it was not missed in the scanning process.
  2. If the box is not located there is a chance the wrong product was dispatched or the box is missing.
  3. It is recommended to check the Physical Overages section to see if similar products that were previously sold but not dispatched are appearing in this section. If similar products are found, there is a chance that the wrong product was dispatched to the client and the correct one was left behind. If this happens it is recommended to adjust the invoice order to reflect the actual product shipped, and to scan the product that was left behind back into your inventory.
  4. It the box can't be found, it must be billed to the "Inventory Adjustments" account with a $0 price with a past date. Next time, the inventory count is done this box will not appear in the Discrepancies Report. 

Physical Overages

  1. If boxes from a previous order are found in the warehouse, two scenarios may have happened: a.) Either the salesperson never confirmed the order or confirmed it after the truck date. Therefore, the boxes were not sent to the client. If this is the case, the order's date must be updated in order to ship and scan the correct box; or the order can be canceled so the boxes return to the inventory. These boxes can be identified as the product information and the order's information coincide. b.) Another possibility is an error in the shipping process; either the box was scanned twice or the label was incorrectly scanned. In this case, the aforementioned in point 3 may apply.
  2. If boxes are found physically and are not in the system, they must be checked to ensure they are inventory boxes or if they have been scanned incorrectly. If it is determined that they belong to the inventory, they must be manually added to the inventory and labels must be reprinted in order to scan them again. These boxes can be identified as their box number and position appear on the report, but no other information exists.
  3. In the previous case, the box can be scanned again and the system will remove it from the discrepancies section and add it to the inventory.