Skip ke Konten
Pertanyaan ini telah diberikan tanda
1 Balas
6002 Tampilan
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
Buang
Avatar
Prakash Makwana
Jawaban Terbai

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
Buang
zentalucod@gmail.com
Penulis

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