Accounting transactions

When accounting is enabled, inventory consumption and sales shipping transactions are created. They can be viewed and synchronized in ALIX settings.

Shipping transactions

A Sales Shipping type transaction is created in ALIX under the following conditions:

For inventories:

  • Debit/Credit = Inventory unit cost x shipped measure x inventory supplier exchange rate
  • Debit Account: Expense account selected in the item’s Accounting tab or the Default expense account defined in configurations.
  • Credit Account: Asset account selected in the item’s Accounting tab or the Default inventory asset account defined in configurations.

For cards:

  • An asset account must be defined on the cards.
  • Child cards will go through the same transaction as their parent.
  • Debit/Credit = Inventory unit cost x consumed measure x inventory supplier exchange rate
  • Debit Account: Expense account selected in the item’s Accounting tab or the Default expense account defined in configurations.
  • Credit Account: Asset account defined in the card

For all cases:

  • The inventory must be of type Quantity and value, otherwise it is not taken into account.
  • The lines in the transaction are grouped by account and reporting tags (defined on the line items associated with the inventory or parent card).

Consumption transactions

An Inventory Consumption type transaction is created in ALIX when there is inventory consumption of Quantity and value type in a card.

Debit/Credit = Inventory unit cost x consumed measure x inventory supplier exchange rate

Depending on these different cases, the accounts will be as follows:

The card has a default inventory production of type Quantity and value.

  • Debit Account: Asset account defined in the product item or the default inventory asset account defined in configurations.
  • Credit Account: Asset account of the consumed item or the default inventory asset account defined in configurations.

The card does not have a default inventory production of type Quantity and value, and the Asset account field is defined on the card.

  • Debit Account: Card asset account
  • Credit Account: Asset account of the consumed item or the default inventory asset account defined in the configurations

The card does not have a default inventory production of type Quantity and value, and the Asset account field is not defined on the card.

  • Debit Account: Expense account of the item consumed or the default expense account defined in the configurations
  • Credit Account: Asset account of the consumed item or the default inventory asset account defined in the configurations

Note: if the debit and credit accounts are the same, no transaction is created.

View transactions

  1. In Settings, go to the Accounting section, then Transactions.
    the Accounting section of Settings with the Transactions tab selected
  2. Click on the desired transaction to view its details.
    the details of an accounting transaction open

Synchronize transactions

  1. In Settings, go to the Accounting section, then Transactions.
  2. Select the desired transactions, then click Sync in the top left of the list.
    the transaction list with transactions selected and the Sync button visible in the top left
    OR
    Click Synchronize all at the top right of the window.
    the Synchronize all button in the top right of the window
  3. Once synchronized, the sync status is updated.
    the transaction list with the status updated after synchronization
  4. If a transaction fails to synchronize, an error message is sent. It appears in the transaction list and in the transaction details window.
    a synchronization error message shown in the transaction list

a synchronization error message shown in the transaction details window

Reverse a transaction

When an action that created a transaction is reversed:

  • If the associated transaction is synchronized, a new reversal transaction is created.
  • If the associated transaction is not yet synchronized, it is deleted.

Mark as synchronized

It is possible to mark a transaction as synchronized when it has been processed manually.

  1. In Settings, go to the Accounting section, then Transactions.
    the Accounting section of Settings with the Transactions tab selected
  2. Select the transactions wanted, then click More Actions -> Mark as synchronized at the top of the list.
    the More Actions menu open with the Mark as synchronized option
  3. The transaction status is updated.
    the transaction list with the status updated
  4. Manually synced transactions can also be desynced by clicking More Actions -> Remove mark as synchronized.
    the More Actions menu open with the Remove mark as synchronized option