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

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

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 >

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

[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

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,

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] 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

[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

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

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] 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

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

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 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

[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;

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

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

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,

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

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

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,

[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

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

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. 

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

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

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 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

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 -

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

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

[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

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] 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: > > *

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

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

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

2019-07-01 Thread Maf King
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, the balsheet-pnl means that finally balance sheet > and income statements can be reported across unlimited multiple dates. Some > assumptions have been made

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