Material Ledger KDM-PNL Not Posting to ML

[Former Member]

Hello Experts,

We are currently in the testing phase for ML startup. I am having a problem with the Exchange Rate Difference KDM-PNL not posting to ML. The account determination is setup with the KDM-PNL with the correct valuation class and GL account. The GL account for the KDM-PNL is being posted to in FI. When I run the Value Flow Monitor this is causing a diference between ML and FI.

I would appreciate any advice that you might have.

Regards,

Greg

[Former Member · Accepted solution]

Hi Arturo,

I will try to answer your questions in the screen shots below.

Questions:

1. In ckm3n, you see the Exchange Rate Dif in the colum ? Yes. In CKM3 I see the ERD.

2. Do you have 1 or 2 accounts ( 1 for credit and 1 for debit) for Exchange Rate Diff? Could you post here a OBYC screen of KDV and KDM ? See below

3. In the ML Close, do you see the clearing records in the FI document? Could you post a the ML close document in FI with the transacion ? See below

Issue: The VFM is showing out of balance between FI and ML of 35.73. This is the balance in the VFM for FI postings. I do not see the KDM-PNL entry to transfer the 35.73 to the next level which should be in GL account 601256.

Material 100290. The ML settlement document is crediting account 603002 (KDM with no general modifier). Do not see the KDM-PNL entry in VFM. This is making the ML-FI out of balance. Should see the KDM-PPL posting in the VFM.

OBYC Valuation Class 5100 for material 100290 – KDM entry above in VFM.

KDM with no General Modifier

KDM with PNL modifier – should this be posted in VFM?

FI Document for account 601256 for material 100290. KDM-PNL. I do not see this entry in VFM.

KDV-PPL

ERD of 35.73 was consumed in next level in material 100416.

FI document for KDV-PPL for material 100416. Looks good.

OBYC for KDV-PPL from lower level

I hope this gives you enough information. Please let me know if you need anything else.

Regards,

Greg

[ArturoSenosain · Accepted solution]

Hi. Very nice problem 😃

You are right, KDM-PNL is missing  on the VFM. If you see the complete ML Close  FI doc 47...8 i guess you see the record OK. The problem is in VFM!!

I did a fast debut to the VFM and found something strange...  Follow the steps with your abap! Maybe Im wrong.

Se38, program ML_VALUE_FLOW_MONITOR

Set a break-point in this select about line 5300. Here the VFM read the OBYC.

SELECT * FROM t030 INTO TABLE t_t030

     WHERE ktopl = t001-ktopl

       AND ( ktosl = 'AKO'

        OR   ktosl = 'AUM'

        OR   ( ktosl = 'KDM' AND komok = '')

        OR   ( ktosl = 'KDM' AND komok = 'ERN' )

        OR   ktosl = 'KDV'

        OR   ktosl = 'PRD'

        OR   ktosl = 'PRV'

        OR   ktosl = 'PRY'

        OR   ktosl = 'UMB'

        OR   ktosl = 'UMD' ).

Run the VFM online and verify if the account for KDM-PNL is in internal table t_t030. At a glance, i can tell you the entry is missing.  See my screenshot.

I set one record for KDM, one with GMod ant the other without.

Breakpoint in the select and verify KDM-PNL is not selected!

UGH, KDM-PNL is not in the select??? I never face this stuff, because i always set KDM-PNL = KDM,because i like the net of KDM to be 0 (the logic is explained in Note 483493 - Posting logic of the material ledger closing PRD PRY PRV) I never try to set a different account for PNL, im not sure if you have to do an aditional step.

I look for OSS about this, but no luck.

I check Note 1873072 - Transaction key KDY for ML closing entries

but there is no change in CKMVFM code....

My recomendation, Try post a message in the Marketplace, replicate the steps in your system. If SAP respond, please post here, i also want to know abut this stuff but this is only my test system.

Wish this help you!

Arturo.

[Former Member · Accepted solution]

Hi Arturo,

Thank you for taking the time to investigate my problem. I will post a message in the Marketplace and post any findings here. While we are discussing VFM, do you know if selecting the option "Without Revaluation Accounts" is supposed to run the VFM without the UMB account key. We activate ML with revaluation amounts. The reconciliation between FI and ML is not in balance because of the UMB FI postings. When I select the "Without Revaluation Accounts" option, there are no changes. Still out of balance. If I need to create a New discussion on this, please let me know.

Regards,

Greg

[ArturoSenosain · Accepted solution]

Hi Sir.

I like to spend time analyzing interesting questions!!

About UMB stuff, post another thread, its a good idea separate topics so people can read easy and without confusion.

If you are new in the Marketplace, i recomend you read the basic rules here  http://scn.sap.com/docs/DOC-19331

"Avoid starting a discussion or posting a question as an unrelated comment to a blog or document, but rather post your questions as separate discussions."

Im sure someone here will help you

Arturo.

[Former Member · Accepted solution]

Hell Arturo,

Thank you for your help in the matter. You were correct. There was a program error. The fix is in note 1933881.

Regards,

Greg

[ArturoSenosain · Accepted solution]

Hi Creg. Nice you identify the bug and thanks for share the correction note.

I guess this problem was here for a long time....

Arturo.

[ArturoSenosain]

Hi Creg. Indeed, theres no much info to help you.

Please, could you explain what you mean with "Difference KDM-PNL not posting to ML" .

Questions:

1. In ckm3n, you see the Exchange Rate Dif in the colum ?

2. Do you have 1 or 2 accounts ( 1 for credit and 1 for debit) for Exchange Rate Diff? Could you post here a OBYC screen of KDV and KDM ?

3. In the ML Close, do you see the clearing records in the FI document? Could you post a the ML close document in FI with the transacion ?

Arturo.