hledger icon indicating copy to clipboard operation
hledger copied to clipboard

generate commodity revaluation transactions ?

Open simonmichael opened this issue 12 years ago • 2 comments
trafficstars

Original author: [email protected] (January 18, 2012 17:20:43)

As reported by betabug, hledger doesn't auto-generate the commodity revaluation transactions described at http://ledger-cli.org/3.0/doc/ledger3.html#Commodity-Pricing-Problem , so hledger's and ledger's reports can differ eg when exchange rates are changing.

$ cat t.j
P 2011/11/18 EUR CHF 1.234

2011/11/18 Invoice
    Debitor                             EUR 1000.00
    Sales                               EUR -1000.00

P 2011/12/02 EUR CHF 1.2261

2011/12/07 Payment
    Debitor                             EUR -1000.00
    Currency:EUR                        EUR 1000.00
$ hledger -f t.j bal
         EUR 1000.00  Currency:EUR
        EUR -1000.00  Sales
--------------------
                   0

$ hledger -f t.j bal --cost
       CHF 1226.1000  Currency:EUR
          CHF 7.9000  Debitor
       CHF -1234.000  Sales
--------------------
                   0

$ ledger -f t.j bal
         EUR 1000.00  Currency:EUR
        EUR -1000.00  Sales
--------------------
                   0

$ ledger -f t.j bal --cost
         EUR 1000.00  Currency:EUR
        EUR -1000.00  Sales
--------------------
                   0

$ ledger -f t.j bal --market
             CHF1226  Currency:EUR
            CHF-1226  Sales
--------------------
                   0

Some corresponding register reports for reference:

$ hledger -f t.j reg
2011/11/18 Invoice              Debitor                 EUR 1000.00  EUR 1000.00
                                Sales                  EUR -1000.00            0
2011/12/07 Payment              Debitor                EUR -1000.00 EUR -1000.00
                                Currency:EUR            EUR 1000.00            0

$ hledger -f t.j reg --cost
2011/11/18 Invoice              Debitor                CHF 1234.000 CHF 1234.000
                                Sales                  CHF -1234.000            0
2011/12/07 Payment              Debitor                CHF -1226.1000 CHF -1226.1000
                                Currency:EUR           CHF 1226.1000            0

$ hledger -f t.j reg Debitor
2011/11/18 Invoice              Debitor                 EUR 1000.00  EUR 1000.00
2011/12/07 Payment              Debitor                EUR -1000.00            0

$ hledger -f t.j reg Debitor --cost
2011/11/18 Invoice              Debitor                CHF 1234.000 CHF 1234.000
2011/12/07 Payment              Debitor                CHF -1226.1000   CHF 7.9000

$ ledger -f t.j reg                                                                                                                                                                                                                         
11-Nov-18 Invoice                                         Debitor                                                                 EUR 1000.00                  EUR 1000.00                                                                  
                                                          Sales                                                                  EUR -1000.00                            0                                                                  
11-Dec-07 Payment                                         Debitor                                                                EUR -1000.00                 EUR -1000.00                                                                  
                                                          Currency:EUR                                                            EUR 1000.00                            0                                                                  


$ ledger -f t.j reg Debitor                                                                                                                                                                                                                 
11-Nov-18 Invoice                                         Debitor                                                                 EUR 1000.00                  EUR 1000.00                                                                  
11-Dec-07 Payment                                         Debitor                                                                EUR -1000.00                            0                                                                  

$ ledger -f t.j reg --market                                                                                                                                                                                                                
11-Nov-18 Invoice                                         Debitor                                                                     CHF1234                      CHF1234                                                                  
                                                          Sales                                                                      CHF-1234                            0                                                                  
11-Dec-07 Payment                                         Debitor                                                                    CHF-1226                     CHF-1226                                                                  
                                                          Currency:EUR                                                                CHF1226                            0                                                                  

$ ledger -f t.j reg Debitor --market                                                                                                                                                                                                        
11-Nov-18 Invoice                                         Debitor                                                                     CHF1234                      CHF1234                                                                  
11-Dec-02 Commodities revalued                            <Revalued>                                                                    CHF-8                      CHF1226                                                                  
11-Dec-07 Payment                                         Debitor                                                                    CHF-1226                            0                                                                  

Original issue: http://code.google.com/p/hledger/issues/detail?id=82

simonmichael avatar Apr 08 '13 16:04 simonmichael