Change of transaction key while posting MIRO

[prabhakar_vemuri]

Dear All

We have a scenario wherein at the time of MIRO if there are any backdated postings (different periods or months) and if there is some value change (GR value and IR value is different), system is picking Gain/Loss account (trasaction key "UMB"). Now,requirement is to trigger "DIF" transaction key instead of "UMB".

I want to know from where this can be maintained. I think OMJJ is for maintaining movement type wise transaction keys. Please help me in getting this maintained. Your inputs will be much appreciated.

[BijayKumarBarik · Accepted solution]

Hi,

Your system designed to triggers Gain/Loss account with KDM-ERA and KDM-ERN in OBYC t.code.

But why you want a change  the setting......Is your business aware of it!

If needed by you and your business, just remove the entry KDM-ERA and KDM-ERN ( but advisable) and only assign G/L account to your favorable key in OBYC t.code.

Also cross check in t.code:OMR4 for t.code:MRNB where it relates to MIRO document type and check UMB key assignment in in OBYC t.code.

Regards,

Biju K

[prabhakar_vemuri · Accepted solution]

This message was moderated.

[prabhakar_vemuri · Accepted solution]

Hello Sir

Thanks for the reply.

We are getting gain/loss from "UMB" transaction key and in the given case there are no exchange rate differences. This case is observed when GR is made with posting date March with 100 value and IR is made in April with some posting date of March with 110 value.Also provided there is no enough stock coverage.

Business wants this price difference to be loaded on to "DIF" key as all the differences will be posted to the G/L account assigned to this posting key.

"UMB" key is assigned with 410001.

"DEF" key is assigned with 410004. (This account business considers as purchase price variance)

Now in the above cases they want the G/L 410004 to be hit.

Can you please suggest the step by step process to change this.

I have checked the Tcodes OMR4 and MRNB but MRNB is giving error like "Assign a document type to transaction MRNB" and could not relate with current issue.

[BijayKumarBarik · Accepted solution]

Hi,

If you and business want to triggers "UMB" transaction key or “DIF" transaction key and follow the options , chose best option which suit to you and your business.

Option-1: Do goods receipt (GR) in March with 100 value and do invoice receipt (IR) in March with 110 value. Check accounting entries in both GR and IR.

Option-2: Do goods receipt (GR) in March with 100 value and do invoice receipt (IR) in April with 110 value. Check accounting entries in both GR and IR.

NOTE: Material valuated at plant level and cross check price control in material master with the material price in material master (MM03) in month of March and April. Cross check tolerance limit for tolerance key BD company code with t.code: OMR6

Regards,

Biju K

[prabhakar_vemuri · Accepted solution]

Hello Sir

As suggested, i tested both the options:

O

ption1: Previous Month Posting

Accounting Entries:

Two Accounting Docs created one for the current period other for the previous period.

Accounting Doc:0090000021

Accounting Doc:0090000022

In option 1 Gain/Loss is hitting.

Option2: (No backdated postings)

Accounting Entries:

In option 2 PPV Account i.e., DIF posting key will hit.

Our requirement is to hit DIF posting key in both the cases. Kindly suggest the way forward. Thanks for your help.

[prabhakar_vemuri · Accepted solution]

Hello Sir

I have provided the accounting entries in both the options. Now we have to configure the system in such a way that in both the cases, system should pick DIF transaction key. where as now system is picking Gain/Loss account in option1 and Purchase price Variance (DIF transaction key) in option2.

Kindly suggest the way forward. Thank you.

[prabhakar_vemuri · Accepted solution]

Hello All

Please anybody suggest how to do the required changes,

[BijayKumarBarik · Accepted solution]

Hi,

Refer SAP Note 518485 with Question No-8 with an answer.

Regards,

Biju K

[prabhakar_vemuri · Accepted solution]

hello Sir

Thank you so much for the valuable information.

Still if the business wants to have only one transaction key (DIF) instead of the two transaction keys (DIF and UMB) which are hitting two different accounts.Is there any possible option (through exits,BADI) to do so and whether it is suggestible. Kindly suggest.

[Former Member]

DIF & UMB are two different keys for different purpose.

DIF key works when there is difference in amount at header & summition of item level amount.

UMB key works when there is difference in the amount paid to vendor & actual accured at the time of GR &  note in this case amount at header is equal to  summition of item level amount.

Regards,

Sanjay Kohli

[Former Member]

Hi,

OMJJ settings is used for Good movements postings with mov.types and not for MIRO postings.

As per std. SAP, the transaction key DIF is triggered only in case of small differences during MIRO where as UMB is tiggered for Gain/loss from revaluation (i..e. incase of value difference between GR and IR.

Thanks n Regards,