Re: [GNC] Unable to reconcile

2019-07-01 Thread 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 t

Re: [GNC] Checksum

2019-07-01 Thread Adrien Monteleone
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 ‘gnu

Re: [GNC] Checksum

2019-07-01 Thread Dale Alspach
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: > > * |f1cb86de60bb0eb2cf5c2c3868e7dab7

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

2019-07-01 Thread David Cousens
Macho See https://wiki.gnucash.org/wiki/Configuration_Locations for the difference in location of custom reports. You will need to copy from the locatioon for 2.6 to that for v3 . David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

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

2019-07-01 Thread 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

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

2019-07-01 Thread David Carlson
This is another aspect relating to the behavior of GnuCash under the general subject of pending edit. See < https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085353.html> and it is also mentioned in < https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085341.html> . David Carlson

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

2019-07-01 Thread David Carlson
Check my answer in the other thread with the same subject line about anchor accounts. That is where the 'problem' lies. On Mon, Jul 1, 2019 at 4:25 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Might indeed be a stray cosmic ray, or temporarily insane electrons, but > this stoo

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

2019-07-01 Thread David Carlson
It looks to me like the paste actually worked fine, but it was not edited to show the account where you wanted it. Try adding a split line assigned to the desired account first. Of course, then you might as well save, jump to the other account, copy the other account name over the undesired accou

Re: [GNC] Checksum

2019-07-01 Thread David Carlson
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 - cb8ba5aa13dce

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

2019-07-01 Thread Christopher Lam
Morayweb you may try one of the tricks mentioned in https://wiki.gnucash.org/wiki/FAQ#Q:_Is_there_a_way_to_merge_two_accounts_into_one.3F On Mon, 1 Jul 2019 at 12:02, morayweb wrote: > Hi I imported a qif file but when i went into the transactions they are all > income and none of them are expen

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

2019-07-01 Thread Tim Kallmer
Not exactly as you typed. I had run `sudo apt update && sudo apt upgrade`. Would your way be different than mine? 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

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

2019-07-01 Thread Adrien Monteleone
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

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

2019-07-01 Thread Paul Kinzelman
Hadn't thought of that. I had already exited when I saw your suggestion and when I started up gnucash again, that same sequence to/from the same accounts as before now works. Perhaps copy/paste works only in the afternoons, not mornings. :-) Earlier when I saw the problem, the cut did work, th

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

2019-07-01 Thread Colin Law
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 inst

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

2019-07-01 Thread Stephen M. Butler
On 7/1/19 1:37 PM, 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

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

2019-07-01 Thread Adrien Monteleone
Have you tried pasting into something like a plain text editor after cutting? Perhaps the clipboard is not picking up the ‘cut’ but GnuCash is still removing the data. Anytime I have a pasting problem I always test in a plain text editor to see if that is the issue. Regards, Adrien > On Jul 1

Re: [GNC] delete multiple transactions? csv import profiles?

2019-07-01 Thread Stephen M. Butler
On 7/1/19 12:41 PM, Mark Van den Borre wrote: > Hi Stephen, hi list, > > Sorry to have bothered the developers with this. I am using the 3.4 > package from Debian testing "Buster". I did glance through the change > logs, but I missed that change. Good to know I'll somewhat soon have > the possibili

Re: [GNC] Accelerator Key for Jump button

2019-07-01 Thread Michael Hendry
> On 1 Jul 2019, at 19:21, Deva - wrote: > > Sorry, yes - the file you located in $HOME/Library/Application Support/ > appears to be the one you have to edit. > > Yes, CMD-S is a problem for split action, so I use CMD-L instead. That works > for me. > > Cheers. Magic! Thanks. Just one rese

[GNC] ​Re: ?Re: Using Mint

2019-07-01 Thread Tim Kallmer
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_a

[GNC] cut/paste problem in 3.4?

2019-07-01 Thread Paul Kinzelman
I just tried cutting a transaction in one account, and I saw it vanish. I went to another account, pasted it, and it wasn't there, it had gone back to the account where it was before I cut it. So I carefully repeated the cut/paste and it did that again. So I deleted it from the one account, and

[GNC] Checksum

2019-07-01 Thread Dale Alspach
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 els

Re: [GNC] delete multiple transactions? csv import profiles?

2019-07-01 Thread Mark Van den Borre
Hi Stephen, hi list, Sorry to have bothered the developers with this. I am using the 3.4 package from Debian testing "Buster". I did glance through the change logs, but I missed that change. Good to know I'll somewhat soon have the possibility once a 3.5 package ends up in Debian. Kind regards, a

Re: [GNC] delete multiple transactions? csv import profiles?

2019-07-01 Thread Stephen M. Butler
On 7/1/19 3:56 AM, Mark Van den Borre wrote: > Hello list! > > Here's two questions that have come up when trying to somewhat > automate processing my bank transactions using gnucash. I had a look > for the answers online, but couldn't really find any recent ones. > > * Can I delete multiple transa

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

2019-07-01 Thread Stephen M. Butler
On 7/1/19 9:17 AM, morayweb wrote: > Hi > I can get a csv version of the file would that make it easier to import? > Thank you. > > C That depends on how good the vendor is at building the csv file.  My Citi's csv file for my cc insists on putting minus signs on the credit column values.  Essentia

Re: [GNC] ​Re: Using Mint

2019-07-01 Thread Stephen M. Butler
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.

Re: [GNC] [GNC-dev] Announcement: GnuCash 3.6 Released

2019-07-01 Thread Stephen M. Butler
On 7/1/19 6:24 AM, Ronal B Morse wrote: > On Sun, 2019-06-30 at 22:37 -0700, Stephen M. Butler wrote: >> This Google Drive location now has debian downloads of v3.6 for both >> Disco and Xenial-Bionic: >> https://drive.google.com/open?id=1s-E6t-snmQiEFaT_hlWF2KHWrIB_LV2x >> >> I have fired up the

Re: [GNC] Accelerator Key for Jump button

2019-07-01 Thread Deva -
Sorry, yes - the file you located in $HOME/Library/Application Support/ appears to be the one you have to edit. Yes, CMD-S is a problem for split action, so I use CMD-L instead. That works for me. Cheers. From: Michael Hendry Sent: 01 July 2019 04:49 To: Deva

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

2019-07-01 Thread David Carlson
morayweb, Try it. I am not looking over your shoulder. In my experience, I try OFX first, QIF next, and CSV last, especially since some banks don't use comma separators because they use commas for other purposes, but to each his own. David Carlson On Mon, Jul 1, 2019 at 11:19 AM morayweb wro

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

2019-07-01 Thread morayweb
Hi I can get a csv version of the file would that make it easier to import? Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription pref

Re: [GNC] Unable to reconcile

2019-07-01 Thread David Carlson
As others have also mentioned, they are not seeing the same issue that you are, at least with the given details. While your last message does list the transaction dates in detail, it does not mention other factors such as whether this, for you, is a new issue in a recent update or whether reconcil

[GNC] ​Re: Using Mint

2019-07-01 Thread Tim Kallmer
If I have Cosmic 18.10, should I use the .deb for Bionic? Message: 1 > Date: Sun, 30 Jun 2019 18:36:38 -0700 > From: "Stephen M. Butler" > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Using Mint > Message-ID: <0de49b0e-978d-3001-b55e-559e75d1c...@gmail.com> > Content-Type: text/plain; charse

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

2019-07-01 Thread David Carlson
There are as many possibilities as there are accountants to cause or fix your dilemma. The simplest is to assume that your source simply got the sign wrong on some of the numbers in the QIF. However, since you are calling the account "Rebate" maybe the numbers are actually supposed to be expenses

Re: [GNC] delete multiple transactions? csv import profiles?

2019-07-01 Thread Greg Feneis
Hi Mark, I think a recent rev of GnuCash does allow the user to save the CSV import settings. To cover yourself for mistakenly importing a large number of transactions, consider practicing checkpointing for your working file. Or, at the least, save before import, and don't save if the import goes

Re: [GNC] Finance-Quote 1.49 released!

2019-07-01 Thread Bruce Schuck
> This release would not have happened without Vincent Lucarelli and > Bruce P Schuck. Therefore I welcome your message which certainly > will help keep us all motivated :) > enjoy the new release! No applause necessary. Just send donuts. ;) Glad to have the opportunity to help. - Bruce S.

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

2019-07-01 Thread morayweb
Tried it again after deleting all transactions but the debit amount is in the rebate part. What is the best way to check the qif file and sort it out. I exported from an online system ? Thanks -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

Re: [GNC] [GNC-dev] Announcement: GnuCash 3.6 Released

2019-07-01 Thread Ronal B Morse
On Sun, 2019-06-30 at 22:37 -0700, Stephen M. Butler wrote: > This Google Drive location now has debian downloads of v3.6 for both > Disco and Xenial-Bionic: > https://drive.google.com/open?id=1s-E6t-snmQiEFaT_hlWF2KHWrIB_LV2x > > I have fired up the Disco verion on my box. I have no way to > ch

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

2019-07-01 Thread David Carlson
Oh, fix the problem with the QIF file first. On Mon, Jul 1, 2019 at 7:40 AM David Carlson wrote: > If you have a backup from just before the import, just use that and import > again. > > David Carlson > > On Mon, Jul 1, 2019 at 7:03 AM morayweb wrote: > >> Hi I imported a qif file but when i w

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

2019-07-01 Thread David Carlson
If you have a backup from just before the import, just use that and import again. David Carlson On Mon, Jul 1, 2019 at 7:03 AM morayweb wrote: > Hi I imported a qif file but when i went into the transactions they are all > income and none of them are expense. Is it possible to change the ones

Re: [GNC] [GNC-dev] Announcement: GnuCash 3.6 Released

2019-07-01 Thread David Carlson
Thank you to all the developers for you incredible efforts to bring this release out. David Carlson On Mon, Jul 1, 2019 at 1:26 AM Maf King wrote: > On Monday, 1 July 2019 11:14:05 BST Christopher Lam wrote: > > Thanks John for the hard work in releasing 3.6. > > > > With regards to reports, th

[GNC] Reconcile Flag when Importing Transactions from CSV

2019-07-01 Thread Patrick
When I am importing transactions from a CSV, I have a "Reconcile" column that I select as the "Transfer Reconciled" column in the import wizard. I have all of the entries marked as "n" in this column, but after importing them, some of them seem to still show up as "c". Am I misunderstanding the "Tr

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

2019-07-01 Thread morayweb
Hi I imported a qif file but when i went into the transactions they are all income and none of them are expense. Is it possible to change the ones to expense as a batch rather than retyping them all in again. Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.ht

Re: [GNC] Formatting Reports

2019-07-01 Thread morayweb
Hi that done the trick thanks. I have another problem but will do another post. Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscriptio

[GNC] delete multiple transactions? csv import profiles?

2019-07-01 Thread Mark Van den Borre
Hello list! Here's two questions that have come up when trying to somewhat automate processing my bank transactions using gnucash. I had a look for the answers online, but couldn't really find any recent ones. * Can I delete multiple transactions at once? I messed up an import and painstakingly r

Re: [GNC] How to reconcile an account which have entries from posting Customer Invoice or Vendor Bill

2019-07-01 Thread Adrien Monteleone
Thanks for the clarification. Interesting issue. I’ll see if I can repeat the problem. Regards, Adrien > On Jul 1, 2019, at 4:53 AM, Jayakumar Chakravarthy > wrote: > > Adrien, > > Those accounts are Tax accounts which are posted along with Invoice or Bills > and are defined in 'Sales Tax Ta

Re: [GNC] How to reconcile an account which have entries from posting Customer Invoice or Vendor Bill

2019-07-01 Thread Jayakumar Chakravarthy
Adrien, Those accounts are Tax accounts which are posted along with Invoice or Bills and are defined in 'Sales Tax Table'. For example, I enter a Vendor Bill for 100 with 9% GST. So the entry posted is: Accounts Payable Credit 109 Purchase Debit 100 GST Debit 9 I am not able to reconcile this

Re: [GNC] How to make liability payment to be appeared in expenses reports

2019-07-01 Thread Eagle7
/(Sorry, my original reply look greet in the preview using HTML format, but odd when posted. Here my re-post with more plain text format)/ Many thanks for your useful reply and it worked if I create it in the split transaction inside the *Checking Account*. However, I tried to reproduce the end

Re: [GNC] Accelerator Key for Jump button

2019-07-01 Thread Deva -
Michael, I had a similar issue some years ago and the resolution provided by list members is to go edit a file by the same name under a different folder. On a Mac, I think it resides in a folder under $HOME/Library/Application Support/ I am not at my Mac right now, so I can't confirm the exact