Steve Langley
Active Member
Greetings,
I have a situation where the warehouse manager wants to perform a cycle
count using a range of locations as the data selection. It is possible to
data select on a range of locations; however, the cycle count will only
generate counts for locations showing inventory. Makes sense; but the
business process outside of the software is to at least observe all
locations in the designated range. The reason stems from wanting to be sure
no one misplaced inventory.
Solution One: Open data selection to include where the on hand quantity is
equal to 0. When tested it brought back all the locations but hundreds parts
to NOT count (zero qty on hand.) Any inventory ever going through the
location was brought forth to be counted. Need a way to show the location
without showing all the transaction history in that location.
Solution Two: Use tag count. The problem is no data is provided and the
user has to write everything down. It's OK in an RF solution but it's not
acceptable in a paper based warehouse. Lots of un-necessary steps.
Solution three. Generate a report that is not a cycle count showing all
locations and any inventory registered with in the location. Compare and
verify the report against the physical. Perform a cycle count if there is a
discrepancy.
Thank in advance for your ideas and help.
Steve Langley
ERP 8.0
Update1
AS400
Web client
I have a situation where the warehouse manager wants to perform a cycle
count using a range of locations as the data selection. It is possible to
data select on a range of locations; however, the cycle count will only
generate counts for locations showing inventory. Makes sense; but the
business process outside of the software is to at least observe all
locations in the designated range. The reason stems from wanting to be sure
no one misplaced inventory.
Solution One: Open data selection to include where the on hand quantity is
equal to 0. When tested it brought back all the locations but hundreds parts
to NOT count (zero qty on hand.) Any inventory ever going through the
location was brought forth to be counted. Need a way to show the location
without showing all the transaction history in that location.
Solution Two: Use tag count. The problem is no data is provided and the
user has to write everything down. It's OK in an RF solution but it's not
acceptable in a paper based warehouse. Lots of un-necessary steps.
Solution three. Generate a report that is not a cycle count showing all
locations and any inventory registered with in the location. Compare and
verify the report against the physical. Perform a cycle count if there is a
discrepancy.
Thank in advance for your ideas and help.
Steve Langley
ERP 8.0
Update1
AS400
Web client