cancel
Showing results for 
Search instead for 
Did you mean: 

Tax amount problem

Former Member
0 Kudos

Hi Experts,

I have a requirement like this. We have created 3 tax codes

I0---- Zero tax

V1---- Vendor charges the tax 10%

U1----Vendor not charges the tax but company pays 10% to Govt.

For U1 tax code ---For PO of 100 USD for a material with 1 Qty means 10% tax on 100

In GR System should update

Inventory Stock A/c---110 USD Dr

GR/IR Account -


110 USD Cr

In MIRO

Vendor account -


100USD Cr

GR/IR clearing -


110 USD Dr

Used tax a/c----


10 USD Cr

For V1 Tax code-- For PO of 100 USD for a material with 1 Qty means 10% tax on 100

In GR the system updates

Inventory stock account---- 100 USD Dr

GR/IR Clearing account --- 100 USD Cr

In MIRO

Vendor account -


110 USD Cr

GR/IR Clearing a/c ---100 USD Dr

Expense/material a/c- 10 USD Dr

I am facing the problem here the system i checked in all ways here that system is not crediting the expense/material a/c if we select the used tax .

I checked in OBCN all the matching but not find the solution

Please check at your end how to achieve this.

Rgds

Swamy

Edited by: Swamy G S on Apr 16, 2008 10:02 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Experts,

Please any input on this, Its very urgent.

Please any information on this

former_member13777
Active Contributor
0 Kudos

Hi,

Post in MM module forum. Basically you are looking for inclusive tax and exclusive tax.

It is possible

but in one PO it may not be possible to use both

When you define tax code check the deductible and non deductible 'check box'

try

Former Member
0 Kudos

Hi,

Thanks for the reply,

We will putting the tax code in the different line item or will create a New PO for different tax codes.

I checked the deductable & non deductable checkbox in OBCN,

I am getting the result as per my calcuation but the client wants for Tax code V1 the tax amount should goto expense account but right now it is going to Used tax, If i try to change the settings then the amount will goes to expense account but Used tax account will not be updated. I am not able to finding out this.

rgds

Swamy

Former Member
0 Kudos

hi dear,

what I understand is u want 2 tax codes one where u can take the credit & other which is to be expensed out.

for deductible u have to select JP5 in OBCN & for non ded JP6.

futher execute sm30 & enter the following view

J_1IT030K_V. enter the company code & transaction ie Jp5 or jp6.here maintain ur tax code V0 or V1 as the case may be along with business palce & GL account.

hope this solves ur problem.

Regards,

Saurabh

Former Member
0 Kudos

Hi,

Thanks,

But the problem is amount is not distributing properly in Tax code.

How to maintain the percentage in tax code--FTXP

what percentage i need to put in FTXP which i am finding problem.

rgds

Swamy

Former Member
0 Kudos

Hii Swamy u r facing a basic problem in tax configuration...

I will tell u the sequence to configure the tax procedure..

1. T.code - OBYZ Create condition types - with Access sequence - MWST

2. Creat account keys T.code - OBCN , which u want to distribute the tax amount to a seperate account or distribute to exp/revenue account i.e

Posting ind. - 2 ( Seperate line item -- seperate account posting )

Posting ind - 3 ( Distribute to relevant exp / revenue account -- means there is no need for account determination )

If u want to select th check box Non - Deductable u can ..but i think it wont work any where..

3.After this using the above the combination i.e condition types and accout keys u have to create tax codes in T.code - FTXP

Ex: Condition type for VAT is J001 (Ex: Input tax condition )

Account key for VAT is 001

New Tax code is V1 ( INPUT tax code ) - in this tax code u have to give tax percentage for the condition type J001 with combination of account key.. here u can create no.of tax codes based on VAT percentages like V1 - VAT-4%

V2 - VAT - 12%

For V2 also u have to give percentage 12% for the above condition type and same procedure as V1

4. T.code - OB40 - Account determination for account keys which u have selected Posting ind. -2 (seperate line item)

No account determination required for - 3 type

For 3 type the tax amount will added to the relevant account whether it is exp / revenue account.

Plsss try the above and if any queries revert to me..

Assign points if it is useful for u..

Regards

Ramki

Former Member
0 Kudos

Hi,

Thanks the problem is solved,

I configured same as your explantion, but I made a mistake that in FTXP the percentage of tax for V1 tax code i put at 1st line instead of 2nd line, which is not calculating properly in MIRO.

I corrected the tax percentage. Its working fine.

rgds

Swamy