web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Generate Inventory Tag...
Microsoft Dynamics SL (Archived)

Generate Inventory Tags problem

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Generate Inventory Tags problem

    Forgot to mention that customer is running SL 2011 FP1.

  • Community Member Profile Picture
    Community Member on at
    RE: Generate Inventory Tags problem

    Forgot to mention that customer is currently on SL 2011 FP1.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans