SAP Business 1 query with link to pricelist hirtory tables
Budget: $30 – $250 USD
We need a report which will indicate differences between the selling prices of products on sales orders at the time sales orders have been added to SAP (therefore approved and added by the creator of the sales orders) vs the selling prices of those products at that point in time on the price lists related to the customer being sold to.
This will therefore require referencing the history tables of the pricelists and comparing to the price list and prices related to the customer at the point in time of adding the sales orders.
The query should therefore compare the final selling prices of the products on the sales orders (closed sales orders) and compare it to the selling prices of those products which was applicable at the point in time the sales order was originally added to SAP.
This will therefore require referencing the history tables of the pricelists and comparing to the price list and prices related to the customer at the point in time of adding the sales orders.
The query should therefore compare the final selling prices of the products on the sales orders (closed sales orders) and compare it to the selling prices of those products which was applicable at the point in time the sales order was originally added to SAP.