You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!