Re: [GNC] Deleting Multiple Transactions

2019-11-18 Thread Ken via gnucash-user
Source of information was: https://money.stackexchange.com/questions/91861/how-to-delete-multiple-transaction-at-once-in-gnucash. The user who gave the information was not named. The only thing I changed was explaining where I used it compared to in the post where the user said he/she

Re: [GNC] Deleting Multiple Transactions

2019-11-18 Thread David Carlson
Ken, Would you care to give credit to your source? Also, if you have modified it, you might note where you have changed it. David Carlson On Mon, Nov 18, 2019 at 11:04 PM wrote: > To all gnu-cash users --- found this on the net today and it was a > lifesaver. Not sure if anyone else needs

[GNC] Deleting Multiple Transactions

2019-11-18 Thread pyz01
To all gnu-cash users --- found this on the net today and it was a lifesaver. Not sure if anyone else needs it - but it was extremely helpful for me. "How can I delete multiple transactions in a batch in GnuCash?" For me I made a copy of my current file. Then on the copy I wanted to delete

Re: [GNC] How to assign a pre-existing payment to a bill?

2019-11-18 Thread Fran_3 via gnucash-user
Great. Thank you for the help Greg. Fran3 On Monday, November 18, 2019, 11:28:12 AM EST, Greg Feneis wrote: What about right click transaction and select assign as payment? Kind regards, Greg Feneis (Pixel 3) On Mon, Nov 18, 2019, 06:14 Fran_3 via gnucash-user <

Re: [GNC] How to assign a pre-existing payment to a bill?

2019-11-18 Thread Fran_3 via gnucash-user
Perfect. Thank you. On Monday, November 18, 2019, 11:20:21 AM EST, Geert Janssens wrote: Op maandag 18 november 2019 15:10:55 CET schreef Fran_3 via gnucash-user: > How can I assign a recorded Payment in gnuCash written to a vendor... > As a payment for the Bill that was posted after

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Michael or Penny Novack
I think PART of this problem is confusion about "another user". Remember that need not be another human being. YOU perhaps have more than one log in << say one with administrator rights and then a another for regular use >> Rather than "in use" the terminology MIGHT be "checked out but not

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
Thanks very much, Frank. I didn't quite understand the difference between gnc-fq-dump and gnc-fq-helper. My data retrieval method name contained digits and gnc-fq-helper did not allow them. I changed the method name to contain letters only and it works fine now. Best,Derek  On Monday,

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Frank H. Ellenberger
Hello Derek, Am Mo., 18. Nov. 2019 um 17:28 Uhr schrieb Derek Robinson via gnucash-user : > > Apologies - I don't know why the linebreaks didn't work in my last message. > Please disregard that (unreadable) version. Tip: To avoid reformatting of source file send them as attachments instead of

Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

2019-11-18 Thread Richard Danielson
Yep.  Thanks. Rick On 2019-11-18 11:44 a.m., Adrien Monteleone wrote: On Nov 18, 2019 w47d322, at 8:22 AM, Derek Atkins wrote: Rick, Richard Danielson writes: Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, snacks and restaurants in the food category) which

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
Solved. gnc-fq-dump worked fine, but gnc-fq-helper (method "symbol") didn't. Noticed the following comment in the parse_input_line method of gnc-fq-helper:   # Make sure we have an opening ( preceded only by whitespace.   # and followed by a one word method name composed of [a-z_]+.   # Also

Re: [GNC] Removing Orphan components from transaction

2019-11-18 Thread Adrien Monteleone
True. I’ve used that method many times as well. (and mentioned it in my other post) But you can’t use the ‘delete split’ option in the right-click menu, sorry if I wasn’t clear about that. Regards, Adrien > On Nov 18, 2019 w47d322, at 12:04 PM, D wrote: > > If you delete every data element

Re: [GNC] Removing Orphan components from transaction

2019-11-18 Thread D via gnucash-user
If you delete every data element in the anchor split, and TAB of the end, the split will be deleted, and the transaction will disappear from the register. I've been using this technique for years to clear out the Imbalance-USD account when items appear there. D. On November 18, 2019, at 11:25

Re: [GNC] Removing Orphan components from transaction

2019-11-18 Thread Adrien Monteleone
> On Nov 18, 2019 w47d322, at 11:23 AM, David Carlson > wrote: > > > You can’t delete a split that is for the account in the current register. > (that is what anchors it to that account) > > Yes, you can delete an anchor split and that is what I noted in my previous > message. I called it

Re: [GNC] Locked out of gnucash

2019-11-18 Thread D via gnucash-user
Clearly, I am in the minority here. I'll drop out of this conversation now. David T. On November 18, 2019, at 10:26 PM, Stan Brown wrote: On 2019-11-18 08:56, D wrote: > Adding to the error message to account for when the software crashes > seems like overkill (as does linking to the

Re: [GNC] Removing Orphan components from transaction

2019-11-18 Thread David Carlson
On Mon, Nov 18, 2019 at 10:50 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Nov 17, 2019 w47d321, at 11:14 PM, Peter West wrote: > > > > I found a transaction in Orphan-AUD. It was a split, and the Orphan > component was zero. Maybe I had forgotten part of the split,

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Maf. King
On Monday, 18 November 2019 16:51:14 GMT Adrien Monteleone wrote: > I agree, using the PID won’t work, because although GnuCash is not (yet) a > multi-user app, some people do use it from various machines with the file > stored on a network. A PID check won’t mean anything to one machine when >

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Adrien Monteleone
> On Nov 18, 2019 w47d322, at 9:17 AM, D via gnucash-user > wrote: > > > > On November 18, 2019, at 8:02 PM, Derek Atkins wrote: > >> Hi, >> I think I have a suggestion for some better wording. See below. >> How about: >> The data file is currently in use. Most likely this means that

Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

2019-11-18 Thread Adrien Monteleone
David, GnuCash can show you the balance of a parent account as two different things on reports and in the CoA: 1. Actual balance of the account (sum of debits and credits in that one account) 2. The sum of the balances of each of the child accounts (what Derek called ‘roll-up’)

Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

2019-11-18 Thread Adrien Monteleone
> On Nov 18, 2019 w47d322, at 8:22 AM, Derek Atkins wrote: > > Rick, > > Richard Danielson writes: > >> Re the subtotals issue, I used to have a number of subtotals >> (e.g. groceries, snacks and restaurants in the food category) which >> showed up in income accounts. That is what I can't

