Re: [GNC] Danish templates do not correctly mark accounts as placeholders
Hello Philip, Am 13.01.21 um 07:49 schrieb Philip Munksgaard: > Hello Frank (and Adrien), > > Thank you for the pointers. Yes, I do believe I could create a PR for this. > Is Github the right place? I don't seem to be able to create issues on > Github, which is what threw me off in the first place and lead me to this > mailing list. > > Best regards, > Philip Github issues is disabled, becausse we use https://bugzilla.gnucash.org. Regards Frank ___ 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] Styles of different items in GNUcash reports
I am trying to fix an issue with the formatting of different items in a simple journal or general ledger. What I am trying to achieve is to format the primary sorting key in BOLD, but it appears that this item does not have s style of its own. In my case the primary sorting key are the accounts The primary sorting key in the generated report seems to be using the background color as defined for the subheader (in e.g. the technicolor style). But it does not appear to have a text style of its own, it appears to use the test style as defined for the normal text field Example of report 1000 Bank account One <-- I want this bold 01.01.2020 Transfer 2000 EUR 02.01.2020 Transfer 1000 EUR Total 3000 EUR 1100 Bank account Two <-- I want this bold 03.01.2020 Transfer 6000 EUR 05.01.2020 Transfer 4000 EUR Total 1 EUR Does anyone have an idea of a workaround or any ongoing improvement to allow this in GNUcash. Right now my only option is to export the HTML, import in Excel and do this manually. Feels like a waste of time as the report function in GNUcash is otherwise very nice and easy. Anyone who can point to a GNUcash developer forum, for these types of issues. Thank you for all advice Ray ___ 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] Styles of different items in GNUcash reports
Check the style sheets on the edit menu. On Wed, 13 Jan 2021, 5:41 pm mummins heitzel, wrote: >I am trying to fix an issue with the formatting of different items in a >simple journal or general ledger. > >What I am trying to achieve is to format the primary sorting key in >BOLD, but it appears that this item does not have s style of its own. > >In my case the primary sorting key are the accounts The primary sorting >key in the generated report seems to be using the background color as >defined for the subheader (in e.g. the technicolor style). > >But it does not appear to have a text style of its own, it appears to >use the test style as defined for the normal text field Example of >report > > >1000 Bank account One <-- I want this bold > >01.01.2020 Transfer 2000 EUR > >02.01.2020 Transfer 1000 EUR > >Total 3000 EUR > >1100 Bank account Two <-- I want this bold > >03.01.2020 Transfer 6000 EUR > >05.01.2020 Transfer 4000 EUR > >Total 1 EUR > > >Does anyone have an idea of a workaround or any ongoing improvement to >allow this in GNUcash. > >Right now my only option is to export the HTML, import in Excel and do >this manually. > >Feels like a waste of time as the report function in GNUcash is >otherwise very nice and easy. > >Anyone who can point to a GNUcash developer forum, for these types of >issues. > > >Thank you for all advice > > >Ray > ___ > 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] Styles of different items in GNUcash reports
This is a repeat of the question originally posted on 11th January from Raimund Strehl, presumably the same person now using a different e-mail address and name. Adrien Monteleone responded to the original. If you're unhappy with the original response it would have be polite to continue the original thread rather than start a new one from different credentials. Alan A Holmes -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+gnucash=alanaholmes.me...@gnucash.org] On Behalf Of mummins heitzel Sent: 13 January 2021 09:41 To: gnucash-user@gnucash.org Subject: [GNC] Styles of different items in GNUcash reports I am trying to fix an issue with the formatting of different items in a simple journal or general ledger. What I am trying to achieve is to format the primary sorting key in BOLD, but it appears that this item does not have s style of its own. In my case the primary sorting key are the accounts The primary sorting key in the generated report seems to be using the background color as defined for the subheader (in e.g. the technicolor style). But it does not appear to have a text style of its own, it appears to use the test style as defined for the normal text field Example of report 1000 Bank account One <-- I want this bold 01.01.2020 Transfer 2000 EUR 02.01.2020 Transfer 1000 EUR Total 3000 EUR 1100 Bank account Two <-- I want this bold 03.01.2020 Transfer 6000 EUR 05.01.2020 Transfer 4000 EUR Total 1 EUR Does anyone have an idea of a workaround or any ongoing improvement to allow this in GNUcash. Right now my only option is to export the HTML, import in Excel and do this manually. Feels like a waste of time as the report function in GNUcash is otherwise very nice and easy. Anyone who can point to a GNUcash developer forum, for these types of issues. Thank you for all advice Ray ___ 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] Commission sales
Since early in the pandemic we’ve been selling some of our neighbour’s stuff, charging a few percent commission, mostly to cover credit card fees. Our income here is really just the commission since the end customer knows it isn’t ours and we aren’t providing any value add othe than facilitating the order and delivery process. The only way I have figured out to account using the business features is to enter an invoice to the end customer and a bill for the full amount from the neighbour. Then I have to hack around in the income and expense accounts to make the difference between the two show up as commission. This is because I can’t put an income account in a bill. Is there a more elegant way of handling this? Sent from my iPhone ___ 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] Best way to upgrade from an old version (2.6.14) to current
I'm a bit confused as to the best update method. These seem to be differing methods, incrementally updating GC (3 steps), or jump to 4.4 (1 step) and let it do the data update in one step. Is the JR one step method reliable for a big file with many accounts? On 1/8/21 10:15 AM, John Ralls wrote: The old GnuCash file still has a bunch of imports and starting with it will save you some time importing and perhaps training the import-matcher. Make a separate backup of it for an extra layer of safety. Since you didn't actually use GnuCash much it's probably safe to just install 4.4. The installer will take care of uninstalling your old 2.6.14. There's a bunch of upgrading that GnuCash will do on its first run and a bunch more on the first import, so be patient! If your existing file is large and your old laptop is slow or doesn't have a lot of memory it may take more than an hour--someone reported several hours for a very large file--to run all of the startup scrubs and then more hours to update the import maps, so plug in the laptop, turn off energy savers (it's OK to blank the screen but you don't want it to go to sleep), and plan to leave it running for a while. As you bring the GnuCash file up to date do small imports--a month or two worth of transactions--to begin. If most of the imported transactions are matched correctly then you can go to larger import batches, but if they're not then you'll want to do a half dozen or so small batches to train the matcher. Note that there's a recently added feature that allows you to select several transactions in the matcher window and assign all of them to the same transfer account; just right-click after selecting and pick Assign Account from the context menu (it's the only option). Remember to save frequently so that you can easily go back if something goes wrong. Regards, John Ralls On 1/8/21 10:28 AM, D. via gnucash-user wrote: Welcome back! Let me start with the last point first: in my experience, Gnucash's developer team is deeply committed to compatibility, and works to ensure that upgrades preserve ALL previous data. Furthermore, the default data storage is XML, which is text that is human readable, and fully transparent to the end user (I'll add the caveat here that for efficiency's sake, the file is usually stored in a compressed format, which cannot be directly read by humans, but which can be expanded and then read). Under the circumstances, you can follow either path, but I'd probably choose to upgrade and update in place, depending on details. Arguing in favor of a fully new start in 4.4 is the simplicity of downloading that version and starting anew. Rather strongly against this, however, is the fact that you have already imported most of your history into the older version--a process that is usually somewhat painful. Under the alternative, you'd update the software, confirm your existing data, and then import new transactions from Quicken. This would allow you to build off the existing data set, perhaps quickly. If you follow the upgrade path, the recommended method is to: 1) Make a backup of your data file. 2) Upgrade to 2.16.21, open your file and perform a check & repair on the entire file. 3) Upgrade to 3.11, open your file and perform a check & repair on the entire file. 4) Upgrade to 4.4, open your file and perform a check & repair on the entire file. 5) Export new transactions from Quicken. 6) Import these transactions into Gnucash. 7) Perform any reconciliations in date order. 8) Relax, don't worry, have a home brew. (This last directive might not apply to the current set of activities) HTH, David T. ___ 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] Best way to upgrade from an old version (2.6.14) to current
Brad, My version is the safest, "This is the way that everyone says it should be done" version. However, John is one of the core developers of the app, and if he says you can probably cut corners and just jump ahead, then that might be worth a try. Hey, if it doesn't work, you can always go back to your backup and use my version. You *did* make a backup before all this, right? David Original Message From: brad Sent: Wed Jan 13 15:16:54 EST 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] Best way to upgrade from an old version (2.6.14) to current I'm a bit confused as to the best update method. These seem to be differing methods, incrementally updating GC (3 steps), or jump to 4.4 (1 step) and let it do the data update in one step. Is the JR one step method reliable for a big file with many accounts? On 1/8/21 10:15 AM, John Ralls wrote: > > The old GnuCash file still has a bunch of imports and starting with it will > save you some time importing and perhaps training the import-matcher. Make a > separate backup of it for an extra layer of safety. > > Since you didn't actually use GnuCash much it's probably safe to just install > 4.4. The installer will take care of uninstalling your old 2.6.14. There's a > bunch of upgrading that GnuCash will do on its first run and a bunch more on > the first import, so be patient! If your existing file is large and your old > laptop is slow or doesn't have a lot of memory it may take more than an > hour--someone reported several hours for a very large file--to run all of the > startup scrubs and then more hours to update the import maps, so plug in the > laptop, turn off energy savers (it's OK to blank the screen but you don't > want it to go to sleep), and plan to leave it running for a while. > > As you bring the GnuCash file up to date do small imports--a month or two > worth of transactions--to begin. If most of the imported transactions are > matched correctly then you can go to larger import batches, but if they're > not then you'll want to do a half dozen or so small batches to train the > matcher. Note that there's a recently added feature that allows you to select > several transactions in the matcher window and assign all of them to the same > transfer account; just right-click after selecting and pick Assign Account > from the context menu (it's the only option). > > Remember to save frequently so that you can easily go back if something goes > wrong. > > Regards, > John Ralls On 1/8/21 10:28 AM, D. via gnucash-user wrote: > Welcome back! > > Let me start with the last point first: in my experience, Gnucash's developer > team is deeply committed to compatibility, and works to ensure that upgrades > preserve ALL previous data. Furthermore, the default data storage is XML, > which is text that is human readable, and fully transparent to the end user > (I'll add the caveat here that for efficiency's sake, the file is usually > stored in a compressed format, which cannot be directly read by humans, but > which can be expanded and then read). > > Under the circumstances, you can follow either path, but I'd probably choose > to upgrade and update in place, depending on details. Arguing in favor of a > fully new start in 4.4 is the simplicity of downloading that version and > starting anew. Rather strongly against this, however, is the fact that you > have already imported most of your history into the older version--a process > that is usually somewhat painful. > > Under the alternative, you'd update the software, confirm your existing data, > and then import new transactions from Quicken. This would allow you to build > off the existing data set, perhaps quickly. > > If you follow the upgrade path, the recommended method is to: > 1) Make a backup of your data file. > 2) Upgrade to 2.16.21, open your file and perform a check & repair on the > entire file. > 3) Upgrade to 3.11, open your file and perform a check & repair on the entire > file. > 4) Upgrade to 4.4, open your file and perform a check & repair on the entire > file. > 5) Export new transactions from Quicken. > 6) Import these transactions into Gnucash. > 7) Perform any reconciliations in date order. > 8) Relax, don't worry, have a home brew. (This last directive might not > apply to the current set of activities) > > HTH, > David T. > > ___ 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: h
Re: [GNC] Best way to upgrade from an old version (2.6.14) to current
Brad It really depends upon the situation. you originally said you had an old file from an early attempt to use GnuCash and there had been little importing of data since that time and that that data was expendable. In this case John's single step process is appropriate. You can then back import any necessary data as far back is required into a new file created with the new version. If on the other hand you had been a long term user with significant records in your existing file (My data file goes back to before 2010 and has data imported from previous accounting programs for example - I do question why I need this occasionally but that is a different matter.), the second update strategy (David T's) is the more appropriate and safest. Changes in data file structures normally only occur with the major version number changes, e.g 2.x to 3.x and 3.x to 4.x and the next major version incorporates procedures for updating the data files for changes from the previous major version. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Tax details on invoice (again)
Thanks Adrien for your reply. I hope this is the right way to respond to you again. I'm still floundering with this. I created a new footer style sheet called "invoice" containing the bank info text but I can't see how to access that when I print or create a pdf. What am I missing? Bill Turner 51/44 Zealey Rd Nambour QLD, 4560 MOB: 0412 168 989 billturner1945...@gmail.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.