Re: [GNC] Finance::Quote started multiplying prices by 100

[Bruce Schuck]

On 9/19/24 8:06 AM, aeg wrote:

Perhaps I should have mentioned in my original post that I had 
previously been downloading quotes on my old laptop, which is running

 GnuCash version 4.12 on Windows 10 with Finance::Quote version
1.5301 installed, so presumably something has changed since those
versions were current.


Alan,

In 1.45 Alphavantage started dividing all .L pricing data by 100. Which 
means securities traded in British Pounds were reported as 1/10 their 
actual value. The ".X" workaround was officially released in v1.58 on 
2023-08-12. I'm somewhat surprised you didn't notice incorrect pricing 
for London Exchange securities that traded in Pounds.


Bruce S.
___
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] Finance::Quote started multiplying prices by 100

[aeg via gnucash-user]

 Hi Bruce,
While using F::Q version 1.5301, the quoted prices always matched the figures 
obtained elsewhere, and GnuCash displayed those figures in GB Pounds, so all 
was well. It was only when I transferred my GC file to the computer running GC 
version 5.4 and F::Q version 1.62 that I started to see prices that were 100 
times greater than they should be.
Regards,Alan G



On Thursday 19 September 2024 at 20:37:07 BST, Bruce Schuck 
 wrote:  
 
 On 9/19/24 8:06 AM, aeg wrote:

> Perhaps I should have mentioned in my original post that I had 
> previously been downloading quotes on my old laptop, which is running
>  GnuCash version 4.12 on Windows 10 with Finance::Quote version
> 1.5301 installed, so presumably something has changed since those
> versions were current.

Alan,

In 1.45 Alphavantage started dividing all .L pricing data by 100. Which 
means securities traded in British Pounds were reported as 1/10 their 
actual value. The ".X" workaround was officially released in v1.58 on 
2023-08-12. I'm somewhat surprised you didn't notice incorrect pricing 
for London Exchange securities that traded in Pounds.

Bruce S.
  
___
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] Database storage

[Roberts K]

Blast from the past,
Yes, I do remember when 200mb hard drive was quite big harddrive to buy in
the shop. I was fairly young man then :-D. But W541 is pretty sweet
machine. I run linux on P70 and do not foresee the need to change it
anytime soon.
Roberts



> Now this Lenovo work station I am sitting at is ancient. The W541's were
> the last of the W series. Still, this little thing I v=can pick up and
> carry around has HUNDREDS of times as much capacity as those three 3350
> hard drives and it has many gbytes of core, enough to load into core
> that entire database several times.

--
Dr Roberts Klotins



On Thu, 19 Sept 2024 at 17:32, Michael or Penny Novack via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 9/19/2024 11:16 AM, Roberts K wrote:
> > In my experience the amount of data is relatively small (even for
> thousands
> > of records)
>
> A bit of historical perspective is needed, particularly because our
> heads have not yet absorbed a fundamental change in technology.
>
> Back in my working days, the IBM 3350's (hard drives) held somewhat over
> 300 mbytes each and our programs on the mainframe had about 10 mbytes
> core (the OS took about 6 mbytes from every program's virtual space.
>
> So a large database might span three drives and only a tiny bit of it at
> a time could fit into core.
>
> Now this Lenovo work station I am sitting at is ancient. The W541's were
> the last of the W series. Still, this little thing I v=can pick up and
> carry around has HUNDREDS of times as much capacity as those three 3350
> hard drives and it has many gbytes of core, enough to load into core
> that entire database several times.
>
> We (NOW) load entire databases into core because we can. We didn't
> before because we couldn't (and the ones that did work that way could
> only handle small databases)
>
> Michael
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] How to treat a sale which involves more accounts?

[Boniforti Flavio]

Hi David and David :-)
Thanks for your replies.
I'm not running any business at all. I am a musician who also collects
(vintage) music instruments. As I also do play them, it happens a couple of
times a year that I'm not interested anymore in keeping one or the other
instrument. For this reason, I sell a couple of items a year and given the
fact that the majority of my items are "vintage" ones, prices are always
fluctuating. So I want to keep track of how much I've gained (or lost) when
selling an item.
Given the above, I think that if I would only use a single "Music
equipment" account, I could not see how much I made (plus or minus) while
selling some items - right? This is the reason which led me to think
about setting up some accounts to "correctly" keep track of this all.

Using this:
1. Debit the Checking account for the total amount of the purchase paid by
the customer;
2. Credit the Income:Sales account by the total amount of the purchase;
3. Credit the Inventory: MusicEquipment Sales account by the amount of the
cost of the items sold;
4. Debit the Expenses:Cost of Goods Sold account by the amount of the
cost of the items sold.

I would do the following when selling something for 120 which I bought for
100:
1. increase the checking account by 120;
2. increase the "Income:Sales" account by 120;
3. increase the "Inventory:Music Equipment Sales" account by 120;
4. decrease the "Expenses:Cost of Goods Sold" account by 100.

