Skip to Content
author's profile photo Former Member
Former Member

Incorrect Account determination while partial billing in FC terms

Hello SAP Gurus,

Please give your valueable inputs for the following scenario:

We have sceanrio where there are two types of differences while doing partail billing (MIRO)

1. Difference between the GR amount and IR amount in FC terms AND

2. Foreign Exchange Gain/Loss difference

For eg. MIGO was done for a PO for 1 quantity @ USD 100 with prevelling exchange rate Rs. 50/USD with following entry:

Material Exp Account (10000)..............Dr. 100 USD (Rs. 5000)

To GR/IR Account (20000) 100 USD (Rs. 5000)

However, Partial invoicing was done for 0.5 quantity with USD 60 (i.e more than proportainate GR amount) and accordingly system posted following entry:

(Exchange Rate on the date of invoicing is, lets say, Rs. 52/USD)

GR/IR Account (20000)..................Dr. 50 USD (Rs. 2500)

GR/IR Diff Account (10010).............Dr. 10 USD (Rs. 620)*

Foreign Exch Diff Account (10020)..Dr. -----------------

To Vendor Account(1111) 60 USD (Rs. 3120)

*3120-2500 (taking this figure as balancing figure)

The above treatment of foreign exchange is not correct as per business process and GAAP as IR amount is more than the proportainate GR amount along with foreign exchange difference. Accordingly system should post the following entry with following break-up of amounts:

GR/IR Account (20000)........................Dr. 50 USD (Rs. 2500)

GR/IR diff Account (10010)...................Dr. 10 USD (Rs. 500)

Foreign Exch Diff Account (10020)........Dr. 0 USD (Rs. 120)

To Vendor Account(1111) 60 USD (3120)

The above treatment is correct due the fact that it should post the GR/IR difference amount at the old rate and foreign exchange difference amount seperately. However, as per SAP standard logic, system directly posts the balancing figure in the GR/IR difference account.

We want to have such configuration/settings such that second entry is automatically posted by the system in this type of scenarios. Request you to check the above scenario in your respective system and please let me know if anything we can do in customization / ABAP development to have correct postings.

Thanks,

Abhijeet Tare

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 18, 2015 at 11:19 AM

    Hi,

    Please check the path at spro--MM-LIV-Incoming invoice --- Configure how exchange rate differences to be treated .

    However exchange rates can be fixed and will not be fixed at po stage . Please try a PO by fixing the exchange rate fixed in the PO .

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 12:12 PM

    Without using 'Exchange rate fixed' indicator in PO, you will not get the same exchange rate at GR. You have to use enhancement in GR which will validate the exchange rate maintained in PO with the exchange rate maintained in OB08.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.