How to create Inventory Stock Valuation Report
Summary:
I was created Inventory Stock Valuation Report but the qty not same with INV_MATERIAL_TXNS
Content (please ensure you mask any confidential information):
i use PRIMARY_QUANTITY on INV_MATERIAL_TXNS table but it Diffrence with quantity on cst_costed_attr_onhand_v, could you help me to describe about the difference about that, or is there any sugestion about new query on my Inventory Stock Valuation Report
Code Snippet (add any code snippets that support your topic, if applicable):
select item_number, item_desc,
category_code, uom_code, uom_name,
sum(total_quantity) total_quantity,
unit_cost,
0