(of course previoulsy I'd had increased the "Inventory:Music Equipment
Purchases" and decreased my "Assets:Checking Account" by 100).

Am I correct with the above?
TIA,
F.


https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Do., 19. Sept. 2024 um 03:52 Uhr schrieb David Cousens <
davidcousen...@gmail.com>:

> Flavio,
>
> Why would you need a Music equipment sold account in the first place?
>
> If your business is making music then:
>
> when you buy equipment you credit your checking account and debit the
> Music Equipment asset account by the amount of the purchase;
> when you sell the equipment you debit your checking account and credit
> the music equipment account.
>
> In this case the equipment is not held for the purpose of selling it at
> a profit. You may however be subject to capital gains type taxes if
>  they apply in your jurisdiction and the value of the equipment sold
> exceeds the thresholds for such taxes.
>
> The situation may however be slightly different if your business is
> actually retailing music equipment. In this case the Music Equipment
> account is essentially an Inventory account - still an asset account.
>
> You would normally in these circumstances set up an Inventory asset
> account which is a placeholder with two sub accounts Inventory:Music
> Equipment Purchases and Inventory:Music Equipment Sales. Your Income
> top level account will also need a subaccount Income:Sales and your
> Expenses top level acoount will need a sub account Expenses:Cost of
> Goods Sold (GoGS)
>
> The basic procedure is the same for purchases of equipment, credit the
> checking account and debit the Music Equipment Purchases sub account.
>
> When you make a sale only the difference between the cost of the
> equipment sold and the selling price is your income ( neglecting  any
> sales tax issues which may also apply) so the following will be the
> basic procedure:
>
> Debit the Checking account for the total amount of the purchase paid by
> the customer;
> Credit the Income:Sales account by the total amount of the purchase;
> Credit the Inventory: MusicEquipment Sales account by the amount of the
> cost of the items sold;
> Debit the Expenses:Cost of Goods Sold account by the amount of the
> cosdt of the items sold.
>
> Your profit on the transaction is recorde by the difference between the
> Income:Sales account and the Expenses:Cost of Goods Sold account
> entries.
>
> Dealing with any applicable taxes will add additional steps to the
> accounting as will making allowances returns of purchases to
> suppliersof faulty equipment and returns of equipment to you with
> faults by customers. You should consult an accountant and consumer
> legislation in your jurisdiction in how to deal with these.
>
> David Cousens
>
> On Wed, 2024-09-18 at 23:37 +0200, Boniforti Flavio wrote:
> > Hi.
> > Still very noob here, so bear with me please.
> >
> > I've got the following accounts (among others):
> >
> > Music equipment
> > Music equipment sold
> > Checking account
> >
> > When I buy music equipment, I take the money from my checking account
> > and
> > add it to the "music equipment" account.
> > When I sell music equipment, how should I register it? I thought that
> > the
> > account "music equipment" would decrease by the sold value, the
> > checking
> > account would increase by the same amount... but what happens with
> > the
> > "Music equipment sold" account?
> > Or am I wrong in separating "music equipment" from "musi

Re: [GNC] Database storage

[Steve Butler]

My first job out of college had a Honeywell 115 Mod 2 box.  Hard drive
(singular) was 10 MB.  RAM was 32K of magnetic core.  6 bit CPU and 7 track
556 bpi tape (3 of them).

Thought we were going to heaven when it was replaced by an HP 3000 with 7
hard drives of 47 MB each and 512 KB memory.

The phone I'm typing this on is many times more powerful than that!



On Thu, Sep 19, 2024, 12:20 Roberts K  wrote:

> Blast from the past,
> Yes, I do remember when 200mb hard drive was quite big harddrive to buy in
> the shop. I was fairly young man then :-D. But W541 is pretty sweet
> machine. I run linux on P70 and do not foresee the need to change it
> anytime soon.
> Roberts
>
>
>
> > Now this Lenovo work station I am sitting at is ancient. The W541's were
> > the last of the W series. Still, this little thing I v=can pick up and
> > carry around has HUNDREDS of times as much capacity as those three 3350
> > hard drives and it has many gbytes of core, enough to load into core
> > that entire database several times.
>
> --
> Dr Roberts Klotins
>
>
>
> On Thu, 19 Sept 2024 at 17:32, Michael or Penny Novack via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > On 9/19/2024 11:16 AM, Roberts K wrote:
> > > In my experience the amount of data is relatively small (even for
> > thousands
> > > of records)
> >
> > A bit of historical perspective is needed, particularly because our
> > heads have not yet absorbed a fundamental change in technology.
> >
> > Back in my working days, the IBM 3350's (hard drives) held somewhat over
> > 300 mbytes each and our programs on the mainframe had about 10 mbytes
> > core (the OS took about 6 mbytes from every program's virtual space.
> >
> > So a large database might span three drives and only a tiny bit of it at
> > a time could fit into core.
> >
> > Now this Lenovo work station I am sitting at is ancient. The W541's were
> > the last of the W series. Still, this little thing I v=can pick up and
> > carry around has HUNDREDS of times as much capacity as those three 3350
> > hard drives and it has many gbytes of core, enough to load into core
> > that entire database several times.
> >
> > We (NOW) load entire databases into core because we can. We didn't
> > before because we couldn't (and the ones that did work that way could
> > only handle small databases)
> >
> > Michael
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> 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] dollar signs in reports

[Murugan Mariappan]

You cannot remove the sign altogether.  Can you explain the use case




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Ian 
D Henry 
Sent: 19 September 2024 20:44
To: gnucash-user@gnucash.org 
Subject: [GNC] dollar signs in reports

I would like to suppress the dollar sign in my income statement and balance
sheet.  How can I do that?

--
Ian D Henry
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C3a181a4f06324f4a173508dcd9053a93%7C84df9e7fe9f640afb435%7C1%7C0%7C638623863758454045%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=%2F%2Fp%2FS%2BhE6Jys7MlxDvMfEQqNd1doNen4gH72bc%2FtaLw%3D&reserved=0
-
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] Database storage

[Bruce Griffis]

Slightly off topic. In my earliest working days we had a Honeywell 
mainframe, were bringing in an IBM mainframe and had a Tandem system for 
airline reservations. The Tandem wrote to two different disks at the 
same time so if there was ever a failure, no data would be lost. One day 
I came in and heard reports that the Tandem was down. It was on raised 
floor, and some large tiles had been removed so someone could run cable 
on the floor. The cleaning crew had bumped into a Tandem and knocked it 
into the open space on the raised floor. The Tandem was down! By about 
12 inches if I remember correctly.


On 9/19/24 12:31, Michael or Penny Novack via gnucash-user wrote:

On 9/19/2024 11:16 AM, Roberts K wrote:
In my experience the amount of data is relatively small (even for 
thousands

of records)


A bit of historical perspective is needed, particularly because our 
heads have not yet absorbed a fundamental change in technology.


Back in my working days, the IBM 3350's (hard drives) held somewhat 
over 300 mbytes each and our programs on the mainframe had about 10 
mbytes core (the OS took about 6 mbytes from every program's virtual 
space.


So a large database might span three drives and only a tiny bit of it 
at a time could fit into core.


Now this Lenovo work station I am sitting at is ancient. The W541's 
were the last of the W series. Still, this little thing I v=can pick 
up and carry around has HUNDREDS of times as much capacity as those 
three 3350 hard drives and it has many gbytes of core, enough to load 
into core that entire database several times.


We (NOW) load entire databases into core because we can. We didn't 
before because we couldn't (and the ones that did work that way could 
only handle small databases)


Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
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] Credit cards - how to deal with those?

[Boniforti Flavio]

Hi and thanks for your replies.
I've gone through the tutorial chapter 7 and I think it's much clearer now.
I'll try setting up the corresponding accounts and playing with them a bit
to understand.

Many thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Do., 19. Sept. 2024 um 18:57 Uhr schrieb R Losey :

> The other account is what you purchased... usually an expense category.
> Food? Dining? Clothing? Entertainment? It depends upon the expense accounts
> you have set up, but it should answer the question "what did you use your
> credit card to buy?"
>
>
>
> On Wed, Sep 18, 2024 at 5:08 PM Boniforti Flavio 
> wrote:
>
>> Hi Greg and thanks for your reply.
>> Indeed I see that I already have an account called "Credit Card", which
>> type is in fact "Credit Card".
>> I was trying to "simulate" such a transaction and I got stuck already:
>> after entering the amount in the "Charge" column, I don't know which
>> account I should select from the "Transfer" column. What would be the
>> correct one?
>>
>> Thanks,
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mi., 18. Sept. 2024 um 23:56 Uhr schrieb fromvendor <
>> fromven...@outtacyte.com>:
>>
>> > Hi there,
>> >
>> > I have my Credit Cards set up each to its own account of type liability
>> > (because I owe it eventually) under a parent placeholder called "Credit
>> > Cards".
>> >
>> > Each transaction goes into the account appropriate for the card in
>> > question.  When I get the statement (download, however), I reconcile the
>> > card and match up receipts.  Once that is done, I "Pay" the card (check,
>> > EFT, however) from my bank account.  That reduces the balance in the CC
>> > account (backwards as it's a liability) and also reduces my bank
>> account.
>> >
>> > Note there are options on how to display a CC type account, I have it
>> so I
>> > enter the transactions on the "Charge" column and the payment in the
>> > "Payment" column.  It's still Debit and Credits fundamentally so it
>> works
>> > out.
>> >
>> > Anyway, I hope that helps.
>> > -greg
>> >
>> > -Original Message-
>> > From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=
>> > outtacyte@gnucash.org] On Behalf Of Boniforti Flavio
>> > Sent: Wednesday, September 18, 2024 4:43 PM
>> > To: gnucash-user@gnucash.org
>> > Subject: [GNC] Credit cards - how to deal with those?
>> >
>> > ... and another question from a noob: how to deal with credit card
>> > transactions?
>> > I usually would register it the day that I've done the transaction, so
>> that
>> > I can trace each single credit card transaction. Of course I know that
>> the
>> > money has not yet been deducted - it will happen once a month when the
>> > credit card invoice is emitted. But if I would register *only* the
>> credit
>> > card invoice, I would lose track of each individual transaction - right?
>> > So what (for a private individual - no business case here) would be the
>> > most appropriate way to handle this?
>> >
>> > TIA,
>> > F.
>> >
>> > https://www.instagram.com/boniforti_music
>> > https://soundcloud.com/boniforti_music
>> > https://bonny-j.bandcamp.com
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > 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.
>>
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
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] How to treat a sale which involves more accounts?

