“Negative Values” in Inventory Items

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report

Are your users allowed to override shortages? This is the cause of negative inventory values 90% of the time in my experience.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, they are not. Overriding shortages and doing backorders are not enabled.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Just in case. Do you have any customization(s) running on any of the SOP/POP/IV processes? If qty shortage override is not enabled, this could be another reason.

Have you also run inventory reconciliation for this product? If IV reconcile fail to reverse the entries, you may want to see if there are any orphaned entries in SOP and/or IV transaction tables.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Vaidy. No, we don't have any application running on the said processes. We are currently doing inventory reconciliation that corrects some of the problems. But there cases that it does not. Most of the time the allocated and available quantities are corrected but not the available. Is there a known bug in the distribution series?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Most common scenario that I had faced in the past (sometimes even now) is QTY Allocated being either negative or more than actuals. This normally gets resolved by IV reconciliation, but on rare occasions there would be some stranded records on SOP line work table (SOP10200) and/or IV adjustment line table (IV10001).

Some of these cases are fixed by running Check Links. Many of them had to be removed from backend directly (SQL).

This is not a bug as far as I know. One pattern that I have noticed is that if you have connection issues between client and server while entering transactions.

We may have to have a detailed look at inventory tables and transaction tables to see if there is anything that holds quantity unwarrantedly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No