Source information

The main source for the Accounts Payable Operational Metrics model is the M3 BE table FPLEDG. The table is filtered by internal reconciliation code 9 to retrieve only fully paid invoices. The transactions are captured in the invoice currency. The term division currency is used in M3 Analytics. Some additional data is retrieved from the M3 BE table FGLEDG, such as invoice and payment amounts in local currency, accounting information, FAM entry ID, and FAM function. The model supports analysis at supplier invoice level.

The Measure dimension of AP Operational Metrics contains the calculation Distinct AP Employees, which is a distinct count of employees. The definition of the calculation is stored in the repository. It is used in reports as No. of Employees.

The Time dimension is based on the internal reconciliation date.