KEAT Issue

[Former Member]

Dear Experts,

When i see T.code KEAT Sales part tally with SA/FI/PCA but when i see COGM part it does not tally.It shows value olny on CO-PA.

So kindly suggest how to come this COGM(raw material,subcontracting,production OH).

Waiting for your reply.

Regards,

Debashis

[dawoodkhalid]

Hello Debashis,

Close the thread or let me know if there would be any issue still remaining.

[Former Member]

Hi Khalid,

The issue is still open.I checked all point.Please send me your email id i send you details in screen shot.

Regards,

Debashis

[dawoodkhalid]

you can send the screenshots here

[dawoodkhalid]

mentioning the mails in SCN is not allowed; read SCN rules of engagement.

[dawoodkhalid]

Close this issue and open it in the "ERP Financials Controlling" space not in "Financials and Controlling Accelerator" space.

this issue is more relevant to this mentioned space.

[Former Member]

Closing the issue.

[dawoodkhalid]

Dear Debashis,

All the COGS values will flow to COPA automatically except the manual postings. Once the billing document is released to accounting all the values will flow.

The reason behind this is that COGS flows to COPA through the condition type VPRS in Pricing Procedure, which is your standard cost estimate. The condition VPRS needs to be mapped to a value field in KE4I Then during billing the value in cond VPRS will be transferred to that value field. VPRS being a statistical cond the values will flow to COPA since statistical conditions are always passed to COPA.

[dawoodkhalid]

Check T.code KEAT and KE4S

You can reconcile and post if you want to match

REMEMBER:

KEAT is meant to detect customizing errors for single billing documents by checking the reconciliation between SD, COPA, PCA and FI.   The KEAT report checks  billing documents and verifies that these have been posted to FI ,COPA and PCA. If a value has been billed, the system reads the billing document and from the SD condition type finds what GL Accounts should be posted to.

[dawoodkhalid]

Also something that users do, that they shouldn't, is post journals to the accounts that are posted directly from SD etc.  Check your GL line items on document type SA.  These entries should be reversed and a solution for them found because they are very likely not in PA.  If they do post to PA, look for the Profit segment button on 'more data', if it brings up a pop up with PA characteristics, it is posting to PA, otherwise not.  If you cannot see this button, it also won't be in PA. It might mean setting up FI postings to PA later (not recommended).

Hope this helps

[Former Member]

Hi Khalid,

I checked all point of view no direct posting done from FI which is SD related.

Only CO-PA column value flows other line FI,SD,PCA no value flows.Not only current customer another customer has same issue.

IN KEAT value actually flow to FI,SD & PCA or not.

Kindly suggest.FI Sd COPA reconciliation was halt.

.

Regards,

Debashis

[dawoodkhalid]

What is your costing scenario, are you costing your products on make to order then reconcile it through KEAW to check value flow from Order/Project Settlement.

Have you done assessment and order settlement to bring those values to COPA?

[dawoodkhalid]

Also ensure the following steps:

For PCA and FI difference see KE5T report

For FI, SD and COPA difference check KEAT report.

For PCA, make sure you have 3KEH, OKB9 settings in place. Also write OKC9 substitutions. In PCA, if there difference is already there you cannot rectify retrospectively. However, you can use 9KE0 or 1KEL for posting documents. Also check 1KE4 for unassigned objects to PCA

In COPA, check whether your condition types and values fields are correctly mapped.

[dawoodkhalid]

Also in some direct FI entries (like FB50, FB60), you might not have updated the COPA data (profitability segment). So such entries would reflect in F.01 but not in KE30 reports.

[dawoodkhalid]

1) Mostly the problems are due to doing completed process in two different months, the common example is delivery and invoice in different months i.e. Delivery is completed for sales order and Invoice is not raise in the same month.

2) Check whether discount condition type in SD assigned to value field in CO-PA without +/- indicators???, this was adding discount to revenue in CO-PA and minus in FI.

3) Credit note entered without doing goods receipt entry (delivery note entry)???

[dawoodkhalid]

Visit the following 2 links for further details:

http://www.spc4saparis.ch/pdf/FICO-Reconciliation-tool.pdf

Controlling 2012 Systematic Guidelines for Reconciling CO-PA to the...

[Former Member]

There is no +/- sign in condition type value field customization & there is no discount field.

Regards,

Debashis

[Former Member]

Hello Debashis,

KEAT is used for reconciliation of the values between COPA-SD-PCA and FI.

You said that sales figures are matching  with SA/FI/PCA but COGM value is not appearing in SD/FI and PCA. That means COGM values are not posted to SD/FI and PCA.

Just drill down the COGM node and system will take you to the original document wherefrom COGM is posted in COPA. This will help you to analyze why COGM is not updated in cross modules i.e. SD/FI/PCA

regards,

makrand

[Former Member]

Hi Makrand,

As per your suggestion drill down COGM means in KEAT report Raw material cost ,subcontracting cost coming in COPA line other line like SD value ,PCA value ,FI value field are blank .If i double clicking on Raw material cost there is nothing came.

Please suggest.Is it coming due to COGS is a cost element?

Regards,

Debashis

[Former Member]

Dear Experts,

I'm waiting  for your valuable suggestion to come out the issue.

Regards,

Debashis Sagoo