Skip to Content
author's profile photo Former Member
Former Member

Account Determination Error

Hello

I am trying to save a billing document and it is giving me account determination error. I work in FI and need to fix this error. Please provide advice.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

11 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2007 at 05:24 PM

    HI,

    WAT IS THE ERROR SHOWING THERE...

    GOTO VKOA..AND ASSIGN WITH COMBINATION OF APPLICATION, CHART OF ACCOUNTS, CONDITION TYPE, ACCOUNT ASSIGNMENT OF MATERAIL, ACCOUNT ASSIGMNET OF CUSTOMER, ACCOUNT KEYS ...

    TRY TO MAINTAIN SAME IN CUSTOMER MASTER AND MATERIALMASTER...ACCOUNT ASSIGNMENT...

    REWARD IF IT HELPS

    RAMKI

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 13, 2007 at 05:42 PM

    Hi

    1) Use T Code Vf02

    2) enter Billing document number

    3) Click on Release to Accounting

    If there is a error, click on the Error message - this will sow the details of the error:

    Common errors could be:

    a) Pricing - could be some conditions have not been given and needs to be updated

    b) some settings related to TAX calculation may be missing

    c) some seetings for CO may be missing

    d) the period may have been closed and needs to be reopened

    verify and come to a conclusion on the error

    cheers

    nandu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2007 at 02:36 AM

    To resolve the error, you can analyze account determination in the billing document. Process:

    Goto T.Code: VF02 & Enter Invoice number

    Next (On the top most strip) goto Environment

    Next (Select Environment) go to Account determination

    Next (In Account Determination) select Revenue Account Determination (first option)

    This will list all the condition types in the Billing document & analyze each condition & check for which G/L accounts is not determined.

    Possible errors:

    1. VKOA not maintained for required combination

    Solution: Maintain the combination in VKOA.

    2. Account Assignment of Customer / material not maintained in Customer / Material Master (If maintained in combination in VKOA).

    Solution:

    Option 1 (Standard solution):

    step 1: Cancel Billing Document --> Reverse PGI --> cancel Delivery --> Cancel Sales Order

    step 2: Maintain Customer master / Material Master correctly.

    step 3: Recreate sales Order --> Delivery --> PGI --> Invoicing.

    Option 2:

    Force the Account Assignment Group of Customer / Material through Debug in change mode of Billing document, which will release Billing Document to Accounting.

    3. Account Key not maintained in Pricing Procedure:

    Impact: This may create accounting document, but if condition type, which are to be posted to account, but do not have account key maintained in pricing procedure, it will not be post the relevant condition type to G/L account.

    From FI Side, you require to check that all the G/L account has been maintained through T.Code: FS00. G/L account being Master data has to be created in each client ot uploaded through LSMW / SCATT / BDC.

    In Billing Document in change mode (in the first screen where we enter Billing Document number), on the top most left hand corner, take a dropdown on Billing Document & select Release to accounting. Here you can get the under mentioned possible message:

    1. G/L account not found

    2. Cost Element not maintained for G/L account.

    In both the above cases, FI consultant requires to take corrective action.

    Regards,

    Rajesh Banka

    Reward points if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 12:02 PM
    • How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 12:07 PM

    Please go to t-code VKOA do the settings for account keys and g/l accounts

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 12:15 PM

    Hi,

    Go to VF02, input Invoice number, try to release to accounting manually.

    Then you will get to know the error:

    If it is pricing error, then check the pricing records and click on update price in VF02, item pricing screen.

    If it is costing error, then copy the material and plant along with company code, go to CK11N t-code, input Material, Plant and run the costing for the following variants:

    ASCE

    CSCE

    DSCE

    TSCE and select itemization for all and save it.

    Then go to CK24 T-code, then input Company code, material and plant, uncheck "Test Run" and Mark the items for costing and execute.

    Once again click on "Release" and then execute and then ensure you have a tick mark and green light against your company code in this T-code and finally save the same.

    Then go back to VF02 and manually release the document to accounting

    Please Reward If Really Helpful,

    Thanks and Regards,

    Sateesh.Kandula

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 12:28 PM

    hi ,

    go to transaction code VKOA and assign the accountkeys and G/L accounts to your sales organisation and chart of accounts

    hope this will resolve your problem

    Pls reward points if the answer is helpful

    REgards,

    Murali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 08:15 PM

    hi,

    First check everything as mentioned below:

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 10:20 PM

    Hi

    if you have user exist then try this option to go to t.cdoe va02 go line items conditions and then update the price

    just see it should work

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 02:47 AM

    To resolve the error, you can analyze account determination in the billing document. Process:

    Goto T.Code: VF02 & Enter Invoice number

    Next (On the top most strip) goto Environment

    Next (Select Environment) go to Account determination

    Next (In Account Determination) select Revenue Account Determination (first option)

    This will list all the condition types in the Billing document & analyze each condition & check for which G/L accounts is not determined.

    Possible errors:

    1. VKOA not maintained for required combination

    Solution: Maintain the combination in VKOA.

    2. Account Assignment of Customer / material not maintained in Customer / Material Master (If maintained in combination in VKOA).

    Solution:

    Option 1 (Standard solution):

    step 1: Cancel Billing Document --> Reverse PGI --> cancel Delivery --> Cancel Sales Order

    step 2: Maintain Customer master / Material Master correctly.

    step 3: Recreate sales Order --> Delivery --> PGI --> Invoicing.

    Option 2:

    Force the Account Assignment Group of Customer / Material through Debug in change mode of Billing document, which will release Billing Document to Accounting.

    3. Account Key not maintained in Pricing Procedure:

    Impact: This may create accounting document, but if condition type, which are to be posted to account, but do not have account key maintained in pricing procedure, it will not be post the relevant condition type to G/L account.

    From FI Side, you require to check that all the G/L account has been maintained through T.Code: FS00. G/L account being Master data has to be created in each client ot uploaded through LSMW / SCATT / BDC.

    In Billing Document in change mode (in the first screen where we enter Billing Document number), on the top most left hand corner, take a dropdown on Billing Document & select Release to accounting. Here you can get the under mentioned possible message:

    1. G/L account not found

    2. Cost Element not maintained for G/L account.

    In both the above cases, FI consultant requires to take corrective action.

    Regards,

    Rajesh Banka

    Reward points if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.