cancel
Showing results for 
Search instead for 
Did you mean: 

New Tax rate

Former Member
0 Kudos

Dear Gurus,

My client requiring a diff flow of tax code.can anyone provide that??

Basic rate:10 qty rate:150 = 1500

discount - 10% = 150=1350(reduced from basic rate)

sales tax 5%=67.5=1417.50(added from discount)

octrai 5.5%=77.9625=1495.46(added from sales tax).

can anyone provide soln for this???

thx in advance..............

Accepted Solutions (1)

Accepted Solutions (1)

ashish_andani
Contributor
0 Kudos

My client requiring a diff flow of tax code.can anyone provide that??

Basic rate:10 qty rate:150 = 1500

discount - 10% = 150=1350(reduced from basic rate)

sales tax 5%=67.5=1417.50(added from discount)

octrai 5.5%=77.9625=1495.46(added from sales tax).

can anyone provide soln for this???

hi..

in MM pricing procedure..

Base price..1500

discount...10% from step no of base cond type

net value : 1350 from step no of base cond type... to step no of discount..

now go to Tax procedure ...

spro...Financial Accounting (New)..Financial Accounting Global Settings (New),,,Tax on Sales/Purchases..Basic setting..Check Calculation Procedure

there choose the BASB cond type..here routine 362 use..it will fetch net value from the mm pricing procudre..

add Cond type for sales tax...

then use tax for octrai and in from field write the step of BASB...

try this out..

Thanks

Edited by: ashish2210 on Aug 29, 2011 12:43 PM

Former Member
0 Kudos

Hi Ashish,

I created a new schema.

i included Pb00 and Pbxx in tat. Next to that it shows net amount.

can u tel me wher to include that 362 reqt??

i created a cndtyp for octroi.shal i include in that line??

tel me how to maintain 5.5,10 % in condition types.

plz reply..........

thx in advance..............

Former Member
0 Kudos

hi Gurus,

can anyone tel me how 2 add % in condition type in purchasing.?i want 2 add 10% on discount,5% on sales tax and 5.5 % on octroi??

where to maintain this numbers??

Plz reply..............

thx in advance...............

ashish_andani
Contributor
0 Kudos

hi..

though u have created the MM pricing procedure...

in that include only two condition type..

i.e.

PB00/PBxx

and discount..

The discount is manual or fixed...if it is fixed then maintain the condition record for discount cond type in MEK1..

now save the pricing procedure...

now create the Tax pricing procedure..

at..SPRO...Financial Accounting (New)..Financial Accounting Global Settings (New),,,Tax on Sales/Purchases..Basic setting..Check Calculation Procedure

then..define procudre.

indclude cond..

BASB int hat add routine 362 in Base type column..

add sales tax cond type JIPS/JIPC(std cond type)..

then add the cond type for octrai..

sales tax is 5% and octrai is 5.5%....if u want to enter them manually then let it be..otherwise if they are fixed then u have to maintian the condition record for these tax cond type..in FV11..against tax code and country..

save it..

Try this out..

Former Member
0 Kudos

hi ashish........

where to give the 362?In BASB procedure or TAXINN procedure? if we give in TAXINN procedure,how it will reduce the base amount??

Plz clarify my doubts............

thx in advance...........

Former Member
0 Kudos

Hi,

You have to give 362 in the Base type field against the BASB condition in your TAXINN procedure. Based on this your new base after discount will flow to the tax procedure.

Thanks & Regards,

Former Member
0 Kudos

Hi,

Just one more clarification.

BASB is not a procedure, its a condition type which you can find in your TAXINN procedure which you can access through the t.code - OBQ3.

Already all the required information has been provided by the fellow SAP experts above.

Please proceed & let us know the results.

Thanks & Regards,

BijayBarik
Active Contributor
0 Kudos

Hi,

You need use tax code as your requirement in PO, where your tax code will link pricing procedure with tax procedure. Basic rate, discount and octrai will flow from pricing procedure and sales tax will be in tax procedure.

For more check wiki links:

http://wiki.sdn.sap.com/wiki/display/ERPLO/16FieldsinPricingProcedureandTheir+Description

http://wiki.sdn.sap.com/wiki/display/ERPLO/DifferencebetweenTAXINJandTAXINN

Regards,

Biju K

Former Member
0 Kudos

Dear Biju,

thanks for replying.

Do i need to maintain MEK1??Is that necessary??

plz explain..............

thx in advance...........

BijayBarik
Active Contributor
0 Kudos

Hi,

Do i need to maintain MEK1??Is that necessary??

It is necessary or not, that you need to answer as you understand client business process and its completely depend on how business handled.

Maintaining condition MEK1 or not, this also you need to answer. Do you know OCTROI amount before creation of PO.

1st you need to understand how & when OCTROI coming into picture in purchasing for specific material. OCTROI is very much active in some state and some other state it have been completely suppressed. In some cases It can be paid as advance and later can be taken to expanse account during final settlement with vendor/vendors. In other cases, it can be appeared in PO ( logically design pricing procedure and tax procedure and OCTROI amount is perfectly calculated in MM schema and may be this condition type assigned to OCTROI vendor).

Regards,

Biju K

ashish_andani
Contributor
0 Kudos

hi...

If ur % amount is fixed u should maintain the condtion record in MEK1..

and if u are uncertain about the % then..u should not maintain the condition record..and prefer the manual condition type...

Hope it helps..

Thanks

Former Member
0 Kudos

Dear Guru,

Can anyone tel me , if i maintain condition record in MEK1 ,it ll applicable to every material??

plz explain........

thx in advance.............

ashish_andani
Contributor
0 Kudos

hi..

in MEK1..u define the condd record for cond type which is in MM purchasing procedure...

For Tax cond type's condition record..

go to FV11..and enter the TAX condtion type. for which u want to maintian the condtion record...

mainly it is the combination of country and tax code...which u will define in FTXP...

Try this out..

Thanks

Edited by: ashish2210 on Aug 30, 2011 6:58 AM

Former Member
0 Kudos

Dear Ashish,

thank u so much for answering.

Now our Client gave new specification.

they want to give 10% discount - manually

they want to have 5% sales by using - taxcode

they want to enter 5,5% octroi manually.

now i create a new a procedure.the discount is working fine.

how to do the sales tax automatically and octroi manually?

plz help.......................

thx in advance

ashish_andani
Contributor
0 Kudos

hi..for automatic fetching of sales tax maintain the cond record in FV11..5%

and for manually octrai..no need to maintain cond record...

u can give manually in Tax procedure...

Try this out.

Thanks

Former Member
0 Kudos

Dear Ashish,

In FV11,the combination Tax Code against Country not coming.How to create those combination?

this octroi cond type configure in MM or FI?If we configure in MM,how it will add the 5.5% amount with sales tax amount.

thank u so much for explaining..............

ashish_andani
Contributor
0 Kudos

hi..

for tax code...u have to go to FTXP..here u will maintain the tax code..

and then...this tax code u will use at invoice tab at purchase order item level..

Try this out..

Thanks

ashish_andani
Contributor
0 Kudos

hi..

.add this octrai in tax code..

it will be easy for u to calculate...from sales tax..

Thanks

Former Member
0 Kudos

Dear Ashish,

In FV11, i couldnt find the combination of tax code with country,Plz help me 2 sort this out.

thanks

Former Member
0 Kudos

Dear Ashish,

My FI team said its not possible to create octroi in tax code.My requirement is

base amt 1500

discount - 10%(entered manually)-1350

sales tax 5%-67.5+1350=1417.5.(sales tax 5% comes from tax code)

octroi 5.5%(entered manually)-77.96+1417.5=1495.46.

is it possible??

ashish_andani
Contributor
0 Kudos

This message was moderated.

Former Member
0 Kudos

