Re: [GNC] print check register

[Chris Tsuji]

   David
   Thank you
   How about printing a range of date.
   Example 6/1/18 to 7/1/19
   Thanks in advance.
   chris tsuji

   Sent: Tuesday, July 02, 2019 at 7:57 PM
   From: "David T." 
   To: "cts...@cheerful.com" ,
   "gnucash-user@gnucash.org" 
   Subject: Re: [GNC] print check register
   While in the register, try Reports->Account Report.


   HTH,
   David



   On Wed, Jul 3, 2019 at 6:40, Chris Tsuji
wrote:



   HI
   How do you print the check register?
   thanks
   Chris Tsuji
   ___
   gnucash-user mailing list
   [1]gnucash-user@gnucash.org
   To update your subscription preferences or to unsubscribe:
   [2]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   If you are using Nabble or Gmane, please see
   [3]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.

References

   1. mailto:gnucash-user@gnucash.org
   2. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   3. https://wiki.gnucash.org/wiki/Mailing_Lists
___
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, 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.

Re: [GNC] print check register

[David T. via gnucash-user]

While in the register, try Reports->Account Report. 

HTH,David
 
 
  On Wed, Jul 3, 2019 at 6:40, Chris Tsuji wrote:   

HI
How do you print the check register?
thanks
Chris Tsuji
___
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, 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@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.

Re: [GNC] Balance sheet report period

[D via gnucash-user]

Rich,

Although it might not be fully clear, the Guide states that the Balance Sheet 
report "provides totals as of a given date."

Therefore, there is no starting date; it covers everything up to the date you 
provide. That is how it is designed and how it is meant to be.

Best,
David

On July 3, 2019, at 1:54 AM, Rich Shepard  wrote:

Looking in the Guide the only reference I see to 'balance sheet report' is a
brief description. When I prepare the report the only date option I see is
the ending date.

Is the start date that of the first entry in GnuCash? Can I produce a
balancve sheet account for only the year-to-date and exclude previous years?
Or does that violate accounting practices?

Rich
___
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, 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@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.

[GNC] print check register

[Chris Tsuji]

HI
How do you print the check register?
thanks
Chris Tsuji
___
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, 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.

Re: [GNC] cut/paste problem in 3.4?

[David Carlson]

Working with release 2.6.19 in Ubuntu 18.04 I also noticed that the
transaction  copy or cut action does not use the clipboard there either.  I
didn't have time to test pasting, however.

David Carlson



On Tue, Jul 2, 2019, 2:45 PM Paul Kinzelman  wrote:

> Thanks for your replies, also to David T, your way of moving a transaction
> had not occurred to me before. I'll try that next time.
> I figured the copy/paste would work more easily, hadn't occurred to me
> that it was for going between different files.
>
> I'm just curious where GC stashes the transaction, doesn't seem to be
> on the standard copy/paste clipboard because I don't see it when I
> paste into a text editor. But it has to go someplace globally to be able
> to move between 2 different GC files.
>
> BTW, the transaction was same currency, same file, vanilla transaction.
> And Adrien, your test case captured what I did.
>
> And I don't think it's the keyboard, these laptop keys are pretty tight and
> I haven't spilled coffee or beer on it. :-) The control and C keys always
> work at other times reliably.
>
> I think the best thing to do at this point is to declare victory and move
> on
> because it's not repeatable. Maybe play with it a bit if it happens again.
>
> On 7/2/2019 1:23 PM, gnucash-user-requ...@gnucash.org wrote:
> > So, until or unless you could make it repeat the issue intentionally and
> repeatedly with the same steps, I?m afraid this one will have to be offered
> up to the digital gods to sort out.
> >
> > Finally, don?t discount a key not functioning. I?ve run myself ragged
> trying to figure out keyboard shortcuts not working properly (especially
> with cmd/ctrl/alt keys) only to discover that after removing the key caps,
> I saw some gunk underneath that was preventing the keypress from
> registering, though I was banging the heck out of it. A little cleaning
> with a q-tip and some rubbing alcohol, and... "magic!?  You can bring up an
> onscreen keyboard viewer that will highlight a key as you press it. Using
> that, you might see if the CTRL key is sticking or missing. (and test the
> other CTRL key as well)
>
> ___
> 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, 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@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.

Re: [GNC] Multicolumn Reports

[Jay Ridgley]

On 7/2/19 2:52 PM, Stan Brown wrote:

This workaround might be helpful.

Reports are all HTML files in your temp folder, so you can access that
folder and then open the report in your Web browser. From there, you
should be able to print it in landscape.

To save the report, you can just click and drag it to your preferred
location. I haven't tried this part, but I expect that if you try to do
that while GC still has it open, Windows won't allow you to move it. In
that case, try copying it instead of moving it.

1. To open your temp folder, either Start » Run » %TEMP%, or open file
explorer, highlight the location bar at the top of the window, and type
%TEMP%

2. To copy a file instead of moving it, RIGHT-click it in the %TEMP%
folder window, then while keeping the mouse button depressed drag it to
the desired location. When you release the mouse button, a small menu
appears: select Copy. As an alternative, single-click the file in the
%TEMP% window and press Ctrl+C, then open a window to the desired
location, click into an empty spot, and press Ctrl+V.



THANKS Stan,

Got'er done!

Cheers,
Jay

--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320
___
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, 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.

Re: [GNC] Employees function fields

[Derek Atkins]

Hi,

"Scott A. Wozny"  writes:

> GNUCash Gurus,
>
> I have a couple questions about the Employees section of GNUCash.  I
> have gone through all the available online documentation I was able to
> find and tried searching the list archives but wasn’t able to locate
> what I needed so I thought I’d try posting to the list.
>
> 1) What is the purpose of the Username field when creating a new user.
> If the employee is uniquely identified by the Employee Number field,
> what does the Username field add / do differently?

Nothing.  It was put in for future features which have never been
implemented.

> 2) What is the Credit Account field in the Billing section for?  At
> first I thought it would be the credit account for vouchers (i.e. the
> A/P liability) but that seems to be handled at the point I post a
> voucher and this field only allows me to choose accounts of type
> Credit Card so I’m at a loss as to its purpose. The docs don’t say
> anything about it other than that it exists so I thought I’d inquire
> here.

It would be for an employee's credit card.  I.e., if the employee has a
company card, this would be the card's account.  It's used in the "Cash"
vs "Card" option in an expense voucher.  Cash implies pay the employee
by check.  Card implies pay the card.

> Thanks very much,
>
> Scott

> 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
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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, 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.

[GNC] Balance sheet report period

[Rich Shepard]

Looking in the Guide the only reference I see to 'balance sheet report' is a
brief description. When I prepare the report the only date option I see is
the ending date.

Is the start date that of the first entry in GnuCash? Can I produce a
balancve sheet account for only the year-to-date and exclude previous years?
Or does that violate accounting practices?

Rich
___
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, 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.

Re: [GNC] Multicolumn Reports

[Adrien Monteleone]

Try to copy/paste into a spreadsheet, or export and open with a spreadsheet 
app. Some people have luck with Excel, but I’ve heard of better results with 
Libre/OpenOffice.

From there, you can format to your heart’s content, including landscape 
orientation.

Regards,
Adrien

> On Jul 2, 2019, at 2:21 PM, Jay Ridgley  wrote:
> 
> Good Afternoon,
> 
> I have formated a multicolumn report and have it showing on my screen, 
> however, if I save or try to print it the report is truncated on the right 
> side. How do I get the entire report to print.
> 
> I am also unable to have the report print oriented as landscape, the system 
> only allows for portrait.
> 
> I am running GnuCash 2.6.17 under Ubuntu 16.04.6 LTS
> 
> This is the final report needed for our fiscal year end 06/30/2019 (FY2018).
> 
> What have I missed?
> 
> Regards,
> Jay

___
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, 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.

Re: [GNC] cut/paste problem in 3.4?

[Paul Kinzelman]

Thanks for your replies, also to David T, your way of moving a transaction
had not occurred to me before. I'll try that next time.
I figured the copy/paste would work more easily, hadn't occurred to me
that it was for going between different files.

I'm just curious where GC stashes the transaction, doesn't seem to be
on the standard copy/paste clipboard because I don't see it when I
paste into a text editor. But it has to go someplace globally to be able
to move between 2 different GC files.

BTW, the transaction was same currency, same file, vanilla transaction.
And Adrien, your test case captured what I did.

And I don't think it's the keyboard, these laptop keys are pretty tight and
I haven't spilled coffee or beer on it. :-) The control and C keys always
work at other times reliably.

I think the best thing to do at this point is to declare victory and move on
because it's not repeatable. Maybe play with it a bit if it happens again.

On 7/2/2019 1:23 PM, gnucash-user-requ...@gnucash.org wrote:

So, until or unless you could make it repeat the issue intentionally and 
repeatedly with the same steps, I?m afraid this one will have to be offered up 
to the digital gods to sort out.

Finally, don?t discount a key not functioning. I?ve run myself ragged trying to 
figure out keyboard shortcuts not working properly (especially with cmd/ctrl/alt 
keys) only to discover that after removing the key caps, I saw some gunk underneath 
that was preventing the keypress from registering, though I was banging the heck out 
of it. A little cleaning with a q-tip and some rubbing alcohol, and... "magic!? 
 You can bring up an onscreen keyboard viewer that will highlight a key as you press 
it. Using that, you might see if the CTRL key is sticking or missing. (and test the 
other CTRL key as well)


___
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, 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.

[GNC] Multicolumn Reports

[Jay Ridgley]

Good Afternoon,

I have formated a multicolumn report and have it showing on my screen, 
however, if I save or try to print it the report is truncated on the 
right side. How do I get the entire report to print.


I am also unable to have the report print oriented as landscape, the 
system only allows for portrait.


I am running GnuCash 2.6.17 under Ubuntu 16.04.6 LTS

This is the final report needed for our fiscal year end 06/30/2019 (FY2018).

What have I missed?

Regards,
Jay
--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320
___
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, 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.

Re: [GNC] Moving invoice transaction detail to new or different invoice

[Adrien Monteleone]

Not that I’m aware of. The closest you could get would be to have them both 
open and do a cut/paste operation, but since you have to do that for each cell 
on the line, you might as well just re-type it.


Regards,
Adrien

> On Jul 2, 2019, at 12:23 PM, WB5FDP  wrote:
> 
> In the past I have just deleted an entry on the invoice before it is posted
> and created it on a new invoice. I was thinking there must be a way to
> simply "move" a line-item to an existing invoice, under a different job.
> 
> 
> 
> Is this possible?
> 
> 
> 
> Rick

___
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, 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.

Re: [GNC] Import Customers to Acct Rec

[Adrien Monteleone via gnucash-user]

Check the Tutorial & Concepts Guide, Chapter 18.2 — Importing Customers & 
Vendors.

Regards,
Adrien

> On Jul 2, 2019, at 12:49 PM, Bruce Irving via gnucash-user 
>  wrote:
> 
> I use GC with a club that currently has about 100 members, any can become A/R 
> Customers.  I would like to import all of my members into A/R Customers from 
> my Excel member sheet. but have been unable to find any way to do this (All I 
> have found is importing transactions.)  I can convert my list to CSV and, 
> since there a lot of columns that are not needed, I can remove them.  Is 
> there any way I can import these members?


___
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, 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.

[GNC] Import Customers to Acct Rec

[Bruce Irving via gnucash-user]

I use GC with a club that currently has about 100 members, any can become A/R 
Customers.  I would like to import all of my members into A/R Customers from my 
Excel member sheet. but have been unable to find any way to do this (All I have 
found is importing transactions.)  I can convert my list to CSV and, since 
there a lot of columns that are not needed, I can remove them.  Is there any 
way I can import these members?

Bruce Preach the Gospel wherever you go.  If necessary, use words.
___
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, 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.

[GNC] Moving invoice transaction detail to new or different invoice

[WB5FDP]

In the past I have just deleted an entry on the invoice before it is posted
and created it on a new invoice. I was thinking there must be a way to
simply "move" a line-item to an existing invoice, under a different job.

 

Is this possible?

 

Rick

 

___
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, 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.

Re: [GNC] Version 3.6 crashes on MacOS 10.14.5

[John Ralls]

