Former Member

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

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

10|10000 characters needed characters exceeded

• Oct 25, 2013 at 04:56 AM

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.

10|10000 characters needed characters exceeded
• Former Member

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

• Oct 25, 2013 at 05:06 AM

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.

StepCtypeDescFromTo10PR00Price20ZC140% Share1030ZC260% Share1070ZVT1VAT 12080ZVT2VAT 2

30

Regards,

Amit

10|10000 characters needed characters exceeded
• Oct 25, 2013 at 06:50 AM

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

10|10000 characters needed characters exceeded
• Former Member
Oct 25, 2013 at 07:58 AM

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).

10|10000 characters needed characters exceeded
• Oct 25, 2013 at 10:02 AM

Hi,

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

10|10000 characters needed characters exceeded
• Siva Prasad Vasireddy Former Member

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.

price100 p60%60 p40%40 Vat17.2 vat24.8
• Oct 28, 2013 at 07:23 AM

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\$