Account Key in Revenue Account Determination

[Former Member]

Hello Experts,

I have a situation where the message u2018GL missingu2019 comes up when I am about to save a sales order. Clicking takes me to the revenue account determination procedure (KOFI00) and I was able to establish that even though revenue accounts were maintained for the table/sequence that meets my purpose (sales org/dist chan/division/acct key), the system was looking at table 4 (general - which only has sales org).

I later established that all tables that have account key in their combination were not checked. The system was only checking table 4 (general).

Can anyone help on how to resolve this? I need the system to look at the table that meets my requirement, which must have account key.

Thanks,

Luqman

[Former Member]

Hi,

I faced the same problem in one of my previous clients. When I was thinking of how to resolve this, it struck to me that Revenue account determination also works on Condition Technique.

By this I mean to say that, in your case, the system is able to find a G/L in table 4, so it is not reading tables maintained after 4. Therefore I would recommend you to move your combination up the order in SPRO-Sales & Distn - BF-Acct assignment - Rev Acct Det- Define acc seq and acct det types - Select your access seq and move your table before table 4.

This will resolve your issue. Let me know if the issue still persists or if my explanation was not clear.

Regards,

Rohan Gudavalli

[Former Member]

Thanks Rohan,

In my current situation, the system is able to read table 9 (Sales/Dist Chan/Div) and another table 999 (though for a different chart of account). This is why I could say it looked like for my CoA and Sales Org, it is any table that has account key that is not been read by the system.

Could there be anything wrong with the account key?

Regards,

Luqman

[Former Member]

Hi,

If it is reading the table, then I would recommend you to check once again if you have done the G/L determination for both KOFI and KOFK condition types for that particular account key in the table you are referring to.

Please update the forum after checking.

Regards,

Rohan Gudavalli

[Former Member]

Hi,

I have maintained KOFK in the GL determination, yet the issue isn't resolved.

I'll appreciate any other suggestions to resolve this issue.

Thanks

Luqman

[prasanna_kumar4]

Hi,

The message on my access is 'Access KOFI not carried out (Initialised field)'

Can you please tell me Are you defined new condition Table with new field catalog?

In VA02 --> Environment ---> Analysis --> Accounting determination

if you don't mind can you please tell me what is the values system is picking and what are the values system is not picking and also tel me system is showing any yellow color

Revert,

Regards,

Prasanna

[Former Member]

Hi,

I didnt define a new condition table from the field catalogue.

From account determination, the system only picks from 50 (KOFI) - General. And there is a yellow colour on the account key for all tables that has account key in the determination.

Hope this helps.

Thanks,

Luqman

[Former Member]

Hello Luqman,

In your sales order you will get the Condition type also for which system is not able to determine the account.

So can you please check out the Account Key for that Condition type and then setting in VKOA.

Also under message The message on my access is 'Access KOFI not carried out (Initialised field)' you will find the combination on which you should have saved the condition record in VKOA.

So please check those out and confirm with you setting.

Regards

Raj

[gomatheeswaran_palaniappa]

Hi,

Please check whether anyone maintained a tax condition manually in the sales document conditions tab. If so, the account key will not be determined automatically and would throw an yellow indicator in analysis.

Pl update pricing with 'G' and check incompletion log and revert.

Regards,

P Gomatheeswaran

[alex_zheng]

Hi Luqman,

Have you checked the account determination analysis in sales order?

You could check that via menu path:

Environment -> Analysis -> Account Determination

What does the analysis say about your own defined acess?

Is there any message shown there(for example, requirement not fulfilled, key field missing...)?

Cheers,

Alex

[Former Member]

Hello Alex,

The message on my access is 'Access KOFI not carried out (Initialised field)'

This same message is also on other accesses except that of 'General'.

Hope this helps.

I am yet to resolve this.

Regards,

Luqman

[Lakshmipathi]

Check whether this thread helps you

[Re: Missing G/L in sales order|;

thanks

G. Lakshmipathi