[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] Error message
Hi, Please keep the list in the loop by copying Gnucash users. I would look in the Scheduled Transaction Editor. There is some transaction there, I believe, which is named CHECKING STATEMENT. This scheduled transaction includes an entry that refers to an account by its (hidden) GUID*, which no longer exists in your file. You must change that transaction so that it refers to an account currently in your Chart of Accounts. Rather than reverse engineer the GUID by searching the data file for that GUID, I would simply delete all the template transactions in that scheduled transaction and recreate them anew, which will correct the reference. To return to your original question, your data will most likely not suffer from this error; whatever scheduled transaction you had will not get created, however. HTH, David * Transaction entries store an account's GUID, rather than an account name. So, were you to examine your raw Gnucash data, you would see a 32 character code, instead of "Assets:Checking". This allows you to rename accounts without screwing up all your historical data. Thus, your renaming of this account would not break the Scheduled Transaction, I believe. The way you break your system is more convoluted, and involves deleting accounts and creating new one with the same human-readable name. On October 14, 2019, at 1:27 PM, RICHARD YENTZER wrote: I use Android gnucash to enter daily shopping expenditures on my phone, then transfer the file weekly through Dropbox to my PC. I recall temporarily renaming the account on the PC. Do you know of a way to ferret out the dangling transaction? Richard On Mon, Oct 14, 2019, 1:29 AM D wrote: Reading the error, I'd say you have a scheduled transaction named "CHECKING STATEMENT" that refers to a no-longer-valid account ID. Did you by chance delete your checking account at some point and then create a new account for it? David On October 14, 2019, at 10:19 AM, RICHARD YENTZER wrote: each time i open gnucash i receive the following message before my user data file loads: Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX [CHECKING STATEMENT] creation. Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX [CHECKING STATEMENT] creation. Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX [CHECKING STATEMENT] creation. it appears to me that this relates to the user data i'm accessing. what is this? is it causing or potentially causing harm? How can i get rid of it? richard ryentze...@gmail.com ___ 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] How to set a customer "opening balance" for the Customer Report
Hi All My financial year started on 1st March 2019. My customer at that stage, owed 67,765.23. I tried to seed this amount in my Equity:Opening Balances account with the corresponding account being Assets:Accounts Receivable. This seemed like a sensible way of opening the accounts. However, because I don't have the invoice in the system, when the payment comes in, if "assign as payment" and select the customer, then the payment is associated with the customer but the opening balance is not so the customer starts 67,765.23 in credit. I could, of course, just not associate the payment with the customer, and then my AR account should balance but my customer report will just not include this detail. Is there any way I can have an opening balance that I can associate with a customer... the same way I would with an invoice? I don't want to create an invoice because that would duplicate a document from another system. Any ideas? thanks -- -- James Thorpe 061 476 2775 ja...@fusionsystems.co.za ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to set a customer "opening balance" for the Customer Report
Delete the opening balance transaction to get you back to zero. Then two options: 1. Create a single invoice with the balance forward and post it as of the original ‘opening balance’ date. 2. If the balance forward is from multiple invoices, import them into GnuCash, either with their real dates, or all dated as of the ‘opening balance’ date. Apply payment(s) as they come in. The advantage to #2 using real dates is you preserve the aging data and tracking of individual invoices vs. payments. This can result in a bit of a mess for affected account balances with old history that you’ll have to make correcting transactions for so that your other ‘opening balances’ work out properly. If you date them all on the same ‘opening balance’ date, you eliminate that extra work, can still track payments vs. invoices, but lose the aging tracking. A twist on option 2 is to create separate consolidated invoices for the various aging amounts (one for 30, one for 60, one for 90 days etc.) this will still preserve aging info, and will reduce the amount of correcting transactions needed, but won’t eliminate them entirely. Regards, Adrien > On Oct 14, 2019 w42d287, at 1:49 PM, James Thorpe > wrote: > > Hi All > > My financial year started on 1st March 2019. My customer at that stage, owed > 67,765.23. > > I tried to seed this amount in my Equity:Opening Balances account with the > corresponding account being Assets:Accounts Receivable. This seemed like a > sensible way of opening the accounts. > > However, because I don't have the invoice in the system, when the payment > comes in, if "assign as payment" and select the customer, then the payment is > associated with the customer but the opening balance is not so the customer > starts 67,765.23 in credit. > > I could, of course, just not associate the payment with the customer, and > then my AR account should balance but my customer report will just not > include this detail. > > Is there any way I can have an opening balance that I can associate with a > customer... the same way I would with an invoice? I don't want to create an > invoice because that would duplicate a document from another system. > > Any ideas? > > thanks > > -- > -- > James Thorpe ___ 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] Error message
Thanks !! You solved my problem. 😃 On Mon, Oct 14, 2019, 9:55 AM D wrote: > Hi, > > Please keep the list in the loop by copying Gnucash users. > > I would look in the Scheduled Transaction Editor. There is some > transaction there, I believe, which is named CHECKING STATEMENT. This > scheduled transaction includes an entry that refers to an account by its > (hidden) GUID*, which no longer exists in your file. You must change that > transaction so that it refers to an account currently in your Chart of > Accounts. Rather than reverse engineer the GUID by searching the data file > for that GUID, I would simply delete all the template transactions in that > scheduled transaction and recreate them anew, which will correct the > reference. > > To return to your original question, your data will most likely not suffer > from this error; whatever scheduled transaction you had will not get > created, however. > > HTH, > David > > * Transaction entries store an account's GUID, rather than an account > name. So, were you to examine your raw Gnucash data, you would see a 32 > character code, instead of "Assets:Checking". This allows you to rename > accounts without screwing up all your historical data. Thus, your renaming > of this account would not break the Scheduled Transaction, I believe. The > way you break your system is more convoluted, and involves deleting > accounts and creating new one with the same human-readable name. > > > On October 14, 2019, at 1:27 PM, RICHARD YENTZER > wrote: > > > I use Android gnucash to enter daily shopping expenditures on my phone, > then transfer the file weekly through Dropbox to my PC. I recall > temporarily renaming the account on the PC. Do you know of a way to ferret > out the dangling transaction? > Richard > > On Mon, Oct 14, 2019, 1:29 AM D wrote: > >> Reading the error, I'd say you have a scheduled transaction named >> "CHECKING STATEMENT" that refers to a no-longer-valid account ID. >> >> Did you by chance delete your checking account at some point and then >> create a new account for it? >> >> David >> >> On October 14, 2019, at 10:19 AM, RICHARD YENTZER >> wrote: >> >> each time i open gnucash i receive the following message before my user >> data file loads: >> >> Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX >> [CHECKING STATEMENT] creation. >> Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX >> [CHECKING STATEMENT] creation. >> Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX >> [CHECKING STATEMENT] creation. >> >> it appears to me that this relates to the user data i'm accessing. >> >> what is this? is it causing or potentially causing harm? How can i get rid >> of it? >> >> richard >> ryentze...@gmail.com >> ___ >> 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] Incactive Customer in Customer List
Thanks for your help. I am unsure about how to report a bug in gnucash. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Incactive Customer in Customer List
The wiki has instructions. Check the website for more info. You’ll need to register an account with the GnuCash Bugzilla system. Regards, Adrien > On Oct 14, 2019 w42d287, at 5:08 PM, Proberts042 wrote: > > Thanks for your help. I am unsure about how to report a bug in gnucash. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash on MacOs Catalina
Hi, I am having a problem running GNUcash 3.7 on Catalina as well. I downloaded that version today and get the error below in the Console. I tried under a different user but same issue. Any ideas? Oct 14 16:03:51 KobePro com.apple.xpc.launchd[1] (com.apple.xpc.launchd.oneshot.0x1018.Gnucash[7193]): Service exited with abnormal code: 1 -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash on MacOs Catalina
> On Oct 14, 2019, at 4:11 PM, Kees Blom via gnucash-user > wrote: > > Hi, > > I am having a problem running GNUcash 3.7 on Catalina as well. I downloaded > that version today and get the error below in the Console. I tried under a > different user but same issue. > > Any ideas? > > Oct 14 16:03:51 KobePro com.apple.xpc.launchd[1] > (com.apple.xpc.launchd.oneshot.0x1018.Gnucash[7193]): Service exited > with abnormal code: 1 Is there a crash report in Console? Anything useful in the trace file? (see https://wiki.gnucash.org/wiki/Tracefile). If not, try opening Applications:Utilities:Terminal and running it from the command line: /Applications/Gnucash.app/Contents/MacOS/Gnucash adjusting the path if you put it somewhere else. Is there any output there? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.