ERROR IN ACCOUNT DETERMINATION

[Former Member]

HI,

I AM NEW TO SAP SD MODULE AND BEEN PRACTICING.

EVERY TIME I TRY TO SAVE THE BILLING DOCUMENT,I GET A MESSAGE SAYING THAT "DOCUMENT IS SAVED(ERROR IN ACCOUNT DETERMINATION)".

PLEASE PROVIDE THE SOLUTION TO SOLVE THIS ERROR.

THANK YOU,

[Former Member · Accepted solution]

If the system says "Document saved (no acc doc generated) that mean there is a error in either Account determination for the Billing doc. To find out the missing G/L account use the following path:

Use T-code VF02 & enter the Billing doc no Then use the main menu> ENVIRONMENT>Acc.determination analysis-->Revenue account . Here u will see the list of condition types that you have used in the pricing procedure & for which a G/L account is required. Click on each condition type. The condition type with Missing G/L account will say" No G/L account determined" on the right side of the Condition type.

When this exercise is over then use T-code VKOA and assign a G/L account. Now when the correct G/L acc is assigned then again use T-code VF02 and enter the Billing doc no. for which u encountered the error and then either use the main menu and Billing Doc-->Release to accounting again or click the Green flag seen on the screen. This will create a Accounting doc for the Billing doc.

Also check with your FI consulant that the no. range for Accounting doc is maintained properly. The T-coder for the same is FBN1.

[Former Member]

Hi,

Account determination is an important integration between SD & FICO modules. whenever a sale takes place, the system automatically posts the various prices and discounts and freights to the respective GL accounts through the account keys.

The account key is assigned to the respective GL account. Also in the pricing procedure we have a column called as account key(second last column). There we assign the account key. For eg., in Std SAP for basic price we have acct key ERL, for discounts ERS, for Output tax MWS, for freight ERF, etc. These account keys are basically defined by the FICO consultant and then the SD consultant assigns the respective account keys against the respective condition type in the pricing procedure.

The customer group is nothing but the grouping of various customers like wholesaler, retailer, etc. This is basically useful while maintaining pricing like for X group basic price is 10Rs, for Y group it is 15Rs. like that. Similarly material group is a grouping of materials like Ball pens, ink pens, gell pens, etc.

When you create the condition table and select these fields and save it and when you assign this table to your access sequence, the system searches for the condition record according to this key combination. For that you have to maintain the condition record in VK11.

now you are done with pricing. you create the sales order. delivery and invoice. Now for the system to generate an accounting document when you save the invoice in VF01 you have to maintain the account determination correctly otherwise the system will give an error - "error in account determination."

For doing account determination you have to go to :

IMG-sales & distribution-basic functions-account assignmentcosting-revenue account determination.

In this you first have to maintain the customer account assignment group and material account assignment group. This group for the customer means for which customer whether domestic or foreign etc. For material whether finished, semi finished, raw material, etc. You can also maintain as per name of the division.

This account assignment group you have to assign in customer as well as material master. In customer master (XD01) -sales area data- billing you have customer acct asst group, make an entry here. In material master (MM01)-sales:sales org.2 you have account asst group, make a proper entry here also.

Now in the above IMG path only you have access sequence, condition type, procedure. maintain everything and assign properly the procedure to the billing document type.

Now go to transaction code VKOA. You will see 5 tables. first is customer group/material group/acct key. When you double click on this it will show as following:

Application, condition type, chart of accounts, sales org., customer acct asst group, material acct asst group, acct key, G/L acct, provision acct. depending upon your customer type and material type you have to maintain all the columns and the respective G/L accounts. Like this do it for the remaining 4 tables.

Now whenever you make a sales order, delivery and invoice and when you save the incoice the system will automatically post the price, discount, tax, freight to the respective G/L accounts. This will make an accounting document which will show the exact value of price, discount, tax, freight for that particular transaction.

I hope I have answered your Query. Please reward valuable points if solution found useful.

Regards,

Allabaqsh G. Patil

[Former Member]

Hello,

There is an error in account determination. To check this

1. Goto VF02 provide billing document number.

2. Environment>Acc.determination analysis>Revenue account. Here you will find the list of condition types that are used in the pricing procedure & a G/L account is needed.

3. Now check each condition type. You will find a message stating "No G/L account determined" on the right side of the condition type missing G/L account.

After this, use VKOA and assign G/L account.

Then goto VF02 give billing document number and then click on the green flag which signals release to accounting.

Now accounting document will be generated.

To check for the accounting document use FB02.

Hope this helps.

Regards,

Priyanka

[Former Member]

Hi use

VF02

and release the billing document and see the error.

If G/L A/C is not their then

FS00

-create and in

VKOA

assign G/L account to accounting key.

If the error with costing run the costing

CK11N

and release it

CK24

.

If tax code not maintained plz maintain it into

VK12

.

These are the probable solutions depending upon the error you can use any one of them.

Best Regards

Sainath

[Former Member]

hi deepika

use tcode VKOA and assign the g/l account for along with account keys.

also for manual posting of ur billing document go to tcode VF02 and enter ur document number and press the flag icon which posts your billing doc to FI.

regards

madhu

[Former Member]

Hi Deepika,

Welcome to SDN and ALL THE BEST!

First check that have u configured account determination in SD.

If s, go to VF02, for the billing document, go to Environment, check the account determination analysis for the condition types.

Regards,

PRaveen.