transactions wrongly imported in USD currency

Brendan Simon Brendan at BrendanSimon.com
Tue Mar 16 00:25:14 EDT 2010


Hi,

I have a whole lot of transactions, that were imported from QIF files
that were downloaded from my bank (in Australia).

When I try to create splits in the transaction, it is asking me for an
exchange rate or value from USD to AUD.  All transactions are in AUD so
it shouldn't be doing this.  Previous transactions do not do this.

I decompressed the .gnucash database and searched for the transaction. 
It seems that quite a few transactions have a currency of USD which is
wrong.

I'm not sure how this happened.  There doesn't seem to be anyway to
change this with the GnuCash GUI .... is there ???

Is it ok to change the database text file, then compress with gzip ??

Here is an example of an _incorrect_ transaction:

    <gnc:transaction version="2.0.0">
      <trn:id type="guid">e3be63456c3b0dd071775b8424929a08</trn:id>
      <trn:currency>
        <cmdty:space>ISO4217</cmdty:space>

        <cmdty:id>USD</cmdty:id>

      </trn:currency>
      <trn:date-posted>
        <ts:date>2005-09-28 00:00:00 +1000</ts:date>
      </trn:date-posted>
      <trn:date-entered>
        <ts:date>2006-01-04 16:10:51 +1100</ts:date>
        <ts:ns>884806000</ts:ns>
      </trn:date-entered>
      <trn:description>TRANSFER    FROM FEREN - STOCKDAL LANDLORD
    PAYMENT</trn:description>
      <trn:splits>
        <trn:split>
          <split:id type="guid">0516f06d92ba7357d60da1841a97dcc7</split:id>
          <split:reconciled-state>c</split:reconciled-state>
          <split:value>73325/100</split:value>
          <split:quantity>73325/100</split:quantity>
          <split:account
    type="guid">4580ebb9a86619fee286aaf4997263b2</split:account>
        </trn:split>




Here is an example of an _correct_ transaction:

    <gnc:transaction version="2.0.0">
      <trn:id type="guid">763aa898ae7eaeb573eb5b2f24d79a57</trn:id>
      <trn:currency>
        <cmdty:space>ISO4217</cmdty:space>

        <cmdty:id>AUD</cmdty:id>

      </trn:currency>
      <trn:date-posted>
        <ts:date>2005-08-31 00:00:00 +1000</ts:date>
      </trn:date-posted>
      <trn:date-entered>
        <ts:date>2005-09-11 14:35:10 +1000</ts:date>
        <ts:ns>25283000</ts:ns>
      </trn:date-entered>
      <trn:description>TRANSFER    FROM FEREN - STOCKDAL LANDLORD
    PAYMENT</trn:description>
      <trn:splits>
        <trn:split>
          <split:id type="guid">cd722550abe122421294c203c3c349ad</split:id>
          <split:reconciled-state>n</split:reconciled-state>
          <split:value>73325/100</split:value>
          <split:quantity>73325/100</split:quantity>
          <split:account
    type="guid">4580ebb9a86619fee286aaf4997263b2</split:account>
        </trn:split>


Thanks, Brendan.



More information about the gnucash-user mailing list