Transaction Historical Summary Report
Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical balances based on a rollback date. The report rolls back all of the transactions for the item to the date you specify and prints the quantity, value, or balance as of that date. In addition, the value and quantity versions let you specify the source type. The report sums the transactions for the item and reports the value or quantity by source type. The report aggregates transaction source types not selected for a specific column in the Other column of the report.
You can use the Balance and Value version of the report totals to determine the gross change in monetary value of a subinventory or inventory for a period of time. For example, if you have two periods open and you want to see the prior period's inventory balance, you can roll back all transactions to the beginning date of the period. Another example would be to generate the report by value and put the rollback date as of your last physical inventory. This would allow you to audit the source transaction values that have created the change from the last physical inventory to the current inventory value.
You can also use this report to measure the volume of throughput in the inventory. The volume of the throughput is the total item quantity that has gone in and out of the inventory from a rollback date you specify to today. You can also use this report to measure the monetary value throughput for the inventory or a subinventory from a date you specify. For example, the source type sales orders and inventory transfers could be analyzed for the value transacted for the last month. By contrast, you could run the quantity option for the same source types and see the number of units transacted for the same period.
Finally, you can use the report to analyze the source of the transactions that have raised and lowered the quantity or value for the items by category. This is a useful tool for sales or purchasing evaluations of item categories.
Report Submission
Use the Transaction Reports, Cost and Period Close Reports, On-hand Quantity Reports. or Submit Requests window and enter Transaction historical summary in the Name field to submit the report.
Report Parameters
Sort By
Choose one of the following options:
| Subinventory
| Sort the report by subinventory.
|
| Item
| Sort the report by inventory item.
|
| Category
| Sort the report by category.
|
Selection Option
Choose one of the following options:
| Quantity
| Report past on-hand quantities and transaction sources that produced the quantities.
|
| Value
| Report past inventory value.
|
| Balance
| Report past inventory balances.
|
Rollback to this Date
Enter a date from which you want to report past quantity, value, or balances.
Category Set
Enter a category set. The report shows past quantity, value, or balances associated with items in this category set.
Categories From
Enter a beginning category to restrict the report to a range of categories.
To
Enter an ending category to restrict the report to a range of categories.
Items From
Enter a beginning item to restrict the report to a range of items.
To
Enter an ending item to restrict the report to a range of items.
Subinventories From
Enter a beginning subinventory to restrict the report to a range of subinventories.
To
Enter an ending subinventory to restrict the report to a range of subinventories.
Source Type for Column One
Enter a transaction source type. The report enumerates transaction quantities or value associated with this transaction source type. Source types not selected for a specific column are aggregated as Other in the report. If your selection option is Balance, the report considers all source types.
Source Type for Column Two
Enter a transaction source type. The report enumerates transaction quantities or value associated with this transaction source type. If your selection option is Balance, the report considers all source types.
Source Type for Column Three
Enter a transaction source type. The report enumerates transaction quantities or value associated with this transaction source type. If your selection option is Balance, the report considers all source types.
Source Type for Column Four
Enter a transaction source type. The report enumerates transaction quantities or value associated with this transaction source type. If your selection option is Balance, the report considers all source types.
See Also
Submitting a Request
