Transaction Historical Summary(Quantity,Value,Balance)
来源:互联网 发布:windows性能计数器缓存 编辑:程序博客网 时间:2024/06/06 17:32
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) costfrom mtl_system_items_bWHERE inventory_item_id = &item_id;
- Transaction Historical Summary(Quantity,Value,Balance)
- Transaction Quantity to Primary Quantity
- Query to check quantity on historical date
- magasin abercrombie france Historical research on what kind of value
- Summary on 20080626: some difference between JDBC transaction and JTA
- Serial number is not available when doing any inventory transaction but shows in on hand quantity in
- Balance
- balance
- Balance
- Summary on 20080701: insert value for identity column in sql
- Summary
- summary
- summary
- Summary
- Summary
- summary
- Summary
- summary
- js禁止输入非数字
- iOS ARC
- linux 查找命令(find which whereis grep locate type)
- 开启所有activex等Internet选项的批处理bat
- 牵手ARM,AMD唱响未来“芯”篇章
- Transaction Historical Summary(Quantity,Value,Balance)
- Makefile 中四种变量赋值方式的区别
- 随滚度条移动的浮动层(类似京东,淘宝商品介绍栏)
- android Service和IntentService
- JDom如何嵌入第三方接口传入的XML数据
- aes 使用
- 动态创建级联菜单
- 大整数相乘(未突破计算机位数限制)的int版本
- C#判断字符是字母、数字、标点。。。。。