If there's no crash log it's likely that Gatekeeper just failed to start it 
after verification. If that's the case it will start up normally the next time 
you launch it.

Regards,
John Ralls


> On Jul 2, 2019, at 8:23 AM, Adrien Monteleone via gnucash-user 
>  wrote:
> 
> There is a tracefile, but make sure to create a copy of it somewhere else 
> because it gets overwritten with the next launch.
> 
> Instructions here: http://wiki.gnucash.org/wiki/Tracefile
> 
> Also, was a crash report not generated when it blew up? Usually MacOS creates 
> and displays a crash report on screen. You can copy and paste the contents to 
> a file and attach them to a bug report. (do not copy and paste the crash or 
> the tracefile into a bug report comment, though, make sure to attach them as 
> text files)
> 
> If you happened to close that crash report, you should be able to find it 
> using Console.app.
> 
> Regards,
> Adrien
> 
>> On Jul 2, 2019, at 9:45 AM, Roderick Averill  
>> wrote:
>> 
>> I’m currently using version 3.4 with no issues.
>> 
>> I downloaded version 3.6-1 for the MacOS and when I open it, it immediately 
>> crashes.
>> 
>> Is there a log file that I can review?
>> 
>> Rod
> 
> ___
> 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, 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@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.

Re: [GNC] cut/paste problem in 3.4?

[Adrien Monteleone]

Paul,

Sorry for any time wasted or misdirection on my part. I re-read your original 
and subsequent posts and realized you were moving a transaction within the same 
book.

I’ve only ever heard this feature used in reference to moving/copying 
transactions between two open files, so I errantly presumed that was the case 
here, which is why I considered a window/mouse focus issue as in that case, the 
cut and paste would be in separate windows.

As noted in my other recent reply, I tested a cut/paste within the same book 
between two different registers and all went well, regardless of if I was 
cutting the debit or credit split.

So, until or unless you could make it repeat the issue intentionally and 
repeatedly with the same steps, I’m afraid this one will have to be offered up 
to the digital gods to sort out.

Finally, don’t discount a key not functioning. I’ve run myself ragged trying to 
figure out keyboard shortcuts not working properly (especially with 
cmd/ctrl/alt keys) only to discover that after removing the key caps, I saw 
some gunk underneath that was preventing the keypress from registering, though 
I was banging the heck out of it. A little cleaning with a q-tip and some 
rubbing alcohol, and... "magic!”  You can bring up an onscreen keyboard viewer 
that will highlight a key as you press it. Using that, you might see if the 
CTRL key is sticking or missing. (and test the other CTRL key as well)

Regards,
Adrien

> On Jul 2, 2019, at 11:02 AM, Paul Kinzelman  wrote:
> 
> Thanks for the suggestion, I'll try to remember that.
> I've been using gnucash for almost a year and I'd never seen it before
> tho I don't cut/paste whole transactions very often so I don't know
> when it'll come up again. I have done transaction copy/paste
> successfully in the past, so it is intermittent.
> 
> I don't think it's a focus problem or it would not have deleted the
> transaction from the source. I didn't focus in any other app between
> the cut and the paste, and the destination did focus when I clicked
> on the tab just before doing the paste.
> 
> So you're saying that if gnucash doesn't see a paste right after a cut,
> it puts the transaction back where it came from? That makes sense
> for it to do that.
> 
> But I'm curious, where does gnucash stash the cut transaction?
> It doesn't seem to be in the standard clipboard.
> 
> Now that you mention it, I have noticed that if I do a simple copy/paste
> of text between like Firefox and emacs (not in gnucash) sometimes it
> would not work (paste would get previous contents), so I've gotten
> into the habit of hitting ^C about 30 times (that many because I'm
> pissed that I have to do it more than once :-) whenever I want to copy.
> I've seen that behavior intermittently on W10 on a previous laptop and
> now on this one too. Maybe it's a W10 issue.
> 


___
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, 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.

Re: [GNC] cut/paste problem in 3.4?

[Adrien Monteleone]

I never cut and paste whole transactions either. I’ve always just re-assigned 
one of the splits. (either via jump if I’m changing the anchor split, or 
rarely, using the Journal)

I thought this function was used more for copying or moving transactions 
between two open files, so I’ve never bothered. (and changing account 
assignments seems more proper to me)

However, testing the feature just for this thread, I was able to successfully 
move a transaction from one register to another. (and back again)

This transaction had two splits for accounts A & B.

I entered the register for account A and cut it.

Then I opened the register for account C and pasted it.

GnuCash re-assigned the transaction to be between B & C. Account A was no 
longer involved. (I also tested the reverse, cutting from register B and 
posting in C. That also worked.)

It seems like a handy feature, but apparently has some hiccups on occasion.

I wonder, the OP didn’t note the currencies involved. Perhaps the intended 
target is in a different currency? (though I should think that one would have 
been obviously noted as a manual re-assignment should trigger the exchange rate 
dialog)

Regards,
Adrien



> On Jul 2, 2019, at 11:21 AM, sunfish62--- via gnucash-user 
>  wrote:
> 
> Paul,
> 
> I don't use the cut and paste transaction feature. If I want to move a
> transaction, I will change the account assignment for that split, which
> effectively moves the transaction from one register to another.
> 
> I would wonder at the utility of cut and paste in this example. A
> transaction contains two entries, each associated with a specific account,
> say accounts A & B. If I were to copy the transaction and paste it into
> account C, there would be nothing to connect the transaction with account C,
> and the transaction would "re-appear" in accounts A & B, but not appear in
> account C. This is, in fact the behavior you originally described.
> 
> If, instead, you follow my approach, you would open account A, change the
> entry for either A or B to account C, and save the transaction. The
> transaction would disappear from the account you changed from, and appear in
> account C instead. 
> 
> Note that if you change A to C while in the register for account A and press
> "Enter," GnuCash may complain about removing the anchor split. I have found
> that Tabbing through the line will allow you to proceed anyway.
> 
> David T.


___
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, 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.

Re: [GNC] cut/paste problem in 3.4?

[sunfish62--- via gnucash-user]

Paul,

I don't use the cut and paste transaction feature. If I want to move a
transaction, I will change the account assignment for that split, which
effectively moves the transaction from one register to another.

