GNOME Bugzilla – Bug 337505
Transactions from invoices are incorrect
Last modified: 2018-06-29 21:01:12 UTC
Please describe the problem: Wrong transactions are performed with invoices Steps to reproduce: 1. Make a new bill, for example from the attached file. 2. Business->Vendor->New Bill 3. Select a Vendor, e.g. ACME 4. Fill in the transaction, eg. Description: Chickens, Expense Account: Aufwendungen:Privat:EDV, Quantity: 10, Unit Price:1000, Tax Table: VAT (The tax "VAT" is 20% with Tax Table Entry Aktiva:Geschäftlich:Vorsteuer. The latter account is of type "Asset") I did also a second line "Hens" - "Aufwendungen:Privat:Kleidung" - 20 - 10000 - VAT 5. Post the bill, choose for "Post to account" "Passiva:Geschäftlich:Verbindlichkeiten", which is already preselected because its the only account of type "A/Payable". 6. Open the account "Passiva:Geschäftlich:Verbindlichkeiten" 7. No numbers are shown in the "Payment" or "Bill" columns! The same is true for the other involved accounts. 8. Business->Vendor->Process Payment 9. In the pop up find the bill 10. "Paid" is checked for the bill which is not true! Actual results: Expected results: The transactions should contain number. The Bill should not be shown as "Paid". Does this happen every time? Yes Other information:
Created attachment 62860 [details] Test file for the bug
This sounds a lot like bug #325890, which was fixed in 1.9.1. I'll take a look. Quick question: Are you using the same currency in all places? This "problem" usually implies that some currency is different....
No, i only use EUR. Maybe another observation is helpful: The above attached file is only for testing. I have also a file with real transactions, and there the problem is slightly different: The "Passiva Geschäftlich:Verbindlichkeiten" and the "Aktiva:Geschäftlich:Vorsteuer" accounts have no number in their "Tot increase" and "Tot Decrease" fields, as described above, but the "Aufwendungen:Privat:EDV" account is correct. To balance the transaction, there appears a transaction line with a mysterious account "Ausgleichskonto-EUR". The transactions of this account are read-only, the account cannot be deleted, only if the transactions are moved to another mysterious account "Ausbuchungskonto-EUR".
Hello, I tested this again with version 1.9.5, r13793. First I set LC_ALL=C and use the business accounts offered from the druid. Everything worked. Optimistically, I set up my real accounts with LC_ALL=de_DE.UTF-8. After some hours of work the error popped up again, just as described in my last comment. Finally I created again with LC_ALL=de_DE.UTF-8 a very simple account hierarchy. This time the error did NOT occure, only an account "Ausbuchungskonto-EUR" appeared suddenly after i populated the tax table with tax "Vorsteuer". I attach this file. Also, in invoices, if i pull down the "Expense account" menu in the transaction line, each possible account appears twice (but its better than last time as reported in bug #337337) Regards, Roman
Created attachment 64697 [details] Gnucash testfile
Hello, the accounts mentioned above "Ausgleichskonto" and "Ausbuchungskonto" are called "Imbalance" and "Orphan" in english, respectively. Regards, Roman
Hello, i just tested again the testfile i attached in comment #2. You have been right, all accounts are in EUR, but the payment currency of of the Vendor "ACME" is set to USD. After correcting it everything worked. Unfortunately in my other file containing real data of mine, there are no USD but the error is still there. I investigate this further. Also in my last attachment where the Orphan account pops up everything is EUR. Regards, Roman
Hello, i did again tests with my real accounts. I carefully checked that everything is in EUR. Accounts Receivable worked correctly. But as soon as i post an invoice for "Accounts Payable", the error takes place. An "Imbalance" Account appears, and the expenses account is not balanced by the "Accounts Payable" and the "Tax" account, but by this "Imbalance" account. I try to prepare a testfile and post it later. Best Regards, Roman
Hello, i have further nailed down the error: Maybe it occurrs only if in the description of an item of the invoice, there is a colon. See the two attachements. The first "testkonto12" is before i create the invoice. Starting from this file, i create a new vendor bill of vendor "ACME" and use colons in the description field, such as "blubb:ADSL - Setup". After posting the bill the "Ausgleichskonto-EUR" (Imbalance) with the transactions appears. This is saved in "testkonto13". It happens both with LC_ALL=C and LC_ALL=de_DE.UTF-8. Best Regards, Roman
Created attachment 65023 [details] "testkonto12" - Gnucash data file from comment #9
Created attachment 65024 [details] "testkonto13" - Gnucash data file from comment #9
Hello, my last comment #9 is wrong, the error occurs also without colons in the descriptions fields. But maybe i have identified the error now: The errors happens iff the amount to pay of an item is fractional, e.g. 10.93. If the amount is e.g.10, everything is ok. This can be tested from the files attached in comments #10 and #11 (the latter shows the result after posting the bill). Best Regards, Roman
Hello, new information about this bug. I tested with 1.9.6, r14070. The bug is exactly the same, no change from 1.9.5. Also the error (should i open a separate bug for this?) that in the first line of a bill entry, each possible entry for the pull-down "Expense account" appears twice remains. But I have found something interesting: The error occurs if the amount to pay of an item is not a multiply of 0.05, e.g. with an amount of 1.04, there is the problem, with 1.05 everything works. Regards, Roman
Hello, i think i know now exactly the conditions for the errors to pop up! It occurs: -For both vendor bills and customer invoices. -Only if the total amount transfered to an account due to tax cannot expressed in full cents. The second condition means: If I have a tax table entry with 20%, and the total amount of the items taxed with this tax table entry is not a multiple of $0.05, the tax cannot expressed in cents, because there are also fraction of cents, i.e. for an item with amount $1.04 the tax is $0.208. Gnucash cannot handle this transaction! Another example: with a tax of 17%, the error appears with amounts of $0.10. The other, small error (double appearence of "Expense account" entries in the pull down menu) occurs only for the first line of a bill, and also for invoices.) I hope the error is now sufficiently localised. Regards, Roman
*** Bug 343722 has been marked as a duplicate of this bug. ***
This explains why it occurs much more frequently for me, as the tax rate in the UK is 17.5%, so the occurrence of fractional pence in the tax amount is much higher. I'll have another look and see if I can see an obvious bug, especially now that Roman has done so much work on localising it, but I'd be grateful if Derek could spare a moment to cast an eye. Fixing this is going to be crucial to using Gnucash once I get VAT registered (in about a week's time).
Yea, the problem was that setting the BaseValue of a Split was trying to never round the number, but we really DO want to round. So this should now be fixed in r14317.
Just for the record, i can report that the problem is solved for me, too. Thanks!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=337505. Please update any external references or bookmarks.