Discussions
Calculate delivery time of products not in stock
We dont have all products in stock, and deliverytime can be anywhere between 0 and 90 days. (time from order factory in china, to arrival in europe)
So it can be that from product A there are arriving 3 pieces next week, another 3 pieces next month, and another 3 pieces in 2 months time.
(different containers on the way to europe)
Now, when product A is not in stock, and having received 6 orders from clients for product A, the deliverytime for the next client would be 2 months.
(as the first 6 arrivals for product A (week 1 and month 1) are already reserved for other clients)
Is there a way in Netsuite to automatically have this deliverytime calculated for every product, for example some report where it shows for every product the current deliverytime if a client would place an order for that product at that moment?