Two calculations are required for a single condition type

[Former Member]

Hello Experts,

I have a requirement to calculate the VAT conditon type in a pricing procedure...like in one case ( If TAX Indicator set to "0,1,2" at sales order header level) tax should be calculate on PR00 & 3 other condition types....in second case ( If TAX Indicator set to " 3 " at sales order header level) tax should be calculate on 3 other condition types except PR00. But make sure that TAX Indicator "3" always set by user manually during the creation of sales order.

Another hurdle is if user set the indicator as 3 manually during the creation of Sales order then price will not be redetermine automatically, So I need this to be happend automatically.

Let me know how should I proceed further to fix the requirement.

Appriciate quick response.

Regards,

Chandu

[Former Member]

Set up your pricing as follows:

10 PR00

20 Z001

30 Z002

40 Z004

100 Subtotal #1 = Sum of 10 through 40

110 ZSUB = Discount condition with condition record for 100% for Tax indicator = '3' (otherwise 0)

200 Tax base = 100 through 110

[Former Member]

Hi Joshua,

First of all thanks for the response.

I want to have more clarification on provided information.. like step number 110 & 200. It seems system will consider both calculations if tax indicator set as 3, becoz as per your information there is no logic has been given to exclude the 100 step if tax indicator is 3.

Let me know if I am wrong and give me information in detail.

I need help to redetermine the pricing after changing the field value as 3 manually.

Regards,

Sudhir T

[Former Member]

Hi Sudir,

Somehow my edit did not get saved:

This is suppoed to read

Set up your pricing as follows:

10 PR00

20 Z001

30 Z002

40 Z003

100 Subtotal #1 = Sum of 10 through 40

110 ZSUB = Discount condition with condition record for 100% for Tax indicator = '3' (otherwise 0) with base = line 10 (PR00)

200 Tax base = 100 through 110

In other words:

For tax indicators = 0,1 or 2

Tax base (Line 200) = PR00 + Z001 + Z002 + Z003

For tax indcator = 3

Tax base = PR00 + Z001 + Z002 + Z003 - (100% x PR00) = Z001 + Z002 + Z003

Yiou will probably aneed to put some code in one of the sales order user exits to trigger repiricing if you change this manually.