FrontAccounting forum — Foreign Exchange Gain Appearing for no reason

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (kvvaradha) — Mon, 06 Jun 2022 00:17:46 +0000

There should be some calculation level decimal value comes during the time of tax applied with it. So it can be either positive or negative balance comes like that. This balance we used foreign exchange gain or loss account to compensate the GL balance.

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (lawmaina78) — Sun, 05 Jun 2022 23:32:12 +0000

Same issue here
Using FA 2.4.11
Am seeing a debit entry into Foreign Exchange Gain of amount 0.01
Yet I've made sure same currency is set right on
- Supplier
- Client
- Item pricing
- Bank

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (rafat) — Sat, 05 Sep 2020 11:00:09 +0000

Hi,

I am facing the exact same problem at both 2.4.4 and 2.4.8.

Maybe the bug is reintroduced again?

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (apmuthu) — Mon, 04 Nov 2013 02:34:09 +0000

Does not yet show up in the official Git Repo. Present in Mercurial though. Get the Mercurial Snapshot of the stable branch here. The unstable branch snapshot is here but it's changelog is stuck at May 2013 though more recent changes have been merged into it. We would need more testing on the unstable branch and it would be nice if mirrored on the official Git site.

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (joe) — Sun, 03 Nov 2013 22:23:14 +0000

This has now been fixed and the stable repository is updated. The change will be included in next minor release that are shipped next week.

/Joe

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (joe) — Sat, 02 Nov 2013 12:37:03 +0000

You have run into a bug. When multiple lines with the same tax type is entered, only the first one is added. The others are accumulated into the Exchange account.

I will ask Janusz, that wrote this routine, to have a look at it.

/Joe

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (carmelr) — Sat, 02 Nov 2013 09:47:02 +0000

Here is an update.
So I started a totally new test company using the en_GB-general COA.
I got the same results. Here are the screen shots:

Purchase Invoice Entry
https://dl.dropboxusercontent.com/u/298 … emo-UK.png

Ledger Result:
https://dl.dropboxusercontent.com/u/298 … emo-UK.png

Regards
Carmelo

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (carmelr) — Sat, 02 Nov 2013 09:06:56 +0000

Thanks Joe for your reply.
I did the following steps to try and locate the problem:

1. I used your Training Co. Demo site and entered the transactions there. Correct Result.
2. I installed a new instance of FA in another folder and copied my COA and config files.
3. Tried the same entries and the error appreared again.

I am using GL Accounts in the Supplier Invoice.

Here is a screenshot of the entry on the Training Co.
https://dl.dropboxusercontent.com/u/298 … nvoice.png

This is the result of the General Ledger on my system (note the entries arethe same only the GL Accounts are different in order to accomodate my COA:
https://dl.dropboxusercontent.com/u/298 … ger-my.png

This screenshot is for the System and General GL Settings:
https://dl.dropboxusercontent.com/u/298 … ttings.png

I hope the above information is enough to help pinpoint the problem.

I can also provide a backup of my test account.

Thanks, Carmelo

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (joe) — Sat, 02 Nov 2013 07:35:45 +0000

I cannot tell from this what the problem is.Is the supplier invoice in foreign currency? Did you use the GL items in the Supplier Invoice vor doing this?
Please be a Little more specific about what you did.

/Joe

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (carmelr) — Fri, 01 Nov 2013 22:49:18 +0000

I am using version 2.3.18
It is the latest version.

Carmelo

Re: Foreign Exchange Gain Appearing for no reason

null@example.com (joe) — Fri, 01 Nov 2013 17:30:03 +0000

Which version of FA are you using? Please upgrade to the latest version, 2.3.18.

Joe

Foreign Exchange Gain Appearing for no reason

null@example.com (carmelr) — Fri, 01 Nov 2013 12:49:31 +0000

Hi,
I created a Supplier Invoice with 8 items in it. Each item has a VAT value entered in a seprate entry.
When I see the General Ledger Transaction Details for this Supplier Invoice, I notice an entry refering to Foreign Exchange Gain.
I checked all settings I could think of and everything seems normal.
Can anyone think of what I am doing wrong? Or is it a bug?
Here is the General Ledger Transaction Details as observed after the entry:

General Ledger Transaction Details     Reference     Date     Person/Item
Supplier Invoice #2     2     01/11/2013     Supplier Amazing.com

Account Code     Account Name     Dimension          Debit     Credit     Memo
2100     Creditors Control Account                         471.40     admin
0030     Office Equipment                             82.86              admin
2218     VAT - 18% Taxable Goods/Services           14.91              admin
0030     Office Equipment                       47.80              admin
2218     VAT - 18% Taxable Goods/Services           8.60              admin
0030     Office Equipment                        47.82              admin
2218     VAT - 18% Taxable Goods/Services           8.60              admin
7501     Office Stationery                        94.43              admin
2218     VAT - 18% Taxable Goods/Services           16.99              admin
7501     Office Stationery                        16.64              admin
2218     VAT - 18% Taxable Goods/Services           2.99              admin
0030     Office Equipment                        119.95              admin
2218     VAT - 18% Taxable Goods/Services           21.58              admin
7501     Office Stationery                        5.61              admin
2218     VAT - 18% Taxable Goods/Services           1.01              admin
0030     Office Equipment                        41.38              admin
2218     VAT - 18% Taxable Goods/Services           7.45              admin
4920     Foreign Exchange Gain                                    67.22     admin  <----------------------
Total                                            538.62      538.62

Any help about this would be appreciated.
Cheers, Carmelo