[GNC] Odd behavior on Transaction Report

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Odd behavior on Transaction Report

Stephen M. Butler
While balancing our checking account we ran into odd behavior on the 
transaction report.

The running balance column goes backwards when there are multiple
transactions on the same day.  For example:

05/17/2018 1213 xxxxx
        Green House
        $40.00 <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
$2,863.80 <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
05/18/2018 1195 xxxx
        Green House
        $2,250.00 <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1fa6#>
$1,564.45 <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1fa6#>
05/18/2018
        Ixxxx
        IHSA
        $126.58 <gnc-register:trans-guid=99e89375cb395cf6008fc3beea504257#>
$3,814.45 <gnc-register:trans-guid=99e89375cb395cf6008fc3beea504257#>
05/18/2018
        xxx
        Church
        $822.77 <gnc-register:trans-guid=724233f33cd8113781d90f804e6de03a#>
$3,941.03 <gnc-register:trans-guid=724233f33cd8113781d90f804e6de03a#>
05/18/2018
        xxx
        Cash.
        $200.00 <gnc-register:trans-guid=8064104e4955e72212a53f35071a508f#>
$4,763.80 <gnc-register:trans-guid=8064104e4955e72212a53f35071a508f#>
05/18/2018
        Transfer
        Money Market $2,100.00
<gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f9f#>
        $4,963.80 <gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f9f#>



Notice how the running balance jumps from line 1 to line 6 then works
itself upwards back to line 2.  Then it jumps to line 7 (not shown).
Made for an interesting hour until the accountant figured out what was
going on.

--
Stephen M Butler, PMP, PSM
[hidden email]
[hidden email]
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Odd behavior on Transaction Report

Christopher Lam
Hi Stephen
The Running balance is directly retrieved from the split data; the ordering
of same-day splits is, I believe, dependent on the order of data entered.
If it matters try setting one of the sortkeys to 'register order' - it may
work.... but even if it does, the custom sorter will sort strictly by date,
so, the running balances will have unpredictable order.
C

On 2 July 2018 at 12:07, Stephen M. Butler <[hidden email]> wrote:

> While balancing our checking account we ran into odd behavior on the
> transaction report.
>
> The running balance column goes backwards when there are multiple
> transactions on the same day.  For example:
>
> 05/17/2018      1213    xxxxx
>         Green House
>         $40.00 <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
> $2,863.80 <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
> 05/18/2018      1195    xxxx
>         Green House
>         $2,250.00 <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1f
> a6#>
> $1,564.45 <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1fa6#>
> 05/18/2018
>         Ixxxx
>         IHSA
>         $126.58 <gnc-register:trans-guid=99e89375cb395cf6008fc3beea5042
> 57#>
> $3,814.45 <gnc-register:trans-guid=99e89375cb395cf6008fc3beea504257#>
> 05/18/2018
>         xxx
>         Church
>         $822.77 <gnc-register:trans-guid=724233f33cd8113781d90f804e6de0
> 3a#>
> $3,941.03 <gnc-register:trans-guid=724233f33cd8113781d90f804e6de03a#>
> 05/18/2018
>         xxx
>         Cash.
>         $200.00 <gnc-register:trans-guid=8064104e4955e72212a53f35071a50
> 8f#>
> $4,763.80 <gnc-register:trans-guid=8064104e4955e72212a53f35071a508f#>
> 05/18/2018
>         Transfer
>         Money Market    $2,100.00
> <gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f9f#>
>         $4,963.80 <gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f
> 9f#>
>
>
>
> Notice how the running balance jumps from line 1 to line 6 then works
> itself upwards back to line 2.  Then it jumps to line 7 (not shown).
> Made for an interesting hour until the accountant figured out what was
> going on.
>
> --
> Stephen M Butler, PMP, PSM
> [hidden email]
> [hidden email]
> 253-350-0166
> -------------------------------------------
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Odd behavior on Transaction Report

Stephen M. Butler
On 07/02/2018 06:02 PM, Christopher Lam wrote:
> Hi Stephen
> The Running balance is directly retrieved from the split data; the
> ordering of same-day splits is, I believe, dependent on the order of
> data entered.
> If it matters try setting one of the sortkeys to 'register order' - it
> may work.... but even if it does, the custom sorter will sort strictly
> by date, so, the running balances will have unpredictable order.
> C
>

Yuck.  To bad the report doesn't recalculate the balances in the order
of the sort.

> On 2 July 2018 at 12:07, Stephen M. Butler <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     While balancing our checking account we ran into odd behavior on the 
>     transaction report.
>
>     The running balance column goes backwards when there are multiple
>     transactions on the same day.  For example:
>
>     05/17/2018      1213    xxxxx   
>             Green House     
>             $40.00
>     <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
>     $2,863.80 <gnc-register:trans-guid=6734c08cadc7b283f6d017249cef1f59#>
>     05/18/2018      1195    xxxx   
>             Green House     
>             $2,250.00
>     <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1fa6#>
>     $1,564.45 <gnc-register:trans-guid=9ca2dd73a33bd8732c5aca13aaae1fa6#>
>     05/18/2018     
>             Ixxxx   
>             IHSA   
>             $126.58
>     <gnc-register:trans-guid=99e89375cb395cf6008fc3beea504257#>
>     $3,814.45 <gnc-register:trans-guid=99e89375cb395cf6008fc3beea504257#>
>     05/18/2018     
>             xxx     
>             Church 
>             $822.77
>     <gnc-register:trans-guid=724233f33cd8113781d90f804e6de03a#>
>     $3,941.03 <gnc-register:trans-guid=724233f33cd8113781d90f804e6de03a#>
>     05/18/2018     
>             xxx     
>             Cash.   
>             $200.00
>     <gnc-register:trans-guid=8064104e4955e72212a53f35071a508f#>
>     $4,763.80 <gnc-register:trans-guid=8064104e4955e72212a53f35071a508f#>
>     05/18/2018     
>             Transfer       
>             Money Market    $2,100.00
>     <gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f9f#>     
>             $4,963.80
>     <gnc-register:trans-guid=b4688a9ed77cc8de4850978704754f9f#>
>
>
>
>     Notice how the running balance jumps from line 1 to line 6 then works
>     itself upwards back to line 2.  Then it jumps to line 7 (not shown).
>     Made for an interesting hour until the accountant figured out what was
>     going on.
>
>     --
>     Stephen M Butler, PMP, PSM
>     [hidden email] <mailto:[hidden email]>
>     [hidden email] <mailto:[hidden email]>
>     253-350-0166
>     -------------------------------------------
>     GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>     _______________________________________________
>     gnucash-user mailing list
>     [hidden email] <mailto:[hidden email]>
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>
>

--
Stephen M Butler, PMP, PSM
[hidden email]
[hidden email]
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Odd behavior on Transaction Report

Derek Atkins
Stephen,

"Stephen M. Butler" <[hidden email]> writes:

> On 07/02/2018 06:02 PM, Christopher Lam wrote:
>> Hi Stephen
>> The Running balance is directly retrieved from the split data; the
>> ordering of same-day splits is, I believe, dependent on the order of
>> data entered.
>> If it matters try setting one of the sortkeys to 'register order' - it
>> may work.... but even if it does, the custom sorter will sort strictly
>> by date, so, the running balances will have unpredictable order.
>> C
>>
>
> Yuck.  To bad the report doesn't recalculate the balances in the order
> of the sort.

This is done for good reason.  Imagine what would happen if you exclude
certain transactions from the report.  Then your balances would be
COMPLETELY off!

>>     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, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-user mailing list
[hidden email]
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.