Hello.

I am having an issue with a product tracked by serial number because on hand quantity and value is 0 because the product was already sold but available quantity is -1.

I tried inventory adjustment and if I change on hand quantity to 1 then available quantity changes to 0 and value changes to positive from 0, but if I change on hand quantity back to 0 (real quantity), the available quantity changes to -1.

Could you please tell if you fixed it?

Thanks :)

Hi,

This could be because of several reasons,

One possible reason is that there can be negative quantities in one or more inventory adjustment entries.  If you have entered negative quantities in one or more inventory adjustment entries for the particular product, it will result in negative quantities and total value in inventory valuation.

To fix this issue, you can create a new inventory adjustment entry with a positive quantity to adjust the inventory upward. This will increase the on-hand quantity and the total value in inventory valuation.

The same can happen in stock move also, if it has negative quantities, you can create a new stock move with a positive quantity to move the product back into the inventory. This will increase the on-hand quantity and the total value in inventory valuation.

it's also possible that there may be error in the system configuration. You may want to check the product's configuration, such as the product type, product category, and inventory valuation method, to ensure that they are set up correctly. In any case, it is recommended to review the inventory transactions for the particular product to determine the reason for the negative quantities and total value in inventory valuation. Once you have identified the cause, you can take the necessary steps to fix the issue.

Regards