Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Item Changer Issue and Inventory Reconcile

Posted on by 75,730
I have been struggling with an IV reconcile issue after using Changer from CRGROUP. The issue is described below. This occurs only when two or more items are merged into one.
 "I have spent the last two days manually scrubbing the IV10200 and IV10201 tables. One thing I have noticed is the field IV10200.RCTSEQNM. I believe that number should be unique every time your received an item. What I am discovering is that it is not unique. I have multiple records for the same item with the same rctseqnm number and this is because the daterecd is also part of the primary key. So I see receipts spread over years where the rctseqnm number is the same but the date is different. Once this happens the iv reconcile program does not know what to do with these records and just reports the same fix over and over again."
Does anyone know for a fact that the IV change/merge item numbers using the PSTL does not have this same problem?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Item Changer Issue and Inventory Reconcile

    Dave, you are right. I should have been more specific. The issue is this. We all know the usual messages you get from IV reconcile. Things like QTY on Hand has been changed from X to N. Well for a handful of items each time you run IV Reconcile you get the same messages. You can run IV Rec six times in a row and you get the same messages. I see other items that appear to have the same date issue and they do not get the messages. We have a huge item number change coming up. I am going to run a backup just before running Changer, then run Changer to see if any new items now have this issue. If not, I will just cleanup the few that do. If new ones pop up I will just have to dig into them and try to find some commonality.

  • Dave Dusek Profile Picture
    Dave Dusek on at
    Re: Item Changer Issue and Inventory Reconcile

    Richard,  A couple of things on this one.  First, you don't mention what the error is that you get on the reconcile.  That could be helpful depending on what it says.  Second,  Are you sure that the problem has to do with the receipt sequence numbers?  Because yes, that is a key field, but you can have duplicate receipt sequence numbers because that isn't the only key field.  Date Received is also a key field and if that is different, which it sounds like it is, then technically, it should be ok.  Maybe the problem is with the reconcile?  I don't know that it is but it's a possibility.  

    I would say what you need to do here is isolate the problem.  In a test company, run the changer and combine items and then reproduce the error.  Then do some testing on the purchase receipt records to see if you can narrow down the issue.  

    Dave

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans