AR Invoices

The Accounts Receivable (AR) Invoices model analyzes the company’s accounts receivable performance in terms of issuing invoices, identify issues in the business process and assist in improving operational efficiency. Aside from the internal business process, the model also provides an avenue to analyze the customer’s performance in terms of payment history, overdue amount, outstanding amount and payment variances. The model shows the payment amounts received from the customer, elapsed time and dates, and trends over time regardless of the reconciliation value.

The model supports analysis of these components:
  • Receivables index
  • Average days past due or follow up
  • Payments past due or follow up
  • Invoices or amounts by invoice type (billback, write-offs, etc.)
  • Number of record changes, payment reminders

Accounting Date is used to analyze the facts in this model. See Infor M3 Analytics for M3 CloudSuites Administration Guide for a list of available dates for this model.

Source information

The main source for the AR Invoices model is the M3 BE table FSLEDG. You can display and manage AR Invoices within the Accounts Receivable.Display (ARS200) M3 program. The table is filtered by transaction code 10 and 20 to retrieve only invoices and payment transactions. The amounts retrieved from the table are in transaction currency. The division and third currency amount are retrieved from the FGLEDG table along with the FAM entry ID and FAM function. The additional information tables used in the model is the FGLEDX and FSLEDX. The FGLEDX table is used for the general ledger additional info to determine the reversed and non-reversed payments. The FSLEDX table is used for determining the invoice type. The model supports analysis at customer invoice level.