Transaction Historical Summary(Quantity,Value,Balance)

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.

Quantity: Report past on-hand quantities and transaction sources that produced the quantities.
Value: Report past inventory value.
Balance: Report past inventory balances.

Quantity

Value

Balance(=Value + Quantity)

Value = Quantity * Cost

ps:A query to get item cost

select segment1 item,
cst_cost_api.get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) cost
from mtl_system_items_b
WHERE inventory_item_id = &item_id;