First, thank you for the program: i am really fascinated with the approach
and flexibility. I am doing accounts for various companies for the audit
purpose and found that it is relatively easy to export data from an
accounting system in the ledger's format for the purpose of transformation
of financial data in order to obey to accounting standards. The only
significant obstacle to use the program is it's default behavior to
evaluate all commodities, which in my case are currencies, at the reporting
date. This makes otherwise brilliant tool very limited in application.
I applied solutions, suggested here and in manual, namely:
- fixing the valuation of single transaction inline with @@ (or @, for
rate) in comments
- applying metadata Value:: to the selected accounts
with very little success. The second approach gave me
something incomprehensible: I tried my best to understand how the program
came to valuation of USD 576 for the second transaction with no success.
> lg -f test.tr reg c: -X EUR
12-Dec-01 Topdom c:f:b EUR12.00
EUR12.00
12-Dec-02 Topdom c:f:b USD576.00
EUR12.00
USD576.00
12-Dec-16 cost paid c:f:b EUR15.00
EUR27.00
USD576.00
12-Dec-31 MMC c:f:b USD13.47
EUR27.00
USD589.47
13-Jan-05 MMC c:f:b USD2500.00
EUR27.00
USD3089.47
the first approach does work, but, the program always revaluates the total
for the account, which is anything but right way to reflect the costs. This
method also ugly, on my opinion, since the valuation of commodity is fixed
for every transaction with big deal of flexibility is being lost.
My questions are these:
1. Is there a way to halt re-valuation of the commodity for all or
selection of accounts?
2. Is there a way to stipulate exch/rate (or cost, in 'ledger' vocabulary)
for a given transaction via 'price' records ('P YYYY/MM/DD CURR RATE') in
any predictable manner?
If I am lucky, I will seek the way to prepare standard report (like reg)
with running total in 2 currencies: base currency, stipulated by -X EUR,
and selected transaction's currency.
Thank you
Regards,
Dmitri
==========================
= /^c:/
; Value:: market(amount, post.date, exchange)
2012/12/01 (14) Topdom
; initial capital
b:hb:eur EUR500;
c:f:b EUR12
l:sh:a EUR-512
2012/12/02 (15) Topdom
; initial capital / USD
b:hb:usd USD1000
c:f:b USD24;
l:sh:a USD-1024
2012/12/15 (11) fixed assets
a:fa:car EUR100.00
l:sh:a EUR-100.00
2012/12/16 (13) cost paid
; check book ordered
c:f:b EUR15
l:sh:a EUR-15
2012/12/31 (12) MMC
b:hb:usd USD12.33
c:f:b USD3.67;
l:sh:a USD-16.00
2013/01/05 (16) MMC
; payment on s/h account
l:sh:a USD500
c:f:b USD50;
b:hb:usd USD-550
P 2012/11/01 USD EUR0.89
P 2012/12/01 USD EUR0.90
P 2012/12/31 USD EUR0.95
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
