[GNC] Display report values in whole curremcy units

[Richard Gaede via gnucash-user]

I would like to be able to print reports which display numbers in whole 
currency unit values. I have experimented with Preferences which only 
allow going to 1 decimal place. Even when I do that,registers and 
reports still display 2 decimal places.


Is what I want to do achievable in Gnucash? If so what am I missing?

Advice appreciated.

Thanks & regards

--
___
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] Change Linked Document Path

[Geoff Storer]

Ok, thanks.

This is my first post!!

On Fri, Sep 2, 2022 at 8:16 AM Jim DeLaHunt  wrote:

> Geoff:
>
> One tenet of GnuCash-user email list etiquette is to cc the gnucash-user
> email list on all replies. We want this discussion to take place on the
> list.
>
> Thus I am replying to you, and cc'ing the list, so that the thread stays
> on the list.  I will reply to this message from the email that reaches me
> via the list.
> —Jim DeLaHunt
> On 2022-09-01 03:57, Geoff Storer wrote:
>
> Hi Jim
>
> Thanks for coming back to me. Sorry I have taken so long to respond.
>
> In answer to your questions:
>
> Q: Are you familiar with the difference in behaviour between relative file
> paths and absolute file paths?
>
> Ans; No this is not one of my strong points
>
> Q: Are you familiar with the difference in spelling (C:\ prefixes and
> backslashes etc.) between relative file paths and absolute file paths?
>
> Ans:  No
>
> Q:  In your GnuCash Book (bookkeeping file), have you associated files to
> transactions using relative path File Associations, absolute path File
> Associations,  or Location Associations?
>
> Ans: I think the answer here is relative path. What I actually did in GNU
> was:
> Edit / preferences / General / Linked Files and with the drop down arrow
> selected the folder location of my invoices
> The reason I say "relative path" is because GNU program details on the
> referenced edit field the comment
> "Path head for Linked Files Relative Paths"
> The location I selected is -  D:\PDF\GNU Invoices
>
> Q:  Were all your attached documents within a single directory on your old
> computer? Do you know the absolute path to that directory?
>
> Ans: Yes all invoices are in the one folder   "D:\PDF\GNU Invoices"  (the
> output here I copied directly from my explorer view so I should have that
> correct)
>
> Q:  Are all your attached documents within a single directory on your new
> computer? Do you know the absolute path to that directory?
>
> Ans: The invoices are in the exact location as on the initial install of
> GNU.
> I only re-installed windows on the C:\ partition. The other
> partitions remain exactly as they were
> The invoices are in "D:\PDF\GNU Invoices"
>
> I hope I have answered all your queries. Let me know if you need any
> further clarification.
>
> Thanks again
>
> Regards
>
> John Murdoch
>
> On Tue, Aug 30, 2022 at 3:46 PM Jim DeLaHunt 
> wrote:
>
>> Hello, John:
>>
>> Your question rings a bell! I did an overhaul on the file associations
>> on my transactions a couple of years ago.
>>
>> On 2022-08-29 04:10, john murdoch wrote:
>> > ...My problem now is that [GnuCash] looks for the attached document in
>> the
>> > windows document folder on the C Drive. I have tried editing the
>> > preferences in [GnuCash] to point to the correct location of the
>> documents
>> > on the alternate partition but this doesn't automatically link to the
>> > document.
>> >
>> >
>> > I can then manually link each document by using  the "manage document
>> > link" function on the right click menu in the account field of GNU
>> > cash. That  of course will be quite tedious and I was enquiring if
>> > there is a "global fix" so that all files could be re-linked in one
>> > procedure? Perhaps editing settings or the system registry?
>> >
>> >
>> > I did try a feature as per the attached screenshot [of the Change
>> Linked Document path head dialogue] without any success.
>>
>> Well, the Change Linked Document path head dialogue, which your
>> screenshot showed, is the best tool in GnuCash for this job. However,
>> you have to know a few things to use it well. I'll bet the UI does not
>> do a complete job of walking a person through it.
>>
>> To set some groundwork, some questions:
>>
>> Are you familiar with the difference in behaviour between relative file
>> paths and absolute file paths?
>>
>> Are you familiar with the difference in spelling (C:\ prefixes and
>> backslashes etc.) between relative file paths and absolute file paths?
>>
>> In your GnuCash Book (bookkeeping file), have you associated files to
>> transactions using relative path File Associations, absolute path File
>> Associations,  or Location Associations?
>>
>> Were all your attached documents within a single directory on your old
>> computer? Do you know the absolute path to that directory?
>>
>> Are all your attached documents within a single directory on your new
>> computer? Do you know the absolute path to that directory?
>>
>> Based on answers to those questions — and once I run GnuCash to refresh
>> my memory about how the Change Linked Document path head dialogue works,
>> and once I translate from macOS to Windows in my head — I can try to
>> help you further.
>>
>> Best regards,
>>   —Jim DeLaHunt
>>
>>
>> Are all your attached documents within a single directory on your new
>> computer?
>>
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 

Re: [GNC] Online quotes for a mutual fund

[Geoff]

Hi Ruaraidh

