Re: [GNC] splits 3+ accounts, how to

2018-04-24 Thread DaveC49
Eric, Mike To be fair to GnuCash, I have not been able to find a formal definition of split in my accounting text books . The only formal references I could find were under IAS39 which deals with embedded derivatives in a hybrid financial instrument (https://www.ventureline.com/accounting-glossary

Re: [GNC] Building issues

2018-04-26 Thread DaveC49
Hi Carlos, I had the same original problem during Make while building Gnucash 3.0 that you did. Aboout half way down the following thread there is a recipe of what worked for me in getting a successful build. It may not address your second problem, but I hope it helps. Cheers David - David

Re: [GNC] ofx/qfx import to V3

2018-04-28 Thread DaveC49
John, For your info OFX import is working fine on Linux Mint/Ubuntu 16.04. The only problem I had was that the previous automatic matching to accounts seemed to have had the data cleared in the swap over to the V3 user preferences files. After one import it had reestablished most of the matching

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-05 Thread DaveC49
Hi Dennis, I recently updated the Ubuntu 16.04 build instructions so I am glad to get your feedback on issues which may be unclear and any errors I may have incorporated. I will try to modify the instructions to make it clearer and eliminate errors. If you find any issues that are specific to Ubun

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-05 Thread DaveC49
Hi Dennis, I updated the BuildUbuntu16.04 page after having similar problems while building Gnucash3.0. My apologies for any errors and lack of clarity in a few areas and thanks for reporting the problems. I will edit the page to try and make some issues clearer as I or other users uncover my mist

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-05 Thread DaveC49
Hi Dennis, Almost there but not quite. In which directory in your home directory /home/dennis have you extracted the gnucash-3.1 directory from the tarball gnucash-3.1.tar.bz2 which you downloaded. Can you tell me the full path to that directory and the full path to the build-cmake directory you h

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-06 Thread DaveC49
Dennis, The obvious place to put the build-cmake directory is in the Applications directory. I personally would not name it build-cmake but build-gnucash-3.1. The reason for that is, to uninstall Gnucash there is no need to retain the gnucash-3.1 source directory which can be deleted, but you will

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-06 Thread DaveC49
Dennis, The instructions on the BuildUbuntu16.04 have now been modified so that they recommend the preferred place for the build directory is in the parent directory of the GnuCash sources as John and Geert recommended this as the preferred location. It can actually be anywhere you wish to put

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

2018-05-06 Thread DaveC49
Dennis, You are missing the third part of the cmake command when you type cmake -DCMAKE_INSTALL_PREFIX=/home/dennis/.local which is why you are getting the cmake error. You need to append either ../gnucash-3.1 or /home/dennis/Applications/gnucash-3.1 on to the end of the cmake command sep

Re: [GNC] Handling VISA Debit Accounts

2018-05-07 Thread DaveC49
>From an accounting perspective, this is just a current asset account like any other bank account. There is not really any need for any new sort of account type specifically for it. Perhaps just indicating in the account name that a debit card is attached, if you specifically need to know that. The

Re: [GNC] Up grade from 2.6.xx to 3.1

2018-05-10 Thread DaveC49
Dennis It is probbaly a good idea to uninstall the previous build of 2.6.x before upgrading. With the changes between 2.6 and 3.1 there may have been changes in the libraries/library names such that some older libraries may not necessarilybe overwritten. How to remove it will depend upon how you

Re: [GNC] Up grade from 2.6.xx to 3.1

2018-05-11 Thread DaveC49
Dennis, The instructions for v3.1 should work. The only problem I had when i compiled 2.6.21 after upgrading to 3.1 was that I had installed guile 2.2.3 and v 2.6.21 looks for guile-1.8 or guile-2.0. It is possible to have several versions of the guile libraries and headers installed as they insta

Re: [GNC] Advice needed, how to handle a medical reimbursement account...

2018-05-14 Thread DaveC49
I think you are overcomplicating the issue by recording the appllication for the refund from the MRA account. No money chnages hands at this point so you could record paying the Doctors bill as Asset:Check Credit $100 Expense:Medical Debit $100 When you receive the ref

Re: [GNC] New User-Clueless on Investments

2018-05-14 Thread DaveC49
The best place to start is the Tutorial and Concepts guide. http://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-setup1.html is the link for V2.6 documentation. There will be a similar section in the V3 docs if you are using that version. While that is mainly aimed at stocks and mutual funds, th

Re: [GNC] Editing Scheduled Transaction

2018-05-18 Thread DaveC49
Robin, I'm also using 3.1 on Mint 18.3. I have tried to duplicate your problem without being able to. I am able to edit the fields in the template transaction without any diffculty and I don't receive that error message at all. I can create 2 scheduled transactions and edit them both at the same t

Re: [GNC] Reconciliation

2018-05-25 Thread DaveC49
Bill, This is not the case for GnuCash v3.1 on Linux Mint 18.3. You can readily check and uncheck the boxes. The only hassle I have had is that by default the credit and debit entries are not ordered by date but by reconcile status and when you check a box, it is automatically placed at the end o

Re: [GNC] Credit Card Charge Decreasing Account Balance

2018-05-26 Thread DaveC49
What version of Gnucash are you using and what platform is it running on. When you look at an individual charge transaction, the balance after the transaction should be larger than the balance before the transaction with the reverse for a payment. Whether that balance is shown as a negative or pos

Re: [GNC] Error Message on trying to Open a gnucash file "There was an error parsing the file...."

2018-05-30 Thread DaveC49
Francis, If you look in the folder which contains your gnucash file there should be a set of backup files. Gnucash creates a backup file. I am assuming you are using the XML format files and not a database. The file will have a name of the form .gnucash and the backups will have the form .gnuc

Re: [GNC] A/P: invoice not displayed and payment is displayed

2018-05-30 Thread DaveC49
Rich, How are you creating the payment of the Bill? If you open the Bill and then use the payment icon in the Toolbar (no need to search for the bill to pay) or alternatively use the Business->Vendor->Process Payment and search for the Bill by Vendor and select the Bill the transactions for the

Re: [GNC] copying files

2018-05-31 Thread DaveC49
Varda, I travel with a laptop and use a desktop at home. If you have internet access while travelling I have had no problem with putting the GnuCash files in a Dropbox account synced to both the desktop and laptop. You can work without internet access and it syncs next time access is available. On

Re: [GNC] Associated Files in 3.1

2018-05-31 Thread DaveC49
Christian V3.1 compiled on Linux Mint using the XML backend works fine with associated files/locations setting them, retrievingthem after closing and reopening the program and opening the locations without any problems so it is possibly associated with the sqllite backend or perhaps the DB backends

Re: [GNC] Cash Flow report

2018-06-03 Thread DaveC49
Martijn, I can't really comment on the Cash Flow reportas implemented in GnuCash and it's options but the doubling of accounts in the selected list when the show subaccounts is selected does appear to be strange and may be a bug. My understanding of a Cash Flow Report is that it includes: cash r

Re: [GNC] Cash Flow report

2018-06-04 Thread DaveC49
Adrien, I think with the default account selection, the Cash Flow report seems to do the right thing. The double selection of accounts seems a bit strange, I haven't really got a proper set of business accounts to check it out on anymore and the dummy set I have put together have been for testing

Re: [GNC] Ubuntu 18.04

2018-06-11 Thread DaveC49
Hi Geert, I think one of the reasons people are not finding the Build#Ubuntu instructions and main build instructions in the wiki is that the main page is identified as Build Instructions for Developers rather than a general GnuCash Build Instructions page which gets listed in the top level direct

Re: [GNC] Wiki:Installation/Building; was: Ubuntu 18.04

2018-06-13 Thread DaveC49
Hi Frank & David T , Thanks for the info re the main page. I will try and hook into the Wiki Installation page as you suggest and have a go at making the build instructions friendlier for general users and split off a more specific page for developer builds. i will then link that back to the pages

Re: [GNC] Is there a Save As command line option

2018-06-21 Thread DaveC49
Steve, One possibility is to use synchronized data bases using master-slave replication. I know this works with MySQL and it is a bit of a pain to set up but once it is going it is generally pretty good. Also a bit of a pain to restart if the replication gets out of sync. I have been meaning to se

Re: [GNC] Trying to get started...

2018-06-21 Thread DaveC49
Edy, GnuCash is a double entry accounting system. There is no "placing of money from a POS under income and transferring it to the Cheque account". Each transaction associated with a POS sale has two components one of which increases the balance of the Cheque account (a debit to the Cheque account

Re: [GNC] Fwd: The two modules

2018-06-25 Thread DaveC49
Stephen, You can possibly force the case of sum of the children account totals being the parent account total by making the parent a placeholder account. Then it cannot have any transactions into it, only the child accounts. David Cousens - David Cousens -- Sent from: http://gnucash.14158

Re: [GNC] Fwd: The two modules

2018-06-25 Thread DaveC49
Stephen, There is no need to install the libofx7specifically. If you install libofx-dev that should install the the appropriate version of the library for your ubuntu version (i.e. libofx4 on 14.04(Trusty), libofx6 on 16.04 (Xenial) and libofx7 on 18.04 (Bionic) David Cousens - David Couse

Re: [GNC] Fwd: The two modules

2018-06-28 Thread DaveC49
Stephen, As an accountant I would prefer to have parent accounts as placeholder accounts which cannot be the target of transactions directly (this can be set in the edit Account dialog and marks the account as read only) as the placeholder total should then be the sum of its active child accounts

Re: [GNC] New Balsheet (and P&L report)

2018-06-30 Thread DaveC49
Christopher, " except that Placeholder accounts can also contain transactions therefore must not necessarily accumulate their children account amounts. " I have to disagree with the above from an accounting perspective. If accounts are setup as Placeholders initially (i.e. the checkbox set in

Re: [GNC] The two modules

2018-06-30 Thread DaveC49
John, Just to clarify. While I have accounting qualifications, I am not a practising accountant and my judgement is primarily an opinion based on my formal studies and my accounting experience in a small business in my particular country. We all need to keep in mind that accounting, while adhering

Re: [GNC] Fwd: The two modules

2018-06-30 Thread DaveC49
John, I agree with you that making the accounts with child accounts have no transactions is being unnecessarily restrictive and may not meet all possible use cases but perhaps having the option of being able to restrict it to that case if it suits an individual's purpose is a suitable compromise.

Re: [GNC] Fwd: The two modules

2018-06-30 Thread DaveC49
Hi Stephen, I agree with your wife about not including the Income Statement inside a Balance Sheet. These serve different functions and it just makes a Balance Sheet more complicated than necessary. From an accounting perspective you should be able to evaluate a balance sheet fairly quickly and ha

Re: [GNC] GnuCash 3.2 Released

2018-06-30 Thread DaveC49
Stephen, It is generally a good idea to remove the previous version before installing a new one. Gnucash will generally overwrite any existing files of the same name, but you may be left with unnecessary files in some cases. Going from 3.1 to 3.2 should be OK as there are unlikey to be major chang

Re: [GNC] Upgrading GC under Ubuntu

2018-06-30 Thread DaveC49
John, The GnuCash wiki Installation instructions now link to the build instructions for Ubuntu (and derivative distrubutions like Linux Mint) https://wiki.gnucash.org/wiki/Building which in turn has a link specifically for building V3 on on Ubuntu16.04, 18.04 and derivatives which now hopefully sh

Re: [GNC] Dark theme on Windows

2018-06-30 Thread DaveC49
Geert, I tried this on Linux Mint 18.3 but had no changes from the default theme. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To upda

Re: [GNC] GnuCash 3.2 Released

2018-06-30 Thread DaveC49
Hi John, If GnuCash is not built with Ninja, there is a cmake_uninstall.cmake file in the top level of the build directory which seems to read the install_manifest.txt file. The Makefile in the same level produced by CMake has an uninstall target - not sure how it executes the commands in the cmak

Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

2018-06-30 Thread DaveC49
Stephen John, Geert In accounting terms there are really only 3 basic account types: Asset Liability Equity These all *must *satisfy the basic accounting equation Assets=Liabilities +Equity. The two sides of this equation are what the German /European system defines as Activa and Passiv

Re: [GNC] Dark theme on Windows

2018-07-02 Thread DaveC49
Geert, The default theme is Mint-X. There is a Mint-X Dark GTK-3 theme available as well and GnuCash comes up nicely in it. It is installable from the Menu->Preferences->Themes dialog in the Cinnamon desktop. I would say on Mint all you have to do is select a dark theme at the system level. There

Re: [GNC] GnuCash 3.2 Released

2018-07-02 Thread DaveC49
John, I'm using CMake v 3.5.1. Presumably the same or similar could be used to create an uninstall target for Ninja. Their argument for providing a default uninstall target seems a bit weak to me as you are not going to be issuing the command in a build directory unless you really intend to uninst

Re: [GNC] GnuCash 3.2 Released

2018-07-02 Thread DaveC49
John, Just some further information. I rebuilt GnuCash with the -G Ninja option. The build.ninja seems to contain a build uninstall target but it has no commands. If I run sudo ninja install it installs GnuCash (in/usr/local the prefix I set with cmake) and creates install_manifest.txt. If i co

Re: [GNC] GnuCash 3.2 Released

2018-07-04 Thread DaveC49
Geert, I had realised the same thing about needing to uninstall before building and shifted the section on uninstalling to before the section on Building on the Wiki page and specifically mentioned using the previous version's build directory. I might make the note clearer about retaining the buil

Re: [GNC] Uninstalling previous versions

2018-07-04 Thread DaveC49
Stan, The previous discussion on uninstalling related to Linux (the Ubuntu distribution in particular) where users have built GnuCash from the source code. On Linux, if you use the particular Linux distribution's (Ubuntu, Debian, Redhat, Centos etc.) supported version of Gnucash, it normally has

Re: [GNC] Upgrading GC under Ubuntu

2018-07-04 Thread DaveC49
Stephen, Colin I think there is a problem with the cmake creation of the scripts that do the install, that is not installing the icons correctly. I just did an uninstall of v3.2 on Ubuntu, deleted any gnucash files left in my install location (/usr/local) relating to gnucash so that all directorie

Re: [GNC] Upgrading GC under Ubuntu

2018-07-04 Thread DaveC49
Stephen, Colin Just a correction to my last post. There is no problem with the icon installation on Linux Mint 18.3. It seems to possibly be a problem with Nemo (Linux Mint file explorer) rather than the installation. All of the icon files are actually there but there is something with the permis

Re: [GNC] Building v3 - Wiki entry for Ubuntu

2018-07-06 Thread DaveC49
Hi Colin, I'm responsible for m,ost of the update on the build Ubuntu. No problem for me with a more generic page name at all. I had stuck with the names that were there as I updated it with the more recent build instructions. I have tried to generalise the page and make it a bit more user orient

[GNC] Flatpack GnuCash v3.2 available in Linux Mint and flathub website

2018-07-06 Thread DaveC49
Gnucash V3.2 is available in the Software Manager in Linux Mint 18.3 downloading from the flatpack form from the flathub website(https://flathub.org/apps/search/GnuCash). Installs OK and indistinguisable from my own build on my system. Can be downloaded from the flathub site directly if you're not

Re: [GNC] Building v3 - Wiki entry for Ubuntu

2018-07-09 Thread DaveC49
Colin, A correction. The latest LM 18.3 Software Manager now installs Gnucash 3.2 as a flatpack in /usr/bin. There are no identiable gnucash directories apart from the user configuration. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _

Re: [GNC] Building v3 - Wiki entry for Ubuntu

2018-07-11 Thread DaveC49
Hi Colin, Sorry for the confusion. I had gone back to check where LM installed from its software manager to check that it was into /usr/local and discovered it was now using flatpack and didn't install in any manner I was previously accustomed to. I appreciate that apt installs to /usr but my memo

Re: [GNC] Flatpack GnuCash v3.2 available in Linux Mint and flathub website

2018-07-11 Thread DaveC49
Colin, There is a link labelled issues to the Gnome bugzilla site on the flathub GnuCash page which links to the now becoming defunct Gnome Bugzilla which is being transferred to Gnome Gitlab and has a link to it, https://gitlab.gnome.org/GNOME . I could not find any reporting of issues with flat

Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows 10 machine?

2018-07-11 Thread DaveC49
Dick, All that is necessary is to copy the .gnucash file from that directory to the new computer (usb stick is probably easiest) where is the name you originally gave your Gnucash file. This is the only file that it is necessary to copy to transfer to your new machine You will find a lot of files

Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows 10 machine?

2018-07-12 Thread DaveC49
Thanks Liz, I didn't think of the preferences. David - 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

Re: [GNC] Imbalance bug in credit note generation?

2018-07-20 Thread DaveC49
Hi Amish' I can also confirm that the credit note has a bug for GnuCash 3.2 running on Linux Mint 19 from the flat pack. I have created an Invoice for $100 for a dummy company in a test file and then a credit note for the same dummy company for $50. I have not used a tax table. After the two tran

Re: [GNC] balance sheet and account equation for Business Accounts

2018-07-22 Thread DaveC49
As well as the internal funds transfer from Euro to USD in your Asset:bank account are you also converting the corresponding income account in Euro to an Income account in USD at the same exchange rate? If not this is a possible spurce of any imbalance in the accounting equation. David Cousens

Re: [GNC] Missing menus

2018-07-25 Thread DaveC49
Joe, I've been using GnuCash on Linux Mint for approx 5 years with no problems. The Software manager version is sometimes a little behind the current GnuCash version but at present it has a flatpak GnuCash V3.2 available that worked fine under LM18.3 and is working fine on LM19. I'm currently run

Re: [GNC] opening my accounts after I have saved them

2018-07-25 Thread DaveC49
Johnnie Use File ->Open from the menu and navigate to the location where you saved the file. Hopefully you did not save the file to a read only CD. You should have received a warning that the device could not be written to if you had attempted to do that. Open the file .gnucash where filename is t

Re: [GNC] Getting My Account To Trial Balance

2018-07-26 Thread DaveC49
Adrien, The main function of the trial balance is to ensure the accounts are numerically correct before any adjustments to the accounts are made before producing the final financial statements. It should be just a straight listing of the balance (credit or debit) of all accounts in the chart of ac

Re: [GNC] Bug in design of commodity sell transactions? (was Re: Getting My Account To Trial Balance)

2018-07-27 Thread DaveC49
Adrien, >From what little I know of the automatic gains/loss calculations by default the gain or loss on a transaction is created in an Orphan-Gains-CCC account by default and the user has to reassign the gain or loss to an appropriate income account. See https://www.gnucash.org/docs/v3/C/gnuca

Re: [GNC] GNUcash 3.2 file open issue

2018-07-27 Thread DaveC49
Adrien, David, The same issue occurs in Linux Mint 19(Tara) which is Ubuntu 18.04 based. Nemo (file explorer) can see the mounted USB stick and access it directly or via the /media// mount point for the device but the Gnucash file open dialog neither sees the USB stick or /media// mount point whe

Re: [GNC] Nabble Delay? (was Re: Future Payments)

2018-07-27 Thread DaveC49
Adrien, I do use Nabble and also get the user list posts by email but as I am in Australia I sometiimes notice there is a long delay associated with being in this timezone. I'm not sure where the moderators are located but, I tend to post usually in the morning AEST (UTC -10:00) and my posts don't

Re: [GNC] Payroll add-on, module, software?

2018-07-27 Thread DaveC49
John I had considered writing a payroll plugin a few years ago but found that finding my way around the Gnucash code made it difficult so I have great respect for the business features that Derek has created so far. I started to think more in terms of a separate payroll program which maintained it

<    1   2