Invoices and Reconciliation Details reports
The measures used in Invoices and Reconciliation Details reports are sourced from the AR Invoices fact. These measures are analyzed by Accounting Date and use the Sum aggregation. These reports also use the Show N Records to filter the Top N categories.
Top Average Reconciliation Days by Category
Description: This report analyzes the payers that have the highest average reconciliation days. You can change the category to the M3 user that processed the customer invoice using the column selector.
Measure: Invc Avg Days – Invc and Due, Invc Avg Days – Invc and Recon
Chart type: 2 data series grouped column chart
Column selector: Payer, User – AR
Top Invoice Record Changes by Category
Description: This report analyzes the payers that have the highest invoice record changes. You can change the category to the M3 user that processed the customer invoice using the column selector.
Measure: No. of Record Changes, Invc Avg Days – Invc and Due
Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 points chart on Y axis 2
Column selector: Payer, User – AR
Top Payment Reversals by Category
Description: This report analyzes the payers that have the highest number of payment reversals. You can change the category to the M3 user that processed the customer invoice using the column selector.
Measure: No. of Pmt Reversals, No. of Pmts
Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 points chart on Y axis 2
Column selector: Payer, User – AR
Accounts Receivable Details
Description: This report shows the underlying factors for the average days it takes for a payer to reconcile payment for their issued invoices.
Measure: Invc Avg Days – Invc and Due, Invc Avg Days – Invc and Pmt, Invc Avg Days – Invc and Recon, No. of Record Changes, No. of Pmt Reversals, No. of Pmts
Chart type: Table