How to create the Access sequence for the Vendor+material+plant combination

[Former Member]

Hi all

Please let me know How to create the Access sequence for the Vendormaterialplant combination..

Whats the use? What its effect in purhcase and taxe..

brief me please

[former_member197616 · Accepted solution]

as you are asking for the pricing, the acces sequence you asked will be created at spro-mmpurchasingconditiuons-price determination process.here

you create the condition table with a number with the firelds you require.

at access , create a access and assign the table with a sequence so that an access sequemce for creation 0f the condition trable will get created.

assign the acess sequence to the condition type say PBXX.

Create the condotion record at MEK1 for the condition type.

then whenever you create the PO with these conditions, the record created will get defaulted in your po.

please check any std condition table/sequence available for the combination before you proceed for new creation.

Regards,

[Former Member · Accepted solution]

The requirement is

We need to have the USE tax 7.5% .The Tax code will maintain at PO. then when GR the accounting entry will be Inventory G/L debit- 1100..(Ex:100 USD tax ),GR/IR G/lCredit1100

at MIRO Vednor account Credit 1000, GR/IR debit 1100..and Tax accural G/L credit--100

For the same we are maintained the tax code. But it is not working then as per SAP Labs solution given to us.we need to set up the access sequence..In FTXP just looking the access sequence thr...o environment noting displaying...Can you explain to me now

[adwait_bachuwar · Accepted solution]

Hi,

you are asked to maintain the access sequence for the tax condition for which you are putting 7.5%.

goto OBQ1 or img..financial accounting new...global settings.... taxes on sales and purchases ......basic settings.....

find the tax condition type. see in it which access sequence is attached.

if there is none then use JTAX used for taxes in India.

or you can create the similar one for your.

to create the same goto OBQ2.

new entry or copy JTAX.

and assign the access sequence to condition type.

this will resolve your problem if you just need to assign the access sequence.

regards,

Adwait Bachuwar

[Former Member · Accepted solution]

The basic requiremnt is below accouting entries

GRN

Inventory DR 1075 (1000 Price + 75 Tax) loaded on item

GR/IR CR 1075

INVOICE

Vendor Cr 1000

Tax Accrual Cr 75

GR/IR Dr 1075

[adwait_bachuwar · Accepted solution]

Hi,

as per the requirement to create the Plant-Vendor-Material access sequence you can use the table 363 in your existing access sequence.

i am doubtful about the postings in MIRO.

in India similar tax requirement is there where during MIGO it gets loaded on stock.

in MIRO just GR/IR gets cleared but not the separate line item.

regards,

Adwait Bachuwar

[murugan_mgl · Accepted solution]

HI,

For the taxes to be loaded to the material it all depends on the acct key & accrual key u provide to the cond type in M/08.In OBCN

for the acct key u define whether it is deductible or Non deductible.

If the tax rate is differing during IV then select the appropriate tax code in MIRO.

[former_member197616]

Hi,

Basically you want to create the access sequence for purchasing pricing conditions or for tax codes?

if you want to create access sequnece for purchasing conditions , create the access sequnce as per my previous posting.

if not you want to create for tax code at FTXP for the tax code Environment ---calculation proceedure --access sequnce you can create.

once a condition table created can not be deleted .Try deleting the table by deactivating in the sequence.

Regards,

[Former Member]

hi

i am working on the Tax from very long days..but not comes across the below requirement. the tax has to be loaded on items and same time while MIRO it sud go to accrual G/L..The tax amount will not go to the vendor

GRN

Inventory DR 1075 (1000 Price + 75 Tax)

GR/IR CR 1075

INVOICE

Vendor Cr 1000

Tax Accrual Cr 75

GR/IR Dr 1075

now you can explain in system

[suma_mani]

Hi Thenna,

Check below mentioned link.I hope that is helpful to get your required entries.

/message/6202480#6202480 [original link is broken]

Best Rgds

SumaMani

[Former Member]

This message was moderated.

[Former Member]

can anybodies give the tips for HKNOT field is empty while posting the MIRO...Basically i have done the this tax settings and accounting entries are correct ..only the problem is error FF804 no.

[former_member197616]

Hi,

In the answers it is understood that you not asking for access sequence creation for base price pbxx correct.You are telling that you have implemented the sap suggestion.could you please give us the note number so that we can provide you the best solution.

at FTXP you can create a tax code whichcan be assigned to a tax procedure for that country.with a value and a GL.

Regards,

[Former Member]

Dear Friend,

First create the table or copy the table no 17 in that remove the purchase organisation and info record category and maintain

the new table and copy any existing aces es sequences and assign that table to new access sequence

Regards

Pramod

[Former Member]

In M/07 if we are copying the access , the fields are also getting copied for the 017 tab Which is required for us. Now how to delete the fields like pur organisation..since there is no option for delete

Edited by: thenna arasu on Oct 31, 2009 5:22 PM