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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Stock Count Entry
Microsoft Dynamics GP (Archived)

Stock Count Entry

(0) ShareShare
ReportReport
Posted on by Community Member

Hi.

We’ve got an odd behavior with the Stock Count Entry window for a particular Stock Count ID. When bringing up ID 351 all the controls are greyed out and we can’t do anything with the window but close it or select another site using the lookup button. Here’s a screenshot.

 

                       

Typically all the controls are enabled on this window and we’ll see a list of inventory.

The Stock Count ID in question is not new but has been used three times in the past. I can see data for it in the IV10300, IV30700, IV10301 and IV30701 tables and as far as I can tell there’s nothing that stands out as being notably different than other IDs.

Any ideas on what we might be missing?

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    What is the status of the stock count on the stock count entry window ?

  • Community Member Profile Picture
    Community Member on at


     

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Apparently, there are corrupted records on the database in IV10300 and IV10301 ... Although the data is there, but there could be some corrupted field or Indices.

    Do you have SQL knowledge ? If So, I would run an SQL profiler just before picking up the Stock Count ID from the lookup . It would give us a hint on what's going on

    I have tested few changes, changing the status and reuse stock index and none of them affected the line items showing in the grid. In case the "Reuse Stock Count" was not checked, everything becomes disables after the stock count is completed. although, I find no proper justification for the items missing on the grid.

    Let me know how it goes with the profiler,

  • Community Member Profile Picture
    Community Member on at

    So I ran the profiler and tried to bring up the Stock Count Entry for 351. There were no errors reported and with the exception of not seeing a ton of entries related to loading the detail lines into the window it looked very much the same as loading another ID into the entry window.

    I see in the IV10300 table that the field RSSTCKCNT is set to 1 for all other stock IDs except this one (351) and one other. I also note that STCKCNSTTS field is typically set to 1 or 2 for all other IDs except for these same two which are 0. Do you know what the stock count status values mean? I think that in the test company I might just set the RSSTCKCNT to 1 for ID 351 and see what happens.

    I think though that whoever counted the stock last year failed to check the Reuse Stock Count box and it seems that’s the main trouble.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    These two fields are

    • STCKCNSTTS : Stock count status 
    • RSSTCKCNT: Reuse stock count

    Stock count status usually changes from started, entered or available, I would test changing it to (1) to be available. Additionally, the reuse stock count would have a value of either (1,0) which is true and false, I would set it to one.

    Before trying these updates on a test company, I might hit the check links as a the last try, it might check records integrity. If it didn't work out, you may proceed with the update.

    Finally, if it never got fixed. Just create a new one and get this one deleted from the database level.

    Let me know if you have any further concerns,

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    I am wondering if the constellation of errors WennSoft reportered today are all related to copying a company and the various setting that should be updated, which are not contained in the company database.

  • Community Member Profile Picture
    Community Member on at

    No these are all issues from different customers that I'm working on.

  • Redbeard Profile Picture
    Redbeard 12,931 on at

    Bummer -

    I was hoping we could kill a few birds with the same stone.

    Did you give Mahmoud's suggestion of changing the Stock Count status in SQL a try?

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at

    Hi WennSoft!

    I have been doing a little digging though our internal databases in which I have found that RSSTCKCNT is usually set as a 1 as Mahmoud had mentioned I was unable to locate what the status values for this one. However, In the IV10300 the STCKCNTSTTS field stores

    1 = Available

    2 = Started

    3 = Entered

    A 0 for STCKCNTSTTS is not a valid value for this column so this would point to as what Mahmoud said in which this Stock count appears to be corrupted.

    Hope this helps!

    ~Thomas Newcomb

    -------------------------------------

    Microsoft Dynamics GP Support

    -------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans