Generate Inventory Tags problem

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Generate Inventory Tags problem

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Generate Inventory Tags problem

Forgot to mention that customer is currently on SL 2011 FP1.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Generate Inventory Tags problem

Forgot to mention that customer is running SL 2011 FP1.