transactions order

Derek Atkins warlord at MIT.EDU
Mon Jan 13 14:22:26 EST 2014


Hi,

"John R. Sowden" <jsowden at americansentry.net> writes:

> Is there a setting to set the order of transactions (actual entry
> vs. date)?  Can I reindex so the physical records are in the order
> that I select?
>
> Example:  I enter empty opening balance transactions, then I start
> entering transactions.  After a couple of weeks, I go back and flesh
> out the data for the opening balance transactions.
>
> I would want to reindex on date, then make the physical records in
> that order.

I'm not sure exactly what you're asking.  The transactions get ordered
by:

 1) Post Date (the date you see in the register)
 2) Number Column (this is a numeric compare, not a string compare)
 3) Date Entered (this is the date/time the transaction was created, not
    visible or editable)

It sounds like what you do is:

1) Enter an O-B txn on Date X
2) Enter a bunch of transactions after date X
3) Go back and then want to enter a bunch of transactions *before* date
   X and adjust the O-B accordingly

You can *ONLY* do #3 if you have *not* reconciled the account.
If you HAVE reconciled the account then when you modify the O-B
transaction you will break you reconcile balance.  If you *DO* do this
you'll need to re-reconcile again and mark the (now broken) O-B txn and
all the new adjustment txns as reconciled.

In general we recommend that you don't do this.  Once you start
reconciling an account you should never add more history and should only
move forward in time.   By definition the O-B is basically "up to this
time there was many transactions that I don't care about enumerating
that tally up to this amount".

So... once you choose a start date you should stick to it.

> tia,
>
>
> John

> 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
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list