Skip to main content

Notifications

Microsoft Dynamics SL forum
Suggested answer

Generate Inventory Tags problem

Posted on by 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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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

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

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

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

    Forgot to mention that customer is running SL 2011 FP1.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans