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):
Tagged:
0