The Excel formula `I_EOL_TXN_QUANTITY` retrieves the total item quantity of transaction lines from Exact Online. Parameters: - `divisionCode`: division code. - `dateFrom`: date from. - `dateTo`: date through. - `glAccountCode`: a general ledger account code or a range of general ledger accounts. See [[General Ledger Account Range]]. - `accountCode`: an account code (customer, supplier, other). - `itemCode`: an item code. - `projectCode`: a project code. - `assetCode`: an asset code. - `itemCode`: item code. - `costCenterCode`: cost centre code or a range of cost centres. See [[Cost Centre Range]]. - `costUnitCode`: cost unit code or a range of cost units. See [[Cost Unit Range]]. - `currencyCode`: a currency code. - `journalCode`: a journal code. - `vatCode`: a VAT code. - `yourRef`: a your reference value. - `reportingYear`: financial year. - `reportingPeriodFrom`: financial period from. - `reportingPeriodTo`: financial period to. - `entryNumberFrom`: entry number from. - `entryNumberTo`: entry number to. Returns: total item quantity of selected transaction lines. `I_EOL_TXN_QUANTITY` allows selection by additional dimensions such as item, asset, project or customer, compared to the other balance formulas. However, use of `I_EOL_TXN_QUANTITY` is significantly slower than other formulas that retrieve balances across transaction lines, since it has to retrieve all associated transaction lines. In a large company there can be millions of transaction lines and typical performance of retrieving 1.000 transaction lines is 3 seconds.