[David Cousens]

Flavio,

> I would do the following when selling something for 120 which I
bought for 100:
> 1. increase the checking account by 120;
> 2. increase the "Income:Sales" account by 120;
> 3. increase the "Inventory:Music Equipment Sales" account by 120;
> 4. decrease the "Expenses:Cost of Goods Sold" account by 100.

These steps are not correct . Your inventory account records the value
(at cost) of the items you are holding so the entry on sale o an item
should equal the cost at purchaser  so you your transaction to record
it should be:

1 . increase (debit) the checking account by 120
2. increase (credit) the Income:Sales account by 120
3. decrease (credit) the Inventory:Music Equipment Sales account  by
100
4. increase (debit) the Expenses: Cost of Goods Sold account by 100


The Inventory:Music Equipment Sales account is what is known in
accounting terms as a contra account to the Music Equipment Purchases
 which is why it is credited to decrease the balance of Inventory
(rather than debit as is usual to increase the balance of an asset
account).  I have added the usual accounting column headings in
brackets. Of the two columns with entries in themthe Debit column is
always the first and the Credit column is always the second followed by
the Balance colum last.

Note that in any transaction  the sums of all the debit and all the
credit entries have to be equal, which was not the case for your
proposed entries.

Cheers
David


On Thu, 2024-09-19 at 21:52 +0200, Boniforti Flavio wrote:
> Hi David and David :-)
> Thanks for your replies.
> I'm not running any business at all. I am a musician who also
> collects (vintage) music instruments. As I also do play them, it
> happens a couple of times a year that I'm not interested anymore in
> keeping one or the other instrument. For this reason, I sell a couple
> of items a year and given the fact that the majority of my items are
> "vintage" ones, prices are always fluctuating. So I want to keep
> track of how much I've gained (or lost) when selling an item.
> Given the above, I think that if I would only use a single "Music
> equipment" account, I could not see how much I made (plus or minus)
> while selling some items - right? This is the reason which led me to
> think about setting up some accounts to "correctly" keep track of
> this all.
> 
> Using this:
> 1. Debit the Checking account for the total amount of the purchase
> paid by
> the customer;
> 2. Credit the Income:Sales account by the total amount of the
> purchase;
> 3. Credit the Inventory: MusicEquipment Sales account by the amount
> of the
> cost of the items sold;
> 4. Debit the Expenses:Cost of Goods Sold account by the amount of the
> cost of the items sold.
> 
> I would do the following when selling something for 120 which I
> bought for 100:
> 1. increase the checking account by 120;
> 2. increase the "Income:Sales" account by 120;
> 3. increase the "Inventory:Music Equipment Sales" account by 120;
> 4. decrease the "Expenses:Cost of Goods Sold" account by 100.
> 
> (of course previoulsy I'd had increased the "Inventory:Music
> Equipment Purchases" and decreased my "Assets:Checking Account" by
> 100).
> 
> Am I correct with the above?
> TIA,
> F.
> 
> 
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
> 
> 
> Am Do., 19. Sept. 2024 um 03:52 Uhr schrieb David Cousens
> :
> > Flavio,
> > 
> > Why would you need a Music equipment sold account in the first
> > place?
> > 
> > If your business is making music then:
> > 
> > when you buy equipment you credit your checking account and debit
> > the
> > Music Equipment asset account by the amount of the purchase;
> > when you sell the equipment you debit your checking account and
> > credit
> > the music equipment account.
> > 
> > In this case the equipment is not held for the purpose of selling
> > it at
> > a profit. You may however be subject to capital gains type taxes if
> >  they apply in your jurisdiction and the value of the equipment
> > sold
> > exceeds the thresholds for such taxes.
> > 
> > The situation may however be slightly different if your business is
> > actually retailing music equipment. In this case the Music
> > Equipment
> > account is essentially an Inventory account - still an asset
> > account.
> > 
> > You would normally in these circumstances set up an Inventory asset
> > account which is a placeholder with two sub accounts
> > Inventory:Music
> > Equipment Purchases and Inventory:Music Equipment Sales. Your
> > Income
> > top level account will also need a subaccount Income:Sales and your
> > Expenses top level acoount will need a sub account Expenses:Cost of
> > Goods Sold (GoGS)
> > 
> > The basic procedure is the same for purchases of equipment, credit
> > the
> > checking account and debit the Music Equipment Purchases sub
> > account. 
> >  
> > When you make a sale only the difference between the cost of the
> > equipment sold and the selling price is

Re: [GNC] Database storage

[Kalpesh Patel]

Anyone remembers Commodore PET and C64? 64MB or less of core and of course big 
whopping modern 3.5 inch 1.44MB floppy drives? 

load "asteroid",8,1



-Original Message-
From: Roberts K  
Sent: Thursday, September 19, 2024 3:18 PM
To: stepbystepf...@comcast.net
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Database storage

Blast from the past,
Yes, I do remember when 200mb hard drive was quite big harddrive to buy in the 
shop. I was fairly young man then :-D. But W541 is pretty sweet machine. I run 
linux on P70 and do not foresee the need to change it anytime soon.
Roberts



> Now this Lenovo work station I am sitting at is ancient. The W541's 
> were the last of the W series. Still, this little thing I v=can pick 
> up and carry around has HUNDREDS of times as much capacity as those 
> three 3350 hard drives and it has many gbytes of core, enough to load 
> into core that entire database several times.

--
Dr Roberts Klotins



On Thu, 19 Sept 2024 at 17:32, Michael or Penny Novack via gnucash-user < 
gnucash-user@gnucash.org> wrote:

> On 9/19/2024 11:16 AM, Roberts K wrote:
> > In my experience the amount of data is relatively small (even for
> thousands
> > of records)
>
> A bit of historical perspective is needed, particularly because our 
> heads have not yet absorbed a fundamental change in technology.
>
> Back in my working days, the IBM 3350's (hard drives) held somewhat 
> over
> 300 mbytes each and our programs on the mainframe had about 10 mbytes 
> core (the OS took about 6 mbytes from every program's virtual space.
>
> So a large database might span three drives and only a tiny bit of it 
> at a time could fit into core.
>
> Now this Lenovo work station I am sitting at is ancient. The W541's 
> were the last of the W series. Still, this little thing I v=can pick 
> up and carry around has HUNDREDS of times as much capacity as those 
> three 3350 hard drives and it has many gbytes of core, enough to load 
> into core that entire database several times.
>
> We (NOW) load entire databases into core because we can. We didn't 
> before because we couldn't (and the ones that did work that way could 
> only handle small databases)
>
> Michael
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


___
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] dollar signs in reports

[Ian D Henry]

I would like to suppress the dollar sign in my income statement and balance
sheet.  How can I do that?

-- 
Ian D Henry
___
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] Finance::Quote started multiplying prices by 100

[aeg via gnucash-user]

 Hi Geoff,
Thank you for following up on this. Please see the attached screenshot example.
Regards,AlanG


On Wednesday 18 September 2024 at 10:28:59 BST, 
gnucash-user-requ...@gnucash.org  wrote:  
Date: Wed, 18 Sep 2024 19:27:01 +1000
From: Geoff 

Hi Alan

Can you please show us the stock in question?  Attach a screenshot of 
the Tools / Security Editor / Edit Security window.

Thanks

Geoff
=

On 18/09/2024 6:25 pm, aeg via gnucash-user wrote:
> I'm currently using GnuCash version 5.4 on a Windows 11 desktopBuild ID: 
> 5.4+(2023-09-23)
> Finance::Quote: 1.62
> For about 5 years, I've routinely imported prices for my very modest stock 
> holding at the end of every week, but when I did so last weekend, all prices 
> were 100 times bigger than they had been on previous weeks. Whilst I'd like 
> to think I've suddenly become wealthy, I suspect there is an alternative 
> explanation, so is there a straightforward way of resolving this? I couldn't 
> find any settings to change.
> Regards,
> AlanG  ___
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] Finance::Quote started multiplying prices by 100

[aeg via gnucash-user]

 Martin, Geoff, Bruce,
Thank you very much for your help with this. I'm pleased to report that it now 
works as expected, having added an X to the symbol as suggested.
Perhaps I should have mentioned in my original post that I had previously been 
downloading quotes on my old laptop, which is running GnuCash version 4.12 on 
Windows 10 with Finance::Quote version 1.5301 installed, so presumably 
something has changed since those versions were current.
Thank you all again; it turned out to be more straightforward to resolve than I 
had feared!
Regards,Alan G


On Thursday 19 September 2024 at 14:46:42 BST, Martin Booth 
 wrote:  
 
  Downloading UK traded stock from Alphavantage you need to add an 'X' to the 
symbol like
CNA.L.X
your prices will now be pounds.

On Thursday 19 September 2024 at 13:05:05 BST, Geoff 
 wrote:  
 
 Hi Alan & Bruce

Alan: I believe the cause of this problem is that CNA is quoted in Pence 
on the LSE and Finance::Quote is interpreting it as Pounds, hence your 
100 fold discrepancy.  Until a fix is found I suggest you either 
manually edit the prices in GnuCash (Tools / Price Database / Edit) or 
just sit back and enjoy your new found wealth!

I am not familiar with the LSE but did come across this article which 
implies that some LSE securities are quoted in Pounds and others in Pence:
https://www.help.saxo/hc/en-au/articles/7743437597213-Stocks-on-London-Stock-Exchange-are-traded-in-pence-or-pound


Bruce: please see attached screenshot.  v1.49 of F::Q interprets the 
price correctly, v1.62 does not.  I ran these tests in Perl outside of 
GnuCash.  Over to you for comment.

Let me know if you need anything else.


Regards

Geoff
=

On 19/09/2024 12:37 pm, Bruce Schuck wrote:
> On Wed, Sep 18, 2024 at 04:25:37 EDT 2024 Alan G wrote:
> 
>> I'm currently using GnuCash version 5.4 on a Windows 11 desktopBuild
>> ID: 5.4+(2023-09-23) Finance::Quote: 1.62
> 
>> For about 5 years, I've routinely imported prices for my very modest
>> stock holding at the end of every week, but when I did so last
>> weekend, all prices were 100 times bigger than they had been on
>> previous weeks. Whilst I'd like to think I've suddenly become
>> wealthy, I suspect there is an alternative explanation, so is there a
>> straightforward way of resolving this? I couldn't find any settings
>> to change.
> 
> To which Geoff replied on Wed Sep 18 05:27:01 EDT 2024:
> 
>> Can you please show us the stock in question?  Attach a screenshot of
>> the Tools / Security Editor / Edit Security window.
> Stock symbols and what sources you have configured for those would be 
> all I need for testing F::Q outside of GnuCash. I suspect you may be 
> using a source (or sources) that get data through web scraping, and the 
> HTML returned from the URL used in the F::Q module has changed.
> 
> Please remember to reply-all, not just the list, and not just the direct 
> emails.
> 
> Thanks.
> 
> Bruce S.___
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] Database storage

[Roberts K]

In my experience the amount of data is relatively small (even for thousands
of records) and database performs well in XML form. As other people have
said - it is copied into memory, So not much use putting it on proper
RDBMS. I remember when I used it on MySQL over 100Mb connection on LAN (or
even MySQL on the same laptop) there was a distinct lag in importing
several hundred transactions, which was not there with XML or SQLite
backend.

I found the best of both worlds is to use SQLite backend - because it is
fastest and most portable - you just need to copy the file. It allows me to
run quite complex reports from R using standard SQL approach. Even more - I
made some bash scripts with SQL queries utilizing regexp support, that
allowed me to quickly get some vital information on terminal - even without
firing up gnucash.

Best wishes,
Roberts
--
Dr Roberts Klotins



On Thu, 19 Sept 2024 at 02:33, Chris Miller via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi Folks,
>
> The FAQ talks about PostgreSQL storage and how it was tired and
> discontinued, but then tried again. This was around version 2 - 3. We are
> now at version 5.8.
>
> Is there support for database storage? I see reference to sqlite3,
> PostgreSQL, and MySQL. Sqlite3 is obviously supported, since I can simply
> save my content as sqlite3 in preference to XML, but I'd really like to use
> either PostgreSQL or MySQL, because, that makes GnuCash client server, and
> probably lets me run on distributed client machines. If GnuCash can
> communicate with a database, it probably doesn't matter where the database
> is.
>
> What is the authoritative position for configuring database storage? Where
> are the instructions about how to do it?
>
> Thanks for the help,
> --
> Chris.
> ___
> 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] Finance::Quote started multiplying prices by 100

[Bruce Schuck]

On 9/19/24 6:46 AM, Martin Booth wrote:

Downloading UK traded stock from Alphavantage you need to add an 'X' to 
the symbol like



CNA.L.X



your prices will now be pounds.


Correct, I added the code to do this in AlphaVantage.pm last July. The 
comment in the source code explains the issue. John Ralls suggested the 
idea of having users add the ".X" suffix to stock symbols they know are 
traded in Pence instead of Pounds.


