Notifications
Announcements
No record found.
The IV Reconcile tool was ran from the utility, which made the situation worst. Multi-Bin is being used. What could be causing this? Any insight is appreciated.
Thank you!
*This post is locked for comments
Oh dear!
I would be interested to know if you are using any third party add-ins or modifications to your GP. If these do not deal with multiple binning or recover from errors correctly, then problems could occur with the stock balance in your bins.
For diagnosing our problems I looked at a handful of products, and picked through the stock movements and bin movements to work out what was going wrong. In our case it was around serial numbered items and a modification we had made.
I now have a SQL job running an integrity check on our bins so that I know immediately that any imbalance = occurs, allowing me to jump into finding the cause.
I would also be interested in the nature of your bin issue, what exactly are you seeing with the qty on hand vs the qty in bins? Are there any patterns to what is happening? Is it happening to particular types of product or in certain locations, it is all about narrowing down the search to uncover the root cause.
If you back up your database i would run a checklinks on the inventory module and then run reconcile to see if there is any underlying data integrity issues. You could also consider doing this on a copy of your production company in case it has undesirable consequences (especially if you don't regularly run check links).
Tim,
You are correct we are using Key2Act Service Manager and Job Cost as well as a good bit of customizations that bulk upload data into GP.
I would start a hunt for what is causing your corruption then, means sifting through the data and looking for clues as to when and how its going wrong.
tim.
Tim, thank you for the wonderful feedback. The issue ended up being an unposted Stock Count batch. Your article on "Developing against Dynamics GP Multiple Bins, tables used", 2016 was extremely beneficial in finding the root cause.
Glad to hear it helped you
www.timwappat.info/.../Developing-against-Dynamics-GP-Multiple-Bins
Explains the tables used in multiple bin enabled GP.
Sadly I've got all the badges when it comes to multiple bin problem solving...
I know this is a 6 year old thread, but was hoping you could advise with my bin qty issue. I processed a return to a new site, which all item numbers were assigned to and a default bin to be used for returns. The sales return process to the new site with no errors. When I Item Inquiry, I can see the qty on hand for that site = to what was returned to it. The bin qty however is 0. A Bin Quantities inquiry reveals that the default site/bin was used to receive the qty returned. Site qty's are correct, but bin qty's do not match the site qty's for the returned items. I can do a transfer entry to move the bin qty's over, but then my site totals would be incorrect. If I use checklinks, which tables do select?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
