Question

How do you remove zero onhand quantities from Count Sheets?

  • 9 March 2023
  • 3 replies
  • 183 views

Userlevel 4
Badge +9

How do you remove zero onhand quantities from Count Sheets?  We don't want to count zero quantities.  We only want to count parts with a quantity on hand greater than zero.
Business Impact: We are counting items that don't need to be counting.  It is slowing down our inventory reconciliation process.


3 replies

Userlevel 4
Badge +9

How do you know that they don’t need counting?

It may be that IFS thinks there is no stock, but there is. So showing a zero qty is not a bad thing 😀

 

There is a housekeeping routine ‘Cleanup of Inventory’ to clear empty locations that you can use prior to running the count report.

Userlevel 3
Badge +8

Agree with @KIMKIMANDREW . Run the ‘Cleanup of Inventory’ job to remove the zero stock records prior to the creation of the Count Report(s).

 

If you do find an item that has been cleared by the clean-up job you will have to manually add this back into the application.

 

Userlevel 7
Badge +28

If you were audited on your counting program and it was determined that you were removing zeros to get around validating the transaction that occurred prior to the counting period, I’m sure it wouldn’t sit well with the auditors.  I know it would be a big problem for ours.

Employees seem to think that 0 on hand in IFS means there can never be any in stock, but depending on your transaction accuracy, that may not be the case. We require all zeros to be counted at least once, ONLY then can the records be cleaned up so they don’t appear again.

Reply