Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
6004 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
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