I would wonder at the utility of cut and paste in this example. A
transaction contains two entries, each associated with a specific account,
say accounts A & B. If I were to copy the transaction and paste it into
account C, there would be nothing to connect the transaction with account C,
and the transaction would "re-appear" in accounts A & B, but not appear in
account C. This is, in fact the behavior you originally described.

If, instead, you follow my approach, you would open account A, change the
entry for either A or B to account C, and save the transaction. The
transaction would disappear from the account you changed from, and appear in
account C instead. 

Note that if you change A to C while in the register for account A and press
"Enter," GnuCash may complain about removing the anchor split. I have found
that Tabbing through the line will allow you to proceed anyway.

David T.

-Original Message-
From: gnucash-user  On
Behalf Of Paul Kinzelman
Sent: Tuesday, July 2, 2019 9:32 PM
To: Gnucash Elist 
Subject: Re: [GNC] cut/paste problem in 3.4?

Thanks for the suggestion, I'll try to remember that.
I've been using gnucash for almost a year and I'd never seen it before tho I
don't cut/paste whole transactions very often so I don't know when it'll
come up again. I have done transaction copy/paste successfully in the past,
so it is intermittent.

I don't think it's a focus problem or it would not have deleted the
transaction from the source. I didn't focus in any other app between the cut
and the paste, and the destination did focus when I clicked on the tab just
before doing the paste.

So you're saying that if gnucash doesn't see a paste right after a cut, it
puts the transaction back where it came from? That makes sense for it to do
that.

But I'm curious, where does gnucash stash the cut transaction?
It doesn't seem to be in the standard clipboard.

Now that you mention it, I have noticed that if I do a simple copy/paste of
text between like Firefox and emacs (not in gnucash) sometimes it would not
work (paste would get previous contents), so I've gotten into the habit of
hitting ^C about 30 times (that many because I'm pissed that I have to do it
more than once :-) whenever I want to copy.
I've seen that behavior intermittently on W10 on a previous laptop and now
on this one too. Maybe it's a W10 issue.


On 7/1/2019 9:35 PM, gnucash-user-requ...@gnucash.org wrote:
> Date: Mon, 1 Jul 2019 16:23:26 -0500
> From: Adrien Monteleone
> To: Users Gnucash
> Subject: Re: [GNC] cut/paste problem in 3.4?
> Message-ID:<72f7c2e7-232e-4308-9665-66e8538ec...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>
> Might indeed be a stray cosmic ray, or temporarily insane electrons, but
this stood out for me:
>
>> Earlier when I saw the problem, the cut did work, the transaction 
>> vanished from the source account, but when I pasted it into the 
>> destination account, it magically appeared again in the source 
>> account but not the destination account.
> My first suspicion would be a mouse/window focus problem. It did paste it,
but not in the window you were expecting it to. Since you can paste into
emacs, the problem is either intermittent, or somehow limited to GnuCash.
>
> I do know GnuCash on MacOS at least, has a focus problem where you 
> must click the title bar sometimes to get it to accept input even 
> though the window ?appears? to be in focus. If that?s your OS, do a 
> search for some threads in the last 6-8 months and something might pop 
> up. I think though this isn?t a GnuCash bug, but a GTK+ bug. (if I 
> recall correctly.)
>
> Maybe do a trial with clicking the GnuCash title bar first, then pasting,
and see which window it gets pasted into.

___
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, 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@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.

Re: [GNC] ​Re: ?Re: Using Mint

[Jimmy R via gnucash-user]

I tried on my Mint 19.1 Bionic

Would not install, dependencies error

Jimmy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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, 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.

Re: [GNC] cut/paste problem in 3.4?

[Paul Kinzelman]

Thanks for the suggestion, I'll try to remember that.
I've been using gnucash for almost a year and I'd never seen it before
tho I don't cut/paste whole transactions very often so I don't know
when it'll come up again. I have done transaction copy/paste
successfully in the past, so it is intermittent.

I don't think it's a focus problem or it would not have deleted the
transaction from the source. I didn't focus in any other app between
the cut and the paste, and the destination did focus when I clicked
on the tab just before doing the paste.

So you're saying that if gnucash doesn't see a paste right after a cut,
it puts the transaction back where it came from? That makes sense
for it to do that.

But I'm curious, where does gnucash stash the cut transaction?
It doesn't seem to be in the standard clipboard.

Now that you mention it, I have noticed that if I do a simple copy/paste
of text between like Firefox and emacs (not in gnucash) sometimes it
would not work (paste would get previous contents), so I've gotten
into the habit of hitting ^C about 30 times (that many because I'm
pissed that I have to do it more than once :-) whenever I want to copy.
I've seen that behavior intermittently on W10 on a previous laptop and
now on this one too. Maybe it's a W10 issue.


On 7/1/2019 9:35 PM, gnucash-user-requ...@gnucash.org wrote:

Date: Mon, 1 Jul 2019 16:23:26 -0500
From: Adrien Monteleone
To: Users Gnucash
Subject: Re: [GNC] cut/paste problem in 3.4?
Message-ID:<72f7c2e7-232e-4308-9665-66e8538ec...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

Might indeed be a stray cosmic ray, or temporarily insane electrons, but this 
stood out for me:


Earlier when I saw the problem, the cut did work,
the transaction vanished from the source account, but
when I pasted it into the destination account, it magically appeared again
in the source account but not the destination account.

My first suspicion would be a mouse/window focus problem. It did paste it, but 
not in the window you were expecting it to. Since you can paste into emacs, the 
problem is either intermittent, or somehow limited to GnuCash.

I do know GnuCash on MacOS at least, has a focus problem where you must click 
the title bar sometimes to get it to accept input even though the window 
?appears? to be in focus. If that?s your OS, do a search for some threads in 
the last 6-8 months and something might pop up. I think though this isn?t a 
GnuCash bug, but a GTK+ bug. (if I recall correctly.)

Maybe do a trial with clicking the GnuCash title bar first, then pasting, and 
see which window it gets pasted into.


___
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, 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.

Re: [GNC] gnucash-user Digest, Vol 196, Issue 5

[Paul Kinzelman]

Thanks for the suggestion, I'll try to remember that.
I've been using gnucash for almost a year and I'd never seen it before
tho I don't cut/paste whole transactions very often so I don't know
when it'll come up again. I have done transaction copy/paste
successfully in the past, so it is intermittent.

I don't think it's a focus problem or it would not have deleted the
transaction from the source. I didn't focus in any other app between
the cut and the paste, and the destination did focus when I clicked
on the tab just before doing the paste.

So you're saying that if gnucash doesn't see a paste right after a cut,
it puts the transaction back where it came from? That makes sense
for it to do that.

But I'm curious, where does gnucash stash the cut transaction?
It doesn't seem to be in the standard clipboard.

Now that you mention it, I have noticed that if I do a simple copy/paste
of text between like Firefox and emacs (not in gnucash) sometimes it
would not work (paste would get previous contents), so I've gotten
into the habit of hitting ^C about 30 times (that many because I'm
pissed that I have to do it more than once :-) whenever I want to copy.
I've seen that behavior intermittently on W10 on a previous laptop and
now on this one too. Maybe it's a W10 issue.


On 7/1/2019 9:35 PM, gnucash-user-requ...@gnucash.org wrote:

Date: Mon, 1 Jul 2019 16:23:26 -0500
From: Adrien Monteleone
To: Users Gnucash
Subject: Re: [GNC] cut/paste problem in 3.4?
Message-ID:<72f7c2e7-232e-4308-9665-66e8538ec...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

Might indeed be a stray cosmic ray, or temporarily insane electrons, but this 
stood out for me:


Earlier when I saw the problem, the cut did work,
the transaction vanished from the source account, but
when I pasted it into the destination account, it magically appeared again
in the source account but not the destination account.

My first suspicion would be a mouse/window focus problem. It did paste it, but 
not in the window you were expecting it to. Since you can paste into emacs, the 
problem is either intermittent, or somehow limited to GnuCash.

I do know GnuCash on MacOS at least, has a focus problem where you must click 
the title bar sometimes to get it to accept input even though the window 
?appears? to be in focus. If that?s your OS, do a search for some threads in 
the last 6-8 months and something might pop up. I think though this isn?t a 
GnuCash bug, but a GTK+ bug. (if I recall correctly.)

Maybe do a trial with clicking the GnuCash title bar first, then pasting, and 
see which window it gets pasted into.


___
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, 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.

Re: [GNC] Version 3.6 crashes on MacOS 10.14.5

[Adrien Monteleone via gnucash-user]

There is a tracefile, but make sure to create a copy of it somewhere else 
because it gets overwritten with the next launch.

Instructions here: http://wiki.gnucash.org/wiki/Tracefile

Also, was a crash report not generated when it blew up? Usually MacOS creates 
and displays a crash report on screen. You can copy and paste the contents to a 
file and attach them to a bug report. (do not copy and paste the crash or the 
tracefile into a bug report comment, though, make sure to attach them as text 
files)

If you happened to close that crash report, you should be able to find it using 
Console.app.

Regards,
Adrien

> On Jul 2, 2019, at 9:45 AM, Roderick Averill  wrote:
> 
> I’m currently using version 3.4 with no issues.
> 
> I downloaded version 3.6-1 for the MacOS and when I open it, it immediately 
> crashes.
> 
> Is there a log file that I can review?
> 
> Rod

___
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, 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.

[GNC] Version 3.6 crashes on MacOS 10.14.5

[Roderick Averill]

I’m currently using version 3.4 with no issues.

I downloaded version 3.6-1 for the MacOS and when I open it, it immediately 
crashes.

Is there a log file that I can review?

Rod
___
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, 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.

Re: [GNC] Checksum

[John Ralls]

The checksums are in the release notes for each version, 
http://www.gnucash.org/news.phtml and 
https://github.com/Gnucash/gnucash/releases/tag/3.6 (file downloads at the 
bottom), on the SourceForge download page, 
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/3.6/,
and were in the release announcement email.

Regards,
John Ralls


> On Jul 1, 2019, at 8:35 PM, Dale Alspach  wrote:
> 
> Thanks,
> 
> Still checksums should be linked from the same location as the files or
> be on the gnucash.org site.
> 
> Dale
> 
> On 7/1/19 5:06 PM, David Carlson wrote:
>> Quote from the release announcement:
>> 
>> "
>> 
>> The SHA256 Hashes for the downloadable files are:
>> 
>>  * |f1cb86de60bb0eb2cf5c2c3868e7dab7d889017e233230f944f158f84eb85f25|  
>> gnucash-3.6.tar.bz2
>>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|  
>> gnucash-3.6.tar.gz
>>  * |cb8ba5aa13dce6c9caedfb774abef47b8e352c2cda7d762d3f74840f1b12766a|  
>> gnucash-3.6.setup.exe
>>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|  
>> Gnucash-Intel-3.6-1.dmg
>>  * |32d373a4faa96cde2bba564bc8d7143d6317f121c488492f2dc5ebe99b4b6163|  
>> gnucash-docs-3.6-1.tar.gz
>> 
>>  * SourceForge:
>>  o Win32
>>
>> 
>>  o Mac-Intel
>>
>> 
>>  * Github
>>  o Win32
>>
>> 
>>  o Mac-Intel
>>
>> 
>> 
>> "
>> 
>> Is that close enough?
>> 
>> On Mon, Jul 1, 2019 at 3:23 PM Dale Alspach > > wrote:
>> 
>>I have been building the 3.x series on linux 18.3 from source. Why is it
>>that the checksum for the source bzipped tarball is not readily
>>available. I have yet to find it for the 3.6 release.
>>The download link from gnucash.org  fetches
>>gnucash-3.6.tar.bz2 from
>>sourceforge.net  but provides nothing else.
>> 
>>Dale
>>___
>>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, 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@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@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.

Re: [GNC] Unable to reconcile

[David Carlson]

Please follow Colin's suggestion and include complete details of the
version of GnuCash, your OS, the steps that you took before each
illustration in the same message so we don't have to guess what you are not
telling us.  Some of us are using mail clients that make it very hard to
navigate backwards through threads or to untangle 'hidden' parts of
messages.

To anonymize your illustration, create a simple data file with bogus data
or use a graphic editor to block out names of accounts.

David Carlson
On Tue, Jul 2, 2019 at 8:04 AM Anna  wrote:

> It was mentioned that this issue arose after an update - in fact, that it
> was the first reconciliation since that update.
>
>
___
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, 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.

Re: [GNC] Checksum

[Dale Alspach]

This will help in the future. The sourceforge download page design is not
for people like me. I would much prefer a link to the 3.6 directory. I
would expect that anyone looking for source code would also.

Dale

On Tue, Jul 2, 2019 at 12:15 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Dale,
>
> They *are* at the same location as the files:
>
> GnuCash.org links you to the SourceForge file host for each platform. (it
> is unfortunate that it auto-downloads however)
>
> On the page it takes you to, click the GnuCash title next to the app icon.
>
> Then click the Files tab.
>
> Then click the ‘gnucash (stable)’ folder.
>
> Then the folder for the release you want, in this case, 3.6.
>
> There you will see the several installers and source tarballs.
>
> Below these file links, are the SHA256 hashes included in the release
> announcement.
>
> If you are using a browser with JS turned on, you should also see an ‘i’
> icon to the far right of each file in the list. Clicking it will display
> the MD5 and SHA1 hashes if you prefer those for some reason.
>
> --
>
> They *are* also on GnuCash.org:
>
> Click the News link at the left in the site menu
>
> You’ll see the release notes containing the hashes just as they were
> published to the mailing list.
>
>
>
> Regards,
> Adrien
>
> > On Jul 1, 2019, at 10:35 PM, Dale Alspach  wrote:
> >
> > Thanks,
> >
> > Still checksums should be linked from the same location as the files or
> > be on the gnucash.org site.
> >
> > Dale
> >
> > On 7/1/19 5:06 PM, David Carlson wrote:
> >> Quote from the release announcement:
> >>
> >> "
> >>
> >> The SHA256 Hashes for the downloadable files are:
> >>
> >>  * |f1cb86de60bb0eb2cf5c2c3868e7dab7d889017e233230f944f158f84eb85f25|
> gnucash-3.6.tar.bz2
> >>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|
> gnucash-3.6.tar.gz
> >>  * |cb8ba5aa13dce6c9caedfb774abef47b8e352c2cda7d762d3f74840f1b12766a|
> gnucash-3.6.setup.exe
> >>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|
> Gnucash-Intel-3.6-1.dmg
> >>  * |32d373a4faa96cde2bba564bc8d7143d6317f121c488492f2dc5ebe99b4b6163|
> gnucash-docs-3.6-1.tar.gz
> >>
> >>  * SourceForge:
> >>  o Win32
> >><
> http://downloads.sourceforge.net/gnucash/stable/gnucash-3.6.setup.exe>
> >>  o Mac-Intel
> >><
> http://downloads.sourceforge.net/gnucash/stable/Gnucash-Intel-3.6-1.dmg>
> >>  * Github
> >>  o Win32
> >><
> https://github.com/Gnucash/gnucash/releases/download/3.6/gnucash-3.6.setup.exe
> >
> >>  o Mac-Intel
> >><
> https://github.com/Gnucash/gnucash/releases/download/3.6/Gnucash-Intel-3.6-1.dmg
> >
> >>
> >> "
> >>
> >> Is that close enough?
> >>
> >> On Mon, Jul 1, 2019 at 3:23 PM Dale Alspach  >> > wrote:
> >>
> >>I have been building the 3.x series on linux 18.3 from source. Why
> is it
> >>that the checksum for the source bzipped tarball is not readily
> >>available. I have yet to find it for the 3.6 release.
> >>The download link from gnucash.org  fetches
> >>gnucash-3.6.tar.bz2 from
> >>sourceforge.net  but provides nothing else.
> >>
> >>Dale
> >>
> >>
> >>
> >> --
> >> David Carlson
>
> ___
> 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, 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@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.

Re: [GNC] Change a batch of transactions from income to Expense

[David Cousens]

The CSV import documentation is not very clear yet as the process was
rewritten and the documentation needs some updating - on the to do list.. 

>From the description you seem to be importing transactions to a bank
account. CSV formats are highly variable.  I usually setup a new dummy test
file to experiment with importing so I don't muck up my main accounts file
and when i have it right I do the import into my main set of books. When you
have sorted out a set of import settings that works you can save them with
an appropriate name in the import setup window and then use them for imports
form the same source.  If the CSV file is very long, I often create a
truncated copy of it with  5 or 6 typical transactions ( edit in spreadsheet
and reexport CSV) to experiment with rather than using a full file.

Make sure the date format selected in the setup window matches the format in
the file. At a minimum you will have to assign the Date, Description and
either the Deposit or Withdrawal headers to the columns in your data file
with that information.  You will need to skip any column header rows present
in the first few rows of the csv file. The setup page allows you to do this.

If your data file has the transaction amounts specified in a single column,
they will need to be +ve for transactions transferring money into the
account and -ve for transactions withdrawing from the account and in this
case you would normally assign the Deposit header to that column and not
assign a Withdrawal header to any column. If on import you find the
transactions are the wrong way round then clear the import and assign the
Withdrawal header to the column and repeat the import.

Some instiutions might provide transaction amounts in separate columns
usually labelled Debits and Credits in the header row they supply. In this
case you would normally apply The Deposit header to the column labelled
Credit and Withdrawal to the column labelled Debit. (if it imports the wrong
way, delete the transactions and reverse the assignment of the headers and
reimport.

Another format often is  a column with the amount and a second column with
either one of Dr or Debit or one of Cr or Credit in a second column. GnuCash
cannot recognize this. You may need to import the data into a spreadsheet
and create a single column with positive and negative amounts and then
reexport it as CSV before importing it into GnuCash.

Some banks will also export a column with an expense category. If this
exists you can assign the header for the transfer account to it. There is a
process in the import for mapping such categories onto the accounts used in
GnuCash.

When you get a setup which works save the setup and then use that setup to
import the file into your main accounts.

Good Luck

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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, 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.

Re: [GNC] Custom reports don't survive upgrade to v3

[Geert Janssens]

Macho,

Can you attach the "not terribly instructive" stack trace here ?
Also when you run the other custom reports resulting in the generic report 
error, can you check the contents of the trace file [1] ?
Typically that file will have more information.

Regards,

Geert

[1] http://wiki.gnucash.org/wiki/Tracefile

Op dinsdag 2 juli 2019 03:48:33 CEST schreef Macho Philipovich:
> Dear gnucash users,
> 
> I decided to upgrade from the long-term support version of Ubuntu to the
> current stable version this weekend.
> 
> This change, I would later learn, entailed upgrading gnucash from
> v2.6.19 to v3.4.
> 
> The upgrade went fine, except that none of my four or five custom
> reports work any more.
> 
> They mostly don't give any helpful error information but just show:
> 
> *Report error*
> An error occurred while running the report.
> 
> One of the reports does, however, give some sort of stack trace, though
> it's not terribly instructive either.
> 
> It's been quite a while since I've looked at any of this, so revisions
> currently feel a bit daunting, but I do rely significantly on these
> custom reports.
> 
> If anyone could point me to any resources on the changes to the reports
> API since v2 and to any debugging resources, it would also be greatly
> appreciated.
> 
> The reports are my own creations, except that one is an extremely
> helpful year-to-date budget report that Phil Longstaff (in cc) provided
> me some time ago over this list in a file he called ytd-budget.scm.
> Phil, if by chance you've revised your report, I'd greatly appreciate a
> copy. And I would very much +1 this report becoming part of the standard
> reports provided within gnucash.
> 
> Many thanks,
> 
> Macho
> 
> 
> ___
> 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, 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@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.

Re: [GNC] Unable to reconcile

[Colin Law]

On Tue, 2 Jul 2019 at 07:58, Anna  wrote:
>
> If you read my message, you will see that this is just what I did.
>
> As mentioned in my update, if a cheque is written on 23 May, for instance, 
> but not presented until 2nd June, and the reconciliation date is 31st May, 
> then with the new version of Gnucash the date of the cheque must be changed 
> to beyond the reconciliation period.

Post a screenshot (or put it somewhere accessible, not sure if you can
post images on this list) showing the reconcile window which will not
allow you to just ignore that entry, even if it is dated before the
reconcile date.
Just to check, you are entering the closing balance from the bank
statement aren't you, not from the GC balance?  If you can't do that
then post a screenshot showing that dialog instead.

Colin

>
> Best
> Anna
>
> On 28/06/2019 17:09:33, David Carlson  wrote:
> Another way looking at this issue is while reconciling to be sure that all 
> transactions on the bank statement are checked and all transactions in the 
> statement period that have not cleared yet are not checked.   Then the 
> reconciliation can be completed.  There is no requirement for outstanding 
> transactions to be checked.
>
>
> If, as you suggested,  the reconciliation ending balance cannot be changed to 
> match the bank statement balance to complete the reconciliation thus 
> requiring all transactions to be checked,  that would be a serious issue 
> requiring a big report.
>
> Please excuse my spell checker re-writes . I cannot be sure that it says what 
> I mean.
>
> David Carlson
>
> On Fri, Jun 28, 2019, 4:27 AM Anna  [mailto:anna.trico...@gmail.com]> wrote:
>
> Yes, that's the first thing I checked.  You'll see that my initial post 
> confirmed this.
>
> This is the first reconciliation since upgrading to a newer version.
>
> I've done some more investigation, and found that it is because one of the 
> transactions had been entered under an incorrect date.  This new version will 
> not allow reconciliation until all transactions within the date span are 
> marked off, meaning that if a cheque is entered, the date will have to be 
> changed from the date it was written to the date it was presented.
>
> Regards
> Daisy
> On 27/06/2019 09:41:02, Derek Atkins  [mailto:de...@ihtfp.com]> wrote:
> Hi,
>
> On Wed, June 26, 2019 3:58 pm, Daisy wrote:
> > I'm trying to reconcile current account. Opening and closing balances
> > tally, as does reconciled balance, but I cannot finish the reconciliation
> > because the cleared balance is different. Total paid in and total paid out
> > are correct.
> >
> > Have made sure that all transactions that should be reconciled are marked
> > off.
> >
> > What is causing this discrepancy?
>
> Make sure your ending balance, as entered when you start the reconcile
> process, matches your statement ending balance. And then make sure only
> the items on the statement are checked off in the reconcile window.
>
> > 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
> de...@ihtfp.com [mailto:de...@ihtfp.com] www.ihtfp.com [http://www.ihtfp.com]
> Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org [mailto:gnucash-user@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@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@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.

Re: [GNC] ​Re: ?Re: Using Mint

[Colin Law]

On Mon, 1 Jul 2019 at 22:34, Tim Kallmer  wrote:
>
> Not exactly as you typed. I had run `sudo apt update && sudo apt upgrade`. 
> Would your way be different than mine?

apt is the replacement for apt-get, I wasn't sure at which version of
mint the new command was added so used the older syntax (which will
continue to work for a number of years at least).  There is little
difference between the two commands.

Colin

>
>
> On Mon, Jul 1, 2019 at 8:56 PM Colin Law  wrote:
>>
>> Did you run
>> sudo apt-get update && sudo apt-get dist-upgrade
>> first, to make sure you system is all up to date?  It may not fix it
>> but worth checking anyway.
>>
>> Colin
>>
>> On Mon, 1 Jul 2019 at 21:41, Tim Kallmer  wrote:
>> >
>> > I ran into problems.
>> > sudo dpkg -i ./gnucash-common_3.6-0_all.deb seemed to install fine, but
>> >
>> > for python3-gnucash_3.6-0_amd64.deb:
>> >
>> > sudo dpkg -i ./python3-gnucash_3.6-0_amd64.deb
>> > (Reading database ... 360610 files and directories currently installed.)
>> > Preparing to unpack .../python3-gnucash_3.6-0_amd64.deb ...
>> > Unpacking python3-gnucash (1:3.6-0) over (1:3.6-0) ...
>> > dpkg: dependency problems prevent configuration of python3-gnucash:
>> >  python3-gnucash depends on libpython3.7 (>= 3.7.0); however:
>> >   Package libpython3.7 is not installed.
>> >  python3-gnucash depends on python3 (>= 3.7~); however:
>> >   Version of python3 on system is 3.6.7-1~18.10.
>> >
>> > dpkg: error processing package python3-gnucash (--install):
>> >  dependency problems - leaving unconfigured
>> > Errors were encountered while processing:
>> >  python3-gnucash
>> >
>> > and for gnucash_3.6-0_amd64.deb:
>> >
>> > sudo dpkg -i ./gnucash_3.6-0_amd64.deb
>> > (Reading database ... 360610 files and directories currently installed.)
>> > Preparing to unpack ./gnucash_3.6-0_amd64.deb ...
>> > Unpacking gnucash (1:3.6-0) over (1:3.3-2) ...
>> > dpkg: dependency problems prevent configuration of gnucash:
>> >  gnucash depends on libboost-regex1.67.0 (>= 1.67.0-10); however:
>> >   Version of libboost-regex1.67.0:amd64 on system is 1.67.0-7ubuntu0.1.
>> >  gnucash depends on libicu63 (>= 63.1-1~); however:
>> >   Package libicu63 is not installed.
>> >  gnucash depends on libofx7 (>= 1:0.9.14); however:
>> >   Version of libofx7:amd64 on system is 1:0.9.13-2.
>> >  gnucash depends on libpython3.7 (>= 3.7.0); however:
>> >   Package libpython3.7 is not installed.
>> >
>> > dpkg: error processing package gnucash (--install):
>> >  dependency problems - leaving unconfigured
>> > Processing triggers for bamfdaemon (0.5.3+18.04.20180207.2-0ubuntu1) ...
>> > Rebuilding /usr/share/applications/bamf-2.index...
>> > Processing triggers for gnome-menus (3.13.3-11ubuntu2) ...
>> > Processing triggers for desktop-file-utils (0.23-3ubuntu3) ...
>> > Processing triggers for mime-support (3.60ubuntu1) ...
>> > Processing triggers for man-db (2.8.4-2) ...
>> > Errors were encountered while processing:
>> >  gnucash
>> >
>> > trying to run gnucash:
>> >
>> > This is a development version. It may or may not work.
>> > Report bugs and other problems to gnucash-de...@gnucash.org
>> > You can also lookup and file bug reports at https://bugs.gnucash.org
>> > To find the last stable version, please refer to https://www.gnucash.org/
>> > ;;; note: source file /usr/share/guile//2.2/ice-9/eval.scm
>> > ;;;   newer than compiled
>> > /usr/lib/x86_64-linux-gnu/guile/2.0/ccache/ice-9/eval.go
>> > Throw without catch before boot:
>> > Throw to key syntax-error with args ("memoization" "In file ~S, line ~S: ~A
>> > ~S." ("/usr/share/guile//2.2/ice-9/boot-9.scm" 63 "Bad expression" (@@
>> > primitive apply)) #f)Aborting.
>> > [1]20182 abort (core dumped)  gnucash
>> >
>> > Any suggestions on what I should do?
>> >
>> > On Mon, Jul 1, 2019 at 7:36 PM  wrote:
>> >
>> > >
>> > > --
>> > >
>> > > Message: 7
>> > > Date: Mon, 1 Jul 2019 11:51:30 -0700
>> > > From: "Stephen M. Butler" 
>> > > To: gnucash-user@gnucash.org
>> > > Subject: Re: [GNC] ?Re: Using Mint
>> > > Message-ID: 
>> > > Content-Type: text/plain; charset=utf-8
>> > >
>> > > On 7/1/19 9:02 AM, Tim Kallmer wrote:
>> > > > If I have Cosmic 18.10, should I use the .deb for Bionic?
>> > >
>> > >
>> > > Yes.? The Trusty-Xenial-Bionic series all seemed to work up through
>> > > 18.10.? I was on 18.10 until folks asked for the 19.04 (Disco) deb
>> > > files.? I'm hoping dpkg-buildpackage worked the correct magic.
>> > >
>> > >
>> > >
>> > ___
>> > 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, 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.

Re: [GNC] Unable to reconcile

[Anna]

If you read my message, you will see that this is just what I did.  

As mentioned in my update, if a cheque is written on 23 May, for instance, but 
not presented until 2nd June, and the reconciliation date is 31st May, then 
with the new version of Gnucash the date of the cheque must be changed to 
beyond the reconciliation period.

Best
Anna

On 28/06/2019 17:09:33, David Carlson  wrote:
Another way looking at this issue is while reconciling to be sure that all 
transactions on the bank statement are checked and all transactions in the 
statement period that have not cleared yet are not checked.   Then the 
reconciliation can be completed.  There is no requirement for outstanding 
transactions to be checked. 


If, as you suggested,  the reconciliation ending balance cannot be changed to 
match the bank statement balance to complete the reconciliation thus requiring 
all transactions to be checked,  that would be a serious issue requiring a big 
report.

Please excuse my spell checker re-writes . I cannot be sure that it says what I 
mean. 

David Carlson 

On Fri, Jun 28, 2019, 4:27 AM Anna mailto:anna.trico...@gmail.com]> wrote:

Yes, that's the first thing I checked.  You'll see that my initial post 
confirmed this.

This is the first reconciliation since upgrading to a newer version.

I've done some more investigation, and found that it is because one of the 
transactions had been entered under an incorrect date.  This new version will 
not allow reconciliation until all transactions within the date span are marked 
off, meaning that if a cheque is entered, the date will have to be changed from 
the date it was written to the date it was presented.

Regards
Daisy
On 27/06/2019 09:41:02, Derek Atkins mailto:de...@ihtfp.com]> 
wrote:
Hi,

On Wed, June 26, 2019 3:58 pm, Daisy wrote:
> I'm trying to reconcile current account. Opening and closing balances
> tally, as does reconciled balance, but I cannot finish the reconciliation
> because the cleared balance is different. Total paid in and total paid out
> are correct.
>
> Have made sure that all transactions that should be reconciled are marked
> off.
>
> What is causing this discrepancy?

Make sure your ending balance, as entered when you start the reconcile
process, matches your statement ending balance. And then make sure only
the items on the statement are checked off in the reconcile window.

> 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
de...@ihtfp.com [mailto:de...@ihtfp.com] www.ihtfp.com [http://www.ihtfp.com]
Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org [mailto:gnucash-user@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@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.