Account determinatin

[Former Member]

Can anybody send me the details on the account determination in SD?

a) When we save the billing document, where and how the posting is happening in SD and FI

b) What are all the G/L accounts and Account key are required to carry out the account determination

c) Is there any cheking tool to check the configured account determination is correct.

d) If we get the error at the time of billing document, what are all the parameters to check to get the document posted.

Please send if you have any related material to mani.saphelp@yahoo.com

Regards

Manivannan R

[Former Member · Accepted solution]

Hi,

mail sent

Regards

Ali

[Former Member]

hi,

1. when we save the billing document, acccounting document will be generated automatically and will posted in the gl accounts. the integration between SD and FI are the account keys which is maintained in sd pricing procedure for the condition types.

2. The GL account keys are

ERL - sales revenue

ERS - sales deductions

ERB- rebate sales deductions

ERU - rebate sales accruals.

ERF- freight

MWS - tax

EVV- cash clearing.

3. VF02 is th option, where the bill document no will be appear on the screen and right side of your hand on the top of application tool bar u will find green flag, just click it and see. whether your posting and determination happened or not it will show.

4. when u get the error while saving the billing document, you have to see

a. kindly check your account determination again carefully. if yes then

b. whether u have maintained account assignment group in the customer master record under billing tab, and in the material master record under sales organistion 2 tab.

c. u have to see the account determination procdure have been assigned to ur billing document type. (F2).

d. if there is any currency issue ex- Instead of INR, if it is like EUR, u have to rectify the gl accounts thr the T.code - FS00. for your company code.

reward points if it is useful.

regards

KR

[Former Member]

Hi,

<b>(a) With the help of account keys for the condition types</b> in the pricing procedure and G/L accounts assigned to the account keys in the accout determination procedure, the system posts the values of the condition types to the respective G/L accounts. The reconciliation account specified in the customer master data gets updated. This account shows the amount the customer has to pay to us. For account key ERL - basic price, ERS - Discounts, ERF - freight, EXD - excise duty, etc.

<b>(b) G/L accounts are different for different companies</b>. When the implementation is done the finance core team member of the client will give all the G/L accounts used by them.

<b>Account determination procedure:</b>

IMG - sales & distribution - basic functions - account assignment / costing - revenue account determination:

1. check master data relevant for accoutn assignment. Here you create the customer and material account assignment group.

2. Define dependencies of revenue account determination. Here you create the condition table.

3. Define access sequence and account determination types.

4. Define & assign the account determination procedure.

5. Define & assign account keys.

6. Asign G/L accounts. Here you will have 5 diffrent key combinations. Maintain the G/L accounts as per your requirement.

7. V/08. Here select your pricing procedure and maintain the account keys for the respective condition types.

<b>(c) Checking tool:</b>

When you create the invoice in VF01 then at this stage the system searches for the G/L accounts to which it has to post the amounts of the condition types. If everything is correct then the accounting document will be generated otherwise the system will give you an error that "Document xyz saved (error in account determination)"

<b>(d) error:</b>

If error comes in billing document, save the billing document, go to change mode select the document go to environment - account determination analysis - revenue accounts. Here just click on the condition type and in the right hand side of the screen the system will show whether it was able to find a G/L account for the respective condition type. If not found then go to VKOA and maintain the G/L account and save.

Now go to VF02 and save the billing document. Error will be solved.

Reward points if solution helps.

Regards,

Allabaqsh G. patil

[Former Member]

Hi,

REVENUE ACCOUNT DETERMINATION: VKOA. To which General Ledger Account the sales values are to be posted is controlled by revenue account det. It is an integration between FI & SD. Here the link is the account key in the pricing procedure.

SPRO- IMG- Basic Functions- Account Assignment / Costing- Revenue Account Det- Assign General Ledger Accounts (GL accounts)

Account Keys:

• KOFI: profit based account type

• KOFK: cost based account type

• KOFI00: procedure for account determination

We need to assign the G/L accounts to the combination of:

• Application: specify “V” sales & distribution

• Condition type: specifies condition types in the proc if controlling is activated in finance take the cond type “KOFK” other wise take “KOFI”

• Chart of Accounts: it’s a classification scheme, consisting of a group of GL accounts. Here we need to specify in which chart of accounts the GL account we are assigning exists

• Sales organisation

• Account assignment group of customers: this is specified in the CMD. (billing above tax table)

• Account assignment group of materials: this is specified in MMR. (Sales orgn)

• Account key: this is specified for each cond type in the procedure

Sales Orgn’s A/C Assignment Grp Cust A/C Assignment Grp Mat A/C Key

1000 01: domestic TR: trading goods ERL: sales revenues

2000 02: export sales FI: finished goods ERS: sales deductions

App Cond Type Chart of A/C S.O Cust A/C assign Mat A/C assign A/C key GL accounts

V KOFI INT 1000 01 TR ERL 1000

V KOFI INT 1000 01 TR ERS 2000

V KOFI INT 1000 01 FI ERL 3000

V KOFI INT 1000 01 FI ERS 4000

V KOFI INT 1000 02 TR ERL 5000

V KOFI INT 1000 02 TR ERS 6000

V KOFI INT 1000 02 FI ERL 7000

V KOFI INT 1000 02 FI ERS 8000

V KOFI INT 2000 01 TR ERL 10000

V KOFI INT 2000 01 TR ERS 20000

V KOFI INT 2000 01 FI ERL 30000

V KOFI INT 2000 01 FI ERS 40000

V KOFI INT 2000 02 TR ERL 50000

V KOFI INT 2000 02 TR ERS 60000

V KOFI INT 2000 02 FI ERL 70000

V KOFI INT 2000 02 FI ERS 80000

This concept is based on cond tech.

• SPRO- IMG- SD- Basic Functions- Account Assignment/ Costing- Revenue A/C Determination- Define Dependencies of revenue account determination (V/14, V12, V/13): cond table

• Define access sequences and account determination types

o Maintain access sequences for account determination

o Define account determination types: assign acc seq to cond type

• Define & assign account det proc: KOFI00: KOFI- requirement 3. KOFK- requirement 2.

o Define account det procedure

o Assign the account det proc to the billing doc type

• Can you do account determination with an account key

o Yes, you can post in GL accounts without account key. Application/ Chart of accounts/ sales orgn/ cust account assignment/ mat account assignment.

• After invoice you can go to FB03 and find the posting of GL account. From VA02 document flow you can find the accounting number.

You can assign GL accounts in the following ways:

• Cust Group/ Mat Group/ Account Key: application, cond type, chart of a/c, sales orgn, cust a/c, mat a/c, a/c key, GL account, GL account

• Cust Group/ Account Key: application, cond type, chart of a/c, sales orgn, cust a/c, a/c key, GL account, GL account

• Mat Group/ Account Key: application, cond type, chart of a/c, mat a/c, a/c key, GL a/c, GL a/c

• General: application, cond type, chart of a/c, sales, GL a/c, GL a/c

• Account Key: application, cond type, chart of a/c, sales, GL a/c, GL a/c.

Thanks

sadhu kishore

[Former Member]

Hi,

a) When v save billing document, automatic account posting to GL accounts are carried out. From SD side...the link is at the account key assignment in pricing procedures...assignign account key to condition types in control data of pricing procedures. For these account keys...specific GL accounts are assigned in Account determination procedure.

b) Account keys are available at the SD side. u assign the specific account keys ( ERL, ERS, ERU...) for different condtioin types like..sales price, discounts, frieght....

GL accounts are given from FI for specific transacton types or condtions.

c) Check account key assignement in pricing procedure control data for various condtion types.

check the account assignment group maintained in CMR and MMR.

Check the account detrmiantion for GL account assignment.

U can also make analysis in Billing document in Environmnet/account determination analysis.

Hope this wld help U

Reward if helpful.

Regards,

Praveen.