Sorry my list includes invoices The module has time, time isn’t the parent of the invoices so for example the time selected is Jan 21 All 5 invoices have the balances as below so in a new module with time in the module I want to display mar 21 $34 apr 21 $50 jun 21 $100 balance(sum: expected period) however say the period is now mar 21 and invoice 5 still hasn’t been received so it’s now expected in Apr 21 any time period previous to mar 21 would be actuals received and I want to forecast the upcoming months receivables apr 21 being the now being $84 invoice 4 and invoice 5 thanks you for your reply
... View more