Re: [GNC] Foreign Currency Receivable
Gao, You have a couple of options. The simplest would be to just ignore that USD is involved at all and convert all of the USD amounts to CNY and post the CNY amounts to GnuCash. That obviously loses a bit of detail. Next up in complexity would be to create some USD accounts for income, expense, and accounts receivable (make that account type bank, not type accounts receivable, for this approach). You'll post those from the monthly statements. When you receive the actual payment you'll credit accounts payable in USD and debit your CNY bank account using whatever exchange rate your bank gives you on the conversion. Depending on how you handle the withheld taxes you also may need a USD or CNY asset account for pre-paid taxes. If you keep the payments in a USD-denominated account then you'd create a bank account in GnuCash to model it and debit it on payments. If you want to track unit sales you could make the income account in CNY and use the CNY->USD exchange rate reflected in your statement. For example if you price the game at CNY 150, you sold 10 of them in April, and your steam statement says that your revenue was USD 100 then you'd credit income CNY1500 and debit Expenses:commision USD 30, As sets:Prepaid taxes or expenses:taxes (depending on how you have to handle the taxes), and Assets:AccountsPayable USD 60. Then when you get the payment and your bank converts the USD 60 into CNY 800 you'd credit accounts payable USD 60, debit CNY 800 and debit Income:Trading Gains CNY 100. If you want you could go a step further and use the business module to convert the steam statement into an invoice. In that case you'd make the accounts payable account type accounts payable. IIRC the business model doesn't know how to handle the exchange rates and trading gains so you'd have to do that part manually, but it might provide some reports that you'd find useful enough to justify the extra work. Regards, John Ralls > On May 25, 2022, at 5:25 PM, Gao Bite wrote: > > Mr. or Mrs. Novack: > > Hello! I am probably not making myself clear in the last e-mail, so I wish > that you could allow me to clarify myself in this e-mail. > > I put my game on the Steam platform and priced it in CNY. Let us assume that > purchases happen in March. When players in China buy the game, they pay in > CNY (without having notice of foreign exchange done by Steam's partner), and > Steam possibly receives their payments in USD. At the end of March, I > received an invoice telling me about data for the game's sales in March, a 30 > percent deduction from the Steam platform, and a 10 percent of income tax. At > the end of April, I received my part in USD. > > I wonder if I clarified myself in this e-mail. If you still have some points > not sure about, I wish that you could let me know it. > > Yours, > > >Bite Gao > > May 26th, 2021 > > On 2022-05-25 22:23, Michael or Penny Novack wrote: >> On 5/25/2022 12:01 AM, Gao Bite wrote: >>> GnuCash Developers and Maintainers: >>> >>> Hello! I am a Chinese developer who sells games on the Steam platform. >>> When I sell my game work on steam, I receive the sales report every month >>> containing data for last month's game selling. And I will receive last >>> month's money in USD at the end of this month. My base currency is CNY. >>> >>> How can I perform my accounting to record the gain and losses from game >>> selling and foreign exchange separately? >> >> >> What data is on this statement beyond gross amount in USD? Is the site doing >> all transactions in USD (games sold for some price in USD as opposed to the >> currency of the buyer). If you are selling different games at various >> prices, unless you are told how many of each However it might be >> simpler for somebody like yourself who is the fabricator of an intangible << >> most sellers would be selling tangible goods with an associated "cost of >> goods" but possibly/probably you do not* >> >> >> ARE you selling goods at some price in USD, does your statement make clear >> how many units sold (at what price) , does it show the fees the agent is >> deducting, etc? Possibly there is no currency exchange involved YET. Maybe >> the only gains/losses form currency exchange would between the time you >> receive this statement and payment in USD and you get that converted into >> CNY in your bank account. >> >> In other words, if you receive a statement from the agent "sales in March >> were $XXX (as of 3/31) but you do not receive into your bank account YYY in >> CNY until April 25th you might want to consider the value of ($xxx - fees) >>
Re: [GNC] Keyboard shortcuts problem with v4.10
This sounds like https://bugs.gnucash.org/show_bug.cgi?id=798515, which is in turn probably https://gitlab.gnome.org/GNOME/gtk/-/issues/4610. The latter is fixed, so I updated the build server and made a new nightly build https://code.gnucash.org/builds/win32/maint/gnucash-4.10-2022-05-21-git-4.10-97-gf18c70f68+.setup.exe that should fix the problem. Regards, John Ralls > On Mar 29, 2022, at 11:10 PM, jbonn...@internode.on.net wrote: > > Hi All, > > > > I can also report that I get a similar problem with similar tracefile > entries, 33 times, when I try to enter a new transaction by typing in the > Description field. Even trying to copy and paste another description fails > on the copy. It is possibly the same on any keyboard input and seems similar > to problems I see some reporting on Mac. > > > > * 16:27:48 ERROR gdk_keysym_to_key_entry_index: assertion > 'info->reverse_lookup_table != NULL' failed > > > > I will wait a bit, but it looks like I may need to go back to v4.9. > > > > John Bonnett > > > > From: jbonn...@internode.on.net > Sent: Wednesday, 30 March 2022 9:00 AM > To: 'gnucash-user@gnucash.org' > Subject: Keyboard shortcuts problem with v4.10 > > > > Hi All, > > > > I have a problem with keyboard shortcuts with the latest v4.10 GnuCash and > Finance:Quote 1.51. I have some keyboard shortcuts on the View menu mapped. > > > > I am running Windows 10 21H2 on an Intel Xeon 16Gb RAM > > > > > > > > The mappings are as follows: > > > > Basic Ledger Ctrl-1 > > Auto-Split Ledger Ctrl-2 > > Transaction Journal Ctrl-3 > > Double Line Ctrl-4 > > > > These shortcuts show on the righthand side of the menu. > > > > The functions on the menu work fine if you select them with the mouse, but > if you use the keyboard shortcuts, at least for Ctrl-2 and Ctrl-4, there is > a small pause, with the hourglass icon, then GnuCash shuts down, without > saving. It starts again OK except you need to select "Open anyway" since the > lock file has not been cleared, but any changes may not have been saved. It > worked fine with v4.9. > > > > Here is a trace file just after such a shut down > > > > * 08:35:32 WARN Unexpectedly, UWP app > `microsoft.windowscommunicationsapps_16005.14326.20544.0_x64__8wekyb3d8bbwe' > (AUMId > `microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mai > l') supports 1 extensions but has no verbs > > * 08:35:32 WARN Unexpectedly, UWP app > `XBMCFoundation.Kodi_19.4.500.0_x64__4n2hpmxwrvr6p' (AUMId > `XBMCFoundation.Kodi_4n2hpmxwrvr6p!Kodi') supports 120 extensions but has no > verbs > > * 08:36:37 WARN Could not locate file AUTHORS > > * 08:36:37 WARN Could not locate file DOCUMENTERS > > * 08:36:37 WARN Could not locate file LICENSE > > * 08:48:41 WARN Could not locate file AUTHORS > > * 08:48:41 WARN Could not locate file DOCUMENTERS > > * 08:48:41 WARN Could not locate file LICENSE > > * 08:54:00 ERROR gdk_keysym_to_key_entry_index: assertion > 'info->reverse_lookup_table != NULL' failed > > > > That last line repeats 33 times. > > > > Any advice appreciated. > > > > John Bonnett > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Double entry directly to Equity
Well, Trading has special meaning in GnuCash: It's used for a set of accounts that are outside of the accounting equation used for tracking unrealized gains and losses from transactions involving more than one commodity. Those accounts are enabled by the book property (accessed via File>Properties) Use Trading Accounts and GnuCash manages them itself. You shouldn't directly edit trading splits. Either you're using it with a different meaning, which you'll need to explain, or you did something wrong and a recent update to GnuCash is stopping you from repeating the error. Equity represents the value of the enterprise, Assets - Liabilities. Income and Expense are special flavors of Equity so most transactions you do are between Assets and Equity. If you close your book then Retained Earnings is the destination of zeroing out the Income and Expense accounts. The other component of Equity is the money brought to the enterprise by the owners/shareholders. If any of that is less than perfectly clear to you then you should study the Tutorial and Concepts Guide and whatever other basic accounting texts you fancy until it is clear. Now, what is it exactly that you're trying to do? Regards, John Ralls > On May 7, 2022, at 8:55 AM, Bogdan wrote: > > Any suggestions there? > > -- Forwarded message - > From: Bogdan > Date: Wed, May 4, 2022, 12:04 > Subject: Double entry directly to Equity > To: > > > Hi, > > I am trying to figure out how to set up a revaluation reserve account > directly in Equity so that I could do e.g. Dr Asset a/c Cr Equity. > > About a year ago I was able to create an account in Trading and debit / > credit it directly from Asset and Liability accounts. However, now when I > enter a similar transaction the Trading account (second leg of the entry) > simply disappears and is replaced by Imbalance. > > What is the appropriate way to make accounting entries directly to Equity > accounts (not retained earnings through PL)? Any idea why the above > approach no longer works? > > Thanks! > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Calculation of Unrealized Losses
David is referring to https://bugs.gnucash.org/show_bug.cgi?id=797796, which is probably the issue you're seeing: You have some three-commodity transactions involving USD, CAD, and a Vanguard fund and the average-cost algorithm used in the trial balance report doesn't work well in that case. Regards, John Ralls > On May 2, 2022, at 7:54 PM, David Carlson wrote: > > Bill, > > If I recall correctly, one or more of the methods GnuCash uses to calculate > exchange rates for reports is technically not correctly defined , so it > obscures the fact that it is not calculating the expected value. That is > leading to strange results when, for example, one attempts to do a trial > balance. I know very little about accounting so I cannot tell you details > about that. > > Some of the developers can help with some of those issues. Hopefully they > can at least tell you which calculation methods to avoid when you want > accurate results . > > On Mon, May 2, 2022, 9:27 PM Bill Dika wrote: > >> Can anyone help me with this? >> >> Do I have to supply more/different information? >> >> I have been using gnucash personally for a couple of years now and would >> like to develop more confidence in the program. >> >> Thank you in advance for your help. >> >> Bill Dika >> >> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika wrote: >> >>> My default currency is Canadian dollars. I have some US dollar >>> accounts in my balance sheet. >>> >>> I have an unrealized loss in the equity section of my balance sheet at >>> July 31 2021 of $12.68 and cannot figure out how it was calculated. I >>> also have US dollar accounts expressed in Canadian dollars that I am >>> unable to determine how the translation from US dollars to Canadian >>> dollars occurs. >>> >>> For example I have a US dollar account of $353.75 for Tesla (see >>> us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22 >>> in Canadian dollars at July 31 2021 (see >>> us-dollar-accts-july-31-2021.png). This is an exchange rate of >>> 1.28966. I am unable to figure out how Gnucash arrives at that rate >>> (see us-dollar-rates-price-database.png). It is not the rate at July >>> 31 2021. It is not the average rate for all rates I have up to July 31 >>> 2021 and it is not the average rate for all rates I have in the price >>> database. >>> >>> Also the $12.68 loss arises from only one change in the US dollar >>> accounts from June 30 2021 to July 31 2021. That is a $524.80 US >>> dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see >>> change-in-us-dollar-acct-july-2021.png). >>> >>> Attached are images of the following: >>> equity-jun-30-2021.png = showing the equity section almost balanced >>> (.01 unrealized gain) (in Canadian dollars) >>> equity-july-31-2021.png = showing the $12.68 unrealized loss (in >>> Canadian dollars) >>> us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts >>> (in US dollars) >>> us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian >>> dollars) >>> us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet >>> accounts (in US dollars) >>> us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian >>> dollars) >>> change-in-us-dollar-acct-july-2021.png = shows the only change in the >>> US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US >>> dollars) >>> us-dollar-rates-price-database.png = all the US to Canadian exchange >>> rates in my database >>> >>> I am a Canadian CPA and feel quite confident about the accounting in >>> the gnucash file. I have reviewed the journal entries for the period >>> and they all balance. The only thing I can ascertain is that the >>> unrealized loss arises from the US dollar accounts but I cannot figure >>> out how gnucash is calculating it nor can I figure out how gnucash >>> translates US dollars to Canadian dollars for those accounts. >>> >>> I have searched the list but cannot find anything that helps me in my >>> calculation. >>> >>> I am on Arch linux using Gnucash 4.9. >>> >>> Any help would be much appreciated. >>> >>> Thank you. >>> >>> Bill Dika >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subs
Re: [GNC] Calculation of Unrealized Losses
No need, we all read this one too. Regards, John Ralls > On May 5, 2022, at 9:52 AM, Bill Dika wrote: > > Thanks David. > > I'll try the gnucash developers list. > > Bill Dika > > On Mon, May 2, 2022 at 10:54 PM David Carlson > wrote: > >> Bill, >> >> If I recall correctly, one or more of the methods GnuCash uses to >> calculate exchange rates for reports is technically not correctly defined , >> so it obscures the fact that it is not calculating the expected value. >> That is leading to strange results when, for example, one attempts to do a >> trial balance. I know very little about accounting so I cannot tell you >> details about that. >> >> Some of the developers can help with some of those issues. Hopefully they >> can at least tell you which calculation methods to avoid when you want >> accurate results . >> >> On Mon, May 2, 2022, 9:27 PM Bill Dika wrote: >> >>> Can anyone help me with this? >>> >>> Do I have to supply more/different information? >>> >>> I have been using gnucash personally for a couple of years now and would >>> like to develop more confidence in the program. >>> >>> Thank you in advance for your help. >>> >>> Bill Dika >>> >>> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika wrote: >>> >>>> My default currency is Canadian dollars. I have some US dollar >>>> accounts in my balance sheet. >>>> >>>> I have an unrealized loss in the equity section of my balance sheet at >>>> July 31 2021 of $12.68 and cannot figure out how it was calculated. I >>>> also have US dollar accounts expressed in Canadian dollars that I am >>>> unable to determine how the translation from US dollars to Canadian >>>> dollars occurs. >>>> >>>> For example I have a US dollar account of $353.75 for Tesla (see >>>> us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22 >>>> in Canadian dollars at July 31 2021 (see >>>> us-dollar-accts-july-31-2021.png). This is an exchange rate of >>>> 1.28966. I am unable to figure out how Gnucash arrives at that rate >>>> (see us-dollar-rates-price-database.png). It is not the rate at July >>>> 31 2021. It is not the average rate for all rates I have up to July 31 >>>> 2021 and it is not the average rate for all rates I have in the price >>>> database. >>>> >>>> Also the $12.68 loss arises from only one change in the US dollar >>>> accounts from June 30 2021 to July 31 2021. That is a $524.80 US >>>> dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see >>>> change-in-us-dollar-acct-july-2021.png). >>>> >>>> Attached are images of the following: >>>> equity-jun-30-2021.png = showing the equity section almost balanced >>>> (.01 unrealized gain) (in Canadian dollars) >>>> equity-july-31-2021.png = showing the $12.68 unrealized loss (in >>>> Canadian dollars) >>>> us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts >>>> (in US dollars) >>>> us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian >>>> dollars) >>>> us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet >>>> accounts (in US dollars) >>>> us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian >>>> dollars) >>>> change-in-us-dollar-acct-july-2021.png = shows the only change in the >>>> US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US >>>> dollars) >>>> us-dollar-rates-price-database.png = all the US to Canadian exchange >>>> rates in my database >>>> >>>> I am a Canadian CPA and feel quite confident about the accounting in >>>> the gnucash file. I have reviewed the journal entries for the period >>>> and they all balance. The only thing I can ascertain is that the >>>> unrealized loss arises from the US dollar accounts but I cannot figure >>>> out how gnucash is calculating it nor can I figure out how gnucash >>>> translates US dollars to Canadian dollars for those accounts. >>>> >>>> I have searched the list but cannot find anything that helps me in my >>>> calculation. >>>> >>>> I am on Arch linux using Gnucash 4.9. >>>> >>>> Any help would be much appreciated. >>>&g
Re: [GNC] Fails under newest Ubuntu
Please remember to copy the list on all replies. > On May 1, 2022, at 3:58 PM, Stephen M. Butler > wrote: > > On 5/1/22 08:47, john wrote: >>> On Apr 30, 2022, at 9:50 PM, Stephen M. Butler >>> wrote: >>> >>> On 4/30/22 15:40, David H wrote: >>>> Steve FYI, >>>> >>>> Re-compiled and working now although I did have to add the following to my >>>> build script.. >>>> >>>> sudo git config --global --add safe.directory $SOURCEDIR > > I saw that when attempting the sudo make install. Although the note didn't > reference the sudo part and it took me a coupe of attempts to figure that > part out. > >>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>> >>>> >>>> Cheers David H. >>>> >>> Cmake was building files in my gnucash git clone directory. I ended up >>> having to destroy and download a whole new clone. That seems to have fixed >>> whatever strange problem cmake was having. Make is currently compiling >>> and I hope that finishes here in the next few minutes. >>> >>> I'll have to pull up the git docs and figure out what your command line >>> does and why it might be needed. >> Cmake does that only if you invoke it in the source directory. Don't do that. > > I was definitely in the Build directory: > ./gnucash > ./Build-4.10-60 <-- in here > > Also tried to copy the ./gnucash --> ./Source-4.10-60 > Cmake worked but make didn't. It still tried to reference ./gnucash When you have a problem like this and periodically just for drill delete the contents of your build directory and start afresh: Make double sure you're really in your build directory, then say rm -rf * && cmake /path/to/source/directory >> >> Git has a clean command: >> git clean -fdx >> You can use that to restore your working directory to a freshly checked out >> state, no need to re-clone. > Tried just the git clean -f (didn't see the dx options). Something > somewhere was still causing cmake to build into the source directory even > though I was in the build one. That would have helped a great deal as I have > a very slow Century NoLink 8Mbit connection. Probably a lot. -d tells git clean to recurse. Leave it out and you clean only the top-level directory. -x tells git to ignore the gitignore files that probably have things like build products if you've messed up and run cmake in the source directory, editor artifacts, and random other stuff. > > Over the course of the evening ended up cloning three times. Finally Cmake > and Make beat me into submission and I referenced the ./gnucash git directory > from the ./Build-4.10-60 directory. That all worked and sudo make install > also worked!! (about midnight). > > I did have one problem with sudo make uninstall in the ./Build-4.9-10 build > folder. I had removed the source folder for that build and uninstall needed > it for some reason. One reason why I would like to keep a copy of the git > directory at the time of build so I have the old source sitting around that > was used for the build. More evidence that you at some point ran cmake in the source directory and make found those Makefiles. The file that make uninstall is looking for is installed_manifest.txt. It contains the paths to all of the installed files. > > I seem to remember that git has the option to checkout into a different > directory so I will investigate if that will work and can be the source > referenced by cmake. It does, but that's not what you want. Cmake won't write anything into your source directory as long as you never invoke it from there and don't use the –B option. > > But, not today! Getting my 5th wheel ready for summer use. I may explore > that when forced to compile again (which may be in the distant future). > > I'm retired!! How can I be this busy? How did I ever have time to go to > work? > Another thing you might want to explore next time is ninja. It's a lot faster than make. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New to GnuCash SQLite on Windows: I have questions
Before Macintosh programs worked by passing a data file name as a parameter to the program you wanted to start or by using an "open" command once you'd started the program. The Macintosh introduced Graphical User Interfaces to the general public and included the ability to click on a file in the file system browser (it introduced the file system browser too) and have that file's associated program launch. It used a filesystem attribute called a resource fork that contained information about the program that created it. Microsoft Windows before WindowsNT was a graphical shell on their rather minimal MSDOS operating system whose very simple filesystem couldn't handle extended attributes so they based their similar capability on file extensions. Linux has had extended attributes since 2002, but they never really caught on and the XDG MIME database relies on file globs--which for practical purposes means file extensions--to determine what program to launch when a user tries to open a data file. Apple started moving away from resource forks around 2010 and removed Launch Services ability to use them to determine the program around 2012. GnuCash itself doesn't care a bit about what you name your file, but launching GnuCash by double-clicking on a book filename/icon on the desktop or file system browser depends on using the .gnucash extension on all current OSes. To facilitate that working in GnuCash Geert wrote https://bugs.gnucash.org/show_bug.cgi?id=615347 and fixed it with https://github.com/Gnucash/gnucash/commit/06489439f64b6cf0510828c2907e658ab900c5f7 12 years ago. Regards, John Ralls > On Apr 21, 2022, at 10:56 AM, David Carlson > wrote: > > Somewhere I lost track of the reasoning to save a file under a filename > without an extension. Since there has never been a standard method to > assign an extended attribute for filetype that, unlike file extensions, is > consistent over all common file storage formats, in my opinion it would > still be very confusing if there were no extensions. As for depending on > the name of the folder for that type of information, I just discovered that > a month ago I misfiled a few PDF's in a folder that is not intended to > contain any such files. I only found them by accident when I was looking > for something else. Oh, remember OS/2 Warp? > > On Thu, Apr 21, 2022 at 12:26 PM Bert Riding wrote: > >> On Thu, 21 Apr 2022 18:08:47 +0100 >> Chris Green wrote: >> >>> On Thu, Apr 21, 2022 at 06:54:11PM +0200, Geert Janssens wrote: >>>> Op donderdag 21 april 2022 16:36:36 CEST schreef Bert Riding: >>>>> On Thu, 21 Apr 2022 08:45:20 +0100 >>>>> >>>>> Chris Green wrote: >>>>>> On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote: >>>>>>>> On Apr 20, 2022, at 1:58 AM, Liz wrote: >>>>>>>> >>>>>>>> On Wed, 20 Apr 2022 09:02:16 +0100 >>>>>>>> >>>>>>>> Chris Green wrote: >>>>>>>>> On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins >>>>>>>>> wrote: >>>>>>>>>>> 1. Is there any way to get GnuCash to save its file, by >>>>>>>>>>> default, with an appropriate suffix other than >>>>>>>>>>> "gnucash?" >>>>>>>>>> >>>>>>>>>> Sure, tell it to do that. It only adds ".gnucash" by >>>>>>>>>> default, but it won't override what you tell it. >>>>>>>>> >>>>>>>>> Where do you tell it that? >>>>>>>> >>>>>>>> "Save As" in the menu should do it. >>>>>>> >>>>>>> Be careful to switch back to the "primary" file after doing >>>>>>> that, otherwise the primary will become the snapshot and new >>>>>>> work will go into the new file. >>>>>> >>>>>> But that's the ultimate aim! :- >>>>>> >>>>>> Instead of having the long, clumsy, "gnucash" suffix one wants >>>>>> something tidier like "gc". >>>>>> >>>>>> Remember on Linux the whole filename is always displayed so all >>>>>> those "gnucash" suffixes get a bit wearing after a while. >>>>> >>>>> In my experience gnucash doesn't care what your data file is >>>>> called, with or without any suffix you care to use. Personally I >>>>> use n
Re: [GNC] Quotes issue
> On Apr 17, 2022, at 9:24 AM, john wrote:
>
>
>
>> On Apr 17, 2022, at 8:07 AM, Steve wrote:
>>
>> On Sat, 16 Apr 2022 19:48:52 -0700
>> john wrote:
>>
>>>> On Apr 16, 2022, at 9:47 AM, Steve wrote:
>>>>
>>>> I'm getting this error:
>>>>
>>>> steve@stevesdesktop:~$ gnc-fq-check
>>>> Json3.c: loadable library and perl binaries are mismatched (got
>>>> handshake key 0xce00080, needed 0xed00080)
>>>>
>>>> But...
>>>> steve@stevesdesktop:~$ sudo find /usr -name "libperl.so*" -exec ls
>>>> -lah {} \; 2>/dev/null -rw-r--r-- 1 root root 3.6M Sep 24 2021
>>>> /usr/lib/x86_64-linux-gnu/libperl.so.5.32.1 lrwxrwxrwx 1 root root
>>>> 17 Sep 24 2021 /usr/lib/x86_64-linux-gnu/libperl.so.5.32 ->
>>>> libperl.so.5.32.1
>>>>
>>>> steve@stevesdesktop:~$ perl --version
>>>>
>>>> This is perl 5, version 32, subversion 1 (v5.32.1) built for
>>>> x86_64-linux-gnu-thread-multi (with 47 registered patches, see perl
>>>> -V for more detail)
>>>>
>>>> So why does gnc-fq-check think there is a mismatch?
>>>
>>> As a first guess your perl json module is linked to a different
>>> version of libjson than the one you have. If you used gnc-fq-update
>>> to set up Finance::Quote then running it again should fix the
>>> problem. If you installed F::Q from your distro's package manager and
>>> there aren't any updates then the packager for that module is running
>>> a bit behind, a common problem for most distros since they rely on
>>> volunteers.
>>>
>>
>> steve@stevesdesktop:~/Downloads$ sudo gnc-fq-update
>> Reading '/root/.cpan/Metadata'
>> Database was generated on Sun, 17 Apr 2022 00:17:02 GMT
>> Date::Manip is up to date (6.86).
>> Finance::Quote is up to date (1.51).
>>
>> (update done here)
>>
>> steve@stevesdesktop:~/Downloads$ sudo apt-get upgrade
>> Reading package lists... Done
>> Building dependency tree... Done
>> Reading state information... Done
>> Calculating upgrade... Done
>> The following packages have been kept back:
>> qdbus
>> 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
>>
>> steve@stevesdesktop:~/Downloads$ dpkg -l | egrep -i 'perl.*json|json.*perl'
>> ii libjson-parse-perl 0.61-1
>> amd64module to read JSON into a Perl variable
>> ii libjson-perl 4.03000-1
>> all module for manipulating JSON-formatted data
>> ii libjson-xs-perl4.030-1+b1
>> amd64module for manipulating JSON-formatted data
>> (C/XS-accelerated)
>>
>> So am I right in thinking that the 4.030 versions are the problem? If
>> so, I'll have to contact the maintainers.
>
> Please remember to copy the list on all replies.
>
> libjson-xs-perl is probably the mismatched library. briefly explains the
> nature of the problem. Before you can blame the Debian packager (the
> libjson-xs-perl maintainer is innocent) for upgrading perl without upgrading
> all of the packages you need to be sure that that's the only instance of
> libjson-xs-perl on your system. If there's another one earlier in perl's
> include path it might be the mismatched library. Have you ever run
> gnc-fq-update or used cpan directly on this machine?
I forgot to paste in the URI that explains the problem. It's
https://foursixnine.io/blog/2019/01/21/perl-binaries-are-mismatched.html
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 4,10 Defective Net Worth Line Chart
> On Apr 7, 2022, at 3:17 PM, Tommy Trussell wrote: > > On Tue, Apr 5, 2022 at 11:34 AM john wrote: > Can you make sure that you have a clean 4.10 install from flathub? All of > those warnings about stale .go files suggests that you don't. > > All the warnings about the source being newer than the compiled .go files is > an artifact of a flatpak issue. Just in case some other folks run into this, > I believe Geert patched the flatpak builder to work around this problem back > in 2019. Some flatpak installations (Ubuntu and derivatives, maybe?) report > weird file modification times. Some (Fedora and derivatives?) don't. > > See https://github.com/flathub/org.gnucash.GnuCash/issues/24 > > Maybe it will be fixed in a future release of flatpak. > > On Wed, Apr 6, 2022 at 8:04 AM David G. Pickett via gnucash-user > wrote: > > I suppose there is a way for flatpak to remove it and reinstall it. > > If you need to reinstall gnucash, you can use the --reinstall flag, which > will remove and replace it with the latest downloaded version: > > $ flatpak install --reinstall org.gnucash.GnuCash > > but I confirmed -- reinstalling does NOT eliminate the "source newer than > compiled" errors (at least not on Ubuntu 21.10). > Tommy, Do *you* have any problems displaying reports on the 4.10 flatpak? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports No Longer Work
Please remember to copy the list on all replies. I just realized that you're using flathub and GnuCash 4.9, so it's definitely the WebKit problem, https://bugs.gnucash.org/show_bug.cgi?id=798486. Just get the new 4.10 from flathub and you should be back in business. Regards, John Ralls > > > On Mar 31, 2022, at 2:13 PM, Steve Isenberg wrote: > > On second thought if I did this correctly: > > $ gtk-launch --version > results in 3.24.30 > > > Steve > > > On Thursday, March 31, 2022, 05:09:00 PM EDT, Steve Isenberg > wrote: > > > John, thanks for writing back directly. > > Sorry, but I don't know how to check the version of webkit or set the > environment variable as described below. > > Can you provide some help with setting this: WEBKIT_DISABLE_COMPOSITING_MODE=1 > > Thanks again > > Steve > > > On Thursday, March 31, 2022, 04:25:47 PM EDT, John Ralls > wrote: > > > > > > On Mar 31, 2022, at 1:11 PM, Steve Isenberg via gnucash-user > > wrote: > > > > No reports work. None of my saved reports display info. Nothing from the > > menu displays info. Even reports I never run display nothing. > > > > Every report, saved or otherwise, displays a blank report screen. No errors > > or warning. > > > > System 76: Pop!_OS 21.10Gnome Version: 40.4.0 > > GnuCash Version: 4.9Build ID: Flathub 4.9-2Finance::Quote: 1.49 > > Custom report file appears correct: > > /home/xx/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8 > > All was working last week. There were some system updates this week, a > > Gnome update as well, but I cannot say what was specifically updated. > > Otherwise, the system is current with updates as of today. > > > > It's tax time here in the states. How do I fix this ASAP? > > > Was one of the updates for webkit2gtk-4.0 to version 2.26.0? They changed a > default that breaks the way GnuCash renders reports. The work-around is to > set WEBKIT_DISABLE_COMPOSITING_MODE=1 in the environment before running > GnuCash. > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports No Longer Work
> On Mar 31, 2022, at 1:11 PM, Steve Isenberg via gnucash-user > wrote: > > No reports work. None of my saved reports display info. Nothing from the menu > displays info. Even reports I never run display nothing. > > Every report, saved or otherwise, displays a blank report screen. No errors > or warning. > > System 76: Pop!_OS 21.10Gnome Version: 40.4.0 > GnuCash Version: 4.9Build ID: Flathub 4.9-2Finance::Quote: 1.49 > Custom report file appears correct: > /home/xx/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8 > All was working last week. There were some system updates this week, a Gnome > update as well, but I cannot say what was specifically updated. Otherwise, > the system is current with updates as of today. > > It's tax time here in the states. How do I fix this ASAP? Was one of the updates for webkit2gtk-4.0 to version 2.26.0? They changed a default that breaks the way GnuCash renders reports. The work-around is to set WEBKIT_DISABLE_COMPOSITING_MODE=1 in the environment before running GnuCash. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Customizing invoices (Helmut Eller
> On Mar 29, 2022, at 10:33 AM, Adrien Monteleone > wrote: > > The report should simply print the data from the invoice unchanged. Be careful what you ask for. The data from the invoice is a rational number, meaning a numerator and a denominator. The print routine will print that as an integer plus a fraction. Remember all of the complaining a few years ago when the price editor showed numbers like 123 + 45/6789? Do you *really* want your invoices to look like that? Or were you thinking "unchanged" means in decimal form but with no rounding? So if you have say 1/3 your printer keeps printing pages full of '3' until it runs out of paper? ;-) There's a preference for force prices to decimal. If that's set then prices displayed in the Price Database window and the register are rounded to 1/100th of the smallest currency unit in which the price is denominated. For most currencies that's two decimal places so prices are displayed with four. The same could be applied to invoices and other reports. I'd think amounts on invoices should be in some integer multiple of the commodity's smallest fraction traded--that's a property of the commodity that you set in the New/Edit Security dialog--and should display as a decimal with the appropriate number of places if the fraction's denominator is a power of 10 or a rational number if not. Does that seem reasonable? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] GnuCash 4.10 Documentation and All-in-one Bundles
I've uploaded Gnucash-Intel-4.10-3.dmg that should have the icons back. Regards, John Ralls > On Mar 29, 2022, at 3:12 AM, Robert Kesterson wrote: > > Confirmed working here also, and also missing those icons. The buttons and > text are there and work fine, though, so it’s not impacting usability. > > On 28 Mar 2022, at 23:59, David H wrote: > >> Thanks John, working on both Monterey and Big Sur now. Sorry to be the >> bearer of bad news but unfortunately now the first 7 icons no longer show >> up for Save / Close / Duplicate / Delete / Enter / Cancel / Blank and the >> last one for Reconcile, although the Split / Jump / Schedule / Transfer >> icons are there. >> >> Thanks also to you and the other GnuCash Developers / Translators / etc for >> all the hard work you put in on Gnucash which is a great product that I use >> daily and couldn't do without any more. >> >> Thanks David H. >> >> On Tue, 29 Mar 2022 at 13:23, John Ralls wrote: >> >>> There was a problem with building the documentation caused by a bad merge >>> of the updated Portuguese translation of the Tutorial and Concept Guide, >>> resulting in the macOS and Windows all-in-one bundles to have only the >>> Portuguese translation. >>> >>> There were also some Gtk bugs in the macOS bundle. >>> >>> Consequently we have a re-release of the documentation as 4.10.1 and >>> updated bundles, gnucash-4.10-1.setup.exe and Gnucash-Intel-4.10-2.dmg. The >>> sha-256 hashes are: >>> >>> f9e27ce70b3a198f3766a598287c8f31d372ec7f19db251463d36895104fe0c7 >>> gnucash-4.10-1.setup.exe >>> 6fc79d00c292e8672485207d0f4d04918efd9af63142695db8ec113d3e398aa6 >>> Gnucash-Intel-4.10-2.dmg >>> 8f81dfbf13a49ec0ab676a82f8dde5b364658528df2ac41372d1e0fb68a8c231 >>> gnucash-docs-4.10.1.tar.gz >>> >>> Sourceforge Links: >>> >>> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-4.10-1.setup.exe/download >>> >>> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/Gnucash-Intel-4.10-2.dmg/download >>> >>> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-docs-4.10.1.tar.gz/download >>> >>> Github Links: >>> >>> https://github.com/Gnucash/gnucash/releases/download/4.10/gnucash-4.10-1.setup.exe >>> >>> https://github.com/Gnucash/gnucash/releases/download/4.10/Gnucash-Intel-4.10-2.dmg >>> >>> https://github.com/Gnucash/gnucash/releases/download/4.10/gnucash-docs-4.10.1.tar.gz >>> >>> Regards, >>> John Ralls >>> >>> ___ >>> gnucash-devel mailing list >>> gnucash-de...@gnucash.org >>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 4.10 Documentation and All-in-one Bundles
There was a problem with building the documentation caused by a bad merge of the updated Portuguese translation of the Tutorial and Concept Guide, resulting in the macOS and Windows all-in-one bundles to have only the Portuguese translation. There were also some Gtk bugs in the macOS bundle. Consequently we have a re-release of the documentation as 4.10.1 and updated bundles, gnucash-4.10-1.setup.exe and Gnucash-Intel-4.10-2.dmg. The sha-256 hashes are: f9e27ce70b3a198f3766a598287c8f31d372ec7f19db251463d36895104fe0c7 gnucash-4.10-1.setup.exe 6fc79d00c292e8672485207d0f4d04918efd9af63142695db8ec113d3e398aa6 Gnucash-Intel-4.10-2.dmg 8f81dfbf13a49ec0ab676a82f8dde5b364658528df2ac41372d1e0fb68a8c231 gnucash-docs-4.10.1.tar.gz Sourceforge Links: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-4.10-1.setup.exe/download https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/Gnucash-Intel-4.10-2.dmg/download https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-docs-4.10.1.tar.gz/download Github Links: https://github.com/Gnucash/gnucash/releases/download/4.10/gnucash-4.10-1.setup.exe https://github.com/Gnucash/gnucash/releases/download/4.10/Gnucash-Intel-4.10-2.dmg https://github.com/Gnucash/gnucash/releases/download/4.10/gnucash-docs-4.10.1.tar.gz 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 4.10 cannot be opened on macOS Big Sur w/Apple Silicon
David, that's https://bugs.gnucash.org/show_bug.cgi?id=798490. It turned out to be a change in Glib to stop using an internal build of libprce (Perl-compatible regular expressions) and when I added the external one as a dependency I didn't realize that Unicode support wasn't the default. I'll have a new dmg up in a couple of hours that will take care of both problems. Regards, John Ralls > On Mar 28, 2022, at 1:03 PM, David H wrote: > > John, > > FYI it doesn't work for me on Monterey on an Intel based MacBook Pro. It > opens at least but when adding a new txn as soon as I type a single letter in > the description Gnucash just disappears entirely :-( On Big Sur it doesn't > open just displays the error message reported by others. > > Cheers David H. > > > On Tue, 29 Mar 2022 at 03:33, john wrote: > This has been reported as https://bugs.gnucash.org/show_bug.cgi?id=798489 > <https://bugs.gnucash.org/show_bug.cgi?id=798489> > He's using Gnucash.app Sourceforge or Github, note the > /Applications/Gnucash.app.. paths. He just happens to also have MacPorts > installed. > > @executable_path is a Mac linker feature that creates paths relative to the > running executable, in this case > /Applications/Gnucash.app/Contents/MacOS/Gnucash. .. means to back up one > level, so @executable_path/../Resources//lib/libcairo-gobject.2.dylib tells > the linker to look at > /Applications/Gnucash.app/Contents/Resources/lib/libcairo-gobject.2.dylib. > It's not linking the MacPorts version of libcairo-gobject.2.dylib. > > The error message is quite clear: "Incompatible library version: > libgtkmacintegration-gtk3.4.dylib requires version 11603.0.0 or later, but > libcairo-gobject.2.dylib provides version 2.0.0" and your otool checks bear > that out: (compatibility version 2.0.0, current version 2.0.0) vs. > (compatibility version 11603.0.0, current version 11603.0.0). The linker > would be happy if it was able to find the MacPorts libcairo-gobject, because > ((compatibility version 11707.0.0, current version 11707.0.0): 11707 > 11603, > but 2 isn't. > > It's strange that it works on Monterey, not that it fails on BigSur (and > earlier, as the bug reporter is using Catalina and another poster here is > using Mojave). > > Regards, > John Ralls > > > > > On Mar 28, 2022, at 9:51 AM, William Prescott wrote: > > > > Are you installing it with MacPorts? Or from the .dmg file on SourceForge? > > > > https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/Gnucash-Intel-4.10-1.dmg/download > > > > <https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.10/Gnucash-Intel-4.10-1.dmg/download> > > > > Will > > > > On 2022 Mar 28, at 03-28 10:33:09, John W. O'Brien via gnucash-user > > wrote: > > > > It looks like this might be a bad interaction with software installed via > > MacPorts, but I don't understand the versioning and dynamic loader well > > enough to be sure or to do anything about it. > > > > $ otool -L > > /Applications/Gnucash.app/Contents/Resources/lib/libcairo-gobject.2.dylib | > > grep libcairo-gobject > > /Applications/Gnucash.app/Contents/Resources/lib/libcairo-gobject.2.dylib: > > @executable_path/../Resources//lib/libcairo-gobject.2.dylib > > (compatibility version 2.0.0, current version 2.0.0) > > $ otool -L /opt/local/lib/libcairo-gobject.2.dylib | grep libcairo-gobject > > /opt/local/lib/libcairo-gobject.2.dylib: > > /opt/local/lib/libcairo-gobject.2.dylib (compatibility version > > 11707.0.0, current version 11707.0.0) > > $ otool -L > > /Applications/Gnucash.app/Contents/Resources/lib/libgtkmacintegration-gtk3.4.dylib > > | grep libcairo-gobje > > ct > > @executable_path/../Resources/lib/libcairo-gobject.2.dylib > > (compatibility version 11603.0.0, current version 11603.0.0) > > > > On 3/28/22 10:25, William Prescott wrote: > >> It ran fine on my MacBookPro M1 Max with Monterey. > >> Will > >> On 2022 Mar 28, at 03-28 08:03:09, John W. O'Brien via gnucash-user > >> wrote: > >> Good morning all, > >> Congratulations on the new release. > >> I am unable to run the new 4.10 on my MacBook Air (M1, 2020) with Big Sur > >> (11.6.5). 4.9 has been running fine, as recently as this morning. > >> The essence of the crash log is: > >> > >> Termination Reason:DYLD, [0x3] Wrong version > >> Application Specific Information: > >> dyld: launch, loading dependent libraries > >> Dyld Error Message: > >>
[GNC] ANNOUNCE: GnuCash 4.10 Released
The GnuCash development team announces GnuCash 4.10, the eleventh release in
the stable 4.x series
Between 4.9 and 4.10, the following bugfixes were accomplished:
Bug 684507 - commodity namespace should be localized
Bug 741674 - Newly created Scheduled Transactions appear in existing search
windows
Bug 797501 - Currency symbols in Hebrew (RTL) language
Bug 797772 - Allow reconciliation report to double filter by both posting
and reconciliation date
Bug 798164 - Import transaction window does not allow changing the
transaction description.
Bug 798272 - up/down arrow keys do not work in account selection pop-up
Bug 798375 - Transfer Account Selection not editable after typing error
Bug 798386 - Cannot increment date by 1 day with Japanese keyboard.Allow
';' to increment the date because on those keyboards + is shift-;.
Bug 798391 -OFX import routine keeps prompting for accepted (and
reconciled) transactions when imported again
Bug 797610 - Scrolling is too fast to follow
Bug 798392 - Reports do not display when Reports JavaScript dependencies
are located at a filepath that includes special characters like hash ("#")
Bug 798395 - ofxdirectconnect downloads crash gnucash 4.9
Bug 798408 - The calculation in budgets UI and reports are wrong.
Bug 798411 - Untranslated/Unused string [pt only]
Bug 798415 - Due Bills Reminder Dialog - Right align 'amount'This was a
right-to-left language (e.g. Hebrew) problem.
Bug 798435 - Crash on print after printing checks
Bug 798438 - on reconcile window, click on the last column 'R' does not
order the entries according with the status
Bug 798448 - Column 'num' cannot be null
Bug 798458 - Build failure with gcc 12
Bug 798474 - Windows 10: Mouse scroll wheel on register only scrolls 1
pixel at a time (instead of 1 line at a time)
The following fixes and improvements were not associated with bug reports:
Added a BETA Stock Transaction Assistant to help create a variety of
securities transactions. To try it out start GnuCash with the --extra option,
open a stock-type register, and select Actions>Stock Assistant. Please note any
issues on Bug 798004.
Remove the hard-coded default namespaces"AMEX", "NASDAQ", "NYSE", "EUREX",
and "FUND" from the New Security dialog. These namespaces were added to the
list of existing namespaces; it was necessary to create a commodity that used
one of them to make that one an actual namespace, so users who have commodities
in e.g. the namespace NYSE will still see that namespace in the selection list.
Reasoning: The list was necessarily incomplete and confused new users.
Fixed the Income Statement report table formating so that all sections get
laid out to the same width.
[Python Bindings]Implement some comparison and arithmetic operators for
GncNumeric
Budgets are sensitive to readonly status
Disable some budget features if book is readonly
Fix suppression of "cut split/transaction" warnings for the current session
These were not working because they were missing from the temporary
warnings settings schema. The warnings could only be dismissed permanently. Add
them to the temporary warnings section of the settings schema.
Currencies in several locations not displayed correctly for Hebrew
[category-barchart] Added option to show ratios
[html-chart] Add format style option for numbers
Better wording for tax table changed info message.
[register] Checkbox any value other than 0x20 (ASCII space) is true,
because it can be X or U+2716 now and could be something else in future. Fixes
in particular the disappearing tax-included and tax-table in the Invoice/Bill
entry register.
[Python Bindings]Provide the complete set of QOF enums in gnucash
[Pyton Bindings]Provide wrapper for qof numeric predicate
Python bindings already have some wrapping objects for qof predicates. This
adds the one missing for GncNumeric comparisons. Additionally fixes a wrong
number for QOF_NUMERIC_MATCH_ANY in example file.
Remove commodity-table.scm, no longer required after adjusting
qif-dialog-utils
Preferences, Import: UPDATE AND RECONCILE should be UPDATE AND CLEAR on
preference "Enable update match action" tooltip text.
[register] Enable horizontal scrolling with a touchpad.
[business]Add diagnostic messages to GncEntry and GncInvoice.
Replace code style guidance with reference to the wiki Coding Standard page.
Update Form/Schedule line references for 2021 for the US Income Tax Report
Update the register help label when cell read only
Change AR/AP Type cell to be read only. The Type cell in AR/AP registers
should not be changeable from the register so make the cell read only.
Tip-of-the-Day, new tip: the full file path is shown in the status bar.
[assistant-qif-import] Prevent ambiguous mnemonic
Mnemonic N clashes with GtkAssistant "Next". Change to D which
Re: [GNC] change default behavior of ctrl-PgDn
Since when is control-page down the "official key combo"? See https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html#txns-register-oview, section 2.9.2.4 Using Entry Shortcuts: " • To move around the register, use these keys to save time: • Tab to move to the next field, Shift+Tab to move to the previous field • Home to move to the beginning of the field, End to move to the end of the field • Enter or ↓ to move to the next transaction, ↑ to move to the previous transaction • Page Up to move up one screen, Page Down to move down one screen • Shift+Page Up to go to the first transaction, Shift+Page Down to go to the last transaction " Regards, John Ralls > On Mar 25, 2022, at 10:37 AM, Adrien Monteleone > wrote: > > Indeed, shift-fn-down_arrow drops me to a blank transaction with the focus on > the date field. Thanks! > > I still think it a bug that the official key combo doesn't work properly. I > thought one was filed already but can't seem to find it. > > Note, it isn't just the key combo not working. Using Action > Blank > Transaction also takes you to the first Action Field rather than the date > field. So it is the underlying function that doesn't work. > > Regards, > Adrien > > On 3/25/22 6:25 AM, Michael Hendry wrote: >> Having not investigated a quick way of getting to a new blank transaction >> before, Ive done some experimenting on my iMac (GNC 4.9 + Big Sur). >> fn-uptriangleTop of current register screen >> fn-downtriangle Bottom of current register screen >> Shift-fn-uptriangle Earliest transaction in register >> Shift-fn-downtriangleBottom of current register, blank transaction >> If I use the extra cluster of nine keys on the wide keyboard: >> Shift-uparrowEarliest transaction in register >> Shift-downarrow Bottom of current register, blank transaction >> All I have to do now is remember these the next time I need them! > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report - Income Statement - Layout problem
I can't reproduce that here. Does that happen with all of the stylesheets? Have you perhaps modified the Technicolor stylesheet so that the Revenue block is smaller than the Expenses one? Regards, John Ralls > On Mar 20, 2022, at 9:51 AM, Carl-Kensaku HERBORT wrote: > > Hello, > > The effective nesting level is the same. > > No, I don't need an option to justify columns. I just need the income > statement report to look as normal as the balance sheet report (see screen > capture). > > I really don't need anything more. > > Have a nice week-end > > Best regards > > -- > Carl-Kensaku HERBORT > DIGIENE > Case postale > CH-1002 Lausanne > Suisse > > +41 (0) 21 320 22 66 > > Le 20.03.22 à 16:27, Michael or Penny Novack a écrit : >> On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote: >>> Hello again, >>> >>> I have tried a more recent version on MacOS (Version 4.9 / build ID >>> 4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of string >>> translation. >>> >>> But the second problem is still there: the width and column alignment of >>> the revenue part is not synchronized with those of the expense part. >>> >>> Do you have any ideas ? >> You did not say is the effective nesting level of income and expense >> the same? >> Even if so, the resulting report would not be what I wanted in a report in >> the final form I would be presenting to the board at meetings or having >> published in an annual report << I used to be treasurer of some 501(c)3 >> organizations and used gnucash to keep the books >> >> I suspect that what you want (from the developers) is an option to "justify >> columns from the right". That's what I would have in the "finished product" >> reports. In the case of the Income Statement (Statement of Revenues and >> Expenses --- what a non-profit calls this report) but also with Balance >> Sheet reports. Instead of writing custom reports* I export and then edit >> with full control over the level of detail in different parts, column >> alignment, etc. and can add annotation as needed. There is a lot of detail >> work** in producing a "pretty print" report. >> Michael D Novack >> * I am a retired pro. While not fluent in the language used to create the >> reports, I can at least read LISP and so soon could be << when you have >> written in half a dozen languages, what's one more >> But the first time >> this came up, I was advised not to bother, just export raw reports and edit >> to the finished product. Great editors already exist so why try to reinvent >> the wheel. >> ** For example, page breaks. You don't want them at an awkward place in the >> report so might want to insert some blank lines to prevent that. You might >> want top levels or total lines a different font size or bold, et. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > <2022-03-18-11h36-gnucash-balance-sheet-report.png><2022-03-18-11h37-gnucash-income-statement-report.png>___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] getting Online_Quotes to work on MacOS
> On Feb 11, 2022, at 1:22 PM, coolnodje wrote: > > Hi, > > I was just following the Online_Quotes doc, installing Finance::Quote and > trying to get some quotes. > > I've been doing: > > ➜ bin sudo ./gnc-fq-update > > [...] > > All tests successful. > Files=56, Tests=82, 4 wallclock secs ( 0.06 usr 0.06 sys + 3.38 cusr 0.51 > csys = 4.01 CPU) > Result: PASS > BPSCHUCK/Finance-Quote-1.51.tar.gz > Tests succeeded but one dependency not OK (Test::Perl::Critic) > BPSCHUCK/Finance-Quote-1.51.tar.gz > [dependencies] -- NA > ➜ bin ./gnc-fq-check > > You need to install the following Perl modules: > Finance::Quote > > Use your system's package manager to install them, > or run 'gnc-fq-update' as root. > missing-lib > ➜ bin > > I'm not too sure why Finance::Quote isn't found after an install. > Relaunching my terminal trying in a fresh shell doesn't make any difference. > > I'm using zsh on latest MacOS, have setup ALPHAVANTAGE_API_KEYin Gnucash GUI > preference and in .zshrc. Maybe because Finance::Quote's install failed, indicated by "Tests succeeded but one dependency not OK (Test::Perl::Critic)" The workaround is to run sudo cpan -f -i B::Keywords then run gnc-fq-update again. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))
Dennis, Please remember to copy the list on all replies. No, "internal server error" indicates that something went wrong on Alphavantage's end. Try again after a few minutes or using yahoo_json instead: Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json XOM Regards, John Ralls > On Feb 11, 2022, at 1:38 PM, smad...@hotmail.com wrote: > > John, > > Ran gnc-fq-check. Version 1.51 no errors. The example in Wiki showed an > error message about a missing Mozilla/CA.pm. Since no error I didn’t run > Mozilla::CA update figuring I had certificates and that wasn’t the current > problem. > Ran gnc-fq-dump for stock XOM with result indicating the Alphavantage key was > missing: > > dwa1@dwa1 ~ % /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v > alphavantage XOM > ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and > stock quotes with source 'alphavantage' or 'vanguard'; see > https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US > dwa1@dwa1 ~ % > > However, in checking GC Preferences, Online quotes, the Alpha Vantage API Key > is there. So I tried using it in the Helper dump script per the WIKI: > “ALPHAVANTAGE_API_KEY= > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage > XOM” with the following Terminal results: > > dwa1@dwa1 ~ % ALPHAVANTAGE_API_KEY= > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage > XOM > Finance::Quote fields Gnucash uses: > symbol: XOM (deduced)<=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: **missing** <=\ >nav: **missing** <=== one of these > price: **missing** <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > All fields returned by Finance::Quote for stock XOM > > stock field value > - - - > XOM errormsg: Internal Server Error > XOM last: **missing** > XOM nav: **missing** > XOM price: **missing** > XOM success: 0 > > dwa1@dwa1 ~ % > > So even though I have the Alphavantage key in place, it is somehow not being > seen and appears to be the current problem. > > Thanks > > > john jralls at ceridwen.us > Fri Feb 11 00:01:27 EST 2022 > > • Previous message (by thread): [GNC] No Stock Quotes - OS Monterey, > Gnucash 4.8(Build ID: 4.8a+(2021-09-28)) > • Next message (by thread): [GNC] Settings in environment.local does > not work > • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] > Dennis, > > You can examine the running processes in /Applications/Utilities/Actiivity > Monitor and kill them from there, or you can just nuke the lot with > sudo killall cpan > if you're reasonably sure that there shouldn't be any left running. > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings in environment.local does not work
Please remember to copy the list on all replies. Did you remember to lead off the environment.local file with the section heading [Variables] ? Regards, John Ralls > On Feb 10, 2022, at 5:52 PM, redfrog2...@outlook.com wrote: > > Mr. Ralls, > > Hello! I would like to change GnuCash's display language to English. > However, > it remains to be system's language (Chinese) after I change environment.local. > It has only changed after I changed the main configuration file: environment. > By the way, I am using Gnucash version: 4.9 (2021-12-18) on Windows 10 > 21H2 > > Yours, > > Bite Gao > Feb 11th, 2021 > > --- > > From: john > Date: 2022-02-11 01:34 > To: redfrog2000 > CC: gnucash-user > Subject: Re: [GNC] Settings in environment.local does not work > > > > > On Feb 9, 2022, at 9:07 PM, redfrog2...@outlook.com wrote: >> >> Gnucash Developers & Maintainers: >> >> Hello! I am a Chinese user of your product. Recently, I have changed >> language settings, and placed them in my custom environment.local file. >> However, I found that display language in gnucash are still not changed. >> Could you please help me solving this problem? >> >> Yours, >> >> Bite Gao >> Jan 28th, 2022 >> >> Attachment: >> content in environment.local: >> # Gnucash's language settings: >> LANG=zh_CN >> LANGUAGE=en_US > > > > > > > > Hi, > > > > With those settings I'd expect that GnuCash would display the UI in English. > Is that not what you're seeing? What operating system are you using and what > version of GnuCash is this? > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))
Dennis, Very good, almost there. The only problem is the failed test in B::Keywords, which you can work around with sudo cpan -f -i B::Keywords and then re-run sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update Regards, John Ralls > On Feb 10, 2022, at 4:14 PM, dennis adams wrote: > > John, decided to give “Xcode-select —install” another try since seemed > problem was lack of CLTs. It installed in an hour so don’t know what the 215 > hrs was about last night. I then ran > “/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update” without sudo > and ended up with 330 pdf pages of terminal dump. I then ran it again with > sudo and have attached the terminal info from that command. I then ran the > check and got the following: > > dwa1@dwa1 ~ % /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check > > You need to install the following Perl modules: > Finance::Quote > > Use your system's package manager to install them, > or run 'gnc-fq-update' as root. > missing-lib > dwa1@dwa1 ~ % > > The terminal dump seems to indicate several prerequisites and dependencies > are not installed. Says to install modules but not sure how to do that. > Thanks > > > >> On Feb 10, 2022, at 15:50, John Ralls wrote: >> >> Dennis, >> >> Progress, I guess. >> >> Yes, $PATH is typed verbatim. You did that part right. >> >> You probably need to run gnc-fq-update and friends with the full path, e.g. >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check >> gnc-fq-update usually requires sudo in front of it >> sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update >> because it wants to write to your system perl directories. >> >> Regards, >> John Ralls >> >>> On Feb 10, 2022, at 1:40 PM, smad...@hotmail.com wrote: >>> >>> John, again thanks. Yes, the obvious is not obvious to me as I am a user >>> and much beyond that I am lost, especially with doing terminal commands. I >>> love using GC and it works great until MAC or sometimes GC updates and >>> there are problems which I try to find solutions to in the Archives. But >>> when I don’t, I ask for help but again am not that coding or terminal >>> savvy. I do try though and appreciate all the help and patience you all >>> provide. >>> >>> I ran the “sudo xcode-select -s /Applications/Xcode.app” command and the >>> check which is below and seems to be correct. >>> >>> Last login: Thu Feb 10 12:58:28 on ttys000 >>> dwa1@dwa1 ~ % sudo xcode-select -s /Applications/Xcode.app >>> Password: >>> dwa1@dwa1 ~ % xcode-select -p >>> /Applications/Xcode.app/Contents/Developer >>> dwa1@dwa1 ~ % >>> >>> I then ran “export >>> PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH” which >>> resulted in the “dquote>” prompt. Here again, I am not sure if I am >>> supposed to substitute something for $PATH or not or if that is the >>> command. At the “dquote>” prompt, I typed in “gnc-fq-update” which just >>> went to the “dquote>” prompt again without updating FQ. Is gnc-fq-update >>> the command or am I supposed to type something in front of gnc-fq-update? >>> >>> dwa1@dwa1 ~ % export >>> PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH" >>> dquote> gnc-fq-update >>> dquote> >>> >>> In an earlier e-mail you stated: >>> >>> /usr/bin is right where you'd expect it, but you can't see it with Finder, >>> only from the terminal. For example you can type >>> ls -l /usr/bin/make >>> and if it's there get back something like >>> -rwxr-xr-x 1 root wheel 167088 Dec 7 15:39 /usr/bin/make* >>> >>> When I ran”ls -1 /user/bin/make” and “ls -1 /user/bin/xcrun” I got back >>> “root wheel 167072 Jan 22 00:42 /usr/bin/make” and “root wheel 166544 Jan >>> 22 00:42 /usr/bin/xcrun” From that I thought I had “make” and “xcrun” but >>> neither of the responses had the “-rwxr-xr-x” before the “1 root—-“ as in >>> your result. Since I am missing the “-rwxr-xr-x”, does that mean I don’t >>> have “make” and “xcrun” installed? >>> >>> Again, I appreciate your help and patience and am sorry it is taking so >>> long to understand this. >>> >>> >>> >>> >>>> On Feb 10, 2022, at 12:43, John Ralls wrote: >>>> >>>> Dennis, >>>> >>>>
Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))
Dennis, Progress, I guess. Yes, $PATH is typed verbatim. You did that part right. You probably need to run gnc-fq-update and friends with the full path, e.g. /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check gnc-fq-update usually requires sudo in front of it sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update because it wants to write to your system perl directories. Regards, John Ralls > On Feb 10, 2022, at 1:40 PM, smad...@hotmail.com wrote: > > John, again thanks. Yes, the obvious is not obvious to me as I am a user and > much beyond that I am lost, especially with doing terminal commands. I love > using GC and it works great until MAC or sometimes GC updates and there are > problems which I try to find solutions to in the Archives. But when I don’t, > I ask for help but again am not that coding or terminal savvy. I do try > though and appreciate all the help and patience you all provide. > > I ran the “sudo xcode-select -s /Applications/Xcode.app” command and the > check which is below and seems to be correct. > > Last login: Thu Feb 10 12:58:28 on ttys000 > dwa1@dwa1 ~ % sudo xcode-select -s /Applications/Xcode.app > Password: > dwa1@dwa1 ~ % xcode-select -p > /Applications/Xcode.app/Contents/Developer > dwa1@dwa1 ~ % > > I then ran “export > PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH” which > resulted in the “dquote>” prompt. Here again, I am not sure if I am supposed > to substitute something for $PATH or not or if that is the command. At the > “dquote>” prompt, I typed in “gnc-fq-update” which just went to the “dquote>” > prompt again without updating FQ. Is gnc-fq-update the command or am I > supposed to type something in front of gnc-fq-update? > > dwa1@dwa1 ~ % export > PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH" > dquote> gnc-fq-update > dquote> > > In an earlier e-mail you stated: > > /usr/bin is right where you'd expect it, but you can't see it with Finder, > only from the terminal. For example you can type > ls -l /usr/bin/make > and if it's there get back something like > -rwxr-xr-x 1 root wheel 167088 Dec 7 15:39 /usr/bin/make* > > When I ran”ls -1 /user/bin/make” and “ls -1 /user/bin/xcrun” I got back “root > wheel 167072 Jan 22 00:42 /usr/bin/make” and “root wheel 166544 Jan 22 00:42 > /usr/bin/xcrun” From that I thought I had “make” and “xcrun” but neither of > the responses had the “-rwxr-xr-x” before the “1 root—-“ as in your result. > Since I am missing the “-rwxr-xr-x”, does that mean I don’t have “make” and > “xcrun” installed? > > Again, I appreciate your help and patience and am sorry it is taking so long > to understand this. > > > > >> On Feb 10, 2022, at 12:43, John Ralls wrote: >> >> Dennis, >> >> I guess you missed the line "making the obvious substitution" right after >> the Xcode-select line, or the substitution isn't that obvious. Since you did >> install it as Xcode.app in /Applications, you'd say >> sudo xcode-select -s /Applications/Xcode.app >> You can check that it worked with >> xcode-select -p >> which should print >> /Applications/Xcode.app/Contents/Developer >> >> No, /Library/Developer/CommandLineTools exists only if you've installed >> command line tools by running >> sudo xcode-select --install >> which you bailed out of because of the long download time. >> >> I dug into /usr/bin/make a bit. It's not make, so it must be an xcrun >> launcher, which if your Xcode-select path is pointed at the uninstalled >> command line tools folder would explain the error messages and of course >> it's finding /usr/bin/make first. I should have recognized that and told you >> export PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH" >> instead. Of course it wouldn't have mattered because of the /Path/to/ >> substitution misunderstanding. >> >> Regards, >> John Ralls >> >> >>> On Feb 10, 2022, at 10:51 AM, smad...@hotmail.com wrote: >>> >>> John, I ran the “ls -l /usr/bin/make” command for “make” and “xcrun” and >>> got the following which I guess says I have both “make” and “xcrun”. >>> >>> Last login: Thu Feb 10 07:21:15 on console >>> >>> dwa1@dwa1 ~ % -rwxr-xr-x 1 dwa1@dwa1 ~ % -rwxr-xr-x 1 dwa1@dwa1 ~ % >>> >>> ls -l /usr/bin/make >>> root wheel 167072 Jan 22 00:42 /usr/bin/make >>> >>> ls -l /usr/bin/xcrun >>> root wheel 166544 Jan 22 00:42 /usr/bin/xcrun >>> >>> One of the erro
Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))
Dennis, I guess you missed the line "making the obvious substitution" right after the Xcode-select line, or the substitution isn't that obvious. Since you did install it as Xcode.app in /Applications, you'd say sudo xcode-select -s /Applications/Xcode.app You can check that it worked with xcode-select -p which should print /Applications/Xcode.app/Contents/Developer No, /Library/Developer/CommandLineTools exists only if you've installed command line tools by running sudo xcode-select --install which you bailed out of because of the long download time. I dug into /usr/bin/make a bit. It's not make, so it must be an xcrun launcher, which if your Xcode-select path is pointed at the uninstalled command line tools folder would explain the error messages and of course it's finding /usr/bin/make first. I should have recognized that and told you export PATH=“/Applications/Xcode.app/Contents/Developer/usr/bin:$PATH" instead. Of course it wouldn't have mattered because of the /Path/to/ substitution misunderstanding. Regards, John Ralls > On Feb 10, 2022, at 10:51 AM, smad...@hotmail.com wrote: > > John, I ran the “ls -l /usr/bin/make” command for “make” and “xcrun” and got > the following which I guess says I have both “make” and “xcrun”. > > Last login: Thu Feb 10 07:21:15 on console > > dwa1@dwa1 ~ % -rwxr-xr-x 1 dwa1@dwa1 ~ % -rwxr-xr-x 1 dwa1@dwa1 ~ % > > ls -l /usr/bin/make > root wheel 167072 Jan 22 00:42 /usr/bin/make > > ls -l /usr/bin/xcrun > root wheel 166544 Jan 22 00:42 /usr/bin/xcrun > > One of the errors at the end of a previous terminal output for > “/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check” was: > > xcrun: error: invalid active developer path > (/Library/Developer/CommandLineTools ), missing xcrun at: > /Library/Developer/CommandLineTools/usr/bin/xcrun > > In Finder, I went to /Library/Developer but there was no “Command Line Tools > folder. I know you said I wouldn’t see /usr/bin with Finder, but shouldn’t > there at least be a Command Line Tools folder under Developer? > > Regarding installation. When I installed Xcode, I let it install where it > wanted to (Applications) without changing the name. I did what you suggested > and ran “sudo xcode-select -s /Path/to Xcode.app” anyway with the following > results: > > dwa1@dwa1 ~ % sudo xcode-select -s /Path/to Xcode.app Password: > xcode-select: error: invalid argument 'Xcode.app' > Usage: xcode-select [options] > > Print or change the path to the active developer directory. This directory > controls which tools are used for the Xcode command line tools (for example, > xcodebuild) as well as the BSD development commands (such as cc and make). > > Options: > -h, --help > -p, --print-path > -s , --switch --install > > developer tools -v, --version -r, --reset > > dwa1@dwa1 ~ % > > print this help message and exit > print the path of the active developer directory set the path for the active > developer directory open a dialog for installation of the command line > > print the xcode-select version > reset to the default command line tools path > > I then tried to run “sudo xcode-select -p —print-path Xcode.app” and got the > same “error: invalid argument ‘Xcode.app’ > > I then ran “export PATH=“$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bin" > and got a “dquote>” prompt. I then typed in “gnc-fq-update”, “sudo > gnc-fq-update’, “run gnc-fq-update” and the full path > “/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check” sequentially, > all with the same result, it just reverted to the “dquote>” prompt. So > apparently, I am not doing this correctly. > > > > > >> On Feb 9, 2022, at 21:51, john wrote: >> >> Your dump looks pretty much llke a rerun of the same problem except that now >> you also have an SSL certificate problem. >> >> /usr/bin is right where you'd expect it, but you can't see it with Finder, >> only from the terminal. For example you can type >>ls -l /usr/bin/make >> and if it's there get back something like >>-rwxr-xr-x 1 root wheel 167088 Dec 7 15:39 /usr/bin/make* >> >> Did you install Xcode in /Applications without messing with the name? If not >> you might try >> sudo xcode-select -s /Path/to Xcode.app >> making the obvious substitution. >> Or, since something seems confused, maybe run that even if you *did* install >> it in /Applications. >> >> Since make is in the Xcode bundle you might be able to work around the >> problem for Finance::Quote with >> export PATH="$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bi
Re: [GNC] Vanguard OFX Access
Kalpesh, If PocketSense downloads OFX files you don't need to do anything with the GnuCash bindings. Just use File>Import>Import OFX/QFX on the downloaded file. Besides, the importers aren't accessible from the python bindings. Regards, John Ralls > On Jan 21, 2022, at 3:08 PM, Kalpesh Patel wrote: > > Sadly Vanguard does not offer OFX formatted download. They only provide QIF, > in one account or individual mutual fund accounts, or CSV format - very > limited formats. Even with QIF format it is a hit or miss in importing to > GNC and CSV formatted requires good deal of post-processing > > > > If you are brave enough and know Python programming, you can try fine free > product call PocketSense > (https://sites.google.com/site/pocketsense/home/msmoneyfixp1) which allows > you to connect to their servers to download OFX formatted file. I hope to > get to GNC Python bindings to see if I can get it to work with (modified) > PocketSense. > > > > > > -- > > > > Message: 6 > > Date: Thu, 20 Jan 2022 21:18:08 -0800 > > From: john mailto:jra...@ceridwen.us> > > > To: Matt Corallo mailto:gcul...@mattcorallo.com> > > > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > Subject: Re: [GNC] Vanguard OFX Access > > Message-ID: <mailto:efb0fd80-c28f-43b2-8c46-54b94393b...@ceridwen.us> > > > Content-Type: text/plain; charset=us-ascii > > > > > > > >> On Jan 20, 2022, at 3:04 PM, Matt Corallo <mailto:gcul...@mattcorallo.com> > wrote: > >> > >> Hi! > >> > >> I'm trying to do an OFX/Quicken DirectConnect connection to Vanguard from > GNUCash. Per a recent discussion on GitHub[1] for this to work, login has to > happen via a URL, which then points to a different URL for transaction and > account requests. In order for the second request to work, the poster there > claims it has to come with a cookie which was returned from the first > request. > >> > >> From what I can tell, there is no way to get GNUCash to make the first > request, take the cookie, and feed it into the second. Am I missing > something or is this a missing feature (or a bug?). > >> > >> I asked on the AQBanking list, but that forum seems to be substantially > less active and less maintained. > >> > > > > You're right. The HTTPS handshake with the cookie is called OFX WebConnect > and AQBanking doesn't support that. Your best option is to download your > transactions as an OFX file from Vanguard's website and import it. > > > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exiting Gnucash Lock file
Kalpesh, That's a medium sized file. >From https://www.sqlite.org/features.html: "* cross-platform: Android, *BSD, >iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are >supported out of the box. Easy to port to other systems." SQLite3 is remarkably stable and widely used. You're already using it in other programs. The SQL backends still create the GnuCash transaction log file. Keep in mind that it only records transactions, not any business module data. Rolling back is why I suggest that you point Windows Backup's File History feature. That only works for SQLite3, BTW: MySQL and Postgresql use more complicated storage mechanisms that make a simple file replacement impractical. There's a remote possibility of corner cases where SQL might not reliably store some data, but nobody has reported one since early in 3.x. Regards, John Ralls > On Jan 21, 2022, at 12:46 PM, Kalpesh Patel wrote: > > Few questions in regards to SQLite3 backend recommendation because currently > XML format for my data is compressed size of 1.82MB so exploring moving to > it. Not sure if this is considered small sized XML file or not but . > > > > 1 - SQLite was natively born on UNIX systems with UNIX systems in mind so > how stable is it for Windows and how well is it supported from the GNC > perspective? > > 2 - Does it still create the log file to be able to replay it like XML > storage creates? > > 3 - How can I roll back transactions (more so related to roll back from > import errors)? With XML I can take the previously created file and make it > my current file after renaming it. > > > > Any other differences to keep in mind other than backup regiment? > > > > > > > > -- > > > > Message: 8 > > Date: Fri, 21 Jan 2022 08:43:04 -0800 > > From: john mailto:jra...@ceridwen.us> > > > To: Thomas Forrester mailto:tlforres...@gmail.com> > > > Cc: Peter mailto:pan...@iinet.net.au> >, gnucash-user > >mailto:gnucash-user@gnucash.org> >> , john.lay...@laymanandlayman.com <mailto:john.lay...@laymanandlayman.com> > > Subject: Re: [GNC] Exiting GnuCash Lock file Vol 226, Issue 57 > > Message-ID: <mailto:e0d29238-0072-40cd-aea7-8dacecea3...@ceridwen.us> > > > Content-Type: text/plain; charset=us-ascii > > > > Very few users will be able to manage a MySQL database server safely. > Fortunately GnuCash provides a SQLite3 backend that doesn't require any > database admin skills. The only caveat is that unlike XML it doesn't write a > fresh file every session so you need to arrange backups on your own; the > OS's built-in snapshotting facility (rather grandly named Time Machine on > macOS and simply Windows Backup on Windows) is good for this, just make sure > that your GnuCash data folder is included in its list of things to back up. > > > > Regards, > > John Ralls > > > > > >> On Jan 21, 2022, at 6:45 AM, Thomas Forrester <mailto:tlforres...@gmail.com> > wrote: > >> > >> Seems like a lot of work. No doubt you're finding interesting > >> anomalies, but... > >> > >> Rather than using xml data files, which have always seemed odd to me > >> (a la, this thread), if you use a MySQL database instead, all saves > >> are automatic and completely bypass the need for all this testing. > >> You still have to save each transaction, or edits to a transaction > >> (Enter key), but otherwise you can freely close the program without > >> any worries about loosing data, and there is no save prompt on the way > >> out. I've run with a MySQL database from the start without any > >> problems at all. Just a thought, and I recognize some may have > >> reasons not to choose that path, although I'm not sure what they would be. > >> > >> On Thu, Jan 20, 2022, 11:22 PM Peter <mailto:pan...@iinet.net.au> > wrote: > >> > >>> John, > >>> Well yes it did terminate or close. > >>> gnucash was closed and was then reopened without any reported issue. > >>> Other than it failed to save the changes and delete the lock file. > >>> Maybe if you could tell me how to confirm it closed or terminated > >>> correctly, I will go and test and see what happens. > >>> This issue I noted in Test#2 was actually caused by me not following my > >>> own test process. > >>> > >>> On 21/01/2022 04:48, John Layman wrote: > >>> > >>> Th
Re: [GNC] Exiting Gnucash Lock file
Having the database read-only in Access sounds like a feature: Writing to the GnuCash database using anything except the GnuCash API voids your warranty. Access insisting on a non-text Primary Key an Access bug. All of GnuCash's tables have primary keys already, but they're mostly text representations of GUIDs because SQLite doesn't support 128-bit unsigned ints nor--unlike MySQL and Postgresql--have a UUID field type. Regards, John Ralls > On Jan 21, 2022, at 1:25 PM, Thomas Forrester wrote: > > I have tried to switch to SQLite3 this afternoon, and although I cannot > answer all your questions, I have observed the following: > > 1. Regarding your stability on Windows question, Check Wiki on SQLite. > It's pretty ubiquitous at this point and extraordinarily stable on all > platforms. I don't think you're going to have an issue with stability. > > 2. There are log files when using SQLite3, but I cannot say if they work > as you are asking. > > 3. Using the recommended ODBC driver, I was able quite easily to connect > the GnuCash database to Microsoft Access, but immediately realized there > are insurmountable problems that I have not found with ODBC/Access using a > MySQL backend for GnuCash. Specifically, although the tables link into > Access with the expected number of rows, All column data shows as > #DELETED#. According to more research, I find the following > incompatibility between the way the GnuCash database is designed and what > Access aspects (from stackoverflow): > > [...] Access (Jet) wants a table to have a unique index in order to be able > to insert/update the table if necessary. > > If your SQLite table doesn't have a unique index (or primary key), then > Access will only allow read access to the table -- you can't edit the > table's data in Access, but the data displays fine. > > To make the table updateable you might revise your SQLite code (or using a > SQLite tool) to add an index to the table. > > If your PK/unique index happens to use a TEXT field, that's fine for > SQLite. However, when you link to it in Access, Access will show the > #DELETED# indications. > > The chain of events appears to be: > > Access/Jet notices the unique index, and tries to use it. However, SQLite > TEXT fields are variable length and possibly BLOBs. This apparently doesn't > fulfill Access's requirements for a unique index field, hence the #DELETED# > indication. > > To avoid that problem, the index has to be a SQLite field type that Access > will accept. I don't know the complete list of types that are acceptable, > but INTEGER works. > > > 4. I don't hold any hope of this, but it would be truly outstanding if the > development team considered this issue (#3 above) and worked to resolve > it. It most certainly is an outlier issue and not something germane to > GnuCash itself, in fact it is more akin to assisting someone in shooting > themselves in the foot. But to someone who understands the proper > precautions, it sure would be helpful! (Not sure why ODBC to Access using > MySQL works fine. Different db structures for different dbs???) > > > > > > > > On Fri, Jan 21, 2022 at 2:48 PM Kalpesh Patel wrote: > >> Few questions in regards to SQLite3 backend recommendation because >> currently >> XML format for my data is compressed size of 1.82MB so exploring moving to >> it. Not sure if this is considered small sized XML file or not but . >> >> >> >> 1 - SQLite was natively born on UNIX systems with UNIX systems in mind so >> how stable is it for Windows and how well is it supported from the GNC >> perspective? >> >> 2 - Does it still create the log file to be able to replay it like XML >> storage creates? >> >> 3 - How can I roll back transactions (more so related to roll back from >> import errors)? With XML I can take the previously created file and make it >> my current file after renaming it. >> >> >> >> Any other differences to keep in mind other than backup regiment? >> >> >> >> >> >> >> >> -- >> >> >> >> Message: 8 >> >> Date: Fri, 21 Jan 2022 08:43:04 -0800 >> >> From: john mailto:jra...@ceridwen.us> > >> >> To: Thomas Forrester mailto:tlforres...@gmail.com> >>> >> >> Cc: Peter mailto:pan...@iinet.net.au> >, >> gnucash-user >> >>mailto:gnucash-user@gnucash.org >>> >>> , john.lay...@laymanandlayman.com <mailto:john.lay...@laymanandlayman.com> >> >> >> Subject: Re: [GNC]
Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
Mark, AIO expands to "all-in-one" and refers to the Windows and macOS bundles that we publish containing GnuCash and all of its dependencies. Flatpak is something of a hybrid in that the GNOME dependencies are provided by the flatpak runtime and our build script adds AQBanking, Boost, and libofx. The relevant commit is https://github.com/libofx/libofx/commit/70ae1b44fd4ea00175ae9fa5a6abd12243534fc2 and it was to fix https://bugs.gnucash.org/show_bug.cgi?id=798267. Interestingly that bug was for Australian Eastern Standard Time, +10:00 instead of US Eastern Standard Time -5:00. Regards, John Ralls > On Jan 13, 2022, at 10:07 AM, Mark Sutton wrote: > > On Thu, Jan 13, 2022 at 09:28:06AM -0800, john wrote: >> Derek, >> >> The libofx change was in libofx-0.10.3 but I also (as I generally do) set >> the same patch to libofx 0.10.2 in the build repositories so GnuCash 4.8 and >> 4.9 include the fix. >> Since the 4.9 AIO still doesn't work there must be another path where the TZ >> is bering applied backwards. >> > I'm not sure what AIO is, but I have 4.9 installed on funtoo. Right now > libofx-0.10.2 > is installed, but I can emerge libofx-0.10.3. > I have also run into this problem but I am in UTC-8 or -7 depending on the > time > of year so the problem only manifested when DST set in. I think I just > massaged the > file to make the transaction post at noon then it didn't matter. > > I have five years of TD files to import so I don't mind doing some tests. > So what combination should work? gnc-4.9 with libofx-0.10.2? > if so does that break with 0.10.3 > I can not find the commit that might have fixed this so I can't see what it > does. > Does it check version and apply the correction or not. > > -mark >> >> >>> On Jan 12, 2022, at 9:31 AM, Derek Atkins wrote: >>> >>> According to that bug it was fixed in LibOFX in June 2021... And the fix >>> appears to be in 0.10.3 >>> What version of LibOFX is in use? >>> >>> -derek > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] AqBanking Online Set Up
Yup, 10 months: 2021030112[-8] 2021123112[-8] Are you sure that GnuCash imported only December's transactions? Did you change the filter on the General Journal register or look in the account's register? Regards, John Ralls > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall > wrote: > > Okay found out Royal Bank only saves transactions upto 120 days for OFX. > Nnesense. 365 days is what an Auditor wants. The file I downloaded only had > one month once I imported the OFX. This conflicts with what Royal Bank has > said so far. So I called Royal Bank back and everything is fine on their > end. > > I then looked at the OFX file in text editor and saw it has March-December so > the problem is with the format of the OFX file relative to GnuCash. > Headers... > > I've attached the transactions for the Use Case in the email. > > Any ideas on next steps? > > > > On Tue, Jan 4, 2022 at 10:51 AM Jesse MacDougall > wrote: > The import went smooth. Alot eaier then a .csv and other softwares I've used > in my career. QFX is what I got but Royal Bank only included December > transactions in the file when I chose the entire year. > > So this is great. Can download one file a month and post each transaction to > proper account usually expense. > > So now I have to get other information so that gnucash will automate the > downloading and importing process? Is this possible? I dunno, I think > so...Sometimes I think technology is supposed to do something but it doesn't > > > On Tue, Jan 4, 2022 at 10:13 AM john wrote: > https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx > > At the end of the QFX import you were presented with a window listing all of > the imported new transactions. Since this is a first import they should all > have had a yellow background. You can either double-click each one or select > one or more and right click then select "assign account" from the context > menu. That will bring up a window with your account tree from which you can > select the "other" account for the selected transactions. When you do this > GnuCash records information from the transaction's description and will use > it to suggest an account for future transactions with similar descriptions; > those will have a green background as will transactions after you've assigned > an account to them. > > If you skipped that step you'll find al of your transactions assigned to > Imbalance-CAD and you'll need to re-assign them in the register. That doesn't > train the import matcher. > > The General Ledger by default filters to the last 30 days. You can change > that with View>Filter By. > > Regards, > John Ralls > > >> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall >> wrote: >> >> I was able to download in QFX format. I did the import. How do I assign >> the transactions to the accounts now? I see some of the transactions are >> posted in GL but I do not see the entire year of transactions. Just >> December. >> >> On Mon, Jan 3, 2022 at 9:28 PM john wrote: >> Not necessarily. You just need to see if Quicken knows how to connect to RBC >> and if so whether they authenticate with DirectConnect (which AQBanking can >> handle), Express WebConect, or WebConnect (both of which it can't). >> >> It just as possible that what that page is really talking about is >> downloading files; you can figure that out by logging in to your RBC web >> account and looking for a download link. GnuCash can handle OFX, QFX, and >> QIF but not QBO. It's also able to handle CSV though that may take a bit of >> tweaking and in some cases some preprocessing of the CSV. >> >> Regards, >> John Ralls >> >> >> >> >>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall >>> wrote: >>> >>> Merci, that eliminates two of the options. I see a forum to a missing >>> institution and connections >>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3. I see someone two >>> years ask about Canadian Banks. No response >>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 >>> >>> Here someone says TD Bank Canada is not listed but USA is =( >>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482 >>> >>> A Quicken friend who uses Royal Bank as well? >>> >>> >>> >>> On Mon, Jan 3, 2022 at 8:26 PM john wrote: >>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal >>> Bank of *Canada* i
Re: [GNC] 4.9 account set up of going business
Maybe what you're missing is that Opening Balances accounts are created as placeholders by the Hierarchy Assistant. Before you can create the balancing transaction you must select the account on the Accounts page, click the Edit button in the toolbar, clear the Placeholder checkbox, and click OK. Once you've created the necessary transactions you should re-set Opening Balances to a placeholder. Regards, John Ralls > On Dec 30, 2021, at 12:52 PM, Rogier F. van Vlissingen > wrote: > > It happens to be a loss. > > I seem to be missing something. For all the other accounts, I simply post > to the account with the balancing transaction going to Opening Balances. > But because of what I described, I get Opening Balances $x and Retained > Earnings $0. Nothing I can think of gets the money from Opening Balances > into Retained Earnings. > > Or is it that when I set it up, I have to do some split transactions to > make sure the appropriate amount ends up in Retained Earnings and the > remainder is Retained Earnings? > > Not sure how, but I could give that a try, I will just have to set that up > all over again. > > > > > > > > On Thu, Dec 30, 2021 at 3:33 PM wrote: > >> Rogier >> >> What is the form of the transaction being used to record the opening >> balance of the Retained Earnings account. Assuming your business has been >> profitable and it is not a loss, then the transaction to record its opening >> balances it should be something like >>Dr >> Cr >> Equity:Opening Balances xxx >> Equity: Retained Earnings xxx >> >> This should reduce the balance of the Retained earnings account while >> keeping the overall Equity account balance constant. >> >> David Cousens >> >> On Thu, 2021-12-30 at 15:18 -0500, Rogier F. van Vlissingen wrote: >> >> >> >> Thanks, I do not get it. I can set up all the opening balances, except one >> retained earnings. To me retained earnings on 1/1/2020 is the accumulated >> position from prior years, I do not see how I can finagle that via what sub >> accounts. Evidently, when I set up the opening transaction, which is fairly >> simple, the retained earnings is left at zero, because I cannot access it, >> and so that difference pops up as part of the opening balance accumulator >> account, which is therefore too high by the exact amount of the retained >> earnings. >> >> Am I missing something? >> >> On Thu, Dec 30, 2021 at 2:52 PM wrote: >> >> Rogier >> >> >> When you transfer account to a new set of books, you would record the >> opening >> balances of the Asset and Liability accounts against the Opening balances >> entries in Equity. >> >> Asset entries will be a debit to the asset account and a credit to the >> opening >> balances account and Liabilities a credit to the liability account and >> debit to >> the opening balances account in Equity. >> >> With this all you previous equity balances have been transferred to the >> Opening >> Balances account and the books are balanced. The Opening Account Balance >> should >> equal the total Equity balance in your previous set of books. >> >> If you wish to restore the Equity sub-account balances (assuming the >> accounts >> have a credit balance in your previous books), you would need to credit the >> aappropriate Equity sub-account in your new book for the amount of its >> balance >> in the previous set of books and debit the Opening Balances account for >> the same >> amount. This will keep the books balanced. >> >> If you restore all the previous books equity sub-account balances, then if >> your >> previous set of books was balanced, the Opening Balances account should >> end up >> with a 0 balance. >> >> As John pointed out, the initial account setup daemon only allows you to >> set the >> opening balances for asset and liability accounts. To restore the Equity >> balances you would need to enter the transactions manually from the Opening >> Balances register after creating the equity subaccounts initially with zero >> balances. >> >> David Cousens >> >> >> On Thu, 2021-12-30 at 06:33 -0500, Rogier F. van Vlissingen wrote: >>> Yeah, thanks. I am on mint, and it has version 3.8. I was able to do >>> something like that in version 3.8. However, I had some problems with it, >>> and moved to 4.9 now because of some other pro
Re: [GNC] 4.9 account set up of going business
> On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen > wrote: > > I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately, > there appears to be some sort of corruption in my file. > > I am now doing it over in 4.9. > > However, I am having a problem with the Opening Balances for 2020, as I > seem to be unable to set up an opening balance for retained earnings. > > The numbers check out, but everything goes in Opening balances, which is > therefore too high by the amount of the retained earnings. > > You can't even do a transfer. > > > What is to be done? A business book wouldn't normally have an opening balances account. OTOH money is fungible and it doesn't really make sense to divide every asset's start-of-year balance between liabilities, paid-in capital, and retained earnings, so it's in my mind quite defensible to use Opening Balances to accumulate everything. Liabilities are handled by creating normal opening balance entries. The New File Hierarchy Assistant doesn't let you make opening balance entries in Equity accounts, but you can add transactions to RE and whatever you're calling paid-in capital to zero out Opening Balances when you've finished with the assistant. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] crypto exchange
> On Dec 23, 2021, at 1:20 PM, Tim via gnucash-user > wrote: > > > Hi, > > I try to hande my crypto trades in gnucash and stuck at trading fees > which decrease my fiat currency (€) in smaller fraction than 1/100. > > Does anybody know how I can handle this? Round to the nearest Euro-cent. No currency has fractions of its smallest unit. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash Dark Theme Needed
Arc,
Thanks for the followup, but please remember to copy the list on all replies.
I've added the requested FAQ, see
https://wiki.gnucash.org/wiki/FAQ#Q:_I.27m_vision-impaired._How_do_I_make_GnuCash_more_accessible.3F
Regards,
John Ralls
> On Dec 22, 2021, at 12:53 PM, S S wrote:
>
> John,
>
> Wonderful, thank you so very much for your help! I simply created both files
> in my User account directory as you specified below, and now I can read and
> use GnuCash again. I hope someone can add this information to the FAQ at some
> point so perhaps in the future no one feels a need to inquire for similar
> help. I'm so glad plain text works fine and no special subject/header rules
> are needed on this list. Thank you again for taking time out of your day for
> me to be so specifically helpful, and may you have an awesome new year ahead!
>
> Thanks Again,
> Arc
>
> From: john
> Sent: Wednesday, December 22, 2021 2:31 PM
> To: S S
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] GnuCash Dark Theme Needed
>
> Don't worry too much about formatting. It's an email list, so format it the
> way you would any other plain-text email.
>
> GnuCash isn't a Windows native application so it doesn't know anything about
> Windows theme settings. In general GnuCash obeys the Gtk theme, but there's
> one exception: The green bar display in the register. You can turn that off
> in Preferences>Register by unchecking "Use GnuCash built in color scheme",
> the first item under Graphics.
>
> To get light text on dark, open (create if necessary)
> AppData\Local\gtk-3.0\settings.ini in Notepad or some other plain-text
> editor. Make it look like
> [Settings]
> gtk-application-prefer-dark-theme=true
>
> To boost the font size create a second file in that directory, gtk.css. In it
> add
> #gnc-id-main-window {
> font-size: 20pt;
> }
>
> See https://wiki.gnucash.org/wiki/GTK3 for more ways to style GnuCash.
>
> Regards,
> John Ralls
>
>
>> On Dec 21, 2021, at 1:04 PM, S S wrote:
>>
>> I apologize if my formatting is not appropriate to the list as I can't find
>> anything about how to format posts to the list. My problem right now is that
>> I downloaded GnuCash 4.9 and I can't read anything in the software as it is
>> not honoring/inheriting/adopting Windows 10 High Contrast Dark theme
>> settings properly. Even if I try to invert the colors manually, it is not
>> displaying correctly and the text is upscaling so poorly it is illegible.
>> For instance, in HomeBank, there's an Edit > Preferences option with subset
>> "Interface" that has the options to "override" GTK font to increase the text
>> size and there is a clear option for "Dark theme." These two options make
>> that software accessible to me. Is there anything like this in GnuCash? Are
>> there any other legally blind or low vision users of GnuCash who might be
>> able to help with how they achieved readable text to use the software?
>>
>> Thanks Very Much,
>> Arc
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] GnuCash 4.9 Released
Sorry, all. I forgot to unmask the Sourceforge download directory and update the Big Green Button links. I just did so, the SF downloads should work now. Regards, John Ralls > On Dec 19, 2021, at 3:06 PM, wrote: > > Getting the same for Windows. No links for 4.9 -- still shows 4.8 > > Maybe it's a timing thing -- will try later this afternoon > > -Original Message- > From: gnucash-user On Behalf > Of prl > Sent: Sunday, December 19, 2021 3:03 PM > To: David H ; GnuCash-User > Cc: GnuCash Developers > Subject: Re: [GNC] [GNC-dev] GnuCash 4.9 Released > > I'm getting the same as David H. When I click on the GnuCash home page link > for 'GnuCash 4.9 for Apple macOS ≥ 10.13—"High Sierra" ', I get a SourceForge > "Whoops, we can't find that page." error page, presumably for a HTTP 404 Not > Found error. > > Peter > > On 20/12/2021 08:11, David H wrote: >> John, >> >> Thanks for that, much appreciated. Sourceforge links aren't working >> for me >> - no 4.9 folder under gnucash (stable) ??? Github links work. >> >> Cheers David H. >> >> >> On Mon, 20 Dec 2021 at 06:24, John Ralls wrote: >> >>> The GnuCash development team announces GnuCash 4.9, the tenth release >>> in the stable 4.x series >>> >>> Between 4.8 and 4.9, the following bugfixes were accomplished: >>> >>> • Bug 797502 - (RTL) - Right edge of the reports are locked >>> while scrolling down Running gnucash in Hebrew, the right edge of the >>> reports are locked while scrolling down and do not scroll with the >>> rest of the report. >>> >>> • Bug 797618 - Spanish translation of Shares and Stock >>> • Bug 797678 - OFX importer should supplement, not replace, >>> existing Notes (and Description and Memo) fields Add an "Append" >>> checkbox to the bottom of the "Generic import transaction matcher" >>> window to the left of the "Reconcile after match" checkbox. When >>> ticked, this causes the imported Description/Notes to be appended to >>> the matched transaction Description/Notes respectively. The selected >>> ticked/unticked state of the "Append" checkbox is saved in a key >>> value pair for the import account, so the next import for that >>> account will automatically default it to the saved state. As these >>> mods are limited to the code for the matcher window, this should work >>> for all the imports that use it - ie ofx & csv file imports (both tested) & >>> aqbanking (cannot test). >>> >>> • Bug 797772 - Allow reconciliation report to double filter >>> by both posting and reconciliation date >>> • Bug 798222 - Account search dialog: Pushing enter does nothing >>> • Bug 798266 - Dropdown picker menu for category does not appear >>> • Bug 798313 - "File/Import/Import Transactions From CSV" >>> crashes Gnucash. >>> • Bug 798320 - Error message indicating a crash of GNUcash >>> when closing application - MacOS 10.15.7 (19H1419) >>> • Bug 798325 - New Currency for Venezuela (VED) >>> • Bug 798327 - Ofx import stops too early for multi-account >>> OFX and one account has no new transactions >>> • Bug 798335 - No longer possible to change trading account >>> Strip trading splits only if "Use Trading Accounts" is enabled for >>> the book so that users who want to manage trading accounts by hand may do >>> so. >>> >>> • Bug 798341 - Right align in Hebrew - Account screen >>> • Bug 798346 - crashes when running check & repair >>> • Bug 798352 - Decimal Precision when Entering Mutual Fund >>> Transaction Let xaccParseAmount parse up to 12 decimal places instead >>> of 8. >>> >>> • Bug 798382 - Typo corrections in comments The following >>> fixes and improvements were not associated with bug reports: >>> >>> • More memory leak plugging and GList efficiency improvements. >>> • Fix build with cmake older than 3.18 >>> 3.18 introduced 'cmake -E cat', but we still have to support versions >>> starting from 3.14. >>> >>> • [account-piecharts] don't use gnc:make-internal-option >>> • Several improvements to the experimental IFRS cost-basis report. >>> • Fix two minor issues with displaying links in the Document >
[GNC] GnuCash 4.9 Released
The GnuCash development team announces GnuCash 4.9, the tenth release in the stable 4.x series Between 4.8 and 4.9, the following bugfixes were accomplished: • Bug 797502 - (RTL) - Right edge of the reports are locked while scrolling down Running gnucash in Hebrew, the right edge of the reports are locked while scrolling down and do not scroll with the rest of the report. • Bug 797618 - Spanish translation of Shares and Stock • Bug 797678 - OFX importer should supplement, not replace, existing Notes (and Description and Memo) fields Add an "Append" checkbox to the bottom of the "Generic import transaction matcher" window to the left of the "Reconcile after match" checkbox. When ticked, this causes the imported Description/Notes to be appended to the matched transaction Description/Notes respectively. The selected ticked/unticked state of the "Append" checkbox is saved in a key value pair for the import account, so the next import for that account will automatically default it to the saved state. As these mods are limited to the code for the matcher window, this should work for all the imports that use it - ie ofx & csv file imports (both tested) & aqbanking (cannot test). • Bug 797772 - Allow reconciliation report to double filter by both posting and reconciliation date • Bug 798222 - Account search dialog: Pushing enter does nothing • Bug 798266 - Dropdown picker menu for category does not appear • Bug 798313 - "File/Import/Import Transactions From CSV" crashes Gnucash. • Bug 798320 - Error message indicating a crash of GNUcash when closing application - MacOS 10.15.7 (19H1419) • Bug 798325 - New Currency for Venezuela (VED) • Bug 798327 - Ofx import stops too early for multi-account OFX and one account has no new transactions • Bug 798335 - No longer possible to change trading account Strip trading splits only if "Use Trading Accounts" is enabled for the book so that users who want to manage trading accounts by hand may do so. • Bug 798341 - Right align in Hebrew - Account screen • Bug 798346 - crashes when running check & repair • Bug 798352 - Decimal Precision when Entering Mutual Fund Transaction Let xaccParseAmount parse up to 12 decimal places instead of 8. • Bug 798382 - Typo corrections in comments The following fixes and improvements were not associated with bug reports: • More memory leak plugging and GList efficiency improvements. • Fix build with cmake older than 3.18 3.18 introduced 'cmake -E cat', but we still have to support versions starting from 3.14. • [account-piecharts] don't use gnc:make-internal-option • Several improvements to the experimental IFRS cost-basis report. • Fix two minor issues with displaying links in the Document Link dialog. • Fix obsolete links to bugzilla.gnome.org in translations. • L18N: Fix glossary/es.po:906: duplicate message definition... 901: ...this is the location of the first definition • [budget-flow] delay creating exchange-fn until a valid budget exists because it needs budget period end-date. • [options.scm] Addon previous commit... need to initialize with guid • [options.scm] gnc:make-budget-option stores guid instead of object because object may become stale if UI is used to delete it, leading to stale pointer and segfault. storing guid is safer, and will return null if budget is deleted. • support SEPA internal transfer • Fix issue with failure to run reconciliation with all accounts present in a multi-account OFX file. Do that by saving a GList of statements, rather than a pointer to a single one. Also freeing of info happens during the call to process_next_file. • Import of OFX files with many securities opens too many matching dialogs Because ofx import is currently split per target account, and since each security has its own accounts, importing such OFX is a tedious process. The fix is to only split the transactions if we identify a potential transfer, currently based on amount, date and accounts. To do that, we insert transactions one by one into a list, making sure we have not already inserted one that has the same date, and the same absolute amount. If we have, we keep this potential transfer for a second phase. A naive approach would loop through added transactions for each new transaction by that ends up being O(N^2), which matters if we have many transactions. Instead, I'm using a hash to make this O(N log N). • [date-utilities.scm] remove unused date selectors code & string • Adjust GNC_DEFINE_TYPE_EXTENDED_END To match new signature of g_once_init_enter and g_once_init_leave. • Fix build with glib2 2.67.x. glib headers should not be included with 'extern "C"'. • Add explanatory note for gnc_add_scheme_deprecated_module test code The
Re: [GNC] Coloring the Action field
It's not supported and it wouldn't be easy to implement in a general way. Gtk
nodes aren't HTML or XML elements with attributes, so Gtk CSS styling can't
query attributes as a selector.
Regards,
John Ralls
> On Dec 16, 2021, at 11:11 PM, AC wrote:
>
> Yeah, I know there's a good likelihood that it isn't supported but I figured
> with all the CSS support maybe I'd get lucky and there was support for
> attribute selection like there is in regular browser CSS. But then that's a
> GTK ask and not necessarily a GnuCash ask.
>
> The general thought if such an attribute selector were supported would then
> be something like:
>
> .gnc-register#registerid .gnc-action-field[value="Payment"] {
> background-color: rgba(255,0,0,0.5); }
>
>
> Again, this is more likely a GTK ask since I'm sure it would take actual code
> in the notebook handler routines to have per register action colors.
>
> On 2021-12-16 22:27, David Carlson wrote:
>> So far no developer has replied to this thread, so we do not know if there
>> are any 'hooks' under the hood to hang this request on, or if it would
>> require substantial development work to implement.
>> One path forward would be to create an Enhancement Request Bug Report in
>> the GnuCash Bugzilla https://wiki.gnucash.org/wiki/Bugzilla.
>> On Fri, Dec 17, 2021 at 12:09 AM AC wrote:
>>> No, I don't like the loan wizard. I already tried it and I still need
>>> to flag the transactions to find them later in the register so I can fix
>>> the splits correctly. The wizard doesn't save me any time.
>>>
>>>>
>>>> Why not point to the loan wizard and how it can setup an automated
>>>> transaction schedule? Sure, it is off a few pennies every so often but
>>>> if a person is looking at the loan details a their bank (or get a
>>>> monthly statement) it is easy to adjust the existing transactions.
>>>>
>>>> Once you understand the resulting schedule formula, you can modify for
>>>> extra monthly payments and won't need the wizard to setup the next loan.
>>>>
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] is trn:date-entered record modified time?
But developers read this list too. ;-) Date Entered is the date the transaction was created and it's not changed if the transaction is edited later. There is no record of the last modification date in the main data file. You may be able to recover that from the transaction logs if you keep all of them forever. Regards, John Ralls > On Dec 4, 2021, at 3:40 PM, David Carlson wrote: > > Users will not be able to help you. > > You can look at < > https://wiki.gnucash.org/wiki/GnuCash#Documentation_for_Developers>, or > post a request on the developers maillist or on the IRC Chat < > https://wiki.gnucash.org/wiki/IRC> > > On Sat, Dec 4, 2021 at 5:21 PM Sherwood Hu wrote: > >> I am working on a program the reads gnucash file. There is a XML element >> trn:date-entered under gnc:transaction. Is the value equal to the last >> modification date? If it is not, which element should I look at? >> >> Your input is greatly appreciated. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Export Current Search
Is a register page displayed in the main window? What version of GnuCash and what operating system/distro? Regards, John Ralls > On Nov 2, 2021, at 11:06 AM, Mike Stillingfleet > wrote: > > OK well I am afraid that I do not see that on my GNUCASH. > > On Tue, Nov 2, 2021, at 5:32 PM, John Ralls wrote: >> No, the Help is literally correct: There is a menu item "Export Current >> Register to CSV..." but *only* if a register tab has focus. >> >> Regards, >> John Ralls >> >> >>> On Nov 2, 2021, at 10:25 AM, Mike Stillingfleet >>> wrote: >>> >>> OK so the option export transactions is what the help is referring to? >>> >>> On Tue, Nov 2, 2021, at 3:48 PM, john wrote: >>>> No, Help is correct. As David pointed out that item is presented only if >>>> the current active tab is a register. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Nov 2, 2021, at 1:28 AM, Mike Stillingfleet >>>>> wrote: >>>>> >>>>> Thank you Michael. This works. So the help files for GNUcash which show >>>>> the fourth option no longer apply. >>>>> >>>>> On Tue, Nov 2, 2021, at 8:24 AM, Michael Hendry wrote: >>>>>> On 2 Nov 2021, at 07:31, Mike Stillingfleet >>>>>> wrote: >>>>>>> >>>>>>> Dear GNUCash Forum, >>>>>>> >>>>>>> Firstly I how that I have posted this correctly. >>>>>>> >>>>>>> I have read in the GNU Cash help that if I have focus on the current >>>>>>> search I should see 4 export options and one of those will be >>>>>>> File->Export->Export Active Register to CSV. >>>>>>> >>>>>>> I do not have that option. >>>>>>> >>>>>>> Is this something that has been removed? >>>>>>> >>>>>>> How else could I export the current search? >>>>>>> >>>>>>> TIA >>>>>> >>>>>> After you have run the search, you will have a “Search Results” tab open. >>>>>> >>>>>> From the “Reports” menu, choose “Account Report”. >>>>>> >>>>>> Click the “Export” button, and save the file to HTML. >>>>>> >>>>>> Before the Export stage, you can adjust the contents of the report >>>>>> using the “Options” button. >>>>>> >>>>>> I’m using LibreOffice for the next stage, but presumably other office >>>>>> suites will do the same. >>>>>> >>>>>> Open the HTML file in LibreOffice. >>>>>> >>>>>> Select All, and Copy to clipboard. >>>>>> >>>>>> Open a new Spreadsheet file. >>>>>> >>>>>> Paste. >>>>>> >>>>>> Save As CSV. >>>>>> >>>>>> >>>>>> This is a very roundabout route, but if this is a one-off job probably >>>>>> worthwhile, >>>>>> >>>>>> Michael >>>>>> >>>>>> PS Curses! As I was about to send this, David Cousens beat me to it >>>>>> with a proper solution! The feature that misled me (and presumably >>>>>> Mike) is that the Export button that appears once the Register tab is >>>>>> selected implies that this is the only way to export from a register, >>>>>> and blinded me to that alternative route. >>>>> >>>>> -- >>>>> Mike Stillingfleet >>>>> mikestillingfl...@fastmail.co.uk >>>>> ___ >>>>> gnucash-user mailing list >>>>> gnucash-user@gnucash.org >>>>> To update your subscription preferences or to unsubscribe: >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>> If you are using Nabble or Gmane, please see >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>> - >>>>> Please remember to CC this list on all your replies. >>>>> You can do this by using Reply-To-List or Reply-All. >>> >>> -- >>> Mike Stillingfleet >>> mikestillingfl...@fastmail.co.uk > > -- > Mike Stillingfleet > mikestillingfl...@fastmail.co.uk ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Export Current Search
No, the Help is literally correct: There is a menu item "Export Current Register to CSV..." but *only* if a register tab has focus. Regards, John Ralls > On Nov 2, 2021, at 10:25 AM, Mike Stillingfleet > wrote: > > OK so the option export transactions is what the help is referring to? > > On Tue, Nov 2, 2021, at 3:48 PM, john wrote: >> No, Help is correct. As David pointed out that item is presented only if the >> current active tab is a register. >> >> Regards, >> John Ralls >> >> >>> On Nov 2, 2021, at 1:28 AM, Mike Stillingfleet >>> wrote: >>> >>> Thank you Michael. This works. So the help files for GNUcash which show >>> the fourth option no longer apply. >>> >>> On Tue, Nov 2, 2021, at 8:24 AM, Michael Hendry wrote: >>>> On 2 Nov 2021, at 07:31, Mike Stillingfleet >>>> wrote: >>>>> >>>>> Dear GNUCash Forum, >>>>> >>>>> Firstly I how that I have posted this correctly. >>>>> >>>>> I have read in the GNU Cash help that if I have focus on the current >>>>> search I should see 4 export options and one of those will be >>>>> File->Export->Export Active Register to CSV. >>>>> >>>>> I do not have that option. >>>>> >>>>> Is this something that has been removed? >>>>> >>>>> How else could I export the current search? >>>>> >>>>> TIA >>>> >>>> After you have run the search, you will have a “Search Results” tab open. >>>> >>>> From the “Reports” menu, choose “Account Report”. >>>> >>>> Click the “Export” button, and save the file to HTML. >>>> >>>> Before the Export stage, you can adjust the contents of the report >>>> using the “Options” button. >>>> >>>> I’m using LibreOffice for the next stage, but presumably other office >>>> suites will do the same. >>>> >>>> Open the HTML file in LibreOffice. >>>> >>>> Select All, and Copy to clipboard. >>>> >>>> Open a new Spreadsheet file. >>>> >>>> Paste. >>>> >>>> Save As CSV. >>>> >>>> >>>> This is a very roundabout route, but if this is a one-off job probably >>>> worthwhile, >>>> >>>> Michael >>>> >>>> PS Curses! As I was about to send this, David Cousens beat me to it >>>> with a proper solution! The feature that misled me (and presumably >>>> Mike) is that the Export button that appears once the Register tab is >>>> selected implies that this is the only way to export from a register, >>>> and blinded me to that alternative route. >>> >>> -- >>> Mike Stillingfleet >>> mikestillingfl...@fastmail.co.uk >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. > > -- > Mike Stillingfleet > mikestillingfl...@fastmail.co.uk ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] macOS Monterey Accessibility Issue
Full Keyboard Access in Monterey is different from and unfortunately quite incompatible with Use Keyboard Navigation since it changes the tab key’s behavior even in native apps like Apple Mail. It seems to require native AppKit UI controls, too: Turning it on and switching focus to GnuCash leaves the Full Keyboard Access on the last native app’s control even though keyboard focus has shifted to GnuCash. Regards, John Ralls > On Oct 28, 2021, at 9:31 AM, Chris Graves wrote: > > Whoops, I enabled the wrong preference, all is okay. My intention was to > enable the capability of tabbing through dialog box fields and that is done > not through the Accessibility pref, but through System > Preferences->Keyboard->Shortcuts->Use keyboard navigation to move focus > between controls. > > Chris > >> On Oct 28, 2021, at 8:38 AM, Chris Graves wrote: >> >> With System Preferences->Accessibility->Keyboard->Enable Full Keyboard >> Access enabled, the tab key no longer moves between fields in the register. >> >> As a workaround, option-tab can be used. >> >> Does anyone else see this behavior using macOS Monterey? >> >> This is with Gnucash-Intel-4.8-2.dmg >> >> Thanks, >> Chris > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Decimal Precision Entering Mutual Fund Transactions
> On Oct 24, 2021, at 2:24 PM, Robin Chattopadhyay wrote: > > Hi all- > > SETUP: > Version 4.8 (plus the commit to fix Bug 798327) > OS: Ubuntu 20.04 LTS > > SCENARIO: > My wife recently started a new job where the 401k provider maintains the > mutual fund positions at nine decimal places (and the price is two decimal > places precision). I set up the security with the fraction traded set to > 1*10^9, I set up the account's fraction traded to 'Use Commodity Value' > > When entering a transaction into the register directly with the full nine > decimal places, GnuCash cuts off the last digit and appears to only save up > to the 8th significant digit thus introducing a small (but annoying) > position difference between my books and the recordkeeper. > > However, if I import the transactions from the OFX file downloaded from the > recordkeeper's website, the full nine digits are imported and displayed in > the register. > > Another related item is that the share amount displayed changes from 9 > digits to 8 digits back to 9 when moving between transactions. For example, > a transaction with 4.008105604 shares shows 4.0081056 as long as that > transaction has the focus. > > The workaround for now appears to only import transactions from the OFX > file, which is fine but it does seem weird to have this inconsistent > experience. > > I glanced through Register-related bugs but I didn't see anything that > jumped out at me as an open existing bug that would explain this behavior. > (I'll concede that my search may have been lacking because previous > discussion on this list related to precision and integer math have gone > over my head) I can replicate that. The truncation happens when one tabs out of the field, suggesting an off-by-one clamp the register somewhere. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manuel utilisateur ...
> On Oct 14, 2021, at 1:00 PM, Guillaume Tétart wrote: > > Bonjour madame, monsieur, > comment est-il possible qu’il n’existe à ce jour, aucune version en français > du manuel d’utilisation de GnuCash ? ... > Cordialement, > Because no-one has volunteered to translate the documentation to French. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 4.8-2 DMG for macOS 12
The last two beta releases of macOS 12 Monterey changed the behavior of a low-level graphics function used by Gtk3 that resulted in application windows not being able to display their content. I've fixed the problem and made a new GnuCash bundle, GnuCash 4.8-2, SHA256 20af888f1d1293a036b595145ad9e5338b3a92f868b6e4fca021d4cc7d9df36b. You need to use it only if you're using or planning to upgrade to macOS 12 Monterey. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transactions do not appear in the register until is pressed
> On Oct 4, 2021, at 2:18 PM, David H wrote: > > The only thing I'm not sure about is what the difference is between clicking > Cancel and clicking OK on the popup as I get the txns regardless :-) Probably because all of your transactions are set to create automatically, so the SLR is just telling you that they've been created. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Monterey
> On Sep 29, 2021, at 4:18 PM, Alan Magnus wrote: > > > Will the latest build of Gnucash run on the forthcoming Apple Monterey? I just tested it on my M1 mini/macOS 12beta7 and it seems to work OK. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash 4.8 Build Fail
David Cousens reported that on the Devel list a few minutes ago. The
work-around is
edit gnucash/gschemas/CMakeLists.txt and change line 32 from
COMMAND ${CMAKE_COMMAND} -E cat ${gschema_migration_files} >
${DATADIR_BUILD}/${PROJECT_NAME}/migratable-prefs.xml
to
COMMAND cat ${gschema_migration_files} >
${DATADIR_BUILD}/${PROJECT_NAME}/migratable-prefs.xml
Regards,
John Ralls
> On Sep 28, 2021, at 4:57 PM, Harry G McGavran Jr via gnucash-user
> wrote:
>
> I have the same problem that David reported on this list, but
> with Ubuntu 20.04:
>
> Gnucash 4.8 won't build --
>
> .
> .
> .
> [ 97%] Built target org.gnucash.GnuCash.dialogs.sxs.gschema.valid-target
> [ 97%] Built target
> org.gnucash.GnuCash.dialogs.import.csv.gschema.valid-target
> [ 98%] Built target compiled-schemas
> [ 98%] Generating ../../share/gnucash/migratable-prefs.xml
> CMake Error: cmake version 3.16.3
> Usage: /usr/bin/cmake -E [arguments...]
> Available commands:
> capabilities - Report capabilities built into cmake in JSON
> format
> chdir dir cmd [args...] - run command in a given directory
> .
> .
> .
>
> I tried chasing this a bit, but I'm not a cmake expert by any means...
> So hopefully there will be a work around...
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] GnuCash 4.8 Released
> On Sep 28, 2021, at 1:55 PM, John Ralls wrote: > > The GnuCash development team announces GnuCash 4.8, the ninth release in the > stable 4.x series > > This is a snap release to fix crashes during migration. The macOS and Win32 > GnuCash bundles were not affected; if you use either of those you do not need > this release. > Between 4.7 and 4.8, the following bugfixes were accomplished: > > None > The following fixes and improvements were not associated with bug reports: > >[gsettings] Avoid crash from settings schema not being registered. >Rethink how gsettings migration file is constructed >GSettings hotfix - resolve crash due to bad schema reference >[gnc-plugin-page-register] call invoice editor with parent window >[assistant-stock-split] set parent window properly > > New API > > None > Deprecations > > None > > New and Updated Translations: None. > Known Problems > > > Complete list of all open bugs: > https://bugs.gnucash.org/buglist.cgi?bug_severity=blockerbug_severity=criticalbug_severity=majorbug_severity=normalbug_severity=minorbug_severity=trivialbug_status=NEWbug_status=ASSIGNEDbug_status=NEEDINFObug_status=REOPENEDlimit=0list_id=8149order=priority%2Cbug_severityquery_format=advanced > > Documentation > > Concurrent with the release of GnuCash 4.8 we're pleased to also release a > new version of the companion Help and Tutorial and Concepts Guide > Between 4.7 and 4.8, the following bugfixes were accomplished: > > None > The following fixes and improvements were not associated with bug reports: > >Remove obsolete files. >Remove autotools. > > New and Updated Translations: None > Getting GnuCash for Windows and MacOS > > GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 > (High Sierra)® and later in pre-built, all-in-one packages. An installer is > provided for Microsoft Windows® while the MacOS® package is a disk image > containing a drag-and-drop application bundle. > > The SHA256 Hashes for the downloadable files are: > >15b8e4ff8336168eba88ef2faade377e5c5ff08e48b4660da1a33a8a407feb12 > gnucash-4.8.tar.bz2 >37e6fbdee7e2ac41299cdb4ffef189c160b03f992ab30e823369df90ebb0d61f > gnucash-4.8.tar.gz >b8c4a4bad5a073f53ea07ad46d4c13096a5d26d906ceda8c049842a8362d0a86 > gnucash-4.8.setup.exe >abb6a0bc433207c1f31fee33aa7f0c63774217b2675e5fab78062c4cd862f975 > Gnucash-Intel-4.8-2.dmg >988011168a3ab2c3601a5af75f5caad89fb18a4e880311f3538b8fc7c9a068d3 > gnucash-docs-4.8.tar.gz > > Microsoft Windows: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.setup.exe > > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.setup.exe > > Apple macOS: > https://github.com/Gnucash/gnucash/releases/download/4.8/Gnucash-Intel-4.8-1.dmg > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/Gnucash-Intel-4.8-1.dmg > > GnuCash is now available as a flatpak from Flathub.org. Instructions for > installing and running may be found at https://wiki.gnucash.org/wiki/Flatpak. > > Getting GnuCash as source code > If you want to compile GnuCash 4.8 for yourself, the source code can be > downloaded from: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.bz2 > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.gz > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.bz2 > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.gz > > You can also checkout the sources directly from the git repository, see > https://wiki.gnucash.org/wiki/Git for instructions. > > To compile GnuCash from the source code by yourself, you will need at least > Gtk+ 3.24, Guile 2.0, Boost 1.54, WebKitGtk 2.4, GoogleTest 1.7.0, cmake 3.10 > and SWIG 2.0.12. Please consult the README.dependencies file in the sources > for the exact list of dependencies and versions. > > Getting the documentation > > If you want to compile the GnuCash Documentation 4.8 for yourself, the source > code can be downloaded from: > https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-docs-4.8.tar.gz > https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-docs-4.8.tar.gz > > The documentation is included in the MacOS and Windows application bundles. > > About the Program > > GnuCash is a free, open source accounting program released under the GNU > General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, > MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its > first stable
[GNC] GnuCash 4.7 Released
The GnuCash development team announces GnuCash 4.8, the ninth release in the stable 4.x series This is a snap release to fix crashes during migration. The macOS and Win32 GnuCash bundles were not affected; if you use either of those you do not need this release. Between 4.7 and 4.8, the following bugfixes were accomplished: None The following fixes and improvements were not associated with bug reports: [gsettings] Avoid crash from settings schema not being registered. Rethink how gsettings migration file is constructed GSettings hotfix - resolve crash due to bad schema reference [gnc-plugin-page-register] call invoice editor with parent window [assistant-stock-split] set parent window properly New API None Deprecations None New and Updated Translations: None. Known Problems Complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blockerbug_severity=criticalbug_severity=majorbug_severity=normalbug_severity=minorbug_severity=trivialbug_status=NEWbug_status=ASSIGNEDbug_status=NEEDINFObug_status=REOPENEDlimit=0list_id=8149order=priority%2Cbug_severityquery_format=advanced Documentation Concurrent with the release of GnuCash 4.8 we're pleased to also release a new version of the companion Help and Tutorial and Concepts Guide Between 4.7 and 4.8, the following bugfixes were accomplished: None The following fixes and improvements were not associated with bug reports: Remove obsolete files. Remove autotools. New and Updated Translations: None Getting GnuCash for Windows and MacOS GnuCash is provided for both Microsoft Windows 8.1® and later and MacOS 10.13 (High Sierra)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS® package is a disk image containing a drag-and-drop application bundle. The SHA256 Hashes for the downloadable files are: 15b8e4ff8336168eba88ef2faade377e5c5ff08e48b4660da1a33a8a407feb12 gnucash-4.8.tar.bz2 37e6fbdee7e2ac41299cdb4ffef189c160b03f992ab30e823369df90ebb0d61f gnucash-4.8.tar.gz b8c4a4bad5a073f53ea07ad46d4c13096a5d26d906ceda8c049842a8362d0a86 gnucash-4.8.setup.exe abb6a0bc433207c1f31fee33aa7f0c63774217b2675e5fab78062c4cd862f975 Gnucash-Intel-4.8-2.dmg 988011168a3ab2c3601a5af75f5caad89fb18a4e880311f3538b8fc7c9a068d3 gnucash-docs-4.8.tar.gz Microsoft Windows: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.setup.exe https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.setup.exe Apple macOS: https://github.com/Gnucash/gnucash/releases/download/4.8/Gnucash-Intel-4.8-1.dmg https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/Gnucash-Intel-4.8-1.dmg GnuCash is now available as a flatpak from Flathub.org. Instructions for installing and running may be found at https://wiki.gnucash.org/wiki/Flatpak. Getting GnuCash as source code If you want to compile GnuCash 4.8 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.bz2 https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-4.8.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.bz2 https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-4.8.tar.gz You can also checkout the sources directly from the git repository, see https://wiki.gnucash.org/wiki/Git for instructions. To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.24, Guile 2.0, Boost 1.54, WebKitGtk 2.4, GoogleTest 1.7.0, cmake 3.10 and SWIG 2.0.12. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions. Getting the documentation If you want to compile the GnuCash Documentation 4.8 for yourself, the source code can be downloaded from: https://github.com/Gnucash/gnucash/releases/download/4.8/gnucash-docs-4.8.tar.gz https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.8/gnucash-docs-4.8.tar.gz The documentation is included in the MacOS and Windows application bundles. About the Program GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, MacOS, and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Crash on exit in Gnucash 4.7-2 in macOS Big Sur
> On Sep 27, 2021, at 6:47 PM, prl wrote: > > I seem to be consistently getting a Gnucash crash when I exit (using either > Gnucash>Quit or command-Q) from Gnucash 4.7-2 on my Big Sur MacBook Pro. > Caused by a Segmentation Violation. > > Here's a snippet from the macOS log of the crash: > Process: Gnucash [4025] > Path: /Applications/Gnucash.app/Contents/MacOS/Gnucash > Identifier:org.gnucash.Gnucash > Version: 4.7-2 (4.7-2) > Code Type: X86-64 (Native) > Parent Process:zsh [4019] > Responsible: Terminal [4017] > User ID: 501 > > Date/Time: 2021-09-28 11:28:31.262 +1000 > OS Version:macOS 11.6 (20G165) > Report Version:12 > Bridge OS Version: 5.5 (18P4759a) > Anonymous UUID:CA0735A3-3879-5356-BA71-4D9410666AF2 > > Sleep/Wake UUID: 9E59B9B4-5345-4236-BD83-17C01E85C186 > > Time Awake Since Boot: 8400 seconds > Time Since Wake: 7700 seconds > > System Integrity Protection: enabled > > Crashed Thread:0 Dispatch queue: com.apple.main-thread > > Exception Type:EXC_BAD_ACCESS (SIGSEGV) > Exception Codes: EXC_I386_GPFLT > Exception Note:EXC_CORPSE_NOTIFY > > Termination Signal:Segmentation fault: 11 > Termination Reason:Namespace SIGNAL, Code 0xb > Terminating Process: exc handler [4025] > > I can post a full crash log as an attachment if it helps. > > Any ideas, anyone? > > System details: > Gnucash 4.7-2 for Intel MacOS >= 10.13, Build ID: 4.7+(2021-09-25) > macOS Big Sur 11.6 > MacBook Pro (13-inch, 2019, Four Thunderbolt 3 ports), MacBookPro15,2 Please post the bit with the address and the first few lines of the stack trace, enough to show at least 2 gnc_ functions. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash 4.7 Problem
Yeah, we're going to do a snap release tomorrow. I've already tagged it and built the tarballs. Regards, John Ralls > On Sep 27, 2021, at 6:03 PM, Jon Schewe wrote: > > The flatpak apears to be broken as well. I run it and nothing appears. > > jpschewe@jon-2019:~ >> flatpak run org.gnucash.GnuCash > F: Ignoring D-Conf migrate-path setting /org/gnucash/GnuCash > > ~ > jpschewe@jon-2019:~ >> echo $? > 133 > > > On Mon, 2021-09-27 at 09:44 +0200, Geert Janssens wrote: >> Unfortunately this is a bug. I missed a name change in the conversion >> code for >> gnucash preferences. >> >> The fix is in the patch attached. >> >> As this is a crasher we may have to do a hotfix release. What do you >> think >> John ? >> >> Regards, >> >> Geert >> >> Op maandag 27 september 2021 06:43:26 CEST schreef John Ralls: >>> Please remember to copy the list on all replies. >>> >>> Removing /usr/local/lib/gnucash isn't enough. You'd also need to >>> remove at >>> least /usr/local/lib/libgnc* and /usr/local/share/gnucash. >>> >>> You don't need the whole build directory. There's a single file, >>> install-manifest.txt, that contains all of the files that were >>> installed. >>> With that one file you can do `xargs rm < install-manifest.txt` to >>> uninstall GnuCash. You might consider saving it off somewhere >>> before you >>> delete the build directory. >>> >>> Regards, >>> John Ralls >>> >>>> On Sep 26, 2021, at 9:08 PM, Harry G McGavran Jr < >>>> w5...@w5pny.com >>>>> wrote: >>>> >>>> That did fix the problem! I guess I will have to be sure >>>> to keep the old build directory around, so I can do a "make >>>> uninstall" >>>> before building the next release! Thanks for the fix -- but I >>>> must >>>> say it would be nice to not have to do the "make uninstall" on >>>> the >>>> old release. Many packages don't even have uninstall in their >>>> Makefiles... (although it would be nice if every one did include >>>> an >>>> uninstall in their Makefiles). >>>> >>>> Thanks, John! >>>> >>>> Harry >>>> >>>> On 9/26/21 9:41 PM, Harry G McGavran Jr wrote: >>>>> I think I figured out what you mean -- >>>>> you must mean either do "make uninstall" or "ninja uninstall" >>>>> with 4.6 >>>>> before building 4.7 ... >>>>> With I build gnucash and always remove /usr/local/lib/gnucash >>>>> before doing "make install" which might be the same thing. >>>>> If it does, then I'll still have the problem. I'll give >>>>> it a try though and if it doesn't work, I'll post a tracefile >>>>> to >>>>> the bug reports... >>>>> >>>>> On 9/26/21 9:34 PM, Harry G McGavran Jr wrote: >>>>>> I don't have the ninja package installed, so I'm not sure >>>>>> what >>>>>> "make/ninja uninstall" means...>>> >>>>>> On 9/26/21 9:20 PM, john wrote: >>>>>>> If you didn't already, run make/ninja uninstall in the 4.6 >>>>>>> build >>>>>>> directory. Configure and build GnuCash 4.7 in an empty >>>>>>> directory, then >>>>>>> install. >>>>>>> >>>>>>> If that doesn't correct the problem get a stack trace of >>>>>>> the crash and >>>>>>> attach it and the trracefile to a new bug report. >>>>>>> >>>>>>> Regards, >>>>>>> John Ralls >>>>>>> >>>>>>>> On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via >>>>>>>> gnucash-user >>>>>>>> < >>>>>>>> gnucash-user@gnucash.org >>>>>>>>> wrote: >>>>>>>> >>>>>>>> This was with Ubuntu 20.04... >>>>>>>> >>>>>>>> On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: >>>>>>>>> I just built Gnucash 4.7 from the release page. >>>>>>>>> It built fine, and it runs fine from the build >>>>>>>>> dir
Re: [GNC] Gnucash 4.7 Problem
Please remember to copy the list on all replies. Removing /usr/local/lib/gnucash isn't enough. You'd also need to remove at least /usr/local/lib/libgnc* and /usr/local/share/gnucash. You don't need the whole build directory. There's a single file, install-manifest.txt, that contains all of the files that were installed. With that one file you can do `xargs rm < install-manifest.txt` to uninstall GnuCash. You might consider saving it off somewhere before you delete the build directory. Regards, John Ralls > On Sep 26, 2021, at 9:08 PM, Harry G McGavran Jr wrote: > > That did fix the problem! I guess I will have to be sure > to keep the old build directory around, so I can do a "make uninstall" > before building the next release! Thanks for the fix -- but I must > say it would be nice to not have to do the "make uninstall" on the > old release. Many packages don't even have uninstall in their Makefiles... > (although it would be nice if every one did include an > uninstall in their Makefiles). > > Thanks, John! > > Harry > > On 9/26/21 9:41 PM, Harry G McGavran Jr wrote: >> I think I figured out what you mean -- >> you must mean either do "make uninstall" or "ninja uninstall" with 4.6 >> before building 4.7 ... >> With I build gnucash and always remove /usr/local/lib/gnucash >> before doing "make install" which might be the same thing. >> If it does, then I'll still have the problem. I'll give >> it a try though and if it doesn't work, I'll post a tracefile to >> the bug reports... >> On 9/26/21 9:34 PM, Harry G McGavran Jr wrote: >>> I don't have the ninja package installed, so I'm not sure what "make/ninja >>> uninstall" means... >>> >>> On 9/26/21 9:20 PM, john wrote: >>>> If you didn't already, run make/ninja uninstall in the 4.6 build >>>> directory. Configure and build GnuCash 4.7 in an empty directory, then >>>> install. >>>> >>>> If that doesn't correct the problem get a stack trace of the crash and >>>> attach it and the trracefile to a new bug report. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via gnucash-user >>>>> wrote: >>>>> >>>>> This was with Ubuntu 20.04... >>>>> >>>>> On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: >>>>>> I just built Gnucash 4.7 from the release page. >>>>>> It built fine, and it runs fine from the build directory, >>>>>> but the installed gnucash binary in /usr/local/bin >>>>>> fails with: >>>>>> Trace/breakpoint trap (core dumped) >>>>>> It only seems to run without error when run from the bin >>>>>> directory where the build is actually done. >>>>>> So I rebuilt Gnucash 4.6 and it's installed binary in /usr/local/bin >>>>>> runs fine. >>>>>> There was no core file even though "core dumped" was displayed with 4.7 >>>>> ___ >>>>> gnucash-user mailing list >>>>> gnucash-user@gnucash.org >>>>> To update your subscription preferences or to unsubscribe: >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>> If you are using Nabble or Gmane, please see >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>> - >>>>> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash 4.7 dmg for Mac
Yeah, I missed a step. Actually a couple of steps. I've uploaded a new dmg: 91597ccd19e31f8ecc454d1a1e5f891c98e60efb28d2a78d2497caf2103a7c55 Gnucash-Intel-4.7-2.dmg Regards, John Ralls > On Sep 26, 2021, at 3:18 PM, Tim LeMaster wrote: > > Is it just me or does the disk image for Mac contain Gnucash 4.6 not 4.7? > When I launch it, it still says 4.6. I was checking to see if the Monterey > fix from GTK got in the release. > > About GnuCash says > Version 4.6 > Build ID: 4.6+ (2021-06-26) > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Equity account changed to Trading Account
Alton, You missed the key element of David's suggestion: Change the type of the account back. You can do that by selecting the account on the Accounts page and clicking the Edit button in the toolbar or using control-E or selecting Edit>Edit Account from the menu. The last will also work from the account register. Once you have the account edit window open look in the bottom left corner for the Account Type list box. Select Equity from that list and click OK to commit the action. Regards, John Ralls > On Sep 26, 2021, at 11:38 AM, Alton Brantley via gnucash-user > wrote: > > I recognize that I can use that mechanism ((Menu-.Transaction->Manage Document > Links and Transaction->Open Linked Document in V4.6). However, I use > scheduled transactions and template transactions (model transactions with all > the split accounts with amounts set to zero) so that all I do is fill in the > values. That way, I never have to take my hands off the keyboard to enter > data. > > I double-checked, and the account marked as Trading is already a top-level > account. If I try to move it under any other account, it shows the possible > types of accounts as blank, so there’s nothing for me to select that enables > me to move the account. > > Also, I looked under File->Properties->Accounts and the “Use Trading > accounts” checkbox is not marked. > > For the time being, I created a new “Assets” account and moved the current > year’s transactions using the trading account split from the “Trading > account” by editing the account in the splits of a search on the “trading” > account name for the current year. Now I have all previous year’s > transactions in the “trading” account, and the current year in an “assets” > account, and I will enter future lines in the new account. > > I am at a loss as to what made the account become identified as a “trading” > account, as all my accounts are in USD. I did discover that in one of my > current year transactions, I had entered a non-zero value in the account that > had switched from “asset” to “trading.” I wonder if that somehow triggered > the software to convert the account. I think I’ll take a look at the code > around accounts and see what I can find. > > Thanks for your suggestions. > > > >> Date: Sun, 26 Sep 2021 08:11:01 +1000 >> From: davidcousen...@gmail.com >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] Equity account changed to Trading Account >> Message-ID: <21626e93bbfcba5046a6b18f15c6917b29fe6ad9.ca...@gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> Alton >> >>> From your description it would appear you are using the notes field to stor >>> a >> link to an external file descriptor. GnuCash has had a facility to associate >> a >> URL for an external file to a transaction (Menu-.Transaction->Manage Document >> Links and Transaction->Open Linked Document in V4.6). This allows you to >> link a >> file (PDF or image of e receipt for example) to a specific transaction and >> open >> it from within GnuCash). You can also set a path header in the preferences >> so >> all your linked files are stored in a single directory (can be a >> subdirectory of >> a folder with your data files in it ) >> >> >> Not sure if this will work on your retyped Equity account but may be worth a >> try. The range of the available account types displayed in the edit >> procedure is >> set by the account type of the parent account in the edit account process >> Can't >> guarantee it will work but worth a try. In the Edit Account process try >> setting >> the Parent Account for the trading account to "New top level account" and >> then >> try changing the account type back to Equity and then reset the parent >> account >> to Equity. >> >> David Cousens >> >> On Sat, 2021-09-25 at 17:17 -0400, Alton Brantley wrote: >>> I have an equity account which I use to record notes about purchases by >>> storing the file name as the note in the split and it always has a zero >>> value >>> so it sorts to the middle of the splits. >>> Sometime in the past couple months, this account became tagged as a >>> ?Trading? >>> account even though it and all of the transaction splits are in USD. >>> >>> I tried to create a new tracking account, and to delete the Trading account >>> by >>> moving the transactions over, but that wasn?t allowed. >>> >>> At this point, I cannot add transactions to the acco
[GNC] GnuCash 4.7 Released
The GnuCash development team announces GnuCash 4.7, the eighth release in the stable 4.x series Compatibility Notice In order to allow flatpak users to share preferences with installations outside of the sandbox we need to change the preference path from /org/gnucash to /org/gnucash/GnuCash. This release of GnuCash does that and it will automatically migrate existing preferences. It does not, however, continue to write preferences to the old path and it runs the migration only once. If you go back and forth between GnuCash 4.7 and an older versions you'll have two sets of preferences, one for GnuCash 4.7 and later and another for GnuCash 4.6 and earlier. This includes the file history list and last-opened file. Between 4.6 and 4.7, the following bugfixes were accomplished: Bug 87847 - RFE: Create a 'checkbox' cell type Bug 766052 - Job report payments wrong when payment contains splits Bug 797596 - New-owner - improved representation of payments with multiple non-APAR splits Bug 798142 - Tax rate appears as a fraction Bug 798180 - Update to macOS Big Sur 11.3 breaks Finance Quote Bug 798205 - Some transactions dropped with no apparent cause or warnings for credit card ofx import Do not exclude from import a transaction that has an FITID which matches an already existing split. This is because it (1) may be a coincidence and therefore the transaction needs to be added or (2) could be on a transfer from the account being imported to another bank account which has already been imported, and so needs to be matched, not added. Bug 798208 - management fee transactions are ignored on OFX import Bug 798211 - Equity statement double calculates unrealized gain Bug 798219 - apply/OK truncates exchange rates from 4 to 2 decimal places; enter doesn't Bug 798221 - Transfer funds between accounts with different currencies crashes Gnucash on macOS Bug 798224 - Scheduled transactions are created with date-entered copied from the template transaction. Bug 798229 - GncDate::c_formats is being created and destroyed twice resulting in a double free crash on every exit. Bug 798234 - Cut Transaction discards the reference to the description/memo strings so that Paste Transaction will paste uninitialised data (or other strings) Bug 798235 - Reconciliation Ending Balance not recalculated the 2nd and subsequent times Statement Date is updated. Bug 798237 - Logging during XML file loading degrades performance significantly Bug 798238 - "New security" dialog doesn't save the "Display symbol" Bug 798250 - Gnucash permanent hang on save while loading report Bug 798256 - Crash in recnFinishCB Bug 798298 - Re-imported transactions no longer ignored Bug 798303 - account list is sorted wrong by amount Bug 798312 - Opening the help for dialogues in the wrong language. The following fixes and improvements were not associated with bug reports: Lots of memory-leaks plugged Change the preferences path to org.gnucash.GnuCash to comply with flatpak requirements and migrate existing preferences to the new paths. This won't provide for automatic sync between a system-installed GnuCash and a flatpak one unless the system-installed one is GnuCash 4.7 or later. Please see the Wiki for more information and a procedure to convert your existing preferences. Cleanup - minimal glib=2.56.1 - drop all conditionals on older versions Add code to handle ofx files that include transfers between accounts During transaction import, ignore splits whose account is not the destination account Do not drop a potential match just because it has an online_id. Now that we don't exclude from import a transaction with an FITID that matches an already existing transaction, if one accidentally re-imports a transaction, this allows it to be automatically matched against the previously imported transaction. Add test for Transaction GetDate() in python bindings, pursuant to Bug 798284. In find customer dialog, add a column for "Shipping Contact" parameter Prep early splash screen messages for translation Change text for SX preference option 'Review created transactions' to better align with existing SX text. Fixed an XML backend problem where trying to open a locked file would clear the lock even if one didn't ask to, so the next attempt would find the file unlocked even if still open in another instance. Fix 2 crashes in Generic Transaction Matcher Handle very large denominators from Finance::Quote's OpenExchange source Update file extension in man pages per mailing list post. Changed some option names: From "Show Accounts until level" to "Levels of Subaccounts" From "Extra notes" to "Extra Notes" from "Report title" to "Report Title" From "Invoice number" to "Invoice Number" to ensure it matches all other invoice reports. Fix missing mnemonic keys
Re: [GNC] Investment Portfolio Reports Question
That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798219 and it's fixed for GnuCash 4.7 that we'll release this weekend. Regards, John Ralls > On Sep 22, 2021, at 2:51 PM, John Edgar wrote: > > Using GNUCash 4.6 > > I manually update my mutual fund closing price daily for the > investment/advanced portfolio reports. My report preference is set to a 4 > decimal number, as that is the format my bank supplies. However, when I > update the price, these reports round the price value to 2 decimal value, > causing the report to display a much different value of my fund holding than > is reported by my bank. > > Is there a preference or option I am missing to ensure the report remains as > non-rounded 4 decimal value ? I am unable to find a reference in the help > guide. > > Thank you for your help. > > > > -- > This email has been checked for viruses by AVG. > https://www.avg.com > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 setup
No, you don't want Imbalance-USD to have a balance. That's a safety-valve account that GnuCash uses when you make an unbalanced transaction by mistake. Opening Balances is for personal books. For a business you have two kinds of Equity: Paid in Capital, which is the money that you and any partners have invested in the business, and Retained Earnings, which is the net profit or loss from prior years. In the simplest case those will be the only two Equity accounts and should balance the difference between Assets and Liabilities. To create an opening transaction open the retained earnings register and start a new transaction in split mode. You can use Opening Balances as the transaction description if you like. Create a split for each asset and liability account with a balance. Don't forget to carry over contra accounts (e.g. depreciation) too. GnuCash will keep a running total in the blank split. When you're done with the assets and liabilities create Equity:Paid in Capital and credit however much that was. The remaining balance should match your carried over retained earnings, so you can just assign the split to Equity:Retained Earnings and you're done. If you're going to use GnuCash's billing and invoicing features, do *not* create splits for carried-over accounts payable and receivable in the Accounts Payable or Accounts Receivable accounts. Instead recreate the outstanding bills and invoices and close the income and expenses accounts into Retained Earnings before you start on the opening balances transaction. Be sure to use the Balance Sheet and Trial Balance Sheet reports to check your work before you start entering regular transactions. If you're going to be keying in 2020 and 2021 transactions refresh those reports often as you input so that you can catch mistakes when you have a small number of new transactions to hunt in. It can be really frustrating to hunt for a 0.03 error in 2 years of transactions. Regards, John Ralls > On Sep 22, 2021, at 1:28 PM, Rogier F. van Vlissingen > wrote: > > I guess that goes to Imbalance-USD, but then how does that balance out? Or > is it that once all the amounts are correct, it will balance and the > imbalance must revert to zero? How does that happen if some of the opening > balances were non-zero out of thin air? > > > On Wed, Sep 22, 2021 at 4:21 PM Rogier F. van Vlissingen > wrote: > >> OH, thanks >> >> Yeah, I already proceeded, I filled in the opening balances where I could, >> and am now starting to create the other accounts which did not exist in the >> standard chart of accounts, but trying to go and edit "retained earnings" I >> do not see how I can add the opening balance. >> >> it's not too many accounts in all, probably 25 total. >> >> So, if I create that opening balance as a transaction e.g. for retained >> earnings, where does the balancing transaction go? I guess I am not God's >> greatest gift to the bookkeeping profession ;-) >> >> >> <http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb> >> Rogier Fentener van Vlissingen <http://rogierfentenervanvlissingen.me> >> >> >> <http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb> >> >> >> On Wed, Sep 22, 2021 at 4:00 PM Stephen M. Butler < >> stephen.m.butle...@gmail.com> wrote: >> >>> Roger, >>> >>> I found it easier to leave all the opening balances at zero while >>> setting up the chart of accounts (COA). Then I create one massive >>> opening transaction dated (in your case) 12/31/2019. >>> >>> That way, if I find I forgot one account, I can add it later then go >>> back and adjust the opening transaction to include an entry for that new >>> account (I know the purist will have nightmares and would prefer you add >>> a new transaction). >>> >>> --Steve >>> >>> On 9/22/21 12:43 PM, Rogier F. van Vlissingen wrote: >>>> I am struggling to move an existing business into gnucash. >>>> >>>> Have a closing trial balance @ year end 2019 >>>> >>>> In the setup screen I don't necessarily have all the accounts, so I >>> imagine >>>> I can set them up later, but some accounts that area available do not >>> let >>>> me put in an opening balance. >>>> >>>> E.g. "retained earnings" has a balance, but in the set up screen there >>> is a >>>> greyed out "zero" and I cannot set up the opening balance. Can I edit >>> that
Re: [GNC] Trial Balance Issue with Fund Merger
> On Sep 1, 2021, at 12:16 PM, John Ralls wrote: > > > >> On Sep 1, 2021, at 11:15 AM, Lisa Rowell wrote: >> >> >> On 9/1/2021 5:27 AM, Lisa Rowell wrote: >>> >>> On 8/31/2021 9:41 PM, John Ralls wrote: >>>> >>>>> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: >>>>> >>>>> I'm working my way through my account history after a massive GnuCash >>>>> import, straightening out issues with missing realized capital >>>>> gains/losses and came across an event that I can't figure out how to >>>>> properly handle. >>>>> >>>>> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) >>>>> which merged with Spartan US Equity Index Investor Class (FUSEX) at some >>>>> odd rate around 1:0.513. When I did the import, I ended up with an >>>>> account for FSMKX and an account for FUSEX and a manually entered >>>>> exchange transaction which did a sell of FSMKX shares and a buy of FUSEX >>>>> shares with no share price. This got everything balanced out as far as >>>>> share counts go, but now I'm finding it's showing up as being not correct >>>>> in the Trial Balance. It looks to me like the exchange is being >>>>> interpreted as if an actual sell event had taken place. >>>>> >>>>> Can GnuCash properly account for this? The case in the manual's More >>>>> Complex Merger example is a bit different because the example stock >>>>> continued to trade under the same symbol, so that solution doesn't map >>>>> well. I found a past mailing list thread that said that the proper way to >>>>> account for this is as a sell transaction of the going away fund and a >>>>> buy transaction of the fund that lives on with an accompanying Realized >>>>> Gain transaction. This doesn't seem right to me though since I didn't >>>>> sell the shares and did not realize a gain and I don't even have prices >>>>> for the time of the merger. In my way of looking at it, the gain >>>>> calculation should come at the time of sale and be based on purchase >>>>> price of the various share amounts, and not at the time of the merger, >>>>> since that maps to the tax view of things where I live. >>>>> >>>>> I understand that GnuCash wouldn't be able to calculate the realized >>>>> gains post merger, and I'm ok with doing that in a side spreadsheet, but >>>>> am more looking for a way around the bogus realized gain entry at the >>>>> time of merger just to make the Trial Balance happy. >>>> If you're not too compulsive and since this is presumably ancient history >>>> in a personal book one simple way to deal with it would be to pretend that >>>> you bought the FUSEX in the first place and ignore the FSMKX, but that >>>> might be a little painful if you have a bunch of reinvested FSMKX dividend >>>> transactions that you'd also need to change. >>>> >>>> I've handled similar situations in the past by doing a simple transfer >>>> transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX >>>> 1000. As long as there's no currency component to the transaction it >>>> shouldn't create a trading imbalance in the book currency. >>>> >>>> Regards, >>>> John Ralls >>> >>> That solution was what worked for me for share transfers between >>> brokerages, where the commodity was the same, but when I changed >>> commodities it somehow shows up as a mismatch in the Trial Balance. I don't >>> have a share price for the shares in either split so, in theory it >>> shouldn't involve the book currency at all. I don't get it at all. >>> >>> I'm sure it's this transaction since the balances match on the previous day >>> and the only other transaction on this date is a paycheck deposit in the >>> book currency that's no where near the amount of the imbalance. The >>> transaction is in the image attached, that's what you're advocating, right? >>> >>> Thanks. >>> >>> Lisa R. >>> >> Additional information: >> >> Removing the cross commodity sell/buy transaction does remove the Trial >> Balance discrepancy. Additionally I added up all of the purchase prices of >> shares of the fund being merged away
Re: [GNC] Trial Balance Issue with Fund Merger
> On Sep 1, 2021, at 11:15 AM, Lisa Rowell wrote: > > > On 9/1/2021 5:27 AM, Lisa Rowell wrote: >> >> On 8/31/2021 9:41 PM, John Ralls wrote: >>> >>>> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: >>>> >>>> I'm working my way through my account history after a massive GnuCash >>>> import, straightening out issues with missing realized capital >>>> gains/losses and came across an event that I can't figure out how to >>>> properly handle. >>>> >>>> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) >>>> which merged with Spartan US Equity Index Investor Class (FUSEX) at some >>>> odd rate around 1:0.513. When I did the import, I ended up with an account >>>> for FSMKX and an account for FUSEX and a manually entered exchange >>>> transaction which did a sell of FSMKX shares and a buy of FUSEX shares >>>> with no share price. This got everything balanced out as far as share >>>> counts go, but now I'm finding it's showing up as being not correct in the >>>> Trial Balance. It looks to me like the exchange is being interpreted as if >>>> an actual sell event had taken place. >>>> >>>> Can GnuCash properly account for this? The case in the manual's More >>>> Complex Merger example is a bit different because the example stock >>>> continued to trade under the same symbol, so that solution doesn't map >>>> well. I found a past mailing list thread that said that the proper way to >>>> account for this is as a sell transaction of the going away fund and a buy >>>> transaction of the fund that lives on with an accompanying Realized Gain >>>> transaction. This doesn't seem right to me though since I didn't sell the >>>> shares and did not realize a gain and I don't even have prices for the >>>> time of the merger. In my way of looking at it, the gain calculation >>>> should come at the time of sale and be based on purchase price of the >>>> various share amounts, and not at the time of the merger, since that maps >>>> to the tax view of things where I live. >>>> >>>> I understand that GnuCash wouldn't be able to calculate the realized gains >>>> post merger, and I'm ok with doing that in a side spreadsheet, but am more >>>> looking for a way around the bogus realized gain entry at the time of >>>> merger just to make the Trial Balance happy. >>> If you're not too compulsive and since this is presumably ancient history >>> in a personal book one simple way to deal with it would be to pretend that >>> you bought the FUSEX in the first place and ignore the FSMKX, but that >>> might be a little painful if you have a bunch of reinvested FSMKX dividend >>> transactions that you'd also need to change. >>> >>> I've handled similar situations in the past by doing a simple transfer >>> transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. >>> As long as there's no currency component to the transaction it shouldn't >>> create a trading imbalance in the book currency. >>> >>> Regards, >>> John Ralls >> >> That solution was what worked for me for share transfers between brokerages, >> where the commodity was the same, but when I changed commodities it somehow >> shows up as a mismatch in the Trial Balance. I don't have a share price for >> the shares in either split so, in theory it shouldn't involve the book >> currency at all. I don't get it at all. >> >> I'm sure it's this transaction since the balances match on the previous day >> and the only other transaction on this date is a paycheck deposit in the >> book currency that's no where near the amount of the imbalance. The >> transaction is in the image attached, that's what you're advocating, right? >> >> Thanks. >> >> Lisa R. >> > Additional information: > > Removing the cross commodity sell/buy transaction does remove the Trial > Balance discrepancy. Additionally I added up all of the purchase prices of > shares of the fund being merged away and that amount does equal to the credit > / debit difference in the report. > It is, but that doesn't quite work. Here's a sample that does: If you don't price the share transfer to the currency (USD in both examples) the trial balance logic assumes 0 and calculates a loss. To avoid that enter the book value of the shares you're transferring as a sell (credit) amount in the source split and a buy (debit) amount in the destination split: ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Information
It can, but it has a rendering issue on Retina screens set to something other than the default scaling, see https://bugs.gnucash.org/show_bug.cgi?id=798207. Regards, John Ralls > On Sep 1, 2021, at 11:31 AM, Chris Green wrote: > > On Wed, Sep 01, 2021 at 12:02:42PM -0500, alanmagnus wrote: >> Is Gnucash yet compatible with the upcoming Mac OSX Monterey? > > Or, to put it another way, can the new Mac OSX Monterey run GnuCash? > > -- > Chris Green > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trial Balance Issue with Fund Merger
> On Aug 31, 2021, at 8:32 PM, Lisa Rowell wrote: > > I'm working my way through my account history after a massive GnuCash import, > straightening out issues with missing realized capital gains/losses and came > across an event that I can't figure out how to properly handle. > > I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) which > merged with Spartan US Equity Index Investor Class (FUSEX) at some odd rate > around 1:0.513. When I did the import, I ended up with an account for FSMKX > and an account for FUSEX and a manually entered exchange transaction which > did a sell of FSMKX shares and a buy of FUSEX shares with no share price. > This got everything balanced out as far as share counts go, but now I'm > finding it's showing up as being not correct in the Trial Balance. It looks > to me like the exchange is being interpreted as if an actual sell event had > taken place. > > Can GnuCash properly account for this? The case in the manual's More Complex > Merger example is a bit different because the example stock continued to > trade under the same symbol, so that solution doesn't map well. I found a > past mailing list thread that said that the proper way to account for this is > as a sell transaction of the going away fund and a buy transaction of the > fund that lives on with an accompanying Realized Gain transaction. This > doesn't seem right to me though since I didn't sell the shares and did not > realize a gain and I don't even have prices for the time of the merger. In my > way of looking at it, the gain calculation should come at the time of sale > and be based on purchase price of the various share amounts, and not at the > time of the merger, since that maps to the tax view of things where I live. > > I understand that GnuCash wouldn't be able to calculate the realized gains > post merger, and I'm ok with doing that in a side spreadsheet, but am more > looking for a way around the bogus realized gain entry at the time of merger > just to make the Trial Balance happy. If you're not too compulsive and since this is presumably ancient history in a personal book one simple way to deal with it would be to pretend that you bought the FUSEX in the first place and ignore the FSMKX, but that might be a little painful if you have a bunch of reinvested FSMKX dividend transactions that you'd also need to change. I've handled similar situations in the past by doing a simple transfer transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. As long as there's no currency component to the transaction it shouldn't create a trading imbalance in the book currency. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction Entry Confirmation
> On Aug 31, 2021, at 8:06 AM, Jack Frillman via gnucash-user > wrote: > > > Is there any way to have GNU Cash make an audio confirmation when a manual > transaction has been entered? > > When I manually enter a transaction by mashing ENTER there is no feedback > that the transaction was entered and I keep hitting ENTER to be sure I didn't > fat finger it. > Just a little beep would suffice. No, sorry. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can GnuCash compute income from foreign exchange transactions using the first in first out method?
GnuCash does have that built in, see Actions>View Lots. It is however a bit cumbersome and isn't likely to scale well for your use case. You might try using trading accounts and creating a balancing G/L transaction at the end of each day, but I think that will come out closer to average cost than to fifo. Regards, John Ralls > On Aug 30, 2021, at 5:04 PM, Tim Hume via gnucash-user > wrote: > > Hi everyone, > > I'm using GnuCash for a small money transfer business. There are lots of > transactions from Australia to Tonga, and transactions going the other way > (Tonga to Australia) too. Transactions are of varying amounts and happen > frequently. > > From day to day GnuCash handles this fine (though the database is getting > rather large). In fact, one reason for using GnuCash is that it handles > foreign currencies (and it's free). For tax, it is necessary to compute > income using the first in first out method (FIFO). The way I've been doing > this to date is to dump the transactions going through the trading accounts > into CSV format, and then using a small program I wrote to compute the income > using the FIFO method (the program is written in awk for anyone curious). > > However, it would be really nice if GnuCash could do this computation itself. > Is this possible? > > Cheers, > > Tim. > > Sent with ProtonMail Secure Email. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Alternate Language (Again)
> On Aug 27, 2021, at 2:59 PM, wrote: > > I should be following up an earlier thread of two weeks ago, but I find I've > deleted the messages from my Inbox and can't see any way to "Reply To" > something I only have in the archives. So I'm creating a new thread > (Apologies: I'm no longer used to using true mailing lists instead of > wrappers like nabble that make it all child's play). > > Here's that prior thread: > >> On Aug 20, 2021, at 10:29 AM, > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> wrote: >> >> Hello all. This may have already been covered, but after the death of > Nabble >> I can't see how to do searches throughout the archive. >> >> I need to produce accounting reports in a different language (French), but > I >> would prefer to use a single installation of Gnucash (all my other sets of >> books are English). >> >> 1. Can I switch languages just for printing the reports? If yes, how? I >> understand that the Account Names, Descriptions, and so on are all going > to >> need to be recorded in French in this set of books. >> >> 2. If that's not possible, how can I install two versions of GnuCash on >> Windows? Can I open the books in English Gnucash, work on them, then close >> and reopen the same books in the French GnuCash? > > Most search engines can search the list archives, just say > site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. > > There's no such thing as English or French versions of GnuCash, every > installation on Windows and macOS includes all of the translations. Some > Linux distros try to save a few kB of space by separating out the > translations, but that's not your concern. > > What you want to do is make a shortcut to GnuCash with the LANG environment > variable set to "fr_FR" as explained by this blog post: > https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows > -shortcut/ > > Regards, > John Ralls > > = > > That seemed to fully answer the basic question, but now that I try it out, I > find it doesn't work. I still get everything (except the creation of the > Chart of Accounts, for which the language selection is working) in English. > > Here is the shortcut target I'm using, as per the link suggested: > > C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && START /D ^"C:\Program > Files (x86)\gnucash\bin^" gnucash.exe" > > Compare with the webpage text, which is: > C:\Windows\System32\cmd.exe /c "SET LANG=en && START /D ^"C:\Program Files > (x86)\Inkscape^" inkscape.exe" > > As these are as close to identical as can be achieved, I am at a loss as to > why it doesn't work. GnuCash has another layer to it's localization. Try C:\Windows\System32\cmd.exe /c "SET LANG=fr_FR && SET LANGUAGE=fr_FR && START /D ^"C:\Program Files (x86)\gnucash\bin^" gnucash.exe" 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] windows 10 and v4.6 possible system language vs appliation language
> On Aug 27, 2021, at 12:37 PM, Karin Lagesen wrote: > > Hi! > > I just started using v4.6 on a new machine running windows 10. For > various reasons, despite being in Norway, I prefer having US language on my > main computer, including date formats. However, I prefer having numbers on > gnucash being in Norwegian format. > > Is there any way to run gnucash in Norwegian on a otherwise US region > computer? > https://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_a_different_language_than_my_monetary.2Fdecimal_separator 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Paying expenses with cryptocurrency
> On Aug 27, 2021, at 10:25 AM, David G. Pickett via gnucash-user > wrote: > > I am sure the accountants would not like the idea, but it opens the subject > of having different accounts in different currencies. This seems less > revolutionary in an international commerce world, like having a London > account in Pounds Sterling. You could buy with any account in the currency > of that account, rather than a book/default currency. I wonder if that would > hide any capital appreciation in the currency, perhaps legally, somewhat like > barter? I guess it would be an enhancement suggestion. I guess you mean to allow Equity accounts in foreign--meaning not the book's--currencies. You can already have Asset and Liability accounts in any commodity you like. Legality aside, why would you want to hide trading G/L from yourself? Why go to the trouble of keeping your books in GnuCash if you don't want an accurate model of your financial condition? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Paying expenses with cryptocurrency
> On Aug 25, 2021, at 10:29 PM, Peter West wrote: > > The recommended mode of dealing with crypto seems to be to record your crypto > as a stock, and handle fluctuation in prices as you would for a stock. When > you are investing crypto that makes sense. But what if you are using crypto > for purchases? That is, if you are using cryptocurrency for the originally > intended purpose? > > Any ideas on how to record this? Aside from the way GnuCash presents assets in registers the only difference between currencies and non-currency commodities is that you can't have Equity or Payable/Receivable accounts denominated in non-currency commodities. We've been told by a licensed accountant that one shouldn't have those accounts in anything other than the book currency anyway. So the answer is that that's how you account for transactions in all currencies, crypto or national, other than the book currency: You price them back to the book currency on the day of the transaction and record any resulting trading gains or losses. Do it any other way and you'll make yourself crazy trying to get your book to balance. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Job Costing as now available
I'll respond now: No, nothing like that has been contributed nor is it being
contemplated by any of the core devs AFAIK. Well designed and written pull
requests welcome.
Regards,
John Ralls
> On Aug 21, 2021, at 9:42 AM, Mike Butcher wrote:
>
> Don, have you seen any response to this message or find a solution
> otherwise? I too need this function in a big way. Making a new account for
> every order is horribly messy and cumbersome. It's been a year and a half
> and I was hoping someone on the development team might have an answer. I
> love GNUcash for my personal life but cannot use it for business without
> some form of jobcosting. I have to reenter info into a database I
> assembled for that.
>
> Take care,
> ~Mike Butcher
>
> On Sat, May 23, 2020 at 4:04 PM doncram wrote:
>
>> Hi, I recently installed and am using GnuCash (Version: 3.10 / Build ID:
>> 3.10+(2020-04-11), on Windows). I am happy to see some functionality for
>> Job Costing has been added in recent years. This is very important to
>> develop so that many more small businesses could possibly use GnuCash. But
>> what is available vs. what is missing and critically needed?
>>
>> Job Costing allows for projects to be defined for, say, construction firms
>> building individual houses, or catering firms doing catering jobs, or
>> manufacturing firms building batches of product. Or it allows a nonprofit
>> or business to define a job for a specific grant or other restricted
>> funding source. And then to track and match the revenues and expenses
>> specific to each project.
>>
>> This is terribly important so that management can attempt to figure out
>> which jobs have been more profitable and why. And I have seen arriving
>> users turned away from GnuCash (e.g. a catering firm a few years ago)
>> because it has been so clear that GnuCash can't serve them. The catering
>> firm needed to do separate accounting & reports for each job, but if i
>> recall correctly was told that it should do it by creating new accounts
>> specific to each job. So its Chart of Accounts would grow longer and
>> longer as its Sales and various Expense types of accounts would have to be
>> duplicated for each repetitive client/job. It would need to create a new
>> account, e.g. Sales-Job#013 for the payments it received for job number 13,
>> and a new Food purchases-Job#13 and a new Labor-Job#13 etc. for each of its
>> standard type of expenses. This would rapidly become totally unworkable,
>> and it does not allow for side-by-side comparison of
>> revenues/expenses/profitability of jobs, so of course the catering person
>> went away. And for existing firms that do use GnuCash but have not tracked
>> separate projects/jobs to date, many of them could benefit if they could be
>> allowed to start doing so.
>>
>> In the current stable version of GnuCash, it is now possible to create
>> jobs. For example, I created a "test b company" with several expense
>> transactions, and created a "job1" underneath "customer A". I can't see
>> yet how to assign job codes to any specific revenue or expense item. In
>> any account register, a new Customer:Job column needs to appear, where I
>> would enter the relevant job for each line ("split"). I should not be
>> _required_ to enter anything into the Customer:Job column, but for any
>> split where I do want to assign the expense or revenue to a specific job, I
>> should be able to do so. And, say if I pay $200 to one contractor for work
>> done on two jobs, I would create two splits, one for each job, and record,
>> say $120 of contractor expense for job#13 and $80 for job #14.
>>
>> Then I want/need an Income Statement By Job report, which would be a
>> regular Income Statement in its first columns, and would report
>> job-specific income statements for each job in following columns. So this
>> would possibly become a very wide report, but that is okay by me, as long
>> as I can scroll over to see any specific job. And like for other reports,
>> I should be able to set Options / Display to show only the rows where there
>> is any non-zero data, and also only the columns where there is any non-zero
>> data (so in a report for Fiscal Year 2020, I don't have to see a column for
>> a job completed in 2018).
>>
>> The only report I find, though, is the one at Reports/Business/Job, which
>> turns out to be some kind of Aging of Receivables report for just one job.
>> Instead of allowing me to run this report for all jobs (like should be
>> available in a general Aging of Receivables r
Re: [GNC] Reports in Alternate Language
> On Aug 20, 2021, at 10:29 AM, wrote: > > Hello all. This may have already been covered, but after the death of Nabble > I can't see how to do searches throughout the archive. > > > > I need to produce accounting reports in a different language (French), but I > would prefer to use a single installation of Gnucash (all my other sets of > books are English). > > > > 1.Can I switch languages just for printing the reports? If yes, how? I > understand that the Account Names, Descriptions, and so on are all going to > need to be recorded in French in this set of books. > > > > 2.If that's not possible, how can I install two versions of GnuCash on > Windows? Can I open the books in English Gnucash, work on them, then close > and reopen the same books in the French GnuCash? > Most search engines can search the list archives, just say site:lists.gnucash.org/pipermail/gnucash-user followed by your search terms. There's no such thing as English or French versions of GnuCash, every installation on Windows and macOS includes all of the translations. Some Linux distros try to save a few kB of space by separating out the translations, but that's not your concern. What you want to do is make a shortcut to GnuCash with the LANG environment variable set to "fr_FR" as explained by this blog post: https://netlicensing.io/blog/2012/06/15/set-environment-variables-in-windows-shortcut/ 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote on Mac M1
That's what "Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own." is about. The issue is that when you launch from Finder there's no shell so GnuCash can't see your MacPorts environment changes. Try launching GnuCash from a shell window that does have the MacPorts environment. Regards, John Ralls > On Aug 20, 2021, at 3:55 AM, Peter West wrote: > > Doesn’t work for me. > > Note: I’m assuming that the message Finance::Quote not installed properly, > when Add is invoked in the security editor, means that it’s not installed > properly. > > I depend a lot on MacPorts. I’ve tried forcing the installation with MacPorts > perl 5.34 foremost in my path, and with it (and all other perl binaries) > relegated in my path. It makes no difference to the appearance of that > message. > > In each case I have checked the installation paths of perl. In the first the > installation paths are in /opt/local, in the latter they are in /usr, > /Library, /System, /Network and /usr/local. > > Peter > — > Peter West > p...@ehealth.id.au > “On these two commandments depend all the Law and the Prophets.” > >> On 20 Aug 2021, at 2:21 pm, Colin wrote: >> >> Thank you John! I ran the commands you provided and Finance::Quote works for >> the first time since I got my M1 MacBook Air! I’ve been watching the >> Finance::Quote threads on the list the last few months, always hoping for a >> solution I could manage to I implement to fix the issue. No doubt I could >> have missed this if it was posted before, regardless you just made my day. >> >> For what it’s worth, my install of GnuCash was done the standard way - >> downloading the DMG from the website. >> >> Also, to make the solution crystal clear to those who are not as good on the >> command line, there was a typo in John’s most recent advice of the commands >> to run. It is B::Keywords (capital K): >> >> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i Finance::Quote >> >> Very gratefully, >> Colin >> >>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote: >>> >>> Message: 5 >>> Date: Thu, 19 Aug 2021 20:36:28 -0700 >>> From: John Ralls mailto:jra...@ceridwen.us>> >>> To: davel...@mac.com <mailto:davel...@mac.com> >>> Cc: Mailing List Gnucash >> <mailto:gnucash-user@gnucash.org>> >>> Subject: Re: [GNC] Finance::Quote on Mac M1 >>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us >>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>> >>> Content-Type: text/plain; charset=utf-8 >>> >>> You didn't read my letter very carefully: You should be able to get quotes >>> now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan >>> -i Finance::Quote`. The system perl is a universal binary and works in both >>> native and Rosetta2 environments. Perl from other sources may or may not >>> work and will regardless require modifying >>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path >>> and @INC so that GnuCash can find the right F::Q. If you insist on that >>> you're on your own. >>> >>> As for a native M1 build, I haven't decided yet whether to do that before >>> the next major nettle release. I really don't like pushing development >>> software at ordinary users, it tends to make for unpleasant surprises. >>> Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong >>> argument for doing a native build until nettle's ARM64 implementation is in >>> a stable release. >>> >>> 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 >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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.o
Re: [GNC] Finance::Quote on Mac M1
You didn't read my letter very carefully: You should be able to get quotes now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan -i Finance::Quote`. The system perl is a universal binary and works in both native and Rosetta2 environments. Perl from other sources may or may not work and will regardless require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path and @INC so that GnuCash can find the right F::Q. If you insist on that you're on your own. As for a native M1 build, I haven't decided yet whether to do that before the next major nettle release. I really don't like pushing development software at ordinary users, it tends to make for unpleasant surprises. Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong argument for doing a native build until nettle's ARM64 implementation is in a stable release. Regards, John Ralls > On Aug 19, 2021, at 3:12 PM, davelist--- via gnucash-user > wrote: > > So does this mean a future official build of gnucash will have an ARM version > and we'll be able to get quotes again? That would be great! > > Thanks, > Dave > >> On Aug 19, 2021, at 5:43 PM, John Ralls wrote: >> >> You can't escape the problems. ;-) >> >> FWIW I just completed building on an M1 with Monterey. Amazingly, there were >> only a few minor problems, one of which has nothing to do with M1 or >> Monterey: Boost's download site changed. >> >> Libdbi and libdbi-drivers last release tarballs were made in 2013 and >> include linker arguments that aren't supported. I switched the build to git >> clones so that the build can be regenerated from scratch. Both that and the >> Boost change are committed to gnucash-on-osx. >> >> The other problem, and perhaps the one that stopped you on MacPorts, is that >> even the latest release of Nettle from last month doesn't support ARM64. It >> tries to compile ARM32 and fails noisily for hundreds of unrecognized >> assembler instructions. The solution is to clone the master branch from >> http://git.lysator.liu.se/nettle/nettle and build that instead. >> >> BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, >> after which everything else built correctly. Once F::Q was installed in >> /Library/Perl GnuCash was able to recognize it and enable the Get Quotes >> button. >> >> Regards, >> John Ralls >> >> >> >> >>> On Aug 19, 2021, at 1:40 AM, Peter West wrote: >>> >>> Hi John, >>> >>> I had already run into problems trying to build GnuCash on MacPorts. I was >>> encouraged to try to build by reading >>> <https://wiki.gnucash.org/wiki/MacOS/Quartz>. >>> >>> Peter >>> — >>> Peter West >>> p...@ehealth.id.au >>> “For behold, when the sound of your greeting came to my ears, the baby in >>> my womb leaped for joy.” >>> >>>> On 17 Aug 2021, at 1:02 am, John Ralls wrote: >>>> >>>> >>>> Support for gtk-osx is on its mailing list, >>>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you >>>> go there I'll remind you that one of gtk-osx's basic requirements is that >>>> you must not have Homebrew or MacPorts visible to it. >>>> >>>> Since you have MacPorts installed already the simplest way forward is to >>>> use that to build GnuCash. >>>> >>>> That said there's no shared code between anything to do with GnuCash and >>>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from >>>> source won't help you get Finance::Quote going. >>>> >>>> Regards, >>>> John Ralls >>>> >>>>> On Aug 16, 2021, at 7:18 AM, Peter West wrote: >>>>> >>>>> I removed the offending PREFIX line from jhbuildrc-custom, and >>>>> immediately ran into a similar problem. >>>>> >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load >>>>> execfile(filename, config) >>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in >>>>> execfile >>>>> exec(code, globals, locals) >>>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in >>>>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec')) >>>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in >>>>
Re: [GNC] Finance::Quote on Mac M1
You can't escape the problems. ;-)
FWIW I just completed building on an M1 with Monterey. Amazingly, there were
only a few minor problems, one of which has nothing to do with M1 or Monterey:
Boost's download site changed.
Libdbi and libdbi-drivers last release tarballs were made in 2013 and include
linker arguments that aren't supported. I switched the build to git clones so
that the build can be regenerated from scratch. Both that and the Boost change
are committed to gnucash-on-osx.
The other problem, and perhaps the one that stopped you on MacPorts, is that
even the latest release of Nettle from last month doesn't support ARM64. It
tries to compile ARM32 and fails noisily for hundreds of unrecognized assembler
instructions. The solution is to clone the master branch from
http://git.lysator.liu.se/nettle/nettle and build that instead.
BTW, on Finance::Quote I force-installed B::Keywords and installed Test2, after
which everything else built correctly. Once F::Q was installed in /Library/Perl
GnuCash was able to recognize it and enable the Get Quotes button.
Regards,
John Ralls
> On Aug 19, 2021, at 1:40 AM, Peter West wrote:
>
> Hi John,
>
> I had already run into problems trying to build GnuCash on MacPorts. I was
> encouraged to try to build by reading
> <https://wiki.gnucash.org/wiki/MacOS/Quartz>.
>
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “For behold, when the sound of your greeting came to my ears, the baby in my
> womb leaped for joy.”
>
>> On 17 Aug 2021, at 1:02 am, John Ralls wrote:
>>
>>
>> Support for gtk-osx is on its mailing list,
>> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you
>> go there I'll remind you that one of gtk-osx's basic requirements is that
>> you must not have Homebrew or MacPorts visible to it.
>>
>> Since you have MacPorts installed already the simplest way forward is to use
>> that to build GnuCash.
>>
>> That said there's no shared code between anything to do with GnuCash and
>> perl or any CPAN modules beyond the macOS SDK. Building GnuCash from source
>> won't help you get Finance::Quote going.
>>
>> Regards,
>> John Ralls
>>
>>> On Aug 16, 2021, at 7:18 AM, Peter West wrote:
>>>
>>> I removed the offending PREFIX line from jhbuildrc-custom, and immediately
>>> ran into a similar problem.
>>>
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>> execfile(filename, config)
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>>> execfile
>>> exec(code, globals, locals)
>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in
>>> module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + '
>>> -std=c++17'}
>>> File
>>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>>> line 675, in __getitem__
>>> raise KeyError(key) from None
>>> KeyError: 'CXXFLAGS'
>>> jhbuild: could not load config file
>>>
>>> In this one, there is obviously a default value, but the Error is
>>> propagating all the way up.
>>>
>>> Peter
>>>
>>>
>>> —
>>> Peter West
>>> p...@ehealth.id.au
>>> “For behold, when the sound of your greeting came to my ears, the baby in
>>> my womb leaped for joy.”
>>>
>>>> On 16 Aug 2021, at 8:21 pm, Peter West wrote:
>>>>
>>>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get
>>>> M1-specific GNC and Finance::Quote working together without any mysterious
>>>> issues.
>>>>
>>>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it
>>>> fails immediately.
>>>>
>>>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
>>>> Loading .env environment variables...
>>>> Traceback (most recent call last):
>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>>> execfile(filename, config)
>>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>>>> execfile
>>>> exec(code, globals, locals)
>>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>>> exec(compile(open(_user_rc, "rb").re
Re: [GNC] Finance::Quote on Mac M1
Support for gtk-osx is on its mailing list,
https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list, but before you go
there I'll remind you that one of gtk-osx's basic requirements is that you must
not have Homebrew or MacPorts visible to it.
Since you have MacPorts installed already the simplest way forward is to use
that to build GnuCash.
That said there's no shared code between anything to do with GnuCash and perl
or any CPAN modules beyond the macOS SDK. Building GnuCash from source won't
help you get Finance::Quote going.
Regards,
John Ralls
> On Aug 16, 2021, at 7:18 AM, Peter West wrote:
>
> I removed the offending PREFIX line from jhbuildrc-custom, and immediately
> ran into a similar problem.
>
> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>execfile(filename, config)
> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
> execfile
>exec(code, globals, locals)
> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in
>module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + '
> -std=c++17'}
> File
> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
> line 675, in __getitem__
>raise KeyError(key) from None
> KeyError: 'CXXFLAGS'
> jhbuild: could not load config file
>
> In this one, there is obviously a default value, but the Error is propagating
> all the way up.
>
> Peter
>
>
> —
> Peter West
> p...@ehealth.id.au
> “For behold, when the sound of your greeting came to my ears, the baby in my
> womb leaped for joy.”
>
>> On 16 Aug 2021, at 8:21 pm, Peter West wrote:
>>
>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get
>> M1-specific GNC and Finance::Quote working together without any mysterious
>> issues.
>>
>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it fails
>> immediately.
>>
>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
>> Loading .env environment variables...
>> Traceback (most recent call last):
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>execfile(filename, config)
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in
>> execfile
>>exec(code, globals, locals)
>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in
>>exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in
>>prefix = os.environ['PREFIX']
>> File
>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>> line 675, in __getitem__
>>raise KeyError(key) from None
>> KeyError: 'PREFIX'
>> jhbuild: could not load config file
>>
>>
>> I'
>>
>> The first thing in .config/jhbuildrc-custom is
>> prefix = os.environ['PREFIX’]
>>
>> So there is no envar PREFIX defined in my environment. That’s easy enough to
>> fix, but what is it supposed to be? Should this Error jusst be caught and
>> defaulted?
>>
>> I don’t do python, so I don’t know how the error/exception process works.
>>
>> Peter
>>
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “For behold, when the sound of your greeting came to my ears, the baby in my
>> womb leaped for joy.”
>>
>>> On 4 Aug 2021, at 7:39 pm, Geoff >> <mailto:cleanoutmys...@gmail.com>> wrote:
>>>
>>> Yes, I don't like doing forced installations either, but this particular
>>> module isn't very important in the overall Finance::Quote scheme of events.
>>>
>>> Here are two suggestions.
>>>
>>> (1) Hack. I'm not familiar with MAC directory structures, but I had a look
>>> at the particular test that is failing, and I reckon that if you create an
>>> empty file here it might just trick it into passing:
>>>
>>> /System/Library/Perl/5.30/darwin-thread-multi-2level/CORE/keywords.h
>>>
>>>
>>> (2) Manual install of B::Keywords without using CPAN:
>>> (a) Download B-Keywords-1.22.tar.gz from here:
>>> https://metacpan.org/pod/B::Keywords <https://metacpan.org/pod/B::Keywords>
>>>
>>> (b) Unzip and untar it to a temp directory.
>>>
>>> (c) From the command line in that dire
Re: [GNC] password when using mysql backend
I don't think that Libsecret is optional and AFAIK no user configuration is necessary. The file you'll need to rewrite to suit your purposes is gnucash/gnome-utils/gnc-keyring.c. Good Luck. Regards, John Ralls > On Aug 13, 2021, at 9:09 PM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > thank you, but I am not using gnome keyring, or any other key manager. > > I would like to simply store the password somewhere in a file in my > gnucash profile. > > how can I do this? > > > On 2021-08-13 17:59, John Ralls wrote: >>> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: >>> Is it possible to store the mysql password somewhere locally? >> >> It's supposed to be stored in libsecret. Check your trace file >> (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings >> gnc_keyring_set_password and gnc_keyring_get_password. >> >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] password when using mysql backend
> On Aug 13, 2021, at 2:00 AM, Fourhundred Thecat <400the...@gmx.ch> wrote: > > Hello, > > I am using gnucash 3.4-1 on Debian 10. And I am using mysql backend. > > Every time I start gnucash, I have to type my password manually. This is > very annoying, and as far as I can tell adds no real security. > > Is it possible to store the mysql password somewhere locally? > > If this is not possible, how could I hardcode the password into gnucash, > and recompile ? I am fine with recompiling, I had to do it for other > purpose anyway It's supposed to be stored in libsecret. Check your trace file (https://wiki.gnucash.org/wiki/Tracefile) for errors/warnings gnc_keyring_set_password and gnc_keyring_get_password. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"
> On Aug 7, 2021, at 1:35 PM, Ashok Sinha wrote: > > Hello everyone, trying this list for the first time, I hope I am following > the instructions. > > I have downloaded and prepared an import.csv file with 2 lines as: > 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021 > 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064 > > Where the columns are Date, Namespace, From Symbol, To Currency, Amount > > The 'Namespace', & 'Currency To' dropdown comes up with an error > respectively as: > Error 1: Column 'From Namespace' could not be understood. Value can't be > parsed into a valid namespace. > Error 2: Column 'Currency To' could not be understood. Value can't be > parsed into a valide commodity. > > Could somebody please explain to me how to import the prices? I think I'm > doing it right - there's a screenshot below. > > The above example has 2 different mutual funds. Once the concept is proved, > I plan to update many (~20) mutual fund prices from a single import csv > file on a weekly basis. Try removing the leading spaces from the namespace and currency columns. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash on macOS Monterey beta
David, Please don't write me or other GnuCash developers directly unless explicitly asked to. Please use the lists, IRC, or the bug tracker. Yes, Gtk window scaling issues on Monterey have already been reported: https://bugs.gnucash.org/show_bug.cgi?id=798207 Regards, John Ralls > On Jul 27, 2021, at 3:57 PM, David Reed wrote: > > John, > > I'm have a couple hobby iOS/Mac apps so I've installed the macOS Monterey > beta in a separate APFS container. Just in case you're not aware, GnuCash > does not seem to work correctly on it. The window seems to not scale > correctly and I can't select the open/cancel button in the file dialog to > open a file. I may have missed someone asking on the GnuCash mailing list as > I haven't been good keeping up with it but wanted you to know if you weren't > aware so perhaps as Monterey gets closer to release, people are warned if it > doesn't work then yet. > > If it would be helpful to see screenshots (if you don't have access to > Monterey) or anything else, let me know. > > Thanks for all that you do in support GnuCash! > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice font size has changed
> On Jul 27, 2021, at 10:01 AM, coolnodje wrote: > > Hi, > > the invoice I print from Gnucash have become printed smaller for some > reason. > I can't explain it, nor can I find any place to control this. (I > switched from Default to CSS experimental which makes it slightly larger > but still quite smaller than it used to be) > > I upgraded to 4.6 as soon as it was out (I'm using brew on MacOS ) and > believe my last invoice was made with this same latest version. > I rebooted my computer, which was on for a lot longer than when the new > release was installed. (it's not supposed to explain anything, but as I > keep Gnucash open all the time these days, switching book accounts, it > feels like it's the most meaningful change I've made to my Gnucash ... sic) Edit>Stylesheets. The CSS-based stylesheet uses CSS directly, so adjust the font-size attributes in the elements you want to change. If you don't know CSS works you might prefer to switch back to the stylesheet you were using before and edit it instead. Go to the fonts tab and use the font chooser to select the typeface and size you want for each element. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
No, that switches only the libgnc*.so libs in lib/gnucash. There are others in lib/. You cannot build GnuCash with an installed GnuCash. You must `sudo apt-get remove gnucash` then `rm -rf *` your build directory and re-run cmake && ninja. Regards, John Ralls > On Jul 20, 2021, at 9:16 PM, Dong Lin wrote: > > > vm-ubuntu-1:~/src/build-gnucash$ mv lib lib-local-build > vm-ubuntu-1:~/src/build-gnucash$ ln -s /usr/lib/x86_64-linux-gnu/gnucash lib > > this only switches the libgnc-*.so libs only. all other libs continue to > point to /usr/lib. > > vm-ubuntu-1:~/src/build-gnucash$ ./bin/gnucash > ./bin/gnucash: symbol lookup error: ./bin/gnucash: undefined symbol: > gnc_run_report_with_error_handling > > >> Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was >> libgnc-html.so linked to if not the ones in /usr/lib? >> >> Regards, >> John Ralls >> >>> On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: >>> >>> >>> On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the >>> apt >>> installed GNC runs fine with charts visible. >>> >>> But locally built GNC (tip of the latest maint branch) has the same >>> issue. >>> I tried switching the libs in build_dir to point to >>> /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an >>> undefined symbol gnc_run_report_with_error_handling and couldn't start. >>> >>> apt removed the system gnucash, purged ~/.cache. reran the local gnc, >>> same >>> problem, blank charts. >>> only the table is visible. >>> >>> the build environment was prepared with apt-get build-dep gnucash as >>> instructed. >>> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was libgnc-html.so linked to if not the ones in /usr/lib? Regards, John Ralls > On Jul 20, 2021, at 7:55 PM, Dong Lin wrote: > > > On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the apt > installed GNC runs fine with charts visible. > > But locally built GNC (tip of the latest maint branch) has the same issue. > I tried switching the libs in build_dir to point to > /usr/lib/x86_64-linux-gnu/gnucash, but the local gnucash encountered an > undefined symbol gnc_run_report_with_error_handling and couldn't start. > > apt removed the system gnucash, purged ~/.cache. reran the local gnc, same > problem, blank charts. > only the table is visible. > > the build environment was prepared with apt-get build-dep gnucash as > instructed. > > >> >> Thank you John. I can confirm that 4.x works with Ubuntu 21.04. >> >> As for release 3.11, the problem exists with the unstable version of 3.11 >> (4064c58cd) only. The stable 3.11 (0fe8ba79e) release works just fine. >> >> | * | | 0fe9ba79e21d0545f4c1f9eb373a9450803a83c4 Release GnuCash 3.11 >> * | | | | | | 4064c58cd03b7f7fb613d593c93569048adb Release GnuCash >> 3.11 >> >> I guess issue lies in it's one of the 163 shared libs that GNC uses that >> came with Ubuntu 20.04. >> >> >>> Dong Lin, >>> >>> You've already demonstrated that the problem doesn't happen on 3.11 so >>> there's no point going backwards in 3.x. >>> According to https://repology.org/project/gnucash/versions Ubuntu 21.04 >>> provides GnuCash 4.5. I suggest that you clean up your system and >>> install >>> GnuCash 4.4 from apt. If it has trouble displaying charts then raise a >>> bug >>> on Ubuntu and let their packager figure out what's going on. >>> >>> Regards, >>> John Ralls >>> >>>> On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: >>>> >>>> >>>> Thanks for the instructions John. I tried it on a Ubuntu 20.04 system >>>> with >>>> no GNC installed. The problem still exists in 4.x. It seems the 3.x >>>> stable branch works. The issue happens in the unstable branch only. >>>> >>>> I also tried running 4.x on a Mac, I can see the plot. Not sure if the >>>> issue is Linux only or Ubuntu only. >>>> >>>> unstable 2455071 bad >>>> stable 3.6-d42695e75 good >>>> unstable 3.5-b7479e8fb bad >>>> >>>> I cannot build 3.4 or anything older. The fix for >>>> G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. >>>> Compile still fails after resolving all conflicts. >>>> >>>> So it seems a very old bug that hasn't been fixed in the unstable >>>> branch. >>>> I believe running 4.x or any 3.x unstable build on standard issue >>>> Ubuntu >>>> 20.04 should easily reproduce. >>>> >>>> >>>>> It turns out that bisecting between 63232f and 8024f4 flat won't work, >>>>> they're on different branches. 63232f is on the 3.x branch which is >>>>> why >>>>> it >>>>> works. 2c637a is from 2019 where the master branch splits off from the >>>>> maint branch (we had a pull request merge mishap at aa53c23 that >>>>> temporarily collapsed them together, but there hadn't been any >>>>> development >>>>> on master at that point anyway). 2c637a is actually the first commit >>>>> where >>>>> the two branches start to diverge. >>>>> >>>>> Since the failing 8024f4 is on master I looked at the changes leading >>>>> up >>>>> to that in a graphical history viewer. One particular change stands >>>>> out, >>>>> 2455071 where we start the conversion from jqplot to chartjs. That >>>>> would >>>>> be a good place to test. >>>>> >>>>> HOWEVER >>>>> The problem may well be that there are remnants of the Ubuntu-provided >>>>> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >>>>> rendering, so before you do any more bisecting I suggest that you >>>>> completely remove all GnuCash shared libraries, loadable modules, and >>>>> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. >>>>> The >>>>> s
Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open files with OneDrive
I don't have One Drive so I'm guessing, but macOS10.15 introduced some security restrictions on access to certain folders which macOS 11 tightened up even more. You might need to give GnuCash some extra privileges. Open System Preferences, go to the Security and Privacy pane, select the privacy tab, and scroll down the left list to Files and Folders. With that selected find Gnucash.app in the right list and see what folders are listed under it. If OneDrive appears there and isn't checked, click the padlock in the lower left corner, authenticate, and then check the box for the OneDrive folder. Start GnuCash and see if you can find your file. If that doesn't work or if there is no line for OneDrive, go to the Full Disk Access item, one up in the left list. Find Gnucash.app in the right list and check its box (you'll have to click the padlock and authenticate if you haven't already). Start GnuCash and try to open the file. Regards, John Ralls > On Jul 20, 2021, at 11:53 AM, Derek Atkins wrote: > > Sounds like a permission problem. > Not sure how to fix it, I'm afraid. > -d > > On Tue, July 20, 2021 2:33 pm, cbp...@gmail.com wrote: >> Hi Derek, Gyle - thanks for the responses. >> >> I'd like to add one other error message - perhaps it will be helpful. When >> I try to go the File -> Open route, I get a slightly different error >> message (though it still doesn't work). The error message I get here is >> below. >> >> --- >> Could not read the contents of >> Error opening directory '/Users//OneDrive/': >> Operation not permitted >> --- >> >> Not sure if that means anything to anyone - but I figured I'd add it >> anyway in case it helps! >> >> Cameron >> >> -Original Message- >> From: Derek Atkins >> Sent: Tuesday, July 20, 2021 11:14 AM >> To: Gyle McCollam >> Cc: Cameron Podd ; gnucash-user@gnucash.org >> Subject: Re: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >> files with OneDrive >> >> Gyle, >> >> Cameron is on a Mac, not a Windows box, so OneDrive may behave differently >> there. Right now it sounds like GnuCash cannot see the OneDrive >> directory. >> >> I am hoping JRalls can pipe up and provide some insights, as he is our >> resident Mac expert. >> >> -derek >> >> On Tue, July 20, 2021 2:07 pm, Gyle McCollam wrote: >>> I use one drive as well, but I have no problem with GNU Cash finding >>> the info. However, I have another directory between Documents and >>> GnuCashData.gnucash (although mine is named differently). >>> When you click on file/open you can navigate to the file on one drive >>> and it should work fine from that point. I had an old program called >>> Money Counts for Windows (MCW) and when I changed the name of that >>> subdirectory to GNUCash recently, I had a problem with GNC finding my >>> info, but using file/open and navigating to the new directory and then >>> ?.gnucash worked for me. Hopefully, this helps. >>> >>> Thank You, >>> Gyle McCollam >>> >>> Gyle McCollam >>> >>> 609.680.2326 Mobile >>> >>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email >>> >>> >>> From: gnucash-user >>> on behalf of Cameron Podd >>> Sent: Tuesday, July 20, 2021 11:33 AM >>> To: gnucash-user@gnucash.org >>> Subject: [GNC] Possible Bug with GNUCash - GNUCash cannot see/open >>> files with OneDrive >>> >>> I am wondering if anyone has encountered - or has a possible solution >>> to - this bug I have found. I usually store my GNUCash file in OneDrive. >>> However, with the new update of OneDrive, GNUCash cannot see the file. >>> See the error below. Has anyone also seen this error - or know how to >>> correct it? >>> >>> Can't parse the URL >>> /Users//OneDrive/Documents/GnuCashData.gnucash >>> >>> Thanks - Cameron >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-A
Re: [GNC] My screenshot FYI. - Re: Big problem GC 4.6 wiping history list? Mac OS Big Sur
Anita, Thanks for the followup, but please remember to copy the list on all replies. Regards, John Ralls > On Jul 20, 2021, at 8:54 AM, Anita Graves wrote: > > Dear John and others who helped me, I wish to inform you that I was able to > solve my problem by simply carefully following the file path and discovered > that I had re-named a folder and that caused my problem. It had nothing to > do with trying to update GC. > > Thanks so much for your help and your kind attention! > > Anita > >> On 2 Jul 2021, at 8:04 PM, John Ralls wrote: >> >> Yes, that's the dialog I expected. It's offering to remove the entry in the >> File menu, not to delete the actual file. After all, it can't find the >> actual file so how could it delete it? >> >> Regards, >> John Ralls >> >> >>> On Jul 2, 2021, at 9:30 AM, Anita Graves wrote: >>> >>> >>> >>>> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>>>> wrote: >>>>> >>>>> Please see the attached screenshot: >>>>> >>>>> I don’t know what to do but I refuse to delete the file I need to work >>>>> with, or any of the other files in the history list. This all happened >>>>> to me when I installed GC 4.6. Before I was using 4.1. Now, when I try >>>>> to import a log file it gives the same screen. Then GC crashes! >>>>> >>>>> I am afraid to wipe all my history and all my work! >>>>> >>>>> Thanks for your help and suggestions. >>>> >>>> Your screenshot didn't make it onto the list, but if GnuCash is asking if >>>> you want to delete a file from the history list that means that it can't >>>> find the file. You'll want to investigate why that is, but rest assured >>>> that GnuCash isn't offering to delete the file, just to remove it from the >>>> history list. >>>> >>>> For the crash, please open a bug and attach the crash report from Console. >>>> You can find instructions for finding the crash report at >>>> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >>>> leading up to the crash in the bug description. >>>> >>>> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
Dong Lin, You've already demonstrated that the problem doesn't happen on 3.11 so there's no point going backwards in 3.x. According to https://repology.org/project/gnucash/versions Ubuntu 21.04 provides GnuCash 4.5. I suggest that you clean up your system and install GnuCash 4.4 from apt. If it has trouble displaying charts then raise a bug on Ubuntu and let their packager figure out what's going on. Regards, John Ralls > On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: > > > Thanks for the instructions John. I tried it on a Ubuntu 20.04 system with > no GNC installed. The problem still exists in 4.x. It seems the 3.x > stable branch works. The issue happens in the unstable branch only. > > I also tried running 4.x on a Mac, I can see the plot. Not sure if the > issue is Linux only or Ubuntu only. > > unstable 2455071 bad > stable 3.6-d42695e75 good > unstable 3.5-b7479e8fb bad > > I cannot build 3.4 or anything older. The fix for > G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. > Compile still fails after resolving all conflicts. > > So it seems a very old bug that hasn't been fixed in the unstable branch. > I believe running 4.x or any 3.x unstable build on standard issue Ubuntu > 20.04 should easily reproduce. > > >> It turns out that bisecting between 63232f and 8024f4 flat won't work, >> they're on different branches. 63232f is on the 3.x branch which is why it >> works. 2c637a is from 2019 where the master branch splits off from the >> maint branch (we had a pull request merge mishap at aa53c23 that >> temporarily collapsed them together, but there hadn't been any development >> on master at that point anyway). 2c637a is actually the first commit where >> the two branches start to diverge. >> >> Since the failing 8024f4 is on master I looked at the changes leading up >> to that in a graphical history viewer. One particular change stands out, >> 2455071 where we start the conversion from jqplot to chartjs. That would >> be a good place to test. >> >> HOWEVER >> The problem may well be that there are remnants of the Ubuntu-provided >> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >> rendering, so before you do any more bisecting I suggest that you >> completely remove all GnuCash shared libraries, loadable modules, and >> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The >> shared libraries will be /usr/lib/libgnc* and you can get rid of the >> shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. >> Remove ~/.cache/guile/ccache as well if it exists. That may fix the >> problem with no more troubleshooting required. If it doesn't `sudo apt-get >> remove gnucash` to have a clean system before doing any test builds. Guile >> is exceptionally stupid about what it loads and trying to build GnuCash >> when there's a package-manager version installed seldom comes out well. >> >> If more bisecting is in order, try 2455071. If it works, try 598c37; >> that's the end of the chartjs upgrades. If that works then check 8024f4 >> again to make sure that that still fails, then `git bisect --first-parent >> start 8024f4 598c37` to find the problem commit (which may well be a >> merge). >> >> Regards, >> John Ralls >> >> >>> On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: >>> >>> >>> I see two 3.11 release commits in maint. >>> >>> 3.11-4064c58cd bad >>> 3.11-0fe9ba79e good >>> >>> bisecting in this range pointed to 2c637a971. >>> >>> bisecting in 63232f388..8024f44bc also singled out 2c637a971. >>> >>> But it cannot be as it's just a version update. Reverting it did not >>> produce a good run. >>> >>> >>>> >>>> That the problem seems to have arisen during the transition between 3.x >>>> and 4.0 does make it a bit more complicated. There are 391 commits >>>> between >>>> 63232f and 8024f4 including 57 merges from maint and 8 feature >>>> branches. >>>> That makes knowing that the problem exists in the latter commit and not >>>> in >>>> the former less helpful than it might be. >>>> >>>> You can test your hypothesis that a merge caused the regression by >>>> testing >>>> 3.11, the last release on the 3.x maint branch. If that fails you can >>>> bisect between it and 63232f. Use `git bisect`, it's the quickest and >>>> easiest way to find the commit that caused the problem. >>>
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
It turns out that bisecting between 63232f and 8024f4 flat won't work, they're on different branches. 63232f is on the 3.x branch which is why it works. 2c637a is from 2019 where the master branch splits off from the maint branch (we had a pull request merge mishap at aa53c23 that temporarily collapsed them together, but there hadn't been any development on master at that point anyway). 2c637a is actually the first commit where the two branches start to diverge. Since the failing 8024f4 is on master I looked at the changes leading up to that in a graphical history viewer. One particular change stands out, 2455071 where we start the conversion from jqplot to chartjs. That would be a good place to test. HOWEVER The problem may well be that there are remnants of the Ubuntu-provided GnuCash 3.8 that are interfering with the 4.x chartjs-based chart rendering, so before you do any more bisecting I suggest that you completely remove all GnuCash shared libraries, loadable modules, and Scheme caches from your system, then reinstall GnuCash 4.6 with apt. The shared libraries will be /usr/lib/libgnc* and you can get rid of the shared modules and system cached guile by `sudo rm -rf /usr/lib/gnucash/`. Remove ~/.cache/guile/ccache as well if it exists. That may fix the problem with no more troubleshooting required. If it doesn't `sudo apt-get remove gnucash` to have a clean system before doing any test builds. Guile is exceptionally stupid about what it loads and trying to build GnuCash when there's a package-manager version installed seldom comes out well. If more bisecting is in order, try 2455071. If it works, try 598c37; that's the end of the chartjs upgrades. If that works then check 8024f4 again to make sure that that still fails, then `git bisect --first-parent start 8024f4 598c37` to find the problem commit (which may well be a merge). Regards, John Ralls > On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: > > > I see two 3.11 release commits in maint. > > 3.11-4064c58cd bad > 3.11-0fe9ba79e good > > bisecting in this range pointed to 2c637a971. > > bisecting in 63232f388..8024f44bc also singled out 2c637a971. > > But it cannot be as it's just a version update. Reverting it did not > produce a good run. > > >> >> That the problem seems to have arisen during the transition between 3.x >> and 4.0 does make it a bit more complicated. There are 391 commits between >> 63232f and 8024f4 including 57 merges from maint and 8 feature branches. >> That makes knowing that the problem exists in the latter commit and not in >> the former less helpful than it might be. >> >> You can test your hypothesis that a merge caused the regression by testing >> 3.11, the last release on the 3.x maint branch. If that fails you can >> bisect between it and 63232f. Use `git bisect`, it's the quickest and >> easiest way to find the commit that caused the problem. >> >> If 3.11 is good then you can run bisect so that it always tests merge >> commits and ignores the commits being merged with `git bisect >> --first-commit start 8024f4 63232f`. >> >> Regards, >> John Ralls >> >> >> >>> On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user >>> wrote: >>> >>> >>> Did more searches. the issue exists in 4.6, running gnc on Ubuntu >>> 20.04.1 >>> LTS with standard gnome. >>> >>> I've gone through the following commits in maint: >>> >>> 4.6 2021 228954c40 bad >>> 0425-2020 8024f44bc bad >>> 0425-2020 63232f388 good >>> 3.10 2020 7d39ccc9d good >>> 3.6 2019 d42695e75 good >>> 0615-2019 410ae9575 good >>> 0601-2019 170651602 good >>> 0601-2019 3a91eedb4 good >>> 0531-2019 69ea174cd bad >>> 0415-2019 0251d044b bad >>> 3.5 2019 b7479e8fb bad >>> >>> I couldn't go any older because ancient code cannot be compiled by my >>> environment. >>> >>> The merges really obscured the search. the order of the merged commits >>> are >>> not chronological. timestamps are time of commit, not time of merge. >>> >>> It looks as if the bug was fixed at one point, but it was lost in a >>> merge. >>> >>> >>> >>>> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the >>>> gnc >>>> trees based off of master at various commits for the bisect. >>>> ; lsb_release -a >>>> No LSB modules are available. >>>> Distributor ID: Ubuntu >>>> Description:   Ubuntu 20.04.1 LTS >>>> Release:       20.04 >>>>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Currency quotes work differently from stock quotes because forex markets
operate differently from stock exchanges. A particular stock symbol on any one
price source is unique and quoted in a single currency so only the symbol is
needed to retrieve the quote. Forex markets quote exchange rates between pairs
of currencies, e.g. GBP to USD or JPY to EUR. Simply asking for the current
quote for EUR isn't meaningful.
In F::Q to retrieve currency quotes you must use `currency` for the source and
you need two symbols as shown in Geoff's examples. Enabling online quotes for a
currency in the security editor won't work because that will try to retrieve a
price for a stock with the currency symbol from the selected source and odds
are there is no such stock.
To easily test that F::Q is working for currencies find a two-currency
transaction and right-click on it, then select "edit exchange rate" in the
context menu. The transfer dialog will appear. Click the Fetch Rate button and
if everything is behaving itself the current rate will fill in the exchange
rate box.
Regards,
John Ralls
> On Jul 18, 2021, at 7:30 AM, david.rom...@davidjromano.com
> wrote:
>
> Thanks Geoff, yes I think I did though I will recheck this.
>
> I've also tried this with an alternative key in case the first was the
> problem.
>
> David
> Sent from my iPhone
>
>> On 18 Jul 2021, at 13:55, Geoff wrote:
>>
>> Hi David
>>
>> Did you remember to set your alphavantage key as an environment variable
>> when testing with Perl from the command line?
>>
>> Can you try this:
>>
>> C:\Program Files (x86)\gnucash\bin>set
>> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
>> __Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
>> gnc-fq-helper
>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") (last .
>> #e0.72002) (currency . "GBP")))
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
>> gnc-fq-helper
>> (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last .
>> #e4.8841) (currency . "RON")))
>>
>>
>> Also, it is normal to get the blank command window when doing Get Quotes on
>> Windows.
>>
>> Regards
>>
>> Geoff
>> =
>>
>>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>>> I'm having a problem with GNC-FQ not being able to retrieve currency data
>>> for the GBP / EUR currency pair.
>>> I had previously used FQ back when the data source was Yahoo, but when the
>>> Yahoo died I stopped using it.
>>> I now need to pick up GBP and EUR rates so I've installed the components
>>> required to get the Alphavantage feed to work - or so I hoped!
>>> Here's where I've got to so far:
>>> 1.I updated GNU Cash to current 4.6.
>>> 2.I installed Strawberry Perl version 5.32.1.1
>>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>>> 5.I ran perl gnc-fq-check and got the following result:
>>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>>> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia"
>>> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual"
>>> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies"
>>> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds"
>>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
>>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
>>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
>>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
>>> "tradeville" "troweprice" "troweprice_direct" "tsp
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
That the problem seems to have arisen during the transition between 3.x and 4.0 does make it a bit more complicated. There are 391 commits between 63232f and 8024f4 including 57 merges from maint and 8 feature branches. That makes knowing that the problem exists in the latter commit and not in the former less helpful than it might be. You can test your hypothesis that a merge caused the regression by testing 3.11, the last release on the 3.x maint branch. If that fails you can bisect between it and 63232f. Use `git bisect`, it's the quickest and easiest way to find the commit that caused the problem. If 3.11 is good then you can run bisect so that it always tests merge commits and ignores the commits being merged with `git bisect --first-commit start 8024f4 63232f`. Regards, John Ralls > On Jul 17, 2021, at 7:46 AM, Dong Lin via gnucash-user > wrote: > > > Did more searches. the issue exists in 4.6, running gnc on Ubuntu 20.04.1 > LTS with standard gnome. > > I've gone through the following commits in maint: > > 4.6 2021 228954c40 bad > 0425-2020 8024f44bc bad > 0425-2020 63232f388 good > 3.10 2020 7d39ccc9d good > 3.6 2019 d42695e75 good > 0615-2019 410ae9575 good > 0601-2019 170651602 good > 0601-2019 3a91eedb4 good > 0531-2019 69ea174cd bad > 0415-2019 0251d044b bad > 3.5 2019 b7479e8fb bad > > I couldn't go any older because ancient code cannot be compiled by my > environment. > > The merges really obscured the search. the order of the merged commits are > not chronological. timestamps are time of commit, not time of merge. > > It looks as if the bug was fixed at one point, but it was lost in a merge. > > > >> Running gnc in Ubuntu 20.04 LTS. Default gnc is 3.8. I built the gnc >> trees based off of master at various commits for the bisect. >> ; lsb_release -a >> No LSB modules are available. >> Distributor ID: Ubuntu >> Description:   Ubuntu 20.04.1 LTS >> Release:       20.04 >> Codename:      focal >> >> >> ; grep WEBKIT ./common/config.h >> /* Definitions for what WEBKIT version we're compiling against: */ >> #define WEBKIT2_4 1 >> /* #undef WEBKIT2_3 */ >> /* #undef WEBKIT1 */ >> >> >> I compared the preprocessor output for html/gnc-html-webkit2.c, the >> affected code block between the working and non-working versions are >> identical. But some line numbers for other .h files are different. So I >> have assumed that it's not 8024f44bc, but other 100+ commits that came >> with the tree merge. >> >> the VNC server runs on Ubuntu (the same machine that the binary is built >> on). The VNC viewer is MacOS (TigherVNC). Tried another viewer running on >> Linux, same outcome. >> >> There are many commits affecting barcharts in that range. The most >> relevant one seems to be this: >> 6b74f80bc Wed Dec 18 21:55:51 2019 +0800 >> [html-pie/scatter/bar/linechart] defer to html-chart renderer >> >> But reverting it resulted in too many conflicts that I dont know how to >> resolve. >> Will try again later using the maint branch. >> >> Thanks! >> >>> >>> >>>> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user >>>> wrote: >>>> >>>> >>>> I am trying to upgrade from 3.8 to 4.6. But found that piecharts and >>>> linecharts in reports have turned blank. The associated tables are >>>> present >>>> though. >>>> >>>> Attempted to perform a binary search in master, and found the latest >>>> working commit is 63232f388. >>>> >>>> >>>> 8024f44bc Sat Apr 25 15:40:07 2020 >>>> -0700                Remove leftover >>>> webkit2 conditional. >>>> 63232f388 Sat Apr 25 14:40:57 2020 >>>> -0700                Merge Jean >>>> Laroche's 'Fix-3-SX-Problems' into maint >>>> >>>> >>>> Unfortunately 8024f44bc came from the maint branch and was merged with >>>> over a hundred other commits. I am not sure how to narrow it down. >>>> Reverting one of them resulted in lots of conflicts that I dont know >>>> how >>>> to resolve. >>>> >>>> I figured the problem has to be related to my environment as no one >>>> else >>>> has brought up the issue. My virtual desktop is >>>> driven by a VNC server (Ubuntu 20.04 LTS). It's not directly >>>> associated >>>> with a hardware graphics card with a ph
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
> On Jul 11, 2021, at 10:36 PM, Dong Lin via gnucash-user > wrote: > > > I am trying to upgrade from 3.8 to 4.6. But found that piecharts and > linecharts in reports have turned blank. The associated tables are present > though. > > Attempted to perform a binary search in master, and found the latest > working commit is 63232f388. > > > 8024f44bc Sat Apr 25 15:40:07 2020 -0700 Remove leftover > webkit2 conditional. > 63232f388 Sat Apr 25 14:40:57 2020 -0700 Merge Jean > Laroche's 'Fix-3-SX-Problems' into maint > > > Unfortunately 8024f44bc came from the maint branch and was merged with > over a hundred other commits. I am not sure how to narrow it down. > Reverting one of them resulted in lots of conflicts that I dont know how > to resolve. > > I figured the problem has to be related to my environment as no one else > has brought up the issue. My virtual desktop is > driven by a VNC server (Ubuntu 20.04 LTS). It's not directly associated > with a hardware graphics card with a physical cable to the monitor. We release off of the maint branch so you should do your bisect there. This isn't likely to have anything to do with your VNC server, nor with whatever you're connecting to it. In what environment are you actually running GnuCash and what version of WebKit is it using? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] OFX Imports to new account reversed
> On Jul 5, 2021, at 8:56 PM, David Carlson wrote: > > I have been using GnuCash for years with OFX imports correctly populating > bank and credit card accounts with deposits and withdrawals. > > Today, using release 3.8 I set up a new credit card account, went online, > downloaded an OFX transaction file and proceeded to import it into > GnuCash. > > Surprise, purchases were entered as payments. I checked the raw OFX file > and it appears to be correct. The account type is Credit Card under a > Liability top account. > > What else can cause this? Were there any payments and were they recorded as purchases? In your OFX file what is the block after the tag? A normal CC one should look like USD In a purchase transaction what is the sign on the amount? It shouldn't matter, but what have you selected in Preferences>Accounts for Reverse Balance 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote Not working on MacBook Air M1 chip
Super. I guess you needed to install JSON::Parse and maybe other dependencies in the Rosetta instance. No doubt it's lost now but I wonder if during the Rosetta install cpan saw that it was already installed and couldn't tell that it was for the wrong architecture. Regards, John Ralls > On Jul 3, 2021, at 11:35 PM, Deepti Randad wrote: > > Hey John - it worked after some trouble shooting - now Finance:Quote is > “recognised” by the GnuCash GUI - Again - Thanks for your help !! > > Regards, > Kamlesh > >> On 04-Jul-2021, at 11:52 AM, Deepti Randad wrote: >> >> I was able to create a “terminal instance” to run under Rosetta2 and also >> then was able to install Finance::Quote using gnc-fq-update. >> >> However, when I tried to run the command "echo '(yahoo_json "CSCO")' | >> ./gnc-fq-helper”, I get a bunch of errors - as follows: (I have not had >> chance to troubleshoot these yet, maybe next weekend) >> >> Thanks John for your guidance so far. >> >> >> Can't load >> '/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle' >> for module JSON::Parse: >> dlopen(/Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle, >> 1): no suitable image found. Did find: >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture >> >> /Library/Perl/5.30/darwin-thread-multi-2level/auto/JSON/Parse/Parse.bundle: >> mach-o, but wrong architecture at /System/Library/Perl/5.30/XSLoader.pm line >> 96. >> at /Library/Perl/5.30/darwin-thread-multi-2level/JSON/Parse.pm line 23. >> Compilation failed in require at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> BEGIN failed--compilation aborted at >> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27. >> Compilation failed in require at (eval 301) line 1. >> BEGIN failed--compilation aborted at (eval 301) line 1. >> at ./gnc-fq-helper line 325. >> Can't locate object method "methods" via package >> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line >> 120. >> >> >>> On 01-Jul-2021, at 10:09 PM, John Ralls wrote: >>> >>> OK. I suspect that it's because GnuCash is running under Rosetta2 and that >>> forces the Intel perl. Try following the instructions in >>> https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ >>> to create a Terminal instance that runs under Rosetta2 and use that to run >>> gnc-fq-update. >>> >>> Regards, >>> John Ralls >>> >>> >>> >>>> On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: >>>> >>>> Hallo John - Many Thanks for your response. >>>> >>>> I ran the GUI from the terminal command prompt as you have suggested - >>>> however, the problem remains the same - the application does not “get” / >>>> “find” Finance::Quote. >>>> >>>> Regards, >>>> Kamlesh >>>> >>>> Regards, >>>> Kamlesh >>>> >>>>> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >>>>> >>>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash >>>> >>> >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tools, Price Database
> On Jul 3, 2021, at 2:24 PM, Tommy Trussell wrote: > > On Sat, Jul 3, 2021 at 3:44 PM Gyle McCollam wrote: > >> I upgraded from version 3.6 to version 4.6 and when I add a new price for >> a stock it only takes 2 digits, previously I had 5 digits. How do I change >> it to 5 digits. I can’t find the screen to have it keep 5 digits. I >> enter the price as 5 digits, but when I save it it coverts it to 2 digits. >> Any help would be GREATLY appreciated. >> > > I saw this issue come across this list just the other day. Seems to be a > new bug: > https://bugs.gnucash.org/show_bug.cgi?id=798219 > > If the bug is causing a hardship, you might try downgrading to GnuCash 4.5, > or consider generating a patched version to use. > There's a workaround: After you type the price hit instead of clicking OK. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur
Please remember to copy the list on all replies. Windows and Linux users wish they had Console. It's very much a Mac thing; it's in Applications:Utilities. There are more detailed instructions in the wiki link I gave you. Regards, John Ralls > On Jul 2, 2021, at 9:35 AM, Anita Graves wrote: > > John, > > What is ‘Console’? Is that a PC thing? I don’t think we have that on Mac. > > Anita > >> On 1 Jul 2021, at 7:36 PM, John Ralls wrote: >> >> >> >>> On Jun 28, 2021, at 11:52 PM, Anita Graves >>> wrote: >>> >>> Please see the attached screenshot: >>> >>> I don’t know what to do but I refuse to delete the file I need to work >>> with, or any of the other files in the history list. This all happened to >>> me when I installed GC 4.6. Before I was using 4.1. Now, when I try to >>> import a log file it gives the same screen. Then GC crashes! >>> >>> I am afraid to wipe all my history and all my work! >>> >>> Thanks for your help and suggestions. >> >> Your screenshot didn't make it onto the list, but if GnuCash is asking if >> you want to delete a file from the history list that means that it can't >> find the file. You'll want to investigate why that is, but rest assured that >> GnuCash isn't offering to delete the file, just to remove it from the >> history list. >> >> For the crash, please open a bug and attach the crash report from Console. >> You can find instructions for finding the crash report at >> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did >> leading up to the crash in the bug description. >> >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GNUCash 4.6 for Ubuntu 20.04 LTS
> On Jul 1, 2021, at 6:05 AM, David G. Pickett via gnucash-user > wrote: > > Bug: Entering price on price database - add, prices auto round to to places ! > Securities - edit says it is trades in 1/1000. Cannot find a setting to > control this. https://bugs.gnucash.org/show_bug.cgi?id=798219 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote Not working on MacBook Air M1 chip
OK. I suspect that it's because GnuCash is running under Rosetta2 and that forces the Intel perl. Try following the instructions in https://osxdaily.com/2020/11/18/how-run-homebrew-x86-terminal-apple-silicon-mac/ to create a Terminal instance that runs under Rosetta2 and use that to run gnc-fq-update. Regards, John Ralls > On Jun 30, 2021, at 5:31 AM, Deepti Randad wrote: > > Hallo John - Many Thanks for your response. > > I ran the GUI from the terminal command prompt as you have suggested - > however, the problem remains the same - the application does not “get” / > “find” Finance::Quote. > > Regards, > Kamlesh > > Regards, > Kamlesh > >> On 29-Jun-2021, at 8:43 AM, John Ralls wrote: >> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur
> On Jun 28, 2021, at 11:52 PM, Anita Graves wrote: > > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I need to work with, > or any of the other files in the history list. This all happened to me when > I installed GC 4.6. Before I was using 4.1. Now, when I try to import a log > file it gives the same screen. Then GC crashes! > > I am afraid to wipe all my history and all my work! > > Thanks for your help and suggestions. Your screenshot didn't make it onto the list, but if GnuCash is asking if you want to delete a file from the history list that means that it can't find the file. You'll want to investigate why that is, but rest assured that GnuCash isn't offering to delete the file, just to remove it from the history list. For the crash, please open a bug and attach the crash report from Console. You can find instructions for finding the crash report at https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did leading up to the crash in the bug description. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Preferences reset problem?
> On Jun 30, 2021, at 2:52 AM, Geert Janssens > wrote: > > Op dinsdag 29 juni 2021 22:22:36 CEST schreef incoming-gnuc...@sabot.com: >> After gnucash 4.5 was announced, I tested upgrading to it on a >> standalone test machine (running flatpak on ubuntu 20.04), and >> I encountered the issue later described here: >> >> https://bugs.gnucash.org/show_bug.cgi?id=798194 >> >> where all my gnucash settings were lost. On that same test machine, I >> tried downgrading to 4.4, but my settings were still gone. This >> seemed kind of scary, so I put off upgrading my real machine pending a >> fix. >> >> I see that the bug report linked to above includes some manual >> migration steps to export/re-import settings as a workaround, so I >> plan to just go ahead and try that (and I will go direct from 4.4 to >> 4.6, skipping 4.5). But I thought I'd check in to make sure that >> there was no other pending/better way or automatic approach to this, >> or is the manual workaround the way to go? >> > So far there's no better workaround. You can either manually set your > preferences again or use the command provided in the bug report. > > The short version of the issue is that a flatpak install of gnucash is as if > you install gnucash on a different machine, completely isolated from your > normal environment. There used to be a convenience to share preferences > between your normal environment and that "virtual" flatpak machine. That > convenience was dropped recently by the flatpak developers (well, the gnome > runtime developers really). Instead they provide a means to automatically > import settings from your main environment to the flatpak "virtual" machine, > but for historical reasons this can't work with gnucash. So as for the > convenience of having your preferences magically available in the flatpak > environment we're stuck between a rock and a hard place unfortunately. > >> If this issue affects all flatpak users, perhaps the release notes >> should reference the preferences issue and describe or link to the >> appropriate workaround? > > That's a reasonable idea. I hope someone will do so. Geert, Can you elaborate on the historical reasons on https://github.com/flathub/org.gnucash.GnuCash/pull/43? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance Quote Not working on MacBook Air M1 chip
> On Jun 27, 2021, at 4:05 AM, Deepti Randad via gnucash-user
> wrote:
>
> Hallo Folks -
>
> I recently installed GnuCash on MacBook Air with the Apple M1 chip - the
> GnuCash GUI itself seems to be working great. Then I tried installing
> finance::quote to get stock quotes automatically, however, this has not been
> working even after a lot of trouble shooting I did. Please find below the
> steps I have taken. Any help / direction will be appreciated. Thanks.
>
> Regards,
> Kamlesh
>
> Finance Quote on MacOS with MacBook Air M1 chip
>
> In the GnuCash GUI, I get the following error message in the “Security
> Editor” screen:
>> Warning: Finance::Quote not installed properly <
> and the rest of the fields below this are disabled.
> I followed the installation instructions on
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS
>
> <https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS>
>
> The about page of the GUI shows:
> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: -
>
> I did the following for installation:
>
> First, run the gnc-fq-update - this I had to run a couple of times, but it
> succeeded.
>
> Now if I run it, I get the following:
>
> Date::Manip is up to date (6.85).
> Finance::Quote is up to date (1.49)
>
> Perldoc gives the following output:
>
> perldoc -lm Finance::Quote
> /Library/Perl/5.30/Finance/Quote.pm
>
> Then, I run the following command, gnc-fq-helper
>
> echo '(yahoo_json "CSCO")' | ./gnc-fq-helper
>
> This returns the data fetched:
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-06-19 12:00:00") (last .
> #e52.07) (currency . "USD")))
>
> Another command I tried:
>
> ./gnc-fq-dump currency USD EUR
> 1 USD = 0.8428 EUR
>
> Therefore I am guessing Finance::Quote is working from command line.
>
> ./gnc-fq-check
>
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" "bsero"
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
> "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
> "platinum" "romania" "seb_funds" "sixfunds" "sixshares"
> "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
> "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
> "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json"
> "yahoo_yql" "za" "za_unittrusts"
Try running
/Applications/Gnucash.app/Contents/MacOS/Gnucash
from Terminal. Does that get it working?
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 4.6 Flathub Build
We've resolved the issue with Flathub and GnuCash 4.6 is now published there. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash 4.6 Released
Thanks. The correct hashes are: 251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 gnucash-4.6.tar.bz2 ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d gnucash-4.6.tar.gz de0447be56f3c56194132a89766221dfac72742c04aa87a84716cdd1ff93cfa7 gnucash-4.6.setup.exe 1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 Gnucash-Intel-4.6-1.dmg 5c4f8957d4e4a27bd7be3bc42f6a0823c1bfa4da1efff3fc17d57db43899c58c gnucash-docs-4.6.tar.gz Regards, John Ralls > On Jun 27, 2021, at 4:21 PM, Glenn Fowler wrote: > > Hi, > > FYI the hashes for the last three are the same: > >251b01dfb9f9c679db26926f934ca4d13c7092a485be04f60e2031d85a445733 > gnucash-4.6.tar.bz2 >ad3a6ec1f5fdf15fd167808cf351bc1aa7c012ea03a16c73a3d1c29bbd59a03d > gnucash-4.6.tar.gz >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-4.6.setup.exe >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > Gnucash-Intel-4.6-1.dmg >1d641691a5c6c4e6cfb32438175c242bdcfb2f1c497db35fc66b4fecd9f084b2 > gnucash-docs-4.6.tar.gz > > On Sun, Jun 27, 2021 at 5:51 PM John Ralls wrote: > >> The GnuCash development team announces GnuCash 4.6, the sixth release in >> the stable 4.x series >> Between 4.5 and 4.6, the following bugfixes were accomplished: >> >>Bug 648335 - Display Created Transactions setting >> >>Add a preference for the 'Review Created Transactions' setting in the >> 'Since Last Run' dialog so that the default can be specified. >>Bug 743753 - Nearest in time security price selection is incorrect in >> reports >> >>Add new price source - 'nearest before report date' will ignore prices >> *after* report date. >>Bug 743999 - Deleting a digit from an existing number greater than >> four digits in length generates an error message. >> >>Because the grouping is off. Checking grouping on input is pointless >> so just ignore the grouping separator when parsing number input. >>Bug 753283 - Current Selection Highlight Lost After Transaction Edit >> in Scheduled Transaction Window >>Bug 787813 - Price change from editing a transaction not reflected in >> pricedb. >>Bug 794877 - Intro text of "Online Banking Setup" is outdated >>Bug 795804 - Extremely slow save >> >>Only update the status bar when the percentage changes by at least 1% >> because running the mainloop is expensive on macOS and Microsoft Windows. >> This speeds up all operations that run the progress bar with overly-fine >> resolution. >>Bug 796761 - Newline (char(10)) is inserted into the end of the string >> if copy & paste text from excel into the description field of transaction >>Bug 797787 - Feature request: preference setting to open new tabs >> adjacent to currently active tab >> >>tests preference; if enabled then new tab inserted after current. if >> disabled then new tab is at the end. >>Bug 797928 - Since last run asks for security price when no shares >> traded >>Bug 798093 - Changing the symbol/abbreviation of a security after the >> trading account was created breaks GnuCash.(Reopened) >>Bug 798133 - Gnucash crash when any custom action is entered >>Bug 798144 - Reconciliation uses different number than entered >> >>If a number was pasted into the balance end value with a currency >> symbol the number would silently fail on evaluate and cause the wrong value >> to be used. With previous changes to the GNCAmountEdit widget a warning >> symbol will indicate a validation error and prevents going forward. >>Bug 798148 - "Accounts" page Present (USD) column uses future prices >>Bug 798151 - Value entry box not tied to associated transaction in >> Since Last Run assistant >>Bug 798156 - glib 2.68.0 breaks gnucash >>Bug 798159 - Keyboard shortcut bug in 'manage document link' >>Bug 798162 - Type Ahead Initialization Problem >>Bug 798170 - Unbound variable: gnc-budget-lookup when running saved >> report Budget Report via gnucash-cli >>Bug 798177 - Price of new stock transactions not saved in price >> database >>Bug 798186 - Incorrect result editting account in register when >> overtyping a part selection. >>Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button >> crashes on Windows >>Bug 798196 - not building with Boost 1.76 >>Bug 798199 - Pasting invalid value in date column crashes GnuCash >>Bug 798202 - Register input ignores theme on KDE rendering black text >> on black backgroun
[GNC] GnuCash 4.6 Released
The GnuCash development team announces GnuCash 4.6, the sixth release in the stable 4.x series Between 4.5 and 4.6, the following bugfixes were accomplished: Bug 648335 - Display Created Transactions setting Add a preference for the 'Review Created Transactions' setting in the 'Since Last Run' dialog so that the default can be specified. Bug 743753 - Nearest in time security price selection is incorrect in reports Add new price source - 'nearest before report date' will ignore prices *after* report date. Bug 743999 - Deleting a digit from an existing number greater than four digits in length generates an error message. Because the grouping is off. Checking grouping on input is pointless so just ignore the grouping separator when parsing number input. Bug 753283 - Current Selection Highlight Lost After Transaction Edit in Scheduled Transaction Window Bug 787813 - Price change from editing a transaction not reflected in pricedb. Bug 794877 - Intro text of "Online Banking Setup" is outdated Bug 795804 - Extremely slow save Only update the status bar when the percentage changes by at least 1% because running the mainloop is expensive on macOS and Microsoft Windows. This speeds up all operations that run the progress bar with overly-fine resolution. Bug 796761 - Newline (char(10)) is inserted into the end of the string if copy & paste text from excel into the description field of transaction Bug 797787 - Feature request: preference setting to open new tabs adjacent to currently active tab tests preference; if enabled then new tab inserted after current. if disabled then new tab is at the end. Bug 797928 - Since last run asks for security price when no shares traded Bug 798093 - Changing the symbol/abbreviation of a security after the trading account was created breaks GnuCash.(Reopened) Bug 798133 - Gnucash crash when any custom action is entered Bug 798144 - Reconciliation uses different number than entered If a number was pasted into the balance end value with a currency symbol the number would silently fail on evaluate and cause the wrong value to be used. With previous changes to the GNCAmountEdit widget a warning symbol will indicate a validation error and prevents going forward. Bug 798148 - "Accounts" page Present (USD) column uses future prices Bug 798151 - Value entry box not tied to associated transaction in Since Last Run assistant Bug 798156 - glib 2.68.0 breaks gnucash Bug 798159 - Keyboard shortcut bug in 'manage document link' Bug 798162 - Type Ahead Initialization Problem Bug 798170 - Unbound variable: gnc-budget-lookup when running saved report Budget Report via gnucash-cli Bug 798177 - Price of new stock transactions not saved in price database Bug 798186 - Incorrect result editting account in register when overtyping a part selection. Bug 798188 - The Invoice Editor -> Printable Invoice toolbar button crashes on Windows Bug 798196 - not building with Boost 1.76 Bug 798199 - Pasting invalid value in date column crashes GnuCash Bug 798202 - Register input ignores theme on KDE rendering black text on black background Bug 798203 - g_assert fault while reversing transaction Bug 798204 - Creation of Imbalance Accounts Bug 798212 - right-click the down-arrow in the date register changes focus to first split The following fixes and improvements were not associated with bug reports: Improve transaction sorting on effective num field so that alpha charachters and numbers larger than 1 billion will be ordered. Ordering is now numeric for leading numbers (so that 9 sorts before 10) and lexical beginning with the first non-numeric character. Note that if one of the values begins with an alpha character ordering will be entirely lexical. Lexical sorting is localized; as in the rest of GnuCash only standard ASCII numbers (codepoints U+0030 - U+0039) are treated as numbers. Add import preferences for the difference in time considered when matching an existing transaction to an imported one. A difference less than the matching-date-threshold raises the score of the match; a difference greater than match-date-not-threshold lowers the score. Add experimental report "IFRS weighted-average cost basis report". This is a work-in-progress to help calculate the cost basis of securities priced in a foreign currency. [income-gst-statement] amend headers post Brexit. UK left EU, therefore VAT headers have now changed. Plug a bunch of memory leaks. Change how the print_info is obtained for the register: Currently the register sets up some 'print_info' values using the default account but if the register is a stock register they should be obtained from a parent account with a currency. Change monetary value for gnc_default_share_print_info: Share values are not currencies so set the monetary value to 0 for the
Re: [GNC] Transaction report export file type
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote: > > Is there a way to export a transaction report as a .csv or .txt file? I > looked at all options and didn't see any place to select the export format. > When I did export the file it defaulted to .html; that would take a lot of > cleaning and it would be nice to export to .csv or .txt. > > Any thoughts? It usually works to copy-and-paste the report into a spreadsheet. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transactions imported from the file assigned to wrong account
Yes, that does sound like a bug. Please file a bug report at https://bugs.gnucash.org. You can easily cite this thread with https://code.gnucash.org/pipermail/gnucash-user/2021-June/096929.html Regards, John Ralls > On Jun 22, 2021, at 8:51 AM, Aleksandar Kocic wrote: > > While removing the account works, it seems like a bug. > > When I remove an account from Tools -> Import Map editor -> Online tab, I get > asked the next time which account I want to use when importing the file. > However, the Import Map Editor doesn't know how to process the file and > extract the account id (the "Match String"). Hence, the "Match String" is > left empty, and the next time I need to import a file, from the same bank but > a different account, the Import Map Editor picks up the existing account, no > question asked. > > As I pointed out before, it is a QFX file, and the line with the account id > looks like this: > USD1234567890CREDITLINE > > Regards, > Aleksandar > > > > On Mon, Jun 21, 2021 at 8:10 PM Aleksandar Kocic wrote: > Thanks John and David, > > The Import Map Editor helped. I removed the account in question, which btw > didn't have assigned the id, and it worked. I was asked to assign the account > when trying to import the file. > > On Mon, Jun 21, 2021 at 8:08 PM John Ralls wrote: > David Carlson pointed you halfway: Open Tools>Import Map Editor. > > The other half is to select the radio button "online" on the top of the > dialog. That should display the online-id to GnuCash account associations and > enable you to delete any that are incorrect. If there's only one then perhaps > GnuCash isn't picking up the right number; compare the online id with your > import file to see wha it's using. > > Regards, > John Ralls > > > > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic wrote: > > > > It is QFX. > > > > I understand the process; however, it doesn't work. All the files are > > assigned to the same account with no questions asked. > > > > Is there a way to remove this association and start fresh? > > > > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, > > wrote: > > > >> Aleksandar: > >> > >> Which file format are you importing? The UI and procedure are slightly > >> different for each one. I am most familiar with OFX file import, and > >> secondarily with CSV file import. > >> > >> At the beginning of the import process, there is a step when GnuCash has > >> you designate which GnuCash account should receive the transactions you > >> are importing. For OFX format files, GnuCash can then remember a > >> correspondence between the account number in the OFX file and the > >> GnuCash account which receives the transaction, and it doesn't need to > >> ask you the next time that you import. > >> > >> Have you read through the GnuCash Guide documentation about file import? > >> < > >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx > >>> > >> > >> Best regards, > >> > >> —Jim DeLaHunt > >> > >> On 2021-06-21 13:17, Aleksandar Kocic wrote: > >>> I download the file from the bank's site and manually import it. > >>> > >>> I can see the account number in the file. However, for whatever reason, > >> the > >>> application chooses another account and it seems that cannot be changed. > >>> > >>> > >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, > >> wrote: > >>> > >>>> > >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic > >>>> wrote: > >>>>> Hi there, > >>>>> > >>>>> I am trying to import transactions downloaded from the bank. However, > >>>> since > >>>>> I have multiple accounts with the same institution, the transactions > >> are > >>>>> assigned to an already existing account. > >>>>> > >>>>> How do I select the account I want to use for importing transactions? > >>>> How are you doing the import and doesn't the bank include the bank > >> account > >>>> number? > >>>> > >>>> Regards, > >>>> John Ralls > >>>> > >>>> > >>> ___ > >>> gnucash-user mailing list >
