Unusual behavior in transactions involving foreign currencies [MW 1.5.1 (486)]

tosz25's Avatar

tosz25

11 Mar, 2010 06:19 PM via web

Kevin/Ash,

I came across what looks like a significant bug in transactions involving foreign currencies:

MW release: 1.5.1 (486)
System currency: Euro
Transaction currency: USD
Exchange rate (for testing purposes): 1 Euro = 2 USD

Description: While creating a split transaction (withdrawal or deposit) in a foreign currency, amounts assigned directly to expense buckets are not converted to the home currency, causing a major discrepancy in bucket balances.

Steps to recreate:
1. Create a deposit transaction in the Foreign Currency Checking Account (for instance, 800 USD)
2. Click on 'Split'
3. Create the first child transaction in the amount of 600 USD and assign it to a bucket (for instance, "Automobile")
4. Create the second child transaction in the amount of 200 USD and assign it to a bucket (for instance "Charity")
5. Click "Save"

Expected results:
1. The balance of the Foreign Currency Checking Account increases by 800 USD
2. The balance of the Automobile bucket increases by 300 Euro (600/2=300)
3. The balance of the Charity bucket increases by 100 Euro (200/2=100)
4. The Bucket Summary Difference = 0 Euro

Actual results (See the attached screenshot):
1. The balance of the Foreign Currency Checking Account increases by 800 USD (correct)
2. The balance of the Automobile bucket increases by 600 Euro (incorrect - should be 300)
3. The balance of the Charity bucket increases by 200 Euro (incorrect - should be 100)
4. The Bucket Summary Difference = -400 Euro (incorrect - should be 0)***

Restarting MW does not correct the bucket balances.

-***A second, less significant bug appears on the Bucket Summary Difference screen - the currency sign by "Foreign currency checking" is incorrect (is € - should be $).-

Bart

  1. Support Staff 2 Posted by Kevin Hoctor on 11 Mar, 2010 10:39 PM

    Kevin Hoctor's Avatar

    Bart: I'll work on this bug for the upcoming patch but the Bucket Summary view is supposed to use your base currency since it is subtracting buckets total from accounts total. If I showed the account currency, the math would look wrong.

    Thanks for reporting this issue.

  2. 3 Posted by tosz25 on 11 Mar, 2010 11:30 PM

    tosz25's Avatar

    Kevin,

    You're right, I got confused on the Bucket Summary issue.

    Thanks!

    Bart

  3. Ash resolved this discussion on 12 Mar, 2010 03:42 AM.

  4. tosz25 re-opened this discussion on 12 Mar, 2010 05:26 AM

  5. 4 Posted by tosz25 on 12 Mar, 2010 05:26 AM

    tosz25's Avatar

    One more thing -- the same problem occurs with deposits assigned to income buckets (my original post only mentions the expense ones but it's a universal issue for all buckets)

  6. Support Staff 5 Posted by Ash on 15 Mar, 2010 11:25 PM

    Ash's Avatar

    Hopefully we'll get this bug fixed up soon.

    ~ash

  7. Ash resolved this discussion on 15 Mar, 2010 11:25 PM.

  8. tosz25 re-opened this discussion on 17 Mar, 2010 01:23 PM

  9. 6 Posted by tosz25 on 17 Mar, 2010 01:23 PM

    tosz25's Avatar

    Kevin & Ash,

    Just wanted to confirm that this issue has been resolved in the latest build of 1.5.2 RC (497). Thank you for your excellent work!

  10. Support Staff 7 Posted by Kevin Hoctor on 17 Mar, 2010 01:30 PM

    Kevin Hoctor's Avatar

    Excellent. Thank you for the confirmation!

  11. Kevin Hoctor resolved this discussion on 17 Mar, 2010 01:30 PM.

Comments are currently closed for this discussion. You can start a new one.