Financial transactions

Maintenix generates a transaction log of financially significant activities related to materials. For example, when you create inventory, inspect received inventory as serviceable, or issue inventory, Maintenix records the financial transaction.

Maintenix can send the transaction log to an external financial system using the Finance API. You can also view the transactions within Maintenix, if you have the correct security privileges, using the Transaction Search page.

Financial transactions are recorded for the following actions:

Financial transaction types and their triggers
Financial transaction	A financial transaction is logged when
ADJPRICE (price adjustment)	The unit price of a consumable part is adjusted in Maintenix. This transaction accounts for the change in value. New AUP = provided value. New Total Value = new AUP * current Total Qty.
ARCHIVE (archive inventory)	Consumable inventory is archived. New Total Qty = current Total Qty - Archived Qty New total value = current total value - AUP* Archived Qty AUP unchanged
CHGFINTP (change financial type of part)	The financial type of a part number is changed to a Rotable or Expense financial type: this action debits the financial type change account (CHGFINTYPE). The financial type of a part number is changed from a Rotable or Expense financial type: this action credits the financial type change account (CHGFINTYPE).
CHGOWN (owner changed)	The owner of a consumable inventory item changes. From local to non-local owner: New Total Qty = current Total Qty - Changed Qty New Total Value = current Total Value - AUPChanged Qty AUP unchanged From non-local to local owner: New Total Qty = current Total Qty + Changed Qty New Total Value = current Total Value + AUPChanged Qty AUP unchanged
CRTINV (create inventory)	Consumable inventory is created locally. New Total Qty = current Total Qty + Created Qty New Total Value = current Total Value + AUP*Created Qty AUP unchanged This transaction is not logged when inventory is received in a shipment and an inventory record is automatically created in Maintenix.
INSP (receive inventory)	Ordered parts are: Received as RFI (ready for issue). In this case the Force Inspection on Receipt check box is not selected for a part number, so it's status is RFI upon receipt. Received and inspected as serviceable. The inventory condition changes from INSPREQ to RFI (or RFB if inventory is incomplete) when the inspector inspects inventory as serviceable. Received and inspected as unserviceable. The inventory condition changes from INSPREQ to REPREQ. While the item is not RFI, you have taken ownership of it. For ordered kits that are received, a financial transaction is logged when the inventory is inspected as serviceable. New Total Qty = current Total Qty + Received Qty New Total Value = current Total Value + PO Line Unit Price* Received Qty; if PO Line does not exist use current AUP New AUP = new Total Value / new Total Qty; if New Total Qty is 0, New AUP = 0 This transaction is not logged for purchases of non-part items such as services and warranties. Such items are not treated as assets, but as simple charges to an expense account.
ISSUE (issue inventory)	Consumable inventory is issued. New Total Qty = current Total Qty - Issued Qty New Total Value = current Total Value - AUP* Issued Qty AUP unchanged
PAYINVC (validate invoice for payment)	An order invoice is validated for payment. Separate transactions are logged for each line in the invoice. Transactions are logged for part and non-part line items. If there is a price difference between PO and Invoice, calculate Adjustment Amount = (On Hand Qty/(Issued Qty+On Hand Qty)*Price Difference New Total Value = current Total Value + Adjustment Amount New AUP = new Total Value/new Total Qty; new AUP is set to 0, if new Total Qty is 0
QTYADJ (quantity adjustment)	The quantity of consumable parts on hand is adjusted. This can happen when parts are lost or discrepancies are found during cycle counting. QTYADJ is also logged when a part number is changed - in this case, two transactions are recorded because two part numbers are impacted. (Qty, AUP, Total Value). New Total Qty = current Total Qty + Adjusted Delta. New AUP = (current Total Value + AUPabs(Adjusted Delta))/new Total Qty; The AUP is recalculated only for debit (Adjustment Qty >0) transaction during part number change, otherwise the new AUP=current AUP. New Total Value = new AUPnew Total Qty
RTNVEN (return inventory to vendor)	Inventory is received and subsequently returned to a vendor. The account that's debited by the transaction depends on whether the invoice for the item was paid. If the item is returned to the vendor before it's inspected, the item was never financially received - therefore when it's returned to the vendor, no financial transaction is logged.
SCRAP (scrap inventory)	Consumable inventory is scrapped. New Total Qty = current Total Qty - Scrapped Qty New Total Value = current Total Value - AUP* Scrapped Qty AUP unchanged
TURNIN (turn in inventory)	Consumable inventory is turned in. New Total Qty = current Total Qty + TurnedIn Qty New Total Value = current Total Value + AUP* TurnedIn Qty New AUP = new Total Value / new Total Qty, but only if a previous issue transaction exists (expected turn in) and has a different unit price than the current AUP
UNARCH (unarchive inventory)	Consumable inventory is unarchived. New Total Qty = current Total Qty + Archived Qty New Total Value = current Total Value + AUP* Archived Qty AUP unchanged
UNDOINSP (undo receipt of inventory)	Receipt of inventory is reversed. For example, inventory for a purchase order was received and inspected as serviceable, but the purchase order is then converted to an exchange order. The UNDOINSP transaction is logged to negate the INSP transaction. New Total Qty = current Total Qty - Received Qty New Total Value = current Total Value - PO Line Unit Price * Received Qty; if PO Line does not exist use current AUP New AUP = new Total Value / new Total Qty
UNDOISSUE (undo the issue transaction)	Consumable serialized inventory is issued, and then the Convert Purchase to Exchange button is used to transform the original purchase order to an exchange order. To trigger this transaction the original PO must be issued and the inventory must be received. The Unit Price on the original PO Order Line must be greater than 0, the financial class of the part must CONSUM (FINANCE_TYPE_CD = CONSUM). New Total Qty = current Total Qty + Issued Qty New Total Value = current Total Value + AUP* Issued Qty AUP unchanged Note that this is a different transaction than when you click the Undo Issue button to reverse the issue of consumable inventory. In this case a TURNIN transaction is logged and Maintenix undoes the issue transaction for the item.
UNSCRAP (unscrap inventory)	Consumable inventory is unscrapped. New Total Qty = current Total Qty + Scrapped Qty New Total Value = current Total Value + AUP* Scrapped Qty AUP unchanged

Maintenix logs a transaction when the inventory in a purchase order is received, but it does not log a transaction for the following order types:

Borrow Orders: Maintenix does not accrue borrow costs. This means that there are no financial transactions recorded when the borrowed item is received and used. The only financial transaction for a borrow occurs when the invoice is validated for payment.
Repair Orders: When you repair a part, repair costs do not affect the balance of the asset account in any way. Maintenix treats all repairs as a simple expense.
Miscellaneous Order Lines: When you purchase non-part items such as services and warranties, the purchases are tracked using miscellaneous lines on purchase orders. Miscellaneous (non-part) purchases are not treated as assets in Maintenix; they are simple charges to an expense account.

The MANUAL_AUP_CALCULATION configuration parameter controls whether the average unit price (AUP) is calculated for the transactions that require AUP recalculation.