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
- 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 |