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

New GL - Parallel ledger in different currency - How to post FX differences?

Hi all,

other than Transaction and Company Code currency, we have a requirement to update every transaction in a third currency which depends from another master data (Fund) with the objective to produce full financial statements (PL and BS).

In order to do this, we have configured a parallel ledger and, by means of field movement exits implemented in report ZFI_U_GIFU (from Special Ledger IMG), we update this ledger by converting the transaction currency amount into the fund currency amount.

This mostly works very well but it creates problems when there are FX differences in fund currency.

Example:

Company Code currency is EUR

Fund Currency is USD

We need to process a vendor invoice and payment in GBP.

Vendor Invoice

Dr Expense 100 GBP

Cr Vendor -100 GBP

Let's assume the FX rate at invoice posting is:

GBP/EUR = 1/1.50

GBP/USD = 1/1.875

The above invoice updates the leading ledger as follows:

GL Account / TC Amount / TC Curr / CC Amount

Expense / 100.00 / GBP / 150.00

Vendor / -100.00 / GBP / -150.00

And the Fund Currency ledger as follows:

GL Account / TC Amount / TC Curr / CC Amount

Expense / 187.50 / USD / 150.00

Vendor / -187.50 / USD / -150.00

Then I process the payment (always in GBP)

Outgoing Payment

Dr Vendor 100 GBP

Cr Bank -100 GBP

Let's assume the FX rate at payment posting is now changed:

GBP/EUR = 1/1.5

GBP/USD = 1/1.2

The above payment updates the leading ledger as follows:

GL Account / TC Amount / TC Curr / CC Amount

Vendor / 100.00 / GBP / 150.00

Bank / -100.00 / GBP / -150.00

And the Fund Currency ledger as follows:

GL Account / TC Amount / TC Curr / CC Amount

Vendor / 120.00 / USD / 150.00

Bank / -120.00 / USD / -150.00

If you look at the vendor recon. account balance, this is the situation by currency:

TC currency = 0

CC currency = 0

Fund currency = -67.50

The field movement user exit only allows playing with values of each individual field (as part of the field movement from the sender to the receiver table) but does not allow creating additional lines.

What we would ideally need is to create an additional line to record an FX Gain/Loss (Gain, in the example above), to store the difference. The desired entry in the fund currency ledger would therefore be:

GL Account / TC Amount / TC Curr / CC Amount

Vendor / 187.50 / USD / 150.00

FX Gain / -67.50 / USD / 0.00

Bank / -120.00 / USD / -150.00

The logic should be the same as the one the standard SAP applies to record FX differences in Company Code currency.

Is there any user exit you would recommend where we can add this additional (ledger specific) line?

Thanks.

Ciao!

Max

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2015 at 05:22 PM

    Hi all,

    nobody knows if it is possible to generate additional lines for FX difference only on selected ledgers?

    Thanks.

    Ciao!

    Max

    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.