Re: [GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
One small correction - there should be a line break in the following statement: # Extract first table.  my $te = HTML::TableExtract->new( headers => [qw(Date Price)] ); ... so it's actually # Extract first table. my $te = HTML::TableExtract->new( headers => [qw(Date Price)] ); On Monday,

Re: [GNC] Removing Orphan components from transaction

2019-11-18 Thread Adrien Monteleone
> On Nov 17, 2019 w47d321, at 11:14 PM, Peter West wrote: > > I found a transaction in Orphan-AUD. It was a split, and the Orphan component > was zero. Maybe I had forgotten part of the split, and then corrected it, > leaving nothing in the Orphan-AUD account. > > I wanted to remove this

Re: [GNC] How to assign a pre-existing payment to a bill?

2019-11-18 Thread Greg Feneis
What about right click transaction and select assign as payment? Kind regards, Greg Feneis (Pixel 3) On Mon, Nov 18, 2019, 06:14 Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > How can I assign a recorded Payment in gnuCash written to a vendor... > As a payment for the Bill that

Re: [GNC] How to assign a pre-existing payment to a bill?

2019-11-18 Thread Geert Janssens
Op maandag 18 november 2019 15:10:55 CET schreef Fran_3 via gnucash-user: > How can I assign a recorded Payment in gnuCash written to a vendor... > As a payment for the Bill that was posted after the payment was made? > Must I delete the deposit/payment and then re-create it as a payment for >

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Derek Atkins
David, On Mon, November 18, 2019 10:27 am, David Carlson wrote: > I like Derek 's suggestion but I would see that and call with this > suggestion: > > There is a lock on the selected data file. Most likely this means that > the data file was not cleanly closed (due to a crash) after it was

[GNC] (Reformatted) Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
Apologies - I don't know why the linebreaks didn't work in my last message. Please disregard that (unreadable) version. New to the list - please direct me to previous posts if I've missed something that will explain what's happening. I wrote a custom F::Q module to extract daily "prices" from

Re: [GNC] Locked out of gnucash

2019-11-18 Thread David Carlson
On Mon, Nov 18, 2019 at 10:01 AM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Am Mo., 18. Nov. 2019 um 16:28 Uhr schrieb David Carlson > : > > > > I like Derek 's suggestion but I would see that and call with this > suggestion: > > > > There is a lock on the selected data file.

[GNC] Crash with no information when using custom F::Q module

2019-11-18 Thread Derek Robinson via gnucash-user
New to the list - please direct me to previous posts if I've missed something that will explain what's happening. I wrote a custom F::Q module to extract daily "prices" from Vanguard 529 plan portfolios that are not traded on exchanges. I believe I've done that correctly. When I run

Re: [GNC] Locked out of gnucash

2019-11-18 Thread D via gnucash-user
On November 18, 2019, at 9:12 PM, Colin Law wrote: >Perhaps a message saying "Error 5135 if you don't understand what this >means then you should have read the wiki" would be a solution. >Colin Certainly, it could be. But it wouldn't be a good one, and I think you should know I wasn't

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Frank H. Ellenberger
Am Mo., 18. Nov. 2019 um 16:28 Uhr schrieb David Carlson : > > I like Derek 's suggestion but I would see that and call with this > suggestion: > > There is a lock on the selected data file. Most likely this means that the > data file was not cleanly closed (due to a crash) after it was last

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Colin Law
On Mon, 18 Nov 2019 at 13:59, D via gnucash-user wrote: > ... > Remember that the lock file and this check exist firstly to prevent multiple > users from opening the file at one time--and that is still a possibility. That may be reason for the test but it is not the most common cause. In fact

Re: [GNC] Locked out of gnucash

2019-11-18 Thread David Carlson
I like Derek 's suggestion but I would see that and call with this suggestion: There is a lock on the selected data file. Most likely this means that the data file was not cleanly closed (due to a crash) after it was last opened. If you are sure that it is not currently in use by you or

Re: [GNC] Locked out of gnucash

2019-11-18 Thread D via gnucash-user
On November 18, 2019, at 8:02 PM, Derek Atkins wrote: >Hi, >I think I have a suggestion for some better wording.  See below. >How about: >The data file is currently in use.  Most likely this means that the data >file was not cleanly closed (due to a crash) after it was last opened. >If you are

Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

2019-11-18 Thread David Carlson
Derek, If what you call a rolling balance is what I call a running balance, then I think that the account register view will show that when it is sorted in chronological order. In fact, as others have already noted, you can see that in your top level accounts. Where you won't see it is in

Re: [GNC] Tel Aviv Stock Exchange (TASE)

2019-11-18 Thread Derek Atkins
Julian Schamroth writes: > How can one access stock prices from the TASE? Is there a website where quotes are available? You'll need to update Finance::Quote to grab from there. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Derek Atkins
Hi, I think I have a suggestion for some better wording. See below. David Carlson writes: > I think a better and more accurate wording would be "The data file has not > been cleanly closed since it was last opened. If you are sure that it was > not opened by another user, click 'Open

Re: [GNC] Tel Aviv Stock Exchange (TASE)

2019-11-18 Thread Frank H. Ellenberger
Hello Julian, AFAIK there is currently no module to do it automatically in finance-quote. So you have to do it manually: 1. go to e.g. https://info.tase.co.il/eng/MarketData/Stocks/MarketData/Pages/MarketData.aspx and download the csv file. There is a button "Export Table Data" at the bottom. 2.

Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable

2019-11-18 Thread Derek Atkins
Rick, Richard Danielson writes: > Re the subtotals issue, I used to have a number of subtotals > (e.g. groceries, snacks and restaurants in the food category) which > showed up in income accounts.  That is what I can't figure out in GC.  > I can make accounts sub-accounts for heading accounts,

Re: [GNC] QIF import - Failed

2019-11-18 Thread Derek Atkins
HI, D via gnucash-user writes: [snip] > One common problem is that the dates in the file do not match the > locale settings. That is, your file has DD-MM- but your locale > uses MM-DD-. The QIF Importer doesn't require this matching, and indeed has lots of logic to test for four common

[GNC] How to assign a pre-existing payment to a bill?

2019-11-18 Thread Fran_3 via gnucash-user
How can I assign a recorded Payment in gnuCash written to a vendor... As a payment for the Bill that was posted after the payment was made? Must I delete the deposit/payment and then re-create it as a payment for that particular Bill or what? Also... How can I assign a pre-existing deposit in

Re: [GNC] Locked out of gnucash

2019-11-18 Thread D via gnucash-user
I don't really agree. David's wording identifies one situation for this dialog, and not even the primary reason for the lock file in the first place. Remember that the lock file and this check exist firstly to prevent multiple users from opening the file at one time--and that is still a

[GNC] Tel Aviv Stock Exchange (TASE)

2019-11-18 Thread Julian Schamroth
How can one access stock prices from the TASE? ___ 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,

Re: [GNC] Locked out of gnucash

2019-11-18 Thread Stan Brown
I think David Carlson's suggestion is better than mine. I had hoped to spark a discussion on this point, so I didn't expect my version would be the final one. I'm delighted that it is being looked at, and benefit to users will result. -- Regards, Stan Brown Tompkins County, New York, USA