Re: [GNC] Danish templates do not correctly mark accounts as placeholders

2021-01-13 Thread Frank H. Ellenberger
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

2021-01-13 Thread mummins heitzel
   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

2021-01-13 Thread Christopher Lam
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

2021-01-13 Thread Alan A Holmes
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

2021-01-13 Thread R. Victor Klassen
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

2021-01-13 Thread brad
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

2021-01-13 Thread D. via gnucash-user
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

2021-01-13 Thread David Cousens
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)

2021-01-13 Thread Bill Turner
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.