#   Since the JSON returned by the GLOBAL_QUOTE API does not specify
#   the currency of the price data, there is no way to determine the
#   correct currency without an additional call to the SYMBOL_SEARCH
#   API. To avoid even slower throttling, this module expects the
#   user to know which securities from certain countries may be traded
#   in the non-ISO4217 currency.
#   Example is LSE traded GBP.L and GBPG.L. GBP.L is traded in GBX,
#   which is also known as GBp, and GBPG.L is traded in the iso-4217
#   currency GBP (Great Britain Pounds).
#   The user will add ".X" to symbols to return GBX priced securities
#   as GBP.

For those wanting to see more on this issue see 
https://github.com/finance-quote/finance-quote/issues/281 and 
https://github.com/finance-quote/finance-quote/pull/326.


F::Q release v1.63 will be available soon (maybe this weekend). It 
contains a new module that gets data from https://financeapi.net that 
requires an API Key/Token. The free key from FinanceAPI allows 100 
queries per day. 4x as many allowed by the AlphaVantage free key. The 
"financeapi" method will use the key stored in the "FINANCEAPI_API_KEY" 
environment variable.


Thank you.

Bruce S.
___
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] Database storage

[Michael or Penny Novack via gnucash-user]

However the behavior of autosave is a pet peeve of mine. The behavior I 
would like to see is for gnucash to have two states, "not in the middle 
of entering a transaction" an "in the middle of entering a transaction"  
I want autosave to pop up only when in the first state (if the timer 
goes off when in the second state -- wait till returned to the first state)


It's not the time interval I want to change but the state behavior. If I 
am in the middle of entering a transaction my answer is always going to 
be NO! (I will finish the transaction and then manually save -- I might 
also cancel the transaction and then manually save. But in the middle? 
WHAT has been saved and what hasn't?)


OR --- if there is a formal definition like "autosave in the middle of 
entering a transaction is a cancel, followed by a save" I could live 
with that.


Michael D Novack


That's true. However, by default GC also autosaves the database
periodically. You can change the autosave interval, or disable autosave
entirely, in Edit » Preferences » General.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Credit cards - how to deal with those?

[R Losey]

The other account is what you purchased... usually an expense category.
Food? Dining? Clothing? Entertainment? It depends upon the expense accounts
you have set up, but it should answer the question "what did you use your
credit card to buy?"



On Wed, Sep 18, 2024 at 5:08 PM Boniforti Flavio 
wrote:

> Hi Greg and thanks for your reply.
> Indeed I see that I already have an account called "Credit Card", which
> type is in fact "Credit Card".
> I was trying to "simulate" such a transaction and I got stuck already:
> after entering the amount in the "Charge" column, I don't know which
> account I should select from the "Transfer" column. What would be the
> correct one?
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mi., 18. Sept. 2024 um 23:56 Uhr schrieb fromvendor <
> fromven...@outtacyte.com>:
>
> > Hi there,
> >
> > I have my Credit Cards set up each to its own account of type liability
> > (because I owe it eventually) under a parent placeholder called "Credit
> > Cards".
> >
> > Each transaction goes into the account appropriate for the card in
> > question.  When I get the statement (download, however), I reconcile the
> > card and match up receipts.  Once that is done, I "Pay" the card (check,
> > EFT, however) from my bank account.  That reduces the balance in the CC
> > account (backwards as it's a liability) and also reduces my bank account.
> >
> > Note there are options on how to display a CC type account, I have it so
> I
> > enter the transactions on the "Charge" column and the payment in the
> > "Payment" column.  It's still Debit and Credits fundamentally so it works
> > out.
> >
> > Anyway, I hope that helps.
> > -greg
> >
> > -Original Message-
> > From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=
> > outtacyte@gnucash.org] On Behalf Of Boniforti Flavio
> > Sent: Wednesday, September 18, 2024 4:43 PM
> > To: gnucash-user@gnucash.org
> > Subject: [GNC] Credit cards - how to deal with those?
> >
> > ... and another question from a noob: how to deal with credit card
> > transactions?
> > I usually would register it the day that I've done the transaction, so
> that
> > I can trace each single credit card transaction. Of course I know that
> the
> > money has not yet been deducted - it will happen once a month when the
> > credit card invoice is emitted. But if I would register *only* the credit
> > card invoice, I would lose track of each individual transaction - right?
> > So what (for a private individual - no business case here) would be the
> > most appropriate way to handle this?
> >
> > TIA,
> > F.
> >
> > https://www.instagram.com/boniforti_music
> > https://soundcloud.com/boniforti_music
> > https://bonny-j.bandcamp.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Finance::Quote started multiplying prices by 100

[Kalpesh Patel]

Looks like that change took place in Version 1.58 Release back on Aug 12, 2023 
where '.X' denotes scaling in effect for alphavantage. See 
https://github.com/finance-quote/finance-quote/releases/tag/v1.58

As a side note, Alphavantage has really tighten up ability to pull free quotes 
from their API to the tune of up to 25 requests per day so tread accordingly.




-Original Message-
From: aeg  
Sent: Thursday, September 19, 2024 11:06 AM
To: Bruce Schuck ; Geoff 
; Martin Booth 
Cc: GnuCash User 
Subject: Re: [GNC] Finance::Quote started multiplying prices by 100

 Martin, Geoff, Bruce,
Thank you very much for your help with this. I'm pleased to report that it now 
works as expected, having added an X to the symbol as suggested.
Perhaps I should have mentioned in my original post that I had previously been 
downloading quotes on my old laptop, which is running GnuCash version 4.12 on 
Windows 10 with Finance::Quote version 1.5301 installed, so presumably 
something has changed since those versions were current.
Thank you all again; it turned out to be more straightforward to resolve than I 
had feared!
Regards,Alan G


On Thursday 19 September 2024 at 14:46:42 BST, Martin Booth 
 wrote:  
 
  Downloading UK traded stock from Alphavantage you need to add an 'X' to the 
symbol like CNA.L.X your prices will now be pounds.

On Thursday 19 September 2024 at 13:05:05 BST, Geoff 
 wrote:  
 
 Hi Alan & Bruce

Alan: I believe the cause of this problem is that CNA is quoted in Pence on the 
LSE and Finance::Quote is interpreting it as Pounds, hence your
100 fold discrepancy.  Until a fix is found I suggest you either manually edit 
the prices in GnuCash (Tools / Price Database / Edit) or just sit back and 
enjoy your new found wealth!

I am not familiar with the LSE but did come across this article which implies 
that some LSE securities are quoted in Pounds and others in Pence:
https://www.help.saxo/hc/en-au/articles/7743437597213-Stocks-on-London-Stock-Exchange-are-traded-in-pence-or-pound


Bruce: please see attached screenshot.  v1.49 of F::Q interprets the 
price correctly, v1.62 does not.  I ran these tests in Perl outside of 
GnuCash.  Over to you for comment.

Let me know if you need anything else.


Regards

Geoff
=

On 19/09/2024 12:37 pm, Bruce Schuck wrote:
> On Wed, Sep 18, 2024 at 04:25:37 EDT 2024 Alan G wrote:
> 
>> I'm currently using GnuCash version 5.4 on a Windows 11 desktopBuild
>> ID: 5.4+(2023-09-23) Finance::Quote: 1.62
> 
>> For about 5 years, I've routinely imported prices for my very modest
>> stock holding at the end of every week, but when I did so last
>> weekend, all prices were 100 times bigger than they had been on
>> previous weeks. Whilst I'd like to think I've suddenly become
>> wealthy, I suspect there is an alternative explanation, so is there a
>> straightforward way of resolving this? I couldn't find any settings
>> to change.
> 
> To which Geoff replied on Wed Sep 18 05:27:01 EDT 2024:
> 
>> Can you please show us the stock in question?  Attach a screenshot of
>> the Tools / Security Editor / Edit Security window.
> Stock symbols and what sources you have configured for those would be 
> all I need for testing F::Q outside of GnuCash. I suspect you may be 
> using a source (or sources) that get data through web scraping, and the 
> HTML returned from the URL used in the F::Q module has changed.
> 
> Please remember to reply-all, not just the list, and not just the direct 
> emails.
> 
> Thanks.
> 
> Bruce S.___
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] Database storage

