Re: [GNC] Setting up account

[Peter West]

Hi Brenda,

Rounding the number up to what? Can you give an example?

I’m on Mac, so things may be different for you.  If I go to the Preferences 
menu, under
Accounts > Default Currency
I can choose between Locale (mine is en-au, Australia, so that gives me AUD) or 
I canchoose a currency from a drop-down menu.  What currency is selected for 
you?

Under
General > Numbers > Decimal places:

I have 2. Is it the same for you?


--
Peter West
p...@pbw.id.au
And after looking around at them all he said to him, “Stretch out your hand.”

> On 10 Sep 2019, at 3:08 pm, Brenda Morton  wrote:
> 
> I set up an account and tried to add the beginning balance but it keeps
> rounding the number up. It also rounds many of the entries. How do I
> correct this?
> 
> Brenda
> ___
> 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] Setting up account

[Brenda Morton]

I set up an account and tried to add the beginning balance but it keeps
rounding the number up. It also rounds many of the entries. How do I
correct this?

Brenda
___
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 setup crash

[Adrien Monteleone]

Your bank’s format may require a newer version of aqbanking.

I think you can run 3.7 on Sierra, but I could be mistaken.

Certainly, there are 3.x versions that will run on it and you don’t have to 
stick with 2.6.21. One of them might have a recent enough version to get your 
transactions.

A last resort may be to run GnuCash in a Linux VM so you can have a fully 
up-to-date installation. VMWare has a seamless/unity mode, and if using 
VirtualBox it is possible to run a headless VM that opens a single app like 
GnuCash seamlessly with a GnuCash icon as if you didn’t know it was running in 
Vbox. (takes some work, but it is possible if that is important to you and you 
don’t like VM ‘window chrome’ getting in the way.)

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 9:33 PM, aegross  wrote:
> 
> I used to use aqbanking to download credit card transactions but stopped a
> couple of years ago; it used to work but I don't recall what version of
> GnuCash I was using then. 
> 
> Today, I tried using the aqbanking wizard and GnuCash crashed.  I also tried
> Actions\Online Actions\Show log window and that crashed GnuCash also.
> 
> GnuCash version: 2.6.21
> MacOs version: Sierra (10.12.6).  Owing to the age of the Mac, this is the
> last recent version that Apple will support.
> 
> I did some looking around for relevant documentation on how to debug but am
> not having success.  If anyone has any ideas, would be appreciated.
> 
> Thanks!
> 
> AEG 


___
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] could not obtain lock on file maybe in use some wh

[Adrien Monteleone]

> On Sep 9, 2019 w37d252, at 9:37 PM, David T.  wrote:
> 
> Adrien,
> 
> 
> Under most circumstances in this situation, I'd agree with you that the 
> problem was an unsuccessful exit. However, Bob clearly notes that not only 
> does he have troubles with the load, but also with saving and backup 
> creation. That sounds very much like some sort of permissions problem.

Yes, I misread that. (scanning too fast, sorry) Certainly, I’d agree in that 
case, something with permissions is likely askew.
> 
> 
> Bob, verify that you have full permissions for the folder in question. Also: 
> is this folder a cloud folder, like dropbox? Sometimes remote folders cause 
> problems. I'm sorry to be vague; I only recall that others have reported 
> troubles on Windows with cloud-stored files. A search of the list archives 
> might point to some further areas to investigate. 
> 

It is odd however that files on a thumb drive can be accessed but not locally 
as Bob noted.

My initial inclination was towards remote folders, but that tidbit threw me for 
a loop.

Perhaps the thumb drive is mounted with full permissions for ease of use, but 
the particular local folder is restricted somehow.

One other consideration, if other apps have writing/saving issues, maybe 
something is causing the drive to be ‘read-only’. I’ve never experienced that 
in Windows.

There might also be a problem with the user account.

On that note...

Bob,

Did you notice if you were in your own account or a guest account?

A guest account probably won’t give you write permission to a regular user’s 
files unless you’ve shared them publicly in advance, but if you installed an 
app for ‘all users’ you might still be able to run GnuCash.

Regards,
Adrien

p.s. - out of curiosity, are you logging into Win10 with a MS account? With a 
password or are you using other means of authentication? Issues with 
authentication *might* (I’m grasping at thin air here standing precariously on 
a very thin limb since I haven’t migrated my Win7 instances to Win10 yet) give 
you OS access and even access to apps, but not to files or write access to 
certain directories. Of course, I really have no idea, it is just a hunch if 
all else fails.


> David
> 
> 
> On Tue, Sep 10, 2019 at 6:38, Adrien Monteleone
>  wrote:
> Delete the .lck files in the directory you are storing your books.
> 
> (presuming you know for a *fact*, that the data files aren’t already open in 
> GnuCash but you just don’t see the window)
> 
> You should then be able to then open any data file.
> 
> You could also choose ‘Open-Anyway’ with the same result.
> 
> There might be several causes, but other than the most obvious (that the file 
> really is already opened) is that the app crashed last time you were 
> accessing that file and the .lck file was not removed due to the ‘ungraceful’ 
> shutdown of GnuCash.
> 
> I don’t think a permissions issue would cause this, but I could be mistaken. 
> Make sure you have full permissions on the folder you are storing the files.
> 
> Regards,
> Adrien
> 
> > On Sep 9, 2019 w37d252, at 7:45 PM, Bob Hammons  wrote:
> > 
> > I have a windows 10 laptop.  Today I got this message when I opened my file.
> > I have 3 different files on this computer and they all say the same thing.  
> > It will not allow any  backups so anything I did today is gone.
> > I tried older files and the same thing happened.
> > I tried my backups that were on a thumb drive.  They seemed to work from 
> > thumb drive.  I then copied them to a new directory on the computer and I 
> > got same message and no backups.
> > I updated to 3.7 with the same results.
> > My windows has been updating a couple time a week.  Could this be a windows 
> > problem?
> > 
> > Thanks for any help!

___
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 3.7 and Weekly Reports

[Adrien Monteleone]

Christopher,

So mark that also not working on MacOS as both of John Morris & I are seeing 
the same issue on different versions of it. (defaulting to Saturday with no 
ability to change it)

I’m just getting into Scheme and I haven’t yet tackled building on MacOS. 
(though I wanted to just to test your patch)

If there is info you could use on this platform let me know and I’ll see what I 
can scrounge up.

(give me a day or two for getting a maint build up and running, but I am 
running 3.7 for ‘production’ so any logging/debugging facilities I could 
provide feedback with.)

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 9:29 PM, Christopher Lam 
>  wrote:
> 
> Only the transaction report is expected to use the new locale-sensitive
> start-of-week feature. It is tested working on Linux, and is known to be
> not yet locale sensitive on windows.
> 
> On Tue, 10 Sep 2019, 00:58 John Morris,  wrote:
> 
>> Hi Adrien,
>>  Thank you for looking into this issue. The transaction report is the
>> main issue for me.
>> 
>> Best,
>> John
>> 
>>> On Sep 9, 2019, at 12:32 PM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>> 
>>> John,
>>> 
>>> I was hoping to get to test this as well pre-release, but didn’t get to.
>>> 
>>> I can confirm that at least for the Transaction Report, so far, indeed,
>> Saturday is a fixed start day. (My locale is set to Sunday)
>>> 
>>> I recall this was one report you were concerned with. Any others?
>>> 
>>> 
>>> Regards,
>>> Adrien

___
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-user Digest, Vol 198, Issue 17

[Adrien Monteleone]

You have a few issues with dependencies, but the biggest one is GnuCash 3.7 
wants boost 1.67 and your repos (based on stock Ubunutu 18.04) only offer 1.65.

Perhaps you could add a ppa, or build libboost 1.67 from scratch, but I’ve not 
attempted that route.

I don’t know if Mint has a similar upgrade path like the stock Ubuntu HWE 
stack. Those are supposed to only advance the kernel and video drivers as far 
as I’m aware, but if they enable more recent backports, that could help. 
(again, not sure if Mint has such a feature)

Maybe someone else who is either on Mint 19.2 (19.3 is not out yet) or Ubuntu 
18.04 and has successfully installed GC 3.7 can lend a hand.

Sorry I couldn’t be of more help. I’m in the middle of setting up a build 
environment for 3.7 on Ubuntu 19.04 and running into a few issues myself with 
old versions of boost.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 8:40 PM, Elmar  wrote:
> 
> Thanks - I did exactly that (downloaded all 3 packages) but I got no joy:
> 
> ets@Shinobi-L ~/Downloads $ sudo apt install ./*3.7*.deb
> [sudo] password for ets:
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Note, selecting 'gnucash' instead of './gnucash_3.7-0_amd64.deb'
> Note, selecting 'gnucash-common' instead of './gnucash-common_3.7-0_all.deb'
> Note, selecting 'python3-gnucash' instead of 
> './python3-gnucash_3.7-0_amd64.deb'
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
> 
> The following packages have unmet dependencies:
>  gnucash : Depends: libboost-date-time1.67.0 but it is not installable
>Depends: libboost-filesystem1.67.0 but it is not installable
>Depends: libboost-locale1.67.0 but it is not installable
>Depends: libboost-regex1.67.0 (>= 1.67.0-10) but it is not 
> installable
>Depends: libboost-system1.67.0 but it is not installable
>Depends: libicu63 (>= 63.1-1~) but it is not installable
>Depends: libofx7 (>= 1:0.9.14) but 1:0.9.12-1 is to be installed
>  python3-gnucash : Depends: python3 (>= 3.7~) but 3.6.7-1~18.04 is to be 
> installed
> E: Unable to correct problems, you have held broken packages.
> ets@Shinobi-L ~/Downloads $
> 
> - Elmar

___
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] AQbanking setup crash

[aegross]

I used to use aqbanking to download credit card transactions but stopped a
couple of years ago; it used to work but I don't recall what version of
GnuCash I was using then. 

Today, I tried using the aqbanking wizard and GnuCash crashed.  I also tried
Actions\Online Actions\Show log window and that crashed GnuCash also.

GnuCash version: 2.6.21
MacOs version: Sierra (10.12.6).  Owing to the age of the Mac, this is the
last recent version that Apple will support.

I did some looking around for relevant documentation on how to debug but am
not having success.  If anyone has any ideas, would be appreciated.

Thanks!

AEG 







--
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.

Re: [GNC] could not obtain lock on file maybe in use some wh

[David T. via gnucash-user]

Adrien,

Under most circumstances in this situation, I'd agree with you that the problem 
was an unsuccessful exit. However, Bob clearly notes that not only does he have 
troubles with the load, but also with saving and backup creation. That sounds 
very much like some sort of permissions problem. 

Bob, verify that you have full permissions for the folder in question. Also: is 
this folder a cloud folder, like dropbox? Sometimes remote folders cause 
problems. I'm sorry to be vague; I only recall that others have reported 
troubles on Windows with cloud-stored files. A search of the list archives 
might point to some further areas to investigate. 

David

 
 
  On Tue, Sep 10, 2019 at 6:38, Adrien 
Monteleone wrote:   Delete the .lck files in 
the directory you are storing your books.

(presuming you know for a *fact*, that the data files aren’t already open in 
GnuCash but you just don’t see the window)

You should then be able to then open any data file.

You could also choose ‘Open-Anyway’ with the same result.

There might be several causes, but other than the most obvious (that the file 
really is already opened) is that the app crashed last time you were accessing 
that file and the .lck file was not removed due to the ‘ungraceful’ shutdown of 
GnuCash.

I don’t think a permissions issue would cause this, but I could be mistaken. 
Make sure you have full permissions on the folder you are storing the files.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 7:45 PM, Bob Hammons  wrote:
> 
> I have a windows 10 laptop.  Today I got this message when I opened my file.
> I have 3 different files on this computer and they all say the same thing.  
> It will not allow any  backups so anything I did today is gone.
> I tried older files and the same thing happened.
> I tried my backups that were on a thumb drive.  They seemed to work from 
> thumb drive.  I then copied them to a new directory on the computer and I got 
> same message and no backups.
> I updated to 3.7 with the same results.
> My windows has been updating a couple time a week.  Could this be a windows 
> problem?
> 
> Thanks for any help!

___
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 3.7 and Weekly Reports

[Christopher Lam]

Only the transaction report is expected to use the new locale-sensitive
start-of-week feature. It is tested working on Linux, and is known to be
not yet locale sensitive on windows.

On Tue, 10 Sep 2019, 00:58 John Morris,  wrote:

> Hi Adrien,
>   Thank you for looking into this issue. The transaction report is the
> main issue for me.
>
> Best,
> John
>
> > On Sep 9, 2019, at 12:32 PM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > John,
> >
> > I was hoping to get to test this as well pre-release, but didn’t get to.
> >
> > I can confirm that at least for the Transaction Report, so far, indeed,
> Saturday is a fixed start day. (My locale is set to Sunday)
> >
> > I recall this was one report you were concerned with. Any others?
> >
> >
> > Regards,
> > Adrien
> ___
> 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-user Digest, Vol 198, Issue 17

[Elmar]

Thanks - I did exactly that (downloaded all 3 packages) but I got no joy:

ets@Shinobi-L ~/Downloads $ sudo apt install ./*3.7*.deb
[sudo] password for ets:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'gnucash' instead of './gnucash_3.7-0_amd64.deb'
Note, selecting 'gnucash-common' instead of './gnucash-common_3.7-0_all.deb'
Note, selecting 'python3-gnucash' instead of 
'./python3-gnucash_3.7-0_amd64.deb'

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 gnucash : Depends: libboost-date-time1.67.0 but it is not installable
   Depends: libboost-filesystem1.67.0 but it is not installable
   Depends: libboost-locale1.67.0 but it is not installable
   Depends: libboost-regex1.67.0 (>= 1.67.0-10) but it is not 
installable

   Depends: libboost-system1.67.0 but it is not installable
   Depends: libicu63 (>= 63.1-1~) but it is not installable
   Depends: libofx7 (>= 1:0.9.14) but 1:0.9.12-1 is to be installed
 python3-gnucash : Depends: python3 (>= 3.7~) but 3.6.7-1~18.04 is to 
be installed

E: Unable to correct problems, you have held broken packages.
ets@Shinobi-L ~/Downloads $

- Elmar

On 9/9/19 9:06 PM, gnucash-user-requ...@gnucash.org wrote:

Message: 4
Date: Mon, 9 Sep 2019 15:32:06 -0500
From: Adrien Monteleone
To: Gnucash Users
Subject: Re: [GNC] upgrade to 3.7?
Message-ID:
Content-Type: text/plain;   charset=us-ascii

Elmar,

That package was for building from source.

If you want .deb files to install, one user is graciously packing them and 
making them publicly available via Dropbox found in this thread:

https://lists.gnucash.org/pipermail/gnucash-user/2019-September/086840.html

Follow the instructions in the thread.

Regards,
Adrien

___
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] could not obtain lock on file maybe in use some where else

[Adrien Monteleone]

Delete the .lck files in the directory you are storing your books.

(presuming you know for a *fact*, that the data files aren’t already open in 
GnuCash but you just don’t see the window)

You should then be able to then open any data file.

You could also choose ‘Open-Anyway’ with the same result.

There might be several causes, but other than the most obvious (that the file 
really is already opened) is that the app crashed last time you were accessing 
that file and the .lck file was not removed due to the ‘ungraceful’ shutdown of 
GnuCash.

I don’t think a permissions issue would cause this, but I could be mistaken. 
Make sure you have full permissions on the folder you are storing the files.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 7:45 PM, Bob Hammons  wrote:
> 
> I have a windows 10 laptop.   Today I got this message when I opened my file.
> I have 3 different files on this computer and they all say the same thing.   
> It will not allow any  backups so anything I did today is gone.
> I tried older files and the same thing happened.
> I tried my backups that were on a thumb drive.  They seemed to work from 
> thumb drive.  I then copied them to a new directory on the computer and I got 
> same message and no backups.
> I updated to 3.7 with the same results.
> My windows has been updating a couple time a week.  Could this be a windows 
> problem?
> 
> Thanks for any help!

___
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] could not obtain lock on file maybe in use some where else

[Bob Hammons]

I have a windows 10 laptop.   Today I got this message when I opened my file.
I have 3 different files on this computer and they all say the same thing.   It 
will not allow any  backups so anything I did today is gone.
I tried older files and the same thing happened.
I tried my backups that were on a thumb drive.  They seemed to work from thumb 
drive.  I then copied them to a new directory on the computer and I got same 
message and no backups.
I updated to 3.7 with the same results.
My windows has been updating a couple time a week.  Could this be a windows 
problem?

Thanks for any help!
___
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] Simple Reports

[Adrien Monteleone]

What do you mean by ‘one type’?

Can you give a real world example?

The Transaction Report (but not the Account Report) has a Transaction Filter 
setting. If you have info in the Memo, Notes, or other fields you want to 
filter by, put that matching text there)

For example, I can run a transaction report on my Expenses:Food:Dining:Alcohol 
account filtered to ‘Reve’ and then I only see the transactions where I drank a 
Reve Coffee Stout at a restaurant. That’s about as drill down as I think you 
can get. (of course, I had to have that detail entered in the Memo to filter by 
in the first place)

You can export the report if need be and it should open up in a spreadsheet app 
just fine. (or copy/paste into a blank sheet)

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 5:00 PM, mrtibbsabq  wrote:
> 
> Thanks Rich and David. This got me down one level but now I want to filter
> for only one type of expense. Is there a way to go down one more level? I
> have even thought about just exporting the date-filtered report as a CVS
> file so I can clean it up that way but I cannot see a way to even do that.
> 
> 
> 
> --
> 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.

Re: [GNC] Simple Reports

[Mike or Penny Novack]

On 9/9/2019 10:28 AM, mrtibbsabq wrote:

Hi. I have been using GnuCash for awhile now but I cannot see a way to tunnel
down into the data and generate some simple reports. I would like to
generate a report between two dates that show only the expenses for a
specific expense category. That seemed easy to do in MS Money but I am stuck
with GnuCash. Can someone set me on the right path here? Thanks.
Or alternatively, if it is an entire subtree or several subtrees of 
expenses that you want.


Use the "Income Statement" and either:
1) Exclude all the accounts you do not want
or (possibly less work)
2) Run the full report, export, and delete the parts you don't want (the 
possibly less work because this might be vast swaths of the report)


Michael D Novack
___
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] Simple Reports

[mrtibbsabq]

Thanks Rich and David. This got me down one level but now I want to filter
for only one type of expense. Is there a way to go down one more level? I
have even thought about just exporting the date-filtered report as a CVS
file so I can clean it up that way but I cannot see a way to even do that.



--
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.

Re: [GNC] Can't seem to load custom reports

[Adrien Monteleone]

I didn’t get to test #1 & #2 again, but sticking with #3, I started GnuCash with

--debug --log gnc.scm=debug

And got some useful info.

It seems all but one of the reports were using:

(use-modules (gnucash main))

which apparently doesn’t exist any more.

The one report that did work was using:

(use-modules (gnucash utilities))

I haven’t had a look yet to see what the changes were and what that includes.

The other failing reports also use:

(use-modules (gnucash printf))

which apparently also doesn’t exist and was commented out in the one working 
report.

Unfortunately, the code for those reports would have to be updated it seems to 
avoid those modules as they fail with them commented out. (understandably)

The following loads and runs correctly:

consolidate-transactions.scm

The following all fail and need to be updated:

compare-cash-flows.scm
current-vs-average.scm
transaction-budget.scm
reconcile.scm (supposedly a re-write, was this already incorporated into the 
included report?)
missing-checks.scm (I don’t use this, but noticed it failed as well)

If anyone has any info on fixing the above reports with respect to the main & 
printf modules, or where I might find more current versions, many thanks.

> On Sep 9, 2019 w37d252, at 3:55 PM, Adrien Monteleone 
>  wrote:
> 
> Spurred by another thread concerning carrying over custom reports from 2.6.x 
> to 3.x, I finally decided to get around to doing the same for my own. I’ve 
> grabbed several reports from the mailing list over the years that I was 
> testing and playing with from 2.6.x and would like to get them working again.
> 
> I’m on Mojave.
> 
> The reports are stored in:
> 
> /HOME/Library/Application Support/GnuCash
> 
> I have a config-user.scm file there as well.
> 
> I’ve tried three different syntaxes of the ‘load’ directive in that file. 
> Following is each method along with TraceFile output for each:
> 
> -
> #1 - escaping the [space] in the path
> 
> (load (/Users/adrien/Library/Application\ Support/GnuCash 
> “my-various-report.scm”))
> 
> TraceFile:
> 
> * 14:31:17  WARN10 (apply-smob/1 # 10e67c300>)
> In c-interface.scm:
> 22:4  9 (gnc:call-with-error-handling _ _)
> In ice-9/boot-9.scm:
>829:9  8 (catch #t # …)
> In c-interface.scm:
>27:37  7 (_)
> In unknown file:
>   6 (eval-string "(load (/Users/adrien/Library/Application…" …)
> In ice-9/boot-9.scm:
>   2312:4  5 (save-module-excursion #)
> In ice-9/eval-string.scm:
> 38:6  4 (read-and-eval # #:lang _)
> In ice-9/eval.scm:
>159:9  3 (_ #f)
>   196:27  2 (_ #f)
>   223:20  1 (proc #)
> In unknown file:
>   0 (%resolve-variable (7 . #) #)
> 
> Unbound variable: /Users/adrien/Library/Application\
> * 14:31:43 ERROR  g_object_ref: assertion 'G_IS_OBJECT 
> (object)' failed
> * 14:31:43 ERROR  g_object_ref: assertion 'G_IS_OBJECT 
> (object)’ failed
> 
> -
> #2 - quoting the [space] in the path
> 
> (load ("/Users/adrien/Library/Application Support/GnuCash" 
> “my-various-report.scm”))
> 
> TraceFile:
> 
> * 14:35:51  WARN 8 (apply-smob/1 # 11107a320>)
> In c-interface.scm:
> 22:4  7 (gnc:call-with-error-handling _ _)
> In ice-9/boot-9.scm:
>829:9  6 (catch #t # …)
> In c-interface.scm:
>27:37  5 (_)
> In unknown file:
>   4 (eval-string "(load (\"/Users/adrien/Library/Applicati…" …)
> In ice-9/boot-9.scm:
>   2312:4  3 (save-module-excursion #)
> In ice-9/eval-string.scm:
> 38:6  2 (read-and-eval # #:lang _)
> In ice-9/eval.scm:
>159:9  1 (_ #f)
> In unknown file:
>   0 (_ "gnctimeperiod-utilities.scm")
> 
> Wrong type to apply: "/Users/adrien/Library/Application Support/GnuCash”
> 
> -
> #3 - direct full path
> 
> (load "/Users/adrien/Library/Application 
> Support/GnuCash/my-various-report.scm”)
> 
> 
> TraceFile:
> 
> 
> * 14:38:58  WARN  In c-interface.scm:
> 22:4 19 (gnc:call-with-error-handling _ _)
> In ice-9/boot-9.scm:
>829:9 18 (catch _ _ # …)
> In c-interface.scm:
>27:37 17 (_)
> In unknown file:
>  16 (eval-string "(load \"/Users/adrien/Library/Applicatio…" …)
> In ice-9/boot-9.scm:
>   2312:4 15 (save-module-excursion _)
> In ice-9/eval-string.scm:
> 38:6 14 (read-and-eval # #:lang _)
> In ice-9/boot-9.scm:
>   2312:4 13 (save-module-excursion #)
>  3832:10 12 (_)
>   1693:5 11 (%start-stack load-stack _)
>   1695:9 10 (_)
> In unknown file:
>   9 (primitive-load "/Users/adrien/Library/Application Supp…")
> In ice-9/eval.scm:
>   721:20  8 (primitive-eval (use-modules (gnucash main)))
> In ice-9/psyntax.scm:
>  1235:36  7 (expand-top-sequence ((use-modules (gnucash main))) _ _ …)
>  1182:24  6 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
>   285:10  5 (parse _ (("placeholder" placeholder)) (()) _ c (eval) …)
> In ice-9/boot-9.scm:
>  3377:20  4 (process-use-modules _)
>   222:17  3 (map1 (((gnucash main
>  3378:31  2 (_ ((gnucash main)))
>   2803:6  1 (resolve-interface _ #:select _ #:hide _ #:prefix _ # _ 

[GNC] Can't seem to load custom reports

[Adrien Monteleone]

Spurred by another thread concerning carrying over custom reports from 2.6.x to 
3.x, I finally decided to get around to doing the same for my own. I’ve grabbed 
several reports from the mailing list over the years that I was testing and 
playing with from 2.6.x and would like to get them working again.

I’m on Mojave.

The reports are stored in:

/HOME/Library/Application Support/GnuCash

I have a config-user.scm file there as well.

I’ve tried three different syntaxes of the ‘load’ directive in that file. 
Following is each method along with TraceFile output for each:

-
#1 - escaping the [space] in the path

(load (/Users/adrien/Library/Application\ Support/GnuCash 
“my-various-report.scm”))

TraceFile:

* 14:31:17  WARN10 (apply-smob/1 #)
In c-interface.scm:
 22:4  9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  8 (catch #t # …)
In c-interface.scm:
27:37  7 (_)
In unknown file:
   6 (eval-string "(load (/Users/adrien/Library/Application…" …)
In ice-9/boot-9.scm:
   2312:4  5 (save-module-excursion #)
In ice-9/eval-string.scm:
 38:6  4 (read-and-eval # #:lang _)
In ice-9/eval.scm:
159:9  3 (_ #f)
   196:27  2 (_ #f)
   223:20  1 (proc #)
In unknown file:
   0 (%resolve-variable (7 . #) #)

Unbound variable: /Users/adrien/Library/Application\
* 14:31:43 ERROR  g_object_ref: assertion 'G_IS_OBJECT (object)' 
failed
* 14:31:43 ERROR  g_object_ref: assertion 'G_IS_OBJECT (object)’ 
failed

-
#2 - quoting the [space] in the path

(load ("/Users/adrien/Library/Application Support/GnuCash" 
“my-various-report.scm”))

TraceFile:

* 14:35:51  WARN 8 (apply-smob/1 #)
In c-interface.scm:
 22:4  7 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  6 (catch #t # …)
In c-interface.scm:
27:37  5 (_)
In unknown file:
   4 (eval-string "(load (\"/Users/adrien/Library/Applicati…" …)
In ice-9/boot-9.scm:
   2312:4  3 (save-module-excursion #)
In ice-9/eval-string.scm:
 38:6  2 (read-and-eval # #:lang _)
In ice-9/eval.scm:
159:9  1 (_ #f)
In unknown file:
   0 (_ "gnctimeperiod-utilities.scm")

Wrong type to apply: "/Users/adrien/Library/Application Support/GnuCash”

-
#3 - direct full path

(load "/Users/adrien/Library/Application Support/GnuCash/my-various-report.scm”)


TraceFile:


* 14:38:58  WARN  In c-interface.scm:
 22:4 19 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9 18 (catch _ _ # …)
In c-interface.scm:
27:37 17 (_)
In unknown file:
  16 (eval-string "(load \"/Users/adrien/Library/Applicatio…" …)
In ice-9/boot-9.scm:
   2312:4 15 (save-module-excursion _)
In ice-9/eval-string.scm:
 38:6 14 (read-and-eval # #:lang _)
In ice-9/boot-9.scm:
   2312:4 13 (save-module-excursion #)
  3832:10 12 (_)
   1693:5 11 (%start-stack load-stack _)
   1695:9 10 (_)
In unknown file:
   9 (primitive-load "/Users/adrien/Library/Application Supp…")
In ice-9/eval.scm:
   721:20  8 (primitive-eval (use-modules (gnucash main)))
In ice-9/psyntax.scm:
  1235:36  7 (expand-top-sequence ((use-modules (gnucash main))) _ _ …)
  1182:24  6 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
   285:10  5 (parse _ (("placeholder" placeholder)) (()) _ c (eval) …)
In ice-9/boot-9.scm:
  3377:20  4 (process-use-modules _)
   222:17  3 (map1 (((gnucash main
  3378:31  2 (_ ((gnucash main)))
   2803:6  1 (resolve-interface _ #:select _ #:hide _ #:prefix _ # _ …)
In unknown file:
   0 (scm-error misc-error #f "~A ~S" ("no code for modu…" …) …)

no code for module (gnucash main)

-
I noticed for #2 & #3 that quoting the path has `load` wanting to insert a “\” 
before it, or at least that’s what it looks like. (see #2 line 4 and #3 line 16)

#1 wants to truncate the path at the escape for the space.

#3 appears to get further along in loading. Perhaps there is a problem with one 
of the reports? Unfortunately, the TraceFile doesn’t seem to indicate which one.

Thoughts, ideas? Am I missing something or have a syntax error I’m not seeing? 
Do I just have to test them one by one to find the culprit?

Thanks.

Regards,
Adrien



___
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] upgrade to 3.7?

[Adrien Monteleone]

Elmar,

That package was for building from source.

If you want .deb files to install, one user is graciously packing them and 
making them publicly available via Dropbox found in this thread:

https://lists.gnucash.org/pipermail/gnucash-user/2019-September/086840.html

Follow the instructions in the thread.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 3:00 PM, Elmar  wrote:
> 
> I downloaded and unpacked gnucash-3.7.tar.gz, but now I don't know what to do 
> with the resulting folder - there is no install shell thingie.  How do I 
> proceed?  I have 3.6 running now. (Linux Mint 19.3).  thanks - Elmar

___
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 3.7 and Reports

[Adrien Monteleone]

John,

This one time is okay, but you really shouldn’t e-mail members directly unless 
specifically requested to. At the very least, others would benefit from the 
exchange. I’m replying to the list to keep the thread going there.

For attachments, mailman seems to like it when your e-mail client puts them all 
at the end, not in-line. So what you have here would probably get stripped out. 
I’ve seen some people refer to each attachment by a number in that case in the 
text. Another option I’ve used at times is img.ur and I just include the links 
in my text.

---

Now, let's tackle the invoice formatting.

For starters, maybe give the default stylesheet a try and see if it gets you 
close (or exactly) to what you want. The default now lets you include an image, 
so you don’t *have* to use Fancy Invoice. Also, maybe play with the banner 
size. If you don’t need it to be full-width, and more like a logo, that might 
help.

Second, pay careful attention to the settings for Rows 1-3 and Left-Right. I 
noticed that your current settings show ‘Our Details’ as Right, but the 2.6.x 
version had them as Left.  Try the following:

Row 1 Left: Picture
Row 1 Right: (empty)
Row 2 Left: Our Details
Row 2 Right: Invoice Details
Row 3 Left: Their Details

This would considerably clean up the display and get you closer to what you had 
with 2.6.x (though not perfectly)

Also setting:

.invoice-title { float: right; }

Should place the invoice # right above the other invoice detail so it looks 
like it is all together.

Of course, there might be cleaner layouts based on the info you have. Note as 
well, that if the section ‘Our Details’ takes up too much vertical space to 
balance out the header, consider placing that info in the ‘Contact’ or ‘Payment 
to’ sections in Options > Display, and then removing it from File > Properties 
> Business. If you need them in Properties > Business for some other reason, 
you can still include them in the "Contact/Payment to" sections and just 
suppress the output at the top with one or all of the following in Options > 
Layout > CSS

.company-email { display: none; }
.company-url { display: none; }
.company-phone { display: none; }

Now, for the invoice detail...

I’m not sure why that second screenshot is so narrow. There were some 
stylesheet changes between 2.6.x and now, so that may be the issue. Try 
exporting the report as an .html file and then opening it with a web browser to 
see if it looks normal. (and then you can print from there) If that works, 
maybe file a bug on Fancy Invoice, but double check any customizations first. 
However, I see your later screenshots seem to be full width, so I’m not sure 
what is going on there.

Finally, I wouldn't mess with the table sizes. You need all 3 to be 100% so it 
always fills the whole width and things don’t look messy or cut off as you 
found with screenshot #7.

Screenshot #3 looks like what I get, save my header Rows and Left/Right 
alignments are different and more balanced.

Regards,
Adrien



> On Sep 9, 2019 w37d252, at 2:26 PM, John Morris  wrote:
> 
> Hi Adrien,
>  Thank you for looking into this in more detail. It is interesting that you 
> are not seeing the problems I am having. That give me hope that I may be able 
> to resolve this without getting a new version of GnuCash.
> 
>  I’m writing directly to you this time because I am not sure if I can include 
> attachments to the list. I’m hoping that I can show you in more detail what 
> I’m getting and what I expect.
> 
>  We are using a customized style sheet based on the Fancy Invoice style 
> sheet, but I did not change it much. Mostly, I just added the banner across 
> the top. Here is a sample of what we were getting in GnuCash 2.6.16.
> 
>  Note that the invoice number is in the same field as the invoice date and 
> the due date and they are all roughly right aligned. Most importantly, the 
> itemization takes up the full width of the page. Next, here is what I get for 
> the same invoice report using GnuCash 3.7.
> 
> Note that the invoice number is now at the top of the page. More importantly, 
> Everything is “right aligned” to a line just past the middle of the page, 
> leaving a large white space on the right. This version includes the fix you 
> suggested earlier to get the invoice right aligned. Thank you for that. Next, 
> I tried filling in the item description to make it wrap (an unlikely scenario 
> in our business). Here is the result.
> 
> Note that the invoice number, and everything else, is correctly right 
> justified. Please ignore the slight misalignment of the numbers in the item 
> descriptions. That is due to me editing the invoice to anonymize it. 
> 
> 
> Next, based on your suggestion to fix the positioning of the invoice number 
> and my very limited understanding of CSS, I played around with the table 
> sizes. Here are screenshots of the original settings and the new settings 
> that at least get our usual invoice to print close 

[GNC] upgrade to 3.7?

[Elmar]

I downloaded and unpacked gnucash-3.7.tar.gz, but now I don't know what 
to do with the resulting folder - there is no install shell thingie.  
How do I proceed?  I have 3.6 running now. (Linux Mint 19.3).  thanks - 
Elmar


___
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 3.7 and Reports

[John Ralls]

> On Sep 9, 2019, at 11:03 AM, Adrien Monteleone 
>  wrote:
> 
>> On Sep 9, 2019 w37d252, at 12:41 PM, John Morris  wrote:
>> 
>> Hi Adrien,
>> Thanks for looking into this issue as well. I will study the new procedure 
>> for loading reports as soon as I am able.
>> 
>>> 1. My invoices (editing/viewing) all pad to the width of the window no 
>>> matter how I size it, so I’m not sure what you have going on. Maybe try 
>>> double-clicking the description header and see if they don’t snap back to 
>>> normal from then on. (I’m also on Mojave)
>> 
>> I’m not sure, but I think we may be comparing apples and oranges. Yes, when 
>> editing an invoice, the columns pad out to fill the window. The issue I was 
>> reporting is about the printable invoice report. There are several options 
>> to choose from (easy, fancy, technicolor and others I don’t recall). None of 
>> them seem to pad out the _printable_ invoice to fill the page. Because these 
>> are static reports, double clicking has no effect.
> 
> Sorry, I misunderstood. But my Invoice Report also pads correctly. The entire 
> item detail table just takes up more horizontal space when the descriptions 
> get longer and the shorter description items all fall in line. (the entire 
> table is sized the same and all columns line up) So I *really* am not sure 
> where the problem lies. The report is just an HTML table. The widths are not 
> fixed. (I don’t have a description that would line-wrap, but I’ll make 
> something up to test.)
> 
>> 
>>> 2. I don’t have a copy of 2.6.x handy to see what it was doing, but indeed, 
>>> the invoice # prints on the top left. This is because it is the ’title’ of 
>>> the document.
>>> 
>>> You can fix that in Options > Layout > CSS
>>> 
>>> add this line:
>>> 
>>> .invoice-title { float: right; }
>>> 
>>> and Apply.
>> 
>> I will try this fix as soon as I can. Is there any way to change it so the 
>> invoice number is not the title of the document? I would rather be able to 
>> put it down in the invoice details where I want it.
> 
> Not without editing the Scheme report code, saving it as a custom report, and 
> then loading it like Doug’s reports.
> 
> For my own invoices, it appeared to look as if it were part of the invoice 
> details. (above the invoice date and due date) Font selection and size should 
> be able to make it appear that way. If you run into trouble attempting that 
> with the built-in stylesheet editor, or aren’t familiar with CSS, shout back 
> and I’ll see what I can come up with.

Note that the Invoice reports include a field in Options>Layout to add custom 
CSS so you can style it however you like.

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] ISO 31-0 number writing

[John Ralls]

It should, provided that the Unix locale settings provided by the OS are 
correct. For example Apple has a long-standing error in their Swiss currency 
file that provides '.' and ',' for the thousands separator and decimal point 
respectively (the Swiss use ' ' and '.'). The ICU-based locale data are 
correct, which confuses users.

Regards,
John Ralls

> On Sep 9, 2019, at 10:23 AM, Adrien Monteleone 
>  wrote:
> 
> David,
> 
> I would second that notion against making it default.
> 
> I see this as an issue of locale though, and it is only for display. (the 
> grouping space, like the grouping comma is not part of the data, or should 
> not be.) Also, Fiable notes the desire to copy/paste or import, so typing the 
> thin/narrow space wouldn’t be an issue, and that can be solved anyway with a 
> keyboard map and a higher level modifier key.
> 
> Fiable,
> 
> What is your locale setting in your OS? Do you have ‘grouping’ set to 
> ’space’? Is your default currency in GnuCash also one normally used in that 
> locale? I should think GnuCash would use that OS setting. (or should)
> 
> Regards,
> Adrien
> 
> 
>> On Sep 9, 2019 w37d252, at 8:24 AM, David Carlson 
>>  wrote:
>> 
>> First, ISO 31-0 was withdrawn on 17 November 2009. It is superseded by ISO
>> 8-1 . Other parts of ISO 31
>> have also been withdrawn and replaced by parts of ISO 8
>> .
>> 
>> That standard suggests that large numbers with many digits be displayed as
>> groups of three separated by a small space instead of dots or commas.  We
>> do not have small space characters on our keyboards, so that will be
>> difficult to implement.
>> 
>> I would also argue that in the U.S. average persons will adopt small spaces
>> with the same fervor that they have adopted metric measures in general.
>> 
>> While it would be ok to adopt this convention as an alternate in GnuCash, I
>> am strongly against forcing the display  to omit dots or commas as
>> thousands separators.
>> 
>> From Wikipedia " In Unicode , thin
>> space is encoded at U+
>> 
>> 2009   thin space (HTML  *·* ). Unicode's U+
>> 
>> 202F   narrow no-break space
>>  (HTML )
>> is a non-breaking
>> space  with a width
>> similar to that of the thin space."
>> 
>> That's my 2 ¢.
>> 
>> On Mon, Sep 9, 2019 at 6:40 AM Fiable.biz via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> Hello.
>>> I suggest an option for the acceptance by GnuCash of the international
>>> notation of numbers, as defined by ISO 31-0 standard and the 22nd General
>>> Conference on Weights and Measures, which declared in 2003 that "the symbol
>>> for the decimal marker shall be either the point on the line or the comma
>>> on the line" and further reaffirmed that "numbers may be divided in groups
>>> of three in order to facilitate reading; neither dots nor commas are ever
>>> inserted in the spaces between groups".81 235,67 and 81 235.67 have the
>>> same meaning and would both be accepted, but 81,235.67 would be refused.
>>> Presently space is neither accepted in importing nor in pasting into
>>> GnuCash. Moreover, if one has chosen the dot as decimal separator then the
>>> coma is refused and vice versa... So I very often have to modify files in
>>> LibreOffice before importing them into GnuCash, and to type figures I could
>>> just copy and paste.
> 
> ___
> 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] appimage

[Dennis Powless]

I just 'installed' Digikam with it and it was a dream/easy!

d

On Mon, Sep 9, 2019 at 1:52 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> There was some discussion a while back on packaging it, but I think it was
> settled to opt for Flatpak. There also is/was a Snap, but I think it stays
> rather dated compared to the current release. (it is not maintained by the
> devs)
>
> Regards,
> Adrien
>
> > On Sep 9, 2019 w37d252, at 12:07 PM, Dennis Powless <
> dpowless...@pobox.com> wrote:
> >
> > Is gnucash available via appimage?
> >
> > D
>
> ___
> 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 3.7 and Reports

[Adrien Monteleone]

> On Sep 9, 2019 w37d252, at 12:41 PM, John Morris  wrote:
> 
> Hi Adrien,
>  Thanks for looking into this issue as well. I will study the new procedure 
> for loading reports as soon as I am able.
> 
>> 1. My invoices (editing/viewing) all pad to the width of the window no 
>> matter how I size it, so I’m not sure what you have going on. Maybe try 
>> double-clicking the description header and see if they don’t snap back to 
>> normal from then on. (I’m also on Mojave)
> 
>  I’m not sure, but I think we may be comparing apples and oranges. Yes, when 
> editing an invoice, the columns pad out to fill the window. The issue I was 
> reporting is about the printable invoice report. There are several options to 
> choose from (easy, fancy, technicolor and others I don’t recall). None of 
> them seem to pad out the _printable_ invoice to fill the page. Because these 
> are static reports, double clicking has no effect.

Sorry, I misunderstood. But my Invoice Report also pads correctly. The entire 
item detail table just takes up more horizontal space when the descriptions get 
longer and the shorter description items all fall in line. (the entire table is 
sized the same and all columns line up) So I *really* am not sure where the 
problem lies. The report is just an HTML table. The widths are not fixed. (I 
don’t have a description that would line-wrap, but I’ll make something up to 
test.)

> 
>> 2. I don’t have a copy of 2.6.x handy to see what it was doing, but indeed, 
>> the invoice # prints on the top left. This is because it is the ’title’ of 
>> the document.
>> 
>> You can fix that in Options > Layout > CSS
>> 
>> add this line:
>> 
>> .invoice-title { float: right; }
>> 
>> and Apply.
> 
>  I will try this fix as soon as I can. Is there any way to change it so the 
> invoice number is not the title of the document? I would rather be able to 
> put it down in the invoice details where I want it.

Not without editing the Scheme report code, saving it as a custom report, and 
then loading it like Doug’s reports.

For my own invoices, it appeared to look as if it were part of the invoice 
details. (above the invoice date and due date) Font selection and size should 
be able to make it appear that way. If you run into trouble attempting that 
with the built-in stylesheet editor, or aren’t familiar with CSS, shout back 
and I’ll see what I can come up with.

Regards,
Adrien

___
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] appimage

[Adrien Monteleone]

There was some discussion a while back on packaging it, but I think it was 
settled to opt for Flatpak. There also is/was a Snap, but I think it stays 
rather dated compared to the current release. (it is not maintained by the devs)

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 12:07 PM, Dennis Powless  
> wrote:
> 
> Is gnucash available via appimage?
> 
> D

___
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 3.7 and Weekly Reports

[Adrien Monteleone]

I’ve updated the bug with a notation of the current problem: 
https://bugs.gnucash.org/show_bug.cgi?id=752395

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 11:56 AM, John Morris  wrote:
> 
> Hi Adrien,
>  Thank you for looking into this issue. The transaction report is the main 
> issue for me.
> 
> Best,
> John

___
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 3.7 and Reports

[John Morris]

Hi Adrien,
  Thanks for looking into this issue as well. I will study the new procedure 
for loading reports as soon as I am able.

> 1. My invoices (editing/viewing) all pad to the width of the window no matter 
> how I size it, so I’m not sure what you have going on. Maybe try 
> double-clicking the description header and see if they don’t snap back to 
> normal from then on. (I’m also on Mojave)

  I’m not sure, but I think we may be comparing apples and oranges. Yes, when 
editing an invoice, the columns pad out to fill the window. The issue I was 
reporting is about the printable invoice report. There are several options to 
choose from (easy, fancy, technicolor and others I don’t recall). None of them 
seem to pad out the _printable_ invoice to fill the page. Because these are 
static reports, double clicking has no effect.

> 2. I don’t have a copy of 2.6.x handy to see what it was doing, but indeed, 
> the invoice # prints on the top left. This is because it is the ’title’ of 
> the document.
> 
> You can fix that in Options > Layout > CSS
> 
> add this line:
> 
> .invoice-title { float: right; }
> 
> and Apply.

  I will try this fix as soon as I can. Is there any way to change it so the 
invoice number is not the title of the document? I would rather be able to put 
it down in the invoice details where I want it.

Best,
John

___
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] Simple Reports

[Adrien Monteleone]

Even better for the slightly adventurous, Doug Doughty some moons ago on this 
list posted a Comparison Transaction Report that is awesome as it allows you to 
see how your spending has changed in particular accounts over time and you can 
customize the periods/intervals, etc. I say ‘adventurous’ because one will have 
to download the custom report from the list, copy it to your GnuCash report 
directory and then make a small modification to a file so it will load in 
GnuCash. Not major surgery, but not for the point-and-click only types. I wish 
he’d submit it to be included in a future release.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 11:38 AM, Rich Shepard  
> wrote:
> 
> On Mon, 9 Sep 2019, D wrote:
> 
>> Not quite. Using your method, open the account, open View->Filter by, set
>> your dates, then run the account report.
>> 
>> Alternatively, open the generic Transaction report, in options, choose the
>> account in question, and set the dates.
>> 
>> I prefer option 2, inasmuch as I don't have to remember to clear the
>> filter from the account after my query, which you have to do in the first
>> method.
> 
> David,
> 
> Those approaches look familiar. I was working from memory so I'm not
> surprised I was off a bit.
> 
> Thanks,
> 
> Rich

___
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] ISO 31-0 number writing

[Adrien Monteleone]

David,

I would second that notion against making it default.

I see this as an issue of locale though, and it is only for display. (the 
grouping space, like the grouping comma is not part of the data, or should not 
be.) Also, Fiable notes the desire to copy/paste or import, so typing the 
thin/narrow space wouldn’t be an issue, and that can be solved anyway with a 
keyboard map and a higher level modifier key.

Fiable,

What is your locale setting in your OS? Do you have ‘grouping’ set to ’space’? 
Is your default currency in GnuCash also one normally used in that locale? I 
should think GnuCash would use that OS setting. (or should)

Regards,
Adrien


> On Sep 9, 2019 w37d252, at 8:24 AM, David Carlson 
>  wrote:
> 
> First, ISO 31-0 was withdrawn on 17 November 2009. It is superseded by ISO
> 8-1 . Other parts of ISO 31
> have also been withdrawn and replaced by parts of ISO 8
> .
> 
> That standard suggests that large numbers with many digits be displayed as
> groups of three separated by a small space instead of dots or commas.  We
> do not have small space characters on our keyboards, so that will be
> difficult to implement.
> 
> I would also argue that in the U.S. average persons will adopt small spaces
> with the same fervor that they have adopted metric measures in general.
> 
> While it would be ok to adopt this convention as an alternate in GnuCash, I
> am strongly against forcing the display  to omit dots or commas as
> thousands separators.
> 
> From Wikipedia " In Unicode , thin
> space is encoded at U+
> 
> 2009   thin space (HTML  *·* ). Unicode's U+
> 
> 202F   narrow no-break space
>  (HTML )
> is a non-breaking
> space  with a width
> similar to that of the thin space."
> 
> That's my 2 ¢.
> 
> On Mon, Sep 9, 2019 at 6:40 AM Fiable.biz via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Hello.
>> I suggest an option for the acceptance by GnuCash of the international
>> notation of numbers, as defined by ISO 31-0 standard and the 22nd General
>> Conference on Weights and Measures, which declared in 2003 that "the symbol
>> for the decimal marker shall be either the point on the line or the comma
>> on the line" and further reaffirmed that "numbers may be divided in groups
>> of three in order to facilitate reading; neither dots nor commas are ever
>> inserted in the spaces between groups".81 235,67 and 81 235.67 have the
>> same meaning and would both be accepted, but 81,235.67 would be refused.
>> Presently space is neither accepted in importing nor in pasting into
>> GnuCash. Moreover, if one has chosen the dot as decimal separator then the
>> coma is refused and vice versa... So I very often have to modify files in
>> LibreOffice before importing them into GnuCash, and to type figures I could
>> just copy and paste.

___
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] appimage

[Dennis Powless]

Is gnucash available via appimage?

D
___
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 3.7 and Reports

[Adrien Monteleone]

> On Sep 9, 2019 w37d252, at 6:02 AM, John Morris  wrote:
> 
> Hi All,
>  I have recently upgraded from Yosemite (macOS 10.10.5) to El Capitan (macOS 
> 10.11.6) and Mojave (macOS 10.14.6) on two different machines. In the 
> process, I have finally taken the leap from GnuCash 2.6.16 into the 3.x 
> series. Until this morning, I was using 3.6 and I am now using 3.7.
> 
>  I’m still testing some functions, but it seems to be working reasonably well 
> overall. Today, I’m writing about aspects of the report system, 
> user-contributed reports and invoices.
> 
> 1. User-contributed reports: Just over a year ago, Doug Doughty contributed 
> several excellent report templates that allowed me to create some very useful 
> reports. I have faithfully moved the contributed files from my old system to 
> my new system, but I am not able to find the reports in the Reports menu. 
> Should they be working? Where should I look for them? It would be a shame to 
> lose all of Doug’s work.

The loading of reports changed between 2.6.x and 3.x. See here: 
https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report

> 
> 2. Invoices: We have been using GnuCash’s invoicing feature to generate 
> invoices for our business. This worked reasonably well for several years in 
> the 2.6.x series. Unfortunately, both GnuCash 3.6 and 3.7 do less well with 
> invoices. The main problem is that the table grid is no longer padded out to 
> fill the page. This means that invoices with relatively short descriptions in 
> the line items look rather ugly with the table taking up only about half of 
> the width of the page and the information that is supposed to be on the right 
> side sitting in the middle of the page. Additionally, the invoice number now 
> prints at the top left, just below the banner, regardless of what I select in 
> the Options dialog. It used to be printed with the invoice details (which I 
> have placed on the right side).
> 
>  Are others experiencing something different from this?

1. My invoices (editing/viewing) all pad to the width of the window no matter 
how I size it, so I’m not sure what you have going on. Maybe try 
double-clicking the description header and see if they don’t snap back to 
normal from then on. (I’m also on Mojave)

2. I don’t have a copy of 2.6.x handy to see what it was doing, but indeed, the 
invoice # prints on the top left. This is because it is the ’title’ of the 
document.

You can fix that in Options > Layout > CSS

add this line:

.invoice-title { float: right; }

and Apply.

Regards,
Adrien


___
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 3.7 and Weekly Reports

[John Morris]

Hi Adrien,
  Thank you for looking into this issue. The transaction report is the main 
issue for me.

Best,
John

> On Sep 9, 2019, at 12:32 PM, Adrien Monteleone 
>  wrote:
> 
> John,
> 
> I was hoping to get to test this as well pre-release, but didn’t get to.
> 
> I can confirm that at least for the Transaction Report, so far, indeed, 
> Saturday is a fixed start day. (My locale is set to Sunday)
> 
> I recall this was one report you were concerned with. Any others?
> 
> 
> Regards,
> Adrien
___
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] Simple Reports

[Rich Shepard]

On Mon, 9 Sep 2019, D wrote:


Not quite. Using your method, open the account, open View->Filter by, set
your dates, then run the account report.

Alternatively, open the generic Transaction report, in options, choose the
account in question, and set the dates.

I prefer option 2, inasmuch as I don't have to remember to clear the
filter from the account after my query, which you have to do in the first
method.


David,

Those approaches look familiar. I was working from memory so I'm not
surprised I was off a bit.

Thanks,

Rich
___
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 3.7 and Weekly Reports

[Adrien Monteleone]

John,

I was hoping to get to test this as well pre-release, but didn’t get to.

I can confirm that at least for the Transaction Report, so far, indeed, 
Saturday is a fixed start day. (My locale is set to Sunday)

I recall this was one report you were concerned with. Any others?


Regards,
Adrien

> On Sep 9, 2019 w37d252, at 5:42 AM, John Morris  wrote:
> 
> Hi All,
>  First, I offer a hearty thank you to the developers for this new version of 
> GnuCash. I really appreciate that my concern about the starting dates for 
> weekly reports garnered someone’s attention.
> 
>  Unfortunately, the weekly reports are still not working correctly for me. In 
> earlier versions (specifically, 2.6.16 and 3.6), all weekly reports started 
> on Sunday regardless of which day I selected for the first day of the week in 
> my locale and regardless of which region I selected. Now, all weekly reports 
> start on Saturday regardless of which day I have selected for the first day 
> of the week in my locale and regardless of which region I have selected. 
> 
>  I’m running GnuCash 3.7+(2019-09-07) under El Capitan (10.11.6) on a 17” 
> 2008 MacBook Pro and under Mojave (10.14.6) on a 15” 2014 MacBook Pro. It 
> seems to be performing essentially identically on both systems.
> 
> 
>  In a related note, the date pickers in the registers now do seem to be 
> working correctly. They seem to start with Monday, the day I have selected as 
> the first day of the week. Thank you for making this fix.
> 
> Best,
> John

___
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] Announcement: GnuCash 3.7 Released

[John Ralls]

Snicker.

Have you ever looked at 
https://github.com/Homebrew/homebrew-cask/blob/master/Casks/gnucash.rb? It just 
downloads Gnucash-Intel-X.Y.dmg from our Github project page. 

As for updating it, you'll have to ask https://github.com/pkryger.

Looking at it did remind me that I should have included in the release notes 
that the dmg no longer has the FinanceQuote Update app because Apple won't 
notarize it. Notarizing is a requirement for installing on Catalina.

Regards,
John Ralls

> On Sep 9, 2019, at 7:57 AM, Larry Beck via gnucash-user 
>  wrote:
> 
> Any ETA for Mac brew files to be updated to 3.7?
> 
> 
> On 9/9/19 10:48 AM, boldstripe wrote:
>> I successfully used these Disco .deb files to install Gnucash 3.7 into Debian
>> Stable (Buster), after first uninstalling previous versions of the three
>> files. 
>> 
>> I followed Stephen's original instructions. Thank you!
>> 
>> 
>> 
>> --
>> 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.
>> 
> 
> ___
> 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] Simple Reports

[D via gnucash-user]

Rich,

Not quite. Using your method, open the account, open View->Filter by, set your 
dates, then run the account report.

Alternatively, open the generic Transaction report, in options, choose the 
account in question, and set the dates. 

I prefer option 2, inasmuch as I don't have to remember to clear the filter 
from the account after my query, which you have to do in the first method.

David

On September 9, 2019, at 8:50 PM, Rich Shepard  wrote:

On Mon, 9 Sep 2019, mrtibbsabq wrote:

> Hi. I have been using GnuCash for awhile now but I cannot see a way to
> tunnel down into the data and generate some simple reports. I would like
> to generate a report between two dates that show only the expenses for a
> specific expense category. That seemed easy to do in MS Money but I am
> stuck with GnuCash. Can someone set me on the right path here? Thanks.

I asked the same question a while ago and learned how to do this.

Using the Accounts tab open the account you want to view.

Isolate the dates by highlighting them.

Then select the Account Report.

If I've mis-remembered the sequence others will put us both back on the
rails.

Rich
___
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] Assign one payment to multiple invoices (from several customers)

[Bat]

Hi,

thank you for your suggestions.

I understand your propositions, though they would involve many more
manual steps (rather than using the [Pay] action on an invoice or
[Process Payment] from Business menu).

And it would not be in the gnucash internal logic, which manage invoice
payments (through lots) at split level (which seems logic and fine).

It is really just a UI difficulty and its a pitty that their is no way
to do it correctly easily.

Thank you anyway, I’m filling a request in bugzilla, and just may hope
that it improves …

驪 ~^v^~ Bat

On 06/09/2019 13:20, Adrien Monteleone wrote:
> There is a ‘better’ way, at least one that doesn’t involve messing with lots.
>
> I’m not sure if anyone has filed an RFE for this use case though. If you 
> don’t see something on Bugzilla, feel free to file it, though it might not be 
> implemented with any haste as this is definitely not a common case. (one 
> business I used to work for did occasionally have this situation a couple of 
> times per year)
>
> I would create a holding asset account to receive the payment initially. 
> (don’t apply it to an invoice yet)
>
> Then pay the various invoices from that holding account. You’ll have to apply 
> payments for each customer separately. (but can select multiple invoices for 
> any one customer at a time as before)
>
> You can use the same NUM if you like for all transactions so their references 
> match.
>
> An example account might be a sub-account of AR, 'Assets:Current 
> Assets:Accounts Receivable:Payments Pending’, but don’t make it as “type” 
> ‘AR’ make sure it is just of type “Asset”.
>
> Let’s say CustomerA made a payment of 1000.00 with 800.00 being for two of 
> their own invoices and 200.00 being for CustomerB
>
> The initial receipt would look like this:
>
> Dr. Assets:Current Assets:Checking/Cash/Undeposited Funds 1000.00
>   Cr. Assets:Current Assets:Accounts Receivable:Payments Pending  
> 1000.00
>
> Then after you apply CustomerA’s portion to their two invoices:
>
> Dr. Assets:Current Assets:Accounts Receivable:Payments Pending
> 800.00
>   Cr. Assets:Current Assets:Accounts Receivable   
> 800.00
>
> And after you apply the remaining amount to CustomerB’s invoice(s):
>
> Dr. Assets:Current Assets:Accounts Receivable:Payments Pending
> 200.00
>   Cr. Assets:Current Assets:Accounts Receivable   
> 200.00
>
> -
>
> There might be other ways which involve applying the entire payment to 
> CustomerA’s account (leaving the balance as an ‘overpayment/pre-payment’) 
> then ‘refunding’ the difference to some holding account, then applying it to 
> CustomerB but those would involve more steps.
>
> In any case, I’d model the real-world movement of funds as best as possible. 
> (this latter case might be what you need to do if a customer decided months 
> later to apply a credit from over/pre-payment to say, the balance for a 
> friend, child, etc.
>
> But you should be able to accomplish this modeling without resorting to 
> editing lots. The only time I edit lots is if through unposting and reposting 
> bills/invoices, GnuCash doesn’t re-apply my various payments properly.
>
> Finally, I’d be sure to use all needed fields at my disposal to document what 
> was going on so I could see at a glance that the various AR payments were 
> really a single receipt, or involved credit applied from one Customer to 
> another. You have the NUM field, Action field (which can be anything you 
> like, though single words are probably best), Notes field (only visible in 
> Double Line Mode), and the Memo field for each split.
>
> Regards,
> Adrien
>
>
>> On Sep 5, 2019 w36d248, at 10:07 AM, Bat  
>> wrote:
>>
>> Hi
>>
>> this is a subject that appears regularly on the mailing list, but I can not 
>> find fine answer neither plan to improve the situation.
>>
>> Some of my customers often pay for their invoices plus for the one of other 
>> customer. So I get one payment (with one reference) to split to multiple 
>> invoices.
>>
>> The distribution of one payment to several invoices is natural through 
>> business features if the invoices are for the same customer. But not if the 
>> invoices belong to several customers.
>>
>> So today, I record the payment on the customer’s invoice, go into the AR 
>> account and verify the splits of the transaction, go into Action -> Lots to 
>> manually remove the other split from the customer payment lot and assign it 
>> to the other customer invoice lot.
>>
>> Is – there a better way to do that ?
>>
>> Is – there a plan to allow selecting several customers invoices in manage a 
>> payment GUI ?
>>
>> Thanks
>>
>> -- 
>> 驪 ~^v^~ Bat
> ___
> 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 

Re: [GNC] Simple Reports

[Rich Shepard]

On Mon, 9 Sep 2019, mrtibbsabq wrote:


Hi. I have been using GnuCash for awhile now but I cannot see a way to
tunnel down into the data and generate some simple reports. I would like
to generate a report between two dates that show only the expenses for a
specific expense category. That seemed easy to do in MS Money but I am
stuck with GnuCash. Can someone set me on the right path here? Thanks.


I asked the same question a while ago and learned how to do this.

Using the Accounts tab open the account you want to view.

Isolate the dates by highlighting them.

Then select the Account Report.

If I've mis-remembered the sequence others will put us both back on the
rails.

Rich
___
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] Announcement: GnuCash 3.7 Released

[Larry Beck via gnucash-user]

Any ETA for Mac brew files to be updated to 3.7?


On 9/9/19 10:48 AM, boldstripe wrote:
> I successfully used these Disco .deb files to install Gnucash 3.7 into Debian
> Stable (Buster), after first uninstalling previous versions of the three
> files. 
> 
> I followed Stephen's original instructions. Thank you!
> 
> 
> 
> --
> 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.
> 



signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Announcement: GnuCash 3.7 Released

[boldstripe]

I successfully used these Disco .deb files to install Gnucash 3.7 into Debian
Stable (Buster), after first uninstalling previous versions of the three
files. 

I followed Stephen's original instructions. Thank you!



--
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] Simple Reports

[mrtibbsabq]

Hi. I have been using GnuCash for awhile now but I cannot see a way to tunnel
down into the data and generate some simple reports. I would like to
generate a report between two dates that show only the expenses for a
specific expense category. That seemed easy to do in MS Money but I am stuck
with GnuCash. Can someone set me on the right path here? Thanks.



--
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.

Re: [GNC] ISO 31-0 number writing

[David Carlson]

First, ISO 31-0 was withdrawn on 17 November 2009. It is superseded by ISO
8-1 . Other parts of ISO 31
have also been withdrawn and replaced by parts of ISO 8
.

That standard suggests that large numbers with many digits be displayed as
groups of three separated by a small space instead of dots or commas.  We
do not have small space characters on our keyboards, so that will be
difficult to implement.

I would also argue that in the U.S. average persons will adopt small spaces
with the same fervor that they have adopted metric measures in general.

While it would be ok to adopt this convention as an alternate in GnuCash, I
am strongly against forcing the display  to omit dots or commas as
thousands separators.

From Wikipedia " In Unicode , thin
space is encoded at U+

2009   thin space (HTML  *·* ). Unicode's U+

202F   narrow no-break space
 (HTML )
is a non-breaking
space  with a width
similar to that of the thin space."

That's my 2 ¢.

On Mon, Sep 9, 2019 at 6:40 AM Fiable.biz via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello.
> I suggest an option for the acceptance by GnuCash of the international
> notation of numbers, as defined by ISO 31-0 standard and the 22nd General
> Conference on Weights and Measures, which declared in 2003 that "the symbol
> for the decimal marker shall be either the point on the line or the comma
> on the line" and further reaffirmed that "numbers may be divided in groups
> of three in order to facilitate reading; neither dots nor commas are ever
> inserted in the spaces between groups".81 235,67 and 81 235.67 have the
> same meaning and would both be accepted, but 81,235.67 would be refused.
> Presently space is neither accepted in importing nor in pasting into
> GnuCash. Moreover, if one has chosen the dot as decimal separator then the
> coma is refused and vice versa... So I very often have to modify files in
> LibreOffice before importing them into GnuCash, and to type figures I could
> just copy and paste.
> ___
> 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.

[GNC] ISO 31-0 number writing

[Fiable.biz via gnucash-user]

Hello.
I suggest an option for the acceptance by GnuCash of the international notation 
of numbers, as defined by ISO 31-0 standard and the 22nd General Conference on 
Weights and Measures, which declared in 2003 that "the symbol for the decimal 
marker shall be either the point on the line or the comma on the line" and 
further reaffirmed that "numbers may be divided in groups of three in order to 
facilitate reading; neither dots nor commas are ever inserted in the spaces 
between groups".81 235,67 and 81 235.67 have the same meaning and would both be 
accepted, but 81,235.67 would be refused.   Presently space is neither accepted 
in importing nor in pasting into GnuCash. Moreover, if one has chosen the dot 
as decimal separator then the coma is refused and vice versa... So I very often 
have to modify files in LibreOffice before importing them into GnuCash, and to 
type figures I could just copy and paste.
___
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 3.7 and Reports

[John Morris]

Hi All,
  I have recently upgraded from Yosemite (macOS 10.10.5) to El Capitan (macOS 
10.11.6) and Mojave (macOS 10.14.6) on two different machines. In the process, 
I have finally taken the leap from GnuCash 2.6.16 into the 3.x series. Until 
this morning, I was using 3.6 and I am now using 3.7.

  I’m still testing some functions, but it seems to be working reasonably well 
overall. Today, I’m writing about aspects of the report system, 
user-contributed reports and invoices.

1. User-contributed reports: Just over a year ago, Doug Doughty contributed 
several excellent report templates that allowed me to create some very useful 
reports. I have faithfully moved the contributed files from my old system to my 
new system, but I am not able to find the reports in the Reports menu. Should 
they be working? Where should I look for them? It would be a shame to lose all 
of Doug’s work.

2. Invoices: We have been using GnuCash’s invoicing feature to generate 
invoices for our business. This worked reasonably well for several years in the 
2.6.x series. Unfortunately, both GnuCash 3.6 and 3.7 do less well with 
invoices. The main problem is that the table grid is no longer padded out to 
fill the page. This means that invoices with relatively short descriptions in 
the line items look rather ugly with the table taking up only about half of the 
width of the page and the information that is supposed to be on the right side 
sitting in the middle of the page. Additionally, the invoice number now prints 
at the top left, just below the banner, regardless of what I select in the 
Options dialog. It used to be printed with the invoice details (which I have 
placed on the right side).

  Are others experiencing something different from this?

Best,
John

___
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 3.7 and Weekly Reports

[John Morris]

Hi All,
  First, I offer a hearty thank you to the developers for this new version of 
GnuCash. I really appreciate that my concern about the starting dates for 
weekly reports garnered someone’s attention.

  Unfortunately, the weekly reports are still not working correctly for me. In 
earlier versions (specifically, 2.6.16 and 3.6), all weekly reports started on 
Sunday regardless of which day I selected for the first day of the week in my 
locale and regardless of which region I selected. Now, all weekly reports start 
on Saturday regardless of which day I have selected for the first day of the 
week in my locale and regardless of which region I have selected. 

  I’m running GnuCash 3.7+(2019-09-07) under El Capitan (10.11.6) on a 17” 2008 
MacBook Pro and under Mojave (10.14.6) on a 15” 2014 MacBook Pro. It seems to 
be performing essentially identically on both systems.


  In a related note, the date pickers in the registers now do seem to be 
working correctly. They seem to start with Monday, the day I have selected as 
the first day of the week. Thank you for making this fix.

Best,
John

___
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] Version 3.7 on macOS 10.14.6

[pete hopkins]

And worked for me to John.  Apologies for wasting everyone’s time and thank you 
for the quick response.


Regards

peter hopkins





On 9 Sep 2019, at 11:20, John Morris 
mailto:johnj...@editide.us>> wrote:

Hi Peter,
 I had the same results the first time I launched GnuCash 3.7. However, when I 
clicked it a second time in the Dock, it seemed to launch normally. I have not 
tested much, but it seems to be working.

 I’m running GnuCash 3.7+(2019-09-07) under El Capitan (10.11.6) on a 17” 2008 
MacBook Pro and under Mojave (10.14.6) on a 15” 2014 MacBook Pro. It seems to 
be performing essentially identically on both systems.

Best,
John

On Sep 9, 2019, at 5:26 AM, pete hopkins 
mailto:pete.hopkins...@outlook.com>> wrote:

I have just upgraded to the latest stable release on macOS and the application 
will no longer open.  It asks the standard security question about opening an 
application that is not from the App Store but that is the last thing that 
happens.  Anyone else suffering this or do I need to revert to version 3.6?
___
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] Version 3.7 on macOS 10.14.6

[John Morris]

Hi Peter,
  I had the same results the first time I launched GnuCash 3.7. However, when I 
clicked it a second time in the Dock, it seemed to launch normally. I have not 
tested much, but it seems to be working.

  I’m running GnuCash 3.7+(2019-09-07) under El Capitan (10.11.6) on a 17” 2008 
MacBook Pro and under Mojave (10.14.6) on a 15” 2014 MacBook Pro. It seems to 
be performing essentially identically on both systems.

Best,
John

> On Sep 9, 2019, at 5:26 AM, pete hopkins  wrote:
> 
> I have just upgraded to the latest stable release on macOS and the 
> application will no longer open.  It asks the standard security question 
> about opening an application that is not from the App Store but that is the 
> last thing that happens.  Anyone else suffering this or do I need to revert 
> to version 3.6?
___
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] Version 3.7 on macOS 10.14.6

[pete hopkins]

I have just upgraded to the latest stable release on macOS and the application 
will no longer open.  It asks the standard security question about opening an 
application that is not from the App Store but that is the last thing that 
happens.  Anyone else suffering this or do I need to revert to version 3.6?






___
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] Upgrade Process

[Derek Atkins]

HI,

On Mon, September 9, 2019 4:24 am, Charles Peter Avery wrote:
> Hello,
>
> I am using Ver 3.5 and looking to upgrade to Ver 3.7.  Would you be able
> to
> point me to the documentation for the upgrade process please?

You don't say what OS/Distro you are using.  But to get from 3.5 to 3.7
just upgrade the software.  There is no need to do anything else; your
data will just migrate to the new version.

> Regards
> Charles Avery

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Upgrade Process

[Charles Peter Avery]

Hello,
 
I am using Ver 3.5 and looking to upgrade to Ver 3.7.  Would you be able to
point me to the documentation for the upgrade process please?
 
Regards
Charles Avery
___
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.