24 Comments

aaa says:

>Recon accounts, tax accounts, and so on should not be flagged as line item >displayed.

Why?

David says:

Good question. They shouldn’t be flagged as li display since the relevant subledger will have the supporting detail. Additionally, having them flagged as LI display will generate a lot of activity in the GL line item index tables – bsis and bsas – which will just be a poor duplicate of the subledger.

MANSOOR BASHA says:

very good detailed concept about GL

SG says:

It’s important to explain the accounting impact on FX, both realised and unrealised, of the combination of settings between Only Balances in LC and Open Item Management for monetary related accounts and its relevance to Second LC. There are some recommended setting rules and possible exceptions to the rule depending on account usage.

pv says:

I have doubts, hope for some solutions
I learned that, without reconciliation account we cannot create an account, is it true. And I also learned that recon account will only be used for the sub ledgers, if so what about all the other GL accounts.
I also want to under stand about the group chart of accounts number, where does it actually come into picture. in what conditions, we use reconciliation account and group chart of accounts number.

David says:

Hi PV –

Thanks for reading and for the questions. A reconciliation account is used to track activity posted against the subledger inside of the GL. So if everything is in order, the balance of all customer accounts assigned to an AR reconciliation account should sum up to the balance on the recon account. Consider a customer invoice. The invoice will debit the customer and credit sales. The posting against the customer will debit the AR reconciliation account that is assigned to the customer.

The group chart of accounts is used to summarize the operating chart of accounts usually for reporting purposes. So if I want to look at a trial balance, I may not be interested in reviewing thousands of operating accounts. Instead, I can run my trial balance by the group account to see a more summarized view.

Hope that helps,
David

Pradipta Mohapatra says:

Hi David,

I like the materials posted in this blog. The concept of each field & their functions etc in SAP FICO.

Do you have any complete set of FICO material like this. I want learn these concept & customization of SAP ECC FICO module.
If possible, can you please send me a copy of FICO material in my Gmail ID: prd.mba10@gmail.com

Thanks & regards
Pradipta

AWS says:

nice article..can you please let me know how field status for a posting key is managed in document entry

Yommy says:

What is the purpose of the “house bank” and “account ID” fields in “Create bank” tab do or whats their impact?

Neev says:

Hi David,

I have question about The alternate account number, in which scenario we use it.

As per my understanding we use it for country specific COA.

Please advice.

Thank you

david says:

Hi Neev –

Thanks for the question, and apologies for being late in posting. I’ve been up to my eyeballs in work.

Usually the alternate account number is used to notate what the equivalent account in a legacy system is/was.

The country specific chart is usually configured per company code in addition to the operating account. The country specific account is then specified as part of the operating account.

can says:

Dear David,

I find your page very useful. Do we have a standard report to see for example some kind of mapping info we might add to FS00 in information (C/A)?
I have tried S_ALR_87012328 – G/L Account List , but doesnt work.
Thanks

david says:

Hi Can –

Sorry for being slow in getting back to you and thanks for the question. There are a few options here:

1) If the mapping is very simple, you can populate the old account in the alternative account field. Most of the standard reports should support reporting on it.

2) If the mapping is more complex, you could have a developer add in a z-table. You would then need a custom report though to display the mapping.

Terry says:

Can you create a subledger within a payable/receivable account in order to facilitate reconciliation when several people are making entries into these accounts?

david says:

Hi Terry –

Thanks for reading and the question.

Let me see if I can rephrase what you’re asking – tell me if I get it wrong. “For GL accounts that are not managed through the AP and AR subledgers using vendor/customer, is there a way to facilitate reconciliation using clearing transactions?”

The answer to that question is yes. You can flag the account as open item managed and then entries can be entered using standard transactions and then cleared using FB05 or another clear transaction.

Let me know if that answers your question or if I misunderstood it.

Thanks,
David

Azam says:

Hi David,
I find you page very useful. You have mentioned that account group controls which fields are available for use on the GL master. Can you tell me any function module which returns these field status variant in SAP, since I am developing a sharepoint application to create GL account where I am finding difficulties in hiding inactive fields

Thanks in advance.

david says:

Hi Azam –

Thanks for reading and for the question. I’m not a developer though, so I’m not going to be much help on this one. Sorry and best of luck in finding a solution.

David

RAMANA says:

Hi David,

I find your page very useful, You haven’t Explain about Valuation group , can u explain that

Sailaja says:

David, How do the G/L accounts get populated with different languages (in SKAT). I’m trying to get all the accounts for a particular company code and their descriptions in Spanish. But I see not all the accounts assigned in SKB1 for that company code have descriptions in Spanish. Few are missing. What is driving the population of SKAT in multiple languages?

david says:

Hi Sailaja –

For most configuration items, you have to log in to SAP in that language to update the labels. In the case of GL accounts, if you go into the account in FS00 and select the “Key word/Translation” tab, you should see the long text at the bottom. You can add multiple languages from here.

Good luck,
David

vindya says:

Hi David, Thank you for a clear and informative article. I will be visiting your blog often : )

Alvin Jason Tabios says:

Hi David,

Re: account group, you mentioned that “Often, the account group is used to help with reporting.”

Requesting for advice. Our client was asking if there is a way to include in a custom Assets report, balances of GL accounts that are not Asset Recon Accounts but to which the client directly posts some fixed asset-related acquisitions. For some reason, client does this direct FI posting (ie, no asset numbers) for certain fixed asset transactions.

Granting that the client does not really want to post such transactions to asset numbers, I thought of using the GL Account Group field in FS00 to tag the non Asset Recon Account GLs that have to be part of the custom Assets report. This way, the custom Assets report will include all GLs where GL Account Group = “Fixed assets accounts” (for example) and Recon Account = (null).

Furthermore, I checked FS10N and the Structured Account Balances report (S_PL0_86000032) before and after this “change” I did in the “Account Group” of certain non Asset Recon GLs. The balances of these GLs in FS10N and in the Structured Account Balances report did not change. Thus, I concluded that the GL Account Group field in FS00 has no impact in GL account balances and in GL balances reports.

Would this “work-around” solution of using the GL Account Group field for a custom Assets report be advisable?

Thank you very much in advance!

Alvin Jason Tabios says:

Hi,
Just ticking the checkbox “Notify me of followup comments via e-mail. You can also subscribe without commenting.”

seethaya says:

Hi david ,

I find you’s blog this is very use full and ease to under standing for me, i have one doubts could you please briefly explain to me valuation group , account clerk ,supplement auto posting,recon acct ready for input .

Thanks ,
seethaya

Leave a Reply