Re: [GNC] Where is my opening balance?

[Adrien Monteleone]

It’s just a convenience. You can always enter a manual transaction between your 
chosen account and Equity:Opening Balances.

Regards,
Adrien

> On Apr 4, 2019, at 12:03 AM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> Hi All,
> 
> I have noticed that when I create a new account, if I
> forget to enter something in opening balance, that
> editing the account afterwards does not give me access
> to enter an opening balance.
> 
> Bug?  Of is it just somewhere I have not looked?  Very
> frustrating!
> 
> Many thanks,
> -T


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Where is my opening balance?

[ToddAndMargo via gnucash-user]

Hi All,

I have noticed that when I create a new account, if I
forget to enter something in opening balance, that
editing the account afterwards does not give me access
to enter an opening balance.

Bug?  Of is it just somewhere I have not looked?  Very
frustrating!

Many thanks,
-T

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Version 3.5

[Pandem]

I forgot to add that there has been previous messages on this subject from
GTI. The subject was ' [GNC] Change text color'.
GTI provided instructions on how to correct the issue and an example file
gtk-3.0.css.

I have used both the instructions and his file in my set up. I would suggest
that you change only ONE thing at a time and watch out for your syntax
errors. 

Good luck

pandem



--
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] Keeping two sets of books

[Stuart McGraw]

JFTR, the OP was using Mysql, I am using Postgresql.

I use many other Postgresql tools and have code (mine and third-party) that
accesses my databases (including the Gnucash ones) and have never had anything
make a peep about keyrings, only Gnucash.  Google Chrome, although it has
nothing to do with Postgresql, also generates the same kind of keyring prompts
(but I don't use it so I don't care).  I agree there is probably something
messed up on my system regarding the keyring and login, but I don't see that
Postgresql (and analogously Mysql) themselves care.  Which leaves Gnucash and
libdbi as the prime suspects.

Since, to me, the annoyance is less than the time it would probably take
to research/fix it, I will wait until I serendipitously encounter some post
from someone with the same problem who has fixed it.  Or until I upgrade
someday and the problem magically disappears. :-)

On 4/3/19 2:28 AM, Colin Law wrote:

I think Adrien is correct, mysql needs access to the keyring in order
to check user access permissions, though if you logon to the PC
manually, entering your password, then I would not have expected it to
have to ask again, and it certainly should not happen each time you
run gnucash.  I think it is most likely an issue with your system and
mysql though, not a GnuCash issue.

Colin

On Tue, 2 Apr 2019 at 23:08, Stuart McGraw  wrote:


It opens without the popup.  Which I suppose implies that the keyring checking 
is occurring in gnucash code conditionally for database access, or in whatever 
api gnucash uses for database access (libdbi?), or possibly in 
database-specific api libdbi uses (eg libpq(?) for Postgresql).  I don't think 
it's the latter since I've not noticed anything about it in the libpq docs but 
I could have easily missed something.

On 4/2/19 3:09 PM, Colin Law wrote:

If, as an experiment, you start a new accounts file and save it as
xml, then shutdown and restart gnucash, which should then open the xml
file, do you get the popup?

Colin

On Tue, 2 Apr 2019 at 18:21, Stuart McGraw  wrote:


No auto-login here and I think the app that needs an option to ignore the 
keyring check entirely is Gnucash (not the database which isn't an app).  As 
for creating a different default keyring, I'll look into that sometime (so 
thanks for the direction to look!) but right now, clicking the Cancel button is 
the easiest way out.  As annoyances go it is nowhere near as bad as those 
caused by Gnome/GTK but that's a subject for a different list. :-)


There are multiple reasons for that pop-up and a solution for each. One 
involves disabling automatic login to the desktop. (if you use it) You can also 
create a different ‘default’ keyring and set it to non-protected. (so it is 
visible to anyone—not wise unless you store nothing in it.) Some apps also let 
you tell them to ignore the keyring check entirely. (Chrome is one such app, 
not sure about MySQL)

