[GNC] What determines the order of transaction is CSV file?

[Dr. David Kirkby]

On Fri, 23 Dec 2022 at 23:06, David Cousens <davidcousens49 at gmail.com>
wrote:

>
> Dave,
>
> Not sure how you achieved that. I just exported one of my accounts and it
> appears to be in date order from the first transaction entered (2015)
> until the
> last (a few days ago). I haven't checked the whole file but the first and
> last
> hundred or so transactions at each end are all in data order. My
> transactions
> are usually imported from downloaded OFX files so they are generally
> imported in
> date order. I used the first to last option in the export dialogue rather
> than
> the date range. As long as the first date is before the last date that
> should
> work the same though AFAIK
>
> David Cousens


Thank you. My transactions were entered manually, so I don’t have a strict
numerical input. However, I was aiming to input them in order, and doubt
that they were not input in quite such a random way.

I am pretty sure that I used first to last.

I thought that GnuCash would either sensible defaults for numbers if none
were specified. Although I specified the starting invoice number, I didn’t
specify the bill number initially, as I have not associated a number with a
bill in the past. I noticed that the export had no bill number - I expected
it to start them at 1. I did later set the starting bill as 1000, but the
bills are exported in a random order too.

Opening balances are randomly distributed throughout the CVS file too -
they are not all at the top or bottom like I would have expected.

I hope that I can resolve this issue, as it’s a pretty important one.

Dave
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkirkby at kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom