Custom .scm script: Query account balance

Derek Atkins warlord at MIT.EDU
Tue Oct 4 10:10:26 EDT 2016


Hi,

Eric Wheeler <gnucash-devel at lists.ewheeler.net> writes:

> Hello all,
>
> I would like to update our invoice .scm template to include a balance from 
> an account containing the customer's name (this is separate from any 
> accounts receivable, it is a retainer liability account).
>
> I tried digging through the account piechart.scm and the taxinvoice.scm to 
> see if I can come up with a way to query the account something like this:
>
> gnc:account-get-comm-balance-at-date append("Liabilities::Retainers::" coyname)

First, you probably don't need the double-colons.

> But I'm not sure how to pass today's date. It's been years since I've 
> written scheme so any help would be greatly appreciated!

(current-time) ??   Or perhaps (localtime (current-time)) -- depending
on what you need.

> -Eric
>
> --
> Eric Wheeler
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

-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-devel mailing list