[GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Art Chimes
This seems like a bug to me, but maybe I'm missing something. I have an account from which I have a regular, automatic withdrawal scheduled with the financial institution. The amount is the same every month, let's say $150. My YTD report shows this year's three withdrawals to date (plus another t

[GNC] Report seems to pull wrong amount from transaction (errata)

2020-05-12 Thread Art Chimes
I'm using GnuCash 3.1 on Windows 10. Sorry for my violation of a cardinal rule of posting here. Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listi

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Adrien Monteleone
My first inklings would be to ask: 1. Do these transactions involve other currencies? Perhaps something is amiss with the FX rate, or the report option for commodity pricing needs some tweaking. 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax ta

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Adrien Monteleone
Addendum, Sorry I didn’t see the version info first. In that case, my first recommendation, before investigating any of my other questions, would be to update to 3.10 unless you really can’t for some reason. Many, many bugs have been fixed since 3.1. Regards, Adrien > On May 12, 2020 w20d133,

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Art Chimes
Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? ===No, stri

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread D. via gnucash-user
drien Monteleone Subject: Re: [GNC] Report seems to pull wrong amount from transaction Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Adrien Monteleone
The Transaction Report doesn’t offer this option. (not sure when it was removed or if it was never there) But I too suspect this is the case. Regards, Adrien > On May 12, 2020 w20d133, at 9:44 PM, D. wrote: > > I'd look at the price source used in the report (on the report options). It > sou

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-12 Thread Christopher Lam
The Transaction Report will convert a split amount to the nearest price if required. I think the OP is reporting issues with the TXF report. On Wed, 13 May 2020 at 03:44, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Transaction Report doesn’t offer this option. (not sure when

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-13 Thread Adrien Monteleone
Hmm.. Not sure why I had Transaction Report in my head. If the report in question is the TXF then indeed that price source option exists and selecting ‘Nearest Transaction Date’ *should* produce the correct results. Regards, Adrien > On May 12, 2020 w20d133, at 10:47 PM, Christopher Lam > wr

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-13 Thread Art Chimes
m: Art Chimes Sent: Wed May 13 01:57:24 GMT+05:30 2020 To: Gnucash Users , Adrien Monteleone Subject: Re: [GNC] Report seems to pull wrong amount from transaction Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-13 Thread Adrien Monteleone
Art, you’re welcome and I’m fine with just list messages. I’m glad you got it resolved. (just curious, is this a custom report?) The price db *should* get a ’transaction’ type entry for every such buy/sell transaction. You might need to have trading accounts turned on for that, I’m not certain.

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-13 Thread Art Chimes
The report started out as a blank transaction report (from the Reports>Transaction Report menu pulldown), which I then modified as required. Does that qualify as a "custom report"? I never heard of trading accounts, but from what I just read in the wiki, it seems to relate to multi-currency books,

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-15 Thread Derek Atkins
Art, Art Chimes writes: > My report apparently uses the number of shares x the price per share > to compute the dollar amount. Possibly the dollar value of the > transaction is not stored in the user's data file but rather is > computed on the fly? The incorrect dollar figure in the report was t

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-15 Thread Adrien Monteleone
> On May 12, 2020 w20d133, at 3:27 PM, Art Chimes wrote: > > > 4. Is your account selection in the Report Options limited to that one > account? Are you reporting on the account for the financial > institution, where the funds come from, or from the target account > where the funds land? > ===A

Re: [GNC] Report seems to pull wrong amount from transaction

2020-05-18 Thread Derek Atkins
Adrien Monteleone writes: > Originally I was thinking of the setting for GC to determine price by > ‘Most Recent’ or ‘Nearest In Time’, and such, but I see the > Transaction Report doesn’t have it. As indeed it shouldn't. A transaction has a fixed exchange rate, and that's the exchange rate tha

[GNC] Report seems to pull wrong amount from transaction (errata #2)

2020-05-12 Thread Art Chimes
Make that GnuCash **3.10** on Windows 10. Sorry: lousy typist worse proofreader ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-u