Regards,
Adrien


On Mar 31, 2019, at 8:23 PM, Stuart McGraw  wrote:


I do have a long persisting problem where I am asked every time for a password for my 
keyring (something I've never used, set up, or want) but since clicking 
"Cancel" results in gnucash opening fine I've never bothered to try to fix it.  
(I'm running gnucash on Ubuntu linux.)



___
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] AR Asset differen t GL codes

[David Cousens]

Teresa,

The business features in GnuCash do not support multiple A/R accounts. There
is only a single A/R account in GnuCash. I also tried doing this several
years ago and discovered that while you could create A/R subaccounts, the
business features did not function with any sub accounts by design. 

It is not really necessary to have more than one A/R account as all the
invoices are linked to a specified customer and bills to a specified vendor,
so you can use filtering on the customer to select customer specific
information when you need it and remove that filtering when you don't in the
relevant reports and you an customize the reports to your needs. The same
applies to dealing with accounts payable and bills.  If you require
information that a particular product is responsible for outstanding debts
then this cannot be obtained directly.

The  detail of information on your IT products and their profiability will
be obtainable from the the structure of your Income and Expense accounts,
not from the asset accounts and A/R and A/P.

David Cousens

Hope this helps to clarify the situation



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing AR invoices

[Adrien Monteleone]

If you’re doing manual entries (or importing the invoices as regular 
transactions instead of as invoices) you determine the accounts posted to so 
assign the splits as you wish, manually after the import or adding that info to 
the CSV.

I’d recommend going to the View menu and switching to Transaction Journal mode. 
(and optionally turn on Double Line mode as well which displays a ’note’ field 
for the entire transaction so you aren’t limited to only the memos fields on 
the splits)

This will always show all split information so you can see all debits and 
credits for each transaction. It helps to be able to follow exactly which 
accounts are involved.

Note, how you have this setup here and how this would work with manual entries 
(typed in or imported) is that the A/R sub-accounts will show $0 if all 
invoices have been collected on. They won’t show you how much has been paid, 
but how much is still owed. (if anything)

The signs of the figures you show in this screenshot are backwards for the A/R 
accounts. This looks like the company owes that money to someone, not that 
someone else owes the company. A/R is an asset because it is revenue earned, 
but not yet collected. Once collected it is accounted for in whatever account 
it was paid into. (Cash, Checking, etc.)

If you have outstanding invoices you haven’t collected on, A/R should be 
positive. If someone pre-paid or overpaid, that would be a credit to A/R.

Textbook invoice transaction:

Dr. Assets:Accounts Receivable
Cr. Income:Sales

It looks like you have the preference for Reversed Balance Accounts set to 
’None’ and this is your transaction entry:

Dr. Income:Sales
Cr. Assets:Accounts Receivable

—which is backwards.

Regards,
Adrien

> On Apr 2, 2019, at 11:06 AM, Teresa  wrote:
> 
> What we do is sell IT preventative maintenance for Hotels. I have GL accounts 
> set up for each item we sell, total of 5.
> 
> what I need to be able to do is import in Assets, how much to apply to each 
> gl account, I also have gl accounts set up under income for paid
> 
> Should I skip doing it as an import and just add lines and amounts under each 
> sold account. If I do this will the system create a credit entry under the 
> corresponding paid account?
> 
> Sold GL accounts are 401-9182 through 401-9185
> 
> Paid accounts are 400-9182 through 400-9185
> 
> 
> 
> 
> 
> On 4/1/2019 10:47 PM, Adrien Monteleone wrote:
>> Teresa,
>> 
>> I forgot to mention, GnuCash has no facility to store ‘products’ or ’service 
>> offerings’ or any kind of ‘inventory’. You just create your own invoice line 
>> items each time. But the software does utilize auto-fill based on previous 
>> entries. So you can start typing a line item description and it will fill in 
>> the rest based on a previous entry as well as other line item info like 
>> income account, discounts, quantity, pricing, tax etc.
>> 
>> If the invoices are exact (or even near) duplicates, you can use the 
>> Duplicate Invoice button as a starting point and edit accordingly.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Apr 1, 2019, at 10:55 AM, Teresa 
>>>  wrote:
>>> 
>>>  we invoice up to 75 recurring invoices monthly, that include one of 5 IT 
>>> products that are loaded in GNUCash.
>>> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AR Asset differen t GL codes

[Adrien Monteleone]

Understood.

The invoice feature of GnuCash is only going to be able to post to a single A/R 
account per invoice. (I can’t even find textbook examples of doing it any other 
way) I don’t see how that’s going to work even if you create custom ‘other A/R’ 
like you have here. If you bill more than one service on any one invoice you 
won’t be able to post them to separate A/R accounts unless you just do manual 
entries. If you bill one service per invoice than you’re good to go.

You could import your invoices as regular transactions instead of importing 
them as invoices. That would allow you to create the split A/R entries, but if 
that data isn’t included in the import CSV, you’ll have to make that all up 
manually for each invoice, as you go. (and of course lose all customer tracking 
benefits of the business features)

I think the better approach might be to try to craft a report to show this 
info, but let GnuCash post to the single A/R account. You can do sane 
accounting and keep the boss happy.

Either using Scheme to run the report from within GnuCash, or switching to one 
of the SQL backends and grabbing the data from the outside are your choices. 
(Scheme is tough, I’d opt for SQL) The easiest path would be to use the SQLite3 
backend. MySQL and PostgreSQL are a much more involved setup. SQlite is used by 
simply saving the file in that format. (and you get instant saves as a bonus)

I’d have the report query all unpaid invoices, adding the amounts for each 
service on the invoice as you step through them. (there certainly might be more 
efficient methods, but this is the basic idea)

I’d have to ask though, what happens now if a client doesn’t pay in full? How 
do you allocate the partial payment across the various services invoiced? (or 
do you send separate invoices for each service?) If you invoice multiple 
services to the same client on the same invoice, that could get messy to figure 
out real quick. At best, you’d have to opt for a simple proportional allocation 
as an estimation.

Maybe someone else here will chime in with some ideas, but I think relying on a 
custom report for that ‘paid’ info is the best route.

If you go the SQLite3 route, look into PieCash which can help with crafting the 
report you need.

Regards,
Adrien

p.s.—please don’t forget to copy the list on all replies - others will benefit 
from the discussion and might be able to offer more (or better) assistance.



> On Apr 3, 2019, at 11:07 AM, Teresa  wrote:
> 
> The reason I want to, I just started on this business. It's 5 years old, the 
> CEO was tracking everything in excel, and wants to continues to track each 
> item, on both the sold to and paid side..I'm trying to accommodate..
> 
> On 4/3/2019 12:03 PM, Adrien Monteleone wrote:
>> Not sure why you’d want to do that. If you’re using separate income accounts 
>> to track your sales, that should be sufficient. (I also offer IT services 
>> and have separate revenue accounts for each one)
>> 
>> A/R is just one big pile. It shouldn't need to be separated. GnuCash does 
>> track however who owes you what and for which invoices. You can see that by 
>> running a customer report and/or a receivables aging report. I suppose if 
>> you really need to see that you’re still owed $x for a particular service 
>> offered, you can either make up a report to do so, or if you are using one 
>> of the SQL backends, you can query the db for the info from A/R and the 
>> invoices. Sounds like a lot of work for little actionable information.
>> 
>> Did a CPA counsel to have separate A/R accounts by revenue stream? Some 
>> software (like for banks) keep separate accounts per customer, but I’ve 
>> never heard of separate A/R accounts per revenue source. You could pull it 
>> off, but you’d have to by-pass the business features entirely and make *all* 
>> of your entries manually.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Apr 3, 2019, at 10:36 AM, Teresa 
>>>  wrote:
>>> 
>>> Are business does not have any products, we're an IT company the sells 
>>> services
>>> 
>>> Under assets and income I have 5 different products, I see when preparing 
>>> an invoice I can choose the income gl#, how can I assign the AR side to a 
>>> specific corresponding GL account#?
>>> 
>>> -- 
>>> 
>>> Teresa Slack

___
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] AR Asset differen t GL codes

