thanks it will be usefull 2016-05-22 21:20 GMT+02:00 Martin Blais <[email protected]>:
> 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/CALUWbLc6uhHzjzy%3Dh_oET9hkd08aWkp6dm6Yt46rzbg47LX5cg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
