Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

One transaction - two currencies - general ledger problem

Posted on by 35

I need to post a general ledger journal. 

R10 000 000 left one G/L Account. ZAR is my default currency.

What landed in the other G/L Account is $590,534.91.

How on earth do I do this?

I tried the journal with 2 lines, without balancing accounts, with the same document number, but it doesn't want to post. 

pastedimage1684240784391v2.png

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    RE: One transaction - two currencies - general ledger problem

    Set Your investment accounts as Bank Accounts, and assign Currency to them (blank for local ZAR currency). Create seperate Bank Account Posting Group with the specific G/L account for each of them.
    Then on the journal lines use Bank Account instead of G/L account.

    I think it was not possible to do in 1 line - Account and Balancing Account to be Bank accounts, so You might need to use a transfer account as Balancing account on both lines.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    RE: One transaction - two currencies - general ledger problem

    Hi, as far as I know, the standard doesn't allow this. You should also set USD in the Currency Code of the Transfer Account line. Let the system automatically calculate the amount based on your exchange rate instead of typing directly.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: One transaction - two currencies - general ledger problem

    check out the currency setting in your BC and take a look at what accounts are used on the respective currency card. try replicate in a sandbox, and see what happens if you choose to balance with a different account. Also checkout if there are field on the journal line which might involves use of a different currency. 

    pastedimage1684262641450v1.png

  • Hilda Steyn Profile Picture
    Hilda Steyn 35 on at
    RE: One transaction - two currencies - general ledger problem

    Not Indian Ruppee - ZAR - South African Rand - Symbol R.

    I have two investment accounts, but the accounts have different currencies. One is in R, one is in $.

    I move Rands from the one, and it lands in $ in the dollar account.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    RE: One transaction - two currencies - general ledger problem

    Try using some dummy 9900 G/L account as Balancing on both lines.

    But I didn't fully get the situation:

    Your default currency is ZAR.

    You have an invoice in Indian Ruppee - 10 000 000

    And You want to pay/or was paid to You in USD ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans