I have a challenge that I’m not quite able to find content around despite my best effort at Google, YouTube and this forum.
I am looking to build a cash flow forecast based off of a dynamic list of unpaid invoices sent to customers. For each invoice I know the invoice number, customer name, payment due date and amount. I would like to be able to toggle the date in which we think we will be paid based on the due date - either sooner or later - to be reflected in a cash flow forecast.
The list of unpaid invoices will be changing over time as invoices are paid (dropping off) or sent (coming on). Is there a way to be able to toggle the date of each invoice via a parameter without having to manually create a parameter for each invoice that lands on the list?
Thanks in advance!