splitting values into 60% and 40% in pricing condition in a sales order

[Former Member]

we want to be able to split values into 60% and 40% in the pricing condition when creating a sales order and each split would have its own VAT

[moazzam_ali]

Hi

If you want your query to be answered properly and with complete solution then you need to ask question with complete details. In your three posts I am unable to understand what exactly you want. Could you please share your requirement with some example and if you want to post this split in FI then with accounting entry. Don't use one line text to explain but use some example or scenario to explain the requirement.

Thank$

[siva_vasireddy2]

Hi,

your Requirement has two Points

1.Splitting the condition types(which Condition type is it Base Price?)

2.Calculation of VATs based on these Splitting

Plz correct me if iam worng

[Former Member]

yes splitting the base price and vat will also be added to each split

[siva_vasireddy2]

Hi,

you can either use routine or use two Different discount condition types to get the value

the discount condition types can be maintained with records as 60% and 40%

After the discounts you get the amount on this amount the two VAT conditions will be calculated.

price	100
p60%	60
p40%	40
Vat1	7.2
vat2	4.8

[Former Member]

Hi,

You can create two VAT condition types say VAT1 & VAT2

VAT1 = 0.6 (60%) x VAT rate (say 4%) = 2.4% on PR00

VAT2 = 0.4 (40%) x VAT rate (say 4%) = 1.6 % on PR00

Create condition records for material for VAT1 as 2.4% & VAT2 as 1.6%. If you are using tax codes, then assign same tax code which is used for regular rate (here 4% as shown above).

[Lakshmipathi]

we want to be able to split values into 60% and 40% in the pricing condition when creating a sales order

What is the logic for this ?  This will help to understand and give a better suggestion.

G. Lakshmipathi

[amit_tunara]

Hi,

You need to create two condition types which will of type % and in pricing procedure it will take your main price as the calculation basis. For example, the PR00 condition is having your price. You create two condition ZC1 and ZC2. These two condition types will be of % type and using appropriate access sequence maintain 40% and 60% as a value for these conditions.

Similarly, two create two condition types for VAT. ZVT1 and ZVT2 condition types will be of percentage type and the reference will be from ZC1 and ZC2 respectively. In pricing procedure assign VAT related accounting key to ZVT1 and ZVT2. Your pricing procedure will look like this.

Step	Ctype	Desc	From	To
10	PR00	Price
20	ZC1	40% Share	10
30	ZC2	60% Share	10
70	ZVT1	VAT 1	20
80	ZVT2	VAT 2	30

I hope this will help you.

Regards,

Amit

[siva_vasireddy2]

Hi,

Plz confirm which pricing condition you want to split plz expalin the scenario.

In the pricing procedure for the particular condition type you can use Alt.calc type as 7 percentage Variant and build your own Logic.

[Former Member]

Wants to split the total value into 60% and 40% in the sales order