Calculate Inventory Catch up date
Is there any way or function to calculate inventory catch up date?
i want to calculate 1st date that recover the sales plan.
|Jul 01||Jul 02||Jul 03||Jul 04||Jul 05||Jul 06||Jul 07||Jul 08|
|Catch Up Date||Jul 08||Jul 08|
in this case,
sales of july 03 will be recovered by july 05 production 10pcs and july 08 production 10 of 20pcs
so the sales is recovered completery at july 08. i want to calculate this date.
Sales of july 07 will be recovered by July 08 production 10 of 20pcs
so the sales is recovered completery at july 08.
please let me know the idea.