Lots of bugs in split transactions with multiple currencies
Using the attached test MD file:
Splitting a transaction that has an amount in the payment box
moves that amount to the deposit field.
1) New Transaction in a USD account (defaults to Miscellaneous
expense)
2) Fill in details including payment amount
3) Split the transaction
4) The amount moves from the payment box to the deposit box in the
first line of the split transaction (shouldn't change)
Splitting a transaction forgets the initial payee
1) New Transaction in USD account
2) Change category to another USD account and fill in payment
account
3) Split the transaction
4) The category changes to Miscellaneous (shouldn't change)
Can't split a transaction successfully between USD and GBP
accounts
1) Create a new transaction with USD Credit Card account as a
category
2) Split the transaction
3) Create a new split with Miscellaneous GBP expense as the
category
4) Exchange rate is not automatically filled in and I can't
manually add one.
I have found a number of other instances where either the payment or the deposit cells in a split transaction become 'locked' and I can no longer freely enter data. The main issue though is the exchange rate problems in split transactions making it impossible for me to use MD successfully. I wish I hadn't upgraded to the 2011 preview...
- test.md 48.2 KB
Comments are currently closed for this discussion. You can start a new one.
2 Posted by music on 13 Jun, 2011 11:55 AM
+1
I am also experiencing issues with split transactions and multiple currencies. I have locked RATE and Foreign Amount cells (which are also blank), and there doesn't seem to be any currency translation happening.
So, in the split, currency is NZD ( x $NZD ), but when I go to the Category (other half of the transaction) which is in CDN, there is no translation. The amount is the same, x $CDN and not x*conversion $CDN.
3 Posted by music on 13 Jun, 2011 10:26 PM
Some more details on what I do to reproduce my issue,
It appears that MD can get stuck in a mode where the exchange rate is always 1, even for new transactions that aren't splits. Quitting and restarting seems to fix the issue, at least temporarily.
To get it to misbehave again, I can do a few things:
Start a new transaction and open a split before saving it. Exchange rate = 1 even though account and category are in different currencies. All further transactions, split or no split, have exchange rate of 1 that cannot be changed. Must restart MD to fix.
Create a transaction that has a category that is the same currency as the account. Then add a split to this transaction that has a category in a different currency. Exchange rate = 1, cannot edit it. BUT, unlike 1. above, exchange rate still working for new transactions.
I can work around 2. by first creating the transaction where the account/category currencies differ, and then adding the split where the account/category are the same.
4 Posted by AndrewN on 14 Jun, 2011 05:55 PM
Yup that is the work around I have been using. First create the transaction with the foreign transaction and then split it.
I am finding when I import transactions I have to delete and re-create many of them to get the exchange rates to work correctly.
Hoping for a fix soon.
5 Posted by Richard on 06 Jul, 2011 07:07 PM
I am having similar issues in build 791 (which according to the updater is the latest version). Is there an update on resolutions for this issue, please?
Support Staff 6 Posted by Jon Hoover on 09 Jul, 2011 05:42 PM
Hi Richard,
Getting the splits issues fixed is a super-high priority but I don't have the dates they will be resolved. Sorry for the inconvenience.
Sincerely,
Jon Hoover, Moneydance Support
7 Posted by Zash on 31 Jul, 2011 08:43 AM
I'm experiencing the same issues; namely that when you split a transaction that is different from the base currency, the split doesn't add the correct currency amount and always returns this to 1, even if you force it.
The only way is remove the split and do two transactions.
T.
8 Posted by Albert Ho on 28 Oct, 2011 02:09 AM
Using Moneydance 2011r2 (803) on Windows Vista with Java 1.6.0_29.
Also experiencing many issues with split transactions in foreign currency. One is that the amount is not converted to the base currency for the expenses chart on the home page. For example, a split transaction for 5000 HKD is shown as 5000 GBP in the expenses chart (should be about 400 GBP at current rates.) This makes the expenses chart almost meaningless for seeing your largest expenses.
Support Staff 9 Posted by Ben Spencer on 28 Oct, 2011 09:21 PM
Hi Albert
I suspect that you have the rate on each split transaction set to 1 such that the other amount is 5000 GBP.
Other than this one issue you mention are there others as well? I believe the issues brought up earlier in this thread have all been fixed in build 803.
Ben Spencer
Moneydance Support
10 Posted by Albert Ho on 29 Oct, 2011 04:57 AM
Hi Ben,
You are right. I realised that this was the case about 5 minutes after I
sent the email. I don't see any other issues with splits at the moment, they
may have all been related to the fx-rate not being set properly.
Thank you for the quick response.
Regards,
Albert
11 Posted by birchalls1 on 29 Oct, 2011 02:07 PM
Updated toVersion2001r2(803) and now unable to operate split transactions in any account or on Reminder transactions. I only operate in GB pounds so I don't understand what the problem is! I have downloaded Moneydance with Java and am running Windows 7 on HP computer. How can I go back to Previous Version which was working well for me.
Alan B
Support Staff 12 Posted by Ben Spencer on 29 Oct, 2011 02:11 PM
Alan
I am not able to reproduce the problem you are describing. Can you be more specific?
Are you able to bring up the split window when creating a transaction reminder?
Ben Spencer
13 Posted by birchalls1 on 29 Oct, 2011 06:14 PM
Thank you for your email, I appear to have solved my problem. It appears
that it was caused because the split box was not large enough. I noticed
that there were a number of references to this problem in the comments on
your website so I tried to enlarge it by dragging the border and found that
I can now work the system for both transactions and Reminder Transactions
with Splits.
Thank you for your prompt reply. Although I don't think I would have solved
the problem if I hadn't seen the chat amongst equally frustrated users. I
spent a couple of very frustrating days believing that I had done some thing
wrong.
Regards
Alan Birchall
14 Posted by Zash on 28 Apr, 2012 12:55 PM
Hey guys, just to let you know this issue is stil present. Even if you force the correct split to avoid the 1 for the second split, whatever you put in gets ignored and resets to 1.
Specific issue for me is GBP/CZK
This messes up all my balances and graphs :(
Thanks,
T
Support Staff 15 Posted by Ben Spencer on 28 Apr, 2012 01:19 PM
Hi Zash
I have still not been able to reproduce the problem you are describing.
See the attached screenshot. I entered a split transaction in a USD account and transferred 100 USD to a GBP account and 100 USD to a EUR account. The exchange rates worked correctly. I closed the transactions and reopened it and it was still correct.
Can you tell me the exact procedure you are taking in order to reproduce the problem.
Ben Spencer
16 Posted by Zash on 30 Apr, 2012 07:59 AM
Hi Ben,
I tried this and it still by default puts in the 1 for the exchange rate. I tried this with a new file and it does the same.
Although, I managed to manually fix the exchange rate, and for once it stayed fixed. I wonder if this is anything to do with me having added the currency manually as CZK isn't supported by default?
I know for fact that when I manually fix it in my real accounts, the rate next stays fixed.
T.
Support Staff 17 Posted by Ben Spencer on 05 May, 2012 04:16 PM
Can you show me a screenshot of the Currency History window for CZK on you system. Select Tools->Concurrences... Select the currency of interest and click edit.
18 Posted by Zash on 06 May, 2012 09:42 AM
Voila
Support Staff 19 Posted by Ben Spencer on 12 May, 2012 01:02 PM
I have still not been able to reproduce this problem. Would you be willing to create an example data file and attach it to this discussion.
20 Posted by Zash on 14 May, 2012 10:22 PM
Hi Ben,
Actually I think this is resolved - What I did was re-create the split and it seems that this was saved correctly. Basically, I think there's some weirdness from the first time this was created then fixed and somewhere along the lines the data gets lost or saved weirdly. So re-doing it sorts it out.
T.
Ben Spencer closed this discussion on 14 May, 2012 11:26 PM.