Just write a script already. I provide a Python library with an open data type for a reason. Or ask the AI - our new overlords - to do it for you.
On Thu, Jul 3, 2025, 14:49 Ken Mankoff <mank...@gmail.com> 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 > <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. > -- 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/CAK21%2BhPxQ-VztufLdbgC35reyptY3Wcu4yQ5R-Dr%3DKim2PrNeg%40mail.gmail.com.