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 <[email protected] > <mailto:[email protected]>> 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 > [email protected] <mailto:[email protected]> > [email protected] <mailto:[email protected]> > 253-350-0166 > ------------------------------------------- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > _______________________________________________ > gnucash-user mailing list > [email protected] <mailto:[email protected]> > 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 [email protected] [email protected] 253-350-0166 ------------------------------------------- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 _______________________________________________ gnucash-user mailing list [email protected] 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.
