Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Michael Beaupre]

We’re seeing a negative quantity on-hand (QOH) in our inventory in GP after doing an Inventory Adjustment.  Has anyone else seen a negative QOH?  Is there a way to prevent a negative QOH?

——————————
Michael Beaupre
Systems Analyst
Connexus Energy
Ramsey MN
——————————

[Charles Allen]

?There is an option in Inventory Setup for overriding quantities. Make sure that option is not enabled.

——————————
Charles Allen
Senior Managing Consultant
BKD Technologies
Houston, TX
——————————
——————————————-

[Josh Kenyon]

We see that happen occasionally and most of the time running the Inventory Reconcile on that particular item will correct it.

——————————
Josh Kenyon
Automated Dairy Systems
Jerome ID
——————————
——————————————-

[Michael Beaupre]

In Inventory Setup, we verified that the three Override check-boxes are unchecked and they are.  Might there be another Inventory Setup that we’re overlooking?

We did these steps in an attempt to fix the negative Quantity on-hand (QOH) but no luck:
1.  Ran Checklinks against Inventory
2.  Ran PSTL Item Reconciler
3.  Ran PA Reconcile Item Quantities

We often have negative quantity ALLOCATED and then we run PSTL Item Reconciler and Reconciler fixes those.

 

 

——————————
Michael Beaupre
Systems Analyst
Connexus Energy
Ramsey MN
——————————
——————————————-

[Katie Pieczynski]

Do you have any of those items allocated and if so when you click on the allocation link does it show an actual document number that it is allocated to?  This happens to us and it is actually the sales work table that we have to run check links on.

——————————
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
——————————
——————————————-

[Michael Beaupre]

Hi Katie, 
Thank you for your reply.  You say “when you click on the allocation link…”  On which screen does this allocation link appear?  Thank you.

——————————
Michael Beaupre
Systems Analyst
Connexus Energy
Ramsey MN
——————————
——————————————-

[Katie Pieczynski]

When you go into Item Inquiry and click the Allocated link it will open up another window and show you everything that Item is allocated to.  (SOP doc and Inventory transactions)  If there is nothing showing in the Item Allocation Inquiry screen then I would do a check links on sales work and then try reconciling the item.

——————————
Katie Pieczynski
Accounts Receivable Manager
DANSR
Champaign IL
——————————
——————————————-

[Michael Beaupre]

I’m with you now Katie.  I will experiment with this (in TEST).  Thank you for your post!

——————————
Michael Beaupre
Systems Analyst
Connexus Energy
Ramsey MN
——————————
——————————————-