cancel
Showing results for 
Search instead for 
Did you mean: 

error in account determination

Former Member
0 Kudos

hai,

I have raised the bill and saved than i am see the this error,

Document 90035740 saved (error in account determination)

I want to know that why this error is coming? What is the impact of this error? and how to slove this error?

Jeevan

Accepted Solutions (0)

Answers (6)

Answers (6)

Manoj_Mahajan78
Active Contributor
0 Kudos

Jeevan,

IMG MENU—Sales & Distribution—Basic Functions-Account assignment/ Costing-Revenue account determination

Check master data relevant for account assignment

Materials: account assignment groups

New entries

Account assignment group Description

K1 Finished Products

K2 Service

K3 Trading products

Save

Customers: account assignment groups

New entries

Account assignment group Description

KA Domestic

KB Export

KC Internal

Save

We use condition technique to set up Account determination

Standard Condition Type KOFI

Access sequence KOFI

Account determination Procedure KOFi00

Standard Tables

001 Customer/material account assign

002 Customer account assignment

003 Material account assignment

004 general

005 Account key

Use the above tables for search that is access sequence

Select define access sequence and account determination type

Maintain access sequences for account determination

Select new entries

Acc seq Description

ZK00 Access seq for account det

Continue

Select ZK00 and select accesses

New entries

Acc table Description

10 1 cust/mat/account key

20 5 account key

Select 10 & 1 Combination. Select fields and activate the fields

Select 20 & 5 combination and select fields and activate fields

Save the access sequence

Fields in tables

Table Fields

1 Sales Org, Cust account assignment grp.mat account assignment grp, account key

5 Sales org, account key

Same menu path

Define account determination type (Condition type)

New entries

Ctyp Name Access sequence

ZK00 Accnt det type Zk00

Save

Define and assignment account determination Procedures

Define account determination Procedure

New entries

Proce Description

ZK0000 Account det Procedure

Continue

Select Zk0000 and select control data

New entries

Step Cntr Condition Type

10 0 ZK00

Save

Assignment account determination Procedure

(Assign the procedure to all the Billing document types)

Position ZKF2

ZKF2 ZK0000

Save

Define and assign account keys

Define account Key

Account key Description

ERL Sales Revenues

ERS Sales deductions

ERF Freight revenue

MWS Taxes on sls/purchase

ERB Rebate sales deductions

ERU Rebate accruals

EVV Cash clearing

Account keys are assigned in the pricing procedure against various condition types

PR00 ERL

K004 ERS

K005 ERS

KF00 ERF

MWST MWS

B001 to B005 ERB ERU

B001 to B005 are Rebate discount condition types

Assign GL accounts

(Here we maintain information in tables, which will be searched by system for selecting GL accounts)

Select table 1

Select details button

App= application, select V for sales

Condition type= Account determination type (ZK00)

Ch= Chart of accounts= INT

(Chart of account is assigned to company code and has the complete list of GL accounts used for business)

SORG= sales org which is involved in revenue generation/ sales unit

A…= Customer account assignment Group

AAG. = Material account assignment group

Actky= Account key like ERL etc

GL account No=the GL account–NO maintained in Chart of accounts

Select new entries and maintain the following

Select Table number 5 to maintain GL accounts for tax, Rebates and cash clearing

MWS—175000

ERB—884000

ERU 884010 89000

EVV 10000

Create Order; Delivery, PGI and then billing document, when the Billing document is saved account determination should happen

First maintain account assignment groups for your customer / materials

Use VD02/ MM02

Customer Record—sales area data—Billing document—maintain account assignment Group

Maintain KA

Material master

Sales: sales org 2 view maintain account assignment group=K1

After we save the Bill the system issues the Following message

Billing document no 905612356 saved

To make sure whether information has been released to accounting, use VF02

And then click release to account icon (Flag)

System says: information already released to accounting

a)Which GL accounts have been found out?

b)What is the account document and structure of account document?

c)Where we find Receivable updated?

a)Select VF02 and Open the Billing document, then select environment, select account determination analysis, select revenue accounts

b)In the Billing document select the accounting tab and then select accounting document, This document has two levels header/ line items under line items we see posting of various GL accounts and Reconciliation account

c)SAP menu—Logistics—SD—Billing—Environment—Accounts Receivables (FBL5)

Enter customer no and Company code and execute

All customer postings (debit / credits) maintained here. To see the details click each of the Accounting document

Reward if it helps..

Regds

MM

Former Member
0 Kudos

hi,

first u have to analysis why the problem comes, means condition type of a item wouls not hit the accounts

<b>analysis</b>

vf02-> enter the billing document>press enter-> click the ENVIRONMENT in menu bar--> in ACC determination analysis click REVENUE ACCOUNTS->now the screen will show with the Line item no on the left-> the each line & condition type & see--> it should show the G/L accounts number

If it not showing it means that particular key is not hit the accounts

now check out the customer master & material master for account assignment group properly.

If this correct, then it could be problem with the account determination. Do teh confi properly

hope this helps u

regards,

Arun prasad

Former Member
0 Kudos

Hi,

For Account Determination,

Check VKOA.

Check whether you had assigned the account keys, sales org to the required G/L Accounts.

If we maintain correctly, we will not get that error.

Award if it helps.

Regards

