Hello All,
I have a customer who cannot generate inventory tags. When they enter the PIID and set up the Item Selection for Locations and Cycle Count, then select User Specified List of Items/Locations, the Location ID they want shows the CountStatus as "In Progress." After they run the process, the event log shows no error, only noting that the "Number of Tags Created = 0".
FYI, there is no PIID showing a Status of In Progress (I). I'm operating on the assumption that there is a corrupt Physical Count process hung somewhere that is causing the problem.
I searched our SQL DB and found that the CountStatus column is in several tables:
Inventory
ItemSite
Location
LocTable
The only table that has CountStatus values of 'P' is ItemSite, but that table does not contain the WhseLoc column, so I fail to see how it could be the source of the "In Progress" Count Status value in the User-Specified Locations (10.395.02) lookup screen.
Any/all suggestions welcome.
Thanks,
Bill
Solution:
Determined that the rows in ItemSite that were set to CountStatus = 'P' (in progress) were preventing the inventory tags from being generated. Ran a SQL update statement to change those to CountStatus = 'A' and the tags were generated without error.
We are assuming (but do not know for sure) that an earlier failed PIID creation attempt via Generate Inventory Tags caused the CountStatus value change.
Hope this saves someone a lot of head scratching.
Bill
Forgot to mention that customer is currently on SL 2011 FP1.
Forgot to mention that customer is running SL 2011 FP1.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148