Re: [GNC] cryptocurrency with many decimals
Hello John, when I try to create XLM inside the "Currencies" name space, I get a message of error: "You may not create a new national currency". So I must cancel the creation of the currency. In any case, If we manage to create XLM under currencies, I would solve the expense's account but I would continue with problems in my assets account. My assets account is a stock account to track gain/losses, So for example: Asset:XLM (stock account) Description; Quantity; Price; Buy; Sell; Balance New coins; 356.2904939; 0,052929 (only displayed 0,0529); 18,858099552 (only displayed 18,86); ; 356.2904939 Fee to transfer; -0,1; 0,052929 (to avoid gain/loses, only displayed 0,0529); ; 0,00529 (it is rounded to 0 !!); 356.2904839 So, I lost XLM but I didn't lost value (capital gains). So, El sáb., 14 sept. 2019 a las 5:01, John Ralls () escribió: > > Yes, you'll have to move XLM to the CURRENCY namespace. GnuCash *should* > allow that since the symbol starts with X. > > Regards, > John Ralls > > > > On Sep 13, 2019, at 1:57 PM, Christian Pinedo Zamalloa > > wrote: > > > > Yes, perhaps using XLM as the security/currency of Expenses:XLM is the > > best approach. I tried it. However I can't set XLM as currency of the > > Expenses:XLM account. I defined the XLM under "CCC" (cryptocurrency) > > namespace and it seems that in a Expense account I can only select a > > national currency under "Currencies" namespace. > > > > Do yo know, what I should have to do? to define XLM under "Currencies" > > namespace, or a configuration change. > > > > Thanks! > > > > El vie., 13 sept. 2019 a las 20:02, John Ralls () > > escribió: > >> > >> > >> > >>> On Sep 13, 2019, at 10:40 AM, Christian Pinedo Zamalloa > >>> wrote: > >>> > >>> Hello, > >>> > >>> I am taking part in the airdrop of Stellar Lumens (XLM) in the keybase > >>> application so I received some free XLM cryptocoins that I would like > >>> to account with gnucash. > >>> > >>> The problem I have is the number of decimals. Cryptocurrency uses up > >>> to 7 decimals (11,1234567) and the price of the currency is often > >>> available with 6 decimals, for example, yesterday's XLM/EUR price was > >>> 0.052929 > >>> (https://www.investing.com/crypto/stellar/xlm-eur-historical-data?cid=1129224) > >>> > >>> I configured an stock account in gnucash to track XLM coins: I set the > >>> numbers I received with 7 decimals, I enter the price (this is round > >>> to 4 decimals) and finally I get the value rounded to only 2 decimals > >>> (this is the main problem). > >>> > >>> The problem I have is that I need to enter very low fees of 0,2 > >>> XML @ 0,052929 = 0,01059 € (from Asset:XML to Expense:XML). So > >>> these commissions are rounded to 0 € of value by gnucash and my > >>> balance fails because I reduce the number of XML coins for 0 euros. > >>> > >>> What could I do to face it? Thanks! > >> > >> You need to change the commodity in your Expense:XML account to XML. > >> Fractions of Euros (and any other real-world currency) smaller than 1/100 > >> simply don't exist. > >> > >> Regards, > >> John Ralls > >> > > > > > > -- > > Christian Pinedo Zamalloa (zako) > > PGP keyID: 0xdb577d4ee6ffbd55 > > PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 > -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 ___ 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] STP (Australia only)
STP, or single touch payroll, is something thought up by the bureaucrats to be sure we pay our way. It has some aspects in common with the UK's making tax digital. This is supposed to be running already, but people like me, who own the company and pay only themselves, have a little more time before they are obliged to sign up. So far, I am learning a lot of new jargon. The data to be transferred needs setting out in a csv file (I understand that) The data is converted to XBRL (new to me) The data is transmitted using ebMS3/AS4 security (new to me) A receipt is generated and returned (no new acronyms here) There are a number of companies offering to be the middleman in these processes. Some are free, others are not. Most of them offer payroll, which I neither need nor want. I looked at some which were apparently Linux friendly and found jar files that would not run, and AppImage and Snap files that wouldn't work either. Questions Are other Australian Gnucash users dealing with this, or still stalling like me? Are there any preferred solutions that anyone on the list has tried? If I can find out the csv format required, would it be helpful to any users to be able to export this automatically from Gnucash? I could construct mine by hand and just copy it every month, so I am not needing this myself. Liz ___ 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] Dimensions in Accounts
You can use the NUM field for a document number if you like. Also available are the Notes, and the Action & Memo fields for each split. There is also a function where you can link a document on your computer to the transaction. (like a scanned receipt) Regards, Adrien > On Sep 13, 2019 w37d256, at 9:57 AM, Hans Henrik wrote: > > We are a small company using gnucash for our accounting. > > We have a similar requirement that we would like to attach reference to > documentation to the transactions (expenses). The possible to indicate annex > number or similar would be fine, so it is easy to find related documentation > the expenses. ___ 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] Badly formed URL unknown-type
Many thanks for looking at this. Details are: GnuCash 3.7 Build ID: 3.7+(2019-09-07) Static hostname: abacus.home Icon name: computer-desktop Chassis: desktop Operating System: Ubuntu 18.04.3 LTS Kernel: Linux 5.0.0-27-generic Architecture: x86-64 I'm inserting an image in case it helps, however if this is not done please tell me and I will know for the future. Best Regards, Uttam On 13/09/2019 20:18, Geert Janssens wrote: > Op vrijdag 13 september 2019 20:50:35 CEST schreef Uttam Chakravorty: > >> Firstly I apologise if I should be trying something other than posting >> here. If so, any guidance would be appreciated. >> >> I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK VAT >> registered company (two people: my wife and our son). >> >> When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the first >> entry the Company is blank, the days are zero and there is -£2.54 in the >> total column. >> >> Clicking on -£2.54 calls up a box displaying 'Badly formed URL >> unknown-type=&acct=48dfa64b05d642c5f5c4cc051 >> 3dba700' >> >> I have run 'Actions' -> 'Check & Repair' globally and on each individual >> account to no avail. I'm stumbling around in the dark. > > Hi, > > Which version of GnuCash are you using ? I seem to remember fixing this in > one > of the more recent releases. > > Regards, > > Geert ___ 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] Convert credit cards as expenses to credit cards as liabilities?
> If you?re going to keep using the simplified method, there?s no point to > changing the account type. > > #1 you?d lose expense tracking entirely for anything spent via the card. > #2 credit card liability would forever be ?negative? (meaning they owe you) > > The simplified method works as you have been doing it. > > The more real-world method is as follows: > > - > When making a purchase on credit: > > Dr. Expenses:(whatever) > Cr. Liabilities:Credit Card > > When making a payment on the card: > > Dr. Liabilities:Credit Card > Cr. Checking > > Now you can track what you spent the money on, as well as how much you owe on > the card. > > -- > > With the current method, all you are doing is recording the card payment from > checking and no specific expense tracking at all. (even though it is listed > as an expense account, you keep increasing it forever as a generic) But an > Income Statement will make sense, as will your Balance Sheet > > With the switch you are considering, you?d just be doing the second of the > above two transactions instead of: > > Dr. Expenses:Credit Card > Cr. Checking > > Which would remove expenses entirely and make your liabilities look like > assets since they are negative. (because you keep paying more down, without > the charge part of the transaction) So both your Income Statement and Balance > Sheet would be wrong. > > It wouldn?t be hard to switch the historical data, especially since it is > just 240 transactions. (which you?ve already noted you don?t mind altering) > > That would *maybe* involve changing the account type. You shouldn?t need to > alter those 240 transactions, because those splits assigned to the card are > still going to be debits. (they were payments, now on a liability which is > correct) > > If you can?t just change the type, then create the new liability account and > then delete the old expense account. When GnuCash asks, choose the liability > version to assign the transactions to. In a very worst case, you?d have to do > that manually 240 times, but I think it is going to be more automatic than > that. > > What you would need to do for the card account balance to make sense (and not > understate your liabilities) is to also enter 240 expense transactions > between the card and ?something?. (you might also do this as annual > transactions, or even a single transaction as the sum of everything up to > this point) > > If you don?t know or don?t care what those historical transactions were for, > you could either leave the expenses:card in place and assign them there, or > create a ?miscellaneous? account or something similar and then proceed in the > future with recording actual expenses paid with the card. > > You might also be able to download some of that actual history from your card > company if you think you want it. (I doubt all 10 years though) > > Regards, > Adrien > > Thank you, Adrien. We can close this. I'll try your import idea using my Expenses:Credit Card export as a baseline. First I'll modify it using search and replace for what the Liabilities:Credit Card account should look like with regard to Expenses:Credit Card, then, second, I'll modify the Expenses:Credit Card account to remove the checking account reference - probably I'll just remove all the transactions and allow them to rebuild when I import the Liabilties:Credit Card transaction. Finally, I'll modify the original Expenses:Credit Card transactions to reflect them paid from within the Liabilities:Credit Card account. I'll try all this with the Transaction ID removed. If this doesn't work, then I'll fall back to just doing it properly from now on. I did check my bank's download capability and it's limited to 120 days, though they do have 10 years worth of monthly statements. Again, thanks. ___ 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] Should i be worried about this report?
Dear sirs: On my Accounts page, everything looks o.k., but when i print this General Journal page, i see a list of Imbalances... Gen. Journal 1 Gen. Journal 2 Have a wonderful afternoon! :-) fred smime.p7s Description: S/MIME Cryptographic Signature ___ 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 not obtaining lock Solved
On 9/13/2019 1:50 PM, Bob Hammons wrote: The trouble was Windows Defender in a recent update blocked Gnucash, Quicken and Open Office data directories. This was in the Ransom ware section Here is a website that explains how to fix this .. Wasn't very nice of MS to do this without any notice that these programs would be blocked Thanks again for you help I did learn a little more about Windows but something new will pop up I am sure. That does not seem to me to be much of an explanation. I don't know about Quicken, but with either OpenOffice (I use LibreOffice) or Gnucash the "data directories" (the directory in which the data lives AND where the lock file will be created) is up to you. Certainly MS didn't block "Documents" (the parent directory where LibreOffice documents likely placed). If, what you are referring to are default locations which these applications might use IF you failed to specify where your documents were to be put that's another matter. I'm not at all sure I would be so critical of MS in that case. It is a really bad idea for people to allow applications to simply place data wherever so you don't KNOW the location. For example, if you don;t know the location, how do you know what directories you want copied to your backup device (you DO make periodic backups, right?). Thus, if I Know that ALL such data would be in the "Documents" tree (organized by sub directories so you can find things) then you know your backup procedure would want to copy "Documents" (and everything in it) when making a backup. In which case you don't need to think of separate backup for each application. When you create a new set of books in gnucash (a new file) the FIRST action you should take after opening it should be a "save as" to the desired location << say in a directory under documents named "Gucash Books" --although there I would have a directory for each set of books since I keep several -- that makes it easier to clean out old log/session backups for a particular set of books since those, and the lock file, will be in the directory where the file is >> Michael D Novack PS when some of us say "directory" that is not different from what you know of as a "file folder". We just learned before it was graphical. Michael D Novack ___ 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] (not) AQbanking setup crash
Please remember to copy the list on all replies. That's the one. Apple changes the name and layout periodically. The person I replied to is using Sierra and you're on Mojave. Also he was using 2.6.21 and your crash report says you've got 3.6. That backtrace looks familiar, too... Oh, yeah, here we are: https://bugs.gnucash.org/show_bug.cgi?id=797375 submitted 23 August by one "Dizzy" Deane Yamane. Maybe you know him? ;-) That bug is waiting for you to attach a trace file from a crash. Looks like you have a lot of crashes in your Console. Are they all the same? Regards, John Ralls > On Sep 11, 2019, at 3:31 PM, Deane Yamane wrote: > > Huh? … All I see on MacOS Mojave is this. I don’t see User Diagnostics. > > >> On Sep 10, 2019, at 5:52 AM, John Ralls wrote: >> >> >> >>> On Sep 9, 2019, at 7:33 PM, aegross wrote: >>> >>> I used to use aqbanking to download credit card transactions but stopped a >>> couple of years ago; it used to work but I don't recall what version of >>> GnuCash I was using then. >>> >>> Today, I tried using the aqbanking wizard and GnuCash crashed. I also tried >>> Actions\Online Actions\Show log window and that crashed GnuCash also. >>> >>> GnuCash version: 2.6.21 >>> MacOs version: Sierra (10.12.6). Owing to the age of the Mac, this is the >>> last recent version that Apple will support. >>> >>> I did some looking around for relevant documentation on how to debug but am >>> not having success. If anyone has any ideas, would be appreciated. >> >> The first step in debugging a crash on a Mac is to open >> /Applications/Utilities/Console, select User Diagnostics in the sidebar and >> find the Gnucash crash reports and examine them. >> >> GnuCash 2.6 is no longer supported and 2.6.21 has an old version of >> AQBanking as well. Please upgrade to 3.7, released last Sunday. If it still >> crashes file a bug report at https://bugs.gnucash.org and attach the crash >> report. >> >> Regards, >> John Ralls >> >> ___ >> 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] Gnucash not obtaining lock Solved
> On Sep 14, 2019, at 5:11 PM, Mike or Penny Novack > wrote: > > On 9/13/2019 1:50 PM, Bob Hammons wrote: >> The trouble was Windows Defender in a recent update blocked Gnucash, >> Quicken and Open Office data directories. >> This was in the Ransom ware section >> Here is a website that explains how to fix this >> .. >> Wasn't very nice of MS to do this without any notice that these programs >> would be blocked >> Thanks again for you help I did learn a little more about Windows but >> something new will pop up I am sure. > That does not seem to me to be much of an explanation. I don't know about > Quicken, but with either OpenOffice (I use LibreOffice) or Gnucash the "data > directories" (the directory in which the data lives AND where the lock file > will be created) is up to you. Certainly MS didn't block "Documents" (the > parent directory where LibreOffice documents likely placed). > Well, actually, yes. And it makes sense. They’re trying to protect you from ransomware - software that encrypts your stuff and then offers to give you the decryption key if you pay up. The idea is that a known list of applications are allowed to touch files in the protected directories, and you can add trusted applications to that list. From the first page of the web site linked in the previous message: > > Controlled folder access applies to a number of system folders and default > locations, including folders such as Documents, Pictures, Movies, and Desktop. ___ 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 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"
The XML file is (optionally, see Preferences>General) compressed with gzip. You might try reopening the database and see if it still takes 20 minutes. ISTR that there was a database upgrade somewhere around 2.6.12 and if so it would take a while to create the new tables, copy all of the records over, and clean up. On Windows you can either run GnuCash from a shell window (CMD or Powershell both work) with the path and any options, e.g. "C:\Program Files (x86)\gnucash\bin\gnucash.exe" --debug --nofile or if you want those options more permanently you can edit the command in the shortcut. Regards, John Ralls > On Sep 13, 2019, at 8:11 PM, GWB wrote: > > OK, will do. This is interesting. I moved the file to a Windows 7 > machine, and opened it with GnuCash 2.6.21. It did read the sqlite3 > file, but it took a long time, probably 20 minutes or so. After it > opened, I saved it as an xml file. GnuCash does open the .xml file > more quickly, so perhaps I should stick with that format. My > assumption is that Windows GnuCash reads and writes to sql formats > without installing those dependencies directly. > > So how do I start GnuCash in Windows using the --nofile --debug > options? It appears to always try to open the last opened file. > > I also notice the xml file is much, much smaller than the sqlite3 > file. The xml is 4.6 Megs, and the sqlite3 file is 65 megs. This is > a file with many years, going back to 2009, but the data all appears > to be there. That's not a bad feature, if it still has all the data. > And if xml it allows transaction "replays" or rollbacks, then great. > I'll stick with it. I'm a fan of data in db formats, but not when the > older xml format functions without errors. > > GnuCash 3 it is. I'll install the latest on Ubuntu and Windows and > see how it does with this xml file. > > Is there a file parser or checker that can correct errors in an > account file? I should give that a whirl and see what it finds. > > Thanks again, you guys rock, > > Gordon > > On Fri, Sep 13, 2019 at 9:59 PM John Ralls wrote: >> >> >> >>> On Sep 13, 2019, at 11:53 AM, GWB wrote: >>> >>> Hello, GnuCash Users, >>> >>> Gnucash will begin to start, then abort (crash) when launched, using >>> normal startup or gnucash --nofile --debug. Output from terminal is: >>> >>> $ gnucash --nofile --debug >>> Found Finance::Quote version 1.38 >>> ** >>> GLib:ERROR:/build/glib2.0-pjKWYQ/glib2.0-2.48.2/./glib/ghash.c:373:g_hash_table_lookup_node: >>> assertion failed: (hash_table->ref_count > 0) >>> Aborted (core dumped) >>> >>> So this is some kind of hash table assertion failure? I have the >>> gnucash.trace and apport bug reports as well, but before I send them I >>> thought I would ask if someone else has seen this. I can rollback to >>> an earlier version of the file, but I would like to get this >>> particular version working now. >>> >>> I might also copy the file to a Windows machine, and install GnuCash >>> there. Or, possible, copy and upgrade to GnuCash 3, and then try to >>> figure out how to move my reports. >>> >>> Any help is greatly appreciated! >>> >> >> It's basically a use-after-free situation. >> >> We're not maintaining the 2.6 branch anymore, so your best bet is to upgrade >> to GnuCash 3.7, the latest release. It's certainly buildable on Ubuntu >> 16.04, our 3.x CI uses Ubuntu 14.04, but the user-prepared .deb will >> probably not find the right dependencies. >> >> Regards, >> John Ralls >> >> ___ 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 not obtaining lock Solved
> On Sep 14, 2019, at 5:11 PM, Mike or Penny Novack > wrote: > > On 9/13/2019 1:50 PM, Bob Hammons wrote: >> The trouble was Windows Defender in a recent update blocked Gnucash, >> Quicken and Open Office data directories. >> This was in the Ransom ware section >> Here is a website that explains how to fix this >> .. >> Wasn't very nice of MS to do this without any notice that these programs >> would be blocked >> Thanks again for you help I did learn a little more about Windows but >> something new will pop up I am sure. > That does not seem to me to be much of an explanation. I don't know about > Quicken, but with either OpenOffice (I use LibreOffice) or Gnucash the "data > directories" (the directory in which the data lives AND where the lock file > will be created) is up to you. Certainly MS didn't block "Documents" (the > parent directory where LibreOffice documents likely placed). > Well, actually, yes. And it makes sense. They’re trying to protect you from ransomware - software that encrypts your stuff and then offers to give you the decryption key if you pay up. The idea is that a known list of applications are allowed to touch files in the protected directories, and you can add tru ___ 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] STP (Australia only)
Liz, I've played around with a couple of the Free apps that the ATO lists on their webpage. Payroller is a web interface app i.e runs on a server somewhere that seems pretty easy to use and similarly ClockOn. The freebies are generally cloud based and are primarily meant to entice you into their paid solutions in most cases, but there is no obligation to do so. Only problem is your data is on their site and not retained by your business I had a look at the developer's page about 6 months ago. I found it almost impossible to navigate with a lot of missing information at that time. A look a few weeks later and there appeared to be more there but still obscure and very hard to follow. I think to get full access you have to join the software developers consortium which requires you to have an Auskey which in turn requires you to be a registered business. A deliberate attempt to cut out the free software market. I have an ABN for a publishing operation my wife and I setup to self publish her poetry so I might be able to get in using that and find out if there is an easy way to interface Gnucash. 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] GnuCash 2.6.12 aborts (core dump) on Ubuntu 16 "hash table assertion failed"
Great, thank you, that helps. This is probably also a problem with gnucash 2.6.12 on ubuntu 16. When I now launch gnucash --nofile --debug it appears to hang on the opening screen and does not complete launch, so there is no menu to open files. My guess is that something went wrong in upgrading a dependency, perhaps sqlite3, and 2.16.12 is not going to respond now (i.e,. the sqlite3 upgrade is a "feature" to all the other dependencies, and a "bug" only to gnucash). The Windows version of 2.16.12 probably did what you are describing. It opened the sqlite3 files, did the database changes, and then allowed me to save it as xml. I'm not going to try to debug gnucash 2.6.12 and sqlite3 on Ubuntu 16 if I can avoid it. An upgrade to Ubuntu 18 is probably inevitable sooner rather than later, given the life cycle of the OS, and guncash 3 also looks necessary at this point. So will my reports on Ubuntu from gnucash 2.6 be automatically available in gnucash 3? Any particular type of voodoo needed to make that happen? Again, you guys rock. Gordon Bynum On Sat, Sep 14, 2019 at 4:59 PM John Ralls wrote: > > The XML file is (optionally, see Preferences>General) compressed with gzip. > > You might try reopening the database and see if it still takes 20 minutes. > ISTR that there was a database upgrade somewhere around 2.6.12 and if so it > would take a while to create the new tables, copy all of the records over, > and clean up. > > On Windows you can either run GnuCash from a shell window (CMD or Powershell > both work) with the path and any options, e.g. > "C:\Program Files (x86)\gnucash\bin\gnucash.exe" --debug --nofile > or if you want those options more permanently you can edit the command in the > shortcut. > > Regards, > John Ralls > > > > On Sep 13, 2019, at 8:11 PM, GWB wrote: > > > > OK, will do. This is interesting. I moved the file to a Windows 7 > > machine, and opened it with GnuCash 2.6.21. It did read the sqlite3 > > file, but it took a long time, probably 20 minutes or so. After it > > opened, I saved it as an xml file. GnuCash does open the .xml file > > more quickly, so perhaps I should stick with that format. My > > assumption is that Windows GnuCash reads and writes to sql formats > > without installing those dependencies directly. > > > > So how do I start GnuCash in Windows using the --nofile --debug > > options? It appears to always try to open the last opened file. > > > > I also notice the xml file is much, much smaller than the sqlite3 > > file. The xml is 4.6 Megs, and the sqlite3 file is 65 megs. This is > > a file with many years, going back to 2009, but the data all appears > > to be there. That's not a bad feature, if it still has all the data. > > And if xml it allows transaction "replays" or rollbacks, then great. > > I'll stick with it. I'm a fan of data in db formats, but not when the > > older xml format functions without errors. > > > > GnuCash 3 it is. I'll install the latest on Ubuntu and Windows and > > see how it does with this xml file. > > > > Is there a file parser or checker that can correct errors in an > > account file? I should give that a whirl and see what it finds. > > > > Thanks again, you guys rock, > > > > Gordon > > > > On Fri, Sep 13, 2019 at 9:59 PM John Ralls wrote: > >> > >> > >> > >>> On Sep 13, 2019, at 11:53 AM, GWB wrote: > >>> > >>> Hello, GnuCash Users, > >>> > >>> Gnucash will begin to start, then abort (crash) when launched, using > >>> normal startup or gnucash --nofile --debug. Output from terminal is: > >>> > >>> $ gnucash --nofile --debug > >>> Found Finance::Quote version 1.38 > >>> ** > >>> GLib:ERROR:/build/glib2.0-pjKWYQ/glib2.0-2.48.2/./glib/ghash.c:373:g_hash_table_lookup_node: > >>> assertion failed: (hash_table->ref_count > 0) > >>> Aborted (core dumped) > >>> > >>> So this is some kind of hash table assertion failure? I have the > >>> gnucash.trace and apport bug reports as well, but before I send them I > >>> thought I would ask if someone else has seen this. I can rollback to > >>> an earlier version of the file, but I would like to get this > >>> particular version working now. > >>> > >>> I might also copy the file to a Windows machine, and install GnuCash > >>> there. Or, possible, copy and upgrade to GnuCash 3, and then try to > >>> figure out how to move my reports. > >>> > >>> Any help is greatly appreciated! > >>> > >> > >> It's basically a use-after-free situation. > >> > >> We're not maintaining the 2.6 branch anymore, so your best bet is to > >> upgrade to GnuCash 3.7, the latest release. It's certainly buildable on > >> Ubuntu 16.04, our 3.x CI uses Ubuntu 14.04, but the user-prepared .deb > >> will probably not find the right dependencies. > >> > >> Regards, > >> John Ralls > >> > >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnu
Re: [GNC] Gnucash not obtaining lock Solved
On 9/14/2019 5:59 PM, R. Victor Klassen wrote: Well, actually, yes. And it makes sense. They’re trying to protect you from ransomware - software that encrypts your stuff and then offers to give you the decryption key if you pay up. The idea is that a known list of applications are allowed to touch files in the protected directories, and you can add tru AH my misunderstanding is because of how described. Coming from the mainframe world (my working days) the concept of "authorized" programs and directories is quite familiar to me. In that environment there was also a level of authorization based on the login of who was running the program. Normal security to me. The threat less things like ransom ware (full back up daily) than selective changes by a malicious user << which would likely be on all generations of backups before being discovered >> Since I am about to retire this old X200 under 7 replacing with a W541 under 10 I can see I will have a choice to make. Either add the apps I will be installing to the authorized app list or turning the feature off. We might consider an addition to the documentation for installing gnucash under Windows 10 << add to list of authorized apps >> I think this is in general a good idea on a shared computer. In my case, my wife is too non-techie to even think of trying to install something. But if we had grandkids living with us? << the great grands are too young to mess with computers >> Michael D Novack -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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] STP (Australia only)
Liz, Possible more significant will be the SBR (standard Business Reporting) of which the STP is one of the first installments. It will have an extension of the MyGov ID which will be used for reporting to multiple agencies which will replace AUSkey in March 2020. It will be used for any of the following: Australian Business Register Australian Taxation Office Australian Securities and Investments Commission ACT Revenue Office QLD Office of State Revenue NSW Office of State Revenue Revenue SA TAS State Revenue Office Territory Revenue Office State Revenue Office VIC WA State Revenue and will address things like licence renewals, business registrations etc directly. 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 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] STP (Australia only)
On Sat, 14 Sep 2019 17:27:02 -0500 (CDT) David Cousens wrote: > Liz, > > I've played around with a couple of the Free apps that the ATO lists > on their webpage. Payroller is a web interface app i.e runs on a > server somewhere that seems pretty easy to use and similarly ClockOn. > The freebies are generally cloud based and are primarily meant to > entice you into their paid solutions in most cases, but there is no > obligation to do so. Only problem is your data is on their site and > not retained by your business > > I had a look at the developer's page about 6 months ago. I found it > almost impossible to navigate with a lot of missing information at > that time. A look a few weeks later and there appeared to be more > there but still obscure and very hard to follow. I think to get full > access you have to join the software developers consortium which > requires you to have an Auskey which in turn requires you to be a > registered business. A deliberate attempt to cut out the free > software market. I have an ABN for a publishing operation my wife and > I setup to self publish her poetry so I might be able to get in using > that and find out if there is an easy way to interface Gnucash. > > David Cousens The apps shown on the ATO page, as you noted, are there to entice one into paying later. I have figured out that I will save $8 in stamps each year if I don't have to send in IAS forms. What I did work out was that most of those companies are actually using another company again for the data exchange with the government. This is the list the ATO provides to help one choose https://www.ato.gov.au/business/single-touch-payroll/in-detail/low-cost-single-touch-payroll-solutions/ This is the complete ATO list https://api.gov.au/productregister/ This is an example of a company which actually interfaces with the ATO https://www.ozedi.com.au/products-and-services/ebms3-as4/ It actually has more information on its website than most of the others combined. Incidentally, I did sign up with Payroller which appeared to be as basic as possible, although I have to provide a fictitious number of hours each week I work to make the system produce an output. After I have registered the choice with the ATO I will be able to make it work and see if it is appropriately functional. Liz ___ 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] Invoice report error
I select 'invoice Report' from the Customer context menu. Which report it is actually I don't know. The problem is/was that there was no A/R account. I can understand that programming a correct prerequisites check into the report in Scheme might be complex, but the error message is completely unclear. I am currently running into consistent segfaults with my local builds on Ubuntu 16.04, so it is kinda frustrating to work with. Regards, Michiel Op 14 sep. 2019 7:48 a.m. schreef Christopher Lam : This is not an invoice-report. This is either customer, vendor or job report. There must be something unusual in the AP/AR account selection in the General tab in options. Or there may be something from a previous installation which must be cleared properly. On Sat, 14 Sep 2019 at 05:32, michielu <[1]gnuc...@uitdehaag.org> wrote: I just compiled and installed the 3.7 Gnucash version as offered on the front-page. When I try to run an invoice report on my existing gnucash file, I get: In ice-9/boot-9.scm: 157: 17 [catch #t # ...] In unknown file: ?: 16 [apply-smob/1 #] In {INSTALL}/gnucash-3.7/libgnucash/app-utils/c-interface.scm: 22: 15 [gnc:call-with-error-handling "(gnc:report-run 0)" ()] In ice-9/boot-9.scm: 157: 14 [catch #t ...] In {INSTALL}/gnucash-3.7/libgnucash/app-utils/c-interface.scm: 27: 13 [#] In unknown file: ?: 12 [eval-string "(gnc:report-run 0)" #] In ice-9/boot-9.scm: 2401: 11 [save-module-excursion #] In ice-9/eval-string.scm: 44: 10 [read-and-eval # #:lang ...] 37: 9 [lp (gnc:report-run 0)] In {INSTALL}/gnucash-3.7/gnucash/report/report-system/report.scm: 776: 8 [gnc:report-run 0] In {INSTALL}/gnucash-3.7/libgnucash/app-utils/c-interface.scm: 64: 7 [gnc:backtrace-if-exception #] 22: 6 [gnc:call-with-error-handling # ...] In ice-9/boot-9.scm: 157: 5 [catch #t ...] In {INSTALL}/gnucash-3.7/libgnucash/app-utils/c-interface.scm: 26: 4 [#] In /home/michiel/dev/gnucash-3.7/gnucash/report/report-system/report.sc m: 780: 3 [#] 754: 2 [gnc:report-render-html # #t] In {INSTALL}/gnucash-3.7/gnucash/report/business-reports/owner-report.s cm: 740: 1 [reg-renderer #] In unknown file: ?: 0 [gnc-account-get-book #f] ERROR: In procedure gnc-account-get-book: Wrong type argument in position 1: #f -- Sent from: [2]http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list [3]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [5]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:gnuc...@uitdehaag.org 2. http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. 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] Gnucash doesn't load American Express QFX files
An update on this. The development branch, at least, on the libofx github https://github.com/libofx/libofx can parse the American Express OFX files. I'm not sure when that ability was added, I didn't try any releases, just the latest commit on the github. So I was able to get them working with GnuCash 3.6. I assume this version of libofx will make it into the repositories eventually, but for now users will have to build their own libofx I guess. Jim ___ 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] How to manage earmarked funds [SOLVED]
Thanks to everyone who offered advice/help. We've got this one solved. Have a great evening! :) On 9/12/19 2:54 PM, David Cousens wrote: Fred, This subject has been addressed many times on the forum/mailing list so if you search the forum or mailing list archives for "Earmaked funds " you will find the previous replies some of the more recent of which are linked below on the Nabble web interface to the archives. http://gnucash.1415818.n4.nabble.com/Earmarking-funds-for-specific-purposes-tp4687783.html http://gnucash.1415818.n4.nabble.com/Best-way-to-earmark-funds-tp1424776.html http://gnucash.1415818.n4.nabble.com/GNC-How-to-manage-earmarked-funds-tp4713084.html http://gnucash.1415818.n4.nabble.com/GNC-Non-profit-accounts-reporting-of-restricted-funds-and-of-future-commitments-tp4711813p4711814.html Cheers 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. smime.p7s Description: S/MIME Cryptographic Signature ___ 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.