[GNC] Report seems to pull wrong amount from transaction

[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, at 1:19 PM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> 
> 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 tables?
> 
> Something may be incorrect with the tax table, as it may be set to inclusive rather than exclusive. If this is a VAT situation, some tinkering may be in order.
> 
> 
> 
> 3. Do the specific transactions (when showing all splits) show the amount for that account as exactly $150 or $146? If the latter, what split(s) appear to balance out the $4 difference?
> 
> Since you only have three transactions, viewing that account register directly should be able to show if the amount is really $146 or $150. Make sure to either click the Splits button or use Auto-Split or Transaction Journal View.
> 
> 
> 
> 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?
> 
> If the total withdrawal was $150 but $146 of that went to say, ‘Cash’ and $4 went to ‘Fees’ then selecting ‘Cash’ in the report options would not generate the full $150 amount, but selecting ‘BankABC’ would.
> 
> 
> Please forgive if I’m misunderstanding the issue.
> 
> Regards,
> Adrien
> 
> 
> 
> 
> 
>> On May 12, 2020 w20d133, at 11:29 AM, Art Chimes <artsonline at gmail.com> wrote:
>> 
>> 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 transaction, unrelated to the automatic ones).  However, the
>> January withdrawal on the report shows an incorrect amount, a few
>> dollars less, $146.
>> 
>> All three accounts were subject to tax withholding. The January
>> withholding was different than the later withdrawals, but otherwise
>> the amount withdrawn from the account was the same in all monthly
>> withdrawals, i.e. $150.
>> 
>> A possible clue: When I click on the hyperlinked amount in the report,
>> it links to the correct account but not to the specific transactions.
>> (In other reports I spot-checked, it takes me directly to the
>> transaction.)
>> 
>> I could not reproduce this error in a few other random reports I generated.
>> 
>> Can you help?  Thanks.
>> 
>> Art