Siri

Lakshmipathi
Active Contributor
0 Kudos

You can use the account determination analysis to review the accounts that are relevant when documents are transferred to Financial Accounting. The analysis also shows which keys, if any, the system used to find the accounts and if any errors occurred during account determination.

<b>Account Determination Analysis Information</b>

Account determination analysis provides the following information for each billing item:

-> The relevant accounts for each condition type

-> From which account assignment type the accounts were determined

-> Which accesses were carried out and their results

-> Which keys were used for the access

<b>Beginning Account Determination Analysis</b>

You can begin the account assignment analysis in a billing document on the following screens in either change or display mode:

-> Billing Item Overview

-> Header Detail

-> Item Detail

To begin the account assignment analysis on one of these screens, choose Environment -> Account determination analysis.

The system displays the condition types with account determination information that is relevant for each item.

To view detailed information about a condition type, place the cursor on the appropriate condition type and choose Goto -> Details.

The system displays the individual accesses, including notes specific to account assignment.

For each individual access, you can choose Goto -> Details to display the keys used to access the account determination tables.

Thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Jeevan

For this u have to do the accounts assignment.

IMG MENU—Sales & Distribution—Basic Functions-Account assignment/ Costing-Revenue account determination

Check master data relevant for account assignment

Materials: account assignment groups

New entries

Account assignment group Description

K1 Finished Products

K2 Service

K3 Trading products

Save

Customers: account assignment groups

New entries

Account assignment group Description

KA Domestic

KB Export

KC Internal

Save

We use condition technique to set up Account determination

Standard Condition Type KOFI

Access sequence KOFI

Account determination Procedure KOFi00

Standard Tables

001 Customer/material account assign

002 Customer account assignment

003 Material account assignment

004 general

005 Account key

Use the above tables for search that is access sequence

Select define access sequence and account determination type

Maintain access sequences for account determination

Select new entries

Acc seq Description

ZK00 Access seq for account det

Continue

Select ZK00 and select accesses

New entries

Acc table Description

10 1 cust/mat/account key

20 5 account key

Select 10 & 1 Combination. Select fields and activate the fields

Select 20 & 5 combination and select fields and activate fields

Save the access sequence

Fields in tables

Table Fields

1 Sales Org, Cust account assignment grp.mat account assignment grp, account key

5 Sales org, account key

Same menu path

Define account determination type (Condition type)

New entries

Ctyp Name Access sequence

ZK00 Accnt det type Zk00

Save

Define and assignment account determination Procedures

Define account determination Procedure

New entries

Proce Description

ZK0000 Account det Procedure

Continue

Select Zk0000 and select control data

New entries

Step Cntr Condition Type

10 0 ZK00

Save

Assignment account determination Procedure

(Assign the procedure to all the Billing document types)

Position ZKF2

ZKF2 ZK0000

Save

Define and assign account keys

Define account Key

Account key Description

ERL Sales Revenues

ERS Sales deductions

ERF Freight revenue

MWS Taxes on sls/purchase

ERB Rebate sales deductions

ERU Rebate accruals

EVV Cash clearing

Account keys are assigned in the pricing procedure against various condition types

PR00 ERL

K004 ERS

K005 ERS

KF00 ERF

MWST MWS

B001 to B005 ERB ERU

B001 to B005 are Rebate discount condition types

Assign GL accounts

(Here we maintain information in tables, which will be searched by system for selecting GL accounts)

Select table 1

Select details button

App= application, select V for sales

Condition type= Account determination type (ZK00)

Ch= Chart of accounts= INT

(Chart of account is assigned to company code and has the complete list of GL accounts used for business)

SORG= sales org which is involved in revenue generation/ sales unit

A…= Customer account assignment Group

AAG. = Material account assignment group

Actky= Account key like ERL etc

GL account No=the GL account–NO maintained in Chart of accounts

Select new entries and maintain the following

Select Table number 5 to maintain GL accounts for tax, Rebates and cash clearing

MWS—175000

ERB—884000

ERU 884010 89000

EVV 10000

Create Order; Delivery, PGI and then billing document, when the Billing document is saved account determination should happen

First maintain account assignment groups for your customer / materials

Use VD02/ MM02

Customer Record—sales area data—Billing document—maintain account assignment Group

Maintain KA

Material master

Sales: sales org 2 view maintain account assignment group=K1

After we save the Bill the system issues the Following message

Billing document no 905612356 saved

To make sure whether information has been released to accounting, use VF02

And then click release to account icon (Flag)

System says: information already released to accounting

a)Which GL accounts have been found out?

b)What is the account document and structure of account document?

c)Where we find Receivable updated?

a)Select VF02 and Open the Billing document, then select environment, select account determination analysis, select revenue accounts

b)In the Billing document select the accounting tab and then select accounting document, This document has two levels header/ line items under line items we see posting of various GL accounts and Reconciliation account

c)SAP menu—Logistics—SD—Billing—Environment—Accounts Receivables (FBL5)

Enter customer no and Company code and execute

All customer postings (debit / credits) maintained here. To see the details click each of the Accounting document

Reward if useful to u

Former Member
0 Kudos

Hi Jeevan,

Check the Account Determination VKOA.

Check whether you had maintained conditions for all the categories in that.

Thanks

Mohan