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) / IV50200 (Stock Count A...
Microsoft Dynamics GP (Archived)

IV50200 (Stock Count Assignment Temp) Table in Dynamics GP

(0) ShareShare
ReportReport
Posted on by David Layten 1,819

Hello,

Can anyone tell me what the purpose of this table is used for. I have a client that I am trying to use the inventory changer and modifier tools (PSTL) on and I receive errors regarding this table.

Thanks,

David

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi David,
    Do you have any data in any of the IV50XXX tables? The 50000 series of tables are temp tables. I do not remember ever having any balances in any of those tables. I honestly do not know what they are used for. I use the Inventory changer tool frequently and have never gotten that error.
    According to their names, they are somehow involved in ABC analysis and Stock Count Assignment. I played around with the stock count a little bit, but I couldn't get any records to populate that table. After that, I forced some records into those tables and then ran the Item Modifier - no errors. Interesting point is I put item 1-A3261A in the IV50XXX tables and then ran Item Modifier on that item. I received no errors, but it did not change the item number of the item in the IV50XXX tables.
    What is the exact error message you are receiving?
    Kind regards,
    Leslie

  • David Layten Profile Picture
    David Layten 1,819 on at

    Leslie,

    The error is Related to Primary Key Contraint PKIV50200. Cannot insert duplicate key in object dbo.IV50200.

    My educated guess is that the customer must have had a workstation lockup when creating a stock count at some point. I was able to remove this error by deleting the contents of the table.

    Before I did this on their live data, I wanted to make sure that this data was not important.

    David

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I think you're pretty safe deleting that data, I'd backup the table first. So, am I understanding you right by concluding that you did, in fact, have records in the IV50200 table? Are they doing anything with stock counts?

    Kind regards,

    Leslie

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March 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