Skip to main content
Solved

Updating item in warehouse quantity available for shipment will go negative

  • June 8, 2026
  • 8 replies
  • 95 views

Forum|alt.badge.img

Any idea about this error when creating a Purchase Return from a Purchase Receipt and how do I resolve this? Item is serialized, so I ran Inventory Lot/Serial History and don’t see the item going out of warehouse location. See snippet below with only one transaction happened in that serial number.

This is the POR with Line Type ‘Goods for MFG’ but when I tick each line and create a return, line type is ‘Goods for IN’ and unable to change.

 

Best answer by MarkD

I found the issue and it was due to item being allocated to a production order. I removed the ‘Location’ filter in Inventory Allocation Details screen and it showed that it’s allocated to the production order. Thanks for your inputs 😊

8 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+13
  • Captain II
  • June 8, 2026

Hi ​@MarkD 

Try checking your "Inventory Balance" to see if that item, by Location & Lot/Serial, has enough "Available" items to make a "Purchase Return".

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Varsity I
  • June 8, 2026

Hi ​@nhatnghetinh - there is stock on hand but 0 available.

Inventory Balance
Inventory Allocation Details

 


nhatnghetinh
Captain II
Forum|alt.badge.img+13
  • Captain II
  • June 8, 2026

Hi ​@MarkD 

There is stock on hand but 0 available => Please check the following reports to find out why available = 0.

 

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Varsity I
  • June 8, 2026

Hi ​@nhatnghetinh - Inventory Allocation details was sent prior to your response. Below is a screenshot of Inventory Transaction history. I’ve checked all these reports already and they don’t make sense. Item hasn’t been issued out yet based on those reports. I don’t know if it helps you provide me an answer, but the Purchase Receipt that I was trying to return has a ‘Goods for MFG’ line type.

 


Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • June 8, 2026

Hello ​@MarkD ,

Did you already follow the troubleshooting steps and solution documented in this previous post by Irina? (Link) 

I hope this previous post helps lead you to your solution.


Forum|alt.badge.img
  • Author
  • Varsity I
  • June 9, 2026

Hi ​@Laura03 - I did, but got the same error. Allowing negative stock is a workaround, but I wouldn’t do that. I’ve raised a ticket already as it could be potential system glitch unless you have another idea 😊


Forum|alt.badge.img
  • Author
  • Varsity I
  • Answer
  • June 9, 2026

I found the issue and it was due to item being allocated to a production order. I removed the ‘Location’ filter in Inventory Allocation Details screen and it showed that it’s allocated to the production order. Thanks for your inputs 😊


Forum|alt.badge.img
  • Freshman I
  • August 16, 2026

@MarkD , 

The most likely cause is that the serialized item’s receipt transaction is not being recognized as available for return, even though the serial history shows the original receipt.

I would check these first:

  1. Verify the serial number’s current warehouse/location — confirm it is still available in the same location as the Purchase Receipt.
  2. Check the serial status — make sure it is not already issued, transferred, consumed, or associated with another transaction.
  3. Review the Purchase Receipt line — confirm the serial number is correctly linked to the receipt and inventory transaction.
  4. Check for inventory synchronization issues — if the serial history shows only the receipt but the return still fails, the inventory/serial balance may be inconsistent.
  5. Rebuild/recalculate inventory balances if your ERP provides that utility, then retry the Purchase Return.

Since the serial history shows only one transaction, I would suspect a serial/inventory balance mismatch or incorrect warehouse/location assignment rather than the Purchase Return itself.