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
You could create a list based on Order Paid Status and check it for Analytics and then build your dashboard from the Finance Cube using that list as a filter. Use the Generate a List utility to schedule it to update daily and that should keep your dashboard up to date.