Can't use AR type accounts with invoices

So, trying to work around the multi-period posting date issue in another thread, I opted to bring in a vestige of paper accounting and utilize an Accrued Revenue account. (otherwise known as ‘unbilled revenue’ or ‘unbilled work’) The guidance I found online suggested this should be a Current

Re: Gnucash on Linux Mint

On Mon, Dec 18, 2017 at 5:15 PM, Robert Heller wrote: > At Mon, 18 Dec 2017 15:50:29 -0600 Les wrote: > > > > > I have been using Linux Mint Mate for several years, updating with each > > incremental release. Currently at 18.2, planning to upgrade to

Re: export general ledger

Jeff, If you have piles of invoices, and you like data entry spreadsheet/text style, you can set up an import csv for them instead and bring them in all at once. There’s a few threads here about the format not too long ago. (within the year) Regards, Adrien > On Dec 18, 2017, at 1:06 PM, Jeff

Re: export general ledger

Sorry if my understanding of the GC General Ledger was off. By combining the files, I meant the exported csv files. So a simple: “cat * > gnucash.csv” after those 4 exports would do the trick. Regards, Adrien > On Dec 18, 2017, at 1:17 PM, Wm via gnucash-user >

Re: export general ledger

On 18/12/2017 18:13, Adrien Monteleone wrote: Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. You recall incorrectly. The

Re: export general ledger

On 18/12/2017 13:16, Sébastien de Menten wrote: To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py I already said that, you just have to wait

Re: export general ledger

On 18/12/2017 10:32, Jeff Abrahamson wrote: On 18/12/17 03:26, Wm via gnucash-user wrote: On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or

Re: MacOS 10.13.2 won't work with Gnucash

Hi Everyone, I just can't believe it! That was indeed the problem - I had downloaded the MacOS-PPC file instead of the Intel one. Not the sort of mistake I usually make! Gnucash 2.6.19 is now running, after a few hiccups, the working none-the-less. I'll be a damn sight more careful in future.

Re: Gnucash on Linux Mint

At Mon, 18 Dec 2017 15:50:29 -0600 Les wrote: > > I have been using Linux Mint Mate for several years, updating with each > incremental release.  Currently at 18.2, planning to upgrade to 18.3 > shortly.  I get a .deb package from getdeb.net. The latest is 2.6.17 >

Gnucash on Linux Mint

I have been using Linux Mint Mate for several years, updating with each incremental release.  Currently at 18.2, planning to upgrade to 18.3 shortly.  I get a .deb package from getdeb.net. The latest is 2.6.17 which has not been updated for some time. Is any Linux Mint users finding newer

Re: export general ledger

> > Alternatively there are a number of scripts that can take gnc files of > some flavour and produce ledger-cli / beancount compatible files which are > generally mores useful than csv files for accounting data anyway. It looks like ledger-cli dropped gnucash import support in 2009?

Re: MacOS 10.13.2 won't work with Gnucash

Hi Everyone, I just can't believe it! That was indeed the problem - I had downloaded the MacOS-PPC file instead of the Intel one. Not the sort of mistake I usually make! Gnucash 2.6.19 is now running, after a few hiccups, the working none-the-less. I'll be a damn sight more careful in future.

Re: MacOS 10.13.2 won't work with Gnucash

Hi Pat, I thought I'd already seen a message to the effect that you'd downloaded the wrong Mac executable - you need to download the Mac OSX Intel bundle NOT the Power PC bundle ? What is the name of the dmg you downloaded - should have Intel in the name NOT PPC. Cheers Dave H. On 19 December

Re: MacOS 10.13.2 won't work with Gnucash

I did what was suggested with Terminal, although it didn't seem to work initially. After I removed the % sign from the command and tried again, this is what came up: I'm still not sure I got the command right as I

Re: export general ledger

Thanks, Adrien.  In the end, as long as I can automate this, I'll be happy.  (I haven't fully followed on on the python solution, but it sure looks like it will work fine, so I've chalked it up as future work for me rather than potential workflow blocking today.  Always good to have a project over

Re: export general ledger

Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. GnuCash takes the opposite approach from paper books. With paper, you enter

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

> On Dec 17, 2017, at 11:07 PM, Dale Alspach wrote: > > Adrien, > > It seems to me that what you want is not an accounting solution but a > software enhancement. I believe that you need to say exactly what you > want in a bugzilla RFE. For the issue you describe below what

Re: errir in SQL syntax

> On Dec 18, 2017, at 8:29 AM, AC wrote: > > You need to reply to all to make this back to the mailing list. > Forwarding for the list. > > > > > > Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL > Maybe somebody can correct this? That

Re: MacOS 10.13.2 won't work with Gnucash

