Skip to Content
This question has been flagged
1 Reply
6671 Views
Avatar
zentalucod@gmail.com

Need help on how to update the FORECASTED quantity in the item record. 

I created Inventory adjustment to correct the item count, the create a new Sales Orders and Confirmed and Validated, but the O HAND and FORECASTED quantities does not reflect the new quantities. hope you can help me on this. thanks

Avatar
Discard
Avatar
Prakash Makwana
Best Answer

Hello dear,

Forecasted quantity mainly reflects when the transfer is ready for the process and On Hand quantity reflects when the transfer process will be done. 

There is one formula for the forecasted quantity,

Forecasted quantity = Onhand quantity - outgoing shipment product quantity + incoming shipment product quantity.

Thanks.

Avatar
Discard
zentalucod@gmail.com
Author

Thanks, but however my scenario is like these:
1. Created Inventory Adjustment (Item: ABC, quantity: 100) date: March 13
Onhand : 100
Forecasted : 100
2. Created Sales Order
Item : ABC
Quantity : 20
Confirmed and Validated
But on the Item record :
ONHAND is still 100, FORECASTED is still 100

it does not change eventhough i already delevered the item.

Hope you can help me on this. thanks