Re: [GNC] Unable to Refine Existing Search
Hi Derek, In the absence of tags in GnuCash, I thought I would use the *Number *field as a pseudo tag since I am not using it for anything else. So my search would be along the lines of *AFTER-dd/mm/yy AND BEFORE-dd/yy/mm AND CONTAINS-STRING-[tag]*. Then what I'd want to do it run the search again with the same date constraints but a different tag. So, it appears your answer means I will simply have to re-enter the date range every time. I am an absolute amateur when it comes to accounts, but it does seem to me that the GnuCash could be improved in this area. Tags would be great, as would a bit more flexibility on custom reports. Thank you for your answer. Kind wishes - Patrick On Wed, 15 May 2024 at 12:37, Derek Atkins wrote: > Hi, > > On Tue, May 14, 2024 3:24 am, Patrick Skelton wrote: > > Hi, > > > > If I do a *Find* in GnuCash using a handful of criteria, it does what I'd > > expect. > > > > If I then want to modify this existing *Find*, I cannot see how to do > > this. > > If I select the same operation again from the menu while the currently > > active tab contains my current find results, and then I click on either > > 'Refine current search' or 'Add results to current search', the original > > criteria I set are gone, so basically I am just doing a new search and > > have > > to enter all the criteria again. > > No, the initial criteria are still there -- just inaccessible. You're > just appending to them with an additional AND statement (refine) or OR > statement (add results). > > > > > Is there a way to modify the search criteria already used or perhaps even > > save a set of criteria so they can be re-run. > > No. > > > I realise what I am really wanting here is a custom report but I need it > > to > > contain only records containing a certain string and I can't see how to > > get > > the reporting to do this. > > Could you go into more details about what it is, exactly, you're trying to > do? > > > Kind wishes - Patrick > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >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.
[GNC] Unable to Refine Existing Search
Hi, If I do a *Find* in GnuCash using a handful of criteria, it does what I'd expect. If I then want to modify this existing *Find*, I cannot see how to do this. If I select the same operation again from the menu while the currently active tab contains my current find results, and then I click on either 'Refine current search' or 'Add results to current search', the original criteria I set are gone, so basically I am just doing a new search and have to enter all the criteria again. Is there a way to modify the search criteria already used or perhaps even save a set of criteria so they can be re-run. I realise what I am really wanting here is a custom report but I need it to contain only records containing a certain string and I can't see how to get the reporting to do this. Kind wishes - Patrick ___ 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] Account Hierarchy
Thank you for the reply, Frank. To take the second half of your reply first, there won’t be many products. I used the word ‘product’ for illustration; in actual fact, these are product groups or types. That said, your other suggestion, to treat shops as assets, is something I will look into. My accountancy knowledge is basic to say the least. I will attempt to find some reading material about this. Thank you for the suggestion. Kind wishes - Patrick On Fri, 3 May 2024 at 21:56, Frank Ciani wrote: > This is where Tags would be great. There are some work arounds to 'fake ' > tags into existence, but they are cumbersome to use - my opinion. > > Shop A and Shop B aren't income/expense accounts. They're locations > comparable to assets. > > Why not setup asset accounts for Shop A and B. Then sales by product and > expenses would be debited/credited to the appropriate Shop account. Then > it would be easy to generate Shop A reports vs. Shop B. > > Your proposed hierarchies would necessitate a lot of duplicate > income/expense accounts which would become a nightmare to maintain. > > Another question is how many products do you plan to have? If it's only a > few, I think you'll be OK. If it's a lot, perhaps you need a product that > has an inventory capability. > > > On Fri, May 3, 2024, 7:57 AM Patrick Skelton > wrote: > >> Hi, >> >> I am about to structure a new set of accounts for a business. GnuCash uses >> a hierarchy, which I am currently trying to decide upon. Two >> part-hierarchies come to mind: >> >> *FIRST* >> >> Sales >> >> Shop A >> >> Product 1 >> >> Product 2 >> >> Shop B >> >> Product 1 >> >> Product 2 >> >> >> *SECOND* >> >> Sales >> >> Product 1 >> >> Shop A >> >> Shop B >> >> Product 2 >> >> Shop A >> >> Shop B >> >> >> The first would make it easy to see sales for each shop but harder to find >> out the sales for each product. The second would make it easy to see sales >> for each product but harder to find out the sales for each shop. >> >> Both of these seem like reasonable questions to be able to ask of the >> accounts. How do I choose which hierarchy to go with and is there any way >> I >> can answer both of these questions? >> >> Any advice would be most welcome as I am no accounting expert and have >> only >> basic knowledge of GnuCash. >> >> Kind wishes - Patrick >> ___ >> 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] Account Hierarchy
Hi, I am about to structure a new set of accounts for a business. GnuCash uses a hierarchy, which I am currently trying to decide upon. Two part-hierarchies come to mind: *FIRST* Sales Shop A Product 1 Product 2 Shop B Product 1 Product 2 *SECOND* Sales Product 1 Shop A Shop B Product 2 Shop A Shop B The first would make it easy to see sales for each shop but harder to find out the sales for each product. The second would make it easy to see sales for each product but harder to find out the sales for each shop. Both of these seem like reasonable questions to be able to ask of the accounts. How do I choose which hierarchy to go with and is there any way I can answer both of these questions? Any advice would be most welcome as I am no accounting expert and have only basic knowledge of GnuCash. Kind wishes - Patrick ___ 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] Another Beginner Accounting Question
Hi, Just when I was thinking I had accumulated all the pieces of the jigsaw I need, I discovered the A/R account. I have a shop that charges 50% margin on whatever they sell. So, if they sell one candle for £12 then I will invoice them only for £6. They get 30 days credit, so ideally I'd use the A/R system. I've played around with this and it seems to do what I expect to the Balance Sheet and Profit & Loss Report except for one thing: I seem to lose any record of the 50% of the total sales value that they have taken. There is a Discount column in the invoice but this doesn't seem to show up anywhere in the accounts. I'd like to have some record of the money I am 'losing' in sales commission, maybe as an expense. Can anyone offer any advice on how this might best be approached, please? Kind wishes - Patrick ___ 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] Beginner Accounting Question
Hi, I'm steadily 'getting' the double-entry idea. In my accounts (which I have just begun experimenting with), I have an account that is called 'Personal Money Used'. This is of type Cash. I use this account when I use my own personal account (i.e. nothing to do with the business) to buy something for the business. I have two questions about this account: 1. What is the correct parent account for this? It feels to me like it is a Liability - money the business owes me but I suspect liabilities are debts to external entities (i.e. not me, the business owner). 2. Would I be better accounting for such purchases simply as money I put into the business (i.e. as an increase in Owner's Equity)? I'm trying hard to get into this but can't afford to pay for professional lessons so any help at all would be very welcome. Kind wishes - Patrick ___ 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] Beginner Accounting Question Using GnuCash
Thank you everyone for those replies. They have been extraordinarily helpful. It is amazing how, when asking a question about something specific, a single sentence or even just a phrase in the reply can cause a lightbulb moment. I now have a much clearer understanding of how the basic mechanics of this work. I think next task is to play with some reports, to see if I can answer the questions I might like to ask at the end of the year. - Patrick On Fri, 17 Dec 2021 at 17:41, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 12/17/2021 6:48 AM, Patrick Skelton wrote: > > Hi, David, > > > > Thank you for that. I have actually just kind-of worked that bit out but > I > > would like the £8 spent on paper to become an asset. Is it simply then a > > case of entering a transfer from Expenses-Stock Purchases to Assets - > Stock > > on Hand? > > > > Kind wishes - Patrick > > You were doing it correctly, Patrick. Your example appears to be a > "stationery" business, so you correctly had the purchase of paper go > into an asset "inventory" rather than being an expense. You also did the > sales transaction correctly, recording not just the part with the > customer but the part where you are now decreasing inventory and > recording an expense for the cost of that pad sold. > > 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 > 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] Beginner Accounting Question Using GnuCash
Hi, David, Thank you for that. I have actually just kind-of worked that bit out but I would like the £8 spent on paper to become an asset. Is it simply then a case of entering a transfer from Expenses-Stock Purchases to Assets - Stock on Hand? Kind wishes - Patrick On Fri, 17 Dec 2021 at 11:40, David H wrote: > Patrick, > > Look carefully at point 2, one side of your transaction should be an > expense as you are expending funds to buy stock eg Expense >> Stock > Purchases rather than Stock on Hand ? > > Cheers David H > > > > On Fri, 17 Dec 2021 at 21:20, Patrick Skelton > wrote: > >> Hi, >> >> I am trying to get my head around double-entry accounting. I think I have >> kind-of got it. I have just set up a stripped down set of accounts and >> tried a handful of transactions, to see how they affect profit-and-loss >> and >> the balance sheet. It all seems to make sense except that there is one >> piece of information that seems to vanish, and I am worried this means I >> am >> doing something wrong. >> >> My transactions beginning with all zero balances are: >> >> (N*ote:* I have added some dates to give context to my later question) >> >>1. 1st Nov: I pay £100 into the business *Bank* financed by *Owner's >>Equity*. >>2. 2nd Nov: I buy some paper costing £12, which comes from *Bank* and >>goes into *Stock on Hand*. >>3. 3rd Dec: I sell a notepad for £12, which credits *Bank* and is >>assigned to *Income - Sales*. >>4. 4th Dec: I transfer the cost of the paper used to make the notepad >>(£1.00) from *Stock on Hand* to *Expenses - Cost of Materials*. >> >> The Balance Sheet shows £111. Liabilities are zero. Retained Earnings are >> £11, which gives total equity of £111. Thus the sheet is balanced. >> >> My question is that no matter what report I run using whatever dates, I >> cannot see the £12 I spent on stock. All I ever see is the £1 that I >> decided was the cost of the paper taken from stock. >> >> Even if I do reports only for the month of November, I don't see the £12 I >> paid for stock because the money came from my bank and went into stock, >> which are both Asset accounts. >> >> Is there a better way to do these transactions so that I could ask the >> question: how much have I spent on stock this month? >> >> I am a complete newbie so would welcome any help or advice (short of 'get >> an accountant', which I would love to but can't afford). >> >> Kind wishes - Patrick >> ___ >> 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] Beginner Accounting Question Using GnuCash
Hi, I am trying to get my head around double-entry accounting. I think I have kind-of got it. I have just set up a stripped down set of accounts and tried a handful of transactions, to see how they affect profit-and-loss and the balance sheet. It all seems to make sense except that there is one piece of information that seems to vanish, and I am worried this means I am doing something wrong. My transactions beginning with all zero balances are: (N*ote:* I have added some dates to give context to my later question) 1. 1st Nov: I pay £100 into the business *Bank* financed by *Owner's Equity*. 2. 2nd Nov: I buy some paper costing £12, which comes from *Bank* and goes into *Stock on Hand*. 3. 3rd Dec: I sell a notepad for £12, which credits *Bank* and is assigned to *Income - Sales*. 4. 4th Dec: I transfer the cost of the paper used to make the notepad (£1.00) from *Stock on Hand* to *Expenses - Cost of Materials*. The Balance Sheet shows £111. Liabilities are zero. Retained Earnings are £11, which gives total equity of £111. Thus the sheet is balanced. My question is that no matter what report I run using whatever dates, I cannot see the £12 I spent on stock. All I ever see is the £1 that I decided was the cost of the paper taken from stock. Even if I do reports only for the month of November, I don't see the £12 I paid for stock because the money came from my bank and went into stock, which are both Asset accounts. Is there a better way to do these transactions so that I could ask the question: how much have I spent on stock this month? I am a complete newbie so would welcome any help or advice (short of 'get an accountant', which I would love to but can't afford). Kind wishes - Patrick ___ 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 by Value No Longer Seems to Work
Hi, I've been using GnuCash for years and generally found it to be excellent. In the past, I have never had any problem with using the Find feature. Now, however, when I try a find-by-value, nothing is ever shown in the results. I enter *Value -> has credits of debits -> equal to -> AMOUNT* and enter an amount that I can see quite clearly in different accounts and nothing is ever shown in the results box. Can anyone suggest what I may be doing wrong? Kind wishes - Patrick ___ 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.
[sqlite] How do I insert a record in an SQLite table only if the row does not already exist?
Hi, I am wanting to create an 'atomic' SQL script that will insert a record into a table only if the supplied record's primary key does not already exist, thus avoiding the constraint exception that occurs if the insert goes ahead. I have the following script which is wrong. I get an error saying the syntax is wrong near the 'WHERE'. *BEGIN EXCLUSIVE TRANSACTION;* *INSERT INTO NetworkLocks* *(* * PK_id,* * owner_username,* * unique_identifier,* * creation_time* *)* *VALUES* *(* * @ID,* * @owner_username,* * @unique_identifier,* * @creation_time* *)* *WHERE NOT EXISTS* * ( SELECT * FROM NetworkLocks nl WHERE nl.PK_id = @ID );* *END TRANSACTION;* Currently, my code works by relying on the uniqueness of the primary key (PK_id) and catch any exception. This is, however, a foreseeable error. It happens in normal operation. I'm not fond of exceptions for this situation. I was hoping to change the SQL script so that it always runs to completion but somehow returns a result. Perhaps the number of rows affected might be zero instead of one? Any help or advice would be very much appreciated. Also, as a newbie to SQLite, I am finding it difficult to get a handle on how to put together more complex queries. There are plenty of example on the internet of simple scripts, but it is difficult to know how to move beyond the basics. Any pointers to good sources of learning for this would be great. Kind wishes ~ Patrick ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Problem Creating Custom Shape
Hi, I attempted to follow the instructions to create a custom shape, but it has a problem. I created my shape and exported it by extension as a shape. I created a new sheet and then added my shape to the new sheet. The thumbnail of the new shape looks correct and I can drag it onto the canvas. When I do this, it has the 8 handles around it, but there is nothing inside the handles, no matter how big I drag them. Does anyone have any idea what I may be doing wrong? Kind wishes ~ Patrick ___ dia-list mailing list dia-list@gnome.org https://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
[users] Problem applying style.
Hi, I have just started using OpenOffice, and am having a very frustrating difficulty that I don't seem to be able to find an answer for in the FAQs. In the hope you can help, here goes: If I create a paragraph of text, I seem to be unable to apply a style to words within the paragraph without it styling the entire paragraph. For example: This is a paragraph of text. This is a paragraph of text. I want to apply a style to one individual word HERE. This is a paragraph of text. This is a paragraph of text. This is a paragraph of text. This is a paragraph of text. This is a paragraph of text. This is a paragraph of text. I create a style in the style menu, highlight the word 'HERE' and double-click the style. The result is that the style is applied to the whole paragraph. Any help would be very much appreciated. Best Wishes, Patrick Skelton
[users] Open Office 2.2 Question
Hi, I am a complete newbie to Open Office. Can you tell me how to remove a Note once it has been inserted? Nothing I do seems to have any effect on it. Best Wishes, Patrick Skelton
