Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Differences between the Default currency and the foreign currency in trial balance

Posted on by 137

Dears' experts 

When i print out the trail balance for the last year i found a closing balance in the closing balance filed for the bank accounts.  and when i select the desired recorded and press on all transaction for the more details i found the total of the foreign currency is zero but field of amount in reporting currency has a value.

how can i deal with this amount as the total amount or the sum of the amount by the foreign currency is zero but with the reporting currency has a value.

i need the amount of the reporting currency became zero as the foreign currency, what is the procedure that i can do without effecting the foreign currency 

regards and thanks for your support

600145.png

  • Suggested answer
    CU26112018-0 Profile Picture
    CU26112018-0 20 on at
    Differences between the Default currency and the foreign currency in trial balance
    We have a number of foreign companies where the local currency is foreign and the additional currency is USD. We have not been able to figure out how to adjust the exchange rate for the balance sheet items at year-end. This causes problems when we close a company because there is no balance remaining in the foreign currency, but there are still USD amounts due to the different exchange rates used over time.  Do you know how we can adjust the USD amount on balance sheet items in these foreign companies so that they equal zero when the foreign currency amount is zero?  Currently using Navision VS13
  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    i have edited the main post to add a screenshot for the general journal entry

  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    i have tracked some of the General journal transaction and the account types are (bank and ledger) as a transfer form SAR to GBP. so, it's a transfer form default currency to the foreign currency

  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    sorry, i didn't get your point.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,784 Most Valuable Professional on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    Does the transactions posted from general journal has vendor module relation?

  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    -- In those transactions are there any values that transaction currency is zero but has reporting currency?

    - No, all rows have values.

    -- are those been posted from revaluation or reporting currency journal.

    - all transactions are (vendor payments, General journals, and invoice journal)

    -- Also this may be cause while revaluations are done both in the AP/AR modules and GL at the same time.

    - i ran the revaluation process. once in AP

  • Verified answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,784 Most Valuable Professional on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    Yes, In those transactions are there any values that transaction currency is zero but has reporting currency? and are those been posted from revaluation or reporting currency journal. I

    Also this may be cause while revaluations are done both in the AP/AR modules and GL at the same time

  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    when I press on all transaction option for the desired record and export the displayed data to excel, i found all transaction with the foreign currency.

    I could sum the total of the transaction in the Amount in transaction currency, and it's ZERO, however the total of Amount in reporting currency is a huge number

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,784 Most Valuable Professional on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    May someone has posted transactions from reporting currency journal?

  • Karim Elshafie Profile Picture
    Karim Elshafie 137 on at
    RE: Differences between the Default currency and the foreign currency in trial balance

    Hi,

    yes i ran the process of foreign currency revaluation, but it didn't affect the Values

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans