Re: command line QIF import
What do you mean "failed"? They aren't in the gnucash file at all? Or, they import incorrectly? If the latter, take a look at some of the transactions that failed; is there something in common? In my Quicken data, it was transactions that had no categories that caused the most problems. Fill things in, try again and see what happens. Rinse and repeat until your data is clean enough, and pick up the rest afterwards. If they didn't import at all, I don't know what to say. David On Sun, Oct 15, 2017 at 22:50, Nelson wrote: Thank you for your answer David. I am aware that QIF is a text file and I can open it in text editor. I have a 235000 lines QIF file created by quicken. Most of the transactions are being imported properly but there are thousands failing as well. I have no way to identify those failed transactions other than going line by line in each account. What shall I "edit in quicken first" to insure a successful import? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
There are multiple classes of failures and most of them seems to be transfers related. There are the ones a which show up more often: - missing transactions - duplicate transactions - voided transactions (transaction exist but flagged as "void" and has zero amount) - transactions in wrong account (transfer from account.A to account.B recorded as debit account.A and credit account.C) I totally understand QIF format limitations. When I do a transfer from account.A to account.B, and I download the transactions from the bank in Quicken, account.B trx. will show up in one day while account.B will show up couple days later, maybe 2 to 5 days. While Quicken will match these properly, GnuCash will create duplicates most-likely, because in the exported QIF file there are two different transactions, one for account.A and one for account.B. That's why I am saying that having some flags to tuneup the import process and detailed logging would help a lot. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
gnucash and mysql: Incorrect datetime value for column 'post_date'
Hello, I'm trying to convert my existing gnucash account from xml to mysql. I created a new mysql database, but when I try to save my data into this database with gnucash I get the following error message: <--- cut here ---> mysql error: Incorrect datetime value: '18981201105900' for column 'post_date' at row 1 <--- cut here ---> In another thread I found the recommendation to adjust the sql_mode using sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Unfortunately, this doesn't change the behaviour for me. Here are some version information: Operating System: Linux opensuse LEAP 42.2 gnucash: gnucash-2.6.16-3.3.1.x86_64 mysql: mariadb-10.0.31-20.7.1.x86_64 Any hint how to get rid off this error is really appreciated. Regards, Joerg Mit TravelXtra profitieren Sie von 5% Rückvergütung auf den Reisepreis – bekannte dt. Reiseanbieter und ein umfangreiches Reiseangebot wie im Reisebüro! https://email.freenetde/reisen/index.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Vendor Bill - Invoice Entries
On 10/15/2017 10:08 PM, DaveC49 wrote: Hi, The facilities you are requesting are likely to require an inventory management system. At present Gnucash is an accounting package and currently does not incorporate any features for inventory management. As far as i know there are no plans to incorporate such features in the near future. To do so would reuire a developer(s) interested in developing these features. Similarly while it can handle the accounting specific side of payroll management it does not handle the calculation of payrolls, deductions, taxes etc. You may need to took at ERP software if you require these facilities. David Cousens I am going to point something out. Gnucash is an accounting package. A business might need a number of OTHER packages that would interact with the accounting package, but normally are separate parts. Why separate? Because which of these other parts a business might want/need depend on the business. A unified business application (including ALL the different possible pieces) would be unnecessarily bulky, with a given business never using many of those pieces. inventory -- only if the business HAS inventory that it sells payroll -- only if the business has employees (employees in the legal sense of that word) billed time -- only of a business deals in "billable hours" POS --- only if a business does this kind of retail << point of sales not only interacts with accounting but also inventory >> etc. etc. etc. Since I do accounting just for non-profits, I am aware of OTHER "pieces" that would apply to this specialty. Just because I may be using gnucash to provide these pieces does NOT mean "part of gnucash" << I am simply ALSO using gnucash to implement "virtual books" for those specific pieces >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
Nelson, It sounds to me like you are unwilling make the effort to "shepherd" your data through the import process. Many of us, including David T are trying to tell you that we have succeeded in completing massive imports from Quicken into GnuCash, but we needed to take several steps to plan our procedure, prepare the data, preprocess data and postprocess data to do it. Each case will vary because each of us took different shortcuts and entered data from different financial institutions, etc. when using Quicken. We also have different ideas about what details are most important to preserve vs what is "noise" David C On Mon, Oct 16, 2017 at 7:55 AM, Nelson wrote: > There are multiple classes of failures and most of them seems to be > transfers > related. There are the ones a which show up more often: > > - missing transactions > - duplicate transactions > - voided transactions (transaction exist but flagged as "void" and has zero > amount) > - transactions in wrong account (transfer from account.A to account.B > recorded as debit account.A and credit account.C) > > I totally understand QIF format limitations. When I do a transfer from > account.A to account.B, and I download the transactions from the bank in > Quicken, account.B trx. will show up in one day while account.B will show > up > couple days later, maybe 2 to 5 days. While Quicken will match these > properly, GnuCash will create duplicates most-likely, because in the > exported QIF file there are two different transactions, one for account.A > and one for account.B. > > That's why I am saying that having some flags to tuneup the import process > and detailed logging would help a lot. > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Migrate from Moneydance to Gnucash
Is there a recommended procedure for migrating Moneydance to GnuCash? ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
On 16 October 2017 at 10:50, wrote: > Hello, > > I'm trying to convert my existing gnucash account from xml to mysql. I > created a new mysql database, but when I try to save my data into this > database with gnucash I get the following error message: Don't manually create the database first. Just use File > Save As and give it a database name. You can overwrite an existing gnucash database in this way but don't try to overwrite an existing db unless it was created by gnucash. I am not guaranteeing that this is the problem, but try that first. > > Operating System: Linux opensuse LEAP 42.2 > gnucash: gnucash-2.6.16-3.3.1.x86_64 > mysql: mariadb-10.0.31-20.7.1.x86_64 I don't know whether anyone has tried it with mariadb, but it should be ok as maria is supposed to be a dropin replacement for mysql. Colin ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
You're getting very defensive here David and your posts are not contributing to this discussion at all. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
On Mon, Oct 16, 2017 at 8:55 AM, Nelson wrote: > > That's why I am saying that having some flags to tuneup the import process > and detailed logging would help a lot. > It sounds like you've identified some areas for improvement. This is a volunteer project, so the more you can do to make this happen, the more likely it will happen. Creating a detailed bug report would be the first step. If you have some quite specific ways to improve the process, that would be very helpful. If you're comfortable with C++, feel free to contribute a patch (it doesn't need to be perfect; we can work with you, too). ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
> On Oct 16, 2017, at 2:50 AM, joerg_dieder...@freenet.de wrote: > > Hello, > > I'm trying to convert my existing gnucash account from xml to mysql. I > created a new mysql database, but when I try to save my data into this > database with gnucash I get the following error message: > > <--- cut here ---> > mysql error: Incorrect datetime value: '18981201105900' for column > 'post_date' at row 1 > <--- cut here ---> > > In another thread I found the recommendation to adjust the sql_mode using > > sql_mode = > ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION > > Unfortunately, this doesn't change the behaviour for me. > > > Here are some version information: > > Operating System: Linux opensuse LEAP 42.2 > gnucash: gnucash-2.6.16-3.3.1.x86_64 > mysql: mariadb-10.0.31-20.7.1.x86_64 > > > Any hint how to get rid off this error is really appreciated. We need to change the schema for MySQL/MariaDB to use DATETIME instead of TIMESTAMP; the latter’s date range is only 1 Jan 1970-15 Jun 2038. It’s on my to-do list for 2.8. For 2.6 you’ll need to use Postgresql instead if you need your books to run before 1970. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
Hi Colin, thank you very much for the quick response to my post. I dropped the database and let gnucash create it. But I get the same error message again. Joerg On Mon, 16 Oct 2017 14:46:31 +0100 Colin Law wrote: > On 16 October 2017 at 10:50, wrote: > > Hello, > > > > I'm trying to convert my existing gnucash account from xml to mysql. I > > created a new mysql database, but when I try to save my data into this > > database with gnucash I get the following error message: > > Don't manually create the database first. Just use File > Save As and > give it a database name. You can overwrite an existing gnucash > database in this way but don't try to overwrite an existing db unless > it was created by gnucash. I am not guaranteeing that this is the > problem, but try that first. > > > > > Operating System: Linux opensuse LEAP 42.2 > > gnucash: gnucash-2.6.16-3.3.1.x86_64 > > mysql: mariadb-10.0.31-20.7.1.x86_64 > > I don't know whether anyone has tried it with mariadb, but it should > be ok as maria is supposed to be a dropin replacement for mysql. > > Colin > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: Ordering Transactions on same date
Solved the problem in aneasier way... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
On 10/16/2017 09:52 AM, Nelson wrote: > You're getting very defensive here David and your posts are not contributing > to this discussion at all. > Hi Nelson, This mailing list is gut wrenching to read. Sadly, it's not a new thing for these open-source project communities to degenerate into something of a Lord of the Flies type of mosh-pit situation with an overall tone of hateful stupidity. I suspect the lack of structural support for social organization and operational sophistication allows squatters and vandals to gain a foothold and eventually dominate a project. Anyway, from the little that I've seen in the last couple of days, it doesn't look like there was ever any significant influence of data integrity engineering involved in the architecture and infrastructure of this software system. While this software might not be considered a safety critical system [1], the decisions that are based on the data involved could have serious impact on people's lives. >From this perspective, whether or not GnuCash is salvageable, I don't know; but in the short term, it's probably prudent to find a more reliable method and tools to manage one's critical data, IMO. [1]: https://en.wikipedia.org/wiki/Safety-critical_system ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
On 16 October 2017 at 7:27, John Ralls said: > > > > On Oct 16, 2017, at 2:50 AM, joerg_dieder...@freenet.de wrote: > > > > Hello, > > > > I'm trying to convert my existing gnucash account from xml to mysql. I > > created a new mysql database, but when I try to save my data into this > > database with gnucash I get the following error message: > > > > <--- cut here ---> > > mysql error: Incorrect datetime value: '18981201105900' for column > > 'post_date' at row 1 <--- cut here ---> > > > > In another thread I found the recommendation to adjust the sql_mode > > using > > > > sql_mode = > > ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISIO > > N_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION > > > > Unfortunately, this doesn't change the behaviour for me. > > > > > > Here are some version information: > > > > Operating System: Linux opensuse LEAP 42.2 > > gnucash: gnucash-2.6.16-3.3.1.x86_64 > > mysql: mariadb-10.0.31-20.7.1.x86_64 > > > > > > Any hint how to get rid off this error is really appreciated. > > We need to change the schema for MySQL/MariaDB to use DATETIME instead of > TIMESTAMP; the latter’s date range is only 1 Jan 1970-15 Jun 2038. > It’s on my to-do list for 2.8. > > For 2.6 you’ll need to use Postgresql instead if you need your books to > run before 1970. A date in 1898 (as reported) looks more like a data error. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote: > > A date in 1898 (as reported) looks more like a data error. I know the OP mentioned Linux - but isn't that date something to with a (fixed/ resolved) windows bug creating transactions from "before time existed" Just rings a distant bell with me... Maybe a grep of the xml file for something like the problem timestamp and fixing the data manually? A postdate won't be visible in the registers anywhere AFAIK. Back up the data file first then back it up again... 0.02 Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Ordering Transactions on same date
On Monday, 16 October 2017 16:18:49 BST baneeishaque wrote: > Solved the problem in aneasier way... > OK. I'll bite. What is the easier way?Others in the future might benefit from your method? BTW, happy to hear that you found a solution. Cheers, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Importing Data
I have just purchased a new laptop with Windows 10 and am trying to import the data from my old laptop onto it. Which files do I look for and how can I put them on my new machine? Rick ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
Hi Maf, thank you very much for this hint. I guess it points into the right direction. I've just checked my xml file and indeed, there is an entry with such a strange date. I will try to fix it as suggested and look, if I can save the data into my mysql database. Joerg On Mon, 16 Oct 2017 20:46:14 +0100 "Maf. King" wrote: > On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote: > > > > > A date in 1898 (as reported) looks more like a data error. > > I know the OP mentioned Linux - but isn't that date something to with a > (fixed/ > resolved) windows bug creating transactions from "before time existed" Just > rings a distant bell with me... > > Maybe a grep of the xml file for something like the problem timestamp and > fixing > the data manually? A postdate won't be visible in the registers anywhere > AFAIK. > > Back up the data file first then back it up again... > > 0.02 > Maf. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Migrate from Moneydance to Gnucash
I think it is about the same as from Quicken, but perhaps easier because Moneydance is closer to being double entry. If they still have QIF exports ... David C On Oct 16, 2017 8:51 AM, "Roger Miskowicz" wrote: > Is there a recommended procedure for migrating Moneydance to GnuCash? > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Importing Data
On Monday, 16 October 2017 21:42:19 BST Rick Strupkus wrote: > I have just purchased a new laptop with Windows 10 and am trying to import > the data from my old laptop onto it. Which files do I look for and how can > I put them on my new machine? > > Rick Hi Rick, look at section 3 of the FAQ for some pointers about data files. you can copy/move the datafile from the old to the new pretty much the same as you would move a word doc - USB stick might be a good choice! HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Vendor Bill - Invoice Entries
Michael: Thanks for the reply. I have to say, I was thinking this would be a natural function of business accounting software but I see your point about the bulk. This is a function I am currently looking into for a non-profit. Basically, we receive invoices for services which I’ve been inputing as bills into the AP register. The invoices of course could contain any number of services, many of which are common. What we’d like to be able to do is to create reports that might say, these are the top 5 services that were preformed in 2016 and how many of each there were. I’d prefer to only have to enter this data once, so I was hoping that GC would have the functionality but I am finding out that this might be outside the scope of any accounting type of software. Would you be able to suggest an approach, a tool, that might compliment GC? Or is this just going to have to be something totally different? Thanks. > On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack > wrote: > > On 10/15/2017 10:08 PM, DaveC49 wrote: >> Hi, >> >> The facilities you are requesting are likely to require an inventory >> management system. At present Gnucash is an accounting package and currently >> does not incorporate any features for inventory management. As far as i know >> there are no plans to incorporate such features in the near future. To do so >> would reuire a developer(s) interested in developing these features. >> Similarly while it can handle the accounting specific side of payroll >> management it does not handle the calculation of payrolls, deductions, taxes >> etc. You may need to took at ERP software if you require these facilities. >> >> David Cousens > > I am going to point something out. Gnucash is an accounting package. A > business might need a number of OTHER packages that would interact with the > accounting package, but normally are separate parts. Why separate? Because > which of these other parts a business might want/need depend on the business. > A unified business application (including ALL the different possible pieces) > would be unnecessarily bulky, with a given business never using many of those > pieces. > > inventory -- only if the business HAS inventory that it sells > payroll -- only if the business has employees (employees in the legal > sense of that word) > billed time -- only of a business deals in "billable hours" > POS --- only if a business does this kind of retail << point of sales not > only interacts with accounting but also inventory >> > etc. etc. etc. > > Since I do accounting just for non-profits, I am aware of OTHER "pieces" that > would apply to this specialty. Just because I may be using gnucash to provide > these pieces does NOT mean "part of gnucash" << I am simply ALSO using > gnucash to implement "virtual books" for those specific pieces >> > > Michael D Novack > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
MariaDB error 2003: Can't connect to MySQL server on x.x.x.x
Server and client are each on machines connected to different local networks. gnucash version 2.6.18 (3a9fbb8) and MariaDB 10.1.26 (xampp v.7.1.9-0-VC14) all machines running Windows 10 trying to open db using external address of server network. server is bound to 0.0.0.0 user has full privilege with ip address of x.x.x.x where x.x.x.x is local ip address of client machine and external address of client network and local address of gateway on server network gateway on server network is configured to forward port 3306 to ip of server on local network. I tried all combinations that made any sense to me and all return same error. I CAN open db running gnucash on same machine as server using 'localhost' and on a different machine on the same local network using local address of server. User has privilege with local ip of 2nd machine and local address of server. What do I try next? ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Vendor Bill - Invoice Entries
I second the comments by Michael. While I use GnuCash to keep up with my personal accounting, for my business I use commercial accounting software which provides all of the modules described and quite a few more. You can license as few or as many modules as desired -- at a cost, of course. So, if you're doing only basic accounting you can license only the general ledger module, which would be analogous to GnuCash. But if your needs are greater than there are the accounts receivable module, the accounts payable, module, payroll, inventory control, sales order entry, point of sale, etc. The only other open source software of which I am aware that would provide you these types of modules is a product called SQL-Ledger which you may wish to investigate: http://www.sql-ledger.org/cgi-bin/nav.pl?page=feature/index.html&title=Features At the very least looking at what SQL Ledger has to offer will show you the kinds of packages available. Otherwise, you're looking at purchasing commercial enterprise resource software. Hope this helps! CMR On 10/16/2017 05:04 PM, fellowtrave...@comcast.net wrote: Michael: Thanks for the reply. I have to say, I was thinking this would be a natural function of business accounting software but I see your point about the bulk. This is a function I am currently looking into for a non-profit. Basically, we receive invoices for services which I’ve been inputing as bills into the AP register. The invoices of course could contain any number of services, many of which are common. What we’d like to be able to do is to create reports that might say, these are the top 5 services that were preformed in 2016 and how many of each there were. I’d prefer to only have to enter this data once, so I was hoping that GC would have the functionality but I am finding out that this might be outside the scope of any accounting type of software. Would you be able to suggest an approach, a tool, that might compliment GC? Or is this just going to have to be something totally different? Thanks. On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack wrote: On 10/15/2017 10:08 PM, DaveC49 wrote: Hi, The facilities you are requesting are likely to require an inventory management system. At present Gnucash is an accounting package and currently does not incorporate any features for inventory management. As far as i know there are no plans to incorporate such features in the near future. To do so would reuire a developer(s) interested in developing these features. Similarly while it can handle the accounting specific side of payroll management it does not handle the calculation of payrolls, deductions, taxes etc. You may need to took at ERP software if you require these facilities. David Cousens I am going to point something out. Gnucash is an accounting package. A business might need a number of OTHER packages that would interact with the accounting package, but normally are separate parts. Why separate? Because which of these other parts a business might want/need depend on the business. A unified business application (including ALL the different possible pieces) would be unnecessarily bulky, with a given business never using many of those pieces. inventory -- only if the business HAS inventory that it sells payroll -- only if the business has employees (employees in the legal sense of that word) billed time -- only of a business deals in "billable hours" POS --- only if a business does this kind of retail << point of sales not only interacts with accounting but also inventory >> etc. etc. etc. Since I do accounting just for non-profits, I am aware of OTHER "pieces" that would apply to this specialty. Just because I may be using gnucash to provide these pieces does NOT mean "part of gnucash" << I am simply ALSO using gnucash to implement "virtual books" for those specific pieces >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- "... arms discourage and keep invader and plunderer in awe, and preserve order in the world as well as property. ... Horrid mischief would ensue were [the law-abiding] deprived of the use of them." -- Thomas Paine ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Vendor Bill - Invoice Entries
I think about the only way you could do it using Gnucash would be to add a series of sub-accounts that are specific to each service that you provide, and then post each bill for a service to the appropriate account. Then you could use the existing reporting available in Gnucash to show the breakdown of each service via the account structure. I'm in a similar situation as you - using Gnucash to maintain the books for a not-for-profit association. But in my case we have a wide variety of products we sell and they change seasonally, so there's simply not enough time in the day to keep up. We use a Point-of-Sale system to record all our sales to our members called Lettuceshare - (www.lettuceshare.org) - all sales are entered at our "checkout" and then I summarise the data and import invoices into Gnucash once a quarter. So can use this system for sales analysis rather than Gnucash. It could potentially work for you too Cheers - Nelson On Tue, Oct 17, 2017 at 8:04 AM, wrote: > Michael: > > Thanks for the reply. I have to say, I was thinking this would be a > natural function of business accounting software but I see your point about > the bulk. This is a function I am currently looking into for a non-profit. > Basically, we receive invoices for services which I’ve been inputing as > bills into the AP register. The invoices of course could contain any number > of services, many of which are common. What we’d like to be able to do is > to create reports that might say, these are the top 5 services that were > preformed in 2016 and how many of each there were. I’d prefer to only have > to enter this data once, so I was hoping that GC would have the > functionality but I am finding out that this might be outside the scope of > any accounting type of software. > > Would you be able to suggest an approach, a tool, that might compliment > GC? Or is this just going to have to be something totally different? > > Thanks. > > > > > On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack < > stepbystepf...@dialup4less.com> wrote: > > > > On 10/15/2017 10:08 PM, DaveC49 wrote: > >> Hi, > >> > >> The facilities you are requesting are likely to require an inventory > >> management system. At present Gnucash is an accounting package and > currently > >> does not incorporate any features for inventory management. As far as i > know > >> there are no plans to incorporate such features in the near future. To > do so > >> would reuire a developer(s) interested in developing these features. > >> Similarly while it can handle the accounting specific side of payroll > >> management it does not handle the calculation of payrolls, deductions, > taxes > >> etc. You may need to took at ERP software if you require these > facilities. > >> > >> David Cousens > > > > I am going to point something out. Gnucash is an accounting package. A > business might need a number of OTHER packages that would interact with the > accounting package, but normally are separate parts. Why separate? Because > which of these other parts a business might want/need depend on the > business. A unified business application (including ALL the different > possible pieces) would be unnecessarily bulky, with a given business never > using many of those pieces. > > > > inventory -- only if the business HAS inventory that it sells > > payroll -- only if the business has employees (employees in the > legal sense of that word) > > billed time -- only of a business deals in "billable hours" > > POS --- only if a business does this kind of retail << point of sales > not only interacts with accounting but also inventory >> > > etc. etc. etc. > > > > Since I do accounting just for non-profits, I am aware of OTHER "pieces" > that would apply to this specialty. Just because I may be using gnucash to > provide these pieces does NOT mean "part of gnucash" << I am simply ALSO > using gnucash to implement "virtual books" for those specific pieces >> > > > > Michael D Novack > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Vendor Bill - Invoice Entries
Thanks CM, I’ll take a look. Given that this is a very small non-profit, I am hoping to avoid a commercial package and so far GC has (mostly) met the needs but now we’re looking at trying to have more data available that is not strictly just dollars and cents so to speak. In any case, are you (or anyone else here) aware of some common commercial packages? > On Oct 16, 2017, at 6:31 PM, C M Reinehr wrote: > > I second the comments by Michael. While I use GnuCash to keep up with my > personal accounting, for my business I use commercial accounting software > which provides all of the modules described and quite a few more. You can > license as few or as many modules as desired -- at a cost, of course. So, if > you're doing only basic accounting you can license only the general ledger > module, which would be analogous to GnuCash. But if your needs are greater > than there are the accounts receivable module, the accounts payable, module, > payroll, inventory control, sales order entry, point of sale, etc. > > The only other open source software of which I am aware that would provide > you these types of modules is a product called SQL-Ledger which you may wish > to investigate: > > http://www.sql-ledger.org/cgi-bin/nav.pl?page=feature/index.html&title=Features > > At the very least looking at what SQL Ledger has to offer will show you the > kinds of packages available. > > Otherwise, you're looking at purchasing commercial enterprise resource > software. > > Hope this helps! > > CMR > > On 10/16/2017 05:04 PM, fellowtrave...@comcast.net wrote: >> Michael: >> Thanks for the reply. I have to say, I was thinking this would be a natural >> function of business accounting software but I see your point about the >> bulk. This is a function I am currently looking into for a non-profit. >> Basically, we receive invoices for services which I’ve been inputing as >> bills into the AP register. The invoices of course could contain any number >> of services, many of which are common. What we’d like to be able to do is to >> create reports that might say, these are the top 5 services that were >> preformed in 2016 and how many of each there were. I’d prefer to only have >> to enter this data once, so I was hoping that GC would have the >> functionality but I am finding out that this might be outside the scope of >> any accounting type of software. >> Would you be able to suggest an approach, a tool, that might compliment GC? >> Or is this just going to have to be something totally different? >> Thanks. >>> On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack >>> wrote: >>> >>> On 10/15/2017 10:08 PM, DaveC49 wrote: Hi, The facilities you are requesting are likely to require an inventory management system. At present Gnucash is an accounting package and currently does not incorporate any features for inventory management. As far as i know there are no plans to incorporate such features in the near future. To do so would reuire a developer(s) interested in developing these features. Similarly while it can handle the accounting specific side of payroll management it does not handle the calculation of payrolls, deductions, taxes etc. You may need to took at ERP software if you require these facilities. David Cousens >>> >>> I am going to point something out. Gnucash is an accounting package. A >>> business might need a number of OTHER packages that would interact with the >>> accounting package, but normally are separate parts. Why separate? Because >>> which of these other parts a business might want/need depend on the >>> business. A unified business application (including ALL the different >>> possible pieces) would be unnecessarily bulky, with a given business never >>> using many of those pieces. >>> >>> inventory -- only if the business HAS inventory that it sells >>> payroll -- only if the business has employees (employees in the legal >>> sense of that word) >>> billed time -- only of a business deals in "billable hours" >>> POS --- only if a business does this kind of retail << point of sales not >>> only interacts with accounting but also inventory >> >>> etc. etc. etc. >>> >>> Since I do accounting just for non-profits, I am aware of OTHER "pieces" >>> that would apply to this specialty. Just because I may be using gnucash to >>> provide these pieces does NOT mean "part of gnucash" << I am simply ALSO >>> using gnucash to implement "virtual books" for those specific pieces >> >>> >>> Michael D Novack >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> 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 >> gn
Re: Vendor Bill - Invoice Entries
Hi Michael, Point taken. I was really commenting specifically on the in package capability of Gnucash to meet fellow_travellers's needs. It might be useful to have a list of external software that does provide additional capability to extend Gnucash somewhere on the wiki page. One of the disadvantages of an external software approach is in the lack of ability to readily exchange data between the various components. I am thinking specifically of customer/vendor information, product listsetc.. While this can be done with data import/export, there is always the problem of ensuring the data import/export is upto date in both packages. I do remember seeing someone mentioning a POS plugin under development sometime ago but haven't seen any more on it. As you have pointed out a POS system is largely useless without an integrated inventory system. The current plugins wiki page doesn't list anything like this though. The plugin capability of Gnucash would be one way of supporting integrated inventory, payroll, POS systems in an integrated fashion but each of these is likely to require a team of developers to support and maintain compatability as Gnucash and each of the packages develops. I think this is one reason such plugins haven't been developed yet. I have tried developing a fairly simple mod for Gnucash and I found finding my way around the code base required a considerable effort and investment in time to work out where to insert the relatively simple code needed. Still working on that, but it does make me really appreciate the efforts the current developers put in. If Gnucash does shift towards SQL database backends in the future, separate packages could have the required data integration through the use of a common shared database minimising the need to interact at the code level. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
On Mon, 16 Oct 2017 06:52:17 -0700 (MST) Nelson wrote: > You're getting very defensive here David and your posts are not > contributing to this discussion at all. > > Gnucash is Gnucash. It isn't a Quicken-to-Gnucash project. Yes, we do get many queries about this, but the process once completed is soon forgotten, and while there is much knowledge about this in the mailing lists, Quicken-to-Gnucash is not the main focus of this project. Nelson, you are free to try and do what you like, except start personal attacks on other contributors. Liz, the moderator. (Profanity is also something I heavily discourage) ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: MariaDB error 2003: Can't connect to MySQL server on x.x.x.x
On 16 October 2017 at 23:03, Joe Harrington wrote: > Server and client are each on machines connected to different local > networks. > gnucash version 2.6.18 (3a9fbb8) and MariaDB 10.1.26 (xampp v.7.1.9-0-VC14) > all machines running Windows 10 > > trying to open db using external address of server network. > > server is bound to 0.0.0.0 > > user has full privilege with ip address of x.x.x.x > > where x.x.x.x is local ip address of client machine and > external address of client network and > local address of gateway on server network > > gateway on server network is configured to forward port 3306 to ip of server > on local network. > > I tried all combinations that made any sense to me and all return same > error. > Can you access the db from diffferent client software? A command line access utility for example? If you can't do that it is not a gnucash issue. Colin > I CAN open db running gnucash on same machine as server using 'localhost' > and on a different machine on the same local network using local address of > server. User has privilege with local ip of 2nd machine and local address of > server. > > What do I try next? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
