On Sun, May 22, 2016 at 3:56 PM, francois PEGORY <[email protected]> wrote:
> yes but in fact, it is not the thing. > to have for a account a balance at a date, it is easy to have it with bql : > select date, flag, payee, account, position, balance from close on > 2016-01-01 where account = "Assets:Banque:bank" > if i want to have balance for this account at this date but i can't query > the balance directive in BQL. > in the perfect world, someting like that: > select date, flag, payee, account, position, balance from close on > Max(date_of_balance_directive) where account = "Assets:Banque:bank" > like this, no need to have a plugin. > If you did that (that is, simply compute the balances on a fixed closing date) it may include some postings from accounts other than the one with the latest balance directive. I'm not sure that this is what you want. In any case, you can always write a script to produce anything you need. Cheers, regards > > 2016-05-22 21:32 GMT+02:00 francois PEGORY <[email protected]>: > >> 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/CAK21%2BhNfD1-44JvV-bmS__c8rUFSUrR-1F%2B944T2QJWksuT%3DwA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
