Re: [GNC] Unable to Refine Existing Search

2024-05-17 Thread Patrick Skelton
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 h

[GNC] Unable to Refine Existing Search

2024-05-15 Thread Patrick Skelton
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

Re: [GNC] Account Hierarchy

2024-05-04 Thread Patrick Skelton
an 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

[GNC] Account Hierarchy

2024-05-03 Thread Patrick Skelton
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

[GNC] Another Beginner Accounting Question

2021-12-22 Thread Patrick Skelton
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

[GNC] Beginner Accounting Question

2021-12-21 Thread Patrick Skelton
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

Re: [GNC] Beginner Accounting Question Using GnuCash

2021-12-18 Thread Patrick Skelton
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 wrot

Re: [GNC] Beginner Accounting Question Using GnuCash

2021-12-17 Thread Patrick Skelton
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

[GNC] Beginner Accounting Question Using GnuCash

2021-12-17 Thread Patrick Skelton
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

[GNC] Find by Value No Longer Seems to Work

2021-04-08 Thread Patrick Skelton
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

[sqlite] How do I insert a record in an SQLite table only if the row does not already exist?

2017-12-21 Thread Patrick Skelton
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

Problem Creating Custom Shape

2015-01-30 Thread Patrick Skelton
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.

[users] Problem applying style.

2007-05-24 Thread Patrick Skelton
. 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

2007-05-15 Thread Patrick Skelton
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