WARNING: Please perform an inventory integrity with fix options before performing a physical count. 


Should I clear out my quantities before doing my physical count?

  • Normally you should not clear out your old quantities before doing a physical count
  • There are some scenarios where it can be useful though.


Strengths

  • Clearing inventory is the easiest way to make sure you clear all quantities and moving forward get to have full control of loading your new inventory quantities and values.
  • When you have a lot of bad actual cost data in System Five, it gives you the opportunity to clear things out and start again.
    • Actual cost data comes from your stock lines located on the cost and stock levels tab of your inventory items.
    • Actual cost data is created when from your PO lines when you receive them into stock
  • When there are fix quantity or other types of inventory integrity type issues at play making in more difficult for System Five to behave correctly during the physical count process. In this scenario, zeroing out the inventory can help catch these types of problems


Weaknesses

  • Since you have full control over loading your new quantities and values it is easy to mess up your quantities or values.
  • The value of the product when you load it back in via the physical count process will not necessary match what it was previously, or what it should be.
    • This is often ignored and will make it easy to mess up the value of your inventory
  • Special processes will be needed to get stock in at the correct value and afterwards get cost back to standard.
    • Export entire inventory with standard cost
    • Export entire inventory with average cost
    • Perform a reset procedure via the physical count module to clear out all inventory quantities
    • Data load average cost to all parts
    • Perform the Physical count process
    • Data load standard cost to all parts
  • Work orders reserve stock and have to be cleared before the reset of quantity to 0 will work
    • Alternatively you can exclude work orders from the count and they will not be reet.
  • Special orders reserve stock and have to be released and cleared before the reset of quantity to 0 will work
    • Alternatively you can exclude work orders from the count and they will not be reet.