Re: [GNC] Bad Debt Recording
Thanks Derek and David, That was the missing part. I record a payment of the Invoice through the standard payments screen, assigning it to a temporary Income (Assets) account, then open the register for the Accounts Receivable and change the account reference to be the Bad Debtors expense account. This seems to keep the correct income figures and clears the outstanding amount for the invoice. Thanks again, very much appreciated. Jeff. On 16/8/24 11:43, Derek Atkins wrote: What I've done in the past is just process a payment and then change the transfer account from the Bank to Expense. -derek Sent using my mobile device. Please excuse any typos. On August 15, 2024 21:36:55 David Cousens wrote: Jeff, I suspect that if you are able to link the write off transaction to the invoice as a payment, this would likely clear it from both the Accounts Receivable Ageing report and the Client report. That linking may be problematical for a bad debt transaction as the Expense Accounts do not show up in the list of transfer accounts you can choose from in the Process Payments dialogue. Equity does show up in the dropdown list but if you use an equity account as the transfer account, then your income for the current period is overstated without the corresponding Expense:Bad Debts entry to reduce the nett income by the amount not paid. It can also results in an overstatement of assets by the amount of bad debts a s receivables always report at their full value and the timing of the bad debt expense recording does not match the recording of the relevant revenue- OK if you are using Cash accounting , but not if you are required to use accrual accounting for your business. Check out the bugs in Bugzilla as I seem to remember this coming up once before. My accounting textbook states that the debt doesn't die when a receivable is written off as uncollectable - the customer's obligation to pay still exists. I haven't had cause to regularly use the business features for more than 10 years now, so I am not certain about this however. I set up a dummy invoice David On Fri, 2024-08-16 at 10:38 +1000, Jeff wrote: Hi David, Again, possibly just my lack of knowledge on the subject, but I thought that essentially you cleared the debt from the client by moving it to the Bad Debt, essentially saying, We are never going to get this money, so lets forget about it. (Note I have other means to flag to not extend credit to those clients if contact continues). However probably the main reason that I thought (or wanted it) to be cleared from the client is: When GnuCash is started, it pops up with a screen showing Outstanding (or Overdue) Invoices. I know that screen can be turned off completely, however I like the screen but would like it to reflect only the outstanding invoices that we are essentially waiting for, not ones we have given up on ever getting. This is assuming that we are never going to see the bad debt money. I do understand that if for whatever reason that money does come in later, that will be a bit messy, but by the time I want to add it to the bad debts I have given up all hope of getting the money. An example is the client is now deceased. Again, I might be looking at this completely wrong. Thanks for your help. Jeff. On 16/8/24 10:21, David Cousens wrote: > I think you would have to link the writeoff transaction to the > invoice > in the same manner you link a payment if GnuCash will allow you too > do > that (I don't know for sure if it will- Derek may be able to > confirm > whether it can be). That should clear the invoice > > I would not see why it you would want to necessarily remove the bad > debt from the client report - they still owe you the money, it is > just > your judgement that you are never going to receive it. Too many > bad > debts to the one client and you would want to look at not extending > credit to them. > > If you ever did receive it, then you would have to do an adjustment > cancelling the bad debt write off and carrying forward the debt > into > the period in which it is paid (bit messy to do). > > David > > On Fri, 2024-08-16 at 09:29 +1000, Jeff wrote: > > Thanks David, > > That is a clearer description of what I am doing. > > The issue that I have, and maybe it is just my lack of general > > accounting knowledge, but the amount ($300) is still showing as > > owing > > from Bob if I either run the Client Report, or open the Invoice. > > > > Shouldn't a written off debt effective remove that debt, so when > > you > > look a that client is shows they owe nothing? > > > > This is the bit that I seem to be missing, or misunderstanding. > > Essentially how do I link it to that specific client? > > > > Regards, > > Jeff. > > > > On 16/8/24 09:17, David Co
Re: [GNC] Bad Debt Recording
Hi David, Again, possibly just my lack of knowledge on the subject, but I thought that essentially you cleared the debt from the client by moving it to the Bad Debt, essentially saying, We are never going to get this money, so lets forget about it. (Note I have other means to flag to not extend credit to those clients if contact continues). However probably the main reason that I thought (or wanted it) to be cleared from the client is: When GnuCash is started, it pops up with a screen showing Outstanding (or Overdue) Invoices. I know that screen can be turned off completely, however I like the screen but would like it to reflect only the outstanding invoices that we are essentially waiting for, not ones we have given up on ever getting. This is assuming that we are never going to see the bad debt money. I do understand that if for whatever reason that money does come in later, that will be a bit messy, but by the time I want to add it to the bad debts I have given up all hope of getting the money. An example is the client is now deceased. Again, I might be looking at this completely wrong. Thanks for your help. Jeff. On 16/8/24 10:21, David Cousens wrote: I think you would have to link the writeoff transaction to the invoice in the same manner you link a payment if GnuCash will allow you too do that (I don't know for sure if it will- Derek may be able to confirm whether it can be). That should clear the invoice I would not see why it you would want to necessarily remove the bad debt from the client report - they still owe you the money, it is just your judgement that you are never going to receive it. Too many bad debts to the one client and you would want to look at not extending credit to them. If you ever did receive it, then you would have to do an adjustment cancelling the bad debt write off and carrying forward the debt into the period in which it is paid (bit messy to do). David On Fri, 2024-08-16 at 09:29 +1000, Jeff wrote: Thanks David, That is a clearer description of what I am doing. The issue that I have, and maybe it is just my lack of general accounting knowledge, but the amount ($300) is still showing as owing from Bob if I either run the Client Report, or open the Invoice. Shouldn't a written off debt effective remove that debt, so when you look a that client is shows they owe nothing? This is the bit that I seem to be missing, or misunderstanding. Essentially how do I link it to that specific client? Regards, Jeff. On 16/8/24 09:17, David Cousens wrote: Jeff, The standard direct write off method for bad debts would be to credit the Accounts Receivable for the amount of the bad debt and debit an Expense:Bad Debts account for that amount. That will remove the bad debt from your Accounts receivable and record it as an expense against the business as you suggested. There are more complex allowance methods where your business has a fraction of bad debts regularly and you are required to use accrual accounting. David Cousens On Fri, 2024-08-16 at 08:53 +1000, Jeff wrote: Hi list, Looking for some advice in recording (writing off) some bad debts in GnuCash when using the Business Invoice/Bills feature. Example: Have Client Bob who owes (has been send and Invoice) for $1000. Bob are disputing the full amount and have only paid $700. In GnuCash I open the Invoice and record a payment of $700. This leaves Bob owing $300. I can record a $300 amount going into Expenses -> Bad Debts, from the Accounts Receivable going directly via the Account page. I think that this then effectively wipes out the debt. (This may be completely wrong) My issue is Bob still shows as owing $300. I, maybe incorrectly, assumed it would effectively show as Bob owes nothing as we have forgiven the amount owed. What step am I missing? Can it be done through the Invoice screen to essentially "pay" the invoice? The Payment side of the Invoice only seems to show "Assets" accounts (as expected). Regards, Jeff. ___ 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. ___ 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. ___ 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
Re: [GNC] Bad Debt Recording
Thanks David, That is a clearer description of what I am doing. The issue that I have, and maybe it is just my lack of general accounting knowledge, but the amount ($300) is still showing as owing from Bob if I either run the Client Report, or open the Invoice. Shouldn't a written off debt effective remove that debt, so when you look a that client is shows they owe nothing? This is the bit that I seem to be missing, or misunderstanding. Essentially how do I link it to that specific client? Regards, Jeff. On 16/8/24 09:17, David Cousens wrote: Jeff, The standard direct write off method for bad debts would be to credit the Accounts Receivable for the amount of the bad debt and debit an Expense:Bad Debts account for that amount. That will remove the bad debt from your Accounts receivable and record it as an expense against the business as you suggested. There are more complex allowance methods where your business has a fraction of bad debts regularly and you are required to use accrual accounting. David Cousens On Fri, 2024-08-16 at 08:53 +1000, Jeff wrote: Hi list, Looking for some advice in recording (writing off) some bad debts in GnuCash when using the Business Invoice/Bills feature. Example: Have Client Bob who owes (has been send and Invoice) for $1000. Bob are disputing the full amount and have only paid $700. In GnuCash I open the Invoice and record a payment of $700. This leaves Bob owing $300. I can record a $300 amount going into Expenses -> Bad Debts, from the Accounts Receivable going directly via the Account page. I think that this then effectively wipes out the debt. (This may be completely wrong) My issue is Bob still shows as owing $300. I, maybe incorrectly, assumed it would effectively show as Bob owes nothing as we have forgiven the amount owed. What step am I missing? Can it be done through the Invoice screen to essentially "pay" the invoice? The Payment side of the Invoice only seems to show "Assets" accounts (as expected). Regards, Jeff. ___ 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. ___ 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. ___ 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.
[GNC] Bad Debt Recording
Hi list, Looking for some advice in recording (writing off) some bad debts in GnuCash when using the Business Invoice/Bills feature. Example: Have Client Bob who owes (has been send and Invoice) for $1000. Bob are disputing the full amount and have only paid $700. In GnuCash I open the Invoice and record a payment of $700. This leaves Bob owing $300. I can record a $300 amount going into Expenses -> Bad Debts, from the Accounts Receivable going directly via the Account page. I think that this then effectively wipes out the debt. (This may be completely wrong) My issue is Bob still shows as owing $300. I, maybe incorrectly, assumed it would effectively show as Bob owes nothing as we have forgiven the amount owed. What step am I missing? Can it be done through the Invoice screen to essentially "pay" the invoice? The Payment side of the Invoice only seems to show "Assets" accounts (as expected). Regards, Jeff. ___ 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] Idiot 101 question
On 1/11/24 10:10 AM, Adrien Monteleone wrote: If their drives with OS installations are intact, perhaps converting them to VM images might suffice for now. As for Windows software, have you given the latest Wine a spin with it? It may not work 100% out of the box, but you might get close enough with some fiddling. Regards, Adrien On 1/11/24 2:15 AM, Jeff wrote: I'm just trying to get back to gnc and unfortunately a windows program, H@r Block. Without at least 2 computers this almost difficult task unless you have a way to run H@r Block windows version 2023 under ubuntu? And right now I have only one computer. A surge supseror exploded and fried all of my computers. I have a temporary replacement for the network server but not any workstations. ___ 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. Adrien: I do not fully understand yet what has happened. My "NEW" old tower recognized all of my drives I pulled from the blown up computers, then poof, the new computer suddenly doesn't recognize them anymore (all of the ssd boot drives). I got lucky tonight and found the drive for my Ubuntu server or I would not be responding. If I cannot get the sata drive from my laptop back up and running then I am screwed for taxes (Stupid me I forgot to backup 2022). I can still do the book keeping from here if I can keep Ubuntu up and running (except that some of the financial institution ID an passwords that are on a windowze drive). Much easier under__Ubuntu and a work station. Unfortunately for me, the tax software is on a windozs drive that I can no longer access. _ _I have not tried using a VM, as this tower suddenly decided that several of my drives no longer exist. How would I move it to a VM? -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Idiot 101 question
On 1/10/24 1:48 AM, David Carlson wrote: Oh, release 5.5 has a couple of bugs, the Windoze version especially. You may want to revert to release 5.4, but that has it's own issue, so check the history here and choose your poison. On Wed, Jan 10, 2024 at 1:42 AM David Carlson wrote: Maybe we should take a lesson from you and put that surge protected power strip next to our pc or entertainment center inside a very sturdy box if it isn't already in it's own container. On Wed, Jan 10, 2024 at 1:06 AM Jeff wrote: After a surge protector blew up in my face and fried my server and workstations I am trying to catch up. I assume the update to 5.5 is compatible on Ubuntu and Windoze? It's tax time and I am down to 0 workstations, from 4, until I can locate a station strictly for taxes. And yes, you will soil your pants no matter how many surge protectors you have explode in your face. Thankfully this one was only a 15 amp one and not the 10 KW inverter that exploded in my face at work. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson -- David Carlson David: I'm just trying to get back to gnc and unfortunately a windows program, H@r Block. Without at least 2 computers this almost difficult task unless you have a way to run H@r Block windows version 2023 under ubuntu? And right now I have only one computer. A surge supseror exploded and fried all of my computers. I have a temporary replacement for the network server but not any workstations. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Idiot 101 question
On 1/10/24 3:42 AM, Jeff wrote: On 1/10/24 1:48 AM, David Carlson wrote: Oh, release 5.5 has a couple of bugs, the Windoze version especially. You may want to revert to release 5.4, but that has it's own issue, so check the history here and choose your poison. On Wed, Jan 10, 2024 at 1:42 AM David Carlson wrote: Maybe we should take a lesson from you and put that surge protected power strip next to our pc or entertainment center inside a very sturdy box if it isn't already in it's own container. On Wed, Jan 10, 2024 at 1:06 AM Jeff wrote: After a surge protector blew up in my face and fried my server and workstations I am trying to catch up. I assume the update to 5.5 is compatible on Ubuntu and Windoze? It's tax time and I am down to 0 workstations, from 4, until I can locate a station strictly for taxes. And yes, you will soil your pants no matter how many surge protectors you have explode in your face. Thankfully this one was only a 15 amp one and not the 10 KW inverter that exploded in my face at work. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson -- David Carlson /I have to remember that. My eye brows are still growing back. Talk about a gremlin in the system, I just had one!!/ / You still have eye browse? Mine have not grown back. Must because I am a lot older than you. I will try to revert one version. I'm still 1 computer short of having my network back up. This f'ing 3 layer security is ridiculous and unnecessary. I keep getting locked out of one of my banks every time I to login. Changing passwords every time I log in is ridiculous. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Upgrading or starting fresh?
Just adding to what Adrien has said. 1. Would it be easier to just download the current stable version and start fresh (with opening balances) for 2024, keeping the previous version/files backed-up and available for informational purposes, and in case of a future audit? Can I have two versions running on the same PC (Windows 10)? I recently upgraded my main books from 2.6 to 5.3 (the current stable packaged version on Kubuntu Linux). I had been upgrading along the way for testing, but hadn't seen the need to update my actual books as the functionality I needed was in 2.6 and working fine. The main reason I upgraded was worried about loosing OS support for such an old program. I took the upgrade through each major version path, all went very smoothly. Just do note, that there has been an underlying change somewhere between 2.6 and 4 with the way GnuCash calculates the total on Invoices and Bills, if you use those features. This has caused some headaches, but i now just add a rounding correction line, doesn't look very professional, but hopefully somewhere down the track they may go back to the old method, just be aware of the change before you jump versions. Example: (Note I have not tried the specific values here, but this is what happens) 1. Add in Line item Costing $100 including GST 2. System Calculates item costs $90.91 excluding GST with a GST of $9.09 3. Shows a TOTAL on the Invoice of $100.01, or $99.99 Note that same can happen if you enter it the other way around, eg without GST and get the system to add it. It is obviously to do with how it rounds the figures. Just annoying when you enter in a single figure, and it shows the figures correct for the line item, but then calculates the wrong figure. Have had it happen even with a single item in the Invoice or Bill, but is more likely to happen when there are multiple line items in the Invoice/Bill. Otherwise the system (at least on Linux, Windows may be different) is as rock solid as ever. Regards, Jeff. ___ 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] Idiot 101 question
On 1/10/24 1:48 AM, David Carlson wrote: Oh, release 5.5 has a couple of bugs, the Windoze version especially. You may want to revert to release 5.4, but that has it's own issue, so check the history here and choose your poison. On Wed, Jan 10, 2024 at 1:42 AM David Carlson wrote: Maybe we should take a lesson from you and put that surge protected power strip next to our pc or entertainment center inside a very sturdy box if it isn't already in it's own container. On Wed, Jan 10, 2024 at 1:06 AM Jeff wrote: After a surge protector blew up in my face and fried my server and workstations I am trying to catch up. I assume the update to 5.5 is compatible on Ubuntu and Windoze? It's tax time and I am down to 0 workstations, from 4, until I can locate a station strictly for taxes. And yes, you will soil your pants no matter how many surge protectors you have explode in your face. Thankfully this one was only a 15 amp one and not the 10 KW inverter that exploded in my face at work. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson -- David Carlson /I have to remember that. My eye brows are still growing back. Talk about a gremlin in the system, I just had one!!/ / / / / -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Idiot 101 question
After a surge protector blew up in my face and fried my server and workstations I am trying to catch up. I assume the update to 5.5 is compatible on Ubuntu and Windoze? It's tax time and I am down to 0 workstations, from 4, until I can locate a station strictly for taxes. And yes, you will soil your pants no matter how many surge protectors you have explode in your face. Thankfully this one was only a 15 amp one and not the 10 KW inverter that exploded in my face at work. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Gnucash
On 26/8/23 11:46, Stan Brown (using GC 4.14) wrote: On 2023-08-25 16:30, Maf. King wrote: I've just had a thought on a possible reason the original file could not be saved. I may be barking up the wrong tree. Does Win have a maximum length for a filename? It does, both for filename specifically (see below) and for total of path+filename. But recent versions of Windows have increased it to the point where real-life use is unlikely to hit the limit. However, "In the Windows API [for use by applications, as opposed to components of Windows itself], the maximum length for a path is MAX_PATH, which is defined as 260 characters. A local path is structured in the following order: drive letter, colon, backslash, name components separated by backslashes, and a terminating null character." That limit does still exist, I have just been dealing with it where a particular file would not open in LibreOffice Writer due to the limit (actually it would open if LibreOffice was open and the file was opened from inside LibreOffice, but it would not open if double clicked, while all other (shorter) files opened fine via both methods). It also did strange things at the File Explorer level, such as not allowing the file to copied to the same folder, with a suggested name change. So the issue affected both 3rd Party apps (LibreOffice) and Windows core apps (Explorer). I could see the possibility of the issue affecting GnuCash. I doubt that file save dialogs are be affected by that, since they're part of Windows, but maybe. May well be, as above. Later in the same article, there is a procedure to remove that limitation in the Windows API, if you're in Windows 10 or 11. I hesitate to suggest that Barry try that procedure himself, because it involves editing the Windows Registry. However, anyone who's comfortable with Registry edits could easily follow the directions to do it for him. Unfortunately the registry change isn't honoured by all apps. Some have the newly increased limit, and some don't. This may or may not be the issue with OP, but there is a fair chance that the maximum limit has been reached. Regards, Jeff. ___ 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] Writing off Stock - More an Accounting Question than a GnuCash one
Thanks Michael and David for the helpful suggestions. It looks like I was sort of on the right track. These write-offs will be very irregular (have not needed to do any for the last 6 years) so I think I'll go along the lines suggested by David. Just now need to get my head around it. Thanks again Jeff. On 26/6/23 06:15, David Cousens wrote: Jeff, The following treatments are generic from a basic accounting textbook and should not be taken as accounting advice that is relevant to your specific circumstances. This is the direct write off method: You write it off as an expense to the COGS account i.e credit the Asset:Inventory account and debit the Expense:COGS account. This would usually be used if the write off amounts are small and irregular. (Using this method can distort the gross margin where writeoffs are significant and is not recommended for significant writeoffs You can also create an Expense:WriteOffs account rather than using COGS if the amount of the write offs is significant and needs to appear as a line item in your reports. In the allowance method, rather than crediting the inventory account directly you set up a contra sub account of the Asset :Inventory account usually named something like Asset:Inventory:InventoryReserve and credit that and again debit the expense account. This is the usual method where the inventory may have lost value but isn't being disposed of immediately. At actual disposal of the asset the Reserve account is debited and the Inventory account is credited. If the value of inventory falls below its cost, it is usually written down rather than written off and a separate expense account Expense:Write Downs is used instead of the Expense:Write Offs account. David Cousens On Sun, 2023-06-25 at 15:42 +1000, Jeff wrote: Hi List, This is more a general accounting question than specifically a GnuCash one, but thought there might be better help on the list for it. Background: I use GnuCash for business use, and track the purchase of inventory. This goes into an Inventory Account When sold, the sale gets recorded against the Income Sales, and the cost of the goods gets recorded in COG's. Issue: I have some stock that is either obsolete, or otherwise no longer fit for sale. Just wondering what is the "correct" way to write this stock off. (In case it matters, I am located in Australia). My thoughts were: - Have an Account called Write-offs to record the transfer of the dollar amount from Inventory to Write-Offs. - Also, record the cost of goods in the COG's account, just like it was sold. This is the main bit I am unsure of. Any other suggestions, or am I looking at this completely wrong? Regards, Jeff, ___ 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. ___ 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. ___ 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.
[GNC] Writing off Stock - More an Accounting Question than a GnuCash one
Hi List, This is more a general accounting question than specifically a GnuCash one, but thought there might be better help on the list for it. Background: I use GnuCash for business use, and track the purchase of inventory. This goes into an Inventory Account When sold, the sale gets recorded against the Income Sales, and the cost of the goods gets recorded in COG's. Issue: I have some stock that is either obsolete, or otherwise no longer fit for sale. Just wondering what is the "correct" way to write this stock off. (In case it matters, I am located in Australia). My thoughts were: - Have an Account called Write-offs to record the transfer of the dollar amount from Inventory to Write-Offs. - Also, record the cost of goods in the COG's account, just like it was sold. This is the main bit I am unsure of. Any other suggestions, or am I looking at this completely wrong? Regards, Jeff, ___ 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] Reports will not display on screen, print to file works == Solved
On 4/11/23 3:53 PM, Murugan Muruganandam wrote: i have the same version and build and i am able to view reports can you try apt get update and also re install the application Saludos Cordiales Murugan *From:* gnucash-user on behalf of Jeff *Sent:* Tuesday, April 11, 2023 2:13 PM *To:* Gnucash userlist *Subject:* [GNC] Reports will not display on screen, print to file works Running: Version: 5.0 Build ID: Flathub 5.0-1 Finance::Quote: 1.5301 on Ubuntu 22.04.2 LTS I do not know when my system upgraded GNC from the prior stable version 4, it was running version 4 a few days ago. None of the reports will display on screen in version 5.0-1. In order to see any report I have to print it to file. I looked in the bug reports and did not see any similar submission. GNC did this to me in a prior version but, I do not remember the fix. If there is not a workaround, how do I remove 5.0-1 and reinstall the last stable 4 release. print it-- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. After uninstalling everything I could from the command line and reinstalling, GNC 5.0 will now display reports in a tab, as it should. It still has some date handling issues that I need to research further after tax season. And I did notice that the "about" screen is different after removing/reinstalling version 5.0, with exception to the version numbers. This install displays the "GNC_*: /'install path'" for DATA, CONF, etc. The prior install did not show these. At the moment it looks like the problem is solved. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports will not display on screen, print to file works
On 4/11/23 1:53 PM, Adrien Monteleone wrote: Jeff, Report display has to do with webkit. Perhaps check to see if it needs updating as well, or if for some reason you've pinned an old version to prevent updating. (but then you'd need to recall why you pinned it so as not to break something else.) That might not be the culprit, but it would be the first thing I'd check. Regards, Adrien On 4/11/23 1:13 PM, Jeff wrote: Running: Version: 5.0 Build ID: Flathub 5.0-1 Finance::Quote: 1.5301 on Ubuntu 22.04.2 LTS I do not know when my system upgraded GNC from the prior stable version 4, it was running version 4 a few days ago. None of the reports will display on screen in version 5.0-1. In order to see any report I have to print it to file. I looked in the bug reports and did not see any similar submission. GNC did this to me in a prior version but, I do not remember the fix. If there is not a workaround, how do I remove 5.0-1 and reinstall the last stable 4 release. ___ 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. Near as I can tell, nothing is pinned. GNC 5.0-1 just does not work with on screen reports (any of them), printing only (file and/or hard copy). Webkit is current, at least according to Synaptic. I'm at a loss. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reports will not display on screen, print to file works
Running: Version: 5.0 Build ID: Flathub 5.0-1 Finance::Quote: 1.5301 on Ubuntu 22.04.2 LTS I do not know when my system upgraded GNC from the prior stable version 4, it was running version 4 a few days ago. None of the reports will display on screen in version 5.0-1. In order to see any report I have to print it to file. I looked in the bug reports and did not see any similar submission. GNC did this to me in a prior version but, I do not remember the fix. If there is not a workaround, how do I remove 5.0-1 and reinstall the last stable 4 release. print it-- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] easy way to total number of transactions and USD ammounts
The IRS threw me a curve ball this year (imagine that). One of their tax forms went from $600 minimum to you, to $20,000 "AND" more than 200 transactions in 2022. Is there someone out there that can hold my hand and show me how to export those transactions to a spreadsheet to see if we fall into that level at the federal level, since there are no reporting features in GNC that total $ and number of transactions, at least that I am aware of? I have not used spreadsheets for much of anything since my college days, shall we say decades ago, so rusty is an understatement. The real kicker is my state sets the minimum at $1,200, period. The company involved, has so far refused to provide me with a copy of the 1099 involved. It may or may not meet the federal level but I know for a fact that it passes my states $ level of $1,200. Don't you just love our tax system in the U.S.A.? NOT! -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] version 5.0 stable, is there a flathub update?
I see that the much awaited version 5.0 stable has been released. Is there a way to do it under Flathub, on Ubuntu 22.04.1 lts? Or do I need to figure out how to convert my updates to flatpak? I would build it on my own server but it fails to create an executable version every-time. One of those gremlins my Physics professors kept warning me about. I think Schrodinger's cat must be lurking in my system some where. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tax Invoice & Australian Tax Invoice Total Discount Bug
Thanks Liz, I'll add it to the tracker. On 19/2/23 08:47, ed...@billiau.net wrote: On Sat, 18 Feb 2023 12:30:18 +1100 Jeff wrote: Hi List, I am in the process of upgrading to the latest version of GnuCash, but have found a bug in the Tax Invoice Report file "taxinvoice.eguile.scm. This effects both the standard Tax Invoice and Australian Tax Invoice as they both use the same scm file. The Discount Total on the report always equates to ZERO. Thanks Jeff. I've never seen it because I never discount anything! There is a place to put the bug and patch file on the bugtracker https://bugs.gnucash.org/ Liz once others have confirmed it is not user error ___ 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. ___ 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.
[GNC] Tax Invoice & Australian Tax Invoice Total Discount Bug
Hi List, I am in the process of upgrading to the latest version of GnuCash, but have found a bug in the Tax Invoice Report file "taxinvoice.eguile.scm. This effects both the standard Tax Invoice and Australian Tax Invoice as they both use the same scm file. The Discount Total on the report always equates to ZERO. I have tried googling, but have not found any other reports of this error, although I do seem to recall running into it a few years ago. I have been running GnuCash 2.6 (yes, I know, VERY old, but it works for me) where the report worked fine. I'm not sure about the 3.x release, but so far all of the 4.x releases I've tried all have the same issue. The report in 2.6 actually calculated the Discount Total by adding each Discount line item amount together. The report line (310) was: (dsc-total (gnc:make-commodity-collector)) The report has been updated some time ago that it now calculates the Discount Total, but the equation is wrong as it always equates to zero. Unfortunately BOTH files state it is: - Version 0.03 - Modified Date: 16 Feb 2012 Surely other people are using the Invoice report to send Invoices with discounts? This bug couldn't have been around unnoticed since 2012, or is there a setting that I've missed? Line 301 in the "new" file now has the following calculation: (dsc-total (- inv-total tax-total sub-total)) However, The Invoice Total - Tax Total - Sub-Total will always equal Zero and does not equate to any discount as those numbers are AFTER the discount has been applied. Example: Charge : $100 Discount: $10 Invoice Total: $90 Tax Total : $1 Sub Total : $89 (Sub Total is the Total Invoice amount Pre-Tax in this report) So Invoice Total ($100) - Tax Total ($1) - Sub-Total ($89) = $0 Nowhere does the Discount Total come into it. I have reverted back the calculation to be based on adding each line item, and it seems to work. I have attached a PatchFile, just in case this issue has been affecting others and they wish to apply the patch, or if a maintainer wishes to apply it to the main branch. I have just based the changes on a 5 minute scheme crash course, mostly by looking at the older report file, so there has not been any rigorous testing, but it seems to work. If there is any setting that I should be using that will make the change redundant I'd be happy if someone could point it out to me. Regards, Jeff.--- taxinvoice.eguile.scm_ORIG 2023-02-18 12:08:18.238227981 +1100 +++ taxinvoice.eguile.scm 2023-02-18 12:08:18.228227981 +1100 @@ -298,7 +298,7 @@ (let* ((inv-total (gncInvoiceGetTotal opt-invoice)) (tax-total (gncInvoiceGetTotalTax opt-invoice)) (sub-total (gncInvoiceGetTotalSubtotal opt-invoice)) - (dsc-total (- inv-total tax-total sub-total)) + (dsc-total (gnc:make-commodity-collector)) (total-col (gnc:make-commodity-collector))) (total-col 'add currency inv-total) (for-each @@ -314,6 +314,8 @@ (acc (if cust-doc? (gncEntryGetInvAccount entry)(gncEntryGetBillAccount entry))) (taxable (if cust-doc? (gncEntryGetInvTaxable entry)(gncEntryGetBillTaxable entry))) (taxtable (if cust-doc? (gncEntryGetInvTaxTable entry)(gncEntryGetBillTaxTable entry +(dsc-total 'add currency rdiscval) + ?> @@ -362,7 +364,7 @@ (if (and discount?) 1 0) ) ?>"> - + ___ 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] Entry of unknown transaction
On 2/4/23 11:46 AM, David Carlson wrote: I have occasionally found a stray deposit receipt near an ATM when I was withdrawing cash. If I carelessly pocketed it with my receipt, I might get a surprise later. The stray would have a different account number on it. Could this be what happened to you? On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry wrote: On 4 Feb 2023, at 11:58, Jeff wrote: > > I have discovered several transactions that show up in one account but do not show up in any other existing account. Regardless of what the bank image shows of where the check was deposited. > > I.E. I have a deposit slip that shows it went to our checking account but never showed up there (OFX or printed mailed statement). I can not reconcile it so how do handle it? > > In other words, I have half of a double entry transaction. More than one, unfortunately. > > -- > --JEffrey Black M.B.A. Not entirely sure what you mean, Jeffrey. Are the transactions you refer to recorded in GNUCash as money paid into your account but without a recorded source account? This should have a corresponding entry in the Imbalance account, automatically created when you put in an unbalanced transaction. Did you receive a check which you deposited in your checking account and for which your received a receipt from the bank in the form of a date-stamp on the deposit slip, but for which there is no record in the bank statement (paper or electronic)? If yes, then you need to take that up with the bank - was the check bounced? When you’re reconciling, you’re matching up the bank’s view of the world with your own, and can only mark as reconciled the transactions which appear in both. Michael ___ 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. -- David Carlson Easiest example that I can remember off the top of my head is, my wife recently wrote a check from her business account (her weeks wages) and deposited it directly into our personal account. The OFX import, and statement, from our bank show it but there is no matching transaction in the business account. Our statement has an image of the check plain as day but there is no match, period, in her business account statement(s). And what really has me bumfuzzled is both sets of books are reconciled per their respective statements. And it's not just one transaction involved, there are multiples. That check did not bounce, it just seemingly like magic appeared in our account out of thin air. Magic money. For now I have the check recorded as a deposit to our account and withdrawal from Imbalance-USD. Just wanted to get your input on if that is the best way to handle transactions like that. Her PayPal dealings are even worse but; that is for a different thread. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Entry of unknown transaction
I have discovered several transactions that show up in one account but do not show up in any other existing account. Regardless of what the bank image shows of where the check was deposited. I.E. I have a deposit slip that shows it went to our checking account but never showed up there (OFX or printed mailed statement). I can not reconcile it so how do handle it? In other words, I have half of a double entry transaction. More than one, unfortunately. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] ^F Find not finding recently entered text in Memo field
On 1/23/2023 3:27 PM, David H wrote: Jeff, If you do a find from the accounts tab it will search in all splits, if however you do a find in a Register tab it only looks at splits for that particular Register, it doesn't search in splits belonging to other Register's. Are you falling into this trap ? Thanks David. Interesting, If I do the find from the Accounts tab it does find the transaction. But I have been searching in the bank register where the transaction I'm looking for resides. It doesn't find the transaction that is in the bank register searched from that specific bank register where the transaction I'm looking for resides. - Jeff Cheers David H. On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht wrote: Windows 11 Version: 4.13 Build ID: 4.13+(2022-12-17) FWIW I've been, happily, using GNUCash for several years. I'm working on my 2022 taxes importing .OFX files from my banks. I generally want to add a memo on most transactions with notes found from the vendor transaction details on their respective sites. Since this adding memos isn't currently possible during the import I move transaction to a temporary 'unaccounterd for 2022' register where I add notes in the memo field, categorize the transaction and save. Occasionally I want to verify that I entered the correct notes in the Memo field. I do a find with 'contains' searching in the 'description, notes or memo' This find operation doesn't appear to be finding transactions I've entered today although if I search visually through the register they have been entered. I did upgrade to 4.13 from some 4.xx version before I started working on this .OFX import. I haven't used Find for some time but if my memory is correct I've used find similarly in the past successfully. I tried to find some kind of re-indexing function. Does such an option exist? I did try exiting and restarting GNUCash and repeating the find with the same results, not finding transaction with memos entered today. -- Jeff Albrecht KF7CRU @jhalbrecht ___ 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. -- Jeff Albrecht KF7CRU @jhalbrecht ___ 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.
[GNC] ^F Find not finding recently entered text in Memo field
Windows 11 Version: 4.13 Build ID: 4.13+(2022-12-17) FWIW I've been, happily, using GNUCash for several years. I'm working on my 2022 taxes importing .OFX files from my banks. I generally want to add a memo on most transactions with notes found from the vendor transaction details on their respective sites. Since this adding memos isn't currently possible during the import I move transaction to a temporary 'unaccounterd for 2022' register where I add notes in the memo field, categorize the transaction and save. Occasionally I want to verify that I entered the correct notes in the Memo field. I do a find with 'contains' searching in the 'description, notes or memo' This find operation doesn't appear to be finding transactions I've entered today although if I search visually through the register they have been entered. I did upgrade to 4.13 from some 4.xx version before I started working on this .OFX import. I haven't used Find for some time but if my memory is correct I've used find similarly in the past successfully. I tried to find some kind of re-indexing function. Does such an option exist? I did try exiting and restarting GNUCash and repeating the find with the same results, not finding transaction with memos entered today. -- Jeff Albrecht KF7CRU @jhalbrecht ___ 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] reports not working unless exported [solved]
On 1/13/23 4:30 PM, David H wrote: Jeff, I seem to recall just doing a "Flatpak Update" fixed an issue with blank reports a little while ago - from memory it updated something else but I don't remember the details. So give that a shot and see if it fixes the issue. Cheers David H. On Sat, 14 Jan 2023 at 07:12, Jeff wrote: Running: Version: 4.13 Build ID: Flathub 4.13 Finance::Quote: 1.5301 on: Ubuntu 22.04.1 LTS I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. (Not sure from which version from Flathub this started.) ALL of the reports built into GNC now have to be exported to see them and time wise that is a problem right now, especially if I screw up and include/exclude a wrong account. I vaguely remember reading a post on how to correct this problem. Any help appreciated. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. Thanks David. It was a Flatpak update problem. For whatever reason, after the last set of updates to Ubuntu, the Flatpak package program did not update 4 files (looked like system files and one video driver). A forced update from a superuser terminal fixed it. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reports not working unless exported
On 1/13/23 4:13 PM, Michael or Penny Novack wrote: I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. Explain what you mean by "will not work" Are you having a DATE problem? (you don't know how to specify the effective date(s) for a report?) Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. I've tried custom date ranges and using beginning of previous year/end of previous year. All I get is a blank tab or window, unless I export the report to say an HTML file, which will display properly in Firefox. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] reports not working unless exported
Running: Version: 4.13 Build ID: Flathub 4.13 Finance::Quote: 1.5301 on: Ubuntu 22.04.1 LTS I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. ALL of the reports built into GNC now have to be exported to see them and time wise that is a problem right now, especially if I screw up and include/exclude a wrong account. I vaguely remember reading a post on how to correct this problem. Any help appreciated. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] reports not working unless exported
Running: Version: 4.13 Build ID: Flathub 4.13 Finance::Quote: 1.5301 on: Ubuntu 22.04.1 LTS I went to generate some reports for the year 2022 and not one of the standard reports will work within GNC now. (Not sure from which version from Flathub this started.) ALL of the reports built into GNC now have to be exported to see them and time wise that is a problem right now, especially if I screw up and include/exclude a wrong account. I vaguely remember reading a post on how to correct this problem. Any help appreciated. -- --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 - 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 4.900 Released
On 1/10/23 12:14 AM, Adrien Monteleone wrote: Lots of great improvements already and I'm sure more to look forward to. (some new reports too!) But of the list so far, my money is on this one getting the most sighs of relief and smiles: "The description field quickfill in the register now displays a drop-down list of possible completions instead of just one inline completion." (of course, a Stock Assistant is majorly cool too...) Thanks to all! Regards, Adrien ___ 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. I missed something here, not surprising with the last 48 hour days I have spent. All of the messages I see are Re.[GNC] GnuCash 4.900 Released. I cannot find the original message in any of the e-mails I down loaded. Is there a new version or not? And how do I find it under Ubuntu 22.04.1 LTS? -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 27/12/2022 16:21, Geert Janssens wrote: Can you post the output of cd /usr/share/glib-2.0/schemas stat -c'%w %n' org.gnucash.* gschemas.compiled 2022-12-26 10:04:03.695021388 +0100 org.gnucash.GnuCash.deprecated.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.business.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.checkprinting.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.commodities.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.export.csv.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.flicker.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.import.csv.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.import.generic.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.import.hbci.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.import.ofx.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.import.qif.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.reconcile.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.sxs.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.dialogs.totd.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.general.finance-quote.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.history.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.warnings.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.window.pages.account.tree.gschema.xml 2022-12-26 10:04:03.699021454 +0100 org.gnucash.GnuCash.window.pages.gschema.xml 2022-12-27 08:29:57.412027720 +0100 gschemas.compiled The next time you start gnucash it will print the value of XDG_DATA_DIRS in the gnucash.trace file somewhere. Can you look for this and check whether there's another directory on the path that has a non-empty glib-2.0/schemas subdirectory ? * 16:30:46 WARN XDG_DATA_DIRS=/usr/share/gnome:/usr/local/share/:/usr/share/ So no. Is there a way to get gnucash 4.13 installed on your system (and not via flatpak ?) That would be another useful test. I just built a deb for 4.13 and indeed the problem is fixed. Thanks for your help. Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 27/12/2022 13:30, Geert Janssens wrote: I'm not sure what the typical paths on Debian are, but on Fedora the schemas for system packages end up in /usr/share/glib-2.0/schemas/ While locally built schemas typically end up in /usr/local/share/glib-2.0/schemas/ If there are schema files in both locations (not necessarily gnucash related), a gnucash installed from a deb package will not find its schema files in the former location and hence settings will not work. The first path has lots of xml-files and a few others. The second path does not exist. echo $XDG_DATA_DIRS gives: /usr/share/gnome:/usr/local/share/:/usr/share/ But there isn't a glib-2.0 directory in /usr/share/gnome, either. Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 27/12/2022 13:41, Jeff wrote: Thanks for the help. I guess something I did created a second gsettings schema a couple of days ago. In the mean time, how do I identify and remove the second gsettings schema? Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 27/12/2022 13:30, Geert Janssens wrote: Typically you'd have plenty of errors or warnings about this in the gnucash.trace file (which John suggested to check for). This was fixed for gnucash 4.13 only. So perhaps you are suffering from this bug ? Oh yes. In /tmp/gnucash.trace I see: * 08:44:20 ERROR g_settings_new_full: assertion 'schema != NULL' failed * 08:44:20 WARN [gnc_gsettings_get_settings_ptr()] Ignoring attempt to access unknown gsettings schema org.gnucash.GnuCash.general * 08:44:20 ERROR void gnc_gsettings_remove_cb_by_func(const gchar*, const gchar*, gpointer, gpointer): assertion 'G_IS_SETTINGS (settings_ptr)' failed Thanks for the help. I guess something I did created a second gsettings schema a couple of days ago. Does anyone have a Debian build for 4.13 that I can test? Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 26/12/2022 19:26, R Losey wrote: This is probably a dumb question, but do your preferences file still exist? And are they readable/writeable by you? And the permissions of the parent directory (or directories) haven't been changed? I've been trying to work out where the changes land. When you make a small minor tweak to preferences, does the timestamp change on the preferences file? Edit/Preferences give the date format to be ISO. If I change it to, say, UK and hit close, and then open the dialogue again, it is back to ISO. When I open Edit/Preferences, I get sys:1: Warning: g_hash_table_foreach: assertion 'hash_table != NULL' failed on the command line, which I assume is then the problem. Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 26/12/2022 18:21, john wrote: You can make sure that you have a dbus-daemon running with `ps -A | grep dbus-daemon`. But the Gsettings docs claim that dbus-daemon doen't need to be running for reads, only for writes. Yup. It's running. org.gnucash.general is obsolete. We changed the preferences domain from org.gnucash to org.gnucash.GnuCash in 4.8 to accommodate flatpak, which insists on the three-level domain name. If you're using the Debian Testing installed GnuCash you should have GnuCash 4.12. Yup. I have 4.12. gsettings list-recursively org.gnucash.GnuCash.general also has date-format 1 Assuming that is UK, I haven't used it in years. Dconf data isn't stored in either of those, it's in $XDG_CONFIG_DIR/dconf. See https://www.systutorials.com/docs/linux/man/7-dconf/ <https://www.systutorials.com/docs/linux/man/7-dconf/> for the gory details about how the system works. XDG_CONFIG_DIR isn't set, but seems to default to ~/.config. The dconf files there are binary. But installing dconf-editor produces the same result as above for org.gnucash.GnuCash.general. Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
Hi John, On 24/12/2022 22:39, john wrote: The prefs are managed by dconf and I think on Linux it needs a dbus daemon running. The latter's logs go in /var/log/daemon.log; I'd expect the GLib gconf frontend errors to show up in the trace file. Weirdly, /var/log/daemon.log only has entries between 30th Oct and 04 Nov, so I assume the logs are landing somewhere else. What do you mean by the gconf trace file? I don't see anything related to settings if I start gnucash with: gnucash --debug --extra Don't hope, test. Try restoring from backup. Since you're on a frequently changing distro you should do that fairly often. I use rsnapshot with hourly/daily/weekly/monthly snapshots. I've just compared GNC_USERDATA_DIR and GNC_USERCONFIG_DIR with old versions and I don't significant changes to the contents. GnuCash does indeed use Gtk3, but even if you'd installed the dev package for that it wouldn't change anything. It's probably too soon for testing to have upgraded to Gtk 3.24.36 as it was released last Thursday. 3.24.35 was released Nov. 4 so that's probably been on your system for a month. It doesn't have anything to do with preferences anyway except to draw the Preferences dialog. GLib is the Gnome library that provides the preferences, but it's not likely to have updated yesterday either because 2.75.1 released on Wednesday and 2.75.0 released on Nov. 10. I just reinstalled gnucash and gnucash-common, but unsurprisingly, it has changed nothing. I'd be grateful for any other insights. Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
On 24/12/2022 22:26, Frank H. Ellenberger wrote: Under Linux the prefs are stored using dconf: https://wiki.gnucash.org/wiki/Configuration_Locations#GSettings Thanks! dconf was updated on the 17th, but I'd used it daily since then, and when I first had the problems on the 22nd. It's weird - for a concrete example: In Edit/Preferences preferences, the date format is set to ISO, but all the dates since the problem started are US. gsettings list-recursively org.gnucash.general returns amongst other things: date-format 1 Does that mean ISO? Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Settings not respected
Hi Michael, Thanks for the reply. On 24/12/2022 17:57, Michael or Penny Novack wrote: The "what happened" is obvious, no longer accessing the files where this information is stored (note recent discussions about where these are with regard to back-up). You are back to the defaults. I had guessed that, but it doesn't matter what I then change, I still get the defaults. So some part of the settings system is broken. The "what caused it" not so obvious, and on that depends whether you can recover or will have to recreate. I've got back-ups (I hope). You are NOT telling us what happened in between the last use of gnucash (when it was working) and this event of a couple days ago. WHAT did you change on your computer? I'm on Debian testing, so although gnucash itself wasn't upgraded, plenty of others have been in the last couple of days. Python 3.9->3.10 was the only one I could see that was directly used by gnucash. I had also installed the -dev packages for gtk4, but gnucash uses gtk3, doesn't it? Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Settings not respected
Hi all, I am a >10 year (daily) gnucash user, in the last few years on Debian testing. I've not had to change the preferences in years. A couple of days ago, gnucash stopped respecting all settings: * the previous set of accounts was not automatically loaded * the previous set of accounts was not available via "recent". * having loaded the previous set of accounts, the default light/dark green account theme was not used * despite ISO date format being set in Edit/Preferences, the US format was used. How can I debug what caused this? Regards Jeff OpenPGP_signature Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Not exactly a new question. Am I introductory screwing up by entering 0 balances in accounts.
For United States of America respondents, unless you have previous experience with the I.R.S. please do not provide answers. I'm not sure how to to ask this. If you are as I am then don't feel alone. I wish they would just levy a straight tax on everyone, the IRS would finally make a profit and we then could maybe find ways to support our own disabled (like myself who does not qualify, even though I can no longer hold a job in the real world because of a medical condition that is uncontrollable by any medical means available with our "modern" medicine). I'm entering 0 dollars in accounts that I know that there is money flowing though them, I just do not know what the other account would be (mysteries, love them but hate them them come tax time). I have a debits that must go to multiple accounts. Problem is, I will not know which accounts for several weeks ( which may be after 2022 tax time thanks to the IRS, they found an error last year that costed me $6,000). Gotta love government accounting, want your money now, might give some back latter if lucky or take more, and goodness knows what account they decided to return or take it from. Then you have to adjust your books accordingly, which violates our double entry journal system ( it may create accounts or tree accounts that are unneeded but required by the IRS). Should I wait until they decide or just use in-balance usd until they decide. Hopefully before tax time. I've been entering 0 balances in accounts that I know have $ in them and putting the difference in in-balance usd. I know that I am not clear on my question but the please ask (U.S. only), not offend. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 12:14 PM, john wrote:
On Oct 13, 2022, at 11:24 PM, Jeff wrote:
Is there any way, even the slightest, to attach a transaction image
to a daemon instead of a specific file? That way I could use a
database system in the background to hold images instead of the file
system. That way images would still be available to GNC and
searchable for me (never know when a rebate might show up {grin}).
There's https://github.com/MigNov/Fuse-db that uses mysql-connector
(should also work with mariadb's connector) to create a filesystem
interface. There's also a perl module,
https://metacpan.org/pod/Fuse::DBI, that (like GnuCash) uses libdbi
so it's a bit more general; the problem is that it's only mountable
from inside perl so it won't work directly with GnuCash.
Alternatively the link field takes URIs as well as directory paths and
IIRC it can load http: or https: URIs. If you can run a local web
server to serve the URIs you can use PHP to query a supported database
for the desired image.
Regards,
John Ralls
Thank you John, I'll look into it. That might be the only suggestion
for now. I would rather have a program standing next to GNC to look at
images, from any location that GNC can access regardless of location.
--
--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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 7:10 AM, Murugan Muruganandam wrote:
Jeff
this may not be the direct answer, nevertheless i use the cloud
storage for my GNU files and it works like a charm(and economical).
Apart from crashes, it allows me to connect from different computers
and work.
Again not an answer to your question, thought will share.
Saludos Cordiales
Murugan
*From:* gnucash-user
on
behalf of Jeff
*Sent:* Friday, October 14, 2022 3:24 AM
*To:* Gnucash userlist
*Subject:* [GNC] transaction images and failed hard drives
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which just
happened to have images attached to GNC transactions. Bad luck on my
part, they also happened to be my backup drives. Murphy is after all the
patron saint of all physicists. Everything that can go wrong will go
wrong. I am currently adding 2 more backup drives plus a third working
drive (all 6 TB, right now, I expect all of them to be filled with my
next project in the next 2 weeks, although 6 gigs will be devoted
specifically to GNC).
Is there any way, even the slightest, to attach a transaction image to a
daemon instead of a specific file? That way I could use a database
system in the background to hold images instead of the file system.
That way images would still be available to GNC and searchable for me
(never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit boards
(i need battery backup here but right now I cannot afford a large enough
system with voltage spike protection) and my electric company is well
known for feeding large voltage spikes here since I have the best
grounding system for miles and I am the last drop on their power line.
60 volts on the neutral is a common experience. It's a wonder that I
still have at least one computer that works.
--
--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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Appreciate the answer but; I do not trust cloud images. Too many
possible snoopers. Everything you send over the web is public, keyed or
not.
For security reasons I need to keep all data local and not just GNC.
All private data is kept on a system that is not accessible via the web,
no internet period.
--
--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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] transaction images and failed hard drives
On 10/14/22 1:33 AM, Geoff wrote:
I doubt if this has change since last you asked, these are your choices:
https://wiki.gnucash.org/wiki/FAQ#SQL_Database
SQLite claims to be very reliable:
https://www.sqlite.org/hirely.html
An easy solution to dodgy power is a cheap laptop - put a battery
between yourself and the grid.
Good luck
Geoff
=
On 14/10/2022 5:24 pm, Jeff wrote:
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which
just happened to have images attached to GNC transactions. Bad luck
on my part, they also happened to be my backup drives. Murphy is
after all the patron saint of all physicists. Everything that can go
wrong will go wrong. I am currently adding 2 more backup drives plus
a third working drive (all 6 TB, right now, I expect all of them to
be filled with my next project in the next 2 weeks, although 6 gigs
will be devoted specifically to GNC).
Is there any way, even the slightest, to attach a transaction image
to a daemon instead of a specific file? That way I could use a
database system in the background to hold images instead of the file
system. That way images would still be available to GNC and
searchable for me (never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit
boards (i need battery backup here but right now I cannot afford a
large enough system with voltage spike protection) and my electric
company is well known for feeding large voltage spikes here since I
have the best grounding system for miles and I am the last drop on
their power line. 60 volts on the neutral is a common experience.
It's a wonder that I still have at least one computer that works.
Sorry, the SQL interface does not work with my main set of books. 30+
years worth of transactions and the SQL conversion locks up. 6 years no
problem.
Dirty power or not, this system worked without a hitch on a 10kw
generator that was, pardon my language, noisier than hell, spikes, lows
were not uncommon.
Somewhere there is a glitch with GNC and the SQL backend. And I am the
butt of that problem.
--
--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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] transaction images and failed hard drives
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which just
happened to have images attached to GNC transactions. Bad luck on my
part, they also happened to be my backup drives. Murphy is after all the
patron saint of all physicists. Everything that can go wrong will go
wrong. I am currently adding 2 more backup drives plus a third working
drive (all 6 TB, right now, I expect all of them to be filled with my
next project in the next 2 weeks, although 6 gigs will be devoted
specifically to GNC).
Is there any way, even the slightest, to attach a transaction image to a
daemon instead of a specific file? That way I could use a database
system in the background to hold images instead of the file system.
That way images would still be available to GNC and searchable for me
(never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit boards
(i need battery backup here but right now I cannot afford a large enough
system with voltage spike protection) and my electric company is well
known for feeding large voltage spikes here since I have the best
grounding system for miles and I am the last drop on their power line.
60 volts on the neutral is a common experience. It's a wonder that I
still have at least one computer that works.
--
--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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] Upgrade issue on Ubuntu 20.04 LTS and GNC 4.10
Came home to find my Ubuntu server, where GNC and all of my books are, saying there was an upgrade from Ubuntu 20.04 LTS to 22.04.1 LTS. Like an idiot I didn't check it, just clicked do it, it's an LTS upgrade after-all. After several hours it finished. I opened what was GNC 4.10 FlatPak before. It ain't now, is Version: 4.11, Build ID: Flathub 4.11, Finance::Quote: 1.49. Would not have questioned it any further except that the tab selected was the TXF report and it is totally blank. Refresh does not help, tried different from to dates, and basically every option available in the report. Nothing. Options please. -- --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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Description list
Hi Steve, That's a great idea, and one that I wish was there, as it's always those seldom used ones that you can't remember what you typed it as. It may not be possible to generate the list from within GnuCash, but you could always export the register to Excel and remove the duplicate entries to create your own list. Regards, Jeff. On 30/6/22 10:05, Steve Elstad wrote: Thanks for that. Is there a way to produce a list of all those descriptions that I have used before? Autocomplete is great if I am close to spelling the description I want. Otherwise I am just guessing and would like to reuse a previously used description. Steve From: Glenn Fowler Sent: Wednesday, June 29, 2022 4:38 PM To: Steve Elstad Cc: GnuCash users group Subject: Re: [GNC] Description list Hi Steve, Your register *is* your list. Auto-complete just matches previous entries as type. On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote: Hi, is there a way to create a list of all the items I have used in the Description field? The autocompletion works if I remember the description correctly. Would like to see a list for those rarely used ones. In the Transfer field there is a pull down list of accounts. Thanks, Steve ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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. ___ 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] Help
Thanks David, After about 9 years of using GnuCash, I've also found myself now having to write off a couple of non-paying invoices. Thanks for the link, it explains it a bit better, I think I will try it on a test system first, just to make sure I understand the steps correctly. Thanks, Jeff. On 22/6/22 09:20, davidcousen...@gmail.com wrote: Eric, The image you attached did not appear to contain anything. Presumably you raised an invoice when you billed the client which would have created an entry debiting Accounts Receivable and crediting the appropriate income account. To record the bad debt you would create a transaction which credited Accounts Receivable and debited Expense:Bad Debts. This will cancel out the amount credited to Income in the original invoice. I had no difficulty creating such an entry in V4.10 with a test account setup for the business features. There was no limitation on the account selection when I created the transaction in the Accounts Receivable register. The Help manual https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has a description of how to do this using the process payment process which does have a restriction on processing the payment to an expense account. The key is to select an asset account (e.g. cheque account) when creating the transaction in Process payment and then after the transaction is created change the account from the asset account to the Expense:Bad Debt account. It is only the process payment procedure which has a restriction on the type of account you can select for a payment and there is no way that GnuCash could internally differentiate between a payment to an Bad Debts expense account and any other expense account as there isn't a specific account type for bad debts. David Cousens On Tue, 2022-06-21 at 19:43 +, Eric Hammond wrote: I was not paid by a client, and have 'written it off', but how do I book it in GnuCash? Standard business practice is to post it in to an expense account such as 'Bad Debt' or 'Uncollectable'. I have created the account 'Expenses:Bad Debt' but GnuCash does not allow me to select it, apparently only accepting an asset account. Thank you for the help, Eric ___ 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. ___ 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] First post
Hi James, 1. It appears as though you did. 2. The New Customer screen shows an "Email" field near the bottom of the first screen. Is this what you are asking, or do you want the Email address field to appear somewhere else? Cheers, Jeff On 4/6/22 11:15, James Osbourne Holmes wrote: 1. Did I do it correctly? 2. Actual question: is there a way to add a field in customers: email address? James Osbourne Holmes a/k/a *Red Pill Media* Go in a good way. ___ 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] Odd Invoice Total (Rounding Issue Maybe)
Hi List, Updated Comments on bug 612957. It seems this has been around for a while. How are others using GnuCash in Australia with 10% GST (or other locations with Tax Included amounts being the normal way of expressing prices) entering Invoices to get around this issue? Any advice appreciated, as I would like to upgrade to a more current version of GnuCash, but may need to stick with the old version while this issue is around if I can't find a workable solution. Note, I have had the odd Invoice/Bill on the old system where the TAX amount is a cent different from the shops Receipt, but the Invoice/Bill total has always been correct. I guess maybe this is the same rounding issue, just affecting the calculated values rather than the entered values. Thanks, Jeff. On 4/6/22 10:46, Jeff wrote: Thanks Adrien, I will report it with the details. On 4/6/22 00:20, Adrien Monteleone wrote: I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through or wasn't exposed/tested to catch it. Regards, Adrien On 6/3/22 8:49 AM, Jeff wrote: Thanks Adrien, Yes, since posting I have done some more testing, and it does appear to be a rounding issue when using Inclusive Tax. I have also tried the same example in 4.10 Flatpak, and the issue remains the same. I assume that in version 2.6.17 the calculation was made in a different way. I can't see any preferences that may be set differently, that may be able to change the behaviour. It appears that when entering Inclusive Tax amounts, behind the scene it actually calculates the Exclusive amount, then adds those figures together to work out the Invoice Total. Is there any way to get the calculation behaviour back to how it worked in 2.6.17? ___ 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. ___ 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] Odd Invoice Total (Rounding Issue Maybe)
Thanks Adrien, I will report it with the details. On 4/6/22 00:20, Adrien Monteleone wrote: I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through or wasn't exposed/tested to catch it. Regards, Adrien On 6/3/22 8:49 AM, Jeff wrote: Thanks Adrien, Yes, since posting I have done some more testing, and it does appear to be a rounding issue when using Inclusive Tax. I have also tried the same example in 4.10 Flatpak, and the issue remains the same. I assume that in version 2.6.17 the calculation was made in a different way. I can't see any preferences that may be set differently, that may be able to change the behaviour. It appears that when entering Inclusive Tax amounts, behind the scene it actually calculates the Exclusive amount, then adds those figures together to work out the Invoice Total. Is there any way to get the calculation behaviour back to how it worked in 2.6.17? ___ 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] Odd Invoice Total (Rounding Issue Maybe)
Thanks Adrien, Yes, since posting I have done some more testing, and it does appear to be a rounding issue when using Inclusive Tax. I have also tried the same example in 4.10 Flatpak, and the issue remains the same. I assume that in version 2.6.17 the calculation was made in a different way. I can't see any preferences that may be set differently, that may be able to change the behaviour. It appears that when entering Inclusive Tax amounts, behind the scene it actually calculates the Exclusive amount, then adds those figures together to work out the Invoice Total. Is there any way to get the calculation behaviour back to how it worked in 2.6.17? Thanks all, Jeff. On 3/6/22 22:57, Adrien Monteleone wrote: Looks like a rounding issue when using inclusive tax. The latest GnuCash is 4.10. You can get a .deb for it in the Debian Archives (see the wiki) or try the Flatpak to see if the issue still exists. Regards, Adrien On 6/3/22 2:07 AM, Jeff wrote: Hi Group. I am just doing some testing testing with updated versions (to me) of GnuCash. I have been using GnuCash for a while on an older machine, it is running 2.6.17 and it is working perfectly, unfortunately the machine it is on is starting to have issues, so am in the process of migrating to a newer machine, and therefore a newer version of GnuCash (finally). The issue I'm having is on a specific Invoice the TOTAL shown down the bottom is 1 cent out. I could understand it if I was doing % discounts etc, but the invoice is very basic, and the total seems to be correct, until the last entry. Invoice Details: Date Description Action Quantity Unit Price Discount Type Discount How Discount Tax Subtotal Tax Today Item 1 Material 1 $1049.00 % < X $953.64 $95.36 Today Item 2 Material 1 $222.00 % < X $201.82 $20.18 Today Item 3 Material 1 $15.00 % < X $13.64 $1.36 Today Item 4 Material 1 $30.00 % < X $27.27 $2.73 Today Item 5 Material 1 $59.15 % < X $53.77 $5.38 Today Item 6 Project 1 $200.00 % < X $181.82 $18.18 The Discount Type and Discount How, are just the prepopulated values and are not used as there is no Discount amount. The TOTAL at the bottom left of the Invoice entry screen is correct until adding the last entry, where it then shows: $1,575.16 instead of the expected $1,575.15. I have tried adding in the Invoice details to a new Invoice, and using two different versions of GnuCash, both seem to show the same behaviour. Are there any suggestions as to why this may be happening, and how to fix it? It is not very comforting that what appears to be a simple Invoice, with not discounts etc, is added up wrong. If I change the Item 5 entry to $59.14 I correctly get $1,575.14. But once again changing the Item 5 to $59.15 gives a Total of $1,575.16. Tested on OS GnuCash Kubuntu 21.10 3.8, Build ID: 3.8b+(2019-12-29) Finance::Quote: 1.49 Installed via Package Manager Kubuntu 22.04 4.8, Build ID: 4.8a+(2021-09-28) Finance::Quote: 1.51 Installed via Package Manager ___ 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] Odd Invoice Total (Rounding Issue Maybe)
Hi Group. I am just doing some testing testing with updated versions (to me) of GnuCash. I have been using GnuCash for a while on an older machine, it is running 2.6.17 and it is working perfectly, unfortunately the machine it is on is starting to have issues, so am in the process of migrating to a newer machine, and therefore a newer version of GnuCash (finally). The issue I'm having is on a specific Invoice the TOTAL shown down the bottom is 1 cent out. I could understand it if I was doing % discounts etc, but the invoice is very basic, and the total seems to be correct, until the last entry. Invoice Details: Date Description Action Quantity Unit Price Discount Type Discount How Discount Tax Subtotal Tax Today Item 1 Material 1 $1049.00 % < X $953.64 $95.36 Today Item 2 Material 1 $222.00 % < X $201.82 $20.18 Today Item 3 Material 1 $15.00 % < X $13.64 $1.36 Today Item 4 Material 1 $30.00 % < X $27.27 $2.73 Today Item 5 Material 1 $59.15 % < X $53.77 $5.38 Today Item 6 Project 1 $200.00 % < X $181.82 $18.18 The Discount Type and Discount How, are just the prepopulated values and are not used as there is no Discount amount. The TOTAL at the bottom left of the Invoice entry screen is correct until adding the last entry, where it then shows: $1,575.16 instead of the expected $1,575.15. I have tried adding in the Invoice details to a new Invoice, and using two different versions of GnuCash, both seem to show the same behaviour. Are there any suggestions as to why this may be happening, and how to fix it? It is not very comforting that what appears to be a simple Invoice, with not discounts etc, is added up wrong. If I change the Item 5 entry to $59.14 I correctly get $1,575.14. But once again changing the Item 5 to $59.15 gives a Total of $1,575.16. Tested on OS GnuCash Kubuntu 21.10 3.8, Build ID: 3.8b+(2019-12-29) Finance::Quote: 1.49 Installed via Package Manager Kubuntu 22.04 4.8, Build ID: 4.8a+(2021-09-28) Finance::Quote: 1.51 Installed via Package Manager Thanks in advance for any suggestions. Regards, Jeff. ___ 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] FlatPak question
Just a curious, do to too long of a day question [36 hours and counting, ain't cattle farming great during calving season!]. (I have no idea how some professional utility and medical staff can handle 48 hour day shifts frequently, multiple days in a row). As the version numbers increase on GNC, will desktop links to specific sets of books still work as you upgrade via FlatPak or will they need to be edited? Running Ubuntu 20.04LTS right now, and intend to keep the most recent stable version of GNC and Ubuntu LTS up and telling me I screwed up an entry. Without the userlist I never would have got the 4.10 desktop icons to work. -- --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: [GNC] Unusual book need
David, I like your approach the best. Even though the transactions are in a joint account between my son and father, I am legally responsible for my sons activities. And all of the transactions apply to my farm, not Dads. Now for the fun part, I have to find all of them and get them moved. The IRS waits for no one and I am in a serious time crunch. 3 abandoned/orphaned bottle calves and trying to save an abandoned newborn that refuses both bottle and standing up (I definitely do not need a quadriplegic calf right now. I don't even know where to purchase a wheel chair for a calf). Oh, the joys of being a farmer! -- --JEffrey Black M.B.A. On 4/15/22 4:10 PM, davidcousen...@gmail.com wrote: Jeff Another approach you could try would be to create a temporary account in your dad's books and move the transactions that should have gone into your account into it. Should work if all of the transactions have at least one account in common , e.g. an Asset; bank account or similar. if not you may need to create more than one temp account. You could then export the transactions in that temp accountas an OFX or CSV file which you could then import into your own books. If the target accounts are the same in yours and your dad's books they should import but if not edit those that aren't. CSV may be more appropriate if you need to edit the transactions before importing If you then delete the temporary account in your dad's books and choose to discard the transactions in it you should be good. David Cousens On Fri, 2022-04-15 at 04:00 -0500, Jeff wrote: I need to move transactions from from one set of books to another one. I didn't realize while entering transactions in my dads books that they should have gone into mine. My dad opened a bank account that I did not know about until I started entering charges that my son made with feed stores (debit card). I had not been informed about the bank account that grandpa opened in my sons name, and I am responsible for all of his income/debits until he is 21. And many of these transactions affect my income/loss. Is there an easy way to move those entries from one journal to the other or will I have to find all of them and manually delete them from one journal and reenter them in mine? These are separate journal files. ___ 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] Unusual book need
I need to move transactions from from one set of books to another one. I didn't realize while entering transactions in my dads books that they should have gone into mine. My dad opened a bank account that I did not know about until I started entering charges that my son made with feed stores (debit card). I had not been informed about the bank account that grandpa opened in my sons name, and I am responsible for all of his income/debits until he is 21. And many of these transactions affect my income/loss. Is there an easy way to move those entries from one journal to the other or will I have to find all of them and manually delete them from one journal and reenter them in mine? These are separate journal files. -- --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: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved
Geert, don't ask me how I did it because I do not know but the new icon now works. Just for kicks and grins I created a desktop file for LibreOffice Writer and it worked right the first time. So then I edited my desktop icon for GNC and compared it to yours and couldn't see any differences except the path and data file name. Renamed my file and copied yours into a text editor, changed the path and filename accordingly. Saved it and right clicked the allow launching and it worked. Working version (copied and edited from your post): [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac Drive'/Ledgers/Dad/Dad.gnucash Name=GnuCash 4.9 FLATPAK Dad Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico == Non-working version: [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/**'Mac Drive'/Ledgers/Dad/Dad.gnucash Name=GnuCash 4.9 FLATPAK Dad Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico To the naked eye they look identical but one works and the other does not. Both are right clicked to allow launching. The only difference I can see, now that I copied and pasted into this e-mail, is that the text width is different. I don't know if that has something to do with it or not (hidden high bit character that doesn't show up in Text Editor perhaps?). I then created an icon for another set of books (which works) and checked the permissions for both. They are not the same. The copy of yours shows a check mark in the 'Allow executing file as program', the second one has a '-' . My original had a check mark too. Thank you! -- --JEffrey Black M.B.A. On 4/2/22 11:28 AM, Geert Janssens wrote: [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /home/janssege/testfile.gnucash Name=GnuCash 4.9 FLATPAK Dad Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/ share/gnucash/pixmaps/gnucash-icon.ico ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
Step 1 and 2 work. The rest does not work. I still get the no suitable backend error. It has to be a compatibility issue with Flatpak and my computer. -- --JEffrey Black M.B.A. On 3/31/22 8:11 AM, Adrien Monteleone wrote: Ha! Best of luck with the keyboard! Check into (Ubuntu) Settings > Universal Access > Typing > Screen Keyboard. This will pop-up an on-screen keyboard when a typing field has focus. That's not the best workaround, but it will help a bit. - As for GnuCash, what about the USB access info from the Wiki? If you've never gotten the flatpak to work right, I'd suspect that is the issue. So try this in order from a terminal: 1. sudo flatpak override org.gnucash.GnuCash --filesystem=$PATH_TO_USB_DRIVE (that is all one line) 2. flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac Drive'/Ledgers/Dad/Dad.gnucash (again all one line) If that works, close GnuCash and try clicking your desktop shortcut again. You should be good to go. If that doesn't work, try moving a copy of the file to your Home folder, then trying from a terminal: flatpak run org.gnucash.GnuCash /home/jeffrey/Dad.gnucash If that doesn't work either, something else is wrong. Regards, Adrien On 3/31/22 1:46 AM, Jeff wrote: Pardn any unreadable wrds, my cockatu decided my keybard was a ty, and I have yet t find all f the pieces nd mae them all work at th riht time. I am ging after a new kybrad tda Adrein. prir t mving t flatPak installs I never had a prblem with upgrades r installs. Desktp icns dn't seem t be an issue with anything except Flatpak. I'll cmplain but the failure t be able t build frm surce later. But I am begging t suspect the 2 issues are related n my netwrk. ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
Okay, finally got a new keyboard. They make great toys for parrots. I have tried all of the suggestions presented and I can still not make a desktop icon for the GNC Flatpak version to load a specific set of books. I did get one icon to work but I do not trust it, it does not place the GNC icon on the desktop, just a generic CSV, and it also places all log files on the desktop ( I use uncompressed XML). I did not have any issues creating icons prior to using Flatpak. -- --JEffrey Black M.B.A. On 3/31/22 1:46 AM, Jeff wrote: Pardn any unreadable wrds, my cockatu decided my keybard was a ty, and I have yet t find all f the pieces nd mae them all work at th riht time. I am ging after a new kybrad tda Adrein. prir t mving t flatPak installs I never had a prblem with upgrades r installs. Desktp icns dn't seem t be an issue with anything except Flatpak. I'll cmplain but the failure t be able t build frm surce later. But I am begging t suspect the 2 issues are related n my netwrk. ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
Pardn any unreadable wrds, my cockatu decided my keybard was a ty, and I have yet t find all f the pieces nd mae them all work at th riht time. I am ging after a new kybrad tda Adrein. prir t mving t flatPak installs I never had a prblem with upgrades r installs. Desktp icns dn't seem t be an issue with anything except Flatpak. I'll cmplain but the failure t be able t build frm surce later. But I am begging t suspect the 2 issues are related n my netwrk. -- --JEffrey Black M.B.A. On 3/29/22 9:36 PM, Adrien Monteleone wrote: For the icon issue, while Flatpak apps are sandboxed and might not have access to that icon location, have you tried copying it to somewhere in your home folder and seeing if that works? (it is the Desktop file using it, so this would be weird, but I guess worth a shot) https://wiki.gnucash.org/wiki/Flatpak#Desktop_Icon gives the example of making a desktop icon and it specifies a /.local location in your home folder. That page might be assuming you installed the app for one user (you) and not the system. This might be why the icon file is in /var/lib instead of /jeffrey/.local. Though why that matters, I'm stumped. I also find it strange that GnuCash is storing backups on the desktop when it is opening the file from the USB drive. But you can try adding a "Path" to your desktop file to indicate the 'working' directory: path=/media/jeffrey/'Mac Drive'/Ledgers/Dad/Dad.gnucash Did this ever work right before you moved to Flatpak? (that is, accessing the files from USB, saving backups in the right location with the files, etc.) Per my other comment about this being a 20.04 flatpak-related bug, perhaps it has something to do with the mount-point or type of mount-point of the USB. Did you give permission to access the USB drive to flatpak? (as noted in the wiki): sudo flatpak override org.gnucash.GnuCash --filesystem=$PATH_TO_USB_DRIVE Finally, are you 100% certain you don't have GnuCash installed either from a build or .deb? When you double-click a data file to open GnuCash (which you say works) what version is reported? What happens when you run your Exec command from the .desktop file in a terminal? Regards, Adrien On 3/29/22 1:18 AM, Jeff wrote: I have tried all of this. As per your information I did in fact find an icon in: /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico The desktop link gives me an error of "No suitable backend was found for /home/jeffrey/Desktop/Dad.desktop". I am using the XML save, uncompressed. I have a great distrust of compressed data files. My .desktop file is: [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac Drive'/Ledgers/Dad/Dad.gnucash Name=GnuCash 4.9 FLATPAK Dad Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico And in case you are wondering 'Mac Drive' is an external USB drive that I bought on clearance for half price, and I am not using a Mac computer. I just never changed the drive name because I had trouble with the initial install of the drive several years ago, pre-Ubuntu. Turned out that I had a bad USB cable. It works flawlessly if I manually click on Dad.gnucash in the file manager. This does not appear anywhere on my server. /home/jeffrey/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico. Permissions are set to run as executable for the desktop icon. Icon does not show up, just the generic blank icon. If I hit "Okay" I end up with a new, empty, set of books. If I manually open Dad.gnucash from the link it opens the correct set of books but; wants to create scheduled transactions going back to 2019. And I also simply installed GNC as a Flatpak. It also creates backups on the desktop. For the life of me I cannot figure out what is going on. I can create desktop icons for everything except Flatpak programs. I have to have a gremlin in my server, because I cannot even build a working version of GNC from source (after uninstalling GNC). As of right now I only have one user on my server. ___ 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
Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu
I have tried all of this. As per your information I did in fact find an icon in: /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico The desktop link gives me an error of "No suitable backend was found for /home/jeffrey/Desktop/Dad.desktop". I am using the XML save, uncompressed. I have a great distrust of compressed data files. My .desktop file is: [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac Drive'/Ledgers/Dad/Dad.gnucash Name=GnuCash 4.9 FLATPAK Dad Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico And in case you are wondering 'Mac Drive' is an external USB drive that I bought on clearance for half price, and I am not using a Mac computer. I just never changed the drive name because I had trouble with the initial install of the drive several years ago, pre-Ubuntu. Turned out that I had a bad USB cable. It works flawlessly if I manually click on Dad.gnucash in the file manager. This does not appear anywhere on my server. /home/jeffrey/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico. Permissions are set to run as executable for the desktop icon. Icon does not show up, just the generic blank icon. If I hit "Okay" I end up with a new, empty, set of books. If I manually open Dad.gnucash from the link it opens the correct set of books but; wants to create scheduled transactions going back to 2019. And I also simply installed GNC as a Flatpak. It also creates backups on the desktop. For the life of me I cannot figure out what is going on. I can create desktop icons for everything except Flatpak programs. I have to have a gremlin in my server, because I cannot even build a working version of GNC from source (after uninstalling GNC). As of right now I only have one user on my server. -- --JEffrey Black M.B.A. On 3/26/22 6:55 AM, david whiting wrote: Hi Jeff, If you installed gnucash for a single user, then the icon file will be at the path I showed in the previous email (but you'll have to change the login name to yours): /home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico If you installed gnucash as a system application for all users, then you will find the icon file here: /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico For the exec line, you might want to put the full path to the gnucash file, e.g. Exec=flatpak run org.gnucash.GnuCash /home/jeff/Documents/test-2.gnucash So, with a *system* installation and assuming that your login is jeff, then the desktop file might look like this: [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash /home/jeff/Documents/test-2.gnucash Name=GnuCash 4.9 FLATPAK test-2 Comment=Manage home and small business accounts Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico (Note that the lines may be wrapped, if so, you'll need to unwrap them) Remember to right-click on the file on the desktop and choose "Allow launching". David On Sat, 26 Mar 2022 at 08:25, Jeff wrote: I tried this but I cannot locate the actual GNC icon file. I do have one where I attempted, unsuccessfully, to build GNC 4.9 from source. I changed the path to the icon in the build directory. And gave the exec the path to one of my .gnucash files but the desktop link still refuses to work. -- --JEffrey Black M.B.A. On 3/25/22 3:45 AM, david whiting wrote: Hi Jeff, The following works for me, with gnucash installed for a user: 1. Create a desktop file (using a text editor) with the entry shown below 2. On the Exec line, change Documents/test-2.gnucash to the path to your gnucash file 3. On the Name line, change this to whatever you want to call it, i.e. what you want to see on the desktop 4. Change the path for the icon to the correct location (perhaps changing /home/david to /home/jeff) 5. Save the file as whatever-you-want-to-call-it.desktop 6. Go to your desktop 7. Right-click on the file on the desktop and select "Allow launching" (this step is important) 8. Repeat this process for other files, changing the Exec line and Name lines accordingly [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash Documents/test-2.gnucash Name=GnuCash 4.9 FLATPAK test-2 Comment=Manage home and small business accounts Icon=/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico David On Fri, 25 Mar 2022 at 07:38, Jeff wrote: I have never had a problem creating desktop icons for mult
Re: [GNC] change default behavior of ctrl-PgDn - solved
My mistake I suppose. Every program I have ever used uses Ctrl-PgDn to go to the end of the file at the first entry point and Ctrl-PgUp to go to the top of the file at the first entry. GNC seems to have a different hotkey combination for this behavior. I have never ran across another program that uses Shft-PgDn to go to the bottom of the file or Shft-PgUp to go to the first entry. Shft-PgUp and Shft-PgDn are used to select everything from the current caret to top of file or bottom of file for copy/cut in all other programs that I have ever used. A habit that I will have to break when using GNC. I just tested it and in fact Shft-PgDn does take me where I want it to. Thank you for explaining in John Ralls. case closed -- --JEffrey Black M.B.A. My mistake On 3/25/22 1:42 PM, John Ralls wrote: Since when is control-page down the "official key combo"? See https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html#txns-register-oview, section 2.9.2.4 Using Entry Shortcuts: " • To move around the register, use these keys to save time: • Tab to move to the next field, Shift+Tab to move to the previous field • Home to move to the beginning of the field, End to move to the end of the field • Enter or ↓ to move to the next transaction, ↑ to move to the previous transaction • Page Up to move up one screen, Page Down to move down one screen • Shift+Page Up to go to the first transaction, Shift+Page Down to go to the last transaction " Regards, John Ralls On Mar 25, 2022, at 10:37 AM, Adrien Monteleone wrote: Indeed, shift-fn-down_arrow drops me to a blank transaction with the focus on the date field. Thanks! I still think it a bug that the official key combo doesn't work properly. I thought one was filed already but can't seem to find it. Note, it isn't just the key combo not working. Using Action > Blank Transaction also takes you to the first Action Field rather than the date field. So it is the underlying function that doesn't work. Regards, Adrien On 3/25/22 6:25 AM, Michael Hendry wrote: Having not investigated a quick way of getting to a new blank transaction before, Ive done some experimenting on my iMac (GNC 4.9 + Big Sur). fn-uptriangle Top of current register screen fn-downtriangle Bottom of current register screen Shift-fn-uptriangle Earliest transaction in register Shift-fn-downtriangle Bottom of current register, blank transaction If I use the extra cluster of nine keys on the wide keyboard: Shift-uparrow Earliest transaction in register Shift-downarrow Bottom of current register, blank transaction All I have to do now is remember these the next time I need them! ___ 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. ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
I tried this but I cannot locate the actual GNC icon file. I do have one where I attempted, unsuccessfully, to build GNC 4.9 from source. I changed the path to the icon in the build directory. And gave the exec the path to one of my .gnucash files but the desktop link still refuses to work. -- --JEffrey Black M.B.A. On 3/25/22 3:45 AM, david whiting wrote: Hi Jeff, The following works for me, with gnucash installed for a user: 1. Create a desktop file (using a text editor) with the entry shown below 2. On the Exec line, change Documents/test-2.gnucash to the path to your gnucash file 3. On the Name line, change this to whatever you want to call it, i.e. what you want to see on the desktop 4. Change the path for the icon to the correct location (perhaps changing /home/david to /home/jeff) 5. Save the file as whatever-you-want-to-call-it.desktop 6. Go to your desktop 7. Right-click on the file on the desktop and select "Allow launching" (this step is important) 8. Repeat this process for other files, changing the Exec line and Name lines accordingly [Desktop Entry] Type=Application Terminal=false Exec=flatpak run org.gnucash.GnuCash Documents/test-2.gnucash Name=GnuCash 4.9 FLATPAK test-2 Comment=Manage home and small business accounts Icon=/home/david/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico David On Fri, 25 Mar 2022 at 07:38, Jeff wrote: I have never had a problem creating desktop icons for multiple books for GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for GNC 4.9. Everything I have tried for the desktop icon has failed miserably on the Flatpak version of GNC 4.9. Is there someone who can guide me on creating the desktop icons for this version on Ubuntu version 20.04 LTS. I have multiple sets of books to maintain for family members. -- --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. ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
I would like to have individual icons that execute GNC for a specific set of books. IE: icon (GNC parents books) icon (GNC personal books) icon (GNC company books) etc. -- --JEffrey Black M.B.A. On 3/25/22 12:43 PM, Adrien Monteleone wrote: You want an application icon or for the individual data files (books)? The application is a bit of work if it is Flatpak, but I would think the data files should be no issue. Regards, Adrien On 3/25/22 2:38 AM, Jeff wrote: I have never had a problem creating desktop icons for multiple books for GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for GNC 4.9. Everything I have tried for the desktop icon has failed miserably on the Flatpak version of GNC 4.9. Is there someone who can guide me on creating the desktop icons for this version on Ubuntu version 20.04 LTS. I have multiple sets of books to maintain for family members. ___ 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] create desktop icons for GNC 4.9 Flatpak on Ubuntu
I have never had a problem creating desktop icons for multiple books for GNC on Ubuntu 20.04 LTS prior to installing the FlatPak version for GNC 4.9. Everything I have tried for the desktop icon has failed miserably on the Flatpak version of GNC 4.9. Is there someone who can guide me on creating the desktop icons for this version on Ubuntu version 20.04 LTS. I have multiple sets of books to maintain for family members. -- --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: [GNC] change default behavior of ctrl-PgDn
Thank you Adrien. I will report it as a bug. This has happened throughout numerous versions of GNC. It is more of an irritation on my part, as my financial imports do not always match receipts entered. Welcome to the world of Murphy's Law, everything that can go wrong will go wrong (A physicists favorite right of passage). On 3/24/22 8:45 PM, Adrien Monteleone wrote: I don't think the date itself is relevant. What you want is to get to a new blank transaction, correct? I have the same problem using 4.9 on MacOS BigSur. I'm not sure when this started. As far as I know, there is no preference. There is a preference for using the 'Enter' key for this function, but that might not be desirable. I guess try playing with that and see if it works to your liking. But I'd say it is a bug. Regards, Adrien On 3/23/22 6:34 PM, Jeff wrote: I'm talking about entering transactions in prior months, not adding new sequential transactions at the end of the journal. On 3/23/22 4:45 PM, Glenn Fowler wrote: Wouldn't pressing be easier than Ctrl+PgDn? On Wed, Mar 23, 2022 at 5:23 PM Jeff <mailto:beastmaster...@hotmail.com>> wrote: Running: Version: 4.9 Build ID: Flathub 4.9-2 Finance::Quote: 1.49GNC 4.9 on Ubuntu. When I need to enter a new transaction (that I missed) and hit ctrl-PgDn it throws me to the bottom of the register as expected. But the caret is on the third number line down, not in the date column where I would expect it to. Is there a simple fix to change this behavior? I have the default view set for view double line, transactional. -- --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. -- --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: [GNC] change default behavior of ctrl-PgDn
I'm talking about entering transactions in prior months, not adding new sequential transactions at the end of the journal. On 3/23/22 4:45 PM, Glenn Fowler wrote: Wouldn't pressing be easier than Ctrl+PgDn? On Wed, Mar 23, 2022 at 5:23 PM Jeff <mailto:beastmaster...@hotmail.com>> wrote: Running: Version: 4.9 Build ID: Flathub 4.9-2 Finance::Quote: 1.49GNC 4.9 on Ubuntu. When I need to enter a new transaction (that I missed) and hit ctrl-PgDn it throws me to the bottom of the register as expected. But the caret is on the third number line down, not in the date column where I would expect it to. Is there a simple fix to change this behavior? I have the default view set for view double line, transactional. -- --JEffrey Black M.B.A. ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. -- --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.
[GNC] change default behavior of ctrl-PgDn
Running: Version: 4.9 Build ID: Flathub 4.9-2 Finance::Quote: 1.49GNC 4.9 on Ubuntu. When I need to enter a new transaction (that I missed) and hit ctrl-PgDn it throws me to the bottom of the register as expected. But the caret is on the third number line down, not in the date column where I would expect it to. Is there a simple fix to change this behavior? I have the default view set for view double line, transactional. -- --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.
[GNC] regex search
I'll admit right off the bat that I have trouble with regex expressions. I find myself needing to be able to do 2 different searches. 1) find in the Num column if it is empty. Meaning that I or the financial institution forgot to say put a check number or transaction id (or type) in the field. 2) find in the Num column if it contains data. Most of my institutions record a check number, ach etc, but put leading 0' (zeros), or other id information, in the field. I need to search for those and remove the extraneous characters and/or put in the proper type of transaction id. I am at my wits end on figuring out how to do these searches. Would someone please show me the proper search filter to do each of these? -- --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: [GNC] exporting search?
On 2/19/22 10:05 PM, Paul Kinzelman wrote: Thank you. That's what I did, but there wasn't an obvious way to export that account. On 2/19/2022 6:35 PM, D. wrote: Personally, I'd have a separate account for medical expenses, and then a transaction report for that account would quickly give me totals for any given period. *From:* Geoff *Sent:* Sat Feb 19 18:32:43 EST 2022 *To:* p...@kinzelman.com, Gnucash Elist *Subject:* Re: [GNC] exporting search? Hi Paul Your original request said you required a list of expenses. If you only want the totals amount, there is no need to export at all. Just scroll to the bottom of the Account Report, which shows the the total Debits, Credits, and Balance. As to your other useful suggestions, please excuse the editorial. I see that the lead article on your web site is titled "The Importance of Building a Strong Community". The great thing about GnuCash is that it is built, maintained, and supported by a wonderful volunteer open source community. Please feel free to join us. I am sure that someone with your background and experience could make and make a valuable contribution: https://wiki.gnucash.org/wiki/Contributing_to_GnuCash Regards Geoff = On 20/02/2022 10:03 am, Paul Kinzelman wrote: Thank you! I see now how I can do that, but it's not all that convenient to do, seems like it would be something that lots of people would want to do. Copy/paste from HTML seems like not a good way to expect people to do it as well. All I want is a total of the columns of a search, seems like this ought to be a feature built in already. I also looked for this kind of search/export in the documentation and couldn't find it, it'd be nice to say something about that too. I tried things like "export search results" and nothing came up. Even "search results" didn't say much. A section on common things people like to do would be good. On 2/19/2022 3:40 PM, Geoff wrote: Hi Paul From the Search Results tab, choose Reports / Account Report. This opens a new tab with a variant of the Transaction Report showing just the transactions in your Search Results. The Report Options let you tweak which columns are displayed. From there, you can either File / Export / Report, or just select all and copy /paste. The export format is HTML, but it pastes into Microsoft Excel in a usable format. Regards Geoff = On 20/02/2022 6:49 am, Paul Kinzelman wrote: Is there some way to export search results? I was trying to get a list of medical expenses for the past year and I didn't see any easy way to do this, is there a good way to do it? I tried search but I couldn't export it or total the columns. It seems like I should be able to export this list - this is a general question. I tried income expense cash flow for the year, but it gave me just money-in and money-out. I was looking for detail to export to a spread sheet. I finally did File Export Transactions and got what I wanted but it seems like there should be an easier way. Suggestions? Thanks! gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. 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 seehttps://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://
Re: [GNC] How to handle multiple entries of multiply reconciled entries
On 2/3/22 10:07 AM, Alan A Holmes wrote: Hi Jeff, Did you take a copy of the database before you upgraded to version 4.9. If so you could take a copy of this backup and open that in version 4.9, which might tell you if the corruption existed before upgrading to version 4.9. Do you have anyway of finding out which version you had before version 4.9? Was it another flatpack version, or was it the version as part of Ubuntu 20.04 LTS? That version might still be available on your machine, or you could re-install that version, which would allow you to look at any backup copy before upgrading to version 4.9 in that version to see if the corruption existed. You could also look at any/all backup copy taken automatically by version 4.9 to see if the corruption exists. This depends on how many days of backups/logs you have specified should be kept in the settings. This might show when the corruption first started. If you can find a backup copy that isn't corrupted then you could start with that copy and then either manually enter all transactions since then, or use the log files created since then to re-apply a subset of transactions (I think I remember a thread somewhere that said you can be selective in which transactions to re-apply). Alan A Holmes -Original Message- From: gnucash-user On Behalf Of Jeff Sent: 03 February 2022 07:43 To: Gnucash userlist Subject: [GNC] How to handle multiple entries of multiply reconciled entries How I did this is beyond me, somehow I confused GNC to let it happen or had a data corruption when the journal was improperly saved (power outage, GNC lost a poker game, thought it was Quirken, etc). I use uncompressed XML on Ubuntu 20.04LTS. I have discovered multiple (dozens) of transactions that are duplicates in several registers but; reconciled to the wrong accounts. I am not sure of the easiest and proper way to correct them. Example of the simplest ones are: using Check 101, Cash, salary. 01/01/10 chk 101 -> Cash -> chk 101 reconciled 01/01/10 chk 101 -> salary -> salary reconciled These are posted as 2 entirely separate transactions, in the same register, but are supposed to be only one transaction: 01/01/10 chk 101 -> salary -> both reconciled As a result my current balance is now off by off by over $4,000. And the real kicker, is that these errors now go back 3 years in this journal. I know these errors did not exist prior to FlatPak 4.9, not sure which version I upgraded from to 4.9. Plus they would have shown up when I did reports for taxes and income expense statements last year. Suggestions, besides burning more midnight oil than this old man has left, other than to delete all of them and enter all of them correctly as I find them. I'm in tax time crunch here. -- --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. . I always make a backup before doing an upgrade, unfortunately I deleted it some time after upgrading as I believed that everything was working as it should. I do not remember what version I used prior to FlatPak 4.9. I want to say 4.2 but I'd be lying if I said I knew that for sure. As for the log copies I only keep 7 days worth and I have the bad habit of running GNC multiple times on any given day. I could try loading the oldest one and see if the problem is still there. It may be that I got the backups mixed up while trying to build 4.9 from source. I have yet to successfully create a version that runs. -- --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.
[GNC] How to handle multiple entries of multiply reconciled entries
How I did this is beyond me, somehow I confused GNC to let it happen or had a data corruption when the journal was improperly saved (power outage, GNC lost a poker game, thought it was Quirken, etc). I use uncompressed XML on Ubuntu 20.04LTS. I have discovered multiple (dozens) of transactions that are duplicates in several registers but; reconciled to the wrong accounts. I am not sure of the easiest and proper way to correct them. Example of the simplest ones are: using Check 101, Cash, salary. 01/01/10 chk 101 -> Cash -> chk 101 reconciled 01/01/10 chk 101 -> salary -> salary reconciled These are posted as 2 entirely separate transactions, in the same register, but are supposed to be only one transaction: 01/01/10 chk 101 -> salary -> both reconciled As a result my current balance is now off by off by over $4,000. And the real kicker, is that these errors now go back 3 years in this journal. I know these errors did not exist prior to FlatPak 4.9, not sure which version I upgraded from to 4.9. Plus they would have shown up when I did reports for taxes and income expense statements last year. Suggestions, besides burning more midnight oil than this old man has left, other than to delete all of them and enter all of them correctly as I find them. I'm in tax time crunch here. -- --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.
[GNC] GNC used side by side with GNC Andriod
I know that they are entirely separate and discrete applications. So no lambasting please. I have successfully imported more qif files than I care to count from Android to GNC up until I "upgraded" my cell phone. Great cooperation between you and the developers of the Android version. Pat on many backs of both development teams. Now I am getting an error of invalid stock entries on import into GNC, when there are no stock entries on the Android side ( I have looked at the qif file and there are no stock exchanges, nor do I own or sell sell stocks yet). Only day to day cash, bank, or credit card transactions. I'll be flipped if I can find a stock entry in the Android qif files. Has anyone else encountered this or a similar issue? -- --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: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/9/22 2:56 AM, davidcousen...@gmail.com wrote: On Sun, 2022-01-09 at 01:56 -0600, Jeff wrote: On 1/8/22 4:24 PM, davidcousen...@gmail.com wrote: On Sat, 2022-01-08 at 02:44 -0600, Jeff wrote: On 1/8/22 1:42 AM, david whiting wrote: On Sat, 8 Jan 2022 at 07:33, Jeff wrote: [...] Not sure if any of this is related or not to unsuccessful builds. Side note: your shell runs and completes but; now I'll be flipped if I can find where it puts the executable now. Directory /opt is empty. If it built and you used the defaults in the script, then it will be in ~/Documents/gnucash/build/bin. Change to that directory and try running it from there: cd ~/Documents/gnucash/build/bin ./gnucash If that works, but it isn't in /opt/ then change to the build directory and run make install: cd ~/Documents/gnucash/build/ sudo make install David No joy. Your first option gives me a list of errors longer than my leg before crashing. The second ends with: CMake Error at cmake_install.cmake:41 (file): file INSTALL cannot set permissions on "/opt/gnucash/share/doc/gnucash/AUTHORS": Operation not permitted. If I run it (in opt), then I get a whole list of errors before it decides to run version 4.8, not 4.9. And automatically opens a set of books that I have not updated for several months, and I am damn sure not going to let it touch it with all of the errors it is generating. Jeff You don't run the shell script in /opt. That is a root directory and you would need root privileges to be able to run it. David Whiting's shell script should be run in your home user directory. It will create the directories it needs. I can no longer find David Whiting's script in the Wiki. It was attached to a section that dealt with distribution specific issues which now appears to be unlinked from the main build on linux page. I can't locate it anywhere. A wiki can be a pain if there are no backlinks. OK I found it https://wiki.gnucash.org/wiki/Building_On_Ubuntu and will link it back into the main wiki page. I haven't done a major re- edit on the Building on Linux page for a couple of years. I find it works best when I have installed a new OS version from scratch and not used the upgrade procedures as my system is not bare bones any more. Somewhere I am making a beginners mistake. It cannot be this hard to make a working version. Especially with all of the guidance you all have provided me. It can be hard to diagnose remotely. The best way to generate output is to redirect the command output to a text file and attach that to your posts. Unfortunately that does not include the command you entered in the text file. You can copy and paste that from the terminal into the top of outputtext file with the text editor (xed on Linux but I think gedit on Ubuntu) e.g. ./build_GnuCash.sh > GC_Build_OP.txt. At this time I think it would be wise for me to remove every GNC file I can find and start over. But it is beginning to look like a clean start means waiting until tax season is over. The IRS and the state department of revenue wait for no one without penalties. If you do this, this will help https://wiki.gnucash.org/wiki/Uninstall_Gnucash_Linux One way or another I am going to build a working version from source. I love programming, and chasing down gremlins to much. Who knows, once I get the chance I might even offer some code of my own. The QIF import needs a little tweaking for the novice, it doesn't differentiate debits from credits on import, makes it a problem on import. The QIF import code is AFAIK fairly old legacy code. It may benefit from a bit better documentation rather than changes to the code per se ___ 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. . Sorry, I built it from Home/Documents/GNC_build, I can move it to /Home and see if anything changes. If not then I will make a post with the echoed output. If possible I would like to move the build to a larger platter drive, my ssd drive is filling up faster than I expected. That location should be OK. David Whitings script will create subdirectories to load the sources into and build it so there should be a $HOME\Documments\gnucash\source directory and a $HOME\Documments\gnucash\build directory created by the script where $HOME translates to /home/ on your system I however; cannot find a new PPA or solution to, when doing sudo apt-get update : Err:1 http://Community-maintained free InRelease Temporary failure resolving 'Community-maintained' -snip W: Failed to fetch http://Commun
Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/9/22 2:28 AM, david whiting wrote: On Sun, 9 Jan 2022 at 07:57, Jeff wrote: [...] I however; cannot find a new PPA or solution to, when doing sudo apt-get update : Err:1 http://Community-maintained free InRelease Temporary failure resolving 'Community-maintained' -snip W: Failed to fetch http://Community-maintained/dists/free/InRelease Temporary failure resolving 'Community-maintained' W: Some index files failed to download. They have been ignored, or old ones used instead. That URL can't be right. It suggests that you have added something to your list of apt sources incorrectly in the past. Please can you post the *full* output when you run the following in the terminal. This should show where that incorrect entry is: sudo grep -rE ^deb /etc/apt/sources.list* David . As per your request David see the attached txt file. -- --JEffrey Black M.B.A. /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal main restricted /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal-updates main restricted /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal universe /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal-updates universe /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal multiverse /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal-updates multiverse /etc/apt/sources.list:deb http://us.archive.ubuntu.com/ubuntu/ focal-backports main restricted universe multiverse /etc/apt/sources.list:deb http://archive.canonical.com/ubuntu focal partner /etc/apt/sources.list:deb-src http://archive.canonical.com/ubuntu focal partner /etc/apt/sources.list:deb http://security.ubuntu.com/ubuntu focal-security main restricted /etc/apt/sources.list:deb http://security.ubuntu.com/ubuntu focal-security universe /etc/apt/sources.list:deb http://security.ubuntu.com/ubuntu focal-security multiverse /etc/apt/sources.list:deb http://Community-maintained free and open-source software (Universe) /etc/apt/sources.list:deb-src http://Community-maintained free and open-source software (Universe) /etc/apt/sources.list.d/phoerious-ubuntu-keepassxc-focal.list.save:deb http://ppa.launchpad.net/phoerious/keepassxc/ubuntu focal main /etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-focal.list.save:deb http://ppa.launchpad.net/thierry-f/fork-michael-gruz/ubuntu focal main /etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-focal.list.save:deb-src http://ppa.launchpad.net/thierry-f/fork-michael-gruz/ubuntu focal main /etc/apt/sources.list.d/mozillacorp-ubuntu-mozillavpn-focal.list:deb http://ppa.launchpad.net/mozillacorp/mozillavpn/ubuntu focal main /etc/apt/sources.list.d/mozillacorp-ubuntu-mozillavpn-focal.list.save:deb http://ppa.launchpad.net/mozillacorp/mozillavpn/ubuntu focal main /etc/apt/sources.list.d/micahflee-ubuntu-ppa-focal.list.save:deb http://ppa.launchpad.net/micahflee/ppa/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash-focal.list:deb http://ppa.launchpad.net/sicklylife/gnucash/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash-focal.list:deb-src http://ppa.launchpad.net/sicklylife/gnucash/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash4_2-focal.list:deb http://ppa.launchpad.net/sicklylife/gnucash4.2/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash4_2-focal.list:deb-src http://ppa.launchpad.net/sicklylife/gnucash4.2/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash4_2-focal.list.save:deb http://ppa.launchpad.net/sicklylife/gnucash4.2/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash4_2-focal.list.save:deb-src http://ppa.launchpad.net/sicklylife/gnucash4.2/ubuntu focal main /etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-focal.list:deb http://ppa.launchpad.net/thierry-f/fork-michael-gruz/ubuntu focal main /etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-focal.list:deb-src http://ppa.launchpad.net/thierry-f/fork-michael-gruz/ubuntu focal main /etc/apt/sources.list.d/phoerious-ubuntu-keepassxc-focal.list:deb http://ppa.launchpad.net/phoerious/keepassxc/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash-focal.list.save:deb http://ppa.launchpad.net/sicklylife/gnucash/ubuntu focal main /etc/apt/sources.list.d/sicklylife-ubuntu-gnucash-focal.list.save:deb-src http://ppa.launchpad.net/sicklylife/gnucash/ubuntu focal main /etc/apt/sources.list.d/micahflee-ubuntu-ppa-focal.list:deb http://ppa.launchpad.net/micahflee/ppa/ubuntu focal main /etc/apt/sources.list.save:deb http://us.archive.ubuntu.com/ubuntu/ focal main restricted /etc/apt/sources.list.save:deb http://us.archive.ubuntu.com/ubuntu/ focal-updates main restricted /etc/apt/sources.list.save:deb http://us.archive.ubuntu.com/ubuntu/ focal universe /etc/apt/sources.list.save:deb http://us.archive.ubuntu.com/ubuntu/ focal-
Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/8/22 4:24 PM, davidcousen...@gmail.com wrote: On Sat, 2022-01-08 at 02:44 -0600, Jeff wrote: On 1/8/22 1:42 AM, david whiting wrote: On Sat, 8 Jan 2022 at 07:33, Jeff wrote: [...] Not sure if any of this is related or not to unsuccessful builds. Side note: your shell runs and completes but; now I'll be flipped if I can find where it puts the executable now. Directory /opt is empty. If it built and you used the defaults in the script, then it will be in ~/Documents/gnucash/build/bin. Change to that directory and try running it from there: cd ~/Documents/gnucash/build/bin ./gnucash If that works, but it isn't in /opt/ then change to the build directory and run make install: cd ~/Documents/gnucash/build/ sudo make install David No joy. Your first option gives me a list of errors longer than my leg before crashing. The second ends with: CMake Error at cmake_install.cmake:41 (file): file INSTALL cannot set permissions on "/opt/gnucash/share/doc/gnucash/AUTHORS": Operation not permitted. If I run it (in opt), then I get a whole list of errors before it decides to run version 4.8, not 4.9. And automatically opens a set of books that I have not updated for several months, and I am damn sure not going to let it touch it with all of the errors it is generating. Jeff You don't run the shell script in /opt. That is a root directory and you would need root privileges to be able to run it. David Whiting's shell script should be run in your home user directory. It will create the directories it needs. I can no longer find David Whiting's script in the Wiki. It was attached to a section that dealt with distribution specific issues which now appears to be unlinked from the main build on linux page. I can't locate it anywhere. A wiki can be a pain if there are no backlinks. OK I found it https://wiki.gnucash.org/wiki/Building_On_Ubuntu and will link it back into the main wiki page. I haven't done a major re- edit on the Building on Linux page for a couple of years. I find it works best when I have installed a new OS version from scratch and not used the upgrade procedures as my system is not bare bones any more. Somewhere I am making a beginners mistake. It cannot be this hard to make a working version. Especially with all of the guidance you all have provided me. It can be hard to diagnose remotely. The best way to generate output is to redirect the command output to a text file and attach that to your posts. Unfortunately that does not include the command you entered in the text file. You can copy and paste that from the terminal into the top of outputtext file with the text editor (xed on Linux but I think gedit on Ubuntu) e.g. ./build_GnuCash.sh > GC_Build_OP.txt. At this time I think it would be wise for me to remove every GNC file I can find and start over. But it is beginning to look like a clean start means waiting until tax season is over. The IRS and the state department of revenue wait for no one without penalties. If you do this, this will help https://wiki.gnucash.org/wiki/Uninstall_Gnucash_Linux One way or another I am going to build a working version from source. I love programming, and chasing down gremlins to much. Who knows, once I get the chance I might even offer some code of my own. The QIF import needs a little tweaking for the novice, it doesn't differentiate debits from credits on import, makes it a problem on import. The QIF import code is AFAIK fairly old legacy code. It may benefit from a bit better documentation rather than changes to the code per se ___ 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. . Sorry, I built it from Home/Documents/GNC_build, I can move it to /Home and see if anything changes. If not then I will make a post with the echoed output. If possible I would like to move the build to a larger platter drive, my ssd drive is filling up faster than I expected. I however; cannot find a new PPA or solution to, when doing sudo apt-get update : Err:1 http://Community-maintained free InRelease Temporary failure resolving 'Community-maintained' -snip W: Failed to fetch http://Community-maintained/dists/free/InRelease Temporary failure resolving 'Community-maintained' W: Some index files failed to download. They have been ignored, or old ones used instead. As far as QIF being an old format, it is still better and more flexible than the OFX variants. But I am not here right now to argue for better QIF support. I just want to figure out how to
Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/8/22 1:42 AM, david whiting wrote: On Sat, 8 Jan 2022 at 07:33, Jeff wrote: [...] Not sure if any of this is related or not to unsuccessful builds. Side note: your shell runs and completes but; now I'll be flipped if I can find where it puts the executable now. Directory /opt is empty. If it built and you used the defaults in the script, then it will be in ~/Documents/gnucash/build/bin. Change to that directory and try running it from there: cd ~/Documents/gnucash/build/bin ./gnucash If that works, but it isn't in /opt/ then change to the build directory and run make install: cd ~/Documents/gnucash/build/ sudo make install David No joy. Your first option gives me a list of errors longer than my leg before crashing. The second ends with: CMake Error at cmake_install.cmake:41 (file): file INSTALL cannot set permissions on "/opt/gnucash/share/doc/gnucash/AUTHORS": Operation not permitted. If I run it (in opt), then I get a whole list of errors before it decides to run version 4.8, not 4.9. And automatically opens a set of books that I have not updated for several months, and I am damn sure not going to let it touch it with all of the errors it is generating. Somewhere I am making a beginners mistake. It cannot be this hard to make a working version. Especially with all of the guidance you all have provided me. At this time I think it would be wise for me to remove every GNC file I can find and start over. But it is beginning to look like a clean start means waiting until tax season is over. The IRS and the state department of revenue wait for no one without penalties. One way or another I am going to build a working version from source. I love programming, and chasing down gremlins to much. Who knows, once I get the chance I might even offer some code of my own. The QIF import needs a little tweaking for the novice, it doesn't differentiate debits from credits on import, makes it a problem on import. -- --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: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/4/22 5:38 AM, davidcousen...@gmail.com wrote: Jeff, If you are having difficulty Jeff you will have to tell us exactly what you have done and which commands you have entered into the terminal and exactly what the terminal output is to each command. We are not mind readers and we are not on your system so unless you tell us we do not know what is happening, we don't know. We need information to diagnose problems. Even worse a lot of us will not be on Ubuntu but on other Linux distributions. There are sometimes subtle and sometimes not so subtle differences to Ubuntu. The build instructions do assume some general familiarity with building software on Linux and Linux terminal operation. If you go to your Ubuntu menu, you should find a heading called something like Administration and it will have an entry with a name like Software Sources. If you click on that you will get a dialogue up. It should have a tab on the LH side with a name like Official Repositories and if you click on that there should be an entry Optional Sources. If there is a switch, checkbox or other control labelled "Software code repositories" or similar make sure it is selected/checked etc. I have found for example that the apt -y switch does not work on Linux Mint. I am not sure about Ubuntu as Linux Mint uses a modified apt command. David Whiting's script was for Ubuntu 20.04 so it should have worked to install the dependencies. One thing you will have to do is find the script file in the file manager and check that it is marked for execution. If not the script won't run. You may have to alter the file manager options to display the file permissions. They should be "-rwxrwxr-x". The "x" in the last position has to be present. If not, if you open a terminal in the directory containing the copy of the script file, then the command chmod +x
Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 1/4/22 5:38 AM, davidcousen...@gmail.com wrote: Jeff, If you are having difficulty Jeff you will have to tell us exactly what you have done and which commands you have entered into the terminal and exactly what the terminal output is to each command. We are not mind readers and we are not on your system so unless you tell us we do not know what is happening, we don't know. We need information to diagnose problems. Even worse a lot of us will not be on Ubuntu but on other Linux distributions. There are sometimes subtle and sometimes not so subtle differences to Ubuntu. The build instructions do assume some general familiarity with building software on Linux and Linux terminal operation. If you go to your Ubuntu menu, you should find a heading called something like Administration and it will have an entry with a name like Software Sources. If you click on that you will get a dialogue up. It should have a tab on the LH side with a name like Official Repositories and if you click on that there should be an entry Optional Sources. If there is a switch, checkbox or other control labelled "Software code repositories" or similar make sure it is selected/checked etc. I have found for example that the apt -y switch does not work on Linux Mint. I am not sure about Ubuntu as Linux Mint uses a modified apt command. David Whiting's script was for Ubuntu 20.04 so it should have worked to install the dependencies. One thing you will have to do is find the script file in the file manager and check that it is marked for execution. If not the script won't run. You may have to alter the file manager options to display the file permissions. They should be "-rwxrwxr-x". The "x" in the last position has to be present. If not, if you open a terminal in the directory containing the copy of the script file, then the command chmod +x
[GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS
On 12/24/21 8:30 AM, david whiting wrote: On Fri, 24 Dec 2021 at 09:11, Jeff wrote: [...] But it appears I am not even a day old computer programmer, after 40 plus years of coding. For the life of me I cannot get the 4.9 code and tools for Ubuntu to install. I've followed every link I can find, even those that David Cousins provided and I still cannot get the source or dependencies to install or download. Would someone please list for me in baby steps howto download and build GNC 4.9 for Ubuntu? Hi Jeff, The script below will build version 4.9 on Ubuntu 20.04 LTS. I have verified this on a clean installation of Ubuntu. One thing that tripped me up a few times is remembering to tick "Source Code" in the Software And Updates dialogue. If you don't do this, it will fail. Please note that I have used -y with apt install so it will install and build without asking. I will try to get around to putting this in the wiki to make it easier for people to find. === build.sh === ## Ubuntu 20.04 ## In "Software and Updates": ## Tick "Source code" ## Tick "Community-maintained free and open-source software (Universe)" ## Change this if you want to build it somewhere else. SOURCEDIR="$HOME/Documents/gnucash/source" BUILDDIR="$HOME/Documents/gnucash/build" ## Change this if you want to install it somewhere else. INSTALLDIR=/opt/gnucash sudo apt -y update sudo apt -y upgrade sudo apt -y install git sudo apt -y build-dep gnucash ## To build series 4 of gnucash on Ubuntu 20.04 sudo apt -y install libboost-program-options1.71-dev mkdir -p $SOURCEDIR mkdir -p $BUILDDIR ## Clone gnucash source from git git clone https://github.com/Gnucash/gnucash.git $SOURCEDIR ## Checkout version 4.9 cd $SOURCEDIR git checkout -b 4.9 4.9 cd $BUILDDIR cmake -DCMAKE_INSTALL_PREFIX=$INSTALLDIR $SOURCEDIR make === End of build.sh === Fingers-crossed this will work for you. David I executed the above script but it did not build an executable version of GNC. Correction, it built an executable program, that immediately started spouting error messages then even faster closed its terminal window. A couple of posts remind to remember to "tick Source Code in the Software And Updates dialogue" or the script would not work. They fail to mention for what PPA. What PPA's do I need for GNC? (on Ubuntu 20.04LTS) The desktop icon file was also a complete gremlin. That issue may resolve itself once I can successfully build a live, healthy, vivacious, running version of 4.9 from source. As of now I am renaming the thread from "how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04LTS" to "Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS" as we have moved way past removing 4.2 and Flathub 4.8. Right now I feel like a CSC 101 student in a CSC 401 class, even though I went to CSC 640 in college and 880 in the real world, yet I cannot successfully build GNC. Both irritating and humiliating. Somewhere I am overlooking that one simple first year programmers error. -- --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: [GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
On 12/26/21 1:32 PM, Stephen M. Butler wrote: On 12/24/21 11:58, davidcousen...@gmail.com wrote: Stephen, Jeff Try $apt-cache search libboost Found these: libboost-program-options-dev - program options library for C++ (default version) libboost-program-options1.74-dev - program options library for C++ libboost-program-options1.74.0 - program options library for C++ Mine shows: libboost-program-options1.67-dev - program options library for C++ libboost-program-options1.67.0 - program options library for C++ There is no libboost-program-options-dev - program options library for C++ (default version) listed. It does however show to be installed in Synaptic Pkg Manager. This will list the libboost options available to install from apt. If libboost- program-options1.71-dev is not listed it is possible that there will be a generic version libboost-program-options-dev or libboost-program-options1.67- dev or possibly even a more recent version if one exists. AFAIK the libboost- program-options-dev will load the most recent available version of the library. GC will work with v1.67 or 1,71 of libboost. Once you have identified a candidate for libboost to install use $sudo apt -y install libboost-program-options-dev So did: sudo apt -y install libboost-program-options-dev and got: Reading package lists... Done Building dependency tree... Done Reading state information... Done libboost-program-options-dev is already the newest version (1.74.0.3ubuntu6). libboost-program-options-dev set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 21.10 must have the 1.74 version. --Steve When I did sudo apt -y install libboost-program-options-dev, I got: Reading package lists... Done Building dependency tree Reading state information... Done libboost-program-options-dev is already the newest version (1.71.0.0ubuntu2). libboost-program-options-dev set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded. I am running Ubuntu 20.04.3 LTS., 64-bit, Gnome version 3.36.8, with windowing system X11. If any of that is important. After spending 4 hours looking for and installing dependencies the following message seems to be a recurring theme in various forms in CMakeError.log. Always referring to pthreads or threads. -Begin quote- Determining if the function pthread_create exists in the pthreads failed with the following output: Change Dir: /Development/Documents/gnucash/build/CMakeFiles/CMakeTmp Run Build Command(s):/usr/bin/make cmTC_0899f/fast && /usr/bin/make -f CMakeFiles/cmTC_0899f.dir/build.make CMakeFiles/cmTC_0899f.dir/build make[1]: Entering directory '/Development/Documents/gnucash/build/CMakeFiles/CMakeTmp' Building C object CMakeFiles/cmTC_0899f.dir/CheckFunctionExists.c.o /usr/bin/cc -DCHECK_FUNCTION_EXISTS=pthread_create -o CMakeFiles/cmTC_0899f.dir/CheckFunctionExists.c.o -c /usr/share/cmake-3.16/Modules/CheckFunctionExists.c Linking C executable cmTC_0899f /usr/bin/cmake -E cmake_link_script CMakeFiles/cmTC_0899f.dir/link.txt --verbose=1 /usr/bin/cc -DCHECK_FUNCTION_EXISTS=pthread_create CMakeFiles/cmTC_0899f.dir/CheckFunctionExists.c.o -o cmTC_0899f -lpthreads /usr/bin/ld: cannot find -lpthreads collect2: error: ld returned 1 exit status make[1]: *** [CMakeFiles/cmTC_0899f.dir/build.make:87: cmTC_0899f] Error 1 make[1]: Leaving directory '/Development/Documents/gnucash/build/CMakeFiles/CMakeTmp' make: *** [Makefile:121: cmTC_0899f/fast] Error 2 --End quote Any idea what dependency I failed to install? -- --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: [GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
On 12/20/21 6:31 AM, davidcousen...@gmail.com wrote: Jeff, Just built GC4.9 on Linux Mint 20.2 (Ubuntu 20.04 based) with no problems. Give it a go and come back to the forum with the terminal output if there are any problems. You can select any terminal output and cut and paste it into a text file then attache the text file to the post to avoid putting it directly in the post. David Cousens On Mon, 2021-12-20 at 02:12 -0600, Jeff wrote: I currently have GNC Version 4.2 installed on Ubuntu 20.04 LTS. At the recommendation of a former post for info I also have 4.8 from flat-hub somewhere on my system (have yet to find out where or how to remove it). 4.2 is is in the launch bar and has desktop icons to multiple sets of books. The only way I have found to run 4.8 is in software manager and have to change books manually (which 4.8 also had the nasty habit of creating backup files on the desktop for some reason). 1) How do I uninstall both versions? 2) how do I install 4.9 (preferably without Flathub)? I also need desktop icons to launch GNC from the desktop for multiple sets of books (lucky me, I am the accountant/tax man for the entire family! I won't even go into what condition I receive financial records in). I am not opposed to building from source code but; all of my tries have so far failed miserably on GNC. It's a simple mater under Windoze but so far nothing I have tried works on Ubuntu. And yes, I need the desktop icons for each set of books as the icons are linked to each individuals books across multiple drives on remote servers not just mine. My memory has had to many read/write cycles to keep track of who is on which server drive and file name. ___ 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. . Okay, I am missing something simple here and I cannot figure it out. I've followed every post and document I can find using duck-duck go to find to howto build GNC 4.9. I successfully uninstalled 4.2 sickly life and 4.8 flathub. But it appears I am not even a day old computer programmer, after 40 plus years of coding. For the life of me I cannot get the 4.9 code and tools for Ubuntu to install. I've followed every link I can find, even those that David Cousins provided and I still cannot get the source or dependencies to install or download. Would someone please list for me in baby steps howto download and build GNC 4.9 for Ubuntu? -- --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: [GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
On 12/20/21 3:16 AM, davidcousen...@gmail.com wrote: Jeff, You may find this page helpful to unistall the flatpak version. https://www.systutorials.com/docs/linux/man/1-flatpak-uninstall/ How did you install GC 4.2. If you built it from source and still have the source and build directories it was installed from theneither $sudo ninja uninstall or $sudo make uninstall run in the build directory in a terminal should uninstall it. If you installed 4.2 from the sickly life ppa you should be able to remove it with $sudo apt remove --auto-remove gnucash If not it will be a manual uninstall as per the instructions here https://code.gnucash.org/wiki/Uninstall_Gnucash_Ubuntu. You need to be fairly careful uninstalling manually it is the method of last resort. Don't delete your desktop icons/shortcuts. You may need to edit them and change the path to the gnucash executable depending on how and where you install it but you should be able to change the path to the gnucash executable and leave the rest of the instruction for the file to open unchanged, Possibly the only way to get 4.9 installed is to build it from source or to use flathub. https://wiki.gnucash.org/wiki/Building_On_Linux The main problem is ensuring all the dependencies and header files for them are installed. https://wiki.gnucash.org/wiki/Installing_Dependencies sometimes you will find the library has a slightly different name and occasionally there will be a library which is assumed to be installed by default which may be missing. $apt-cache search is a command which can be used to locate the specific library names and what is available on your OS version can be a substring of the library name which identifies it eg "swig" will lsit the swig2.0 and swig3.0 library if available. You can generally use the most recent versions of most libraries unless the use of a specific version is identified in the README.dependencies file in the downloaded source files. (I haven't updated the dependency list since V3 so substitute the version number listed in the README.dependencies file if it is different. I used to do that after I upgraded to a new Linux MInt version but their version upgrade is now so good I have never had to completely reinstall the OS since Linux Mint 19.1 so I have never had to reinstall all the dpendencies When you run the cmake command in the build directoryit will generally stop with an error message if a dependency is missing. The easiest procedure is to load the depnendency that was missing and then rerun the cmake command until it completes without error. Once that is done youcan run the build commands and the install commands. Once you get it built successfully for the first time it is usually a piece of cake to build and install subsequent Gnucash version Keep the source directory and the buidl directory as the uninstalling them is easiest by running $sudo ninja uninstall in the build directory. David Cousens On Mon, 2021-12-20 at 02:12 -0600, Jeff wrote: I currently have GNC Version 4.2 installed on Ubuntu 20.04 LTS. At the recommendation of a former post for info I also have 4.8 from flat-hub somewhere on my system (have yet to find out where or how to remove it). 4.2 is is in the launch bar and has desktop icons to multiple sets of books. The only way I have found to run 4.8 is in software manager and have to change books manually (which 4.8 also had the nasty habit of creating backup files on the desktop for some reason). 1) How do I uninstall both versions? 2) how do I install 4.9 (preferably without Flathub)? I also need desktop icons to launch GNC from the desktop for multiple sets of books (lucky me, I am the accountant/tax man for the entire family! I won't even go into what condition I receive financial records in). I am not opposed to building from source code but; all of my tries have so far failed miserably on GNC. It's a simple mater under Windoze but so far nothing I have tried works on Ubuntu. And yes, I need the desktop icons for each set of books as the icons are linked to each individuals books across multiple drives on remote servers not just mine. My memory has had to many read/write cycles to keep track of who is on which server drive and file name. ___ 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. . Near as I remember I installed 4.2 via sickly life ppa as that was the only way I could. 4.8 was via Flathub. Per your recommendations I am going to try to uninstall both versions, if I can. As far as building from source, I found the documentation links to be
[GNC] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts
I currently have GNC Version 4.2 installed on Ubuntu 20.04 LTS. At the recommendation of a former post for info I also have 4.8 from flat-hub somewhere on my system (have yet to find out where or how to remove it). 4.2 is is in the launch bar and has desktop icons to multiple sets of books. The only way I have found to run 4.8 is in software manager and have to change books manually (which 4.8 also had the nasty habit of creating backup files on the desktop for some reason). 1) How do I uninstall both versions? 2) how do I install 4.9 (preferably without Flathub)? I also need desktop icons to launch GNC from the desktop for multiple sets of books (lucky me, I am the accountant/tax man for the entire family! I won't even go into what condition I receive financial records in). I am not opposed to building from source code but; all of my tries have so far failed miserably on GNC. It's a simple mater under Windoze but so far nothing I have tried works on Ubuntu. And yes, I need the desktop icons for each set of books as the icons are linked to each individuals books across multiple drives on remote servers not just mine. My memory has had to many read/write cycles to keep track of who is on which server drive and file name. -- --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: [GNC] Adaptive learning reset of imports
On 12/2/21 1:41 PM, David H wrote: I'm using Flatpak on Ubuntu 21.04 and it is just like the usual Gnucash application. It saves the backup and log files wherever you decide to save your data file so I'm guessing you saved your data file to your desktop and that's why you ended up with all the backup and log files there also ? I keep my Gnucash data files in /home//Documents/GnuCash so that's where all the backup and log files are so they aren't cluttering up the desktop. So I would suggest you revisit Flatpak and save your datafile in an appropriate sub folder. Note that there is also a preference to never retain log files so perhaps you had that turned on for the normal desktop app ? Cheers David H. On Thu, 2 Dec 2021 at 21:34, Jeff <mailto:beastmaster...@hotmail.com>> wrote: On 12/2/21 4:21 AM, David H wrote: What version of Gnucash are you running and what OS ? I could be wrong but I think it's a fairly recent thing... Cheers David H. On Thu, 2 Dec 2021 at 19:10, Jeff mailto:beastmaster...@hotmail.com>> wrote: On 12/2/21 2:50 AM, David H wrote: Hi Jeff, Are you looking for Tools >> Import Map Editor ? Cheers David H. On Thu, 2 Dec 2021 at 18:29, Jeff mailto:beastmaster...@hotmail.com>> wrote: I remember reading a post on resetting the adaptive learning on OFX imports but I can not find it now. I am currently importing an OFX file from a business checking account and all income and, a few others that repeatedly show up, that are not recognized (this has been happening for several versions of GNC, both Windoze and Ubuntu versions 4.?). I am having this problem on every import, whether it is one week or one month of records. How can I reset the the learning process? IE. all deposits are income, not an unknown account? -- --JEffrey Black M.B.A. ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. If it is in there I cannot find it. Perhaps I do not understand how to enter the filter. All of the transactions come from one bank. All deposits are income, and the OFX import does not recognize any of them as income, just unknown. -- --JEffrey Black M.B.A. Ubuntu 20.04.3 LTS with GNC Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.49 *Note I would love to update to the latest stable version but I have so far been unsuccessful in doing so, all of of my builds have failed. And Flatpak caused even more problems for me (copied all backups to my desktop for some reason)* It makes no sense to me. It matches deposits from Square to the income account but refuses to match checks or cash to the income account. --JEffrey Black M.B.A. My data files are all saved on an external drive so I can take the drive anywhere I need to with my laptop instead of staying with my dedicated server. -- --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: [GNC] Adaptive learning reset of imports
On 12/2/21 4:21 AM, David H wrote: What version of Gnucash are you running and what OS ? I could be wrong but I think it's a fairly recent thing... Cheers David H. On Thu, 2 Dec 2021 at 19:10, Jeff <mailto:beastmaster...@hotmail.com>> wrote: On 12/2/21 2:50 AM, David H wrote: Hi Jeff, Are you looking for Tools >> Import Map Editor ? Cheers David H. On Thu, 2 Dec 2021 at 18:29, Jeff mailto:beastmaster...@hotmail.com>> wrote: I remember reading a post on resetting the adaptive learning on OFX imports but I can not find it now. I am currently importing an OFX file from a business checking account and all income and, a few others that repeatedly show up, that are not recognized (this has been happening for several versions of GNC, both Windoze and Ubuntu versions 4.?). I am having this problem on every import, whether it is one week or one month of records. How can I reset the the learning process? IE. all deposits are income, not an unknown account? -- --JEffrey Black M.B.A. ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. If it is in there I cannot find it. Perhaps I do not understand how to enter the filter. All of the transactions come from one bank. All deposits are income, and the OFX import does not recognize any of them as income, just unknown. -- --JEffrey Black M.B.A. Ubuntu 20.04.3 LTS with GNC Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.49 *Note I would love to update to the latest stable version but I have so far been unsuccessful in doing so, all of of my builds have failed. And Flatpak caused even more problems for me (copied all backups to my desktop for some reason)* It makes no sense to me. It matches deposits from Square to the income account but refuses to match checks or cash to the income account. --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.
[GNC] how to handle temporary desk checks
I never encountered this in any of my accounting practice before. My wife's personal business ran out of checks, so until the new ones arrived all of the banks desk checks are numbered . Check number already exists as a valid check number some years ago. Should all of the temporary numbered check numbers be entered as or a, b, etc in GNC? -- --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: [GNC] Adaptive learning reset of imports
On 12/2/21 2:50 AM, David H wrote: Hi Jeff, Are you looking for Tools >> Import Map Editor ? Cheers David H. On Thu, 2 Dec 2021 at 18:29, Jeff <mailto:beastmaster...@hotmail.com>> wrote: I remember reading a post on resetting the adaptive learning on OFX imports but I can not find it now. I am currently importing an OFX file from a business checking account and all income and, a few others that repeatedly show up, that are not recognized (this has been happening for several versions of GNC, both Windoze and Ubuntu versions 4.?). I am having this problem on every import, whether it is one week or one month of records. How can I reset the the learning process? IE. all deposits are income, not an unknown account? -- --JEffrey Black M.B.A. ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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. If it is in there I cannot find it. Perhaps I do not understand how to enter the filter. All of the transactions come from one bank. All deposits are income, and the OFX import does not recognize any of them as income, just unknown. -- --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.
[GNC] Adaptive learning reset of imports
I remember reading a post on resetting the adaptive learning on OFX imports but I can not find it now. I am currently importing an OFX file from a business checking account and all income and, a few others that repeatedly show up, that are not recognized (this has been happening for several versions of GNC, both Windoze and Ubuntu versions 4.?). I am having this problem on every import, whether it is one week or one month of records. How can I reset the the learning process? IE. all deposits are income, not an unknown account? -- --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: [GNC] Newest version for Ubuntu 20.04 LTS
On 10/2/21 12:48 PM, david whiting wrote: Hi Jeff, On Wed, 29 Sept 2021 at 07:11, Jeff wrote: [...] I would settle for a copy of "Building the Newest Version of GNC for Dummies Course" book. Others have shown you that you can use flatpak to get the latest version, but if you do want to build from source I have found that the following works on Ubuntu 20.04. I have also attached it as a script. This clones the source from git and by default builds the maintenance version. The versions are tagged, so you can use git to checkout a different version and build that if you want, e.g. you could build 4.8 rather than maint. build-gnucash.sh ## Change this if you want to build it somewhere else. SOURCEDIR="$HOME/Documents/gnucash/source" BUILDDIR="$HOME/Documents/gnucash/build" sudo apt update sudo apt upgrade sudo apt-get install build-essential ## This is one long line sudo apt install git make cmake libglib2.0-dev libxml2-dev libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3 libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev gwenhywfar-tools libgwengui-gtk3-dev # Only use the next 2 lines if you have not installed [[Google_Test | Google Test]] already. sudo apt install libgtest-dev# >=1.7.0 sudo apt install google-mock # 1.8.0 installs googlemock in a subdirectory of gtest mkdir -p $SOURCEDIR mkdir -p $BUILDDIR ## Clone gnucash source from git, if it is not already there [ ! -d $SOURCEDIR/gnucash ] && git clone https://github.com/Gnucash/gnucash.git $SOURCEDIR cd $BUILDDIR cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR make end of script David As time permits I will give it a try. All of my previous attempts have failed. My next problem seems that after following, shoot can not remember who demonstrated it for me, the Flatpak install of 4.8 keeps copying my books from an external drive to my user desktop. Complete with all timed backups. Clearly I have an environment variable set wrong someplace. Oh well, that's what keeps development interesting, figuring out where you hid that little gremlin in the system. -- --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: [GNC] Newest version for Ubuntu 20.04 LTS
On 9/29/21 6:48 AM, Jon Schewe wrote: If you install from flatpak you will get the current version. However note that there is currently a bug with 4.7 that prevents it from opening, so you may want to wait on that. sudo apt install flatpak sudo flatpak install org.gnucash.GnuCash flatpak run org.gnucash.GnuCash On Wed, 2021-09-29 at 01:10 -0500, Jeff wrote: Short of building from source, is there a link anywhere for upgrading from 4.2 to the next compatible stable version on Ubuntu 20.04 LTS? The Debian list is too far behind since I run multiple O.S.'s. I tried the suggested PPA, I think it was sicklylife something or other for 4.3. Totally screwed up a test set of books that I use just to test new versions before I turn it loose on my multiple sets of books for family. It would be nice to run the same working versions on my Ubuntu Server (Micro$soft bricked my main server and had to replace it, so I am migrating everything I can to Ubuntu) and my dual boot laptop. I have tried several times to build from source but; I am too old school on my programming language list (i.e. Cobol, Pascal, forth) to get a build to work. Every time I have tried it spits out in a foreign language some error list and fails to build. My bad. You would think that someone who wrote over 100,000 lines of C++ code to handle up to 2 billion inventory items for a POS and parts ordering system at best cost could easily handle this, but the languages you use are all too new to me. I would settle for a copy of "Building the Newest Version of GNC for Dummies Course" book. . So how do I get this to launch from a desktop icon like I had 4.2 doing? On Ubuntu. The desktop link still does 4.2 but the command line you listed does 4.8. -- --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: [GNC] Problems setting up first OFX transaction download
On 9/29/21 5:53 PM, David Carlson wrote: David, There are multiple ways to skin that cat, and it is not clear which one you are asking about. Quicken has an online banking type of feature which Gnucash can sometimes emulate, and sometimes not. In Gnucash it is called online banking. There is also a manual transaction download feature which works well with many banks using a file format called QFX or OFX. That requires manually going to the bank's website and manually selecting a transaction download in the OFX or QFX format if available, saving it locally then importing it into your data file. Some banks only offer CSV or other formats. I personally haven't been able to get the first way to work with any of the banks that I use, so I use second method. I would not be able to help you with online banking. On Wed, Sep 29, 2021, 5:22 PM Steve Welch via gnucash-user < gnucash-user@gnucash.org> wrote: I’ll be following this with interest — I just moved from Moneydance and am trying to set up credit card transaction downloads from Citi. No problems doing so in MD, but I haven’t been successful yet in GnuCash. I’m sure there’s something I’m not understanding here… Steve On Sep 29, 2021, at 4:25 PM, David Ellis wrote: I have been using Quicken for home and business for years to keep my one man office books. It does everything I need, especially auto-population of bank transactions in register for preparing financial statements. Now converting to GnuCash and used the wizard to a) import to gnu from Quicken data file, then b) set up OFX transaction download from bank directly to gnu. Got data import great, but efforts to get OFX duds. I am a retired dba so I kind of know what I'm doing, but didn't help much. I called the bank and worked with a tech person there but a detailed review of each item in the wizard didn't get anywhere with her either. I kept getting the error that there were no new transactions to download since the last one, which was 3 weeks and 29 transactions ago. Am I going to just have to download CSV monthly and import to gnu or can I actually get OFX to work? Thanks, David ___ 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. ___ 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. I will be following this with interest as well. I personally have never cared for the OFX/QFX format, it limits the data imported to much, the QIF format is much more suited and flexible for financial data interchange (CSV too if you understand the layout). Might as well say, QIF is informative while OFX/QFX are dumb as a stump when coming from any financial institution. OFX/QFX imports tend to leave out important information. Ever since the "newest" version of OFX/QFX came out I am having the same trouble, even with files that are supposedly under the previous format. New transactions that will not import. I suspect but can not prove it, that the QFX/OFX importer has a hiccup because date ranges and accounts match so it skips transactions, new or not. -- --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.
[GNC] Newest version for Ubuntu 20.04 LTS
Short of building from source, is there a link anywhere for upgrading from 4.2 to the next compatible stable version on Ubuntu 20.04 LTS? The Debian list is too far behind since I run multiple O.S.'s. I tried the suggested PPA, I think it was sicklylife something or other for 4.3. Totally screwed up a test set of books that I use just to test new versions before I turn it loose on my multiple sets of books for family. It would be nice to run the same working versions on my Ubuntu Server (Micro$soft bricked my main server and had to replace it, so I am migrating everything I can to Ubuntu) and my dual boot laptop. I have tried several times to build from source but; I am too old school on my programming language list (i.e. Cobol, Pascal, forth) to get a build to work. Every time I have tried it spits out in a foreign language some error list and fails to build. My bad. You would think that someone who wrote over 100,000 lines of C++ code to handle up to 2 billion inventory items for a POS and parts ordering system at best cost could easily handle this, but the languages you use are all too new to me. I would settle for a copy of "Building the Newest Version of GNC for Dummies Course" book. -- --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.
[GNC] Find transaction with totals
I'm sure this has been asked before but I can not find an answer. I frequently need to do a search (alt-f) for specific transactions and need to know how much was spent (number of transactions would be helpful in many instances). By any possible search parameters. Is there a way to display the $ amounts found (number of transactions would be greatly helpful to) or is there a report I am overlooking. I.E. search for all transactions containing notes, memo, description for "Blah blah corp" dates 02/23/2021 to today, account "Worthless expense", dollar amount greater or equal to $20. It is mainly the number of transactions and dollar total I am looking for. -- --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: [GNC] Redo account reconciliations
On 9/4/21 1:16 PM, Derek Atkins wrote: Exactly. But he had already reconciled to Aug 31, so need to use that date. -derek Sent using my mobile device. Please excuse any typos. On September 4, 2021 11:09:12 AM john wrote: Oops, that'w wrong: You can't use the February statement's balance, you have to use the July statement balance (assuming that you haven't yet reconciled August) because the reconcile window doesn't know how to use xaccAccountGetReconciledBalanceAsOfDate. Regards, John Ralls On Sep 4, 2021, at 7:59 AM, john wrote: He said the February reconcile. So tell the reconcile info dialog 28 Feb and type in the balance from the February statement as usual. Click OK. As long as you haven't messed up anything else you'll be able to check the one unreconciled split from February and the finish button and you're done. Regards, John Ralls On Sep 4, 2021, at 7:18 AM, Derek Atkins wrote: Ah... But that's NOT how you are supposed to recover from that. If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction, it doesn't matter what date the transaction has -- you should re-reconcile 31 August! You just need to re-check the February transaction. -derek On Sat, September 4, 2021 9:10 am, Christopher Lam wrote: Derek, Consider a well-used bank account. You reconcile every end of the month successfully up to 31 Aug 2021. Accidentally you unreconcile a Feb 2021 split. You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail because the reconciliation end balance also tallies splits from March 2021 onwards. C On Sat, 4 Sept 2021 at 13:01, Derek Atkins wrote: Chris, On Sat, September 4, 2021 8:36 am, Christopher Lam wrote: I agree that if an account reconciliation is done periodically correctly every time, then it works well. If an old reconciled split is unreconciled and we need to re-reconcile a previous reconciliation date, then the code falls apart. I'm curious why you say it falls apart? It may be an idea to allow batch unreconciliation of all splits whose reconcile date is after the reconciliation date in the Reconciliation dialog, thereby allowing the user to re-do reconciles. That could be a good idea. -derek On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user < gnucash-user@gnucash.org> wrote: The starting balance is computed from all the reconciled transactions "to date". It *can* be safe to ignore the starting balance if, for example, a transaction became unreconciled. For example, let's say you reconcile from some starting balance X to a final balance of $1000. Then you accidentally unreconcile a $100 transactions. If you try to re-reconcile that same statement/date/ending-balance of $1000, it won't show X as the starting balance, but something else (PROBABLY $900, but I'm not 100% sure). But that's okay -- just ensure the ending balance is correct and all the transactions that SHOULD be reconciled ARE reconciled. There is no way to get a transaction to reconciled status (y) manually -- the only way is through a reconcile process. So if you have reconciled transactions, that must've happened through a reconcile. I would recommend you just go ahead with March, ignore the starting balance, enter the correct March ending balance, and see if the reconciliation works (ensure you re-reconcile anything from earlier that might have become unreconciled). So I just want to build a bit on this answer. GNUCash doesn't have QBs reconciliation system - so don't equate the two. As an accountant who doesn't need to be handheld or leashed, I find GNUCash's system better than QBs - albeit there is room for improvement. However, I wouldn't recommend GNUCash to someone less comfortable with bare-ledger accounting - controls exist for a reason. I don't know how the backend works, but my experience is that the "Opening balance" is basically a running total of all the transactions marked "Reconciled" in that account. Whereas QB will _prevent_ you from attempting to reconcile August if July's reconciled balance differs from what it previously reconciled, GNUCash doesn't care - it just says "The transactions marked 'Reconciled' for this account total to $X." And that's good for when you have to go back and fix things... and know what you're doing. When you reconcile a transaction, again based on my experience, GNUCash toggles the "Reconciled" flag on the account _and_ inserts the reconciliation date. I personally like this because I can, say, start a fresh reconciliation for March having reconciled through August to pick up the transactions that _should_ have been in the March reconciliation but weren't because I readded them (or whatever). However, I need my calculator with me because I need to adjust the "closing balance" to reflect not the statement balance but what GNUCash's "running total" balance should be. Contrast this to having to undo every rec in QB
[GNC] Search with subtotals
Is there a way to do a search (ctrl F) and have a dollar total for all found transactions? Or a built in report tool that I am overlooking? running Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.49 On Ubuntu 20.04.2 LTS, not sure of the version on windows 10 pro (4.?) -- --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.
[GNC] Reconciliation screw-up
I may confuse myself even more here, so would appreciate some patience and guidance. I was given bank statements for 2 accounts (A and C). Unbeknownst to me there was a transaction that was supposed to go from account A to C (A $1 -> C $1). When the entries were made, the transactions were entered as A $1 -> B $1 and C $1 -> D $1 Accounts B and D never get reconciled. Accounts A and C do, and are now. What would be the simplest way to correct this error? I am using GNC 4.2 on Ubuntu 20.04. Data-file is uncompressed XML. -- --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.
[GNC] Gnucash issues with Ubuntu on external drives
My Windows 10 pro server recently went unstable so I am trying to move as much data and programs as I can to a new internal harddrive running Ubuntu 20.04-LTS. This includes Thunderbird, which I have so far been unsuccessful in migrating and that makes it difficult for me to keep up with the user list. I installed GNC 4.4 on Ubuntu. I'm getting some input issues that occur at random intervals. Account names that seemingly cease to exist when doing line entry, account names hiding when highlighted by mouse or keyboard. Auto-fill that does not duplicate the prior entry (previous entry was Hurley, auto fills with Hu unless I add the r.) Minor inconvenient issues at the moment. Will post about them later. What I can not find is why GNC will not show all of the mounted hard drives, internal or external, when selecting a set of books to open. Nor will it open the last set of books used if it was on an external drive (I have not yet tried copying them to the Ubuntu drive to see if works) . I have to go to file manager and double-click the set of books I need. Suggestions? -- --JEffrey Black M.B.A. -- This email has been checked for viruses by AVG. https://www.avg.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.
Re: [GNC] inventory
On 2/16/2021 6:34 AM, David Long wrote: Hi, Since GNU Cash does not include inventory recording, can anybody recommend an inventory recording system. I do not need all the inventory management capabilities, just record keeping, showing purchases, issues and balances in unit and cost. Thanks David ___ 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. . I'm not exactly sure what you are asking for. That being said, I track my Cattle inventory (100 head) in expense and income accounts (you can add T accounts as needed). GNC is an incredibly versatile program due to its great many under appreciated contributors/programmers. It is much more than a true and perfect double entry accounting program. You can track anything as long as YOU understand the accounts and have the time. Right down to the number of packages of raman noodles you purchase if you so desire (personally a number I find quite disturbing at the end of the month). All of the accounts you mentioned could be cash accounts if so desired. Problem is when you have a large number of individual items to record then your time inputting them is large. A POS/Inventory system would be the preferred system for inventory. Which I have 100,000 lines of code I wrote for it I can get it out of the ancient computer I wrote it on, capable of 2 billion individual items (find myself in need of it again if I can retrieve the source code. Passwords are a biotch if you forget them). Then you could export income/expense to GNC for book-work. If you wish then I would be willing to discuss possible methods through personal e-mail, not the list. -- --JEffrey Black M.B.A. -- This email has been checked for viruses by AVG. https://www.avg.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.
Re: [GNC] Changing multiple transactions
On 1/31/21 2:30 PM, Stephen M. Butler wrote: On 1/31/21 12:26 PM, Jeff Rizzo wrote: On 1/31/21 12:05 PM, Stephen M. Butler wrote: PPS Backups are mandatory. Yeah, they will be, once I get enough useful data in there that I don't keep starting over from scratch. Since I sent out the original email, I've realized that it's any kind of bulk editing that will require this, and turns out, apparently I really like to change multiple things at once. I'll give it a try and see if it's worth it. Oh. Starting over from scratch? Just train the importer (you will have to do that anyway over time). Don't let them go to the imbalance account in the first place. If importing a CSV file, create an extra column that you call the transfer account (or something like that) and put your own strings in there for the different accounts. During the import GnC will ask you for the real account name for each of those strings. It will ask only once per string rather than each time it encounters that same string (as would be done if matching on something else). Yeah, I'm still in the "evaluate whether this is going to work for me long-term" phase, so reimporting isn't TOO painful. I will try to put what you've suggested here into action, though I'm currently puzzling a little about how to with an OFX source instead of CSV - it did ask me the real account name, but apparently only for one side of each transaction? I'll dig. Thanks for your help, +j ___ 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] Changing multiple transactions
Using what you wrote here as a clue, I went looking for some older posts by you, and I think I found the actual helpful piece in it: it wasn't clear to me before that the account field WAS actually paste-able; I thought I had tried and failed, but I must have done something else wrong. This method of "bulk"-editing will actually work for me as a workaround, since it doesn't require touching the mouse. It's still not as good as being able to apply a change to multiple transactions, but it's enough. Thanks! +j On 1/31/21 3:07 PM, D via gnucash-user wrote: I'd ask how many transactions you've got to edit-- because over the years, I've had many opportunities to bulk edit transactions (new ideas on account setups, realizations that what I'd been doing didn't meet my needs or goals, etc.). In every case, it's been quite easy to change even large numbers of transactions (like, hundreds) using the methods I've shared both on the wiki and on recent threads here (open Imbalance, copy the new destination account, paste in appropriate field. Rinse. Repeat). By the time you've worked out the kinds of procedures outlined here, you could have made the changes and moved on to other things. Just my 2ç. David T. On Jan 31, 2021, 15:30, at 15:30, David Carlson wrote: If those transactions appeared in the imbalance account because you imported them without correctly assigning them during the import process, just re-import them. Note that if they were imported from OFX files the bad transactions would have to be deleted before they can be re-imported. On Sun, Jan 31, 2021 at 2:06 PM Stephen M. Butler < stephen.m.butle...@gmail.com> wrote: I have not had to do this at a large enough level to warrant the below: 1. Make a backup copy of your file (I presume you are using XML instead of a database back-end). 2. Export all the transactions from the Imbalance Account (getting the other splits also). 3. Delete the entire Imbalance Account and all associated transactions (why you needed to export the other splits). 4. Pull the export from #2 into a spreadsheet or other editing tool and make the assignments. 5. Import the multi-split edited file from #4 into GnC. 6. Do reports and other sanity checks to ensure everything is right. That's the safe and logical way. The other way is not safe and could really mess things up so you still need a backup: 1. Make that backup. 2. Un-Compress the XML file so you can humanly read the contents. 3. Figure out which fields you need to edit on which transactions (note -- I've not used an XML editor so don't know how easy this might be. I'd probably use vi or sed myself and groan inwardly.) 4. Make those edits. 5 Do the reports and other sanity checks to ensure everything is right. 6. Go back to the backup copy and try again since #5 wasn't right. Note: Loop through these steps as many times as needed until #5 looks good. --Steve PS If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes. Again, make that backup first and loop around as needed until GnC looks good. PPS Backups are mandatory. On 1/31/21 11:35 AM, Jeff Rizzo wrote: Hi- I'm currently trying to get my financial house back in order after some years, and have been pleasantly surprised with how much progress GNUCash has made since last I tried to use it (8 or 9 years ago). It seems to fit my need almost perfectly at this point, with one gaping hole - not being able to edit multiple transactions at the same time. :-( (I have read the "Register Tip" that says "There is no direct way to move a large number of transactions from one account to another in GnuCash.") As I'm trying to deal with several years' (two, at this point) worth of data, having to make three clicks to change each transaction is really a drag - and it's quickly sapping my enthusiasm for this project. Is there some workaround that some clever soul out there is using that would speed this up? To clarify, I'm trying to move large numbers of similar transactions from the "Imbalance" account to where they actually belong, so I don't see how I could easily do this by deleting an account. Thanks, +j ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --
