Re: [GNC] How should I enter values on a budget in gnucash ?

2019-10-21 Thread Christopher Lam
Thanks, I think a reasonable approach to determine a budget's sign-reversal policy will be: - if budgeted expense amounts are mostly negative, conclude "reversal = income/expense" - otherwise, if budgeted liability amounts are mostly negative, conclude "reversal = none" - otherwise conclude "revers

Re: [GNC] AqBanking help for Citi CC (cont'd again)

2019-10-21 Thread xngin
Greetings everyone, I'm happy to report a working Citi CC OFX Direct Connect through AqBanking. It took quite a bit of tinkering to figure out. For a while I was stuck on the fact that had to be a UUID4, which AqBanking cannot produce, but it seems that Citi changed something and now it works as

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread David H
Awesome thanks John, I'm relatively new to the Mac and MacOS so still learning, learning, learning :-) Cheers Dave. On Tue, 22 Oct 2019 at 12:32, John Ralls wrote: > > Dave, > > Showing the extensions (e.g. the .txt in foo.txt) is a preference in > Finder's preferences on the Advanced tab. > >

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread John Ralls
Dave, Showing the extensions (e.g. the .txt in foo.txt) is a preference in Finder's preferences on the Advanced tab. You don't need to double click a text file to read it, you can just select it and tap the space bar. That actually works for a surprising variety of file types, not just text.

Re: [GNC] register column sizes

2019-10-21 Thread James Gill via gnucash-user
That sure would have helped me. Of course it would have also helped me if I had read the instructions before I started messing about. lol Jim Gill -- jimvg...@yahoo.com blog: http://searchinforkinfolk.blogspot.com web: http://www.jimgill.net On Monday, October 21, 2019, 9:23:10 PM EDT, D

Re: [GNC] register column sizes

2019-10-21 Thread D via gnucash-user
Well, then you couldn't hide columns. David On October 22, 2019, at 5:01 AM, David Carlson wrote: Jim, Glad that you solved your problem. Others, I think that the current release behaves exactly the same way. Would it be worth while to propose an enhancement to have some minimum column widt

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread D via gnucash-user
Installation is covered in the wiki, and linked directly on www.gnucash.org on the navigation menu (4th item under "Information")--"Installation". David On October 22, 2019, at 3:48 AM, David H wrote: I copy everything to Applications/GnuCash and run it from there, you can't run it from the dm

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread David H
Thanks John so they are but I think I'll just keep copying them over with the app as it's a lot easier than digging down about 5 sub directories :-) The dmg I have doesn't show them with .txt on the end of the file name or if they are I've turned it off somehow but they open up when you double clic

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread John Ralls
You only need to copy Gnucash.app. The other files, README.txt, NEWS.txt, etc. are in the dmg and renamed with the .txt so you can easily read them with QuickLook. They're also inside Gnucash.app (control-click on Gnucash.app in Finder and select "Show package contents" from the context menu) at

