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

(0) Share

Report

Posted on by Karim Elshafie

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

All responses (11)

Answers (1)

Suggested answer

CU26112018-0 20 on at

Like (0)

Report

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 137 on at

Like (0)

Report

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 137 on at

Like (0)

Report

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 137 on at

Like (0)

Report

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

sorry, i didn't get your point.
Suggested answer

BillurSamdancioglu 15,786 Most Valuable Professional on at

Like (0)

Report

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 137 on at

Like (0)

Report

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 15,786 Most Valuable Professional on at

Like (0)

Report

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 137 on at

Like (0)

Report

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 15,786 Most Valuable Professional on at

Like (0)

Report

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

May someone has posted transactions from reporting currency journal?
Karim Elshafie 137 on at

Like (0)

Report

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