David, Adrian is talking about the num field in scheduled transactions.
Regards, John Ralls > On 11 Apr 2025, at 12:06, David Carlson <david.carlson....@gmail.com> wrote: > > Adrian_Jolly, > > The check number is controlled in the check printing process rather than > the scheduled transaction process. There it is possible to correct for > misprints, etc. > > As for simply giving each transaction a unique ID number in the Since Last > Run process, I never tried that myself. > > > > On Fri, Apr 11, 2025 at 10:33 AM Adrian Jolly via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Thanks for your responses, but I’m still unclear. >> >> >> >> Simple question – please answer Yes or No >> >> >> >> Can I enter a formula into a scheduled transaction so that the check >> number (Num field) will automatically increment? >> >> >> >> If the answer is Yes, can you help me make it work with a bit more detail >> and guidance >> >> >> >> If the answer is NO then thanks for your honesty and do you know of any >> workarounds that I might consider to achieve this function >> >> >> >> Many thanks >> >> Adrian >> >> >> >> From: R Losey <rlo...@gmail.com> >> Sent: 11 April 2025 02:32 >> To: David H <hell...@gmail.com> >> Cc: adrian_jo...@btinternet.com; gnucash-user@gnucash.org >> Subject: Re: [GNC] Help with using formula in NUM field of Scheduled >> Transactions >> >> >> >> Can I enter a formula into a scheduled transaction so that the check >> number will fill in with the next one? >> >> >> >> >> >> On Thu, Apr 10, 2025 at 7:48 PM David H <hell...@gmail.com <mailto: >> hell...@gmail.com> > wrote: >> >> Check the wiki at https://wiki.gnucash.org/wiki/Scheduled_Transactions >> ??? >> >> Variables and Formulas were introduced to serve the *mortgage/loan druid* >> in >> 2002. Variables and Formulas work only in cells like Deposit and Withdrawal >> (or Debit and Credit if you have formal account names turned on) that >> require something that evaluates to a number. >> >> 1. Any text string [not followed by parens] entered in the template >> transaction will be recognized as a *variable*, and you will be prompted >> to provide a value when the scheduled transaction is created. >> 2. Any text string *followed by parens*, optionally with arguments, will >> have the string "gnc:" prepended to it and *evaluated in the scheme >> environment*.*Arguments* are separated with :. See fin.scm >> <https://github.com/Gnucash/gnucash/blob/stable/bindings/guile/fin.scm> >> for >> examples of providing functions. >> 3. There is a *magic variable* '*i'*, which stands for the *current >> instance-count of the scheduled transaction*. 1 for the first, 2 for the >> second, &c. It might be 0-based. >> >> >> - I'd like to have a variable which decrements each month, in order to >> automatically calculate sum-of-digits depreciation. >> >> In any case, if you know the starting point, "(42 - i)" should work. >> Cheers David H. >> >> On Fri, 11 Apr 2025 at 09:43, Adrian Jolly via gnucash-user < >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > wrote: >> >>> I require to schedule a weekly transaction, where the Num field >> increments >>> by 1 for each transaction >>> >>> >>> >>> My template has " i + 1 " (without the quotes), in the Num field. But >> all I >>> get is " i + 1 " (without the quotes) in each and every transaction. >> What >>> am I doing wrong? >>> >>> >>> >>> >>> >>> >>> >>> Adrian >>> >>> >>> >>> >>> >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> ----- >>> 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 <mailto:gnucash-user@gnucash.org> >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> >> >> >> >> >> >> -- >> >> _________________________________ >> Richard Losey >> rlo...@gmail.com <mailto:rlo...@gmail.com> >> Micah 6:8 >> >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> 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 > ----- > 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 ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
