Skip to Content
Menu
This question has been flagged
2 Replies
5884 Views

In inventory valuation the product quantity and total value is showing negative but the product on hand quantity is positive in product template.

I have created inventory adjustment entries for particular product, is this any reason for this.


Avatar
Discard
Best Answer

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 :)

Avatar
Discard
Best Answer

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

Avatar
Discard

I have zero QTY on hand of a storable product and my inv. val report shows $-36k value. This is on an archived product. Is there anyway to force the value to the correct $0?

Related Posts Replies Views Activity
2
Jul 25
3049
1
Feb 25
1492
1
Jan 16
6549
1
Jun 25
697
1
Jun 25
750