I think you are out of luck with Gilts.  I have checked the web sites of 
Morningstar, Financial Times, Alphavantage, and Yahoo Finance; and none 
of them seem to be able to provide price data for Gilts securities.


I note that you can obtain price data directly from the LSX:-
https://www.londonstockexchange.com/stock/TR29/united-kingdom/company-page
However none of the Finance Quote modules currently use the LSX as a 
data source.



Regards

Geoff
=

On 24/08/2022 6:59 pm, Ruaraidh Sackville Hamilton wrote:
Finding the right source and symbol seems a challenge! For several years 
I've been successfully getting quotes through fq using the single source 
"Alphavantage, US" for single UK equities, and the multiple-source "U.K. 
funds" for UK funds. However, I can't find anything that works for UK 
Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they 
appear on the LSE and FT websites. I've tried all sources listed in the 
GC help system that seem reasonably possible. Some examples:


C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534

all generate the error code
** This stock quote cannot be used by GnuCash!

Does anyone have any experience with this?

Regards,

Ruaraidh

On Mon, 17 May 2021 at 01:55, Geoff > wrote:


Hi Jacob

It looks like the Financial Times' Funds service will provide prices:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
      symbol: SE0005993078         <=== required
        date: 05/12/2021           <=== recommended
    currency: DKK                  <=== required
        last: 237.96               <=\
         nav: 237.96               <=== one of these
       price: 237.96               <=/
    timezone:                      <=== optional



Regards

Geoff
=

On 17/05/2021 7:35 am, Jacob Larsen wrote:
 > Hi
 >
 > I am trying to get online quotes for a few mutual funds I am
tracking,
 > but I am having no luck, mostly because they don't really have any
 > symbols, only ISINs. Anyone have any ideas on how I proceed on
this one?
 >
 > They are not available on Yahoo, but I found them on a few others
 > without succeeding gnc-fq-dump with any of them, this is one of them:
 >
 >
https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

 >
 >
https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

 >
 > https://www.investing.com/funds/nordnet-superfonden-danmark

 >
 >
 > /Jacob
 >
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org 
 > To update your subscription preferences or to unsubscribe:
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user

 > If you are using Nabble or Gmane, please see
 > https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 someone tell me how A-L=Eq+(I-Ex) is correct?

[W. Neal Lewis]

Liz,

Thank you.

I've received much help and am learning what is needed.

Best regards,

Neal Lewis

P.S. The book that was recommended: "Accounting All-In-One for Dummies" 
is on its way to me, purchased yesterday from Amazon. I am thankful for 
that suggestion, because I did not know what to look for. The other 
members were able to get me over a logical hurdle that had blocked 
forward progress until they offered help. WNL



On 8/31/22 11:42 PM, Liz Dodd wrote:

On Wed, 31 Aug 2022 21:08:35 -0500
"W. Neal Lewis"  wrote:


David,

That's where this all started.

It didn't make sense so I thought I would ask people who were more
knowledgeable.

I did look on line and nothing on line made any more sense.

So, thank you for your help.

Best regards,

Neal Lewis

Putting on my educator hat

Not everyone understands the same way, people read the same words and
assign different meaning to those words.
So we need access to lots of different approaches.

Putting on my moderator hat
.
Officially this list does not support accounting discussions, but it is
one of the things we do here, as well as how to use Gnucash.

Liz
___
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] Change Linked Document Path

[Jim DeLaHunt]

Geoff:

One tenet of GnuCash-user email list etiquette is to cc the gnucash-user 
email list on all replies. We want this discussion to take place on the 
list.


Thus I am replying to you, and cc'ing the list, so that the thread stays 
on the list.  I will reply to this message from the email that reaches 
me via the list.

    —Jim DeLaHunt

On 2022-09-01 03:57, Geoff Storer wrote:

Hi Jim

Thanks for coming back to me. Sorry I have taken so long to respond.

In answer to your questions:

Q: Are you familiar with the difference in behaviour between relative file
paths and absolute file paths?

Ans; No this is not one of my strong points

Q: Are you familiar with the difference in spelling (C:\ prefixes and
backslashes etc.) between relative file paths and absolute file paths?

Ans:  No

Q: In your GnuCash Book (bookkeeping file), have you associated files to
transactions using relative path File Associations, absolute path File
Associations,  or Location Associations?

Ans: I think the answer here is relative path. What I actually did in 
GNU was:
Edit / preferences / General / Linked Files and with the drop down 
arrow selected the folder location of my invoices
The reason I say "relative path" is because GNU program details on the 
referenced edit field the comment

"Path head for Linked Files Relative Paths"
The location I selected is -  D:\PDF\GNU Invoices

Q: Were all your attached documents within a single directory on your old
computer? Do you know the absolute path to that directory?

Ans: Yes all invoices are in the one folder   "D:\PDF\GNU Invoices"  
(the output here I copied directly from my explorer view so I should 
have that correct)


Q: Are all your attached documents within a single directory on your new
computer? Do you know the absolute path to that directory?

Ans: The invoices are in the exact location as on the initial install 
of GNU.
        I only re-installed windows on the C:\ partition. The other 
partitions remain exactly as they were

        The invoices are in "D:\PDF\GNU Invoices"

I hope I have answered all your queries. Let me know if you need any 
further clarification.


Thanks again

Regards

John Murdoch

On Tue, Aug 30, 2022 at 3:46 PM Jim DeLaHunt > wrote:


Hello, John:

Your question rings a bell! I did an overhaul on the file
associations
on my transactions a couple of years ago.

On 2022-08-29 04:10, john murdoch wrote:
> ...My problem now is that [GnuCash] looks for the attached
document in the
> windows document folder on the C Drive. I have tried editing the
> preferences in [GnuCash] to point to the correct location of the
documents
> on the alternate partition but this doesn't automatically link
to the
> document.
>
>
> I can then manually link each document by using  the "manage
document
> link" function on the right click menu in the account field of GNU
> cash. That  of course will be quite tedious and I was enquiring if
> there is a "global fix" so that all files could be re-linked in one
> procedure? Perhaps editing settings or the system registry?
>
>
> I did try a feature as per the attached screenshot [of the
Change Linked Document path head dialogue] without any success.

Well, the Change Linked Document path head dialogue, which your
screenshot showed, is the best tool in GnuCash for this job. However,
you have to know a few things to use it well. I'll bet the UI does
not
do a complete job of walking a person through it.

To set some groundwork, some questions:

Are you familiar with the difference in behaviour between relative
file
paths and absolute file paths?

Are you familiar with the difference in spelling (C:\ prefixes and
backslashes etc.) between relative file paths and absolute file paths?

In your GnuCash Book (bookkeeping file), have you associated files to
transactions using relative path File Associations, absolute path
File
Associations,  or Location Associations?

Were all your attached documents within a single directory on your
old
computer? Do you know the absolute path to that directory?

Are all your attached documents within a single directory on your new
computer? Do you know the absolute path to that directory?

Based on answers to those questions — and once I run GnuCash to
refresh
my memory about how the Change Linked Document path head dialogue
works,
and once I translate from macOS to Windows in my head — I can try to
help you further.

Best regards,
  —Jim DeLaHunt


Are all your attached documents within a single directory on your new
computer?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] Question - Applying Credit notes to an outstanding invoice

[Adrien Monteleone]

Menu: Business > Customer > Process Payment

Look up the customer
Select both the desired credit note and the desired invoice

Set the other appropriate info, but unless also taking another form of 
payment leave the payment field unchanged.


The credit note will be used to partially/fully offset the invoice which 
will show up as a 'payment' in the Customer Report.


Regards,
Adrien

On 9/1/22 9:39 AM, Nora wrote:

I'm not sure how to apply a client's credit note to pay for another invoice
of the same client.



___
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] "Deleted" Invoices or Bills

[Adrien Monteleone]

Menu: Business > Customer/Vendor > Find Invoice/Bill > 'Invoice/Bill ID' 
> 'contains' > "Use Next" or whatever text you changed it to. (without 
quotes)


Then you can select the one you want and use the view/edit button to 
adjust from there.


Regards,
Adrien

On 9/1/22 1:25 PM, Eric Hammond wrote:

Thanks Adrien,
I understand the complexity of the data-base, and re-using them would be great.
But
Please tell me how you find them?
(there are a LOT at this point)
Once I Unpost and clean up incorrect invoices or bills they seem to vanish when I close 
its tab in the "Accounts" ribbon.



___
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] "Deleted" Invoices or Bills

[Eric Hammond]

Thanks Adrien,
I understand the complexity of the data-base, and re-using them would be great.
But
Please tell me how you find them?
(there are a LOT at this point)
Once I Unpost and clean up incorrect invoices or bills they seem to vanish when 
I close its tab in the "Accounts" ribbon.

All the best,
Eric

Date: Wed, 31 Aug 2022 19:35:38 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] "Deleted" Invoices or Bills
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

They remain forever. (There was a decent explanation as to why recently on IRC 
- the short of it is that deleting them cleanly is simply too messy with the 
current code.)

My workflow in such cases is to change their ID to 'use next'. You can either 
create a dummy vendor/customer for them as well, or just leave them as-is since 
you can re-assign the vendor/customer before posting.

When I want to start a new bill/invoice, I do a find for 'use next' IDs, but 
that is pretty rare now as I just duplicate a previous document and edit from 
there. (and I don't think I have any 'use next' documents left
anyway.)

Regards,
Adrien

On 8/31/22 6:59 PM, Eric Hammond wrote:
> A different track
> In my hasty entering / importing of Invoices and Bill I find that some of 
> them are duplicates, or not needed.
> I can make them "disappear" by un-posting and clicking the delete button, but 
> where do they go?
> Does GnuCash automatically purge the trash? If not, how do I clean it up?
> Thanks for the help,
> Eric


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

[GNC] Question - Applying Credit notes to an outstanding invoice

[Nora]

Hi Gnucash users/helpers

 

I'm not sure how to apply a client's credit note to pay for another invoice
of the same client.

Thanks for you assistance.

 

Nora

 

 

 

 

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