VAT amount is adding with my mrp (maximum retail price) . It should not added with MRP. How to solve this prob

[former_member1136049]

Dear Experts ,

Here I am facing one problem with pricing and billing .

I am using Vat condition as ZVAT  and  VAT amount is adding with my mrp (maximum retail price) . It should not added with MRP. 

I have made condition type as  ZVAT and using mark down pricing . I am deriving price from MRP . For example

Sales order price MRP is 700 and I am using Vat as 4.7 in mark down calculation and vat is coming as 33.32 Rs.  But I am facing problem in billing

documents.Please find the below billing documents.In the Billing document, customer debit is showing as 700

plus vat amount. It should not be added vat In the MRP price,  because I am using as markdown. Customer debit should come 700 and export sales

credit  should come as 700 .Here VAT amount is adding with MRP and customer debit is showing as 733.32 . How to solve this . I have attached all the

screen shots.Can any one help me this scenario.I have attached pricing , sales order and billing documnets

Regards/Lijo

[former_member216765 · Accepted solution]

Hi

As per your screenshots the MRP= 700 and Tax over MRP= 33.32 (4.7%). the total payble by the customer is MRP+TAX.

Now, I wish to know if the MRP 700 includes the TAX 33.32? if it does then your MRP should be 666.68. Please clearify.

Also share the screen shot of Conditions values determined in the billing document.

[former_member1136049 · Accepted solution]

Hi Amit ,

Please find the details.

My MRP (Maximum retail Price ) is 700 , which inclusive of tax.
That means, I am collecting from the customer 700 rs including my tax. My
selling price (MRP) is 700 rs which include 33.32 of Tax. That means accounting
values should come. Customer debited to 700 and sales credited to 666.68+
tax (33.32) = 700 .My accounting shows, Customer debited to 733.33 and sales
credited to 700 + 33.32(Tax) , which is wrong . My total values should not
exceed more than 700. How can get the accounting as Customer debit 7000 and
sales credit 666.68 and vat payable credit figure 33.32.Could please
help on this.

Thanks and Regards in advance

Lijo

[former_member216765 · Accepted solution]

Hi lijo

Check your condition ZVAT in V/06 and maintain X in the Plus/Minus field and test your scenario and share your results here.

[former_member1136049 · Accepted solution]

Dear Amit ,

Thanks for the mail . As per your previous mail . I have assigned 666.68 as the MRp and remain 33. 32 as the tax component . Now Customer debit is arriving at 700 and sales credit is 666.68 and tax is 33.32 . This looks fine for me .. Thanks for your reply

[rahul_vishwakarma2]

Hi Friend,

   I am not sure if this will work or not , but once you can try this and confirm. Try Backward Calculation.

Backward Calculation Formula :

Basic rupess is 100 & tax is 12.5% = then total value is 112.50 rights

so now for backward calc on Total value is 112.50/1.125=100 rs basic

i.e 12.5/100=0.125+1 so its 1.125

Hope this will help you.

Regards,

Kundan

[former_member1136049]

Hi

We are using mark down(backward for this scenario) . MRP is 700 . Invlusive of tax we are calculating .

Rgds/lijo

[Former Member]

Hi,

In your pricing condition record how you are maitaining record in VK11 for condition type ZMRP.

You can maintain the ZMRP value as 668 & then use Rounding rule while calculating ZVAT based on ZMRP value for 4.76%.

This may help you.

[former_member1136049]

Thanks for the reply. Please find the details.

My MRP (Maximum retail Price ) is 700 , which inclusive of tax.
That means, I am collecting from the customer 700 rs including my tax. My
selling price (MRP) is 700 rs which include 33.32 of Tax. That means accounting
values should come. Customer debited to 700 and sales credited to 666.68+ tax
(33.32) = 700 .My accounting shows, Customer debited to 733.33 and sales
credited to 700 + 33.32(Tax) , which is wrong . My total values should not exceed
more than 700. How can get the accounting as Customer debit 7000 and sales
credit 666.68 and vat payable credit figure 33.32.Could please help on this.

Thanks and Regards in advance

Lijo

[ajitsingh6]

Hi Lijo,

You must have heard about Reverse Pricing in SAP which is best suited in your scenario.

Please go through following link,

http://scn.sap.com/thread/1300891

Regards,

Ajit Singh

[rahul_vishwakarma2]

Hi Friend,

    As per my understanding, you should have to check the Account Key for the condition type which is assigned in the Pricing Procedure V/08 Transaction Code.

  Also check the Accounting assignment in VKOA Transaction code. Over here you should have to assigned different G/L with New Account Key which is assigned to VAT Condition.

Hope this will help you .

Regards,

Kundan

[krishna_k19]

Hi,

   Please check the Accounting key which you used for MRP and VAT

Thanks & Regards,

Krishna