Pricing update in open sales order

[shashanko_aditya]

Hi Experts,

I am looking for possible explanation of the below scenario. Dates given below are imaginary. System - S4/HANA 1909 (IS-A- VMS)

Sales order created & item added on, say (26th Jan 2020)

All pricing conditions updated correcting which were valid on 26th Jan 2020.

Billing is done on 2nd of Feb 2020.

Just before billing, we have a custom logic (as a separate batch program) to update pricing date in sales order at header and item level and as such automatic pricing update happens after pricing date update.

Now, the problem

On 26th Jan 2020, one condition (freight recovery) was set at 180 $.

However, freight recovery condition was updated to 190 $ on 1st of Feb 2020. The validity dates are correctly set. the valid from date for the latest condition record is 1st Feb 2020.

So now on 2nd of Feb, when sales order was invoiced, the pricing date was updated to 2nd Feb, 2020 but the condition value of freight recovery is still 180 $ and not 190 $. Even the manual price update (with pricing update type B & C) does not update the condition value to 190 $.

Any reason, why the update isn't working?

[jagansapsd]

Mr. Aditya pls check pricing type in copy control.In the copy control 'PRICING TYPE SHOULD BE SET as H " . It means copy pricing elements and redermines frieght.

[former_member661744]

Hi Shashanko,

Just to update you system will not make any changes to the price when you are creating the sales order and updating it will not work,So you will have to save then sales order and then goto change mode-->sales order-->item conditions-->Click Update,

Can you please try again

Regards,

Anese khan

[Lakshmipathi]

I presume, you were trying for a line item in open sale orders where some partial delivery has happened already in which case, system will not update for such of those line items.

[shashanko_aditya]

There is only one item in the order. The delivery is already created for it.

we have instances in the past when we were successfully able to update pricing before billing and post delivery.

Thanks

Shashanko

[shashanko_aditya]

Hi Sir,

can you suggest me any alternative way to analyse the issue?

Thanks
Shashanko

[Lakshmipathi]

only issue is update fails in existing orders.

Did you try "Edit > Mass Change > New Pricing" from VA05?

[shashanko_aditya]

Yes, I already did try that. In fact I have searched for similar issues on SCN and tried almost everything but nothing seems to have worked.

Thanks

Shashanko

[former_member661744]

Hi Shashanko,

As per my understanding the prices at the sales order are determined based on the Pricing date/Services rendered date and In your case it is not changed at the sales order,

You are only updating the prices using a batch program the system checks the prices based on the pricing date and its populating the values and it is the system behavior,

So try to play with the pricing date to get the expected result i.e.,

Ex : Create Condition record as of 06/04-100$

Create sales order with pricing date as 06/04 and create an invoice on 06/04 and do not save it

Change the validity period from 08/04 to 31/12/9999 and change the pricing date in the sales order to 09/04 and update pricing .Expectation the Prices will change and once changed it will also flow into the billing document

Regards,

Anese Khan

[shashanko_aditya]

Hi Anese,

I have tried all permutations and combination of manipulating the price date and service rendered date. however, business expectation of an automatic price update of a condition type upon updating the pricing date via a batch program is not achieved.

I have also tried deleting and re-creating the condition records with different date. still no expected result achieved.

Also to add to it, a coupe of days before a similar issue was faced when a new variant condition was introduced after the sales order was created and the pricing update refused to automatically update the sale order with a new entry in the pricing. I had to manually key in the data in PRCD_ELEMENTS as a workaround.

Just wondering, why the pricing update is not working.

If I create a new sales order, the new condition records are available, only issue is update fails in existing orders.

Thanks

Shashanko

[Lakshmipathi]

What the Analysis tab says?

[shashanko_aditya]

Thanks for your response.

The analysis tab still shows the condition value of the older date and not the new condition record value.

As communicated earlier, the price date is updated at both header & item level to 2nd May 2020.

Thanks again

Shashanko