Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]
It is working fine here on MacOS and Linux Mint. Can you replicate it with a fresh test book using all default settings? Regards, Adrien On 11/30/23 10:25 PM, Michael Campbell via gnucash-user wrote: Fixed. Eventually. I unchecked the "Numbers, Date, Time" -> "Automatic decimal point" check box in settings where it was set to 2 decimal places and now amounts will be calculated correctly. Is anyone else able to replicate this bug? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
Is there any way to get a report showing amounts 'as entered'. That is, are all foreign transactions converted by those rules in aggregate, or is there a method for getting the actual converted amounts tallied? (for example, the exchange rate might vary enough from the beginning of the report period vs. the end resulting in always having an incorrect report.) Would employing trading accounts facilitate this with the currency splits existing in the transaction instead of the report having to estimate by one of those rules? Regards, Adrien On 11/30/23 8:10 PM, john wrote: On Nov 30, 2023, at 16:40, Derek Atkins wrote: Even more, the REPORTS only use #2, not #1, to figure out the "value" of an account in another currency. Not exactly. Most reports have a Price Source option that allows you to select how commodity prices and currency exchange rates are retrieved. Last up through report date, closest to report date, and Most recent use the indicated date filter to select a price from the pricedb. The other two, Average cost of purchases weighted by volume and Weighted average of all transactions in the past calculate the price from the splits in all transactions in all accounts. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]
Fixed. Eventually. I unchecked the "Numbers, Date, Time" -> "Automatic decimal point" check box in settings where it was set to 2 decimal places and now amounts will be calculated correctly. Is anyone else able to replicate this bug? Regards, Michael Campbell On 12/1/23 09:27, Adrien Monteleone wrote: > That sounds like a 'smallest commodity fraction' issue off the top of > my head. > > Check your settings for your affected currency. > > Another place to check is the setting for automatic decimal points. > > Regards, > Adrien > > On 11/30/23 4:20 PM, Michael Campbell via gnucash-user wrote: >> Hello All, >> >> Long time lurker here, first time poster. I have been learning to use >> GNU Cash for my personal finances and now business for the past 10 >> years. I am still learning. >> >> When entering Goods and Services Tax for an entry, I used to just be >> able to divide the total cost by eleven in the ledger and it would >> calculate the proper amount. i.e., $72.25/11 would enter $6.57 into the >> ledger. >> >> I am not sure if there has been an update or somehow I have changed a >> setting but now when I perform the calculation in the entry field I get: >> $72.25/11 enters $656.82 - clearly not correct. It is out by a factor of >> 100 which should be a clue. >> >> Is this a bug in GNU Cash in a recent update or have I somehow screwed >> up a setting some where - and if so where would I start to look? >> >> System Information: >> >> GNU Cash Version: 5.4 >> Build ID: 5.3-412-g53245caebf+(2023-09-23) >> >> uname -a >> Linux nuc 6.6.2-zen1-1-zen #1 ZEN SMP PREEMPT_DYNAMIC Mon, 20 Nov 2023 >> 23:17:26 + x86_64 GNU/Linux >> >> neofetch >> -` mick@nuc >> .o+` >> `ooo/ OS: Arch Linux x86_64 >> `+: Host: NUC12WSKi7 M42762-305 >> `+oo: Kernel: 6.6.2-zen1-1-zen >> -+oo+: Uptime: 45 mins >> `/:-:+++: Packages: 1456 (pacman) >> `//+++: Shell: zsh 5.9 >> `/++: Resolution: 2560x1440 >> `/+++o/` WM: sway >> ./oooo++osso+` Theme: Adwaita [GTK2/3] >> .ooso-/oss+` Icons: Adwaita [GTK2/3] >> -osso. :ssso. Terminal: tmux >> :osss/ oo+++. CPU: 12th Gen Intel i7-1260P >> (16) @ 4.700GHz >> /o/ +ooo/- GPU: Intel Alder Lake-P GT2 >> [Iris Xe Graphics] >> `/oso+/:- -:/+oo+- Memory: 4386MiB / 31673MiB >> `+sso+:-` `.-/+oso: >> `++:. `-/+/ >> .` `/ >> >> >> Thanks, I hope someone can help me resolve this annoying issue. >> >> Michael Campbell >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. OpenPGP_0xF8F9F6EB6FCC696F.asc Description: application/pgp-keys OpenPGP_signature.asc Description: PGP signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
> On Nov 30, 2023, at 16:40, Derek Atkins wrote: > > Even more, the REPORTS only use #2, not #1, to figure out the "value" of > an account in another currency. Not exactly. Most reports have a Price Source option that allows you to select how commodity prices and currency exchange rates are retrieved. Last up through report date, closest to report date, and Most recent use the indicated date filter to select a price from the pricedb. The other two, Average cost of purchases weighted by volume and Weighted average of all transactions in the past calculate the price from the splits in all transactions in all accounts. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
Hi, GnuCash stores the exchange rates in two ways: 1) In the transaction, it lets you record the exact conversion. 2) In the priceDB, it lets you input one price per day. When you enter a transaction like #1, gnucash will automatically create a pricedb entry for you. In other words, you do NOT need manually enter prices, you just need to manually enter a cross-currency transaction, and gnucash will add the pricedb. This could be a problem, if you enter in the wrong exchange rate -- it will enter incorrect data into the pricedb. Even more, the REPORTS only use #2, not #1, to figure out the "value" of an account in another currency. Therefore, I suggest you look in the PriceDB at a date similar to the date of the transaction itself, and ensure you don't have some other exchange rate listed. -derek On Thu, November 30, 2023 7:02 pm, David Kirkby wrote: > On Thu, 30 Nov 2023 at 20:50, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> As Derek noted, this is likely not a bug, but an issue with your pricedb >> in your main file. >> >> I too lost the plot, and forgot that those reports can target which >> price to use for such cases. >> >> Your options then are to: >> >> 1. Play with the price target option >> 2. Edit, or delete the offending price(s) in the pricedb if not needed >> elsewhere. >> >> Regards, >> Adrien > > > I am in bed now using my mobile phone so don’t have access to GnuCash to > look at anything. > > I was unaware of the price db, and have not *knowingly* set anything up > like I see described here > > https://wiki.gnucash.org/wiki/Online_Quotes > > Maybe at some time I did mess around and set something up, and that’s what > it is using. > > However, I have noticed sometimes that GnuCash does suggest a number of > GBP > to enter for a USD transaction, and it’s “guess” is not wildly out. I > have not taken much notice of the values, but they seem to imply £1 is > worth more than a USD, but not twice as much. > > I am not sure how GnuCash will ever be able to make a meaningful report > that includes any conversion from pounds to dollars, particularly when > each > transaction will have a different exchange rate. > > I have tried to keep things simple when USD or EUR payments are made by > bank transfer, by recording only amount in pounds received. I am not going > to itemise the bank charge, as it is not recorded in any statement. But > with PayPal the transaction fee is always recorded in the statements from > PayPal. There’s a fee even on GBP transactions. > > Dave > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 20:50, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > As Derek noted, this is likely not a bug, but an issue with your pricedb > in your main file. > > I too lost the plot, and forgot that those reports can target which > price to use for such cases. > > Your options then are to: > > 1. Play with the price target option > 2. Edit, or delete the offending price(s) in the pricedb if not needed > elsewhere. > > Regards, > Adrien I am in bed now using my mobile phone so don’t have access to GnuCash to look at anything. I was unaware of the price db, and have not *knowingly* set anything up like I see described here https://wiki.gnucash.org/wiki/Online_Quotes Maybe at some time I did mess around and set something up, and that’s what it is using. However, I have noticed sometimes that GnuCash does suggest a number of GBP to enter for a USD transaction, and it’s “guess” is not wildly out. I have not taken much notice of the values, but they seem to imply £1 is worth more than a USD, but not twice as much. I am not sure how GnuCash will ever be able to make a meaningful report that includes any conversion from pounds to dollars, particularly when each transaction will have a different exchange rate. I have tried to keep things simple when USD or EUR payments are made by bank transfer, by recording only amount in pounds received. I am not going to itemise the bank charge, as it is not recorded in any statement. But with PayPal the transaction fee is always recorded in the statements from PayPal. There’s a fee even on GBP transactions. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] An operation is still running, wait for it to complete before quitting
On Thu, 30 Nov 2023 at 20:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Have you run Actions > Check & Repair > Check & Repair All? > > There might be something amiss that such scrubbing can clean up. > > Regards, > Adrien I have run that many times. However, I never thought of running it when this happened. will do that next time I get the problem. Thank you for the suggestion. Dave. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GNU Cash not performing math functions correctly on entry
MIchael That still works as expected in GnuCash 5.4 running on Linux Mint. I entered a transaction for $15.61 credit to my bank account, entered the next split as $15.61/11 and it was calculated as $1.42 with $14.19 going to the Imbalance account (I hit enter after entering the second split). I also tested your entry as well and the correct amount was entered. David Cousens On Thu, 2023-11-30 at 22:20 +, Michael Campbell via gnucash-user wrote: > Hello All, > > Long time lurker here, first time poster. I have been learning to use > GNU Cash for my personal finances and now business for the past 10 > years. I am still learning. > > When entering Goods and Services Tax for an entry, I used to just be > able to divide the total cost by eleven in the ledger and it would > calculate the proper amount. i.e., $72.25/11 would enter $6.57 into the > ledger. > > I am not sure if there has been an update or somehow I have changed a > setting but now when I perform the calculation in the entry field I get: > $72.25/11 enters $656.82 - clearly not correct. It is out by a factor of > 100 which should be a clue. > > Is this a bug in GNU Cash in a recent update or have I somehow screwed > up a setting some where - and if so where would I start to look? > > System Information: > > GNU Cash Version: 5.4 > Build ID: 5.3-412-g53245caebf+(2023-09-23) > > uname -a > Linux nuc 6.6.2-zen1-1-zen #1 ZEN SMP PREEMPT_DYNAMIC Mon, 20 Nov 2023 > 23:17:26 + x86_64 GNU/Linux > > neofetch > -` mick@nuc > .o+` > `ooo/ OS: Arch Linux x86_64 > `+: Host: NUC12WSKi7 M42762-305 > `+oo: Kernel: 6.6.2-zen1-1-zen > -+oo+: Uptime: 45 mins > `/:-:+++: Packages: 1456 (pacman) > `//+++: Shell: zsh 5.9 > `/++: Resolution: 2560x1440 > `/+++o/` WM: sway > ./oooo++osso+` Theme: Adwaita [GTK2/3] > .ooso-/oss+` Icons: Adwaita [GTK2/3] > -osso. :ssso. Terminal: tmux > :osss/ oo+++. CPU: 12th Gen Intel i7-1260P > (16) @ 4.700GHz > /o/ +ooo/- GPU: Intel Alder Lake-P GT2 > [Iris Xe Graphics] > `/oso+/:- -:/+oo+- Memory: 4386MiB / 31673MiB > `+sso+:-` `.-/+oso: > `++:. `-/+/ > .` `/ > > > Thanks, I hope someone can help me resolve this annoying issue. > > Michael Campbell > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GNU Cash not performing math functions correctly on entry
That sounds like a 'smallest commodity fraction' issue off the top of my head. Check your settings for your affected currency. Another place to check is the setting for automatic decimal points. Regards, Adrien On 11/30/23 4:20 PM, Michael Campbell via gnucash-user wrote: Hello All, Long time lurker here, first time poster. I have been learning to use GNU Cash for my personal finances and now business for the past 10 years. I am still learning. When entering Goods and Services Tax for an entry, I used to just be able to divide the total cost by eleven in the ledger and it would calculate the proper amount. i.e., $72.25/11 would enter $6.57 into the ledger. I am not sure if there has been an update or somehow I have changed a setting but now when I perform the calculation in the entry field I get: $72.25/11 enters $656.82 - clearly not correct. It is out by a factor of 100 which should be a clue. Is this a bug in GNU Cash in a recent update or have I somehow screwed up a setting some where - and if so where would I start to look? System Information: GNU Cash Version: 5.4 Build ID: 5.3-412-g53245caebf+(2023-09-23) uname -a Linux nuc 6.6.2-zen1-1-zen #1 ZEN SMP PREEMPT_DYNAMIC Mon, 20 Nov 2023 23:17:26 + x86_64 GNU/Linux neofetch -` mick@nuc .o+` `ooo/ OS: Arch Linux x86_64 `+: Host: NUC12WSKi7 M42762-305 `+oo: Kernel: 6.6.2-zen1-1-zen -+oo+: Uptime: 45 mins `/:-:+++: Packages: 1456 (pacman) `//+++: Shell: zsh 5.9 `/++: Resolution: 2560x1440 `/+++o/` WM: sway ./oooo++osso+` Theme: Adwaita [GTK2/3] .ooso-/oss+` Icons: Adwaita [GTK2/3] -osso. :ssso. Terminal: tmux :osss/ oo+++. CPU: 12th Gen Intel i7-1260P (16) @ 4.700GHz /o/ +ooo/- GPU: Intel Alder Lake-P GT2 [Iris Xe Graphics] `/oso+/:- -:/+oo+- Memory: 4386MiB / 31673MiB `+sso+:-` `.-/+oso: `++:. `-/+/ .` `/ Thanks, I hope someone can help me resolve this annoying issue. Michael Campbell ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement suggestion
I could be mistaken, but I don't think uncommitted transactions are written using the SQL backends. An edit perhaps, but not a new transaction. Note, the OP is referencing a crash, or leaving GnuCash open, forgetting about a pending edit to be committed, and restarting the computer. I think in the latter case, GnuCash will prompt to confirm the 'graceful' shutdown initiated by the OS. A hard reset or power down though would not. However, in such cases, I expect to lose unsaved data anyway, no matter what app I'm using. Regards, Adrien On 11/30/23 3:48 PM, Glenn Fowler wrote: I'm assuming you are using XML. In that case the "Save" button does appear from being greyed out and you are indicated on close. Of course this is global and not individual indications that you would like. The SQL database will save as you go. I'm in the other camp where I *don't* want to auto-save. This has saved me numerous times where I make a big mistake and it's a simple close without saving and reopening which is a littler easier and quicker than opening a previous backup and renaming files. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GNU Cash not performing math functions correctly on entry
Hello All, Long time lurker here, first time poster. I have been learning to use GNU Cash for my personal finances and now business for the past 10 years. I am still learning. When entering Goods and Services Tax for an entry, I used to just be able to divide the total cost by eleven in the ledger and it would calculate the proper amount. i.e., $72.25/11 would enter $6.57 into the ledger. I am not sure if there has been an update or somehow I have changed a setting but now when I perform the calculation in the entry field I get: $72.25/11 enters $656.82 - clearly not correct. It is out by a factor of 100 which should be a clue. Is this a bug in GNU Cash in a recent update or have I somehow screwed up a setting some where - and if so where would I start to look? System Information: GNU Cash Version: 5.4 Build ID: 5.3-412-g53245caebf+(2023-09-23) uname -a Linux nuc 6.6.2-zen1-1-zen #1 ZEN SMP PREEMPT_DYNAMIC Mon, 20 Nov 2023 23:17:26 + x86_64 GNU/Linux neofetch -` mick@nuc .o+` `ooo/ OS: Arch Linux x86_64 `+: Host: NUC12WSKi7 M42762-305 `+oo: Kernel: 6.6.2-zen1-1-zen -+oo+: Uptime: 45 mins `/:-:+++: Packages: 1456 (pacman) `//+++: Shell: zsh 5.9 `/++: Resolution: 2560x1440 `/+++o/` WM: sway ./oooo++osso+` Theme: Adwaita [GTK2/3] .ooso-/oss+` Icons: Adwaita [GTK2/3] -osso. :ssso. Terminal: tmux :osss/ oo+++. CPU: 12th Gen Intel i7-1260P (16) @ 4.700GHz /o/ +ooo/- GPU: Intel Alder Lake-P GT2 [Iris Xe Graphics] `/oso+/:- -:/+oo+- Memory: 4386MiB / 31673MiB `+sso+:-` `.-/+oso: `++:. `-/+/ .` `/ Thanks, I hope someone can help me resolve this annoying issue. Michael Campbell OpenPGP_0xF8F9F6EB6FCC696F.asc Description: application/pgp-keys OpenPGP_signature.asc Description: PGP signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement suggestion
I'm assuming you are using XML. In that case the "Save" button does appear from being greyed out and you are indicated on close. Of course this is global and not individual indications that you would like. The SQL database will save as you go. I'm in the other camp where I *don't* want to auto-save. This has saved me numerous times where I make a big mistake and it's a simple close without saving and reopening which is a littler easier and quicker than opening a previous backup and renaming files. On Thu, Nov 30, 2023 at 2:51 PM David Carlson wrote: > Have you looked at https://bugs.gnucash.org/show_bug.cgi?id=686051, which > was reported 13 years ago? > > On Thu, Nov 30, 2023 at 12:27 PM Glenn Fowler > wrote: > >> Hi that is expected behavior with xml, have you tried the database format? >> >> On Thu, Nov 30, 2023, 1:05 PM David G. Pickett via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >> > One problem with gnucash is inadvertently uncommitted modified >> > transactions. It's be nice if the tab lit up if that account included >> > such, so I can commit it before wandering off. If the system is >> rebooted >> > or gnucash is killed for batch stock price updates, these modifications >> are >> > lost, even with timed save configured. >> > >> > Alternately, find a way to save the modified transaction so when you >> > reopen gnucash, you can approve it. >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > - >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] An operation is still running, wait for it to complete before quitting
Have you run Actions > Check & Repair > Check & Repair All? There might be something amiss that such scrubbing can clean up. Regards, Adrien On 11/30/23 9:53 AM, David Kirkby wrote: This may be related to my other issues, but I sometimes see this. I just deleted all my USD transactions, leaving GBP and EUR untouched and verified that both the P&L and trial balance showed a zero balance for goods and services sold in USD. Then I tried posting the first invoice and then paying it. But it did not show as paid. When I try to exit I get this message. Windows task manager indicates that GnuCash is using virtually no CPU time. (I'm running Windows 11 and GnuCash 5,4 - Build ID: 5.4+(2023-09-23). ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
As Derek noted, this is likely not a bug, but an issue with your pricedb in your main file. I too lost the plot, and forgot that those reports can target which price to use for such cases. Your options then are to: 1. Play with the price target option 2. Edit, or delete the offending price(s) in the pricedb if not needed elsewhere. Regards, Adrien On 11/30/23 7:20 AM, David Kirkby wrote: I have lost the plot I think. I think there's a bug in the reporting. Here's a demo account, with the GBP shown correctly for USD sales, but the value of the USD sales is not given. I don't know if that's intentional or not, but having both the GBP and USD would seem nice. [image: image.png] But the ones I produced for my accountant have the foreign currency too, which is nice. I have not blanked out the $540 transaction, but left that. The GBP amount is wrong. But I'm not sure what the intended behavior of the report is. [image: image.png] Looking in the bank account for that transaction I see [image: image.png] In the trial balance [image: image.png] So there are 3 different GBP figures for these reports. 1) $540 was converted by the bank into £424.00. It shown as that in the bank account. 2) P&L shows $540 and £441.67. The £441.67 is wrong (£17.67 too high). 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low) I suppose it's worth reporting this as a bug, despite the fact I can't reproduce it in a test case, which would obviously be most helpful to the developers. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
First, yes, that warning is for when you try to delete the *Invoice*, not the payment. (same for Bills with Vendors) Second, as you may have noticed, inline images are not possible with this list, you have to attach them separately. Because of that, if you can, please give them some meaningful name other than 'image'. (or perhaps number them) When it is just one, that is no big deal, but when you are including 4 or 5, like here, it takes some time opening each to figure out where it belongs in the post. Regards, Adrien On 11/30/23 8:04 AM, David Kirkby wrote: This was the message I was thinking of - you can't delete from accounts receivable without unposting. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement suggestion
Have you looked at https://bugs.gnucash.org/show_bug.cgi?id=686051, which was reported 13 years ago? On Thu, Nov 30, 2023 at 12:27 PM Glenn Fowler wrote: > Hi that is expected behavior with xml, have you tried the database format? > > On Thu, Nov 30, 2023, 1:05 PM David G. Pickett via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > One problem with gnucash is inadvertently uncommitted modified > > transactions. It's be nice if the tab lit up if that account included > > such, so I can commit it before wandering off. If the system is rebooted > > or gnucash is killed for batch stock price updates, these modifications > are > > lost, even with timed save configured. > > > > Alternately, find a way to save the modified transaction so when you > > reopen gnucash, you can approve it. > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect.
Well, it took some time, but the problem seems to be solved. I went back a couple of years and eventually found some errors associated with some fraudulent activity on my account. I also did some work fixing errors in an associated savings account. When I finished that, all my previously correct reconciled balances were wrong. So, I continued searching for errors, until all those reconciled balances agreed with my bank statements. I was finally able to balance my account for the current month, but the beginning balance in the reconcile window still showed a false, negative amount. Until this morning when I finally balanced last month (Oct 2023). Suddenly, that beginning balance is now correct. I still have no idea just what caused that false value to show up, but things are working correctly now. Thanks for all your help! :>) John Reagan On 11/21/23 4:39 PM, John Ralls wrote: Oops, I guess you don't *quite* get how to use the mailing list: Always use reply-all so that your reply goes to the list, not just to the person you're replying to. Regards, John Ralls On Nov 21, 2023, at 4:23 PM, sailing wrote: Great! Thank you. +} Original message From: John Ralls Date: 11/21/23 6:49 PM (GMT-05:00) To: Elven Decker Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Account reconciliation -- Gnucash's beginning balance is incorrect. On Nov 21, 2023, at 12:35 PM, Elven Decker wrote: Not sure how to use this help thread, but I have had a similar problem years ago which recently started happening again. I solve it by exiting the reconciliation window and then re-opening it. When the small reconcile information window opens, I click on the "Statement Date" drop-down and choose the correct date by hand. This forces some kind of re-computation of the beginning and ending balances. You seem to have figured out the mailing list. No need to quit and restart the reconcile, though: You can edit the reconcile information with Reconcile>Reconcile Information... from the reconcile window's menu. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement suggestion
Hi that is expected behavior with xml, have you tried the database format? On Thu, Nov 30, 2023, 1:05 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > One problem with gnucash is inadvertently uncommitted modified > transactions. It's be nice if the tab lit up if that account included > such, so I can commit it before wandering off. If the system is rebooted > or gnucash is killed for batch stock price updates, these modifications are > lost, even with timed save configured. > > Alternately, find a way to save the modified transaction so when you > reopen gnucash, you can approve it. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Enhancement suggestion
One problem with gnucash is inadvertently uncommitted modified transactions. It's be nice if the tab lit up if that account included such, so I can commit it before wandering off. If the system is rebooted or gnucash is killed for batch stock price updates, these modifications are lost, even with timed save configured. Alternately, find a way to save the modified transaction so when you reopen gnucash, you can approve it. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] An operation is still running, wait for it to complete before quitting
Although the invoice was showing as unpaid as I mentioned, I forcibly quit GnuCash, then saw the $591 invoice was marked as paid. But when I looked at the trial balance I saw this [image: image.png] for a $591 invoice. But there's no way GnuCash should have any idea how any GBP that was, as it was paid as USD directly into a USD PayPal account. After PayPal fees that was $561.80. The P&L shows $591.00 £443.58 Income statement show the same $591.00 £443.58 I can't see how any accounts will have any idea how many GBP it is as this time. On Thu, 30 Nov 2023 at 15:53, David Kirkby wrote: > This may be related to my other issues, but I sometimes see this. > > I just deleted all my USD transactions, leaving GBP and EUR untouched and > verified that both the P&L and trial balance showed a zero balance for > goods and services sold in USD. > > Then I tried posting the first invoice and then paying it. But it did not > show as paid. When I try to exit I get this message. Windows task manager > indicates that GnuCash is using virtually no CPU time. (I'm running Windows > 11 and GnuCash 5,4 - Build ID: 5.4+(2023-09-23). > > > [image: image.png] > > > > > -- > Dr David Kirkby Ph.D > Kirkby Microwave Ltd > Email: drkir...@kirkbymicrowave.co.uk > Web: https://www.kirkbymicrowave.co.uk/ > Telephone 07910 441670 (UK) or +44 7910 441670 (international) > Registered in England and Wales, company number 08914892. > Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] An operation is still running, wait for it to complete before quitting
This may be related to my other issues, but I sometimes see this. I just deleted all my USD transactions, leaving GBP and EUR untouched and verified that both the P&L and trial balance showed a zero balance for goods and services sold in USD. Then I tried posting the first invoice and then paying it. But it did not show as paid. When I try to exit I get this message. Windows task manager indicates that GnuCash is using virtually no CPU time. (I'm running Windows 11 and GnuCash 5,4 - Build ID: 5.4+(2023-09-23). [image: image.png] -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
In this data file there is a transaction that converts from 540 to 424. It sounds like that is correct. My only guess as to the reporting is that there are PriceDB entries in your real data file that are "incorrect" for the actual transaction days. In the data file you posted, there is only a single PriceDB entry for USD to GBP with a value of 106/135.. And Lo! and Behold, 540 * 106 / 135 = 424. I think this explains why the reports work for the test data. And you are correct, you cannot remove an INVOICE transaction from AR/AP directly, you need to unpost the invoice to remove it. This is by design. -derek On Thu, November 30, 2023 9:04 am, David Kirkby wrote: > This was the message I was thinking of - you can't delete from accounts > receivable without unposting. > > [image: image.png] > > > On Thu, 30 Nov 2023 at 13:37, David Kirkby > > wrote: > >> The attached has the single USD/GBP transaction that I'm having problems >> with the reporting with. But the reporting is fine on this demo. >> >> On Thu, 30 Nov 2023 at 13:20, David Kirkby >> >> wrote: >> >>> On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> Apparently so! >>> >>> I have lost the plot I think. >>> >>> I think there's a bug in the reporting. >>> >>> Here's a demo account, with the GBP shown correctly for USD sales, but >>> the value of the USD sales is not given. I don't know if that's >>> intentional >>> or not, but having both the GBP and USD would seem nice. >>> >>> [image: image.png] >>> >>> >>> But the ones I produced for my accountant have the foreign currency >>> too, >>> which is nice. I have not blanked out the $540 transaction, but left >>> that. >>> The GBP amount is wrong. But I'm not sure what the intended behavior of >>> the >>> report is. >>> >>> [image: image.png] >>> >>> Looking in the bank account for that transaction I see >>> [image: image.png] >>> In the trial balance >>> >>> [image: image.png] >>> >>> So there are 3 different GBP figures for these reports. >>> 1) $540 was converted by the bank into £424.00. It shown as that in the >>> bank account. >>> 2) P&L shows $540 and £441.67. The £441.67 is wrong (£17.67 too high). >>> 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low) >>> >>> I suppose it's worth reporting this as a bug, despite the fact I can't >>> reproduce it in a test case, which would obviously be most helpful to >>> the >>> developers. >>> >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Apparently so! > I have lost the plot I think. I think there's a bug in the reporting. Here's a demo account, with the GBP shown correctly for USD sales, but the value of the USD sales is not given. I don't know if that's intentional or not, but having both the GBP and USD would seem nice. [image: image.png] But the ones I produced for my accountant have the foreign currency too, which is nice. I have not blanked out the $540 transaction, but left that. The GBP amount is wrong. But I'm not sure what the intended behavior of the report is. [image: image.png] Looking in the bank account for that transaction I see [image: image.png] In the trial balance [image: image.png] So there are 3 different GBP figures for these reports. 1) $540 was converted by the bank into £424.00. It shown as that in the bank account. 2) P&L shows $540 and £441.67. The £441.67 is wrong (£17.67 too high). 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low) I suppose it's worth reporting this as a bug, despite the fact I can't reproduce it in a test case, which would obviously be most helpful to the developers. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
Apparently so! You can't delete the *invoice* but you can delete the payment. I don't ever recall anything different and I've been using GnuCash for 10+ years. Of course, you do get the confirmation for deleting the payment, but it isn't an error. Deleting the payment *should* 'unattach' it. Regards, Adrien On 11/30/23 4:00 AM, David Kirkby wrote: I think I must be going mad.😪 I thought in the past I had always observed an error message if trying to delete a transaction in the bank account that was attached to a posted invoice, using the business features and AR or AP. . But I just checked a previous installation on another computer (slightly earlier release on Linux) and found it is possible to simply delete an entry from the bank account, despite it being attached to a posted invoice. Did I just dream there was an error message generated if one tried to delete a transaction in the bank account, for which there was a posted invoice? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 09:18, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Once again - please remember to reply to the list... > OOps. > > It was several replies up the thread, but I was replying to your point > about being able to delete payments for only some currencies. (though > you've now discovered that currency isn't a limitation) > > Here was my posting: > > > Let's get some terminology and workflow straight: > > > > 1. Using the Business Features, Invoices and Bills are entered in a > separate UI, *not* directly in an account register. > > > > 2. Posting these, results in transactions appearing in the respective > A/R or A/P accounts. > > > > 3. Those transactions are immutable at this point and cannot be edited > or deleted from either the AR/AP accounts, or the other side of their > transactions. (Income accounts in the case of Invoices, or Expense accounts > in the case of Bills) At this point, no bank account or other 'payment > account' is involved. > > > > 4. Payments can either be entered via the 'Process Payment' function, or > entered directly into an appropriate account register. (or imported into > said register) If directly entering or importing, you then have to > right-click the transaction and choose 'Assign as payment' to bring up the > 'Process Payment' dialog to formally link the payment transaction to an > Invoice or Bill. These transactions affect and appear in the source account > and either AR/AP accordingly. They are always editable and delete-able from > any affected register. The Invoice/Bill posting status has no bearing on > this. However, while you can edit them directly, you generally should do so > by right-clicking and choosing 'Edit payment'. > > Does that clear up the issue concerning deleting payments? > > Note, I think there is a bug concerning invoices showing still as paid > after a payment is deleted, but that might only be in the Invoice UI. > I'm not sure that is the case everywhere. I'd have to investigate. I > also don't know if that bug has been filed. > > Regardless, if after deleting a payment, you unpost and repost the > invoice, it should now show as unpaid since GnuCash can't find the > original payment to re-link it. > > There is nothing odd about being able to delete a payment. > > Regards, > Adrien > I think I must be going mad.😪 I thought in the past I had always observed an error message if trying to delete a transaction in the bank account that was attached to a posted invoice, using the business features and AR or AP. . But I just checked a previous installation on another computer (slightly earlier release on Linux) and found it is possible to simply delete an entry from the bank account, despite it being attached to a posted invoice. Did I just dream there was an error message generated if one tried to delete a transaction in the bank account, for which there was a posted invoice? Dave ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
Once again - please remember to reply to the list... - It was several replies up the thread, but I was replying to your point about being able to delete payments for only some currencies. (though you've now discovered that currency isn't a limitation) Here was my posting: Let's get some terminology and workflow straight: 1. Using the Business Features, Invoices and Bills are entered in a separate UI, *not* directly in an account register. 2. Posting these, results in transactions appearing in the respective A/R or A/P accounts. 3. Those transactions are immutable at this point and cannot be edited or deleted from either the AR/AP accounts, or the other side of their transactions. (Income accounts in the case of Invoices, or Expense accounts in the case of Bills) At this point, no bank account or other 'payment account' is involved. 4. Payments can either be entered via the 'Process Payment' function, or entered directly into an appropriate account register. (or imported into said register) If directly entering or importing, you then have to right-click the transaction and choose 'Assign as payment' to bring up the 'Process Payment' dialog to formally link the payment transaction to an Invoice or Bill. These transactions affect and appear in the source account and either AR/AP accordingly. They are always editable and delete-able from any affected register. The Invoice/Bill posting status has no bearing on this. However, while you can edit them directly, you generally should do so by right-clicking and choosing 'Edit payment'. Does that clear up the issue concerning deleting payments? Note, I think there is a bug concerning invoices showing still as paid after a payment is deleted, but that might only be in the Invoice UI. I'm not sure that is the case everywhere. I'd have to investigate. I also don't know if that bug has been filed. Regardless, if after deleting a payment, you unpost and repost the invoice, it should now show as unpaid since GnuCash can't find the original payment to re-link it. There is nothing odd about being able to delete a payment. Regards, Adrien p.s.—I also attached your images you sent here for anyone else following along. On 11/29/23 6:11 PM, David Kirkby wrote: I can’t seem to find the relevant post of yours, but I realise my current accounts are corrupted in some way, if I right click on any transaction in the bank account I see this. Note the invoice is posted - I can jump to see if I want, and it will show as PAID. Then if I click "Delete transaction" I see this. If I click "Delete transaction", the money disappears from the bank account, but the invoice is still showing as paid. I thought this issue was only happening with non-GBP transactions, but I can see I can do it with GBP transactions too. Em,. I need to retrieve an older backup, where there was a message saying the transaction was posted, and it needed to be unposted before being deleted. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 03:48, Alan Hopkins wrote: >Hello David >We receive and pay for a multitude of currencies. This made life >complicated for a small business so we decided to use a FX service - we >use OFX because we managed to get to them in their early days and were >offered a special continuing deal. >However, there are quite a few others too - TransferWise (now just >called Wise) were probably the initiators in this area. >The way it works is that we tell them what we need to pay in FX, we pay >in our local currency and the bill is paid to the supplier in their >currency. On the receipt side, the client pays into a bank account >local to them, the OFX service notifies us of the receipt, and then we >can either convert to our local currency immediately or at some time >over the next 2 months when we wish - this has an advantage (generally) >in being able to get a more favourable exchange rate and thus a better >return. >The service costs less than banks - they provide a better exchange rate >and have lower fees - and our accounts are all in local currency. We >just adjust our invoices/bills according to the rate received/paid. >Easy peasy. >I'm not sure that will help you but it just might! >Cheers >Hop > A significant percentage of my transactions go via PayPal, so I don't think that would work too well for me. It might sometimes, especially on the rare higher value transaction which is paid by bank transfer. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.