[GNC] gnucash-user Digest, Vol 192, Issue 23
Mike Commissaris
commissaris.mike at gmail.com
Sat Mar 9 11:30:21 EST 2019
Subject: Re: [GNC] Problems Accessing GnuCash Files on my D:\
Your symptoms sound different, but I fought a similar situation where I
share a NTFS data drive between windows and LinuxMint 18.3.
It seems that windows does not release any disk it uses because it helps
windows boot faster. I first proved this by holding the shift key while
shutting down windows. This supposedly causes windows to fully shut down
and release the disk. I was then able to access my data drive from Linux. I
am new to linux and struggle with the learning curve, but my ultimate cure
(so far) was to install an Linux NTFS driver via my grub boot file.
Dont know if this will help, but it is at least a redirection - sound like
you have tried most other options.
On Fri, Mar 8, 2019 at 3:36 PM <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Still can't update price quotes (D)
> 2. Re: Problems Accessing GnuCash Files on my D:\ (brob2684)
> 3. Re: gnucash 3.4 help needed (devlin)
> 4. Re: Uploading Invoices (Adrien Monteleone)
> 5. Re: Uploading Invoices (Adrien Monteleone)
> 6. Re: Default invoice/statement (Adrien Monteleone)
> 7. Re: Problems Accessing GnuCash Files on my D:\ (brob2684)
> 8. Re: Order of transactions (Adrien Monteleone)
> 9. Re: Order of transactions (Derek Atkins)
> 10. New user beginning balances receivables (Teresa)
> 11. Re: gnucash 3.4 help needed (David Cousens)
> 12. Re: New user beginning balances receivables (David Cousens)
> 13. can't print to paper since upgrade to version 3.2
> (Chris Roy-Smith)
> 14. Re: Monthly Income V Expense Report (Not Chart)
> (Adrien Monteleone)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 08 Mar 2019 23:48:09 +0530
> From: D <sunfish62 at yahoo.com>
> To: "rmcasali at gmail.com" <rmcasali at gmail.com>, John Ralls
> <jralls at ceridwen.fremont.ca.us>, Elias K Gardner <
> zorkerz at gmail.com>
> Cc: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Still can't update price quotes
> Message-ID: <x40xf6tkkxyuhuxhbei5rvk0.1552069089516 at email.android.com>
> Content-Type: text/plain; charset=utf-8
>
> How many quotes are you attempting to retrieve? If it's more than five,
> you're likely to run into Alphavantage's throttling. That is a major reason
> why many users switched onward to Yahoo-json.
>
> David
>
> On March 8, 2019, at 11:25 PM, rmcasali at gmail.com wrote:
>
> Hi,
>
> I'm having the same problem. All source works with 'gnc-fq-dump', but
> gnucash still giving error message "Unable to retrieve quotes for these
> items:".
>
> The last time I update the price quotes was 01st March, after that my
> linux system update perl5 packages and I couldn't update any price
> quotes anymore. I don't know with have some relation, but it was only
> thing I saw different.
>
> I hope it's helps to find out the problem.
>
> Rafael Casali
>
>
> On Fri, 2019-03-08 at 07:57 -0800, John Ralls wrote:
> > Unfortunately there are no logs.
> >
> > Have you triple-checked that you have the Alphavantage API key set
> > correctly?
> >
> > To troubleshoot further first check that quote retrieval works at
> > all: Try
> > gnc-fq-dump alphavantage AAPL
> > from the command line. You'll probably need to specify a full path to
> > gnc-fq-dump, and you'll need to set ALPHAVANTAGE_API_KEY in the
> > environment. If that works try one of your own stocks (unless you
> > hold Apple in which case you already have). If that works then
> > disable quote retrieval on all but that stock inside of GnuCash and
> > try to get prices. If that works then there's some security that's
> > causing F::Q to blow up and you need to figure out which one.
> >
> > The best way to do that is called "binary search": You disable half
> > of the active ones and try. If that fails, disable half of the rest
> > and try again. Keep doing that until it succeeds. At that
> > point reenable the most recent set that you disabled and disable the
> > others. Keep doing that until you've found one security that fails.
> > Re-enable all of the rest and try. If it fails then you need to
> > repeat the process, perhaps several times, to find all of the
> > securities that fail.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 7, 2019, at 9:15 PM, Elias K Gardner <zorkerz at gmail.com>
> > > wrote:
> > >
> > > Thanks John I just double checked all of my securities. They all
> > > either have online quotes disabled or are set to alphavantage, no
> > > Yahoo left. Is there a log or something to get more details about
> > > the error?
> > >
> > > On Thu, Mar 7, 2019 at 10:59 AM John Ralls <
> > > jralls at ceridwen.fremont.ca.us> wrote:
> > > Make sure that you have no securities using any yahoo source except
> > > yahoo_json (which BTW still works well and unlike alphavantage
> > > doesn't throttle). Any attempt to use the other yahoo sources will
> > > cause the entire retrieval to fail.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > > > On Mar 7, 2019, at 7:34 AM, Elias K Gardner <zorkerz at gmail.com>
> > > > wrote:
> > > >
> > > > My apologies I left out the error, its: "
> > > >
> > > > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner <
> > > > zorkerz at gmail.com> wrote:
> > > >
> > > > > I'm still getting the"" error when trying to update my price
> > > > > database. I
> > > > > got an alpha advantage key, put it in gnucash, and updated my
> > > > > Finance::Quote perl module to 1.47. At one point that seemed to
> > > > > sort of
> > > > > work but now I just get the "" error. Most of my quotes are
> > > > > approaching a
> > > > > year old. The absolute newest is from November 2018.
> > > > >
> > > > > Any suggestions on what I can do? I've searched this list
> > > > > multiple times
> > > > > already without luck. I fear that I broke something in one of
> > > > > my many
> > > > > attempts to fix this over the past year. Maybe I should start
> > > > > fresh. I've
> > > > > attempted to purge gnucash and reinstall but this does not seem
> > > > > to start
> > > > > everything fresh and frankly purging perl is a little over my
> > > > > head without
> > > > > clear guidance. Someday I'll reinstall ubuntu entirely (using
> > > > > 18.10 now, no
> > > > > fresh install for a few years) but thats become a bigger and
> > > > > bigger chore.
> > > > >
> > > > > I'm open to any suggestions. Much appreciated.
> > > > > <gnucash-user at gnucash.org>
> > > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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 at 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 at 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.
>
> ------------------------------
>
> Message: 2
> Date: Fri, 8 Mar 2019 12:59:58 -0600 (CST)
> From: brob2684 <bennrobertson at hotmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Problems Accessing GnuCash Files on my D:\
> Message-ID: <1552071598710-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hi Colin and David
>
> Thanks very much for your replies.
>
>
> Colin Law wrote
> > Are you using File > Open to open the file? If so are you able to
> > browse the folders on D: ok and see all the files there?
>
> It makes no difference whether I double click on the file, or go file open.
>
>
> If you copy the file that you can't open from D: to a different drive
> are you able to open it from there?
>
>
> Yes, if I copy the file off the D: drive to my backup drive, I can open it
> there. No need to change permissions, or anything, it just works. The
> problem seems to be restricted to my D:.
>
>
> What happens if you open the file from the backup folder and then use
> File > Save As to save it to D:?
>
>
> I get the following message if I try to save the database in XML format as
> a
> new file:
> Gnucash could not obtain the lock file for
> D:\Documents\<name>\Data\GnuCash\Balsheet-new.gnucash. That database may be
> in
> use by another user, in which case you should not save the database. Do you
> want to proceed with saving the database?
> Selecting "Save" results in no file being saved.
>
> And if I try to save the database in sqlite3 format, I get the following
> message:
> Can't parse the URL
> D:\Documents\<name>\Data\GnuCash\Balsheet-new.gnucash
> Again, no file is saved.
>
> If I try to save the file as an XML file overwriting an existing file in
> the
> directory, I get the following message:
> Could not make a backup of the file
> D:\Documents\<name>\Data\GnuCash\Balsheet.gnucash
>
> If I try to save the file as a sqlite3 file overwriting an existing file in
> the directory, I get the following message:
> The server at URL D:\Documents\<name>\Data\GnuCash\Balsheet.gnucash
> experienced an error or encountered bad or corrupt data.
>
> I am no longer getting the lock error message this morning when attempting
> to overwrite. I did this step before attempting to open a file on my D:, so
> as David Carlson suggested, it is quite likely I may have had a copy of the
> original file open yesterday when I was trying to save as and overwrite it.
>
>
> If you try to open something like a .doc file from the same folder on
> D: in Word or whatever you use is that ok? Are you able to save it
> again. That may tell you if it is a system problem rather than a
> GnuCash problem.
>
>
> As I said in my initial message, I have no problems saving to the same
> directory from Microsoft Word. Also, being explicit this time round, I can
> open, edit and save the same file in Word without issue.
>
>
> When you get the " Gnucash could not obtain the lock file for..." message,
> it appears that you actually have the copy on your D: drive open rather
> than your backup. Have you checked the file dates of each copy and the
> most recent Gnucash backups (with the .2019xxxx.gnucash suffix in the
> name) in each location?
>
> It's quite possible a version I had attempted to open may have been open in
> the background yesterday as I am no longer receiving that specific error
> message this morning after rebooting my PC. However, as shown by the saving
> tests I conducted for Colin above, I still cannot save to the D: location.
> Nor can I open a guncash file from that location without error.
>
>
> What version of GnuCash are you using, what version of Windows are you
> using, and how is your drive D: connected to your computer? When you tried
> editing a document on your D: drive per Colin's suggestion, did that work?
> How do you address your backup and how is it connected? How and when do
> you back up your D; drive? Have you been diligent about updating Windows OS
> and the OS on your D: server?
>
>
> GnuCash 3.4 from December 2018. This hasn't changed in the past two weeks
> (it was installed back in January). I have uninstalled and reinstalled
> GnuCash to no avail.
>
> My primary hard drive is split into two partitions, the C: where Windows
> resides and the D: where I save my data. The My Documents folder has been
> moved to the D:, but it's been this way since the computer was set up, so
> again this hasn't changed. GnuCash has no issues saving or opening a file
> to
> C:\Users\<name>.
>
> The backup question was a good one. I have two backups - one saved to a WD
> MyBook Elite drive that is directly connected to the PC and accessed via
> the
> L: (I have no idea why Windows gave it that letter, I do not have that many
> drives). The files saved here have no issues. The WD backup software hasn't
> been updated in years (but it's the latest version on issue). This backup
> has not changed.
>
> My NAS also takes a backup of the D: periodically and saves it in read-only
> format. I am experiencing the same access errors here. However, I must
> admit
> I have never before tried to open a GnuCash backup file off the NAS.
> Copying
> this file to my WD Backup and unticking the read-only flag sees GnuCash
> again work correctly. As far as I can tell, the NAS hasn't been updated
> recently - it tends to run and not give me any grief so it's been left
> alone.
>
> Windows 10 updates get downloaded and installed automatically. The Windows
> version is 1809 and the OS build is 17763.316 (no idea what the difference
> between the two numbers is).
>
> Thanks for the suggestions so far. I don't mind if I can't directly access
> the files from my NAS, but I am perplexed as to why GnuCash won't
> read/write
> from my D:.
>
> Thanks again,
> brob2684
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 8 Mar 2019 14:18:42 -0500
> From: devlin <devlinpe at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash 3.4 help needed
> Message-ID: <0d2d16a3-5cd2-3bd8-0425-367de4510a71 at gmail.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> Nope.
>
> No matter what I try, I get the error that the "gnucash3.4 directory
> does not exist."
>
>
> On 3/7/19 11:51 PM, David Cousens wrote:
> > cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local ../gnucash-3.4
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 8 Mar 2019 13:24:57 -0600
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Uploading Invoices
> Message-ID: <DE69399A-CCE7-4F92-B1EC-843EBC3CC6E8 at lusfiber.net>
> Content-Type: text/plain; charset=us-ascii
>
> This is covered in the Tutorial & Concepts Guide - Chapter 18 Import
> Business Data. (
> http://www.gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=guide)
>
> The format you need is CSV and the column headings (fields) are described
> at the end of the chapter in 18.1.2
>
> Note, the beginning of the chapter focuses on Python scripts to accomplish
> converting data to the needed format. This may or may not be useful to you.
>
> Regards,
> Adrien
>
> > On Mar 8, 2019, at 11:38 AM, Teresa <Teresa at coba-em.com> wrote:
> >
> > I am using an external invoicing system, and I am a new user. I need to
> import 30 monthly and individual invoices from my invoicing system into Gnu
> Cash.
> >
> > I also need to import invoices YTD, paid and open.
> >
> > Is there a template?
> >
> > --
> >
> > Teresa Slack
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 8 Mar 2019 13:27:25 -0600
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Uploading Invoices
> Message-ID: <C1A16462-C444-45C4-B325-FCF60D20879F at lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> I don?t see any reason you can?t use the same invoice number rather than
> having to maintain two numbering systems. GnuCash lets you make up just
> about any numbering scheme you want, so certainly, you use the same
> original number from the external system.
>
> Regards,
> Adrien
>
> > On Mar 8, 2019, at 12:02 PM, Justin Haynes <justin at justinhaynes.com>
> wrote:
> >
> > Oh, also, have you looked in File -> Properties? Notice under book
> options
> > in "Business" and "Counters". In Counters, those are for internal
> > numbering, but there is also a field in invoices
> >
> >
> > And one more thing - if the external invoicing system has its own invoice
> > numbers, you should be able to import those as the "Billing ID". That's
> > separate from GNUCash's internal InvoicID. So for example, if you don't
> > have any invoices, and you manually created a new customer and created a
> > new invoice, you could rely on GNUCash to autonumber teh invoice, and you
> > can fill in the external invoice systems id as "Billing ID" Like I show
> > here. I would think importing works the same but I have not tested it
> > becaus I don't use an external invoicing system.
> >
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 8 Mar 2019 13:30:46 -0600
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: GnuCash <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Default invoice/statement
> Message-ID: <FFCBD4C2-9037-457E-9C2A-CC8A122CBBBB at lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> Roger,
>
> If for some reason you just had to stick with the 2.6.x series for a while
> longer, I?d recommend 2.6.21 as many bugs were fixed between it and 2.6.17.
> It is the last stable release of the 2.6 series. But 3.4 is the current
> release. (3.5 is due out at the end of the month I believe)
>
> Regards,
> Adrien
>
> > On Mar 8, 2019, at 8:33 AM, Derek Atkins <derek at ihtfp.com> wrote:
> >
> > Hi,
> >
> > <rmomxtx at gmail.com> writes:
> >
> >> Thanks Derek,
> >>
> >> Good to know the feature has been added to Version 3.x. I take it by
> current
> >> you mean stable? Still a little reluctant to upgrade as version 2.6.17
> is
> >> working for us. If it ain't broke...
> >
> > Version 2.6.17 was released Q3 2017. It is now Q1 (almost Q2) 2019, so
> > it's almost two years old. And yes, 3.4 is the current stable release.
> >
> >> Roger
> >
> > -derek
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 8 Mar 2019 13:41:12 -0600 (CST)
> From: brob2684 <bennrobertson at hotmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Problems Accessing GnuCash Files on my D:\
> Message-ID: <1552074072826-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hi Colin and David,
>
> I've done a bit more digging and it began to looks like there was a small
> chance the issue is linked to the special Windows folders.
>
> If I move a copy of my gnucash file to an existing directory on D:\ that is
> not a special Windows folder (e.g. D:\Filing or D:\Tmp) then gnucash opens
> the file without issue.
>
> On the other hand, if I move the file to a special Windows folder (e.g.
> D:\Documents or D:\Favorites or D:\Desktop or D:\Pictures). Surprisingly,
> D:\Downloads works without issue.
>
> I haven't made any changes to this setup in the past fortnight.
>
> A fair bit of further random, seemingly aimless Googling along the above
> lines kept turning up recommendations about permissions, none of which
> worked.
>
> ----------------------------
>
> However, I eventually turned up this little chestnut:
>
>
> https://superuser.com/questions/1293897/cannot-save-files-to-desktop-in-windows-10
>
> It seems "Controlled folder access" was switched on. From what I've read,
> it's supposed to be an opt-in feature, and when enabled, it uses a
> mechanism
> to track apps trying to make changes to files in the protected folders. If
> the app is malicious, or it's not recognized, the feature will in real-time
> block the attempt, and you'll get a notification of the suspicious
> activity.
>
> So it looks like my problem stems from opting in (sorry, I have no
> recollection of doing so) but I've also received no notifications of
> suspicious activity either.
>
> Disabling this means I can open/save/edit files in GnuCash that are written
> to my D:\Documents folder again.
>
> Thanks both for your help,
> brob2684
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 8 Mar 2019 13:41:40 -0600
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Order of transactions
> Message-ID: <901251D1-9723-413F-836B-C6BE95AFB1DD at lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> I didn?t mean to still be able to sort by the real transaction number, but
> if you have one, and you?ve repurposed the NUM field, you?ll likely want a
> place to put it just for reference. I simply offered an overview of the
> remaining options. Overloading NUM as a time field is pretty much giving up
> on using it to hold a real transaction number. (though one user piped in
> they used a yyyy.nnnn format that seems to work, though I don?t see how
> with the intervening ?.?)
>
> The ideal would be to edit the time portion of the transaction's entry but
> of course, that means more code and maintenance for a non-widespread use
> case. The occurrence of negative balances is rare unless you extensively
> use a cash account (where it is impossible in the real world) or you
> frequently have just the right types of transactions in some other asset so
> that the GnuCash ordering produces this condition.
>
> Regards,
> Adrien
>
>
> > On Mar 8, 2019, at 8:54 AM, Derek Atkins <derek at ihtfp.com> wrote:
> >
> > Adrien Monteleone <adrien.monteleone at lusfiber.net> writes:
> >
> >> Yes, that is why I was explaining the abuse of the NUM field as a time
> >> field for sorting and how to do it in a way that works. If you are
> >> doing this, (or instead using 1,2,3,4 ) *and* you want to keep track
> >> of a transaction number, then you?ll have to put it somewhere else so
> >> you can still sort that transaction in the order you want. One obvious
> >> choice for an alternative would be the Action field for that
> >> particular split line. Another would be the Note field. (especially if
> >> the Action field is also otherwise utilized) Another option would be
> >> the Memo field for the split.
> >
> > Yes, if you want to order your transactions in a specific order but then
> > also be able to sort by a transaction number then yes, you would need to
> > do what you suggest and put the default-sort-order into Num, and the
> > transaction number into another field.
> >
> > But why would you want to do that?
> >
> > You could still SEARCH for transaction number even if you overload num
> > with <sortNum>.<TxnNum>. But yes, you couldn't sort on the <TxnNum>
> > portion -- I just don't see the use case for that.
> >
> > *shrugs*
> >
> >> Regards,
> >> Adrien
> >
> >> 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
> > derek at ihtfp.com www.ihtfp.com
> > Computer and Internet Security Consultant
> >
>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 8 Mar 2019 14:55:44 -0500
> From: "Derek Atkins" <derek at ihtfp.com>
> To: "Adrien Monteleone" <adrien.monteleone at lusfiber.net>
> Cc: "gnucash-user" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Order of transactions
> Message-ID:
> <f657a03b3b7d75d90c2f806f739f4a7f.squirrel at mail2.ihtfp.org>
> Content-Type: text/plain;charset=utf-8
>
> Adrien,
>
> On Fri, March 8, 2019 2:41 pm, Adrien Monteleone wrote:
> > I didn?t mean to still be able to sort by the real transaction number,
> but
> > if you have one, and you?ve repurposed the NUM field, you?ll likely want
> a
> > place to put it just for reference. I simply offered an overview of the
> > remaining options. Overloading NUM as a time field is pretty much giving
> > up on using it to hold a real transaction number. (though one user piped
> > in they used a yyyy.nnnn format that seems to work, though I don?t see
> how
> > with the intervening ?.?)
>
> As I said, the string field is converted to an integer using the
> C-language atoi() function and then the sort happens using the numerical
> value. So the string yyyy.nnnn with be converted into the number yyyy and
> that will be used to sort. If yyyy is 0001, this would be sorted before a
> yyyy of 2. Basically, the conversion for sorting will stop at the first
> non-numeral character. That's why using yyyy.nnnn works. Or yyyy-nnnn.
> Even yyyyAnnnn will work (this is all assuming the yyyy and nnnn are all
> numerals).
>
> So 00011.16298462 will come before 2.294362. If it were a pure string
> compare, then this would not be the case.
>
> > 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
> derek at ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
>
>
> ------------------------------
>
> Message: 10
> Date: Fri, 8 Mar 2019 16:00:43 -0500
> From: Teresa <Teresa at coba-em.com>
> To: gnucash-user at gnucash.org
> Subject: [GNC] New user beginning balances receivables
> Message-ID: <714b3523-d1f6-dce9-3c1c-677130af0178 at coba-em.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> I have loaded all balances for a business that was doing their
> accounting on excel
>
> The balances go through Dec 2018
>
> The issue I have is they had 3 receivable accounts
>
> Receivable = Asset
>
> Paid = Income
>
> Aged = ??
>
> I'm not sure where to put the aged amount, retained earnings?
>
> Thank you
>
> --
>
> 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
>
> Teresa at Coba-EM.com <mailto:Teresa at Coba-EM.com>
> Coba-EM.com <http://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. /
>
>
>
> ------------------------------
>
> Message: 11
> Date: Fri, 8 Mar 2019 15:27:52 -0600 (CST)
> From: David Cousens <davidcousens at bigpond.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash 3.4 help needed
> Message-ID: <1552080472323-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Devlin
>
> OK that error means that cmake is unable to locate the source directory
> from
> the build directory. You would use it in this form if the directory
> structure is
>
> Applications
> |
>
> --------------------------------------
> |
>
> |
> gnucash-3.4
> gnucash-3.4-build
> |
> source code
>
> however your directory structure appears to be:
> Applications
> |
> gnucash-3.4
> |
>
> ------------------------------------------
> |
>
> |
> sources
> gnucash-3.4-build
>
> the relative path from gnucash-3.4-build to gnucash-3.4 in this case is
> ".." not "../gnucash-3.4".
> try
> $cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local ..
>
> Apologies I should have picked that up earlier but I wasn't looking past
> the
> unneeded directive for the libraries.
>
> David Cousens
>
>
>
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 12
> Date: Fri, 8 Mar 2019 16:56:36 -0600 (CST)
> From: David Cousens <davidcousens at bigpond.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] New user beginning balances receivables
> Message-ID: <1552085796435-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Teresa
>
> The best option is to use the business features and create dummy invoices
> to
> match the original invoices. This should create the aging entries.
>
> You will need to add the business accounts Accounts receivable and Accounts
> Payable using the Action->New Account Heirarchy and select Business
> Accounts.
>
> Then Use Business->Customers->New Invoice to create invoices and predate
> them to the dates of the original invoices. You can add customers from the
> new invoice dialog after hitting the Select button for the customer.
>
> See
> https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users
> https://wiki.gnucash.org/wiki/Business_Features_Issues
> https://www.gnucash.org/docs/v3/C/gnucash-guide/pt03.html
>
> for more detail.
>
> David Cousens
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 13
> Date: Sat, 9 Mar 2019 09:59:03 +1100
> From: Chris Roy-Smith <chris_roysmith at internode.on.net>
> To: gnucash-user at gnucash.org
> Subject: [GNC] can't print to paper since upgrade to version 3.2
> Message-ID: <cc71ee0a-c94b-da1b-5388-249da2ab8e56 at internode.on.net>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> Hi All.
>
> I was running version 2.6. Printing offered a choice of printers. Linux
> Mint updated GnuCash to version 3.2. Now I don't get a list of printers.
> Only "lpr"and "file" is offered. Other programs still offer the normal
> list of printers. I can still print to file, but that is awkward. How do
> I print to paper now?
>
> Thanks
>
> Chris Roy-Smith
>
>
>
> ------------------------------
>
> Message: 14
> Date: Fri, 8 Mar 2019 17:32:49 -0600
> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Monthly Income V Expense Report (Not Chart)
> Message-ID: <8BD458F3-2122-424E-9AED-D287501D6711 at lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> Dan,
>
> What you are looking for (per your screenshot) is a multi-period Income
> Statement.(P&L)
>
> GnuCash doesn?t have this yet. (it is under development, but work has hit
> a roadblock, so don?t expect it soon)
>
> For now, you have three options:
>
> 1. Run the Transaction Report that Chris offered, export or copy/paste to
> a spreadsheet and massage from there.
>
> This option will get you the monthly figures all in neat columns along
> with a total and average column as well as account names for each row.
> You?ll just need to add total lines for Expenses and Income, but it also
> provides a ?net income/loss? labeled as ?Grand Total? - adjust as desired.
> You?ll also need to delete all of those boldface ?total for? lines as I
> can?t seem to get rid of them and only get the account summary portion.
>
> 2. Run an Income Statement/P&L for each desired period, export or
> copy/paste to a spreadsheet and massage from there.
>
> I?ve been using this option. I save the report, open it in LibreOffice
> calc via the ?Insert Sheet from File? function in the Insert menu, and then
> copy only the data column over. You?ll have to always 'include zero balance
> accounts' so everything lines up as some periods may not have transactions
> in all accounts. I then copy over columns which calculate percentages and a
> variance for each period for further analysis. I also have a YTD column. (I
> think I?ll add an ?average? column now as that would be useful for
> budgeting)
>
> 3. Run a Multi-Column report and make each desired column an Income/P&L
> report, each configured to a different period.
>
> The downside here is each column will repeat the account labels which
> takes up unnecessary space and clutters the report. (which is why a proper
> version is in development) You can use this as-is, or export or copy/paste
> to a spreadsheet to remove the extraneous labels and add a ?YTD? or other
> columns as needed.
>
> I would say Chris?s options on the Transaction Report seem to be the least
> amount of work and that is probably the better option if you ever edit
> transactions in a prior period as that will get you the most up-to-date
> data where my method-2 would require re-exporting the prior periods each
> time. (I think I?ll switch, using this as a source to pull data into my
> custom sheet that has percentages and variances)
>
> Regards,
> Adrien
>
> > On Mar 8, 2019, at 9:28 AM, Dan Carmona via gnucash-user <
> gnucash-user at gnucash.org> wrote:
> >
> > Hi,
> >
> >
> >
> > Tried this but this is not Income V Expenses. It is more
> account/category transaction summary by month.
> >
> >
> >
> >
> >
> > From: Christopher Lam <christopher.lck at gmail.com>
> > Sent: Friday, March 8, 2019 9:11 AM
> > Cc: Dan Carmona <dkcarmona at yahoo.com>; Gnucash Users <
> gnucash-user at gnucash.org>
> > Subject: Re: [GNC] Monthly Income V Expense Report (Not Chart)
> >
> >
> >
> > Run the Transaction Report
> >
> >
> >
> > Accounts/Accounts select Income and Expense accounts
> >
> > Display/Subtotal table: enabled
> >
> > Sorting/Primary Sortkey: account-name
> >
> > Sorting/Primary Subtotal: true
> >
> > Sorting/Secondary Sortkey: date
> >
> > Sorting/Secondary Subtotal: monthly
> >
> > Sorting/Hide transactions: enabled
> >
> >
> >
> >
> >
> > On Fri, 8 Mar 2019 at 13:49, David Carlson <david.carlson.417 at gmail.com
> <mailto:david.carlson.417 at gmail.com> > wrote:
> >
> > Dan,
> >
> > The image you included appears to be from a different program, not from
> > GnuCash. GnuCash, to my knowledge, does not have a similar report at
> this
> > time.
> >
> > On Fri, Mar 8, 2019 at 6:34 AM Dan Carmona via gnucash-user <
> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > wrote:
> >
> >> I can't seem to find how to perform a monthly Income/Expense Report (not
> >> chart).
> >>
> >> For example:
> >>
> >>
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org <mailto:gnucash-user at 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 at gnucash.org <mailto:gnucash-user at 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 at 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.
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> gnucash-user mailing list
> gnucash-user at 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.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 192, Issue 23
> *********************************************
>
--
Mike
More information about the gnucash-user
mailing list