Versions Compared

Old Version 15

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Jesica Avendaño (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Overview



Excerpt

The inventory reconciliation process is where the warehouse reconciles what's in the physical inventory with what's in Komet's system inventory summary Inventory Summary section.



How does the process work?

The process starts by selecting the "Reset Inventory" option. This action is available from the  option within the  Shipping > Inventory screen tab, by  by clicking on the "Actions" button and selecting "Reset Inventory". When this action is performed all the "Physical Inventory" scanned status is cleared from all the inventory boxes in the Shipping > Inventory screen is cleared.

The system also offers the option of clearing rack positions (number of racks rack numbers or locations). However, this option is not recommended for companies that handle inventories with more than inventory count of 1000 items or more. This option is recommended when the warehouse is condensed and boxes are moved from one rack to rack when another while performing the inventory count. 

Image RemovedImage Added

After reseting the "Physical Inventory" status in the system, the physical scanning takes place by using the Inventory option from , number "3",  from the scanner. Boxes already sold in an order invoiced with a current or future date but not marked as shipped warehouse (SW) can also must be scanned. This , keeping in mind that this process usually takes place at the end of the day.

Relevant Articles

2015-08-27_0931.pngImage Added


Panel

Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
sorttitle
cqllabel in ( "inventory" , "scanning" , "shipping" , "discrepancies" )
labelsscanning, inventory, shipping


Image Removed

Which products are marked as a discrepancy?

Once the process starts, the system will mark the box as Scanned (by placing a check mark green checkmark on the "Physical Inventory" column will appear) or place it as a Discrepancy on the Discrepancies Report, based on certain rules.


Panel
borderColorCerulean
bgColorWhite
titleColorWhite
titleBGColorSteelBlue
titleWhat does the system do once a box is scanned?
  1. The system will look for the box scanned
with the gun
  1. to see if it exists or not in
the system
  1. Komet's inventory. If it doesn't it will
save
  1. mark that box as a discrepancy.
  2. If the box is found, but it is still
on
  1. in the staging area, the box is saved as a discrepancy and shown on the Discrepancies
Report as
  1. Report as "Staging Area".
  2. If the box found
belongs to an order
  1. has been invoiced, the system validates the order's date, and will proceed as follows:

    • If it is an order where some boxes were previously shipped (Scanned as shipped warehouse),
 the
    • and the box number shipped wasn't the same as the box number invoiced, the system looks for another box
with
    •  with the same lot number marked
as
    • as RW (received warehouse
) but not shipped
    • ) or FS (Farm Shipped). If the system finds
a
    • an available box
available
    • with the same lot number, the swap is made in
the system
    • Komet's inventory and the box found will be marked as scanned and a
check mark
    • checkmark will appear under the "Physical Inventory" column. If a box with the same lot number is not available it is marked as a discrepancy and it will appear on the Discrepancies Report.

    • If the

order is an order for the actual date or for a future date, the

    • boxes are in an invoice for a current or future date this will not be a "discrepancy". The system will mark the box as scanned in

the

    • the "Physical Inventory" column as it

should be in the warehouse as the order's date is not a date that has passed yet and therefore,

    • would not have been shipped by the warehouse (SW) and should be physically available.

 

Info

When

using

referring to the phrase "...the system

will look

looks for

an available

another box..." we mean the following:

  • A box with the same lot number that is
on the system
  • in Komet's inventory, that has not been scanned
into the physical inventory
  • and marked within Komet as "Physical Inventory", and has a "farm shipped" (FS) or "received warehouse" (RW) status.
  • A box from an order for the
actual date
  • current or
a
  • future date, that has not been scanned
as physical inventory
  • and marked within Komet as "Physical Inventory" and does not have a "shipped warehouse" (SW) status.
 


Discrepancies Report

Once the scanning process is finished. The completed, the Discrepancies Report can be run, the . 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 physically scanned with the scan gun in the physical inventory processduring the Physical Inventory Process. 
  • Physical Overage: Shows the details of all the boxes that were scanned physically but were not in the systemKomet's inventory.

After running the report, the ideal is for no discrepancies to come up on the reportideally, there shouldn't be any discrepancies. However, if discrepancies are found, each case should must be analyzed and treated separately.

 

NotePlease ensure the same box is not scanned more than once, this can cause problems when reconciling the inventory

To learn more on how to deal with these, please see Discrepancies Report.


Warning
titleImportant
  • The Inventory option
should
  • can only be used when the inventory is being accounted for. If the company needs to update box locations, option 5 "Update Box Location" should be used instead.

 

 

 

  • Please ensure the same box is not scanned more than once, this can cause problems when reconciling the inventory.





Info

A Discrepancy or Physical Overage is the difference between all items recorded as inventory in the system but not appearing on the "Physical Inventory" column as scanned. 



We've encountered an issue exporting this macro. Please try exporting this page again later.