KE5T Report - amount difference

[Former Member]

Hi Gurus,

Need your expertise on this.

When we view KE5T report for account 60685, we noticed a difference between the base ledger and comparison ledger amount. For the base ledger totals, we found out that totals from GLT0 table was calculated based on the amounts from FBL3N (G/L Line Item Display )report but we cannot find out how does SAP came up w/ the totals for comparison ledger(PCA - GLPCT table). We tried checking GLPCA table for a more detailed data to find out how totals on PCA was calculated but totals did not matched with ours.In addition, no records were found when we tried searching for account 60685 in GLPCA table. Note that all FI docs(auto posted thru MM) has its corresponding PCA docs.

Can you please enlighten us how comparison ledger total amounts are calculated?

Thanks.

Ellen

[Former Member]

Hi Ellen, KE5T differences can be hard to track down...but base on the description of your symptoms, I think you need to look at the following:

(1) If you cannot find any line items for account 60685 in GLPCA (or tcode KE5Z) or COEP, etc, that means the account does not have any cost object assigned  to it. This can happen in the case where the account does not exists as a cost element (which means SAP allowed user to post to it without a cost object though the account is a P&L account). So check, KA03 to see if the account exist. If it does not exists, then that is the root cause of your problems. That means, MM/FI documents associated with the accounts never made it to CO or PCA.

If all of the above is true, I am afraid you have a little monster to deal with. Depending on how long this has been going on, you may need to transfer (tcode 1KE8. CAUTION: use very carefully) the specific line items again from MM/FI but the analysis work you need to determine what documents to transfer can be extensive. The major caveat is, you have to create the account first as a cost element. There lies your conundrum: Because the cost objects fields are initially empty, then you cannot repost these entries in CO (details is you need it). Keep in mind that the PCA/FI ledger is what you are looking at when reviewing KE5T. So if the CO line items is not of importance, then you can just focus on PCA which is much easier to address and get to balance. For this, you will need to run tcode (9KE0), and post the missing balances as a one sided entry-no offsets broken down by Cost objects (Cost centers, IO, whatever) + Profit Centers. In this tcode, only the PC is important as the other data like cost centers are only statistical at this point...meaning, the entries don't get back posted to CO. but you get your balance by PC in GLPCT which will then clear your KE5T difference. Now, depending on which ledger you are using for consolidation, you have to analyze that impact. To post a one-sided entry in 9KE0, you need a special configuration for document type...You can enable this in SPRO (details can follow if you need it)

Please come back with questions if you need further details.

Thanks,
Sam

[Former Member]

Thanks Samuel!

As per checking, account 60685 doesn't exist as a cost element in KA03 but the g/l account is a balance sheet account and not p/l account. Will we still proceed on the solution you have mentioned?

Another question is, do you have any idea how does SAP came up w/ the totals in GLPCT table where-in fact there was no line item for account 60685 in GLPCA. There was a difference of SGD 200.00 between base ledger and comparison ledger.

Base Ledger = SGD 5600.00

Comparison Ledger = SGD 5400.00

Your advise would be greatly appreciated.

Regards,

Ellen

[Former Member]

Hi Samuel

We have a similar issue but with a Balance sheet Payables account.

Could you please help us check the same?

Regards

Aashish

[Former Member]

Hi Ellen, sorry your question fell off my radar.  If this account is a balance sheet account, does your accounting policy require that this account be reported at a profit center level? If so, look at the setup in 3KEH to make sure the account has a default profit center assigned.

If it's the case that it does, then you should see some entries in GLPCT for it. It sounds like you do. So that eliminates missing settings like setting up the account for Automatic transfer from FI to PCA.

There are numerous ways that items end up in GLPCT without corresponding entries in GLPCA. There's an OSS note that describes these and I don't happen to have the number. Just search for GLPCT , GLPCA , "Transfer" as key words in OSS. I have a PDF file that describes these, not sure how to get it to you.

What kind of account is this (what is it used for?)

[Former Member]

Aashish, you case should be relatively simpler. Just run F.5D and 1KEK to balance up your payables in PCA. If still not there, then make sure when running KE5T that you are including beginning balance (period = 0) and showing differences only.