Thanks for the tip! I did not notice the edit that was added last year. So, hledger now has this built in. That's good to know. Cheers!
On Thursday, 3 July 2025 at 8:49:07 pm UTC+2 [email protected] wrote: > Hi Alen, > > Thanks for that link. The FAQ link there points to hledger, and a quick > > beancount2ledger bean.bc > ledgerfile > hledger -f ledgerfile aregister checking cc > > gives the report I was looking for. > > Thanks, > > -k. > > On 2025-07-03 at 11:32 -07, 'Alen Šiljak' via Beancount > <[email protected]> wrote... > > Oohhh, I had this question a couple of years ago. > > > > > https://money.stackexchange.com/questions/154316/how-can-i-identify-all-transfers-from-account-a-to-account-b-in-ledger-cli > > > > Simon Michael did a good job getting close to solution but these > > systems are inherently not made for such a thing, unfortunately. If > > (or when) there is a JOIN statement in bean-query, it would be > > possible to construct a query that selects postings that are to either > > of the desired accounts, along with their transaction id, then pivot > > on the transaction id. This would still not be ideal but would be > > close. The other, more realistic option at the moment, would be to do > > it in two steps using a query and a print, then use the new file for a > > separate query. Anyway, still an interesting and unresolved (in an > > elegant matter) question. > > > > On Thursday, 3 July 2025 at 5:58:14 pm UTC+2 [email protected] wrote: > > > >> I'd like to list all transfers between two accounts. For example, to > >> estimate monthly credit card payments. > >> > >> I've tried, > >> > >> bean-query bc.bean "SELECT date, payee, narration WHERE account ~ > >> 'Assets:foo:bar' AND account ~ 'Liabilities:foo:baz'" > >> > >> But it returns nothing (because account is one thing, and cannot be > >> an AND of two things). Can someone help me with this query? I tried > >> ChatGPT and it was not helpful. > >> > >> Thanks, > >> > >> -k. > >> > > > > -- You received this message because you are subscribed to a topic in > > the Google Groups "Beancount" group. To unsubscribe from this topic, > > visit > > https://groups.google.com/d/topic/beancount/RCp-S1qlKdM/unsubscribe. > > To unsubscribe from this group and all its topics, send an email to > > [email protected]. To view this discussion visit > > > https://groups.google.com/d/msgid/beancount/609ffcb9-e9bc-4074-b0e9-8aadc7ddf3a3n%40googlegroups.com > . > -- 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 visit https://groups.google.com/d/msgid/beancount/8970ae48-e23d-4414-bf5e-916d1e9ef281n%40googlegroups.com.
