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.