[Adrien Monteleone]

Not sure why you’d want to do that. If you’re using separate income accounts to 
track your sales, that should be sufficient. (I also offer IT services and have 
separate revenue accounts for each one)

A/R is just one big pile. It shouldn't need to be separated. GnuCash does track 
however who owes you what and for which invoices. You can see that by running a 
customer report and/or a receivables aging report. I suppose if you really need 
to see that you’re still owed $x for a particular service offered, you can 
either make up a report to do so, or if you are using one of the SQL backends, 
you can query the db for the info from A/R and the invoices. Sounds like a lot 
of work for little actionable information.

Did a CPA counsel to have separate A/R accounts by revenue stream? Some 
software (like for banks) keep separate accounts per customer, but I’ve never 
heard of separate A/R accounts per revenue source. You could pull it off, but 
you’d have to by-pass the business features entirely and make *all* of your 
entries manually.

Regards,
Adrien

> On Apr 3, 2019, at 10:36 AM, Teresa  wrote:
> 
> Are business does not have any products, we're an IT company the sells 
> services
> 
> Under assets and income I have 5 different products, I see when preparing an 
> invoice I can choose the income gl#, how can I assign the AR side to a 
> specific corresponding GL account#?
> 
> -- 
> 
> Teresa Slack

___
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] Mac OS Mojave

