How to Adjust Inventory Value of Historical Stock Balance

A. Adjust Inventory Value when item have qty = 0 and Inventory Value is positive amount

for QTY = 0 , value = 200

1. adjust IN 1 qty , value = 0 .
result : qty = 1 , value = 200

2. adjust OUT 1 qty , with value 200
result : qty = 0 , value = 0

B. Adjust Inventory Value when item have qty = 0 and Inventory Value is negative amount

for QTY = 0 , value = -450

1. adjust IN 1 qty , with value 450
result : qty = 1 , value = 0

2. adjust OUT 1 qty , value = 0
result : qty = 0 , value = 0

C. Adjust Inventory Value when item qty > 0 and Inventory Value is negative

qty = 19, value = -636.12 , correct MA Cost = 76

or you can try to adjust make it qty = 0 and value = 0 first .

1. adjust out 19 qty , value = 0
result : qty = 0 , value = -636.12

2. adjust add 1 qty , value = 636.12
result : qty = 1 , value = 0

3. adjust out 1 qty , value = 0
result : qty = 0 , value = 0

4. adjust in 19 qty , value = 76
result : qty = 19 , value = 1444

D. Adjust Inventory Value when item qty < 0 and Inventory Value is positive (to zerolize Inventory Value)

qty = -15, value = 370.00 , correct MA Cost = 0.0

1. adjust in 16 qty , value = 0
result : qty = 1 , value = 370.00

2. adjust out 1 qty , value = 370.00
result : qty = 0 , value = 0

E. Adjust Inventory Value when item qty < 0 and Inventory Value is negative (to zerolize Inventory Value)

qty = -22 , value = -733.00 , correct MA Cost = 0.00

1.adjust in 22 qty , value = 0
result : qty = 0 , value = -733.00

2. adjust in 1 qty , value = 733.00
result : qty = 1 , value = 0

3. adjust out 1 qty , value = 0
result : qty = 0 , value = 0