Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need organization inventory data unit cost wise — Cloud Customer Connect
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

Need organization inventory data unit cost wise

Received Response
edited May 5, 2021 7:49AM in Reporting and Analytics for SCM 1 comment


Dear ,

We have 11 Inventory Organization in which we want inventory unit cost as per org id. 
so we created customized query 
join cst_transactions ct into inv_material_txns imt through ct.INVENTORY_ORG_ID = imt.ORGANIZATION_ID
and select 1 inventory organization but still its shows all organization data.


Howdy, Stranger!

Log In

To view full details, sign in.


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