cancel
Showing results for 
Search instead for 
Did you mean: 

Accounting substitution during MIRO

Former Member
0 Kudos

Hello Experts,

I need to define substitution during MIRO

Process is :

When material is received from foreign vendor, exchange rate used is as on the date of mat receipt. But the requirement is to valuate the inventory

with exchange rate prevailing on invoice date (ex rate declaration date)

Currently, system takes difference between invoice date's ex rate and mat receipt date's ex rate to exchange gain/loss.

During MIRO such exchange gain/ loss is posted to, say, account 611400 account

I need to define substitution rule wherein system posts such gain/loss to different GL account,say, 520430. So that exchange gain/loss on only such transaction is readily available for reporting requirement.

How such substitution rule can be defined.

Thanks in advance.

Regards      

Accepted Solutions (1)

Accepted Solutions (1)

former_member183424
Active Contributor
0 Kudos

If both transaction hits same transaction key, then you can't substitution the amount into two different G/L account. If you change the G/L account to 520430, then all gain and loss amounts will goes to this new G/L account.

I hope you need a badi or user exit to achieve this. You can hit G/L 520430 for your this type of transaction and rest of all transaction will be hit on G/L 611400.

Former Member
0 Kudos

Hi Dev,

Could you please describe more on Badi / user exit?

And is there any standard Badi / user exit available?

Regards

Anand

former_member183424
Active Contributor
0 Kudos

Badi or User exit is just a coding. By using this you can write your own logic and you can achieve some functionality which can't happens in standard SAP.

A better way to find exit or badi, you can look into the document

You have to consult with your ABAP consultant for more details about using badi or exit.

Former Member
0 Kudos

Thank you Dev. I will go through the link.

Btw, precisely, during MIRO ex gain/loss is posted to accounts 611400(gain) and 611400 (loss) speciafied in OBA1. These 2 accounts need to be substituted with account 520430 for gain and loss.

Regards

Anand

former_member183424
Active Contributor
0 Kudos

I can see this is 1 G/L account 611400.

Same G/L account can be used in debit side and credit side.

Former Member
0 Kudos


Sorry typo....

GL accounts 611400(gain) and 611401 (loss)  in OBA1 with same exchange rate difference key(which is blank) need to be substituted with GL 520430 (for both gains and loss) only for MIROs for imported materials

Regards

Anand

former_member183424
Active Contributor
0 Kudos

Yes. As I have said you can use same G/L account for both gain and loss side.

Former Member
0 Kudos


Hi

I defined substitution and it is working well

Regards

Anand

Former Member
0 Kudos

Thank you for your suggestions

Regards

Anand

former_member183424
Active Contributor
0 Kudos

GreatJ..

Now you can close your discussion.

See The SCN Rules of Engagement | SCN

Option 8.

Answers (2)

Answers (2)

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

Please, see these notes

SAP Note 116250 - MR08/MR8M:Cancellation+exchange rate diffrnces(KDM)

SAP Note 165635 - Documentation: Enhancement LMR1M001 (MM-IV)

SAP Note 1156325 - BAdIs in the Logistics Invoice Verification environment

I hope this helps you

Regards

Eduardo

Former Member
0 Kudos

Hi,

yes you can create the new GL account it comes under the P&L and while posting the invoice in the MIRO ,please create the new GL account and assign to FI OB40

system will generate the entries are

vendor account DR

            GR/IR account CR

Exchange rate TAX account DR