This message was moderated.

ashish_andani
Contributor
0 Kudos

hi..

yes it is possible to use tax code..

understand this flow..

u define tax code in FTXP...this tax code contains the Tax pricing procedure...

Different tax codes contain different tax condition type active...

suppose in one purchase order u want sales tax to be active..and in one u want excise tax to be active...

so..both taxes will be in same tax procedure..and when u define tax codes u maintain the condtion record for particular tax cond type..

suppose..in tax code V1..u have activatted sales tax active..then in V2 u have activated excise active..

now while creating PO..u insert this tax codes in the invoice tab...and according to this tax codes the tax will be calculated...

hope u get it..

thanks

Former Member
0 Kudos

Dear Ashish,

is it possible to send screen shots??

sorry for asking u so much ....

thx..............

ashish_andani
Contributor
0 Kudos

hi..

http://i40.servimg.com/

for hosting the screenshots is blocked at my work. place...

so..i cant make it buddy...

Ask me i will help you at my best..

Thanks

Former Member
0 Kudos

is it possible to solve through tax procedure in FI.....

ashish_andani
Contributor
0 Kudos

hi..

Tax is calculated at the net value of the PO..when all the discounts,surcharges is finished...then on the net value of the purchase order the tax is calculated..

now in ur case..u want sales tax to be calculated first then Octrai..and octrai condtion type is in MM pricing proc..

so..it wont be possible to jump from MM pricing procedure to tax procedure in between of the MM pricing proced...

so...best it so create tax cond type in M/06 just same as in tax cond type OBYZ and maintain the account key and acrual key of sales tax G/L account...

try this out..

Thanks

BijayBarik
Active Contributor
0 Kudos

Hi,

Read all my above replies and do it once in the system ,just try and then you will get result.As I said and again I am repeating that Basic rate (Gross Price), Discount(Discount % on Gross ) and Octroi Charge will be in MM pricing procedure. As your case only VAT(sale tax ) will come from tax procedure.

Keep MM pricing procedure as below setting. Create PO where you have Gross Price, Discount which is a u201CNet Priceu201D which is a base value to calculate VAT and VAT will calculate with a tax code with VAT condition type with tax procedure. All VAT amount ( tax amount) will transfer to MM pricing procedure with condition type NAVS ( you can also customize your own condition type) and from then you add all amount (as required by you) and have your Octroi Charge on it with a condition type ZOCT and finally come to TOTAL price.

####Setting as for specific requirement

Steps-Couu2014Condition type--Cond Descri--- -


From -


TO

10----0


PB00
Gross Price
--


30----0


R000
Discount % on Gross

10
--


40----0


Subtotal
10

30
-

50----0---NAVS


Non-Deductible Tax--


60----0


Sub-Total
40

50
-

70----0


ZOCT
Octroi Charge(%)

60
--


80----0


TOTAL
60

70
--

Regards,

Biju K

Former Member
0 Kudos

Dear Biju and Ashish,

Thank u so much for ur help.Its working fine.But Navs and Zoct not hitting the GL account.

any suggestion friends.................

thx for ur help....................

ashish_andani
Contributor
0 Kudos

hi..

please ask ur FI people and confirm the G/L account for these NOVS and Zoct purposes..

and then Go to M/08 pricing proc and assign Keys in front of these cond type..

and in OBYC...maintain the G/Laccount against that keys...

Try this out..

Thanks

BijayBarik
Active Contributor
0 Kudos

Hi,

For NAVS not require to hit any G/L account.

If needed to hit a G/L account for Octroi Charge ,then keep an accounting key & an accrual key {FR1 or you can create a new key} for condition type for ZOCT in MM pricing procedure.

NOTE:

Your thread on "tax rate" is already answered.If you have further any issue,start a new thread. Check & Read Forum Rules :

https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement

Regards,

Biju K

Answers (1)

Answers (1)

Former Member
0 Kudos

This message was moderated.