[Adrien Monteleone]

I’m using it just fine right now, so it isn’t a general compatibility problem 
with Mojave.

Can you describe more what the problem is?

Do you get any error messages? Does it crash?

Does it open the data file at all?

If it doesn’t automatically open your last used file, what happens when you 
navigate to File > Open and choose your data file?

Regards,
Adrien


> On Apr 3, 2019, at 10:29 AM, Ian Lovatt via gnucash-user 
>  wrote:
> 
> Hi, have just installed OS Mojave on my MacBook Pro and can no longer access 
> my GnuCash records. Any idea’s what I can do to make GnuCash compatible with 
> the new OS please?
> 
> Ian Lovatt
> ___
> 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] Fonts

[Adrien Monteleone]

Check the FAQ on the wiki. There is a set of linked pages there detailing how 
to set your own style sheet to change colors, fonts, padding, etc.

If you want the same font across the entire UI, you’ll want to use the * 
selector.

Regards,
Adrien

> On Apr 3, 2019, at 7:10 AM, Gareth Davies via gnucash-user 
>  wrote:
> 
> Using V3.5 on Windows 10 
> 
> 
> 
> Hi,  
> 
> 
> 
> Since upgrading to V3.5 today I have noticed that all the fonts in the
> program have changed to a very thin one which doesn't stand out as on the
> previous version.
> 
> 
> 
> How can I change the default text font to one which is bolder and easier to
> read.
> 
> 
> 
> Many thanks,
> 
> Gareth

___
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] AR Asset differen t GL codes

[Teresa]

Are business does not have any products, we're an IT company the sells 
services


Under assets and income I have 5 different products, I see when 
preparing an invoice I can choose the income gl#, how can I assign the 
AR side to a specific corresponding GL account#?


--

Teresa Slack

Senior Client Manager

*_Coba Enterprise Management, LLC_*

3620 Pelham Road, PMB 107

Greenville, SC 29615

Office: 864.343.8017 x 5

Cell:    864.525.3633

ter...@coba-em.com 
Coba-EM.com 

