Issue #351: Allow a balance column by referencing another column, sum up position converted at original rate (blais/beancount)

5 views
Skip to first unread message

Martin Michlmayr

unread,
Dec 19, 2018, 6:22:13 AM12/19/18
to bean...@googlegroups.com
New issue 351: Allow a balance column by referencing another column, sum up position converted at original rate
https://bitbucket.org/blais/beancount/issues/351/allow-a-balance-column-by-referencing

Martin Michlmayr:

I [posted this to the beancount list](https://groups.google.com/forum/#!topic/beancount/SGDBejEtd0I) and Martin said this isn't supported at the moment. Opening a ticket.

I have expenses in one currency (EUR) and want to convert all of them to another (USD) **on the day** of the transaction.

This gives the correct result because I pass "date" to CONVERT():

```
beancount> SELECT sum(convert(position, "USD", date)) WHERE account ~ '^Assets:A';
sum_conver
----------
107.50 USD
```

But I'd like to see a "register" type view with each individual transaction and the total.


Test case:

```
plugin "beancount.plugins.implicit_prices"

2000-01-01 open Assets:A
2000-01-01 open Assets:B

2018-12-05 * "Test 1"
Assets:A 20 EUR @ 1.10 USD
Assets:B

2018-12-06 * "Test 2"
Assets:A 45 EUR {1.14 USD} @ 1.14 USD
Assets:B

2018-12-07 * "Test 3"
Assets:A 30 EUR {1.14 USD}
Assets:B
```


Reply all
Reply to author
Forward
0 new messages