Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
6003 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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.

Awatar
Odrzuć
Autor

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