/NOTICE TO RECIPIENTS: The information contained in and accompanying 
this communication may be confidential, subject to legal privilege, or 
otherwise protected from disclosure, and is intended solely for the use 
of the intended recipient(s). If you are not the intended recipient of 
this communication, please delete and destroy all copies in your 
possession, notify sender that you have received this communication in 
error, and note that any review or dissemination of, or the taking of 
any action in reliance on, this communication is expressly prohibited. 
Email messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, deleted 
or interfered with without the knowledge of the sender or the intended 
recipient. Coba Enterprise Management, LLC makes no warranties in 
relation to these matters. Please note that Coba Enterprise Management, 
LLC reserves the right to intercept, monitor, and retain email messages 
to and from its systems as permitted by applicable law. If you are not 
comfortable with the risks associated with e-mail messages, you may 
decide not to use email to communicate with Coba Enterprise Management, 
LLC. /


___
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] Mac OS Mojave

[Ian Lovatt via gnucash-user]

Hi, have just installed OS Mojave on my MacBook Pro and can no longer access my 
GnuCash records. Any idea’s what I can do to make GnuCash compatible with the 
new OS please?

Ian Lovatt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Version 3.5

[Pandem]

My eyes are old too.  There is a solution however and I wish that just once a
new version would do this and cause the formatting to change. . Use the
following URL and follow the instructions

https://wiki.gnucash.org/wiki/GTK3#Manual_Styling_using_CSS_file.

I added this to the file and then saved the gtk-3.0.css file

/* Font Size in Documents */
* {
  font: 10pt arial, sans-serif;
}
pandem



--
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] Fonts

[Gareth Davies via gnucash-user]

Using V3.5 on Windows 10 

 

Hi,  

 

Since upgrading to V3.5 today I have noticed that all the fonts in the
program have changed to a very thin one which doesn't stand out as on the
previous version.

 

How can I change the default text font to one which is bolder and easier to
read.

 

Many thanks,

Gareth

 

 

 

___
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] Keeping two sets of books

[Colin Law]

I think Adrien is correct, mysql needs access to the keyring in order
to check user access permissions, though if you logon to the PC
manually, entering your password, then I would not have expected it to
have to ask again, and it certainly should not happen each time you
run gnucash.  I think it is most likely an issue with your system and
mysql though, not a GnuCash issue.

Colin

