*This post is locked for comments
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156