You’re offline. This is a read only version of the page.
It has been 7 - 8 years now that we are encountering "negative values" in our inventory items as seen below. We had conducted several simulations with our partner-vendor but the thing is, this scenario kept on recurring. Hoping to find what could be the possible causes and solution to this long standing problem.
*This post is locked for comments
Could you share the SQL code? I can open the link...
I have the same problem
Exactly my thoughts, Frank.
If you're GP vendor has indicated that you can't use Check Links because "since we have customized features/modules inside", I would be willing to bet the customizations are the root cause of negatives you are seeing. I would ask your vendor to review the customizations to help isolate this behavior.
Nope, we haven't. I'll try to check this out and will definitely let you know the result.
Thank you so much!
Have you considered the SQL script above for recalculating allocations ?
Your feedback is highly appreciated,
Thank you for the note here.
We usually run the ITEM RECONCILE hoping that the negative values of the Allocated, Available and on-hand will be fixed. However, there are instances that even if we did it more than once the value is not corrected.
What I mentioned earlier re : Check Links and Reconcile is in the System utility that as we are advised, should not be used.
Will do further investigation on the 3 possible causes you've mentioned here and hopefully from there be able to nail down the culprit.
Hello there,
I do believe that your issue is related to the "allocated quantity", as you can see the quantity available is 5 which implies that your inventory stock didn't go down . The quantity on hand is calculated according to the following criteria :
On Hand = Available - Allocated.
In this essence, there is definitely a problem with your "allocation", correcting that will get your inventory stock back to the normal case.
Now why would an allocation go in minus, there is no standard scenario in which Dynamics GP would have a negative allocated quantity if it works by design, there is support article from Microsoft which explains that the reasons for that is either related to posting corruption, third party integration or incorrect importing of data.
The solution for that is definitely the reconciliation, I find no reasonable logic at all with preventing you from running this utility, it does check such problems and correct it accordingly.
For the mean time, consider the following SQL statement which recalculate your inventory allocation (Manufacturing is not included in this script) Dynamics GP inventory allocations to SOP orders script
Your feedback is highly appreciated,
I just recently learned about this myself and planning to ask them in details about this. But in passing, they said that since those were customized applications, when the utilities are run, those account or transactions will be deleted as the system will perceive that they are "orphan" accounts?
Do you mean then, that creating something like "Check Links" is not advisable? What are the tools we can use then for GP Database Maintenance? what are your suggestions?
This one is intriguing: "we cannot run the Check Links and Reconcile utility tool of GP since we have customized features/modules inside".
Can you get an idea from your vendor on the level of customizations? If there is any customization that requires you to not run Check Links and/or Reconciliation, then you got to be aware of the complete scope.
Reinventing Check Links and Reconcile process is unnecessary if we have efficient and harmless customizations.
According to our Vendor, we can not run the Check Links and Reconcile utility tool of GP since we have customized features/modules inside. Actually, we are thinking, if we can't use them, then we have to create something like that out of GP. But in order to do that we have to understand the complete process , table familiarization, etc?
As for "lost connection" this is one thing right now that we are also looking at closely.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (