Hi,
I am using the query below to get a list of outstanding payments:
SELECT
last(date), leaf(account), sum(position) as outstanding
WHERE
account ~ "AccountsReceivable"
GROUP BY leaf(account)
ORDER BY outstanding DESC
It works as intended but it also lists the zero balance accounts. Is there
a way to exclude them?
Thanks.
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/7ac22da0-d4a8-42ea-85dc-facd8073520fn%40googlegroups.com.
