1 Topic by carmelr (edited by carmelr 11/01/2013 12:50:17 pm)

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Topic: Foreign Exchange Gain Appearing for no reason

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Foreign Exchange Gain Appearing for no reason

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

Joe

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Foreign Exchange Gain Appearing for no reason

I am using version 2.3.18
It is the latest version.

Carmelo

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Foreign Exchange Gain Appearing for no reason

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

5 Reply by carmelr (edited by carmelr 11/02/2013 04:04:17 pm)

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Foreign Exchange Gain Appearing for no reason

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

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Foreign Exchange Gain Appearing for no reason

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Foreign Exchange Gain Appearing for no reason

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Foreign Exchange Gain Appearing for no reason

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

9 Reply by apmuthu (edited by apmuthu 11/04/2013 02:50:04 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Foreign Exchange Gain Appearing for no reason

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.

apmuthu's Website

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 550

Re: Foreign Exchange Gain Appearing for no reason

Hi,

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

Maybe the bug is reintroduced again?

rafat's Website

  • From: Tanzania, Arusha
  • Registered: 04/27/2012
  • Posts: 34

Re: Foreign Exchange Gain Appearing for no reason

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

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Foreign Exchange Gain Appearing for no reason

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.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website