Sorry, you're talking through your hat. GnuCash isn't built as a universal binary, it's 32-bit only. 32-bit programs run just fine on all 64-bit OSes supported by Gtk+. We (meaning I) provide two such, one for PPC built on an actual PPC Mac Mini and one Intel, built on a MacPro running MacOS

Fwd: Re: errir in SQL syntax

You need to reply to all to make this back to the mailing list. Forwarding for the list. Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL Maybe somebody can correct this? Wolfgang On Mon, Dec 18, 2017 at 8:30 AM, AC

Re: MacOS 10.13.2 won't work with Gnucash

At Mon, 18 Dec 2017 07:19:16 -0800 John Ralls wrote: > > It is indeed complaining about the CPU. To be absolutely sure that that’s > the problem, you can run > file /Users/patriciamitchell/Desktop/Gnucash.app/Contents/MacOS/Gnucash-bin > > in Terminal. Note the "-bin"

Re: MacOS 10.13.2 won't work with Gnucash

At Mon, 18 Dec 2017 05:56:46 -0700 (MST) "its...@gmail.com" wrote: > > I did what was suggested with Terminal, although it didn't seem to work > initially. After I removed the % sign from the command and tried again, this The '%' is the bash (typical) command prompt. > is

Re: MacOS 10.13.2 won't work with Gnucash

At Mon, 18 Dec 2017 08:15:56 -0500 "R. Victor Klassen" wrote: > > Looks like you somehow got the build for an x86 machine (on PowerPC machine) > or (more likely) the build for a PowerPC machine on an x86 machine. More likely 32 vs 64 bit x86 (ix86 vs x86_64). > > It's

Re: MacOS 10.13.2 won't work with Gnucash

It is indeed complaining about the CPU. To be absolutely sure that that’s the problem, you can run file /Users/patriciamitchell/Desktop/Gnucash.app/Contents/MacOS/Gnucash-bin in Terminal. Note the “-bin” on the end. For an Intel machine it should say "Mach-O executable i386”. If it says

Re: Gnucash + mysql

> On Dec 18, 2017, at 6:29 AM, Wolfgang Paul Rauchholz > wrote: > > Didn't think about that possibility. > Let me try this out too. > > Do you know whether there are plans to extend usage of mysql in gnucash? > Not MySQL per se, but we do intend to make GnuCash a

Re: Gnucash + mysql

Didn't think about that possibility. Let me try this out too. Do you know whether there are plans to extend usage of mysql in gnucash? Thanks. Wolfgang On Mon, Dec 18, 2017 at 2:46 PM, Colin Law wrote: > You don't need to use mysql to do that, provided you have access to a

Re: Gnucash + mysql

You don't need to use mysql to do that, provided you have access to a share on the server where the xml file is. That is what I do. Then I can access it from any machine on my local network, or from anywhere in the world using my home VPN. However if that is what you want to do, just setup the

Re: Gnucash + mysql

Several reasons for mysql: Several reasons: - I have backup procedure on my home server - I can access (hopefully) form several laptops to the database (not concurrent) On Mon, Dec 18, 2017 at 1:15 PM, Colin Law wrote: > On this list when replying you have to use Reply All

Re: export general ledger

To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py On Mon, Dec 18, 2017 at 11:32 AM, Jeff Abrahamson wrote: > On 18/12/17 03:26, Wm

Re: MacOS 10.13.2 won't work with Gnucash

Looks like you somehow got the build for an x86 machine (on PowerPC machine) or (more likely) the build for a PowerPC machine on an x86 machine. It’s complaining about the CPU. > On Dec 18, 2017, at 7:56 AM, its...@gmail.com wrote: > > I did what was suggested with Terminal, although it didn't

Re: MacOS 10.13.2 won't work with Gnucash

I did what was suggested with Terminal, although it didn't seem to work initially. After I removed the % sign from the command and tried again, this is what came up: I'm still not sure I got the command right as I

Re: Gnucash + mysql

On this list when replying you have to use Reply All (or similar) otherwise your reply just goes to the previous poster (as yours did to me). I am copying in the list so others will see it. Once you have installed mysql then you should be able to use Save As and select mysql as the type. I have

Re: MacOS 10.13.2 won't work with Gnucash

At Mon, 18 Dec 2017 00:52:49 -0700 (MST) "its...@gmail.com" wrote: > > Hi John, > > I have done a complete uninstall of the program. Restarted in Safe Mode, > then downloaded a fresh copy of an earlier version and installed. Nothing > happened. > > I reinstalled version

Re: export general ledger

On 18/12/17 03:26, Wm via gnucash-user wrote: > On 17/12/2017 19:31, Jeff Abrahamson wrote: >> I'd like to export the general ledger to a csv file.  When I use File -> >> Export, however, I'm offered a choice of exporting income, expenses, >> assets, or liabilities.  But I'd like to have all