HI,
Are you willing to share your data file? Or create a small data file
that shows the issue?
If neither is possible, could you create screen shots of all the registers
and the report, along with the account settings, report settings, and user
preferences?
-derek
On Thu, December 8, 2022 8:10 pm, rov...@comcast.net wrote:
> Accounts are set up identical in ver 2.2.6 and 4.1.2. The "reverse sign"
> preference is set as credit in both versions.
> The transaction report is identical in both versions other than the Total
> dollars being positive in the expense section in ver 4.1.2 vs dollars
> being negative in 2.6.6
>
> Thanks
> Joe
>
> -----Original Message-----
> From: Derek Atkins <de...@ihtfp.com>
> Sent: Thursday, December 8, 2022 4:56 PM
> To: rov...@comcast.net
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Transaction Report
>
> HI,
>
>
> On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote:
>> Hope this explains it better
>>
>>
>>
>>
>>
>> There are two accounts in the transaction report
>>
>>
>>
>> Expense Type A/Payable
>
> An A/Payable account is not an expense. It is a liability.
>
>>
>> Income Type Bank
>
> Similarly, a Bank account is not an income.
>
>>
>>
>>
>> In the expense account register transactions show as a positive number
>> in the payment/debit column and the balance column is a negative
>> number that augments negative as transaction are added.
>
> It sounds like your accounts are not set up correctly.
>
>>
>>
>>
>> In the Income account register transactions show as a positive number
>> in the deposit/debit column and the balance column is a positive
>> number that augments positive as transaction are added.
>
> Yes, because it's not Income, it is a Bank that you "labeled" Income. And
> yes, in a Bank account, a debit increases the account value/total.
>
>>
>>
>>
>> The report is a simple one that shows all expense transactions form
>> the Expense Account as a debit/payment negative dollar amount and all
>> transactions from the Income Account as a debit/deposit positive
>> dollar amount. So in the end my grand total should be the negative sum
>> of all transactions in the Expense account minus the sum of all
>> positive transaction in the income account.
>>
>>
>>
>> Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the
>> expense account Totals show as a positive number so Instead of
>> subtracting expense from income they add together in the grand total.ie.
>>
>>
>>
>> Ver 2.6.1 Expense Total ($-1200) Income Total $2400 Grand
>> total
>> $1200
>>
>> Ver 4.1.2 Expense Total $1200 Income Total $2400 Grand
>> total
>> $3600
>
>
> You might want to check the value of your "reverse sign" preference.
> I suspect it's not the same.
>
>>
>>
>>
>> Thanks
>>
>> Joe
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
> Derek Atkins 617-623-3745
> de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
>
>
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
_______________________________________________
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.
