What is the Process Sequence for Inventory Transactions on the Same Date?

Transactions are processed in the following sequence: Quantity, Amount, Cost Layer, Entry Sequence

Transaction Dates are very important when reviewing how Acctivate inventory transactions are processed. This is the behavior in Acctivate 7.0 and a significant change from prior versions, where transaction date and/or entry sequence were primarily used.

For example, the Cost of Goods Sold for a sales invoice is based on the inventory transactions on or prior to the invoice date. That’s a pretty obvious scenario, but what happens with multiple transactions are entered on the same date?

Multiple transactions entered with the same date are processed in a consistent sequence regardless of what time of day the transactions were actually entered. This is an important concept if you have products with different types of transactions on a given date.

Regardless of the Cost of Goods Sold method (i.e., FIFO or Average), the following sequence is used when evaluating inventory transactions for a single date:

Transactions are first sequenced by Transaction Type:

  1. Beginning Inventory from QuickBooks
  2. Receipts and Assemblies with positive quantities
  3. Inbound Transfers (the TO warehouse side of a transfer)
  4. Added Cost Receipts
  5. All Other Transactions
  6. Balance Adjustments

Transactions in one of the above categories are processed in the following sequence:

  1. Quantity
    • Largest quantity first
    • Smallest quantity last

  1. Amount
    • Transactions with same quantity are sequenced by Amount/Value
    • Largest amount first
    • Smallest amount last

  1. Cost Layer (FIFO/LIFO only)
    • Transactions with same quantity and amount are sequenced by FIFO/LIFO Cost Layer.

  1. Entry Sequence
    • Transactions for same quantity, amount (and layer) are sequenced by original entry sequence