HiFinance would like to identify unpaid invoices for schools visits. I have an existing Schools Visits dashboard which includes Order Paid Status, but I cannot add Payment Method as that field is not available in the Seats & Tickets cube.
I tried to create a new pivot table using the Finance cube, which does include Payment Method, but then Order Paid Status is not available in the Finance cube?!
I'm thinking this should be a fairly straightforward ask, so am I missing something? Does anyone else have a way to report on unpaid invoices?
Many thanksBest wishes
Dawn
Hi Dawn,
I had been struggling with this as well. I ended up using the Seats and Tickets Cube and the Total Ticket Unpaid Amount greater than /equal to 1 as the criteria.
I am new so I am not positive that that is the way, but it has started working for me.
Laurel