Pricing procedure inclusive tax

[Former Member]

Hi

We have a scenario for one of our company code, the client will enter total price which has to be sent as invoice to the customer , business tax is 5.5% of the total price. For eg if the total invoice amount is 10000 which will be entered by the customer the calculation of tax will be on 10000 which is 550 the sales price will become 9450.

Accounting entry should be customer Dr 10000,Credit sales G/L account 9450 and tax account 550.

Net value in sales document should be 10000, tax 550 and sales price 9450.

How can i achieve such a scenario in SAP, i have tried using RVAB01 PP but in vain.

I have tried a PP as explained below

10 PR0 Manual Required Statistical

20 Business tax From 10 EVT key

Is there anyway i can tell subtotal is 10 - 20 key as ERL.

If i do as explained above will the total price entered will hit customer account?

Please advice.

Thanks,

Vaishnavi

[Former Member]

Try the Pricing procedure like this

10 PR00 - statistical - sub total for example D = 10000

20 MWST - From Cond record say 5 %- sub total for example E - act key what ever needed = 500

30 Applicable price condition type say ZPRO - . Alt calc type KWERT = D-E. - accnt key. Make sure ZPRO is not setup as Price condition type, else MWST will be excluded. = (10000 - 500 ) 9500

Total Price will be 10000, tax amount 500 will post to accounting & also the 9500 will post to accounting. Fine tune the PP based on your testing and requirement.

Regards

Sai

[Former Member]

Hi Sai

I have done in the same way as you have mentioned, the issue iam facing when iam posting invoice to accounting iam getting an error on MWS or tax condition type should only be calculated against the price which has ERL as account key which is ZPRO.

The tax line is not getting posted to accounting if its calculated on the base price inclusive of tax as no account key is against it.

10 0 ZPR0 Sales Price X 2

11 0 ZK04 Discount 11

12 0 SUB TOTAL 10 11

20 0 ZDPR Discounted Price 12 ERL

30 0 ZBT Business tax 12 MWS

This is my PP, ZPRO 10000, if there is discount ZK04 will be excecuted

else subtotal = 10000, ZDPR iam maintaining condition record 94.5 % which will come to 9450, business tax 5.5 % on 1000 which is 550.

The accounting entries will be correct, but accounting entry will not have tax code since MWS is on line 12 which doesn't have acckey ERL.

Can you please help how to resolve this?

Thanks,

Vaishnavi

[prasanna_kumar4]

Hi,

1. can you please tell me in your case VAT is Fixed ?

2. If VAT changes that is the case how many times you can maintain the condition record and how system will retrieve the condition record based on the VAT

i think you better to go for Routine take the help of ABAPer ask him to right routine and also kindly check the following link you will get the idea

Regards,

Prasanna

[Former Member]

pls assign calctype 2 to line 12. Also I see that you are using a custom tax condition type. Please check the configuration of this condition type to match with MWST. Category should be D and Group condition shoudl be checked.

Regards

Sai

[Lakshmipathi]

Check this thread

[Re: Tax inclusive in base price|;

thanks

G. Lakshmipathi

[od_manikandan]

Hai Vaishnavi

10 ZPRO Manual entry (total price) user enter 10000

20 Proo Basic price 10 10 (condition record maintained as 94.5%) so value will come as - 9450 ERL (Acct key)

30 ZTAX Business Tax 10 10 (cond. record 5.5% if it is fixed) value will as 550 VAT (Acct key)

40 Total ________________10000

Regards,

Mani

[Former Member]

Hi Manikandan

Thanks for your reply, i have implemented the logic, it works fine. But the problem is i cannot post it to accounting since the ZTAX condition type we are maintaining @ ZPR0, Tax condition should only maintained on line items which has ERL i.e on discounted price as the account key as understood from the error below, then tax will be calculated as 95.5%.

I have tried in the reverse way for calculating composite tax and maintained condition record as 5.82% and adivced the customers to mention the sales price with out tax, there is an issue with decimal places in later case.

Any idea how to resolve the error of maintaining tax code in ZPRO instead of PROO discounted price.

Tax code B1 does not appear in any G/L account item

Message no. FF753

Diagnosis

The document entered contains a customer or vendor item with tax code B1. This does not occur in any of the G/L account or asset items.

Consequences:

If you have not entered the cash discount base manually, the system will set it to zero in this item.

If this item was paid with cash discount deduction and the cash discount amount contains a tax portion, the tax code entered is used for the backdated tax calculation. An automatic breakdown does not take place on the basis of the offsetting items.

Procedure

Check whether the tax code was set correctly. If necessary, correct it or enter "**".

There are, however, also situations in which it makes sense to enter a tax code manually which differs from the offsetting items, for example, during data acquisition.

Regards,

Vaishnavi

[Former Member]

Hi Vaishnavi, please use Tax CType MWSV and try..

Regards,

Raghu.