On Tue, 2 Apr 2019 at 23:08, Stuart McGraw  wrote:
>
> It opens without the popup.  Which I suppose implies that the keyring 
> checking is occurring in gnucash code conditionally for database access, or 
> in whatever api gnucash uses for database access (libdbi?), or possibly in 
> database-specific api libdbi uses (eg libpq(?) for Postgresql).  I don't 
> think it's the latter since I've not noticed anything about it in the libpq 
> docs but I could have easily missed something.
>
> On 4/2/19 3:09 PM, Colin Law wrote:
> > If, as an experiment, you start a new accounts file and save it as
> > xml, then shutdown and restart gnucash, which should then open the xml
> > file, do you get the popup?
> >
> > Colin
> >
> > On Tue, 2 Apr 2019 at 18:21, Stuart McGraw  wrote:
> >>
> >> No auto-login here and I think the app that needs an option to ignore the 
> >> keyring check entirely is Gnucash (not the database which isn't an app).  
> >> As for creating a different default keyring, I'll look into that sometime 
> >> (so thanks for the direction to look!) but right now, clicking the Cancel 
> >> button is the easiest way out.  As annoyances go it is nowhere near as bad 
> >> as those caused by Gnome/GTK but that's a subject for a different list. :-)
> >>
> >>> There are multiple reasons for that pop-up and a solution for each. One 
> >>> involves disabling automatic login to the desktop. (if you use it) You 
> >>> can also create a different ‘default’ keyring and set it to 
> >>> non-protected. (so it is visible to anyone—not wise unless you store 
> >>> nothing in it.) Some apps also let you tell them to ignore the keyring 
> >>> check entirely. (Chrome is one such app, not sure about MySQL)
> >>>
> >>> Regards,
> >>> Adrien
> >>>
>  On Mar 31, 2019, at 8:23 PM, Stuart McGraw  wrote:
> 
> 
>  I do have a long persisting problem where I am asked every time for a 
>  password for my keyring (something I've never used, set up, or want) but 
>  since clicking "Cancel" results in gnucash opening fine I've never 
>  bothered to try to fix it.  (I'm running gnucash on Ubuntu linux.)
>
___
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] How to change the currency in the summary bar

[Stefan Ivanovski]

Hi Christopher,

Thank you very much for the steps. I appreciate it.
That's very helpful.

Regards,
Stefan

On Tue, Apr 2, 2019 at 3:49 PM Christopher Lam 
wrote:

> We prefer https://wiki.gnucash.org/wiki/Mailing_Lists#Netiquette here
>
> To change root currency:
> 1. backup datafile
> 2. rename datafile.gnucash to datafile.gnucash.gz then gunzip using a
> reputable tool such as 7-zip
> 3. open using a reputable text editor such as Notepad++. find the root
> currency labelled ROOT
> 4. locate the associated currency e.g.
>   
> CURRENCY
> EUR
>   
> 5. change the  at leisure.
> 6. save, restart.
>
> Beware, there will be unknown side effects.
>
> On Tue, 2 Apr 2019 at 06:26, Stefan Ivanovski <
> stefan.ivanov...@bucknell.edu> wrote:
>
>> Dear Christopher,
>>
>> Thank you for the prompt reply.
>> I am not sure how to change the data file. I am not very experienced with
>> coding and programming.
>>
>> Do you have some link you can point me to how to follow along?
>>
>> Regards,
>> Stefan
>>
>> On Thu, Mar 28, 2019 at 10:44 AM Christopher Lam <
>> christopher@gmail.com> wrote:
>>
>>> There's no ui for modifying the summary bar currency unfortunately. It
>>> is set when you create your book.
>>>
>>> To modify afterwards you'll need to modify the data file and change the
>>> currency for the (invisible) root account.
>>>
>>> A book property option *could* be implemented; I doubt that it will have
>>> side effects elsewhere, but I'm not sure.
>>>
>>> On Thu., 28 Mar. 2019, 15:14 Stefan Ivanovski, <
>>> stefan.ivanov...@bucknell.edu> wrote:
>>>
 Hi GNU Cash enthusiasts,

 I've been using this software for personal financing and it's great for
 what I want to do. It does a great job managing multiple currencies.

 However, recently I wanted to change the currency of the "Grand Total"
 in
 the summary bar, but I could not find anywhere the option under Edit >
 Preference.

 I would like to change the currency from Macedonian Denars to Euros in
 the
 "Grand Total" only.

 I am using version 3.4 for Windows and I've changed the global settings
 to
 EUR, but nothing works.

 Anyone that could assist me on this? I would very much appreciate your
 help.

 Regards,
 Stefan

 [image: Screenshot_1.png]

 [image: image.png]
 [image: image.png]

 --
 *Stefan Ivanovski*
 ___
 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.

>>>
>>
>> --
>> *Stefan Ivanovski*
>>
>>
>> *Master of City Planning, Class of 2015University of Pennsylvania, School
>> of Design*
>> *International Relations and Spanish*
>> *Bucknell University, Class of 2012*
>>
>> *​LinkedIn: www.linkedin.com/in/stefanivanovski
>> *
>> *Overture: **Personal video introduction
>> *
>>
>

-- 
*Stefan Ivanovski*


*Master of City Planning, Class of 2015University of Pennsylvania, School
of Design*
*International Relations and Spanish*
*Bucknell University, Class of 2012*

*​LinkedIn: www.linkedin.com/in/stefanivanovski
*
*Overture: **Personal video introduction
*
___
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.