Payment Status shows ~No Value~ in CAA

Molly P

My user often creates payables subledger analyses. After migrating reports to CAA, I can no longer view the Payment Status of an invoice when adding invoice journal details to the analysis. Key fields used are journal name, batch, invoice number, net transaction amount, payment status. When pulling payment status into this query, the value shows as "~No Value~". The correct value appears only for payments journals, but these are not the accounts being analyzed. Can we add something else to the visualization to make the payment status for an invoice appear?

Sushil Dhoot-Oracle

Hi Molly, the "Payment Status" that you see in CAA currently or even GL Account Account Analysis earlier is the status of payment transaction like Issued, Void, Reconciled, Negotiated, etc. and it works with Payment transactions and related journals. If you are looking for Invoice Payment Status, then its not supported as a column by design because Payment Status is at the Invoice Installment level and the data grain of AP Invoices in CAA is at the distributions.