Microsoft Dynamics GP (Archived)

NEGATIVE QUANTITY BALANCES IN INVENTORY

(1) Share

Report

Posted on by Community Member

Good Day to you all. I am currently having negative quantity balances on some of my inventory items.

Has anyone experienced this before? What is the root cause and how can this be prevented?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Modupe

Please let us know if your case is resolved, or whether you need any further assistance.

If not, please feel free to close the case.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Thanks Harry for your response.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Thanks Mahmoud for your insight

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Thanks Rosemary. we would reconcile and hope this issue will be resolved.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Good morning,

We had that same issue initially with GP, the primary cause was due to batches, SOP and INV, which may have ended abnormally with check links and reconciles not being done in a timely manner.

We are currently with GP 2013 and we do not have any negative issues.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

I do agree with Harry that it could be a result of a logical ordering of transaction entry, which practically means that your system configuration allows to override quantity (override quantity means selling or withdrawing quantity from your warehouse even if there is no sufficient balance to cover such "out" transaction)

If this is the cause of having negative quantity in your stores, then you are definitely on the safe side and you can proceed with entering the "in" transaction to replenish quantity shortage without any issues.

Although what I would have some concerns about is any possible inventory mismatches between purchase receipts and historical inventory trial balance. For now, lets assume that it is only a result of transaction entry ordering sequence, before digging into further other possible reasons.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: NEGATIVE QUANTITY BALANCES IN INVENTORY

Modupe,

Typically, negative balances occur in Inventory when beginning balances were not imported, purchase orders are not used to bring in new inventory, and fulfillment of sales orders are driving quantities negative. The solution to the problem is to close the loop on inventory by entering beginning balances and purchase order receipts. If you are shipping items, then you have inventory, so it stands to reason, if Dynamics GP has negative quantity balances, then the inventory numbers in the system are not accurate.

Was this reply helpful? Yes No