Re: [GNC] AqBanking help for Citi CC (cont'd again)

2019-10-21 Thread David Reiser via gnucash-user
> On Oct 21, 2019, at 12:13 PM, Jonathan Stickel wrote: > > On 10/20/19 22:13, John Ralls wrote: >>> On Oct 20, 2019, at 7:46 PM, Jonathan Stickel wrote: >>> >>> As with messages in January and August, I too would like AqBanking to work >>> with a Citi credit card account. I've followed the r

Re: [GNC] register column sizes

2019-10-21 Thread David Carlson
Jim, Glad that you solved your problem. Others, I think that the current release behaves exactly the same way. Would it be worth while to propose an enhancement to have some minimum column width such as 10 pixels for all columns in the register display? David Carlson On Mon, Oct 21, 2019 at 2:4

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread David H
I copy everything to Applications/GnuCash and run it from there, you can't run it from the dmg. Cheers Dave H. On Mon, 21 Oct 2019 at 20:28, GJS wrote: > Hi, > I've run 2.6 on previous version of MacOSX but couldn't install 3.6. > Having updated to Catalina none of my 32 bit software works! Tha

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Adrien Monteleone
Will do. Also of note, I normally use the sqlite backend so not sure if that has an impact. I’ll try it also with XML since the script only works on that anyway. I might not get done with testing till tomorrow though. Regards, Adrien > On Oct 21, 2019 w43d294, at 5:03 PM, Christopher Lam > wr

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Christopher Lam
Actually, try the trial balance again in a recent maint. A major speedup was merged in last month: https://github.com/Gnucash/gnucash/commit/0ec82872b -- I think you'll find it's now much faster. Come back with benchmarks :) and confirmation amounts are still correct. Otherwise bugzilla is perfect

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Adrien Monteleone
Where should I post it? A bug report? > On Oct 21, 2019 w43d294, at 4:48 PM, Christopher Lam > wrote: > > > > On Mon, 21 Oct 2019 at 20:12, Adrien Monteleone > wrote: > The Trial Balance took 21 seconds. (I didn’t use a stop watch, I just watched > my desktop clock tick by, so not very sci

[GNC] Change edit account mutual fund Security/Currency value

2019-10-21 Thread ornd25
"One way to achieve this may be to create a second stock account with thecorrect currency using a dummy name, then delete the account with theincorrect currency. In the delete dialog it should ask you if you want totransfer any existing transactions into the account you are deleting toanother a

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Christopher Lam
On Mon, 21 Oct 2019 at 20:12, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Trial Balance took 21 seconds. (I didn’t use a stop watch, I just > watched my desktop clock tick by, so not very scientific, but enough of a > spread to be an issue) > > Both tally everything from all t

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread David Cousens
To me the main driver of a single data file approach is the ability to create reports with multi-period comparisons of the data. To be able to do this in a year by year with separate file approach GnuCash would have to have the ability to either keep multiple sets of books open simultaneously or se

Re: [GNC] Change edit account mutual fund Security/Currency value

2019-10-21 Thread David Cousens
One way to achieve this may be to create a second stock account with the correct currency using a dummy name, then delete the account with the incorrect currency. In the delete dialog it should ask you if you want to transfer any existing transactions into the account you are deleting to another ac

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Adrien Monteleone
> On Oct 21, 2019 w43d294, at 12:40 PM, D wrote: > > > Um, the dictionary definition of a "trial balance" is "a statement of all > debits and credits in a double-entry account book, with any disagreement > indicating an error." It is, by definition, a report "as of" a given time > that incl

Re: [GNC] Build error ver 3.7 on mint 19.2

2019-10-21 Thread Geert Janssens
Op maandag 21 oktober 2019 06:32:33 CEST schreef David Cousens: > Geert > > Also agree it needs to be separate from the Building on Linux. Having a new > wiki page on packaging GnuCash with breakout pages for notes and problems > associated with the various packaging methodologies like Snap, Flatp

Re: [GNC] Backporting Gnucash 3.7 to Ubuntu "Bionic" (or Mint, etc.)

2019-10-21 Thread Geert Janssens
Op maandag 21 oktober 2019 04:11:50 CEST schreef Tommy Trussell: > I did not try it much due to the memory limitations. However on that system > I have a "shared" directory symlinked out of the user's home directory to > another user directory where GnuCash and all other work-related files were > i

Re: [GNC] register column sizes

2019-10-21 Thread James Gill via gnucash-user
I am using Mint 19.1 and GnuCash 2.6.19. I could not get the columns to reappear by opening from the Accounts List or from an account with a transfer. I finally found that I could open the hidden columns by putting the cursor on a dividing column rule in the row with column names (creating a do

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread D via gnucash-user
On October 21, 2019, at 10:40 PM, Adrien Monteleone wrote: >Certainly, to each their own. I enjoy reading of other’s process and workflows >and why they make certain decisions. Thanks for offering yours. >My own experiences are in-line: >> On Oct 21, 2019 w43d294, at 2:15 AM, James Thorpe >>

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Adrien Monteleone
Certainly, to each their own. I enjoy reading of other’s process and workflows and why they make certain decisions. Thanks for offering yours. My own experiences are in-line: > On Oct 21, 2019 w43d294, at 2:15 AM, James Thorpe > wrote: > > In another discussion "How to set a customer opening

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Adrien Monteleone
Still there. A date entry would indeed be so much more useful. Regards, Adrien > On Oct 21, 2019 w43d294, at 9:01 AM, Stan Brown > wrote: > > On 2019-10-21 09:40, Derek Atkins wrote: >> James Thorpe writes: >>> >>> a) Fear of corrupting previous year's transactions >>> >>> Once my financi

Re: [GNC] AqBanking help for Citi CC (cont'd again)

2019-10-21 Thread Jonathan Stickel
On 10/20/19 22:13, John Ralls wrote: On Oct 20, 2019, at 7:46 PM, Jonathan Stickel wrote: As with messages in January and August, I too would like AqBanking to work with a Citi credit card account. I've followed the recommend settings described here: https://lists.gnucash.org/pipermail/gnu

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Stan Brown
On 2019-10-21 09:40, Derek Atkins wrote: > James Thorpe writes: >> >> a) Fear of corrupting previous year's transactions >> >> Once my financials are done for the year and reported on, I do not >> wish to inadvertently enter or modify a historical transaction that >> will result in the same report

Re: [GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread Derek Atkins
Hi James, Just for the record, I've got transactional data going back to 2005 and 2007 for my business and personal accounts. -derek James Thorpe writes: > In another discussion "How to set a customer opening balance for the > Customer Report" which has been satisfactorily resolved, Derek Atki

Re: [GNC] How to set a customer "opening balance" for the Customer Report

2019-10-21 Thread Derek Atkins
Adrien Monteleone writes: > How does one enter opening balances, *per customer* or *per vendor*? You don't. You have to enter all outstanding invoices (or bills). > So far that we’ve figured out, the only method is to enter a payment > assigned to Equity:Opening Balances. > > While this does a

[GNC] Change edit account mutual fund Security/Currency value

2019-10-21 Thread ornd25
Is there a way to change the “Security/Currency” value of a mutual fund after transactions have been added to the account? Apparently, while creating a sub-account for a mutual fund I made an error on the New/Edit Account->General->Identification->Security/Currency. I selected the wrong mutual

Re: [GNC] How to create Expense Report to Business from Personal Acct?

2019-10-21 Thread Derek Atkins
Alternatively, in the business side, instead of recording the purchase directly like that you could use the Expense Voucher interface. This treats you (the "employee") like a "vendor" in AP. It's a little more work than just entering in the transactions directly but it also provides you with the

Re: [GNC] How to create Expense Report to Business from Personal Acct?

2019-10-21 Thread Fran_3 via gnucash-user
Thank you David. Perfect answer. Fran3 On Sunday, October 20, 2019, 11:45:00 PM EDT, David Cousens wrote: In the personal accounts if you have expended money on items for the business it creates a Liability for the business  and in your personal accounts by expending money from your ba

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread Derek Atkins
Hi, You need to copy the GnuCash.app from the DMG to /Applications or ~/Applications and then run GnuCash from there. -derek On Mon, October 21, 2019 6:17 am, GJS wrote: > Hi, > I've run 2.6 on previous version of MacOSX but couldn't install 3.6. > Having updated to Catalina none of my 32 bit so

[GNC] Just updated to MacOSX Catalina and GnuCash will not open.

2019-10-21 Thread GJS
Hi, I've run 2.6 on previous version of MacOSX but couldn't install 3.6. Having updated to Catalina none of my 32 bit software works! Thanks Apple. Downloaded 3.7-1. Clicking the file opens a folder containing six files but not the usual File -> Applications facility. Clicking the Gnucash icon

[GNC] Error and Warning messages just before and after upgrading to Ver. 3.7

2019-10-21 Thread Alan A Holmes
Running GnuCash Version: 3.7 Build ID: 3.7+(2019-09-07) on Windows 10 Pro Version 10.0.18362 Build 18362 I've noticed various correspondence about people having problems with Ver. 3.7, and references to looking at the tracefile. I updated to Ver. 3.7 on 15-Oct-2019 just after 14:00, so out of i

[GNC] Why I create a new datafile each year for GnuCash

2019-10-21 Thread James Thorpe
In another discussion "How to set a customer opening balance for the Customer Report" which has been satisfactorily resolved, Derek Atkins asked why I am creating a new data file. I did pose the original question as if moving from a different system so as to avoid the discussion of why I'm crea