Qty will go Negative in the Warehouse when creating a Shipment

You need to resolve the -128 in <UNASSIGNED> location first.  Acumatica will aggregate quantity in all warehouse locations so it thinks you have -121 available right now.  The -128 could be fixed with an Inventory Adjustment if you don’t have a business need to drill into it to find where those transactions occured.  You may also get information on the negative quantity in the Inventory Transaction History report.

Hi ​@rdillard64 

Along with what ​@josborn02 stated, what does the Inventory Allocation details show for that item? Purchase Orders are usually what creates the negative qty.

This is a Manufactured part and the -128 is coming from Booked Sales orders. 

I was told that was normal to see a negative in the UNASSIGNED location.    it is not uncommon to see the high negative numbers like this.  Below is a different inventory item .  we have ben able to confirm shipments and invoice with no issued.  we invoiced orders yesterday..  

Below is a careen shot of Inventory Allocation Details for the part in Question. 

Check your Item Class settings, check the ‘Allow Negative Quantity’ checkbox, and try to process the transaction again.

Check the allow negative check box on the item class setting and refreshed my Brower and still get the error 

rdillard64 wrote:

Check the allow negative check box on the item class setting and refreshed my Brower and still get the error 

 

What location is on the Sales Order?

​@Kandy Beatty ,  i checked the Sales Order and the Warehouse is on the Line but there is no where for us to key in a location.   We went live on 12/1/24 and this i have had other errors that have stopped the shipment creation or confirmation process but thsi is the first time i have seen this one. 

i do have some order with receipt lines for RMAs   but i have 5 showing on hand this would only effect 3 pcs IF it was effecting anything.  that would leave me with 2 pcs which is all i am trying to create a shipment for. 

i have been unable to get the shipment created as of this morning and my customer is not very happy.  Thank you for all the imput. 

josborn02 wrote:

Check your Item Class settings, check the ‘Allow Negative Quantity’ checkbox, and try to process the transaction again.

 

 

This did not work. i’m going to check it back.  

​@rdillard64 

Do you shipment item with negative quantity, or are you saying you have qunatity in the warehouse.

Recalculate inventory did you executed?

Below is a screen shot of the sales order. I opened every sales order with the part number on a line and verified there are non allocated.    the -103 represents how many i have on sales orders.  All my Sales Orders have the correct warehouse on the line. 

 Screen shot below if Before Recalculating Inventory. 

Screen shot below is AFTER recalculating Inventory. 

i found something that is odd.   in Inventory allocation details there is a Sales Order that was invoiced last month and i checked and the Invoice is in the Open Status.  it still shows allocated??  Plus we did not go live until 12/1/2024 so how can it be allocated as of November?

How do i remove this allocation?   i checked the sales order and there is only one line on it for these parts. 

Open the stock item and click the Pencil icon next to Item Class.  Look for Availability Calculation and click that pencil.  Screen shot that and send it over.  I don’t think allowing the inventory to go negative is not the approach you will want to go.  

Availability Calculation Rules

Availability Calculation Rules: General Information

​@travislawson, below is our Availability Calculation Rules. All of our Production Stock Items have the same rules and actually in order get the customer satisfied we kept unchecking these, one at a time until we could create the shipment.  

i need to take a more scientific approach now that we have time the first of this month.   i see you did not check Production Demand and Allocated.  i’ll read up on the two links you referenced above to see what i am missing in our set up.  maybe we have to much checked. 

My thought would be to leave the Include Qty’s unchecked.  It’s including things that aren’t in inventory yet so.  This is where you On Hand numbers come from. 
 

The screenshot is the default settings. I would leave what you have checked. 
 

I know it doesn’t show in allocates, but are any of the SO’s linked to a production order?  If so I would unlink them then go into the SO itself and click line details and make sure allocated isn’t checked. If it’s not, click it to allocate then take it back off. 
 

Then try to ship the other order. 

​@travislawson thanks for the input.  i unchecked the included Qty and will monitor the next time Shipping calls.  and they will.  i have not tried the unlinking step.