Unwinding debtors into future period

grirvine

Hi,

 

I have a line item with the balance for each invoice which is a list at the end of the month 

 

I have another line item for the predicted timeperiod that cash is expected 

 

I want to forecast cash received based of only the current months closing position. 

regards 

ChrisAHeathcote

You need to set up a properties module for you invoices list which you can use to define the expected payment delay.
If your target module is dimensioned by period month then in you properties module allocated a number for each invoice that indicates how many months you expect to wait for payment.
In your target module we can use the function POST to post into future periods based on the number entered in the properties module for each invoice.
In the forecast cash line item use a formula such as the following;
= POST(closing balance, properties module.expected delay)
The formula will offset and post the value from the closing balance line item the specified number of periods forward into future months.