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 can we compare the prices of the sales order and price list

Summary:


Content (required):

Hello Experts,

One of our customer demands a BI report to see the items' price in the price list and in sales order. We use a price list to value the item but sometimes users change the unit price in sales order. We need to create a sql query to see. But in DOO_HEADERS_ALL table, we just can see 'pricing strategy id'. I can not see the segment lists under the pricing strategy. How can I see the used price list name and charges of the items by sql?

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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