[GNC] "Deleted" Invoices or Bills
Eric Hammond
eric at jehammond.net
Tue Sep 6 20:21:41 EDT 2022
I have created many test invoices (and bills) that I "virtually deleted" by not Posting them.
As before, as soon as I close that document's tab it apparently vanishes.
I have opened the Gnucash.gnucash file with Notepad++ and searched for the text I know should be in the unposted invoices, but no results.
Having those particular invoices or bills actually vanish would the best outcome, re-useability is second best.
How do I find them again to re-use? Or verify that they are gone, thereby saving space?
Thanks,
Eric
Date: Thu, 1 Sep 2022 18:25:27 +0000
From: Eric Hammond <eric at jehammond.net>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] "Deleted" Invoices or Bills
Message-ID:
<BYAPR19MB25174222BB7EDEA4B753D3C3D57B9 at BYAPR19MB2517.namprd19.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
Thanks Adrien,
I understand the complexity of the data-base, and re-using them would be great.
But....
Please tell me how you find them?
(there are a LOT at this point)
Once I Unpost and clean up incorrect invoices or bills they seem to vanish when I close its tab in the "Accounts" ribbon.
All the best,
Eric
Date: Wed, 31 Aug 2022 19:35:38 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] "Deleted" Invoices or Bills
Message-ID: <teouoq$t13$3 at ciao.gmane.io>
Content-Type: text/plain; charset=UTF-8; format=flowed
They remain forever. (There was a decent explanation as to why recently on IRC - the short of it is that deleting them cleanly is simply too messy with the current code.)
My workflow in such cases is to change their ID to 'use next'. You can either create a dummy vendor/customer for them as well, or just leave them as-is since you can re-assign the vendor/customer before posting.
When I want to start a new bill/invoice, I do a find for 'use next' IDs, but that is pretty rare now as I just duplicate a previous document and edit from there. (and I don't think I have any 'use next' documents left
anyway.)
Regards,
Adrien
On 8/31/22 6:59 PM, Eric Hammond wrote:
> A different track....
> In my hasty entering / importing of Invoices and Bill I find that some of them are duplicates, or not needed.
> I can make them "disappear" by un-posting and clicking the delete button, but where do they go?
> Does GnuCash automatically purge the trash? If not, how do I clean it up?
> Thanks for the help,
> Eric
------------------------------
Message: 3
Date: Thu, 1 Sep 2022 13:44:14 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] "Deleted" Invoices or Bills
Message-ID: <tequhu$t14$1 at ciao.gmane.io>
Content-Type: text/plain; charset=UTF-8; format=flowed
Menu: Business > Customer/Vendor > Find Invoice/Bill > 'Invoice/Bill ID'
> 'contains' > "Use Next" or whatever text you changed it to. (without
quotes)
Then you can select the one you want and use the view/edit button to adjust from there.
Regards,
Adrien
On 9/1/22 1:25 PM, Eric Hammond wrote:
> Thanks Adrien,
> I understand the complexity of the data-base, and re-using them would be great.
> But....
> Please tell me how you find them?
> (there are a LOT at this point)
> Once I Unpost and clean up incorrect invoices or bills they seem to vanish when I close its tab in the "Accounts" ribbon.
------------------------------
Message: 4
Date: Thu, 1 Sep 2022 13:46:53 -0500
From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Question - Applying Credit notes to an outstanding
invoice
Message-ID: <tequmt$t14$2 at ciao.gmane.io>
Content-Type: text/plain; charset=UTF-8; format=flowed
Menu: Business > Customer > Process Payment
Look up the customer
Select both the desired credit note and the desired invoice
Set the other appropriate info, but unless also taking another form of payment leave the payment field unchanged.
The credit note will be used to partially/fully offset the invoice which will show up as a 'payment' in the Customer Report.
Regards,
Adrien
On 9/1/22 9:39 AM, Nora wrote:
> I'm not sure how to apply a client's credit note to pay for another
> invoice of the same client.
------------------------------
Message: 5
Date: Thu, 1 Sep 2022 15:16:20 -0700
From: Jim DeLaHunt <list+gnucash at jdlh.com>
To: Geoff Storer <go.storer.ben at gmail.com>, Gnucash Users
<gnucash-user at gnucash.org>
Subject: Re: [GNC] Change Linked Document Path
Message-ID: <00eab847-49b3-9d61-01b4-db3b6a506c37 at jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Geoff:
One tenet of GnuCash-user email list etiquette is to cc the gnucash-user email list on all replies. We want this discussion to take place on the list.
Thus I am replying to you, and cc'ing the list, so that the thread stays on the list.? I will reply to this message from the email that reaches me via the list.
??? ?Jim DeLaHunt
On 2022-09-01 03:57, Geoff Storer wrote:
> Hi Jim
>
> Thanks for coming back to me. Sorry I have taken so long to respond.
>
> In answer to your questions:
>
> Q: Are you familiar with the difference in behaviour between relative
> file paths and absolute file paths?
>
> Ans; No this is not one of my strong points
>
> Q: Are you familiar with the difference in spelling (C:\ prefixes and
> backslashes etc.) between relative file paths and absolute file paths?
>
> Ans:? No
>
> Q: In your GnuCash Book (bookkeeping file), have you associated files
> to transactions using relative path File Associations, absolute path
> File Associations,? or Location Associations?
>
> Ans: I think the answer here is relative path. What I actually did in
> GNU was:
> Edit / preferences / General / Linked Files and with the drop down
> arrow selected the folder location of my invoices The reason I say
> "relative path" is because GNU program details on the referenced edit
> field the comment "Path head for Linked Files Relative Paths"
> The location I selected is -??D:\PDF\GNU Invoices
>
> Q: Were all your attached documents within a single directory on your
> old computer? Do you know the absolute path to that directory?
>
> Ans: Yes all invoices are in the one folder? ?"D:\PDF\GNU Invoices"?
> (the output here I copied directly from my explorer view so I should
> have that correct)
>
> Q: Are all your attached documents within a single directory on your
> new computer? Do you know the absolute path to that directory?
>
> Ans: The invoices are in the exact location as on the initial install
> of GNU.
> ? ? ? ? I only re-installed windows on the C:\ partition. The other
> partitions remain exactly as they were ? ? ? ? The invoices are in
> "D:\PDF\GNU Invoices"
>
> I hope I have answered all your queries. Let me know if you need any
> further clarification.
>
> Thanks again
>
> Regards
>
> John Murdoch
>
> On Tue, Aug 30, 2022 at 3:46 PM Jim DeLaHunt <list+gnucash at jdlh.com
> <mailto:list%2Bgnucash at jdlh.com>> wrote:
>
> Hello, John:
>
> Your question rings a bell! I did an overhaul on the file
> associations
> on my transactions a couple of years ago.
>
> On 2022-08-29 04:10, john murdoch wrote:
> > ...My problem now is that [GnuCash] looks for the attached
> document in the
> > windows document folder on the C Drive. I have tried editing the
> > preferences in [GnuCash] to point to the correct location of the
> documents
> > on the alternate partition but this doesn't automatically link
> to the
> > document.
> >
> >
> > I can then manually link each document by using? the "manage
> document
> > link" function on the right click menu in the account field of GNU
> > cash. That? of course will be quite tedious and I was enquiring if
> > there is a "global fix" so that all files could be re-linked in one
> > procedure? Perhaps editing settings or the system registry?
> >
> >
> > I did try a feature as per the attached screenshot [of the
> Change Linked Document path head dialogue] without any success.
>
> Well, the Change Linked Document path head dialogue, which your
> screenshot showed, is the best tool in GnuCash for this job. However,
> you have to know a few things to use it well. I'll bet the UI does
> not
> do a complete job of walking a person through it.
>
> To set some groundwork, some questions:
>
> Are you familiar with the difference in behaviour between relative
> file
> paths and absolute file paths?
>
> Are you familiar with the difference in spelling (C:\ prefixes and
> backslashes etc.) between relative file paths and absolute file paths?
>
> In your GnuCash Book (bookkeeping file), have you associated files to
> transactions using relative path File Associations, absolute path
> File
> Associations,? or Location Associations?
>
> Were all your attached documents within a single directory on your
> old
> computer? Do you know the absolute path to that directory?
>
> Are all your attached documents within a single directory on your new
> computer? Do you know the absolute path to that directory?
>
> Based on answers to those questions ? and once I run GnuCash to
> refresh
> my memory about how the Change Linked Document path head dialogue
> works,
> and once I translate from macOS to Windows in my head ? I can try to
> help you further.
>
> Best regards,
> ????? ?Jim DeLaHunt
>
>
> Are all your attached documents within a single directory on your new
> computer?
>
>
>
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
------------------------------
Message: 6
Date: Thu, 1 Sep 2022 19:08:00 -0500
From: "W. Neal Lewis" <wnlewis at southwind.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Can someone tell me how A-L=Eq+(I-Ex) is correct?
Message-ID: <2c54edf1-69ba-5fbc-4a3f-bf718c6a0af0 at southwind.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Liz,
Thank you.
I've received much help and am learning what is needed.
Best regards,
Neal Lewis
P.S. The book that was recommended: "Accounting All-In-One for Dummies"
is on its way to me, purchased yesterday from Amazon. I am thankful for that suggestion, because I did not know what to look for. The other members were able to get me over a logical hurdle that had blocked forward progress until they offered help. WNL
On 8/31/22 11:42 PM, Liz Dodd wrote:
> On Wed, 31 Aug 2022 21:08:35 -0500
> "W. Neal Lewis" <wnlewis at southwind.net> wrote:
>
>> David,
>>
>> That's where this all started.
>>
>> It didn't make sense so I thought I would ask people who were more
>> knowledgeable.
>>
>> I did look on line and nothing on line made any more sense.
>>
>> So, thank you for your help.
>>
>> Best regards,
>>
>> Neal Lewis
> Putting on my educator hat
> ....
> Not everyone understands the same way, people read the same words and
> assign different meaning to those words.
> So we need access to lots of different approaches.
>
> Putting on my moderator hat
> .....
> Officially this list does not support accounting discussions, but it
> is one of the things we do here, as well as how to use Gnucash.
>
> Liz
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
------------------------------
Message: 7
Date: Fri, 2 Sep 2022 10:18:30 +1000
From: Geoff <cleanoutmyshed at gmail.com>
To: Ruaraidh Sackville Hamilton <ruaraidh.sh at gmail.com>
Cc: Jacob Larsen <jacob at larsen.net>, gnucash-user
<gnucash-user at gnucash.org>
Subject: Re: [GNC] Online quotes for a mutual fund
Message-ID: <face14e3-ff59-07ae-76aa-dffdce7fe94e at gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Hi Ruaraidh
I think you are out of luck with Gilts. I have checked the web sites of Morningstar, Financial Times, Alphavantage, and Yahoo Finance; and none of them seem to be able to provide price data for Gilts securities.
I note that you can obtain price data directly from the LSX:- https://www.londonstockexchange.com/stock/TR29/united-kingdom/company-page
However none of the Finance Quote modules currently use the LSX as a data source.
Regards
Geoff
=====
On 24/08/2022 6:59 pm, Ruaraidh Sackville Hamilton wrote:
> Finding the right source and symbol seems a challenge! For several years
> I've been successfully?getting quotes through fq using the single source
> "Alphavantage, US"?for single UK equities, and the multiple-source "U.K.
> funds" for UK funds. However, I can't find anything that works for UK
> Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they
> appear on the LSE and FT websites. I've tried all sources listed in the
> GC help system that seem reasonably possible. Some examples:
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534
>
> all generate the error code
> ** This stock quote cannot be used by GnuCash!
>
> Does anyone have any experience with this?
>
> Regards,
>
> Ruaraidh
>
> On Mon, 17 May 2021 at 01:55, Geoff <cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>> wrote:
>
> Hi Jacob
>
> It looks like the Financial Times' Funds service will provide prices:
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
> ? ? ?symbol: SE0005993078? ? ? ? ?<=== required
> ? ? ? ?date: 05/12/2021? ? ? ? ? ?<=== recommended
> ? ?currency: DKK? ? ? ? ? ? ? ? ? <=== required
> ? ? ? ?last: 237.96? ? ? ? ? ? ? ?<=\
> ? ? ? ? nav: 237.96? ? ? ? ? ? ? ?<=== one of these
> ? ? ? price: 237.96? ? ? ? ? ? ? ?<=/
> ? ?timezone:? ? ? ? ? ? ? ? ? ? ? <=== optional
>
>
>
> Regards
>
> Geoff
> =====
>
> On 17/05/2021 7:35 am, Jacob Larsen wrote:
> > Hi
> >
> > I am trying to get online quotes for a few mutual funds I am
> tracking,
> > but I am having no luck, mostly because they don't really have any
> > symbols, only ISINs. Anyone have any ideas on how I proceed on
> this one?
> >
> > They are not available on Yahoo, but I found them on a few others
> > without succeeding gnc-fq-dump with any of them, this is one of them:
> >
> >
> https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK
> <https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK>
> >
> >
> https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F00000TH8X
> <https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F00000TH8X>
> >
> > https://www.investing.com/funds/nordnet-superfonden-danmark
> <https://www.investing.com/funds/nordnet-superfonden-danmark>
> >
> >
> > /Jacob
> >
> > _______________________________________________
> > 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
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists
> <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 <mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
> <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: 8
Date: Fri, 2 Sep 2022 13:04:31 +1000
From: Geoff Storer <go.storer.ben at gmail.com>
To: Jim DeLaHunt <list+gnucash at jdlh.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Change Linked Document Path
Message-ID:
<CANnWTVg6Q8=RqYpy3xwk7wk-=V0i7BEqf4q0HA+zBJjJC2YvRw at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Ok, thanks.
This is my first post!!
On Fri, Sep 2, 2022 at 8:16 AM Jim DeLaHunt <list+gnucash at jdlh.com> wrote:
> Geoff:
>
> One tenet of GnuCash-user email list etiquette is to cc the gnucash-user
> email list on all replies. We want this discussion to take place on the
> list.
>
> Thus I am replying to you, and cc'ing the list, so that the thread stays
> on the list. I will reply to this message from the email that reaches me
> via the list.
> ?Jim DeLaHunt
> On 2022-09-01 03:57, Geoff Storer wrote:
>
> Hi Jim
>
> Thanks for coming back to me. Sorry I have taken so long to respond.
>
> In answer to your questions:
>
> Q: Are you familiar with the difference in behaviour between relative file
> paths and absolute file paths?
>
> Ans; No this is not one of my strong points
>
> Q: Are you familiar with the difference in spelling (C:\ prefixes and
> backslashes etc.) between relative file paths and absolute file paths?
>
> Ans: No
>
> Q: In your GnuCash Book (bookkeeping file), have you associated files to
> transactions using relative path File Associations, absolute path File
> Associations, or Location Associations?
>
> Ans: I think the answer here is relative path. What I actually did in GNU
> was:
> Edit / preferences / General / Linked Files and with the drop down arrow
> selected the folder location of my invoices
> The reason I say "relative path" is because GNU program details on the
> referenced edit field the comment
> "Path head for Linked Files Relative Paths"
> The location I selected is - D:\PDF\GNU Invoices
>
> Q: Were all your attached documents within a single directory on your old
> computer? Do you know the absolute path to that directory?
>
> Ans: Yes all invoices are in the one folder "D:\PDF\GNU Invoices" (the
> output here I copied directly from my explorer view so I should have that
> correct)
>
> Q: Are all your attached documents within a single directory on your new
> computer? Do you know the absolute path to that directory?
>
> Ans: The invoices are in the exact location as on the initial install of
> GNU.
> I only re-installed windows on the C:\ partition. The other
> partitions remain exactly as they were
> The invoices are in "D:\PDF\GNU Invoices"
>
> I hope I have answered all your queries. Let me know if you need any
> further clarification.
>
> Thanks again
>
> Regards
>
> John Murdoch
>
> On Tue, Aug 30, 2022 at 3:46 PM Jim DeLaHunt <list+gnucash at jdlh.com>
> wrote:
>
>> Hello, John:
>>
>> Your question rings a bell! I did an overhaul on the file associations
>> on my transactions a couple of years ago.
>>
>> On 2022-08-29 04:10, john murdoch wrote:
>> > ...My problem now is that [GnuCash] looks for the attached document in
>> the
>> > windows document folder on the C Drive. I have tried editing the
>> > preferences in [GnuCash] to point to the correct location of the
>> documents
>> > on the alternate partition but this doesn't automatically link to the
>> > document.
>> >
>> >
>> > I can then manually link each document by using the "manage document
>> > link" function on the right click menu in the account field of GNU
>> > cash. That of course will be quite tedious and I was enquiring if
>> > there is a "global fix" so that all files could be re-linked in one
>> > procedure? Perhaps editing settings or the system registry?
>> >
>> >
>> > I did try a feature as per the attached screenshot [of the Change
>> Linked Document path head dialogue] without any success.
>>
>> Well, the Change Linked Document path head dialogue, which your
>> screenshot showed, is the best tool in GnuCash for this job. However,
>> you have to know a few things to use it well. I'll bet the UI does not
>> do a complete job of walking a person through it.
>>
>> To set some groundwork, some questions:
>>
>> Are you familiar with the difference in behaviour between relative file
>> paths and absolute file paths?
>>
>> Are you familiar with the difference in spelling (C:\ prefixes and
>> backslashes etc.) between relative file paths and absolute file paths?
>>
>> In your GnuCash Book (bookkeeping file), have you associated files to
>> transactions using relative path File Associations, absolute path File
>> Associations, or Location Associations?
>>
>> Were all your attached documents within a single directory on your old
>> computer? Do you know the absolute path to that directory?
>>
>> Are all your attached documents within a single directory on your new
>> computer? Do you know the absolute path to that directory?
>>
>> Based on answers to those questions ? and once I run GnuCash to refresh
>> my memory about how the Change Linked Document path head dialogue works,
>> and once I translate from macOS to Windows in my head ? I can try to
>> help you further.
>>
>> Best regards,
>> ?Jim DeLaHunt
>>
>>
>> Are all your attached documents within a single directory on your new
>> computer?
>>
>>
>>
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
------------------------------
Message: 9
Date: Fri, 2 Sep 2022 15:43:19 +1000
From: Richard Gaede <arg at speedweb.com.au>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: [GNC] Display report values in whole curremcy units
Message-ID: <cc3503d2-3aa4-de3e-c3e8-81c86e85cef4 at speedweb.com.au>
Content-Type: text/plain; charset=UTF-8; format=flowed
I would like to be able to print reports which display numbers in whole
currency unit values. I have experimented with Preferences which only
allow going to 1 decimal place. Even when I do that,registers and
reports still display 2 decimal places.
Is what I want to do achievable in Gnucash? If so what am I missing?
Advice appreciated.
Thanks & regards
--
------------------------------
Message: 10
Date: Fri, 2 Sep 2022 16:13:53 +1000
From: Geoff <cleanoutmyshed at gmail.com>
To: Richard Gaede <arg at speedweb.com.au>, Gnucash Users
<gnucash-user at gnucash.org>
Subject: Re: [GNC] Display report values in whole curremcy units
Message-ID: <65a29639-6e8c-028c-3472-fadced7c00bd at gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Hi Richard
No, nothing has changed since you last asked this question:
https://lists.gnucash.org/pipermail/gnucash-user/2019-January/082136.html
Regards
Geoff
=====
On 2/09/2022 3:43 pm, Richard Gaede via gnucash-user wrote:
> I would like to be able to print reports which display numbers in whole
> currency unit values. I have experimented with Preferences which only
> allow going to 1 decimal place. Even when I do that,registers and
> reports still display 2 decimal places.
>
> Is what I want to do achievable in Gnucash? If so what am I missing?
>
> Advice appreciated.
>
> Thanks & regards
>
------------------------------
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
-----
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 234, Issue 3
********************************************
More information about the gnucash-user
mailing list