How to apply sum function(or any) on time line item?
Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens
In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days)
Now in Expected Repair item return module, I have expected line item - What I'm trying to do is or requirement is to take from the incoming(Cee-Cee Shop module) line item to Expected(Expected Repair item return module) line item on the basis of Expected Cee-Cee return date line item(Cee-Cee Shop module)
End result will be on 1st Oct 19 when I enter incoming as 100 in Cee-Cee Shop module since the lead time is 15 days the incoming no-goes onto Expected line item but shows only on 16'th Oct 19.
I've also attached an Excel file to get a better understanding.
Thanks & Regards
Sorry if there are any language mistakes.