Detailed Financial Log Report

Maintenix generates a transaction log of every financially-significant materials activity that occurs. To see these details and analyze the financial transactions that occurred within a specified reporting period, you can run the Detailed Financial Log Report. You can choose to see the details of all transactions within a specific date range, or you can select specific account types and codes.

The debit and credit amounts shown for each transaction in this report, are summed up in the Summary Financial report.

When there are unexpected changes in costs, you can use the Detailed Financial Report to analyze all transactions against a specific account and to identify discrepancies.

The transactions in the report are sorted by transaction date and transaction number.

To run this report on demand (for auditing purposes), select the Detailed Financial Log Report from your role menu. To transmit this report information to an external financial system, the Finance API is recommended.

Specifications

The Detailed Financial report contains the following parameters:
Note: Bold fields are mandatory.
  • Start Date: The start date and time of the report period.
  • End Date: The end date and time of the report period. (A typical reporting period is one month.)
  • Account Code: Select ALL or select account codes from the fnc_account table.
  • Account Type: Select ALL or select account type codes from the ref_account_type table.

Report Detail

The following table lists the report fields along with their description and location in Maintenix.

Note there is an existing limitation of the report: If a consumable part number is not repairable, then for the TURN IN transaction the report does not show the Aircraft, Work Package, WP Supply Location, or WP Location.

Report Field/Column name Description Maintenix UI page Maintenix UI field
Transaction ID Transaction identifier Transaction Search Transaction ID
Date Transaction date Transaction Details Transaction Date
Type Transaction type Transaction Details Transaction Type
Description Transaction description Transaction Details Description
Aircraft Registration code Inventory Details Registration Code
Work Package Work package order Work Package Details Work Package Number
WP Supply Location Supply location code Location Details Parent Location
WP Location Location code Location Details Code
OEM Part No Original Equipment

Manufacture part number

Part Details OEM Part Number
Serial No Inventory serial number Inventory Details OEM Serial No
Order No Order number

PO Details or other order details pages

Order Number
Invoice No Invoice number PO Invoice Details PO Invoice Number
Account Code Financial account code Account Details Account Code
External Ref. Financial account external reference code Transaction Details External Reference
Currency Currency code Transaction Details Debit/Credit
Account T-Code

Financial T code (account code or transaction code) that is used to integrate with an external system).

Transaction Details T Code
Account Type Financial account type Transaction Details Account Type
Debit Debit amount Transaction Details Debit
Credit Credit amount Transaction Details Credit