[GNC] Ok how do i begin? How do I open my new acct with a credit balance in my bank acct? This is for my opening balance in my new biz acct.
please keep it simpleThank you...b³ -- Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, State Securities Board of TX, *www.bullish.org bbag...@bullish.org 972.BUL.LISH, 285.5474 landline*** ___ 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] Budget Question and stylesheet question
Hi, I checked my 2.6.15 on my old computer and the C$ symbol is not there. I do not remember doing anything to specifically set C$ for the budget. I wonder why it is only in the right hand totals and not in all the budget items. I did set it for my Chart of Accounts and that is also the case in 2.6.15. Larry On Thu, Jan 9, 2025 at 12:04 PM David H wrote: > I am also seeing this in 5.10 on Win 10 - my test budget doesn't have any > currency prefix whereas Larry's does for some reason ? Just posed this > same question and then read your post here suggesting the same :-) > > Cheers David H. > > On Fri, 10 Jan 2025 at 05:58, CWheeler via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Yes, that is what I mean. >> >> I looked at the screenshot you posted, and I notice that the total >> column entries on the right of the budget show the totals in C$. No idea >> whether that could be an issue, but I'd like to know how you made that >> happen. My budgets don't display any currency indicators. (I'm on an >> older version of GnuCash, that could also be the reason why I don't see >> it.) >> >> On 2025-01-09 02:48 p.m., larry johnston wrote: >> > Hi, >> > >> > To be clear, when you say more than one top level Asset account, you >> > mean that there are two Asset accounts at the top of the Chart of >> > Accounts. I have Assets and nested under that Cash, TFSA. RRIF etc. >> > and under each of those the actual bank accounts etc. The same with >> > Expenses, Income etc. So that does not seem to be the issue. >> > >> > Thanks, >> > >> > Larry >> > >> > On Thu, Jan 9, 2025 at 8:51 AM CWheeler via gnucash-user >> > wrote: >> > >> > I have seen the budget issue happen when there is more than one >> > top-level Asset or Expense account in the book. It may occur with >> > other >> > account types as well, but I haven't tested those scenarios. >> > >> > > Date: Wed, 8 Jan 2025 20:15:07 -0800 >> > > From: larry johnston >> > > To: Brad Morrison >> > > Cc: Gnucash Users >> > > Subject: Re: [GNC] Budget Question and stylesheet question >> > > Message-ID: >> > > >> > > z...@mail.gmail.com> >> > > Content-Type: text/plain; charset="UTF-8" >> > > >> > > Hi, >> > > >> > > I did not upgrade, I started new on a new machine. Then I >> > entered all my >> > > data manually. Thus I don't think it isn issue with data >> > integrity. I am >> > > still hoping there is something I haven't done properly or some >> > option I >> > > haven't turned on. >> > > >> > > Thanks for reaching out. >> > > >> > > Larry >> > > >> > > On Wed, Jan 8, 2025 at 2:02?PM Brad >> > Morrison wrote: >> > > >> > >> Hi Larry & GNUCash users, >> > >> >> > >> "I just started using 5.10 on a new computer, Windows 11 and >> > have run >> > >> into two issues. I was previously running 2.6.15 in Windows 10." >> > >> >> > >> https://gnucash.org/download.phtml - the current version of >> > GNUCash is >> > >> 5.10, but there are some specific steps needed to take to >> > ensure data >> > >> integrity when upgrading between point versions (2 > 3, 3 > 4, >> > 4 > 5). >> > >> >> > >> https://wiki.gnucash.org/wiki/Installation#Upgrading & >> > >> >> > >> >> > >> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade >> > >> are some resources on what to do when upgrading. >> > >> >> > >> --- >> > >> Thanks, >> > >> >> > >> Brad -https://www.facebook.com/brad.morrison.12327/ & >> > >> https://norcal.social/@BradMorrison >> > >> >> > >> On 2025-01-08 11:01, larry johnston wrote: >> > >> >> > >>> Hi, >> > >>> >> > >>> I have gone through a couple years of the list without finding >> > an answer >> > >> to >> > >>> my questions. >> > >>> >> > >>> My companion who is running 4.14 on a Windows 11 computer ran >> > into a >> > >>> similar problem with her budget. her expenses were not >> > populating in the >> > >>> monthly totals at the bottom of the budget. It turns out that >> > she had >> > >>> entered zeros in some of her place holder accounts. Once she >> > cleared >> > >> those >> > >>> lines the monthly totals populated correctly. I can't find any >> > similar >> > >>> problem in my budget. Any help is appreciated. >> > >>> >> > >>> TIA, >> > >>> >> > >>> Larry >> > >>> >> > >>> On Mon, Jan 6, 2025 at 2:11?AM David H >> wrote: >> > >>> >> > >>> Hi Larry, >> > >>> >> > >>> Can't help you with your budget questions but if you click the >> > >>> lists.gnucash link at the bottom of the emails it will take >> > you to here - >> > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which >> > is agood >> > >>> place to start searching or browsing previous postings. >> > >>> >> >
Re: [GNC] gnucash-user Digest, Vol 262, Issue 24
gt;>>>>>> Hi, >>>>>>>>> >>>>>>>>> I have gone through a couple years of the list without finding an >>>>>> answer to >>>>>>>>> my questions. >>>>>>>>> >>>>>>>>> My companion who is running 4.14 on a Windows 11 computer ran >>>>> into a >>>>>>>>> similar problem with her budget. her expenses were not populating >>>>> in >>>>>> the >>>>>>>>> monthly totals at the bottom of the budget. It turns out that she >>>>> had >>>>>>>>> entered zeros in some of her place holder accounts. Once she >>>>> cleared >>>>>> those >>>>>>>>> lines the monthly totals populated correctly. I can't find any >>>>> similar >>>>>>>>> problem in my budget. Any help is appreciated. >>>>>>>>> >>>>>>>>> TIA, >>>>>>>>> >>>>>>>>> Larry >>>>>>>>> >>>>>>>>> On Mon, Jan 6, 2025 at 2:11?AM David H wrote: >>>>>>>>> >>>>>>>>> Hi Larry, >>>>>>>>> >>>>>>>>> Can't help you with your budget questions but if you click the >>>>>>>>> lists.gnucash link at the bottom of the emails it will take you to >>>>>> here - >>>>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which is >>>>> agood >>>>>>>>> place to start searching or browsing previous postings. >>>>>>>>> >>>>>>>>> Cheers David H. >>>>>>>>> >>>>>>>>> On Mon, 6 Jan 2025 at 16:45, larry johnston < >>>>> larryej1...@gmail.com> >>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I just started using 5.10 on a new computer, Windows 11 and have >>>>> run >>>>>> into >>>>>>>>> two issues. I was previously running 2.6.15 in Windows 10. >>>>>>>>> >>>>>>>>> I set up my budget and everything seems good, except that the >>>>> rows at >>>>>> the >>>>>>>>> very bottom, Income, Expense, Transfers and Total have not been >>>>>> populated, >>>>>>>>> so you can't see how your budget is doing for each period (month). >>>>>> These >>>>>>>>> would automatically populate in 2.6.15. Is there some place that I >>>>>> need to >>>>>>>>> turn this on? >>>>>>>>> >>>>>>>>> In 2.6.15 I was able to make a new stylesheet for my reports that >>>>> had >>>>>> grid >>>>>>>>> lines between the rows and columns. This makes it much easier to >>>>> read >>>>>> the >>>>>>>>> reports. In 5.10 the same steps are just putting bars over some >>>>> of the >>>>>>>>> rows. >>>>>>>>> >>>>>>>>> It has been a long time since I searched for answers to my >>>>> questions, >>>>>> but >>>>>>>>> I >>>>>>>>> seem to remember that there is some place where there is a monthly >>>>>>>>> compilation of the issues discussed here. If I could find it, >>>>> maybe I >>>>>>>>> could >>>>>>>>> limit my questions to the group. >>>>>>>>> >>>>>>>>> TIA, >>>>>>>>> >>>>>>>>> Larry >>>>>>>>> ___ >>>>>>>>> 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. >>>>>> ___ >>>>>> 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. >>>>> >>>> > -- next part -- > A non-text attachment was scrubbed... > Name: image.png > Type: image/png > Size: 69012 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250109/674bc5ca/attachment.png> > > -- > > Subject: Digest Footer > > ___ > > 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. > > > -- > > End of gnucash-user Digest, Vol 262, Issue 24 > * ___ 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] Budget Question and stylesheet question
David, Thanks for your insights. When I started my Chart of Accounts, I thought I had set it to C$ but it was in US$ an dI had to go back and change them to C$. Maybe I missed one or two of them. I was not aware of the Locale option. Where would I find it and would it change all of my accounts or do I have to apply it individually? Larry PS I copied the list with this, I hope that is ok with you. On Thu, Jan 9, 2025 at 12:12 PM David H wrote: > Larry, > > What are your Accounts preferences set to for default currency - "Locale" > or did you "Choose" Canadian Dollar? My accounts are just set to "Locale" > and I don't have your issue > > Cheers again David H. > > > > On Fri, 10 Jan 2025 at 06:00, David H wrote: > >> Larry, >> >> I don't use Budgets so I'm not at all familiar with their use. I created >> a new budget in my current file that has about 10 - 15 years of txns in >> it. I just highlighted the expenses row at top and clicked "estimate" and >> told it to use the previous 12 months figures which populated the budget >> figures at both top and bottom. I also tried just selecting the amount for >> the first few months on the expenses row and as I entered a new monthly >> figure of $5,000 it updated the figures at bottom which I assume is the >> expected behaviour ? >> >> It's interesting that your Total column is prefixed with "C$" whereas >> totals are just prefixed with "$" - are you mixing currencies in your >> GnuCash file and could this be an issue with budgets ? >> >> This is on Win 10 using GnuCash 5.10. Will also try on Win 11 later today. >> >> Cheers David H. >> >> [image: image.png] >> >> >> On Fri, 10 Jan 2025 at 05:12, larry johnston >> wrote: >> >>> Brad, >>> >>> I am unclear on the potential issues you point to. >>> >>> 1. Manually entered data. There is very little data in the file yet as it >>> is only January (I did not bring forward any data from previous years). >>> Will data entered into accounts affect the budget? I don't think so. I >>> entered my budget manually and it calculated accurately in the rows, with >>> the monthly amounts being totalled to a yearly amount at the right end of >>> the table. However the columns were not filled (populated) at the bottom >>> of >>> each column (Income, Expenses, Transfer and Remaining to Budget). This >>> never happened before in 2.6.15. >>> >>> 2. Version of GnuCash. I started new in the latest version 5.10 in >>> Windows >>> 11. >>> >>> 3. The data file. As noted above the file was started in 5.10, nothing >>> was >>> imported. >>> >>> I suppose this could be a bug, but if it is I would have expected someone >>> else to note it before now. Therefore I think there must be something I >>> missed in setting up the budget that so that it will populate the column >>> (i.e. monthly) totals. >>> >>> Below is a screenshot of my Budget. >>> >>> Any help is appreciated, >>> >>> TIA, >>> >>> Larry >>> >>> >>> >>> [image: image.png] >>> >>> On Thu, Jan 9, 2025 at 1:20 AM Brad Morrison >>> wrote: >>> >>> > Hi Larry/GnuCash users, >>> > >>> > There may be a few potential issues involved: >>> > >>> > - the data (which you mentioned that you entered manually) >>> > >>> > - the version of GnuCash >>> > >>> > - the data file (which might depend on which version of GnuCash that >>> > data file was started with, which is slightly separate from the data >>> > itself and the version of GnuCash) >>> > >>> > https://wiki.gnucash.org/wiki/Installation#Upgrading & >>> > >>> > >>> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade >>> > are some resources on what to do when upgrading. >>> > >>> > --- >>> > Thanks, >>> > >>> > Brad - https://www.facebook.com/brad.morrison.12327/ & >>> > https://norcal.social/@BradMorrison >>> > >>> > On 2025-01-08 20:15, larry johnston wrote: >>> > >>> > > Hi, >>> > > >>> > > I did not upgrade, I started new on a new machine. Then I entered >>> all my >>> > data manually. Thus I don't think it isn issue with data integrity. I >>> am >>> > still hoping there is something I haven't done properly or some option >>> I >>> > haven't turned on. >>> > > >>> > > Thanks for reaching out. >>> > > >>> > > Larry >>> > > >>> > > On Wed, Jan 8, 2025 at 2:02 PM Brad Morrison >> > >>> > wrote: >>> > > >>> > >> Hi Larry & GNUCash users, >>> > >> >>> > >> "I just started using 5.10 on a new computer, Windows 11 and have >>> run >>> > >> into two issues. I was previously running 2.6.15 in Windows 10." >>> > >> >>> > >> https://gnucash.org/download.phtml - the current version of >>> GNUCash is >>> > >> 5.10, but there are some specific steps needed to take to ensure >>> data >>> > >> integrity when upgrading between point versions (2 > 3, 3 > 4, 4 > >>> 5). >>> > >> >>> > >> https://wiki.gnucash.org/wiki/Installation#Upgrading & >>> > >> >>> > >>> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade >>> > >> are some resources on what to do when upgrading. >>> > >> >>> > >> --- >>
Re: [GNC] gnucash 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
Downgrading and resaving as xml sounds like the quickest solution. I'm not sure that using mysql has any benefit for access at different workstations, since GnuCash is not multiuser anyhow. Also, if you downgrade to the package with SQL support, you could just stay there, unless there's some compelling reason to get the latest and greatest flatpak. David T. On Jan 10, 2025, 12:47 AM, at 12:47 AM, dewaj wrote: >On Thu, 9 Jan 2025 12:16:34 -0600 (CST) >Mark Penner wrote: > >> Jan 9, 2025 09:19:45 dewaj : >> >> > Flatpak edition of gnucash 5.10 starts with this warning: >> > >> > libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so >> > >> > is /app/lib/dbd/ the correct path? >> > >> > That path is not found anywhere at all on the system. >> >> That path is inside the flatpak. Run `flatpak run --command=sh >> org.gnucash.GnuCash` to get a shell inside the flatpak and then you >> can see if the file exists there. > >Thanks for that info. > >Neither the files nor the path are found. > >I have been using mysql instead of xml because gnucash is used at >different workstations. > >I do not use the debian version of gnucash (currently at 4.13). > >perhaps I can downgrade to 5.9 to save the data from mysql to xml. > >-- >dj > >___ >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.
Re: [GNC] Ok how do i begin? How do I open my new acct with a credit balance in my bank acct? This is for my opening balance in my new biz acct.
Bob This will surprise you but the transaction is Asset:Bank account Debit Equity:Opening Balances Credit The basics section of the Tutorial and Concpets Guide has an introduction to the use of the terms debit and credit in accounting practice. The main thing to remember is these are reversed in your books from the bank's use of them on statements as those statements are issued by them from their accounting perspective. Your bank account is a liability for a bank as they have to be able to come up with the money if you demand it. Likewise your credit card is an asset in the bank's accounting system but a liability in your books. David Cousens On Thu, 2025-01-09 at 18:00 -0600, bullish bob bagley via gnucash-user wrote: > please keep it simpleThank you...b³ > ___ 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] Budget Question and stylesheet question
Hi, I went back and checked preferences and Accounts was set to Locale but showed US$. I changed it to C$ and that did not affect the Budget. I have now set it to Locale and $C and the dialog box says it will affect all future actions, still no effect on the Budget. I guess I need to check all of my accounts now to ensure they are consistent. That is probably a task for th weekend. Larry On Thu, Jan 9, 2025 at 4:22 PM larry johnston wrote: > David, > > Thanks for your insights. When I started my Chart of Accounts, I thought I > had set it to C$ but it was in US$ an dI had to go back and change them to > C$. Maybe I missed one or two of them. I was not aware of the Locale > option. Where would I find it and would it change all of my accounts or do > I have to apply it individually? > > Larry > > PS I copied the list with this, I hope that is ok with you. > > On Thu, Jan 9, 2025 at 12:12 PM David H wrote: > >> Larry, >> >> What are your Accounts preferences set to for default currency - "Locale" >> or did you "Choose" Canadian Dollar? My accounts are just set to "Locale" >> and I don't have your issue >> >> Cheers again David H. >> >> >> >> On Fri, 10 Jan 2025 at 06:00, David H wrote: >> >>> Larry, >>> >>> I don't use Budgets so I'm not at all familiar with their use. I >>> created a new budget in my current file that has about 10 - 15 years of >>> txns in it. I just highlighted the expenses row at top and clicked >>> "estimate" and told it to use the previous 12 months figures which >>> populated the budget figures at both top and bottom. I also tried just >>> selecting the amount for the first few months on the expenses row and as I >>> entered a new monthly figure of $5,000 it updated the figures at bottom >>> which I assume is the expected behaviour ? >>> >>> It's interesting that your Total column is prefixed with "C$" whereas >>> totals are just prefixed with "$" - are you mixing currencies in your >>> GnuCash file and could this be an issue with budgets ? >>> >>> This is on Win 10 using GnuCash 5.10. Will also try on Win 11 later >>> today. >>> >>> Cheers David H. >>> >>> [image: image.png] >>> >>> >>> On Fri, 10 Jan 2025 at 05:12, larry johnston >>> wrote: >>> Brad, I am unclear on the potential issues you point to. 1. Manually entered data. There is very little data in the file yet as it is only January (I did not bring forward any data from previous years). Will data entered into accounts affect the budget? I don't think so. I entered my budget manually and it calculated accurately in the rows, with the monthly amounts being totalled to a yearly amount at the right end of the table. However the columns were not filled (populated) at the bottom of each column (Income, Expenses, Transfer and Remaining to Budget). This never happened before in 2.6.15. 2. Version of GnuCash. I started new in the latest version 5.10 in Windows 11. 3. The data file. As noted above the file was started in 5.10, nothing was imported. I suppose this could be a bug, but if it is I would have expected someone else to note it before now. Therefore I think there must be something I missed in setting up the budget that so that it will populate the column (i.e. monthly) totals. Below is a screenshot of my Budget. Any help is appreciated, TIA, Larry [image: image.png] On Thu, Jan 9, 2025 at 1:20 AM Brad Morrison wrote: > Hi Larry/GnuCash users, > > There may be a few potential issues involved: > > - the data (which you mentioned that you entered manually) > > - the version of GnuCash > > - the data file (which might depend on which version of GnuCash that > data file was started with, which is slightly separate from the data > itself and the version of GnuCash) > > https://wiki.gnucash.org/wiki/Installation#Upgrading & > > https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade > are some resources on what to do when upgrading. > > --- > Thanks, > > Brad - https://www.facebook.com/brad.morrison.12327/ & > https://norcal.social/@BradMorrison > > On 2025-01-08 20:15, larry johnston wrote: > > > Hi, > > > > I did not upgrade, I started new on a new machine. Then I entered all my > data manually. Thus I don't think it isn issue with data integrity. I am > still hoping there is something I haven't done properly or some option I > haven't turned on. > > > > Thanks for reaching out. > > > > Larry > > > > On Wed, Jan 8, 2025 at 2:02 PM Brad Morrison < bradmorri...@sonic.net> > wrote: > > > >> Hi Larry & GNUCash users, > >> > >> "I just starte
Re: [GNC] Ok how do i begin? How do I open my new acct with a credit balance in my bank acct? This is for my opening balance in my new biz acct.
https://www.gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide David T. On Jan 10, 2025, 3:38 AM, at 3:38 AM, David Cousens wrote: >Bob > >This will surprise you but the transaction is > >Asset:Bank account Debit >Equity:Opening Balances Credit > > >The basics section of the Tutorial and Concpets Guide has an >introduction to the use of the terms debit and credit in accounting >practice. > >The main thing to remember is these are reversed in your books from the >bank's use of them on statements as those statements are issued by them >from their accounting perspective. > >Your bank account is a liability for a bank as they have to be able to >come up with the money if you demand it. > >Likewise your credit card is an asset in the bank's accounting system >but a liability in your books. > >David Cousens > > >On Thu, 2025-01-09 at 18:00 -0600, bullish bob bagley via gnucash-user >wrote: >> please keep it simpleThank you...b³ >> > >___ >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.
Re: [GNC] correct a mistake early
Ya'll are just simply incredible!! On 1/9/25 2:03 PM, David Cousens wrote: Bob, No great problem. Create the folder and then locate the datafile, its backup and log files, i.e. anyfiles which have the base filename you gave the file e.g. .gnucash .gnucash..gnucash .gnucash..log where is a string with format "mmddhhmmss" e.g. .20250110060236 Any file .LCK can be deleted. When you next start GnuCash use the File->Open dialogue to navigate to the folder and the datafile in it and open it. After that GnuCash should remember where the file is on subsequent openings unless you open another data file. David Cousens On Thu, 2025-01-09 at 10:35 -0600, bullish bob bagley via gnucash-user wrote: I created a name for my folder and did not set up a holder file to keep things out of my document folder. How do retreat back and do this properly? I am watching a video "How to setup gnucash business accounting files aka the chart of accounts via the the busy bee post. This is my mistake, but the video does not allow me to correct it. I would like to delete the file set up and then set it up properly as per the video. Thank youb³ -- Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, State Securities Board of TX, *www.bullish.org bbag...@bullish.org 972.BUL.LISH, 285.5474 landline*** ___ 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 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
On Thu, 9 Jan 2025 12:16:34 -0600 (CST) Mark Penner wrote: > Jan 9, 2025 09:19:45 dewaj : > > > Flatpak edition of gnucash 5.10 starts with this warning: > > > > libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so > > > > is /app/lib/dbd/ the correct path? > > > > That path is not found anywhere at all on the system. > > That path is inside the flatpak. Run `flatpak run --command=sh > org.gnucash.GnuCash` to get a shell inside the flatpak and then you > can see if the file exists there. Thanks for that info. Neither the files nor the path are found. I have been using mysql instead of xml because gnucash is used at different workstations. I do not use the debian version of gnucash (currently at 4.13). perhaps I can downgrade to 5.9 to save the data from mysql to xml. -- dj ___ 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] When importing an account tree from a csv file, account type information disappears
Hi Hakon/GnuCash users, https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - have you read this section of the GnuCash Wiki on importing and exporting data? What version of GnuCash are you using? The current version is 5.10 - https://www.gnucash.org/download.phtml What operating system are you using? --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-08 15:28, Michael or Penny Novack via gnucash-user wrote: > On 1/8/2025 5:52 PM, ha...@finne.net wrote: > >> I am a new GnuCash user. I have several problems when trying to import an >> account tree from an accounting program (Mamut Datax) I have used before. >> One of these problems can be described as follows. >> >> I export the account structure from my MD system to a csv file. I then use >> MS Excel to restructure the information to fit the input requirements for a >> csv file that will define a GnuCash account tree. During the import to >> GnuCash, I assign my MB Account Type field to the Type field of GnuCash. >> Once imported, the account tree looks ok, except that the Type field for >> each account is empty. It does not matter whether I use the original US Type >> typology or the built-in Norwegian Type typology. I understand that a >> subaccount cannot be assigned a Type that is not compatible with the account >> above it in the tree, all the way up to the five fundamental account types. >> And I make sure the sequence of accounts in the csv file defines the >> hierarchy top-down (should it matter). Please help me sort this out. >> Assigning account Types manually after the import is possible, but I would >> rather solve this in a more automatic manner. >> >> -- Håkon > > I've done this sort of thing several times in my working days, so can see you > are leaving out a critical step (when migrating between databases) > > a) FIRST do an export from your DESTINATION and make sure you can import that > back in (in this case to another instance of gnucash books) > > b) DID that work? Did everything you expected to see appear where it should? > > NOTE: These first two steps are to isolate potential problems. If an issue > shows up doing "a" and "b" it would show up going data source to data > destination no matter how perfect you did the rest and you'd be looking for > the problem in the wrong place. In other words, skipping those first two > steps only looks like it saves time. In practice, will save much more head > scratching time later. > > c) OK, you NOW look at the format (of that export from gnucash) using your > favorite editor? See where all the fields are? All .cvs means the fields are > delineated by commas, NOT that their order is correct. Now you look at your > export from MB. Not likely in the same order. You'll possibly need to write > something to fix if no "reorder tool" available < that, roll my own, then leave that in a department library as a tool >> > > NOTE: If there is SOMETHING in the gnucash export you can't find in the MB > export may have to fill in manually. > > 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. ___ 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] correct a mistake early
Thank you On 1/9/25 11:10 AM, Derek Atkins wrote: If you just want to change the location of the data file on your disk, then you can either File -> Save As into the new location, or you can move the file to the new location and then File -> Open from the new location. It will not remove the old files from the old location, but you can move them yourself, safely. Hope this helps. -derek On Thu, January 9, 2025 11:35 am, bullish bob bagley via gnucash-user wrote: I created a name for my folder and did not set up a holder file to keep things out of my document folder. How do retreat back and do this properly? I am watching a video "How to setup gnucash business accounting files aka the chart of accounts via the the busy bee post. This is my mistake, but the video does not allow me to correct it. I would like to delete the file set up and then set it up properly as per the video. Thank youb³ -- Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, State Securities Board of TX, *www.bullish.orgbbag...@bullish.org 972.BUL.LISH, 285.5474 landline*** ___ 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. -- Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, State Securities Board of TX, *www.bullish.org bbag...@bullish.org 972.BUL.LISH, 285.5474 landline*** ___ 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 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
Flatpak is in devuan repos. presumably if flatpak were not supported it would not be in a repo and/or would not be installable. devuan specific packages are built without systemd dependencies. otherwise typical debian packages are used. gnucash 5.9 flatpak edition supports mysql and sqlite3. ranking appears to be irrelevant. devuan is functional. -- dj ___ 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 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
Jan 9, 2025 09:19:45 dewaj : > Flatpak edition of gnucash 5.10 starts with this warning: > > libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so > > is /app/lib/dbd/ the correct path? > > That path is not found anywhere at all on the system. That path is inside the flatpak. Run `flatpak run --command=sh org.gnucash.GnuCash` to get a shell inside the flatpak and then you can see if the file exists there. ___ 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] gnucash 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
Using devuan daedalus with gnucash flatpak. Flatpak edition of gnucash 5.10 starts with this warning: libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so is /app/lib/dbd/ the correct path? That path is not found anywhere at all on the system. libdbdmysql is installed in the debian default location of /usr/lib/x86_64-linux-gnu/dbd/ At present, gnucash 5.10 flatpak edition lists only xml and pgsql as file options. -- jd ___ 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] no suitable module found for a file
Hi Jean-Pierre/GnuCash users, Glad to hear that installing the libdbd-sqlite3 library solved that issue! Another option to figuring out which Linux dependency might be missing from the Linux distribution that you are using with GnuCash or any other Linux program/app, is to use the Flatpak version, which bundles the libraries/runtimes/dependencies with the Linux app/program. https://flathub.org/apps/org.gnucash.GnuCash - the Flatpak version of Gnucash https://flatpak.org/setup/ & https://flathub.org/setup lists the 41 different Linux distros that work with Flatpak/Flathub and how to get it set up. --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-09 01:34, Jean-Pierre Vandenbroucke wrote: > Hallo, > > Installing libdbd-sqlite3 solved the problem, thank you. > > Op 8/01/2025 om 22:07 schreef David Cousens: Jean-Pierre, > > Were you using one of the SQL backends to store your file in V5.5 on > LM22. If so, it may be possible that the V5.6 on LMDE6 has been built > without the database drivers. > So you still have access to the Linux Mint22 system. If so run the > File-Save As dialogue from the menu. At the top of the dialogue pane > there is a selection box labelled data format which has the options: > mysql > postgres > sqlite3 > xml > > The existing setting of this will tell you what format the file was > originally saved in. If it is in one of the first 3 formats the version > on the new machine will need to have the SQL support libraries. > > If you check the same dialogue on your new machine, if it doesn't > supply these options it has likely been built without the SQL drivers. > > Another way you can check for the drivers presence is to type the > command > "dpkg -l : grep dbi" > into a terminal. If you have the database support installed it should > indicate the following packages are installed: > libdbi > and at least one of > libdbd-mysql > libdbd-pgsql > libdbd-sqlite3 > > If you select "xml" in the File->Save As dialogue, the file will be > saved in xml format which can be opened in GnuCash when it has been > built without SQL support. Give it an identifiable filename (e.g append > "_xml" to the filename - you can delete this addition later). Copy this > file to your new machine and then open it with the File->Open dialogue. > > If what I suspect is the problem you should be able to open it. > > David Cousens > > On Wed, 2025-01-08 at 11:25 +0100, Jean-Pierre Vandenbroucke wrote: Hallo, > > I switched recently from Linux Mint 22 to LMDE6. > > In Linux Mint 22 I used the version 1:5.5-1.2build1 from ubuntu > noble/universe without problems. > In LMDE6 the version was 1:4.13-1 from bookworm (debian). > > When I started GNUCASH in LMDE6 I received the following: "No > suitable module found for file ...". > I decided to delete 1:4.13-1 and to install 1:5.6-1~bpo12+1 from > bookworm-backports. > But when starting GNUCASH I receive the same message. > > It is only for the file in which I made transactions in Linux Mint 22 > that I get the message "no suitable module found.." > I have a file in which i made no transactions in Linux Mint 22 and > this file opens without problem in LMDE6. > > How could I re-enter all my 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 - 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.
Re: [GNC] When importing an account tree from a csv file, account type information disappears
(Apologies if I mess up the response format on this mailing list; I subscribed to daily digests, so I had to copy-paste from that bundle of messages.) Thanks, Michael, for your prompt response. The ordering of fields and potential manual edits that you suggest after steps a) and b), I had already been through a number of times. However, I had not performed your suggestions a) and b) below, so I went through those steps this morning. This procedure at first seemed to reveal nothing unexpected. However, in preparing a new file (book) from scratch, I discovered that there seemed to be some mixture of English/Norwegian terminologies. Since I expected that my problem was related to the English/Norwegian issue, I performed the New-file-then-export procedure on two different out of the 17 proposed "Categories" of account "ensembles" (my word) available for my language version (nb). I first established a new file (book) using an ensemble called "Common Accounts", where everything was worded in English -- except for the account Type for each account, which was worded in Norwegian. The subsequent csv file export of the account tree, however, displayed the account Types in ENGLISH UPPERCASE. I then repeated the New-file-then-export procedure for an ensemble called "Nærings Kontoer", a use case where everything was in Norwegian, including the account Type for each account. The subsequent csv file export of the account tree, however, displayed the account Types in ENGLISH UPPERCASE. In other words, the export procedure displayed the account Types in ENGLISH UPPERCASE, whereas the display of the account Types inside the GnuCash book was in Norwegian Sentence case. This held for both the "Common Accounts" ensemble (English original) and the "Nærings Kontoer" ensemble (Norwegian adaptation of a different set of accounts). So I tested four different cases of importing a (selection of) my MD account tree (sorry I also erroneously misspelt it MB earlier) into a new and empty GnuCash file (book): Norwegian and English account Type names, in UPPERCASE and Sentence case. The only case where all the account Types were then actually imported, was the combination of English account Type names written in UPPER CASE. One interesting anomaly, though: the English Bank account Type is worded exactly the same way in Norwegian. So in the Norwegian UPPERCASE case import, the account Type for bank accounts was correctly imported (even though no accounts had been defined yet as ASSET accounts). I can now proceed with my other problems of changing from my Mamut Datax system to a GnuCash system. However, since I have not been able to find documentation on the English UPPERCASE requirement for the import (via csv) of account Types associated with imported accounts, I hope someone could either include that in the documentation or give better pointers to where to find it (if it is already somewhere in the documentation). Does anyone reading this message pick up this challenge, or should I direct it elsewhere -- and if so, where? -- Håkon Message: 7 Date: Wed, 8 Jan 2025 18:28:33 -0500 From: Michael or Penny Novack To: gnucash-user@gnucash.org Subject: Re: [GNC] When importing an account tree from a csv file, account type information disappears Message-ID: <0c4e7607-5a9a-4511-8048-d514111b3...@comcast.net> Content-Type: text/plain; charset=UTF-8; format=flowed On 1/8/2025 5:52 PM, ha...@finne.net wrote: I am a new GnuCash user. I have several problems when trying to import an account tree from an accounting program (Mamut Datax) I have used before. One of these problems can be described as follows. I export the account structure from my MD system to a csv file. I then use MS Excel to restructure the information to fit the input requirements for a csv file that will define a GnuCash account tree. During the import to GnuCash, I assign my MB Account Type field to the Type field of GnuCash. Once imported, the account tree looks ok, except that the Type field for each account is empty. It does not matter whether I use the original US Type typology or the built-in Norwegian Type typology. I understand that a subaccount cannot be assigned a Type that is not compatible with the account above it in the tree, all the way up to the five fundamental account types. And I make sure the sequence of accounts in the csv file defines the hierarchy top-down (should it matter). Please help me sort this out. Assigning account Types manually after the import is possible, but I would rather solve this in a more automatic manner. -- H?kon I've done this sort of thing several times in my working days, so can see you are leaving out a critical step (when migrating between databases) a) FIRST do an export from your DESTINATION and make sure you can import that back in (in this case to another instance of gnucash books) b) DID that work? Did everything you expected to see appear where it should? NOTE:
Re: [GNC] gnucash 5.10 flatpak edition: "failed tp load /app/lib/dbd/libdbdmysql.so"
Hi Dewaj/GnuCash users, While this may not answer your immediate issue: https://www.devuan.org/os/packages - does Devuan support Flatpaks? https://distrowatch.com/table.php?distribution=devuan - DistroWatch lists it as #44 in Linux distro popularity, so it is not a common distribution. It also looks like Devuan is not 1 of the 41 Linux distributions listed at https://flatpak.org/setup/ or https://flathub.org/setup --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-09 07:17, dewaj wrote: > Using devuan daedalus with gnucash flatpak. > > Flatpak edition of gnucash 5.10 starts with this warning: > > libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so > > is /app/lib/dbd/ the correct path? > > That path is not found anywhere at all on the system. > > libdbdmysql is installed in the debian default location of > /usr/lib/x86_64-linux-gnu/dbd/ > > At present, gnucash 5.10 flatpak edition lists only xml and pgsql as > file options. > > -- > jd > ___ > 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.
Re: [GNC] Budget Question and stylesheet question
I have seen the budget issue happen when there is more than one top-level Asset or Expense account in the book. It may occur with other account types as well, but I haven't tested those scenarios. Date: Wed, 8 Jan 2025 20:15:07 -0800 From: larry johnston To: Brad Morrison Cc: Gnucash Users Subject: Re: [GNC] Budget Question and stylesheet question Message-ID: Content-Type: text/plain; charset="UTF-8" Hi, I did not upgrade, I started new on a new machine. Then I entered all my data manually. Thus I don't think it isn issue with data integrity. I am still hoping there is something I haven't done properly or some option I haven't turned on. Thanks for reaching out. Larry On Wed, Jan 8, 2025 at 2:02?PM Brad Morrison wrote: Hi Larry & GNUCash users, "I just started using 5.10 on a new computer, Windows 11 and have run into two issues. I was previously running 2.6.15 in Windows 10." https://gnucash.org/download.phtml - the current version of GNUCash is 5.10, but there are some specific steps needed to take to ensure data integrity when upgrading between point versions (2 > 3, 3 > 4, 4 > 5). https://wiki.gnucash.org/wiki/Installation#Upgrading & https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade are some resources on what to do when upgrading. --- Thanks, Brad -https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-08 11:01, larry johnston wrote: Hi, I have gone through a couple years of the list without finding an answer to my questions. My companion who is running 4.14 on a Windows 11 computer ran into a similar problem with her budget. her expenses were not populating in the monthly totals at the bottom of the budget. It turns out that she had entered zeros in some of her place holder accounts. Once she cleared those lines the monthly totals populated correctly. I can't find any similar problem in my budget. Any help is appreciated. TIA, Larry On Mon, Jan 6, 2025 at 2:11?AM David H wrote: Hi Larry, Can't help you with your budget questions but if you click the lists.gnucash link at the bottom of the emails it will take you to here - https://lists.gnucash.org/mailman/listinfo/gnucash-user which is agood place to start searching or browsing previous postings. Cheers David H. On Mon, 6 Jan 2025 at 16:45, larry johnston wrote: Hi, I just started using 5.10 on a new computer, Windows 11 and have run into two issues. I was previously running 2.6.15 in Windows 10. I set up my budget and everything seems good, except that the rows at the very bottom, Income, Expense, Transfers and Total have not been populated, so you can't see how your budget is doing for each period (month). These would automatically populate in 2.6.15. Is there some place that I need to turn this on? In 2.6.15 I was able to make a new stylesheet for my reports that had grid lines between the rows and columns. This makes it much easier to read the reports. In 5.10 the same steps are just putting bars over some of the rows. It has been a long time since I searched for answers to my questions, but I seem to remember that there is some place where there is a monthly compilation of the issues discussed here. If I could find it, maybe I could limit my questions to the group. TIA, Larry ___ 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. ___ 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] correct a mistake early
I created a name for my folder and did not set up a holder file to keep things out of my document folder. How do retreat back and do this properly? I am watching a video "How to setup gnucash business accounting files aka the chart of accounts via the the busy bee post. This is my mistake, but the video does not allow me to correct it. I would like to delete the file set up and then set it up properly as per the video. Thank youb³ -- Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, State Securities Board of TX, *www.bullish.org bbag...@bullish.org 972.BUL.LISH, 285.5474 landline*** ___ 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] correct a mistake early
If you just want to change the location of the data file on your disk, then you can either File -> Save As into the new location, or you can move the file to the new location and then File -> Open from the new location. It will not remove the old files from the old location, but you can move them yourself, safely. Hope this helps. -derek On Thu, January 9, 2025 11:35 am, bullish bob bagley via gnucash-user wrote: > I created a name for my folder and did not set up a holder file to keep > things out of my document folder. How do retreat back and do this > properly? I am watching a video "How to setup gnucash business > accounting files aka the chart of accounts via the the busy bee post. > This is my mistake, but the video does not allow me to correct it. I > would like to delete the file set up and then set it up properly as per > the video. Thank youb³ > > -- > Since 1989 Fully Disclosed Broker/Dealer SEC: MPID BOBS, FINRA, SIPC, > State Securities Board of TX, *www.bullish.org bbag...@bullish.org > 972.BUL.LISH, 285.5474 landline*** > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Budget Question and stylesheet question
Hi Larry/GnuCash users, There may be a few potential issues involved: - the data (which you mentioned that you entered manually) - the version of GnuCash - the data file (which might depend on which version of GnuCash that data file was started with, which is slightly separate from the data itself and the version of GnuCash) https://wiki.gnucash.org/wiki/Installation#Upgrading & https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade are some resources on what to do when upgrading. --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-08 20:15, larry johnston wrote: > Hi, > > I did not upgrade, I started new on a new machine. Then I entered all my data > manually. Thus I don't think it isn issue with data integrity. I am still > hoping there is something I haven't done properly or some option I haven't > turned on. > > Thanks for reaching out. > > Larry > > On Wed, Jan 8, 2025 at 2:02 PM Brad Morrison wrote: > >> Hi Larry & GNUCash users, >> >> "I just started using 5.10 on a new computer, Windows 11 and have run >> into two issues. I was previously running 2.6.15 in Windows 10." >> >> https://gnucash.org/download.phtml - the current version of GNUCash is >> 5.10, but there are some specific steps needed to take to ensure data >> integrity when upgrading between point versions (2 > 3, 3 > 4, 4 > 5). >> >> https://wiki.gnucash.org/wiki/Installation#Upgrading & >> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade >> are some resources on what to do when upgrading. >> >> --- >> Thanks, >> >> Brad - https://www.facebook.com/brad.morrison.12327/ & >> https://norcal.social/@BradMorrison >> >> On 2025-01-08 11:01, larry johnston wrote: >> >>> Hi, >>> >>> I have gone through a couple years of the list without finding an answer to >>> my questions. >>> >>> My companion who is running 4.14 on a Windows 11 computer ran into a >>> similar problem with her budget. her expenses were not populating in the >>> monthly totals at the bottom of the budget. It turns out that she had >>> entered zeros in some of her place holder accounts. Once she cleared those >>> lines the monthly totals populated correctly. I can't find any similar >>> problem in my budget. Any help is appreciated. >>> >>> TIA, >>> >>> Larry >>> >>> On Mon, Jan 6, 2025 at 2:11 AM David H wrote: >>> >>> Hi Larry, >>> >>> Can't help you with your budget questions but if you click the >>> lists.gnucash link at the bottom of the emails it will take you to here - >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which is agood >>> place to start searching or browsing previous postings. >>> >>> Cheers David H. >>> >>> On Mon, 6 Jan 2025 at 16:45, larry johnston wrote: >>> >>> Hi, >>> >>> I just started using 5.10 on a new computer, Windows 11 and have run into >>> two issues. I was previously running 2.6.15 in Windows 10. >>> >>> I set up my budget and everything seems good, except that the rows at the >>> very bottom, Income, Expense, Transfers and Total have not been populated, >>> so you can't see how your budget is doing for each period (month). These >>> would automatically populate in 2.6.15. Is there some place that I need to >>> turn this on? >>> >>> In 2.6.15 I was able to make a new stylesheet for my reports that had grid >>> lines between the rows and columns. This makes it much easier to read the >>> reports. In 5.10 the same steps are just putting bars over some of the >>> rows. >>> >>> It has been a long time since I searched for answers to my questions, but >>> I >>> seem to remember that there is some place where there is a monthly >>> compilation of the issues discussed here. If I could find it, maybe I >>> could >>> limit my questions to the group. >>> >>> TIA, >>> >>> Larry >>> ___ >>> 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. ___ gnuca
Re: [GNC] RE no suitable module found for a file
Hallo Bruce, For me libdbd-sqlite3 solved the problem, thank you. Op 9/01/2025 om 01:59 schreef Bruce Irving: Hi, Jean-Pierre Vandenbroucke. I also use GnuCash in MX-23 Linux based on bookworm (debian). GNC was 5.9. Last week, I had to re-install MX-23, When I finally got GNC installed, it turned out to be version 5.10. I also had a message of no back end. With the help of others, making sure that libdbd-mysql, libdbd-pgsql, libdbd-sqlite3 were installed on my system solved my problem, HTH Bruce Hallo, I switched recently from Linux Mint 22 to LMDE6. In Linux Mint 22 I used the version 1:5.5-1.2build1 from ubuntu noble/universe without problems. In LMDE6 the version was 1:4.13-1 from bookworm (debian). When I started GNUCASH in LMDE6 I received the following: "No suitable module found for file ...". I decided to delete 1:4.13-1 and to install 1:5.6-1~bpo12+1 from bookworm-backports. But when starting GNUCASH I receive the same message. It is only for the file in which I made transactions in Linux Mint 22 that I get the message "no suitable module found.." I have a file in which i made no transactions in Linux Mint 22 and this file opens without problem in LMDE6. How could I re-enter all my 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 - 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.
Re: [GNC] no suitable module found for a file
Hallo, Installing libdbd-sqlite3 solved the problem, thank you. Op 8/01/2025 om 22:07 schreef David Cousens: Jean-Pierre, Were you using one of the SQL backends to store your file in V5.5 on LM22. If so, it may be possible that the V5.6 on LMDE6 has been built without the database drivers. So you still have access to the Linux Mint22 system. If so run the File-Save As dialogue from the menu. At the top of the dialogue pane there is a selection box labelled data format which has the options: mysql postgres sqlite3 xml The existing setting of this will tell you what format the file was originally saved in. If it is in one of the first 3 formats the version on the new machine will need to have the SQL support libraries. If you check the same dialogue on your new machine, if it doesn't supply these options it has likely been built without the SQL drivers. Another way you can check for the drivers presence is to type the command "dpkg -l : grep dbi" into a terminal. If you have the database support installed it should indicate the following packages are installed: libdbi and at least one of libdbd-mysql libdbd-pgsql libdbd-sqlite3 If you select "xml" in the File->Save As dialogue, the file will be saved in xml format which can be opened in GnuCash when it has been built without SQL support. Give it an identifiable filename (e.g append "_xml" to the filename - you can delete this addition later). Copy this file to your new machine and then open it with the File->Open dialogue. If what I suspect is the problem you should be able to open it. David Cousens On Wed, 2025-01-08 at 11:25 +0100, Jean-Pierre Vandenbroucke wrote: Hallo, I switched recently from Linux Mint 22 to LMDE6. In Linux Mint 22 I used the version 1:5.5-1.2build1 from ubuntu noble/universe without problems. In LMDE6 the version was 1:4.13-1 from bookworm (debian). When I started GNUCASH in LMDE6 I received the following: "No suitable module found for file ...". I decided to delete 1:4.13-1 and to install 1:5.6-1~bpo12+1 from bookworm-backports. But when starting GNUCASH I receive the same message. It is only for the file in which I made transactions in Linux Mint 22 that I get the message "no suitable module found.." I have a file in which i made no transactions in Linux Mint 22 and this file opens without problem in LMDE6. How could I re-enter all my 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Budget Question and stylesheet question
Hi, To be clear, when you say more than one top level Asset account, you mean that there are two Asset accounts at the top of the Chart of Accounts. I have Assets and nested under that Cash, TFSA. RRIF etc. and under each of those the actual bank accounts etc. The same with Expenses, Income etc. So that does not seem to be the issue. Thanks, Larry On Thu, Jan 9, 2025 at 8:51 AM CWheeler via gnucash-user < gnucash-user@gnucash.org> wrote: > I have seen the budget issue happen when there is more than one > top-level Asset or Expense account in the book. It may occur with other > account types as well, but I haven't tested those scenarios. > > > Date: Wed, 8 Jan 2025 20:15:07 -0800 > > From: larry johnston > > To: Brad Morrison > > Cc: Gnucash Users > > Subject: Re: [GNC] Budget Question and stylesheet question > > Message-ID: > >z...@mail.gmail.com> > > Content-Type: text/plain; charset="UTF-8" > > > > Hi, > > > > I did not upgrade, I started new on a new machine. Then I entered all my > > data manually. Thus I don't think it isn issue with data integrity. I am > > still hoping there is something I haven't done properly or some option I > > haven't turned on. > > > > Thanks for reaching out. > > > > Larry > > > > On Wed, Jan 8, 2025 at 2:02?PM Brad Morrison > wrote: > > > >> Hi Larry & GNUCash users, > >> > >> "I just started using 5.10 on a new computer, Windows 11 and have run > >> into two issues. I was previously running 2.6.15 in Windows 10." > >> > >> https://gnucash.org/download.phtml - the current version of GNUCash is > >> 5.10, but there are some specific steps needed to take to ensure data > >> integrity when upgrading between point versions (2 > 3, 3 > 4, 4 > 5). > >> > >> https://wiki.gnucash.org/wiki/Installation#Upgrading & > >> > >> > https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade > >> are some resources on what to do when upgrading. > >> > >> --- > >> Thanks, > >> > >> Brad -https://www.facebook.com/brad.morrison.12327/ & > >> https://norcal.social/@BradMorrison > >> > >> On 2025-01-08 11:01, larry johnston wrote: > >> > >>> Hi, > >>> > >>> I have gone through a couple years of the list without finding an > answer > >> to > >>> my questions. > >>> > >>> My companion who is running 4.14 on a Windows 11 computer ran into a > >>> similar problem with her budget. her expenses were not populating in > the > >>> monthly totals at the bottom of the budget. It turns out that she had > >>> entered zeros in some of her place holder accounts. Once she cleared > >> those > >>> lines the monthly totals populated correctly. I can't find any similar > >>> problem in my budget. Any help is appreciated. > >>> > >>> TIA, > >>> > >>> Larry > >>> > >>> On Mon, Jan 6, 2025 at 2:11?AM David H wrote: > >>> > >>> Hi Larry, > >>> > >>> Can't help you with your budget questions but if you click the > >>> lists.gnucash link at the bottom of the emails it will take you to > here - > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which is > agood > >>> place to start searching or browsing previous postings. > >>> > >>> Cheers David H. > >>> > >>> On Mon, 6 Jan 2025 at 16:45, larry johnston > >> wrote: > >>> Hi, > >>> > >>> I just started using 5.10 on a new computer, Windows 11 and have run > into > >>> two issues. I was previously running 2.6.15 in Windows 10. > >>> > >>> I set up my budget and everything seems good, except that the rows at > >> the > >>> very bottom, Income, Expense, Transfers and Total have not been > >> populated, > >>> so you can't see how your budget is doing for each period (month). > These > >>> would automatically populate in 2.6.15. Is there some place that I need > >> to > >>> turn this on? > >>> > >>> In 2.6.15 I was able to make a new stylesheet for my reports that had > >> grid > >>> lines between the rows and columns. This makes it much easier to read > the > >>> reports. In 5.10 the same steps are just putting bars over some of the > >>> rows. > >>> > >>> It has been a long time since I searched for answers to my questions, > but > >>> I > >>> seem to remember that there is some place where there is a monthly > >>> compilation of the issues discussed here. If I could find it, maybe I > >>> could > >>> limit my questions to the group. > >>> > >>> TIA, > >>> > >>> Larry > >>> ___ > >>> 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
Re: [GNC] Budget Question and stylesheet question
Yes, that is what I mean. I looked at the screenshot you posted, and I notice that the total column entries on the right of the budget show the totals in C$. No idea whether that could be an issue, but I'd like to know how you made that happen. My budgets don't display any currency indicators. (I'm on an older version of GnuCash, that could also be the reason why I don't see it.) On 2025-01-09 02:48 p.m., larry johnston wrote: Hi, To be clear, when you say more than one top level Asset account, you mean that there are two Asset accounts at the top of the Chart of Accounts. I have Assets and nested under that Cash, TFSA. RRIF etc. and under each of those the actual bank accounts etc. The same with Expenses, Income etc. So that does not seem to be the issue. Thanks, Larry On Thu, Jan 9, 2025 at 8:51 AM CWheeler via gnucash-user wrote: I have seen the budget issue happen when there is more than one top-level Asset or Expense account in the book. It may occur with other account types as well, but I haven't tested those scenarios. > Date: Wed, 8 Jan 2025 20:15:07 -0800 > From: larry johnston > To: Brad Morrison > Cc: Gnucash Users > Subject: Re: [GNC] Budget Question and stylesheet question > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Hi, > > I did not upgrade, I started new on a new machine. Then I entered all my > data manually. Thus I don't think it isn issue with data integrity. I am > still hoping there is something I haven't done properly or some option I > haven't turned on. > > Thanks for reaching out. > > Larry > > On Wed, Jan 8, 2025 at 2:02?PM Brad Morrison wrote: > >> Hi Larry & GNUCash users, >> >> "I just started using 5.10 on a new computer, Windows 11 and have run >> into two issues. I was previously running 2.6.15 in Windows 10." >> >> https://gnucash.org/download.phtml - the current version of GNUCash is >> 5.10, but there are some specific steps needed to take to ensure data >> integrity when upgrading between point versions (2 > 3, 3 > 4, 4 > 5). >> >> https://wiki.gnucash.org/wiki/Installation#Upgrading & >> >> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade >> are some resources on what to do when upgrading. >> >> --- >> Thanks, >> >> Brad -https://www.facebook.com/brad.morrison.12327/ & >> https://norcal.social/@BradMorrison >> >> On 2025-01-08 11:01, larry johnston wrote: >> >>> Hi, >>> >>> I have gone through a couple years of the list without finding an answer >> to >>> my questions. >>> >>> My companion who is running 4.14 on a Windows 11 computer ran into a >>> similar problem with her budget. her expenses were not populating in the >>> monthly totals at the bottom of the budget. It turns out that she had >>> entered zeros in some of her place holder accounts. Once she cleared >> those >>> lines the monthly totals populated correctly. I can't find any similar >>> problem in my budget. Any help is appreciated. >>> >>> TIA, >>> >>> Larry >>> >>> On Mon, Jan 6, 2025 at 2:11?AM David H wrote: >>> >>> Hi Larry, >>> >>> Can't help you with your budget questions but if you click the >>> lists.gnucash link at the bottom of the emails it will take you to here - >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which is agood >>> place to start searching or browsing previous postings. >>> >>> Cheers David H. >>> >>> On Mon, 6 Jan 2025 at 16:45, larry johnston >> wrote: >>> Hi, >>> >>> I just started using 5.10 on a new computer, Windows 11 and have run into >>> two issues. I was previously running 2.6.15 in Windows 10. >>> >>> I set up my budget and everything seems good, except that the rows at >> the >>> very bottom, Income, Expense, Transfers and Total have not been >> populated, >>> so you can't see how your budget is doing for each period (month). These >>> would automatically populate in 2.6.15. Is there some place that I need >> to >>> turn this on? >>> >>> In 2.6.15 I was able to make a new stylesheet for my reports that had >> grid >>> lines between the rows and columns. This makes it much easier to read the >>> reports. In 5.10 the same steps are just putting bars over some of the >>> rows. >>> >>> It has been a long time since I searched for answers to my questions, but >>> I >>> seem to remember that there is some place where there is a monthly >>> compilation of the issues discussed here. If I could find it, maybe I >>> could >>> limit my questions to the group. >>>
Re: [GNC] correct a mistake early
Bob, No great problem. Create the folder and then locate the datafile, its backup and log files, i.e. anyfiles which have the base filename you gave the file e.g. .gnucash .gnucash..gnucash .gnucash..log where is a string with format "mmddhhmmss" e.g. .20250110060236 Any file .LCK can be deleted. When you next start GnuCash use the File->Open dialogue to navigate to the folder and the datafile in it and open it. After that GnuCash should remember where the file is on subsequent openings unless you open another data file. David Cousens On Thu, 2025-01-09 at 10:35 -0600, bullish bob bagley via gnucash-user wrote: > I created a name for my folder and did not set up a holder file to > keep > things out of my document folder. How do retreat back and do this > properly? I am watching a video "How to setup gnucash business > accounting files aka the chart of accounts via the the busy bee > post. > This is my mistake, but the video does not allow me to correct it. I > would like to delete the file set up and then set it up properly as > per > the video. Thank youb³ > ___ 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] Budget Question and stylesheet question
I am also seeing this in 5.10 on Win 10 - my test budget doesn't have any currency prefix whereas Larry's does for some reason ? Just posed this same question and then read your post here suggesting the same :-) Cheers David H. On Fri, 10 Jan 2025 at 05:58, CWheeler via gnucash-user < gnucash-user@gnucash.org> wrote: > Yes, that is what I mean. > > I looked at the screenshot you posted, and I notice that the total > column entries on the right of the budget show the totals in C$. No idea > whether that could be an issue, but I'd like to know how you made that > happen. My budgets don't display any currency indicators. (I'm on an > older version of GnuCash, that could also be the reason why I don't see > it.) > > On 2025-01-09 02:48 p.m., larry johnston wrote: > > Hi, > > > > To be clear, when you say more than one top level Asset account, you > > mean that there are two Asset accounts at the top of the Chart of > > Accounts. I have Assets and nested under that Cash, TFSA. RRIF etc. > > and under each of those the actual bank accounts etc. The same with > > Expenses, Income etc. So that does not seem to be the issue. > > > > Thanks, > > > > Larry > > > > On Thu, Jan 9, 2025 at 8:51 AM CWheeler via gnucash-user > > wrote: > > > > I have seen the budget issue happen when there is more than one > > top-level Asset or Expense account in the book. It may occur with > > other > > account types as well, but I haven't tested those scenarios. > > > > > Date: Wed, 8 Jan 2025 20:15:07 -0800 > > > From: larry johnston > > > To: Brad Morrison > > > Cc: Gnucash Users > > > Subject: Re: [GNC] Budget Question and stylesheet question > > > Message-ID: > > > > > > > > > Content-Type: text/plain; charset="UTF-8" > > > > > > Hi, > > > > > > I did not upgrade, I started new on a new machine. Then I > > entered all my > > > data manually. Thus I don't think it isn issue with data > > integrity. I am > > > still hoping there is something I haven't done properly or some > > option I > > > haven't turned on. > > > > > > Thanks for reaching out. > > > > > > Larry > > > > > > On Wed, Jan 8, 2025 at 2:02?PM Brad > > Morrison wrote: > > > > > >> Hi Larry & GNUCash users, > > >> > > >> "I just started using 5.10 on a new computer, Windows 11 and > > have run > > >> into two issues. I was previously running 2.6.15 in Windows 10." > > >> > > >> https://gnucash.org/download.phtml - the current version of > > GNUCash is > > >> 5.10, but there are some specific steps needed to take to > > ensure data > > >> integrity when upgrading between point versions (2 > 3, 3 > 4, > > 4 > 5). > > >> > > >> https://wiki.gnucash.org/wiki/Installation#Upgrading & > > >> > > >> > > > https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade > > >> are some resources on what to do when upgrading. > > >> > > >> --- > > >> Thanks, > > >> > > >> Brad -https://www.facebook.com/brad.morrison.12327/ & > > >> https://norcal.social/@BradMorrison > > >> > > >> On 2025-01-08 11:01, larry johnston wrote: > > >> > > >>> Hi, > > >>> > > >>> I have gone through a couple years of the list without finding > > an answer > > >> to > > >>> my questions. > > >>> > > >>> My companion who is running 4.14 on a Windows 11 computer ran > > into a > > >>> similar problem with her budget. her expenses were not > > populating in the > > >>> monthly totals at the bottom of the budget. It turns out that > > she had > > >>> entered zeros in some of her place holder accounts. Once she > > cleared > > >> those > > >>> lines the monthly totals populated correctly. I can't find any > > similar > > >>> problem in my budget. Any help is appreciated. > > >>> > > >>> TIA, > > >>> > > >>> Larry > > >>> > > >>> On Mon, Jan 6, 2025 at 2:11?AM David H wrote: > > >>> > > >>> Hi Larry, > > >>> > > >>> Can't help you with your budget questions but if you click the > > >>> lists.gnucash link at the bottom of the emails it will take > > you to here - > > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user which > > is agood > > >>> place to start searching or browsing previous postings. > > >>> > > >>> Cheers David H. > > >>> > > >>> On Mon, 6 Jan 2025 at 16:45, larry johnston< > larryej1...@gmail.com> > > >> wrote: > > >>> Hi, > > >>> > > >>> I just started using 5.10 on a new computer, Windows 11 and > > have run into > > >>> two issues. I was previously running 2.6.15 in Windows 10. > > >>> > > >>> I set up my budget and everything seems good, except that the > > rows at > > >> the > > >>> very bottom, Income, Expense, Transfers and Total have not be
