cancel
Showing results for 
Search instead for 
Did you mean: 

VAT should be increased for percentage independently of price

former_member328731
Participant
0 Kudos

Dear colleagues,

I have requirement regarding pricing. We have price, and VAT. However, in special case VAT needs to be increased for Duty fee. Only VAT and not price. Requirement is that VAT must be automatically determinate, should not be changed manually.

For example PR00 is 100,00 USD, and  VAT rate is 10%. In special case Duty fee should be included. Duty fee will not be paid by customer, just VAT for Duty Fee.

For example

Price:

100 USD

100 USD

Duty:

10%

10 USD

VAT:

10%

11 USD

Customer:  Dr 111,00 USD

Revenue: Cr 100,00 USD

VAT: Cr 11,00 USD

Duty fee should not be posted, just used define proper VAT.

I added

PR00 100,00    100,00

Sub1 100,00

ZZDF 10%           10,00

MWST 10%         111,00

I did not put posting key on ZZDF, because I do not need to post it in G/L. and I get error in account determination. If I put statistical indicator system does not take ZZDF for VAT calculation.

Could you please help me how to get desired posting and to have proper pricing procedure.

Thank you,

Harry

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

Share the screen shot of your pricing procedure

G. Lakshmipathi

former_member328731
Participant
0 Kudos

Hi Lakshmipathi,

It is copy of standard procedure, just in line 912 ZZDF is added.

Price condition config is

Thank you,

Harry

Lakshmipathi
Active Contributor
0 Kudos

The step number in pricing procedure is a continuous one instead of minimum intervals of 5 to 10.  Though, you can insert one step after 911 with Counter 1, to test whether the scenario can be met with standard, unfortunately, it is not possible to define the pricing procedure to calculate values in between 911 and 912.  Hence, you need to add this logic in your existing routine assigned to your tax condition type

G. Lakshmipathi

jobis
Contributor
0 Kudos

Hi Harry,

Do you want the value of condition ZZDF to be added to the net value, or you want that value just for the calculation of the Tax?

If yes,  then I think you can achieve it by modifying  your pricing procedure in std way.

Step  cond type          from  to     Statistical

10       PR00

20       ZZDF                                 yes (tick)

30      Taxable price     10   29

40      MWST               30

Make modifications in your Pricing procedure to include the logic as above.

Do test, It should work for you

Jobi

former_member328731
Participant
0 Kudos

Hi Jobi,

I want ZZDF value just for the calculation of tax.

If I tick Statistical procedure will not use ZZDF for tax calculation, and I need it. If I uptick statistical it will ask for account on which needs to be posted (which I do not need, because ZZDF is used just for VAT calculation).

Any other suggestion?

Regards,

Harry

former_member328731
Participant
0 Kudos

Hi G. Lakshmipathi,

I did not understand your comment. In case that my VAT is on 913 and ZZDF on 912 what my possibilities are. What I should do to get desired effect?

Regards,

Harry

jobis
Contributor
0 Kudos

Dear Harry,

Did you try the procedure steps I have put in my last post.?

Even though the ZZDF is statistical, you can use it for calculation, it will work. Only think is it will not be added in to the Net value.

You test this in an IDES and see how it works.

Update your feedback

Thanks

Jobi

Shiva_Ram
Active Contributor
0 Kudos

Can you try the following?

1) Set ZZDF as statistical condition type and add a value in the sub-total field against the condition type

2) In the step MWST - Add a calculation type routine, to add value ZZDF value from the sub-total field with VAT value, which is determined from MWST condition type.

Discuss an ABAPer, who can help with writing the calculation routine in transaction code VOFM.

Regards,

former_member328731
Participant
0 Kudos

Hi Jobi,

I tried

I created subtotal w/o any requirement of condition formula.  I added it after ZZDF. ZZDF is statistical. MWST is calculated only on Net Value. MWST have calculation formula for Basis type 16.

Kind regards,

Harry

former_member328731
Participant
0 Kudos

Hi Shiva,

So I need calculation formula anyway? I can not use standard one 16?

Can it be handeled somehow without new calculation formula or ABAP help?

Kind regards,

Harry

jobis
Contributor
0 Kudos

Hi Harry,

If you are using Alt Cond Base value 16 for mwst, then my suggestion will not work. But, is it mandatory to use this routine?

I think, if you know, the values to be considered for tax, and keeping your conditions in a logical sequence, in the pricing procedure, you may be able to have  MWST without the  std routine 16.

This is my Opinion.

Else you will have to go for new custom routines as suggested above.

Thanks

Jobi

Answers (0)