Re: [GNC] Should GNUCash allow a split to reference the same account twice
Yes, I use this feature a lot when purchasing bonds in bond market. In my case, first I deposit money say 2500 with broker, then I buy bonds say worth 2100 (21 bonds worth 100 each) and by end of the day I get 400 back in my bank. This I note down (simplify) as a single transaction with 3 splits: Foo bank - Debit 2500 Bond (as stock) - Credit 21 units worth 100 each Foo bank - Credit 400 Please do not disable this feature. Thanks and regards. Amish On 20/07/23 23:16, Henry Law wrote: Should GNUCash refuse to allow a transaction to have two splits into the same account? My knowledge of accounting is scant, but with it I can't see why one would ever legitimately do that. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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: [GNC] GST: how to
On 23/11/20 11:15 am, Lokesh Yagnik wrote: Question is regarding tracking GST. How do you record GST charged to you ? so as to be able to claim it in the future. Do you put it via two separate transactions? Thanks in advance Lokesh Check this: (based on your name - I am assuming you mean for India) http://gnucash.1415818.n4.nabble.com/Instructions-for-GST-India-td4693136.html Its bit old but works. You may also use ready account template that comes by default with Gnucash. Infact new Income and GST statement report makes things much easier then it was in 2017. Regards, Amish ___ 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] Notes (few other) fields should be editable even after posting invoice
Hi, Thank you very much for merging the PR. On a side note, any idea why the following is being done? Source: gnucash/gnome/dialog-invoice.c 1921: gtk_widget_set_sensitive (iw->id_entry, FALSE); /* XXX: why set FALSE and then TRUE? */ 1922: gtk_widget_set_sensitive (iw->id_entry, TRUE); It is first set to FALSE and then set to TRUE? (I had put XXX note in my PR) Also may be you can change a note on line like this: - 1919: /* Setup viewer for read-only access*/ + 1919: /* Setup viewer for read-only access. Allow editing of notes and some other items*/ Thanks and regards, Amish. On 18/10/19 2:28 am, Geert Janssens wrote: Hi, I agree unconditionally on the notes field. And I can see how being able to pull up job or customer/vendor details directly from the invoice window could be a big time saver. So I have merged your PR to revert the read-only status of these three fields as I find the old behavior's use case is stronger than the current behavior's one. Having said that, I believe we can do much better still in the user interface area. I had made a few suggestions in bug 797168, but currently have other priorities. So for now this will have to do. Best regards, Geert Op maandag 14 oktober 2019 15:08:55 CEST schreef Amish: Hello, There was this fix implemented in Gnucash which inadvertently created issue for me. This was the bug report which was marked RESOLVED FIXED. https://bugs.gnucash.org/show_bug.cgi?id=797168 But this fix created issue with respect to my GST filing and tracking. So I counter opened a bug report last month to fix this, by partially reverting it. https://bugs.gnucash.org/show_bug.cgi?id=797400 I also created pull request on Github for the same: https://github.com/Gnucash/gnucash/pull/580 Its been one month but since bug report or PR are not reviewed and my GST tracking is affected completely. Hence I am posting the same here in mailing list. Here is copy-paste of the description from the bug report that I had filed. Before Gnucash 3.6, I used to track customer/vendor conversations/issues OR GST related and other important points via Notes field of invoice / bill. Now since Gnucash 3.6 these fields are no more editable, unless I unpost the bill. This does not make sense. Why cant I add notes after bill was posted? It does not cause any harm in invoice values. So locking the field is unnecessary. It was so helpful for GST (India) tracking too. Once I report the invoice to Government portal, I would simply add #GSTFILED in Notes. Similarly when my vendors upload their invoices (where I am buyer), I would mark those bills as #GSTMATCHED too. Anytime in future if I wanted to check if there is any invoice / bill that is not reported by me (or by my vendor) - I would simply "Find bill / invoice" where notes did not contain #GSTFILED or #GSTMATCHED This made tracking of my GST returns and GST government filing very easy. But now that Notes field is un-editable... every time I have to unpost the invoice / bill and add note and then post the invoice / bill again. (messing up customer payment too). This is not really needed. Similarly under "Billing information" - Edit button under Customer / Vendor was clickable. This "Edit" also does not affect actual Invoice OR bill values. But it helped me find GST number, Phone numbers, Email address (and other details) of Customer / Vendor easily and instantly. Otherwise just to find customer detail - I have to go all the way to Customers Overview - Search customer, right click and then Edit. (unnecessary three or more clicks and scrolling of screen) Since Notes field and Edit customer under posted Invoice / bill - does not change anything related to Invoice or bill values.. they should be made Editable. So that adding notes (after posting) becomes easy and obtaining customer information is also fast. Please re-consider the change and make them editable again. Otherwise it handicaps few nice features. Please review PR, the link is given above. Thank you, Amish. ___ 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.
[GNC] Notes (few other) fields should be editable even after posting invoice
Hello, There was this fix implemented in Gnucash which inadvertently created issue for me. This was the bug report which was marked RESOLVED FIXED. https://bugs.gnucash.org/show_bug.cgi?id=797168 But this fix created issue with respect to my GST filing and tracking. So I counter opened a bug report last month to fix this, by partially reverting it. https://bugs.gnucash.org/show_bug.cgi?id=797400 I also created pull request on Github for the same: https://github.com/Gnucash/gnucash/pull/580 Its been one month but since bug report or PR are not reviewed and my GST tracking is affected completely. Hence I am posting the same here in mailing list. Here is copy-paste of the description from the bug report that I had filed. Before Gnucash 3.6, I used to track customer/vendor conversations/issues OR GST related and other important points via Notes field of invoice / bill. Now since Gnucash 3.6 these fields are no more editable, unless I unpost the bill. This does not make sense. Why cant I add notes after bill was posted? It does not cause any harm in invoice values. So locking the field is unnecessary. It was so helpful for GST (India) tracking too. Once I report the invoice to Government portal, I would simply add #GSTFILED in Notes. Similarly when my vendors upload their invoices (where I am buyer), I would mark those bills as #GSTMATCHED too. Anytime in future if I wanted to check if there is any invoice / bill that is not reported by me (or by my vendor) - I would simply "Find bill / invoice" where notes did not contain #GSTFILED or #GSTMATCHED This made tracking of my GST returns and GST government filing very easy. But now that Notes field is un-editable... every time I have to unpost the invoice / bill and add note and then post the invoice / bill again. (messing up customer payment too). This is not really needed. Similarly under "Billing information" - Edit button under Customer / Vendor was clickable. This "Edit" also does not affect actual Invoice OR bill values. But it helped me find GST number, Phone numbers, Email address (and other details) of Customer / Vendor easily and instantly. Otherwise just to find customer detail - I have to go all the way to Customers Overview - Search customer, right click and then Edit. (unnecessary three or more clicks and scrolling of screen) Since Notes field and Edit customer under posted Invoice / bill - does not change anything related to Invoice or bill values.. they should be made Editable. So that adding notes (after posting) becomes easy and obtaining customer information is also fast. Please re-consider the change and make them editable again. Otherwise it handicaps few nice features. Please review PR, the link is given above. Thank you, Amish. ___ 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] Imbalance bug in credit note generation?
On Tuesday 31 July 2018 08:34 PM, Geert Janssens wrote: Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish: Can someone using Gnucash for Business account please check credit note creation? I have seen your bug report but haven't had time to verify. As this is my area I will do so soon and if I can reproduce I will for sure put it on my priority list for 3,3. Regards, Geert Just for the record, the fix has been pushed to git maint branch. https://github.com/Gnucash/gnucash/commit/d87fa3a5bed0b948f28651bf8b0897373cc7110e Thank you Geert for quick fix. Amish. ___ 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] Imbalance bug in credit note generation?
On Tuesday 31 July 2018 08:34 PM, Geert Janssens wrote: Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish: Can someone using Gnucash for Business account please check credit note creation? I am wondering how come noone came across this bug. It is a serious bug unless I am doing something wrong. This bug is now affecting maintaining business account for me. Without "correctly assigned / balanced" credit notes all figures come out wrong. Bug report: https://bugs.gnucash.org/show_bug.cgi?id=796766 I am wondering if developers know this or not. As it has not been assigned to anyone or acknowledged. The impatience... ;) Thank you for your reply. But I did wait about 2 weeks after bug report. It's holiday season so expect replies to have a longer delay. I have only returned from vacation today and have a huge backlog to process. I have seen your bug report but haven't had time to verify. As this is my area I will do so soon and if I can reproduce I will for sure put it on my priority list for 3,3. Mailing list was reasonably active so I was just wondering and also worried about my issue. My business depends on Gnucash credit notes working properly so you can understand that for me it would become a priority. Ofcourse I completely understand that its an open source software by volunteers around the world. I tried my best to report the bug in best possible way. Do let me know if you need more information. Regards, Geert Thanks and regards, Amish ___ 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] Imbalance bug in credit note generation?
Can someone using Gnucash for Business account please check credit note creation? I am wondering how come noone came across this bug. It is a serious bug unless I am doing something wrong. This bug is now affecting maintaining business account for me. Without "correctly assigned / balanced" credit notes all figures come out wrong. Bug report: https://bugs.gnucash.org/show_bug.cgi?id=796766 I am wondering if developers know this or not. As it has not been assigned to anyone or acknowledged. So please check. Thank you. Amish On Friday 20 July 2018 08:02 AM, DaveC49 wrote: 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 transactions, A/R has a balance of $150 intead of $50. The recorded transactions in the Accounts Receivable Register are as follows: Invoice Posted Dr Cr Assets:Accounts Receivable $100 Income:Sales $100 Credit Note Posted Dr Cr Income:Sales $50 Assets:Accounts Receivable $50 Imbalance $100 whereas the last transaction should have been Dr Cr Icome:Sales $50 Assets:Accounts Receivable $50 giving rise to a final balance in the Accounts receivable of $150 and the unnecessary entry for $100 in the Imbalance account. 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. ___ 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] Imbalance bug in credit note generation?
Thank you for acknowledging. I was wondering if my messages reach the list as my past 3-4 emails (on different subjects) have gone unanswered. Although messages do appear in mailing list archives. Please add your report also to the following bug report so that it can be tracked and also adds the weight to bug. https://bugs.gnucash.org/show_bug.cgi?id=796766 Thank you. Amish On Friday 20 July 2018 08:02 AM, DaveC49 wrote: 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 transactions, A/R has a balance of $150 intead of $50. The recorded transactions in the Accounts Receivable Register are as follows: Invoice Posted Dr Cr Assets:Accounts Receivable $100 Income:Sales $100 Credit Note Posted Dr Cr Income:Sales $50 Assets:Accounts Receivable $50 Imbalance $100 whereas the last transaction should have been Dr Cr Icome:Sales $50 Assets:Accounts Receivable $50 giving rise to a final balance in the Accounts receivable of $150 and the unnecessary entry for $100 in the Imbalance account. 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. ___ 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] Imbalance bug in credit note generation?
Hello I am trying to create a credit note for a customer, in exact same way as Invoice except that type chosen is "Credit note". But after posting the "credit note", Gnucash is "increasing" receivables instead of decreasing. It also increases "tax liability" - it should actually decrease it. But it correctly "reduces" the Income. Effectively this creates an "imbalance" entry too - because internally the total does not balance. Please find more details and screen shots in the following bug report (filed 2 days back) https://bugs.gnucash.org/show_bug.cgi?id=796766 I am posting here for two reasons: 1) To know if I am using "Credit note" incorrectly (which I doubt) 2) To highlight the bug (if it is indeed a bug) because it is a serious "accounting" bug and probably needs addressing on priority. So please check. Thank you Amish. ___ 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] sub-windows always staying above main window
Hello This is a bit of inconvenience introduced in version 3.0 Earlier when I open sub-windows like "Find transaction", "Due invoices reminder", "Due bills reminder", "Find invoice" etc., a small window would open. Earlier after opening those windows I could press "Alt-Tab" and switch back to Main Gnucash window. Now I can still Alt-tab but that small window will remain on top of the Main window covering major part of Main window. Every time I am forced to minimize small window to see Full contents of Main window. Can we make it like older version? Where small windows simply go behind Main window on Alt-tab. Thank you PS: Using Linux - Arch Linux. Gnucash v 3.0. Amish. ___ 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] future of custom reports in 3.x
May be fastest and easiest way would be to first save sample data (say only 1 transaction) to say PostgreSQL database and then use pg_dump to dump it to text file. Amish. On Tuesday 10 April 2018 08:57 PM, Matthew Pounsett wrote: On 8 April 2018 at 13:13, John Ralls <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> wrote: In the meantime there are four alternatives for custom reports: 2. Learn SQL and use a SQL backend to extract the data you want. The results are generally amenable to import into a spreadsheet for further processing; you could also install the appropriate ODBC module for your SQL engine of choice and connect to it with Libre/OpenOffice, Microsoft Access, or some similar tool with a custom report writer or your favorite programming language’s SQL interface (e.g. DBAPI for Python). Is there some clear documentation of the SQL schema somewhere? I had a look through the gnc-*-sql.cpp files, but it's not the most transparent description of a database that I've ever read. :) I was considering putting together a set of Python/SQLAlchemy classes that implement the object-data mapping, and would be happy to contribute it back to the project, if people thought that'd be useful. ___ 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] Additional filter option (by number) for Transaction report
Yes I know about POSIX negative matcher but one cant memorize its easily. So I thought one additional checkbox (invert result) can be easy solution? PS: I will check the scheme report when I get time. If it is easy, I will definitely try to add that feature and send PR. Amish On Tuesday 10 April 2018 06:31 PM, Christopher Lam wrote: To Amish: You can set Filter/Transaction Filter regex option to true, and use POSIX regular expressions to your content (which may not have an intuitive negative-string matcher). HTH C On 10/04/18 20:16, Amish wrote: Not sending a new email for a similar feature. Is there a way to have a Negative filter. Like Memo *not* containing word "Credit Note" Amish. On Tuesday 10 April 2018 04:02 PM, C Whistler wrote: Dear community, I have started using Gnucash recently and would like to use the existing transaction report to filter out specific transactions. Though currently I cannot find the option to filter transaction by number. I am guessing the easiest way would be to modify the exiting Transaction.scm. If someone could kindly give me a hand for the code to add/modify please it will be much appreciated. (I have some experience in scripting and am starting to pick up scheme now.) Best regards, Whistler ___ 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] Automatic Invoice numbering
See this: https://www.gnucash.org/docs/v2.6/C/gnucash-help/book-options.html#counters-book-options This also allows you to have Prefix AND/OR suffix to Automatically generated invoice numbers. Regards, Amish On Tuesday 10 April 2018 05:54 PM, subscriptions wrote: Does GNUC support automatically selecting a invoice number when creating a new invoice for clients? ... Thanks, jdegraw ___ 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] Additional filter option (by number) for Transaction report
Not sending a new email for a similar feature. Is there a way to have a Negative filter. Like Memo *not* containing word "Credit Note" Amish. On Tuesday 10 April 2018 04:02 PM, C Whistler wrote: Dear community, I have started using Gnucash recently and would like to use the existing transaction report to filter out specific transactions. Though currently I cannot find the option to filter transaction by number. I am guessing the easiest way would be to modify the exiting Transaction.scm. If someone could kindly give me a hand for the code to add/modify please it will be much appreciated. (I have some experience in scripting and am starting to pick up scheme now.) Best regards, Whistler -- 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. ___ 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] Addition of Mailing List Subject Prefix
Is it possible to put [GNC] tag at the end of the subject. Those who filter on subject will still be able to use it and those who are disturbed by additional unnecessary tagging would be happy too. Amish. On Tuesday 10 April 2018 05:09 PM, Alain Williams wrote: The point is that different people choose different ones - for whatever reason. So: let's make it easy for people who are not using your chosen MUA to also distinguish GC/GNC email from the others in their mailbox. The price for those who do not need it on the Subject: line is a few characters - get over it! ___ 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] 3.0 UI broken under W8.1
This is how I do it... double click headers of all the columns which you want to be maximized (except Description column) And then in the end - double click "description" column. That should fit everything on screen to best possible width. Regards Amish. On Monday 09 April 2018 12:37 PM, Ed wrote: Gday all, I've just installed 3.0, and it looks great! Unf, when I resize one of the columns (description), I can only make it bigger, and not smaller. All the other fields are now too small, and it's unusable. Any suggestions? Thanks from down under. Ed ___ 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] future of custom reports in 3.x
I wonder the same too. Although new reports are enough for me now. But I had to delete lots of old custom reports because they no more worked (or compiled) But in future I may want to have my own custom reports. I wish there was GnuCash library with we could simply call Gnc_LoadFile("path") and then we could also do all the magical things that GnuCash does! Amish On Sunday 08 April 2018 02:38 PM, Saša Janiška wrote: Hello, while having problems to load certain (ytd-budget.scm) report in 2.6.20 under (Fedora) Linux i nthe attempt to return back to GnuCash from (h)ledger, I wonder if there is some plan in regard to the future of custom reports, iow. is it still recommended to learn some Scheme in order to achieve/tweak what is missing, do you envision using Python or something else suitable to enable end-users write custom reports (more) easily? Sincerely, Gour ___ 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: where to share GnuCash python scripts?
For open source codes - GitHub would be a good place. https://github.com/ On Friday 23 March 2018 11:15 PM, darrylctx wrote: Where would be the best place to upload the .py files if I wanted to share them? Right now, they are pretty raw, but I could clean them up and make them a little easier to use. At the least, they are an example of how easy it is to get data into GC with a few simple python scripts. ___ 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.
saved searches (for invoice / bill / transaction searches)?
Hello Is there an easy way to save some regularly used searches? I have certain types of searches which I perform every week. It can be combination of many things - Customer name, date (within certain range), notes etc. If we can have "saved search" features - similar to "saved reports" feature, it would be great help. Thanks in advance Amish ___ 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: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use
Hello Try Arch Linux if you are willing to put initial efforts in learning and a bit of tweaking here and there. It has r8168 drivers too. (as a separate package which you can install easily) Plus rolling release model which means you will always have up-to-date system. Once you get hold of it, its very easy to maintain. Arch used to support Gnucash but due to webkit related security issues it stopped releasing Gnucash officially. However there is archlinuxcn repository which is well maintained so its very easy to install Gnucash from there. Arch also has DVD / USB live media with which you can test if your internet is working with it. Regards, Amish On Thursday 15 March 2018 11:47 AM, jeffrey black wrote: I realize this is the wrong forum to ask but; I am finally looking to ditch Windoze 10 completely. ... Does anyone have a suggestion on what flavor of Unix I should use on this computer? Wifi, networking and GnuCash are mandatory requirements for me to switch. --JEffrey Black M.B.A. ___ 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: Instructions for GST India
On Wednesday 07 February 2018 05:52 PM, Deva - wrote: Frank, Read the wiki and spent better part of my day trying to generate a template, but I am sorry to say I give up. The wiki assumes one is familiar with xml and how gnucash uses xml - neither of which I am comfortable with. I have created XML file and created pull request too. https://github.com/Gnucash/gnucash/pull/275 Having spent all day thinking about this, I am now wondering whether it would have been a futile effort even if I had succeeded in making a template. Reason being - my use case for GST is only a subset of what Amish laid out. Even if we attempt to put Amish's comprehensive setup as a template, it cannot be used by all GST users in India. What we have posted is only one aspect of GST in India, mainly covering GSTR-3B and GSTR-1/2 components of the return. Then there are other aspects such as - - composition dealers - e-way bills (launched recently) - export related services and such… Yes but there are many more normal GST dealers than GST composition dealers. For composition dealers I guess there will be even less accounts. So they can use template and remove unwanted accounts. E-way bill - not sure if that would be part of Gnucash anyway. User can put a note in Invoice stating e-way bill number Export services - I have no idea about their returns but that should not stop us from creating normal templates which can become a starting point. Thanks and regards, Amish. ___ 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: Instructions for GST India
On Tuesday 06 February 2018 05:37 PM, Deva - wrote: I can concur with Amish’s setup for GST India, but with a few minor observations. I have a similar setup, though not as elaborate as Amish’s. This is largely due to the fact that I don’t claim GST input tax credit for purchases (my tax credits are negligible compared to what I pay as GST). Also, I have to deal with only 1 tax rate of 18%, but that does involve setting up of 3 tax tables like Amish pointed out - CGST @ 9%, SGST @ 9% and IGST @ 18%. Thanks and yes - you are lucky to have just one tax rate!! :) My few observations - a. Not sure if you need 2 A/R accounts. Since these accounts are not directly used in reports, just having one should do (sub-accounts for GST and NonGST can be merged into the parent). These are required for verifying total in GSTR 1 return. Also GSTR 1 asks for total AR (sale) plus AR of (sale to) Interstate Non-GST dealers. Hence atleast in my case they are required. b. You may find it more helpful by actually putting the tax rate in the tax account name itself. For instance, "Liabilities:Sales:GST:IGST @ 18%” as the account name, instead of "Liabilities:Sales:GST:IGST”. While this will not make a difference if you are using Tax Invoice report, it will show up nicely in case of a Printable Report or Fancy Invoice report because the tax line will read IGST @ 18% (instead of just IGST). I generate printable invoice in Libreoffice Calc (Linux's Excel). But yes your idea is nice. c. I haven’t segregated the NonGST vs. GST (registered vs. unregistered dealers), though I can see the benefit given GST reporting requirements. However, I think with the new transaction report that was posted on this list sometime back (by Doug, I think), one can easily generate summaries based on descriptions in the transaction registers. So if you are diligent about tagging your transactions with proper notes/memos, etc. then you can always generate summaries based on those with the new transaction report to meet the GST reporting requirements. Adding notes / memos require additional care. One spelling mistake and your transaction will not show up in report. I think if you are dealing with large volumes of GST related transactions, Amish’s setup is the way to go, though it may seem a bit tedious to set it up in the beginning. My GST invoices are to the tune of about 100 invoices a year, so I have cut down on my account hierarchy to keep it simple. Yes my setup can be scaled down but depends on the individual's choice and requirement. And yes, it can certainly go on the wiki for those looking for help. I wish I had something like that to guide me when I was doing the same, but with trial and error, I got to what I wanted. I am sure all of us continue to remain indebted to GnuCash to help keep our financial matters in order despite the chaotic rollout of GST that India witnessed not so long ago. Indeed chaotic! And yes Gnucash saved me from purchasing expensive software. Cheers, Deva Amish ___ 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: Instructions for GST India
tedious but its just one time thing. Once done then everything becomes very easy. Now the actual usage of these accounts and tables: Whenever you create Invoice / Bill - based on customer / vendor select the right Income / expense account (from stage 1) and right Tax table (from stage 2). And when you post invoice / bill - select the right Asset / Liability account (again from stage 1) i.e. GST or NonGST accounts based on type of customer / vendor and GST / IGST / NonGST tax table based on customer/vendor and the tax percentage. Stage 4: (Report Generation) --- For report generation - you can use transaction report and customize it as per your requirement. Save the customized report so that you do not need to customize it every time. I have created 4 types of customized transaction report 1) GST-Sale-Tax Report start date - start of previous month (or quarter) end date - end of previous month (or quarter) Primary key - Account name Secondary key - Date Seconday subtotal - None Accounts selected - Liabilities:Sales (and all subaccounts) Account filtered by - Income:Sales (and all subaccounts) Filter type - Include transaction to/from filter accounts This will give you previous months tax details (for sales) useful for GSTR3B return Similarly you can create reports for GST-Sale-Total, GST-Purchase-Tax, GST-Purchase-Total. You need to tinker a bit here and there (mostly by selecting the right accounts) And then save all reports and you are all set for GST India! (GSTR1/2/3B) Stage 5: (Set off) --- Once you file GSTR3B return - do same set off (as you did in GSRT3B) from Tax Assets / Liabilities accounts created in stage 1. Overall just be careful while data entry at stage 3 and stage 5 and everything should be perfect and ready. So thats all, hope it was useful. Regards, Amish. ___ 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: Close Book regression
Yes i had noticed the same too. What i did is moved 1 or 2 transactions which fall on closing date to one day earlier. Amish On 28-Oct-2017 4:19 PM, "Yves-Eric Martin" < yem_lists.gnucash@filter.yve.net> wrote: Hi all, Version: GnuCash 2.6.18 (built from rev 3a9fbb8+ on 2017-09-22) I think I found a regression in the Close Book tool: until last year (not sure which version unfortunately), the transactions on the closure date were included in the calculations, resetting all income and expense balances to zero. But now, it seems these closure date transactions are not included anymore, leaving accounts with non-zero balances. Steps to reproduce (on a new file with the default common accounts, no transactions): 1) create a transaction in Expenses:Supplies on 2017-09-29 for the purchase of goods for 1,000 (credit to Cash in Wallet) 2) create a transaction in Expenses:Supplies on 2017-09-30 for the purchase of goods for 200 (credit to Cash in Wallet) 3) use the Close Book tool with: - Closing date: 2017-09-30 - Income total: Equity:Opening Balances - Expenses total: Equity:Opening Balances - Description: Closing Entries Current behavior: The Expenses:Supplies account shows a balance of 200 Expected behavior: The Expenses:Supplies account shows a balance of 0 Workaround: a temporary workaround is to run the Close Book tool using "date + 1", then manually edit the two closing transactions and move them back 1 day. Thank you, Yves-Eric ___ 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: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 08:06 PM, Ronal B Morse wrote: This is really starting to sound like a job for some sort of inventory control software, not an accounting package. Regards. Nope I am not asking for item tracking. (sold, purchase, in stock). Its just stupid Government compliance issue and for actual business I have no use of "total quantity" feature. Amish. ___ 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: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 03:27 PM, Maf. King wrote: On Thursday, 19 October 2017 10:35:53 BST Amish wrote: On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert I think you are mixing my query with a similar query posted earlier today. I am not talking about reports. But I am talking about "Invoice tab" that is opened when feeding data about Invoice. As we keep adding "Invoice items", the status bar shows "Total, Subtotal and tax total" I think it would be nice if "Quantity" total is also shown in status bar. This would require source code changes and not guile/scheme. Thanks and regards, Amish Hi Amish, Whilst I don't ignore the stupid rules that tax authorities around the world dream up, I don't understand how summing the quantities of line items on an invoice is in any way useful. E.g. your customer buys 1 bulk box containing 10 widgets (line 1 - and costing less than 10 individual widgets) and 3 sprockets (line 2). you list those on the invoice as quantities 1 and 3. What use is the number 4? your customer has 13 discrete items... I completely can see that the line item quantity numbers should be shown on the invoice, and a government could mandate that. If they really do want a "total quantity" shown at the bottom of the invoice, then that would be the GC invoice template that needs a mod, not the register window? 0.02 Maf. I agree if units are different then quantity makes no sense. But in my case its always "PCS" (pieces) so it should help a bit. Also we dont have to print quantity on Invoice but every month we have to file tax return which mentions HSN code of item and number of pieces sold. I know its crazy but then who can say anything to Government? I will try to see if I can learn report templates. Thanks all for replies. Amish. ___ 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: Quantity total below create / view / edit invoice
On Thursday 19 October 2017 01:00 PM, Geert Janssens wrote: Op donderdag 19 oktober 2017 02:56:27 CEST schreef Amish: Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? The only way I see is to create your own custom invoice report, which will unfortunately require you to write some code in the guile/scheme language. Regards, Geert I think you are mixing my query with a similar query posted earlier today. I am not talking about reports. But I am talking about "Invoice tab" that is opened when feeding data about Invoice. As we keep adding "Invoice items", the status bar shows "Total, Subtotal and tax total" I think it would be nice if "Quantity" total is also shown in status bar. This would require source code changes and not guile/scheme. Thanks and regards, Amish ___ 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.
Quantity total below create / view / edit invoice
Hello Recently in India GST was implemented. The government requires to report sale / purchase quantity too in invoice. When I create / view / edit invoice, I can see Invoice total and tax total in status bar. Is it possible to add Quantity total too? Or is there any other way? Thanks in advance. Amish ___ 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: Customized saved-reports file per gnucash file (i.e. per company)
On Wednesday 11 October 2017 09:05 PM, Maf. King wrote: Amish - the only thing I think I can suggest at this point is that each company has it's own user login - at least that way the list of accounts is not cumbersome.. Or thinking about it, if on linux (may work on Win, probably not on Mac), you could create some shortcuts for each accounts file that sets up a custom environment (i think you need to set GNC_DOT_DIR bit have a good google first) before launching GC so that each company has its own prefs file. probably more cumbersome than a really busy menu, and error-prone, though,,, Maf. Easiest workaround would be that I have two saved-reports stored in .gnucash directory. say saved-reports-companyA and saved-reports-companyB Before starting gnucash for a company I copy saved-reports-companyX to saved-reports-2.4 This can be done with 2 line script (say gccompany): #no error checking done cp ~/.gnucash/saved-reports-$1 ~/.gnucash/saved-report-2.4 exec gnucash /path/to/$1.gnucash Then instead of calling "gnucash companyA.gnucash" I call "gccompany companyA" That way I dont have to maintain 2 Linux accounts and 2 different settings directory. Amish. ___ 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: Customized saved-reports file per gnucash file (i.e. per company)
On Tuesday 10 October 2017 09:20 PM, Maf. King wrote: On Tuesday, 10 October 2017 16:20:28 BST Amish wrote: So I would like to know if there is way to have customized saved-reports file per gnucash file? Name and location of which can be stored in that gnucash file itself. So that I do not have to keep re-selecting accounts everytime and reports related to company A does not show when gnucash of company B is opened and vice versa. Hi Amish. Not that I know of. I've dealt with this by calling the reports CompanyA-Foo and CompanyB-Foo Although, I must say that I think the report saved accounts by name, not ID, so one report could be used as the basis for the second company, with only a little tweaking. Maf. I know thats how I have done it right now. But I am from India where recently GST taxatio was introduced. I have managed to configure Gnucash for the same. For GST return filing Government needs many types of reporting every month. Report for 3 types of taxes (IGST/CGST/SGST) Report for trade payable (purchase+tax) Report for trade receivable (sale+tax) Report for taxable sales Report for taxable purchase Then there are reports for sale/purchase to/from GST dealers And then same reports for dealers not registered under GST As you can see there are almost 11-12 types of reports that we have provide to Government at end of every month Now if I create customized reports I will have: CompanyA-Sale, CompanyA-Purchase, ... 11-12 reports same way 11-12 reports for company B I have 2 more companies which I have still not migrated to GST So you can see the report list will be too long when I open "Saved report configuration" That is why I was asking if it is possible to have: 1) saved-reports per company 2) OR saved-reports storing FULL account name - for example Assets:Purchase:IGST insted of account ID. I believe 2nd option would be much better as then we dont need to create separate reports for each company. Infact both 1 and 2 can be implemened, if possible that would allow to store reports in a better way and also make them REUSABLE. Thanks and regards, Amish ___ 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.