Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread list+gnucash
Bo: Thank you for a good question! John Ralls already gave you an answer, and it is correct. John writes the code, he knows whereof he speaks. But let me try to explain it a different way. On 2025-02-09 04:36, Bo Buckley wrote: ...I recently tried to add a JPY checking account to my books..

Re: [GNC] Searching mailing lists

2025-02-09 Thread Liz
On Sun, 9 Feb 2025 20:21:59 +0900 Bo Buckley wrote: > > According to the mailing list docs: > > > Currently, there is no on-site mechanism to search the mailing lists > > *and the search link on the archive page is broken.*Instead, use > > the term "site:lists.gnucash.org" at Google or Yahoo! to

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread John Ralls
> On Feb 9, 2025, at 17:32, Bo Buckley wrote: > @John Ralls, would you be able to point to where in the codebase this is > handled (i.e. where the Exchange Rate from the Transfer Funds Dialog is > taken and how the Price Database entry Price is calculated?) I'd understand > a lot better seeing th

Re: [GNC] confusion on new fields in csv import

2025-02-09 Thread David Cousens
David I think the main issue is there is no well defined protocol/standard for CSV data and the importer does not know where the CSV file originates and whether the data is presented from the perspective of the entity which provided the data or that of the entity which has received the data which

Re: [GNC] Searching mailing lists

2025-02-09 Thread David Cousens
I am not sure what the official position is re the mail archive site. AFAIK it mirrors posts to the official lists which are maintained by the GnuCash team and moderated by Liz. I just find it much easier to locate posts and threads on the mail archive site that in the official mailing lists. davi

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread Bo Buckley
Thank you for another reply John. What you explain makes sense to me, but it is not the observed behavior from my version of GNUCash. If it were the same, I would not have an issue. Let me use your same example values. You postulated an exchange rate of $0.66/100¥. Suppose you have two splits, >

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread sunfish62--- via gnucash-user
I hesitate to jump in here, since you've already got the best advisor in John, but... You keep entering the exchange rate, and it's been stated clearly before that the exchange rate is not stored and is not reliable. You mentioned in passing previously that you don't know the destination amoun

Re: [GNC] Searching mailing lists

2025-02-09 Thread David Cousens
As well as the method Liz mentioned it is also possible to access and search the mailing list archives at https://www.mail-archive.com/gnucash-user@gnucash.org/ https://www.mail-archive.com/gnucash-devel@gnucash.org/ You need to have existing membership of the mailing list. I cannot remember

Re: [GNC] Searching mailing lists

2025-02-09 Thread Bo Buckley
Thank you for the links David. That is helpful. Is this link not listed in the docs anywhere? If not, are you not seeing a bunch of duplicate questions in the mailing lists? Seems like having a clearly explained method for searching for duplicates would be of somewhat high priority to keep the list

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread Bo Buckley
Dear John and Jim, Thank you for your replies. Though I'm not sure they solve my problem. Consequently for best results enter the correct amount in the register and > the value in the exchange rate dialog and let GnuCash calculate the > price/exchange rate. > In your example, when importing each

Re: [GNC] Searching mailing lists

2025-02-09 Thread sunfish62--- via gnucash-user
https://wiki.gnucash.org/wiki/Mailing_Lists ⁣David T.​ On Feb 10, 2025, 8:23 AM, at 8:23 AM, David Cousens wrote: >I am not sure what the official position is re the mail archive site. >AFAIK it mirrors posts to the official lists which are maintained by >the GnuCash team and moderated by Liz.

Re: [GNC] confusion on new fields in csv import

2025-02-09 Thread sunfish62--- via gnucash-user
David, I was not confused about the reasons for the change in terminology.  OP indicated confusion about that change in terminology, and asked how the new terms related to their past experience. I was attempting to provide that connection. I don't use csv much at all with GnuCash, preferring

[GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread Bo Buckley
Version: 5.9 Build ID: Flathub 5.9 Finance::Quote: 1.63 I recently tried to add a JPY checking account to my books, and import all the transactions from 2024. Following along with the docs, I was able to get most transactions to look as expected: https://lists.gnucash.org/docs/C/gnucash-guide/cur

Re: [GNC] Settings for low-vision users?

2025-02-09 Thread Jediator
The easiest way is to change/lower the resolution on your screen display (on Windows using Settings/Control Panel, on Mac using System Settings).  This will help not only with GNC, but also all apps on your computer. -- ND On 2/8/25 10:27 PM, David H wrote: Hi Fred, You don't say what OS an

Re: [GNC] confusion on new fields in csv import

2025-02-09 Thread Michael or Penny Novack via gnucash-user
On 2/9/2025 5:11 AM, David Cousens wrote: David I think the main issue is there is no well defined protocol/standard for CSV data and the importer does not know where the CSV file originates and whether the data is presented from the perspective of the entity which provided the data or that of t

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

2025-02-09 Thread John Ralls
The price database contains only one exchange rate per day. All amounts and values are rounded to the commodity’s minimum fraction, which is 1 for JPY and .01 for USD. Each split in a transaction has an amount in the split’s account commodity and a value in the transaction currency. The transac

Re: [GNC] Invoice configuration?

2025-02-09 Thread John Ralls
Latest is 5.10. If you built from git then you’ve got whatever was the stable HEAD when you pulled. That might report the version as 5.01+15-gX where is the sha1 hash for whatever commit it was. You can save anything you change in report options as a saved report configuration. To use

Re: [GNC] Invoice configuration?

2025-02-09 Thread Simon Roberts
Many thanks John (yes, version wise, I'm using 5.5 for my business, and just built the latest for my wife. I guess that's 5.10, add 'em together and ... yeah well, you can tell I wasn't looking at hers at the time I wrote the question) But huge thanks, I am playing with that now and it seems to wo

Re: [GNC] confusion on new fields in csv import

2025-02-09 Thread Steve Butler
I had to experiment with the fields to find that amount negated worked the best for me. Make a copy of your file and run experiments using the different amount fields to see what happens. Once you find a setup that works for you, switch back to your production file and move forward. On Sat, Feb