Mass change of price in sales order of different customers having different material / products

[former_member1298534]

Hi all,

I tried searching out for my query in the community but could not find an exact solution to it. Hope somebody could help me out or direct me to a discussion over the topic held earlier.

Query:

How to change the price of all products/material of different customer at one go.

Background:

There are many sales orders open in the system which are created for a different customer for different products/material. Now recently there is price revision & it is required to update the price of all products/material for all customers in each sales order.

My query is: Is there any way to update prices of all customer, all products at one go in OPEN sales orders instead of manually updating prices through VA02>pricing condition> carry out new pricing in each sales order OR using VA05 in which, no doubt we can update prices in mass, but it can only update for single product and single customer.

Is there any other way?

[VeselinaPeykova]

For open sales orders - one option is to use VA05 and from the list Edit->Mass Change-> New Pricing. This is useful if you do not have a huge list of documents.

If I need to reprice lots of open orders, I would prefer to use LSMW with BAPI_SALESORDER_CHANGE and set LOGIC_SWITCH-PRICING to 'B'. It is not immediately obvious that you can use BAPI_SALESORDER_CHANGE in LSMW, but it is very easy to do so, just use the concept from this blog: Mass Creation of Customer Hierarchy

Please, have in mind that as a result of repricing some orders may be blocked for credit reasons or if you have some workflow based on order value that this can trigger new approval. VA05 repricing is viable if you have relatively small number of documents, for other cases I would use LSMW.

For orders which were already processed you cannot perform repricing but in SAP we have retroactive billing, as a result of which you can issue automatically credit/debit memos for price changes. You will have to check with Sales and Finance if you need to do this as well and whether retroactive changes are even allowed.per company policy and local legislation.

[Amiran]

Hello,

Pricing date change in sales order lead new price calculation. So, you can change pricing date for multiple sales orders at once in transaction MASS.

Regards