Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Multiple currencies issue #12

Open
emorozov opened this issue Jul 9, 2014 · 1 comment
Open

Multiple currencies issue #12

emorozov opened this issue Jul 9, 2014 · 1 comment

Comments

@emorozov
Copy link

emorozov commented Jul 9, 2014

I liked ledger-web very much, but I'm using 3-4 currencies simultaneously, and therefore ledger-web is useless in my case.

Reports show some numbers but without currencies attached, and they get it obviously wrong (for example, income is in currency CUR1 and expenses are in currency CUR2). When I'm using ledger command, I use -X option to see everything converted to a single currency.

Also, I use Russian names for accounts (like 'Активы' instead of 'Assets') and have to manually tweak reports to replace account names. It would be nice if it would be possible to specify mapping in the config file.

@alexjj
Copy link

alexjj commented Jan 10, 2016

There's a commodity entity in the database (according to the Readme), although I can't get it to do anything: trying to get a simple monthly report to show it:

<% @query = query do %>
select
    xtn_month as "Month",
    account as "Account",
    sum(amount) as "Total",
    commodity as "Currency"
from
    ledger
where
    (account ~ 'Income'
    or account ~ 'Expenses')
    and xtn_date between :from and :to
group by
    xtn_month,
    account
order by
    xtn_month,
    account
<% end %>
<div class="page-title">
  <h1>Monthly</h1>
</div>
<%= table @query %>```

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants