Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

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

    Add comment
    10|10000 characters needed characters exceeded

  • 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

    I hope this will help you.


    Regards,

    Amit

    Add comment
    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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).

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2013 at 10:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    Add comment
    10|10000 characters needed characters exceeded