[R Losey]

On Wed, Sep 18, 2024 at 8:54 PM Chris Miller via gnucash-user <
gnucash-user@gnucash.org> wrote:

> > It should be noted: GnuCash does *not* do database queries as it
> processes
> > transactions.
> Well, that's disappointing ... and definitive.
>
> If this content is stored as flat XML, then I would expect it not to scale
> very well. When does it start having performance problems?
>
> Thanks for the help,
> --
> Chris.
>
> V:916.799.9461
> F:916.974.0428
> A: Because we read from top to bottom, left to right.
> Q: > Why should I start my reply below the quoted text?
> ___
> 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.
>

For what it's worth, this was a worry of mine, but I have over 8 years in
the XML format and haven't had any performance issues. The startup may be
slowing (about 3-4 seconds; doing a save is similar), but entering
transactions is speedy. This is an an iMac, using the Intel version of
GnuCash and accessing the GnuCash file on my NAS over SMB.  My windows
machine is a little slower - say 5-6 seconds for load/save.  It is speedy
on Linux, as it is an NFS mount.

I'd say it is scaling extremely well.

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Can't open saved .gnucash file

[John Ralls]

It looks like you left a report open and the option string saved in your state 
file has a bad value. The state file has the same name as your .gnucash file 
with a .gcm extension tacked on (i.e. “my-book.gnucash.gcm”) and is located in 
GNC_DATA_HOME/books (see 
https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME for where 
GNC_DATA_HOME is on your system).

You can either delete or edit the state file. If you delete it you’ll lose all 
of your open tabs and UI customizations, so you’ll probably prefer to edit it. 
Open it in your favorite text editor (e.g. emacs, nano, vi) and go to the 
bottom. Each open window has a [Window N] section containing a [Page N] section 
for each open tab. Report tabs will have the PageType GncPluginPageReport. Find 
the one with an option value (1530334800 .  0) and delete it, renumbering the 
following [Page N] sections so that the numbering is consecutive. Save the file 
and start GnuCash.

Regards,
John Ralls



