Re: [GNC] Transaction ordering on num field
For those that care, it is perfectly easy to have numbers sort correctly with an alphanumeric sort, simply include the leading zeros. If you think your check numbers will never exceed 1000, just number the checks: 0001, 0002,... 0100, 0101, etc.If you expect to write more than 1000, add another leading 0. Will On 2021 Jun 10, at 06-10 01:40:24, flywire wrote: How can special customisation to sort a GnuCash field be justified when it makes future transitions even more difficult? This field should be sorted in a standard way. It's clearly the old *numeric* field for sorting cheques, and the banks tell us cheques are as good as dead. When it was changed to alphanumeric the sort order should have changed too, ie 10 before 2. I note David's comment on current functionality. Significant changes should occur at major versions. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org 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 gnucash-user@gnucash.org 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.
Re: [GNC] Transaction ordering on num field
My bank doesn't print leading zeros on my checks On Thu, Jun 10, 2021 at 9:42 AM w...@theprescotts.com wrote: > For those that care, it is perfectly easy to have numbers sort correctly > with an alphanumeric sort, simply include the leading zeros. > If you think your check numbers will never exceed 1000, just number the > checks: 0001, 0002,... 0100, 0101, etc.If you expect to write more than > 1000, add another leading 0. > > Will > > On 2021 Jun 10, at 06-10 01:40:24, flywire wrote: > > How can special customisation to sort a GnuCash field be justified when it > makes future transitions even more difficult? This field should be sorted > in > a standard way. It's clearly the old *numeric* field for sorting cheques, > and the banks tell us cheques are as good as dead. When it was changed to > alphanumeric the sort order should have changed too, ie 10 before 2. > > I note David's comment on current functionality. Significant changes should > occur at major versions. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 > gnucash-user@gnucash.org > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Transaction ordering on num field
. put a 100 as prefix last you a few years ... looking at an old CQ book and that is how mine are numbered. Haven't used one for quite a while now though 😊 David -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: 10 June 2021 15:46 To: w...@theprescotts.com Cc: GnuCash Users Subject: Re: [GNC] Transaction ordering on num field My bank doesn't print leading zeros on my checks On Thu, Jun 10, 2021 at 9:42 AM w...@theprescotts.com wrote: > For those that care, it is perfectly easy to have numbers sort > correctly with an alphanumeric sort, simply include the leading zeros. > If you think your check numbers will never exceed 1000, just number > the > checks: 0001, 0002,... 0100, 0101, etc.If you expect to write more > than 1000, add another leading 0. > > Will > > On 2021 Jun 10, at 06-10 01:40:24, flywire wrote: > > How can special customisation to sort a GnuCash field be justified > when it makes future transitions even more difficult? This field > should be sorted in a standard way. It's clearly the old *numeric* > field for sorting cheques, and the banks tell us cheques are as good > as dead. When it was changed to alphanumeric the sort order should > have changed too, ie 10 before 2. > > I note David's comment on current functionality. Significant changes > should occur at major versions. > > > > -- > Sent from: > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 > gnucash-user@gnucash.org > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org 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 gnucash-user@gnucash.org 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.
Re: [GNC] Transaction ordering on num field
> On Jun 10, 2021, at 8:14 AM, > wrote: > > . put a 100 as prefix last you a few years ... looking at an old CQ > book and that is how mine are numbered. > > Haven't used one for quite a while now though 😊 All very well if one is starting a new book, but it's unreasonable to require a user with many years of data to renumber hundreds of checks. The proposed change doesn't affect users who have fully-numeric entries, those will continue to sort numerically. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Transaction ordering on num field
> On Jun 9, 2021, at 11:40 PM, flywire wrote: > > How can special customisation to sort a GnuCash field be justified when it > makes future transitions even more difficult? This field should be sorted in > a standard way. It's clearly the old *numeric* field for sorting cheques, > and the banks tell us cheques are as good as dead. When it was changed to > alphanumeric the sort order should have changed too, ie 10 before 2. > > I note David's comment on current functionality. Significant changes should > occur at major versions. None of my banks have told me that checks are dead, though I certainly try to write as few as possible these days. Regardless, my books go back 25 years and have lots of check numbers in them. The num filed has always been a free string, you can put whatever you want in it, but the sort is a very simple comparison of calls to a C standard library function (atoi) that converts leading digits to numbers. The whole point of this thread is to find out if anyone thinks this is a significant change. I guess you do, so please explain in detail, including whether it actually affects your use of GnuCash and if so how. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Check printing
I'm getting to the point that I can rarely read my own handwriting. So I started playing with printing checks from GC bank reisters. I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??) It works - sometimes. If I "print" a check, and the printer mis-behaves, I can't reprint it! The other day, I needed to write eight checks to different parties, other than the payee, the checks were the same, I could only print one of them! I had to hand write the others. Is there any way that I can get a check to reprint? Or, to print multiple nearly identical checks? Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Modify check templet
Where can I find information on the check templets? I have found 'quicken_3part.chk' which are text documents. I need something that will help me understand what the various parts are. I currently use the 4th address line as a memo and I want to print this line on the stubs on the stubs. Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Transaction ordering on num field
What about 999a and 999b? Those currently evaluate equal so that the sort routine will proceed to the next criterion, date_entered. ISTM this would be something of a special case where preserving numerical ordering makes sense only in the case of leading numbers followed by a very few alpha characters. The example of 999a vs. 1000a is simple, but what to do with 10xr79b2 vs 9z54rq8e? I think most people would agree that that should be sorted lexically so that 10xr79b2 comes before 9z54rq8e. Such a scheme would allow the possibility of abcd and 10xyz and it's not possible to tell which rule should govern when looking at that pair in isolation. Collating algorithms work pairwise. Worse, your comment about auto numbering suggests that you might want to mix the styles so even running through all of the transactions to determine a pattern would produce a result the user might not like. Good point about case sensitivity. I can't think of any good argument for sorting to be case sensitive. Can anyone else? The proposed change wouldn't affect auto-numbering, only sort. Regards, John Ralls > On Jun 8, 2021, at 2:20 PM, David Carlson wrote: > > I would prefer 999a to sort before 1000a and character sorts to be case > insensitive, but I do not depend on that for any purpose. > > I do, however, depend on the auto numbering function ignoring strings > containing non-numeric characters as it currently does, so it currently only > increments numbers and still numbers the next check correctly if I use > non-numeric characters in transactions that do not represent checks. > > Those are my preferences! > > On Tue, Jun 8, 2021 at 1:37 PM John Ralls wrote: > Really the effective num field because of the split-action option, but > anyway... > > The submitter of PR#963 complained that sorting on the num field doesn't work > right if the value is bigger than an int can hold; that's 9 digits. His > knowledge of C wasn't quite up to the task of fixing it, but I've fixed his > implementation and have it ready to push for GnuCash 4.6. > > So far so good, but it changes the order of transactions when the num field > isn't all numeric and I want to know if the change will cause trouble for > anyone. > > The current behavior is that a string beginning with a letter will have a > sort value of 0 and one starting with a number will have a value equal to the > numbers up to the first non-number character, so for example 12ab34 will have > a sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort equally so > the compare would fall through to the next criterion; "abc" would sort > between "-12ab34" and "12ab34". > > The new way is that if both strings are all numbers and there are fewer than > 19 characters in each then the sort values will be their numeric values and > the comparison will be numeric, so e.g. 2 sorts before 10. If those > conditions aren't true then the two values will be string-compared, meaning a > lexical sort: A very large number beginning with 2 will sort before a shorter > number beginning with 3; "abc" will sort before "def" but after both "123" > and "-123" because 1 and - sort before a. That's for an English locale; in > order to accommodate UTF-8 strings the collation of the current locale. > > Will that break anyone's carefully-crafted transaction ordering? > > Regards, > John Ralls > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. > > > -- > David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Check printing
A few days ago the MICR printer cartridge that I used to use popped up out of some black hole so I may try printing checks again. As I recall, tho it used to be reasonably easy to print test checks on plain paper first, then just be sure the desired transactions had the word print in the Num field. Oh, there was a trick to matching up check numbers which now slips my mind. I suppose that is the issue Bruce is wrestling with. On Thu, Jun 10, 2021, 12:08 PM Bruce Irving wrote: > I'm getting to the point that I can rarely read my own handwriting. So I > started playing with printing checks from GC bank reisters. > I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version > 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??) > It works - sometimes. If I "print" a check, and the printer mis-behaves, I > can't reprint it! The other day, I needed to write eight checks to > different parties, other than the payee, the checks were the same, I could > only print one of them! I had to hand write the others. > Is there any way that I can get a check to reprint? Or, to print multiple > nearly identical checks? > Bruce > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
Re: [GNC] Check printing
I am using preprinted check stock that has the MICR already on it. I don.t need to use MICR printing Bruce On Thu, Jun 10, 2021 at 10:39 AM David Carlson wrote: > A few days ago the MICR printer cartridge that I used to use popped up out > of some black hole so I may try printing checks again. As I recall, tho > it used to be reasonably easy to print test checks on plain paper first, > then just be sure the desired transactions had the word print in the Num > field. Oh, there was a trick to matching up check numbers which now slips > my mind. > > I suppose that is the issue Bruce is wrestling with. > > > > On Thu, Jun 10, 2021, 12:08 PM Bruce Irving wrote: > >> I'm getting to the point that I can rarely read my own handwriting. So I >> started playing with printing checks from GC bank reisters. >> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version >> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??) >> It works - sometimes. If I "print" a check, and the printer mis-behaves, >> I >> can't reprint it! The other day, I needed to write eight checks to >> different parties, other than the payee, the checks were the same, I could >> only print one of them! I had to hand write the others. >> Is there any way that I can get a check to reprint? Or, to print multiple >> nearly identical checks? >> Bruce >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> 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 gnucash-user@gnucash.org 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.
Re: [GNC] Check printing
What I would do under your circumstances is fill out all the details in the register for the first one, duplicate transaction and edit the payee and number fields, and so on until I had them all in the register. Then command-p on the Mac for each of them. It might be control-p on your platform I don’t know. Does that not work? Sent from my iPhone > On Jun 10, 2021, at 12:46 PM, Bruce Irving wrote: > > I am using preprinted check stock that has the MICR already on it. I don.t > need to use MICR printing > Bruce > >> On Thu, Jun 10, 2021 at 10:39 AM David Carlson >> wrote: >> >> A few days ago the MICR printer cartridge that I used to use popped up out >> of some black hole so I may try printing checks again. As I recall, tho >> it used to be reasonably easy to print test checks on plain paper first, >> then just be sure the desired transactions had the word print in the Num >> field. Oh, there was a trick to matching up check numbers which now slips >> my mind. >> >> I suppose that is the issue Bruce is wrestling with. >> >> >> >>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving wrote: >>> >>> I'm getting to the point that I can rarely read my own handwriting. So I >>> started playing with printing checks from GC bank reisters. >>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version >>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??) >>> It works - sometimes. If I "print" a check, and the printer mis-behaves, >>> I >>> can't reprint it! The other day, I needed to write eight checks to >>> different parties, other than the payee, the checks were the same, I could >>> only print one of them! I had to hand write the others. >>> Is there any way that I can get a check to reprint? Or, to print multiple >>> nearly identical checks? >>> Bruce >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> 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 > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
