I've implemented the last idea just for fun--it works: https://bitbucket.org/blais/beancount/commits/2d1940b82d386734df444973a517c6355e010227?at=default
https://bitbucket.org/blais/beancount/src/2d1940b82d386734df444973a517c6355e010227/CHANGES?at=default&fileviewer=file-view-default#CHANGES-7 On Sun, May 22, 2016 at 2:21 PM, Martin Blais <[email protected]> wrote: > There's no possible date common over all accounts which makes this > possible. > For example, two different accounts may have different dates for their > last balance directives. > > In order to carry this out using bean-query, you'd have to somehow tell it > to stop accumulating the positions after the last balance, conditional on > this per-account value. Not sure how to do that, there's no conditional on > aggregation functions in bean-query. > > However, an easy way to do this would be to write a plugin that discards > all transactions after the last Balance directive in each account. Note > that this is not well-defined because a single transaction posts to > multiple accounts... if one of the postings is before that account's last > Balance directive and the other isn't, should one ignore the transaction or > not? I don't know. You might have your own opinion on that. > > If you don't care to maintain the accounting equation, you could write a > custom report that sums up the positions in each account, disregarding the > transactions themselves. But then running a balance sheet or trial balance > on those won't sum up to zero. > > Or ... yet another idea: you could write a plugin that inserts metadata on > postings which occur after the last Balance directive (e.g. "unverified: > TRUE") and use bean-query's WHERE clause to filter those out. That would > work. In fact, you could always leave that plugin on... if you don't use > the field, it wouldn't hurt anything else. That's the best implementation > IMO. > > Choose your evil. > > > > On Sun, May 22, 2016 at 12:25 PM, francois PEGORY <[email protected]> > wrote: > >> exactly i want the date from the last Balance directive. >> regards >> >> 2016-05-18 16:32 GMT+02:00 Martin Blais <[email protected]>: >> >>> Do you want "data from the last Balance directive" or "the balances as >>> of the date of the last Balance directive in each account"? >>> Please be specific. >>> >>> >>> On Wed, May 18, 2016 at 5:46 AM, francois PEGORY <[email protected] >>> > wrote: >>> >>>> Thanks but i wanted to have the latest Balance directive not the >>>> effective Balance. >>>> >>>> Regards >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> *De : *Martin Blais <[email protected]> >>>> *Envoyé le :*mardi 17 mai 2016 06:42 >>>> *À : *Beancount <[email protected]> >>>> *Objet :*Re: balance >>>> >>>> >>>> >>>> bean-report <filename> balances >>>> >>>> bean-query <filename> "select account, sum(position) group by account" >>>> >>>> >>>> >>>> >>>> >>>> On Mon, May 16, 2016 at 12:26 PM, francois PEGORY < >>>> [email protected]> wrote: >>>> >>>> hello, >>>> >>>> i look for having the latest balance fro each account in my file: >>>> >>>> do you know how to have it ? >>>> >>>> >>>> >>>> regards >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> 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 post to this group, send email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/beancount/CALUWbLeHGUJE6XY74MB3dH-Q7wzfcqyWzw3SLySJ5y7r_5LEUA%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/beancount/CALUWbLeHGUJE6XY74MB3dH-Q7wzfcqyWzw3SLySJ5y7r_5LEUA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> >>>> >>>> -- >>>> 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 post to this group, send email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/beancount/CAK21%2BhO7DehN1bQbPdtGzp0P269Z7MC8-9ZoSoZW2NzvqTHuGw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/beancount/CAK21%2BhO7DehN1bQbPdtGzp0P269Z7MC8-9ZoSoZW2NzvqTHuGw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> >>>> >>> >>> >> > -- 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 post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNbpihobd%2BqajsYHzTaygjOBYXpHBKFDM4607g2CTd%2BYw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
