Overview
The I/C Transaction History report lists all transactions posted within the period you specify. You can limit the report to a range of account sets or range of item numbers.
The report also shows the net change to the inventory control account for the account set and period.
Transaction history is accumulated and reported according to the settings in the Fiscal Calendar in Common Services.
Important! Transactions are accumulated for this report only if the Keep Transaction History option is selected on the Processing tab of the I/C Options screen.
When to Print
Print the report when you want to review transaction history by item or list transactions from all posting journals for a specific accounting period.
You can also print the report at the end of an accounting period to check the balance of your general ledger control account, since the total for the account sets on the report should match the total for the general ledger control account.
Information Printed on This Report
The following information is shown for each transaction:
- Date, fiscal year, and fiscal period.
- Document number entered with the transaction.
- Type of transaction.
- Day-end number (assigned sequentially each time Day End Processing is run) and entry number (indicating the order in which each transaction was processed by Day End Processing).
- Quantity and unit of measure.
- Source currency and exchange rate for each transaction, If you use multicurrency accounting.
- Debit or credit amounts, to be posted to the account set's general ledger inventory control account. In multicurrency ledgers, these amounts are in the functional currency.
The following information is also shown on the report:
- Opening and ending balances for the item's inventory control account (when you sort the report by account set).
- Opening and ending balances and the net change for each location and account set (when you sort by account set).
- Net change posted to the inventory control account from all transactions posted for the item.
- Number of transactions included.