> On Sep 19, 2024, at 07:19, Chris Raesz via gnucash-user 
>  wrote:
> 
> I recently had a desktop meltdown but I had my data backed up. I am using 
> Linux and gnucash version GnuCash 5.8, Build ID: 5.8+(2024-07-06)
> 
> When I try to open it, I get a message stating some other user has the file 
> locked. When I tell it to open read-only or open anyway, it crashes. My 
> command line attempts give me this:
> 
>   Backtrace:
>   In ice-9/boot-9.scm:
> 160: 6 [catch #t # ...]
>   In unknown file:
>   ?: 5 [apply-smob/1 #]
>   In ice-9/boot-9.scm:
>   2412: 4 [save-module-excursion #   ice-9/eval-string.scm:65:9 ()>]
>   In ice-9/eval-string.scm:
>  44: 3 [read-and-eval # #:lang ...]
>  37: 2 [lp (let ((options #)) (let (#) (# option)) ...)]
>   In ice-9/eval.scm:
> 432: 1 [eval # #]
>   In unknown file:
>   ?: 0 [GncOption-set-value # (absolute
>   1530334800 . 0)]
> 
>   ERROR: In procedure GncOption-set-value:
>   ERROR: Wrong type (expecting exact integer): (1530334800 . 0)
> 
>   Some deprecated features have been used.  Set the environment
>   variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
>   program to get more information. Set it to "no" to suppress
>   this message.
> 
> 
> What do I need to do to clear this lock issue??
> 
> -- 
> chris.
> ___
> 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] Can't open saved .gnucash file

[Ed Reeder]

Thanks!  It also looks like it is also a case of RTFM.
https://lists.gnucash.org/docs/C/gnucash-guide/basics-backup1.html

Looks like this would be another way to recover.

Thanks so much for your detailed explanation.

/Ed

On Thu, Sep 19, 2024, at 10:12 AM, John Ralls wrote:
> It looks like you left a report open and the option string saved in 
> your state file has a bad value. The state file has the same name as 
> your .gnucash file with a .gcm extension tacked on (i.e. 
> “my-book.gnucash.gcm”) and is located in GNC_DATA_HOME/books (see 
> https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME for 
> where GNC_DATA_HOME is on your system).
>
> You can either delete or edit the state file. If you delete it you’ll 
> lose all of your open tabs and UI customizations, so you’ll probably 
> prefer to edit it. Open it in your favorite text editor (e.g. emacs, 
> nano, vi) and go to the bottom. Each open window has a [Window N] 
> section containing a [Page N] section for each open tab. Report tabs 
> will have the PageType GncPluginPageReport. Find the one with an option 
> value (1530334800 .  0) and delete it, renumbering the following [Page 
> N] sections so that the numbering is consecutive. Save the file and 
> start GnuCash.
>
> Regards,
> John Ralls
>
>
>
>> On Sep 19, 2024, at 07:19, Chris Raesz via gnucash-user 
>>  wrote:
>> 
>> I recently had a desktop meltdown but I had my data backed up. I am using 
>> Linux and gnucash version GnuCash 5.8, Build ID: 5.8+(2024-07-06)
>> 
>> When I try to open it, I get a message stating some other user has the file 
>> locked. When I tell it to open read-only or open anyway, it crashes. My 
>> command line attempts give me this:
>> 
>>   Backtrace:
>>   In ice-9/boot-9.scm:
>> 160: 6 [catch #t # ...]
>>   In unknown file:
>>   ?: 5 [apply-smob/1 #]
>>   In ice-9/boot-9.scm:
>>   2412: 4 [save-module-excursion #>   ice-9/eval-string.scm:65:9 ()>]
>>   In ice-9/eval-string.scm:
>>  44: 3 [read-and-eval # #:lang ...]
>>  37: 2 [lp (let ((options #)) (let (#) (# option)) ...)]
>>   In ice-9/eval.scm:
>> 432: 1 [eval # #]
>>   In unknown file:
>>   ?: 0 [GncOption-set-value # (absolute
>>   1530334800 . 0)]
>> 
>>   ERROR: In procedure GncOption-set-value:
>>   ERROR: Wrong type (expecting exact integer): (1530334800 . 0)
>> 
>>   Some deprecated features have been used.  Set the environment
>>   variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
>>   program to get more information. Set it to "no" to suppress
>>   this message.
>> 
>> 
>> What do I need to do to clear this lock issue??
>> 
>> -- 
>> chris.
>> ___
>> 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] Can't open saved .gnucash file

[Chris Raesz via gnucash-user]

I recently had a desktop meltdown but I had my data backed up. I am 
using Linux and gnucash version GnuCash 5.8, Build ID: 5.8+(2024-07-06)


When I try to open it, I get a message stating some other user has the 
file locked. When I tell it to open read-only or open anyway, it 
crashes. My command line attempts give me this:


   Backtrace:
   In ice-9/boot-9.scm:
 160: 6 [catch #t # ...]
   In unknown file:
   ?: 5 [apply-smob/1 #]
   In ice-9/boot-9.scm:
   2412: 4 [save-module-excursion #]
   In ice-9/eval-string.scm:
  44: 3 [read-and-eval # #:lang ...]
  37: 2 [lp (let ((options #)) (let (#) (# option)) ...)]
   In ice-9/eval.scm:
 432: 1 [eval # #]
   In unknown file:
   ?: 0 [GncOption-set-value # (absolute
   1530334800 . 0)]

   ERROR: In procedure GncOption-set-value:
   ERROR: Wrong type (expecting exact integer): (1530334800 . 0)

   Some deprecated features have been used.  Set the environment
   variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
   program to get more information. Set it to "no" to suppress
   this message.


What do I need to do to clear this lock issue??

--
chris.
___
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] Database storage

[Robert Heller]

At Thu, 19 Sep 2024 07:32:05 -0700 "Stan Brown (using GC 4.14)" 
 wrote:

>
> On 2024-09-18 18:54, Jim DeLaHunt wrote:
> > In other words, if you have GnuCash store data in a database, GnuCash
> > reads all its data out of the database when it starts, and writes all
> > the data back when it stops. It does not write and commit each
> > transaction as it goes.
>
> That's true. However, by default GC also autosaves the database
> periodically. You can change the autosave interval, or disable autosave
> entirely, in Edit » Preferences » General.

That does not change the fact the even when using a database for storage,
GnuCash still is not multi-client capable.



>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
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] Database storage

[Stan Brown (using GC 4.14)]

On 2024-09-18 18:54, Jim DeLaHunt wrote:
> In other words, if you have GnuCash store data in a database, GnuCash
> reads all its data out of the database when it starts, and writes all
> the data back when it stops. It does not write and commit each
> transaction as it goes.

That's true. However, by default GC also autosaves the database
periodically. You can change the autosave interval, or disable autosave
entirely, in Edit » Preferences » General.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Database storage

[Chris Miller via gnucash-user]

Hi Roberts, 

> I found the best of both worlds is to use SQLite backend - because it is
> fastest and most portable - you just need to copy the file. It allows me to
> run quite complex reports from R using standard SQL approach. Even more - I
> made some bash scripts with SQL queries utilizing regexp support, that
> allowed me to quickly get some vital information on terminal - even without
> firing up gnucash.
I had already come to the same conclusion. And I have also already posed 
questions to myself: 

* Does SQLite support transactions? -- Yes. 
* Are transactions implemented? -- Let's assume, "Yes." 

So, this raises more questions, on the assumption of transactional database 
updates in SQLite. 

* Transactional database updates implies multiple user concurrency, but 
everywhere I hear that multiple users is "problematic". Certainly this is true 
with the XML storage because the file is single-use locked, so less 
"problematic" than "impossible". (-: But is it still true with SQLite? 
* If SQLite is supporting transactions, and I then have to assume SQLite is 
"talking" SQL, then what is the complexity with doing the same for other 
back-end databases? 
I hope I have not strayed into an acrimoniously controversial area, but I would 
like to hear the debate. 

Thanks for the help, 
-- 
Chris. 

V:916.799.9461 
F:916.974.0428 
A: Because we read from top to bottom, left to right.
Q: > Why should I start my reply below the quoted text? 
___
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] Database storage

[Michael or Penny Novack via gnucash-user]

On 9/19/2024 11:16 AM, Roberts K wrote:

In my experience the amount of data is relatively small (even for thousands
of records)


A bit of historical perspective is needed, particularly because our 
heads have not yet absorbed a fundamental change in technology.


Back in my working days, the IBM 3350's (hard drives) held somewhat over 
300 mbytes each and our programs on the mainframe had about 10 mbytes 
core (the OS took about 6 mbytes from every program's virtual space.


So a large database might span three drives and only a tiny bit of it at 
a time could fit into core.


Now this Lenovo work station I am sitting at is ancient. The W541's were 
the last of the W series. Still, this little thing I v=can pick up and 
carry around has HUNDREDS of times as much capacity as those three 3350 
hard drives and it has many gbytes of core, enough to load into core 
that entire database several times.


We (NOW) load entire databases into core because we can. We didn't 
before because we couldn't (and the ones that did work that way could 
only handle small databases)


Michael


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Credit cards - how to deal with those?

[Ian Pilcher]

On 9/18/24 4:56 PM, fromvendor wrote:

Each transaction goes into the account appropriate for the card in
question.  When I get the statement (download, however), I reconcile
the card and match up receipts.  Once that is done, I "Pay" the card
(check, EFT, however) from my bank account.  That reduces the
balance in the CC account (backwards as it's a liability) and also
reduces my bank account.


An alternative, which I haven't seen mentioned, is to "batch" the
transactions on a statement into a single transaction and use splits for
the individual charges.  The has the advantage of keeping the account
register less cluttered, but it does mean that you lose the date
information for the individual charges.

(I actually take it a step further and split each statement into
separate transactions for the 2 calendar months that it covers.  For
example, my 19 September credit card statement will be split into two
transactions -- "19 Sept 2024 statement - Aug transactions" and "19 Sept
2024 statement - Sept transactions.")

--

Google  Where SkyNet meets Idiocracy


___
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] Finance::Quote started multiplying prices by 100

[Martin Booth via gnucash-user]

 Downloading UK traded stock from Alphavantage you need to add an 'X' to the 
symbol like
CNA.L.X
your prices will now be pounds.

On Thursday 19 September 2024 at 13:05:05 BST, Geoff 
 wrote:  
 
 Hi Alan & Bruce

Alan: I believe the cause of this problem is that CNA is quoted in Pence 
on the LSE and Finance::Quote is interpreting it as Pounds, hence your 
100 fold discrepancy.  Until a fix is found I suggest you either 
manually edit the prices in GnuCash (Tools / Price Database / Edit) or 
just sit back and enjoy your new found wealth!

I am not familiar with the LSE but did come across this article which 
implies that some LSE securities are quoted in Pounds and others in Pence:
https://www.help.saxo/hc/en-au/articles/7743437597213-Stocks-on-London-Stock-Exchange-are-traded-in-pence-or-pound


Bruce: please see attached screenshot.  v1.49 of F::Q interprets the 
price correctly, v1.62 does not.  I ran these tests in Perl outside of 
GnuCash.  Over to you for comment.

Let me know if you need anything else.


Regards

Geoff
=

On 19/09/2024 12:37 pm, Bruce Schuck wrote:
> On Wed, Sep 18, 2024 at 04:25:37 EDT 2024 Alan G wrote:
> 
>> I'm currently using GnuCash version 5.4 on a Windows 11 desktopBuild
>> ID: 5.4+(2023-09-23) Finance::Quote: 1.62
> 
>> For about 5 years, I've routinely imported prices for my very modest
>> stock holding at the end of every week, but when I did so last
>> weekend, all prices were 100 times bigger than they had been on
>> previous weeks. Whilst I'd like to think I've suddenly become
>> wealthy, I suspect there is an alternative explanation, so is there a
>> straightforward way of resolving this? I couldn't find any settings
>> to change.
> 
> To which Geoff replied on Wed Sep 18 05:27:01 EDT 2024:
> 
>> Can you please show us the stock in question?  Attach a screenshot of
>> the Tools / Security Editor / Edit Security window.
> Stock symbols and what sources you have configured for those would be 
> all I need for testing F::Q outside of GnuCash. I suspect you may be 
> using a source (or sources) that get data through web scraping, and the 
> HTML returned from the URL used in the F::Q module has changed.
> 
> Please remember to reply-all, not just the list, and not just the direct 
> emails.
> 
> Thanks.
> 
> Bruce S.___
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] Monthly Reports

[Phyllis Bruce]

NMichael, you may not be aware that your responses are not going to the
group.  The proper address is gnucash-user@gnucash.org.  I had also
forgotten the dash.  Now to your last comments.

As I stated earlier, there are times - not always - when it seems
appropriate to me to detail the costs to a specific item in the chart of
accounts.  By no means do I send a printout of the entire month.  However;
if I can download the entire month to a *.cvs file, I can hide the
information which is NOT necessary to the board.  Certain members of the
board are interested in different details.  Membership is captured four
ways - individual, household, parish, diocese.  The endowment committee
needs to know who and how much has been donated to principal.  The sacristy
shop charges postage and stock to the customer.  As you can see from the
brief I sent earlier, all of this information is accounted for in my chart
of accounts.  If a certain cost is out of whack, *I * want to highlight it
to the board.

I can download from the financial institutions into a cvs file, outside of
GNU, that I can manipulate but that would mean double the work.  It all
comes down to the transactions and their allocations.  I do it in GNU and
don't wish to do it again.  That is why I am trying to get a monthly
Transaction report.

I will go back to David's suggestion of subtracting the totals from the
previous months.  I provide a monthly report to the board - the summary
report will be the final report of the year.  I am not having any luck in
creating a transaction report despite all my efforts.

po

On Thu, Sep 19, 2024 at 10:11 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> That may well be. But I was responding to what you said needed for, the
> 990-N
>
> As for your board, are you saying they want to look at the individual
> transactions of an account, say "membership dues" as opposed to the total
> received during the period (month?) for the income account "membership
> dues"?
>
> Understand? I am questioning what report you should want to run. IF what
> you wanted was a report for each period showing the TOTALS for each income
> and expense account then you would be wanting to run a different report
> than "transaction". << as a non-profit you would want the TITLE of that
> report "Statement of Revenues and Expenses" or shorter title "Statement of
> Revenues" but the TITLE of a report is independent of the NAME gnucash
> assigns the report -- and you choose by name, not title >>
>
> Now I do understand circumstances where a board (more usually just another
> officer/board member) wants to look at individual transactions. For
> example, the organization might have a policy "a second officer will verify
> that disbursements are legitimate, have supporting documentation" << a
> policy like that might be adopted once the organization recovers from fraud
> or embezzlement >> But that is usually "if over X amount". To save that
> confirming officer from looking at all would export the transaction report
> for the disbursing accounts and then a spreadsheet app could find the lines
> where amount in column > X.
>
> Michael D Novack
>
> PS -- PLEASE -- I am not saying your board doesn't want to look at each
> and every transaction. Just questioning because of my experience. If they
> really do want to do this, could you explain why?  For example, if you told
> me "they want to look into account X because transactions of sub types A,
> B,. and C all go into X and they want to see how much was A, how much was
> B, how much C it's not a report that needs a fix but the CoA (X needs
> children XA, XB, and XC and now they don't need to go through the
> transactions of X)
>
>
>
>
>
>
>
> On 9/18/2024 8:20 PM, Phyllis Bruce wrote:
>
> Correct.  But that is only for the IRS.  I still need monthly reports for
> the board.
>
> On Sep 18, 2024, at 5:54 PM, Michael or Penny Novack
>   wrote:
>
> 
>
> I also will use my transaction report for the 990-N as our income is
> derived entirely from membership fees.
>
>
>  The only way that how much you take in affects the 990-N is to make
> sure it is not over the threshold requiring you to file 990-EZ or 990. The
> 990-N "electronic postcard" is just notifying the IRS "yes, we still exist
> but too small for you to bother yourself about". So you only need to know
> the TOTAL income.
>
> Michael D Novack
>
>
> --
> There is no possibility of social justice on a dead planet except the 
> equality of the grave.
>
>
___
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] Can't open saved .gnucash file

[Chris Raesz via gnucash-user]

That sort of worked. I got the same error message after deleting that 
report, but it let me open it anyway. After that, I created the deleted 
report and closed it down. When I restarted Gnucash, no issues. Thanks 
very much.


chris.


On 9/19/24 12:12, John Ralls wrote:
It looks like you left a report open and the option string saved in 
your state file has a bad value. The state file has the same name as 
your .gnucash file with a .gcm extension tacked on (i.e. 
“my-book.gnucash.gcm”) and is located in GNC_DATA_HOME/books (see 
https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME for 
where GNC_DATA_HOME is on your system).


You can either delete or edit the state file. If you delete it you’ll 
lose all of your open tabs and UI customizations, so you’ll probably 
prefer to edit it. Open it in your favorite text editor (e.g. emacs, 
nano, vi) and go to the bottom. Each open window has a [Window N] 
section containing a [Page N] section for each open tab. Report tabs 
will have the PageType GncPluginPageReport. Find the one with an 
option value (1530334800 .  0) and delete it, renumbering the 
following [Page N] sections so that the numbering is consecutive. Save 
the file and start GnuCash.


Regards,
John Ralls



On Sep 19, 2024, at 07:19, Chris Raesz via gnucash-user 
 wrote:


I recently had a desktop meltdown but I had my data backed up. I am 
using Linux and gnucash version GnuCash 5.8, Build ID: 5.8+(2024-07-06)


When I try to open it, I get a message stating some other user has 
the file locked. When I tell it to open read-only or open anyway, it 
crashes. My command line attempts give me this:


  Backtrace:
  In ice-9/boot-9.scm:
160: 6 [catch #t # ...]
  In unknown file:
  ?: 5 [apply-smob/1 #]
  In ice-9/boot-9.scm:
  2412: 4 [save-module-excursion #]
  In ice-9/eval-string.scm:
 44: 3 [read-and-eval # #:lang ...]
 37: 2 [lp (let ((options #)) (let (#) (# option)) ...)]
  In ice-9/eval.scm:
432: 1 [eval # #]
  In unknown file:
  ?: 0 [GncOption-set-value # (absolute
  1530334800 . 0)]

  ERROR: In procedure GncOption-set-value:
  ERROR: Wrong type (expecting exact integer): (1530334800 . 0)

  Some deprecated features have been used.  Set the environment
  variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
  program to get more information. Set it to "no" to suppress
  this message.


What do I need to do to clear this lock issue??

--
chris.
___
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.