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 <beancount@googlegroups.com> 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 man...@gmail.com 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 > beancount+unsubscr...@googlegroups.com. 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 beancount+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/beancount/874ivtp0tc.fsf%40gmail.com.
