Is there any way or function to calculate inventory catch up date?
i want to calculate 1st date that recover the sales plan.
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.
Hi sasakawar.If you're using Anaplan build-in timescale you'll need to add additional line items and modify them as as per file below.A word of explainationBoolean items serves as watchers to indicate if specified day is Catchup date and if to display it for previous dates. You may want to adjust formulas as needed.
Thank you for your advice.
I tried to your idea, but i can not imagine how to adjust to meet requirements.
It seems to be possilbe to calc total catch up date, but hard to calc catch up date of each sales.
Please refer attached file.
i will keep on trying...
Hi SasakawaI see where I misunderstood your example. I'll check if there is anything else that can be done to reach that goal. Let me know if you figure out the solution on your own.Best RegardsLukasz.
Should this not work for you?