Skip to main content
Solved

Updating item in warehouse quantity available for shipment will go negative

  • June 8, 2026
  • 7 replies
  • 58 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 😊

7 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+13

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

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 😊