Column returning no value when combining Payables Invoices and Payment History subject areas
I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage invoice screen. The drill through to the detailed analysis is handled with prompts.
The most relevant information for our accountants is the invoice approval status, invoice paid status and payment status. This requires the subject areas Payables Invoices - Transactions Real Time and Payables Payments - Payment History Real Time.
When they drill on a value where a payment does not exist, the summary analysis will pass the filter 'is null' to the detail analysis. This is where the problem occurs, because it will not return any values. Somehow the values are not matched with null, although in my understanding this is the definition of 'non-existing'.