I'm not sure if this is expressible in BQL (I'm not at my computer right now to try this out), but conceptually you could write a query that sums up the amount of each posting from your "Accounts Receivable" account, grouped by tag. Then filters out tags that don't match your invoice tag pattern, and then filters out groups that have a zero sum.
If this isn't expressible in BQL, you could use beancount's Python API to do this in Python with probably only a few lines of code. Gary On Friday, May 31, 2024 at 3:07:34 PM UTC+2 Maurice de Laat wrote: > Hello all! > > First message, let me start by thanking for such a wonderful piece of > software! > > Currently seeking my way through beancount and fava and wondering what > would be a good way to find invoices that have yet to be payed. > > I could tag an incoming or outgoing invoice with p.e. "^tobepayed", and > remove that tag when the invoice is being payed, but that would mean that I > would have to change a previous transaction's tag which seems as not the > most practical thing to do. > > Currently I do have an unique tag for each invoice which is being used > when the invoice is received as well as when the invoice is being payed. It > would be great if I could use these tags to find the invoices yet to be > payed. > > Any thoughts? > Thank you! > Maurice > -- 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/9855d558-5cca-447f-8d36-a45c4edc8123n%40googlegroups.com.
