Overview
The I/C Transaction History report lists all transactions posted for the items assigned to the account sets you select within the period you specify. The report shows the net change to the inventory control account for the account set and period.
Important! Transactions are accumulated for this report only if you use the Keep Transaction History option in the I/C Options screen.
Transaction history is accumulated and reported according to the settings in the Fiscal Calendar in Common Services.
Transactions cleared in the Clear History screen are not included in the report.
When to Print
Print the report when you want to review transaction history by item or list transactions from all posting journals.
The report can also be used 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 date, fiscal year, and fiscal period of each transaction.
- The document number entered with the transaction.
- Day-end numbers, assigned sequentially each time Day End Processing is run, and entry numbers indicating the order in which each transaction was processed by Day End Processing.
- If you use multicurrency ledgers, the source currency and exchange rate for each transaction.
- The amount of the transaction in source currency. Amounts that credit the general ledger inventory control account (such as shipments) are displayed in parentheses.
- Debit or credit amounts for each transaction, to be posted to the account set's general ledger inventory control account. In multicurrency ledgers, these amounts are in the functional currency.
- The net change posted to the inventory control account from all transactions posted for the item.
- The opening and ending balances for the item's inventory control account when you sort the report by account set.
- The opening and ending balances and the net change for each location and account set when you sort by account set.
If you sort by item number, the report shows only the net change for each location and account set.