Transactions not appearing correctly

Sat Nov 28 13:00:32 EST 2009

I have made a bit more progress...

I have attached a file with the XML for the transaction which is not working
and the transaction which is (in my previous email I failed to include the
XML of the entire transaction entry).  It appears that the main difference
between two, other than the fact that the "quantity" is being shown as zero,
the "currency" is also different in each example. In the example that fails,
the currency is XAU but in the example that works the currency is USD.

What is meant by the "currency" field in a transaction like this?  Is it
possible to change the "currency" in a transaction from the register?  Would
you consider it a bug when I can successfully enter a transaction in the
register for the "stock" but it does not show up in the register for the
"cash" part of the brokerage account?  Should this issue be easier to see
and resolve from the register?

Many thanks,
Ken

2009/11/28 Ken <kmailuk at googlemail.com>

> Some more detail:
> At the end of this email I have pasted the raw XML from the file for the
> transaction which is a problem (Example 1).  It appears, for some strange
> reason that the "quantity" is 0 in the line of the split.  In a test
> transaction (Example 2), the quantity is displayed correctly.
> I can not figure out how to fix this as there is not way to edit the
> quantity field from the transaction register.
>
>
> EXAMPLE 1
> <trn:description>Buy 50 FXY at USD 94.10</trn:description>
>  <trn:splits>
>    <trn:split>
>      <split:id type="guid">57c6efd5ba6e01ea03ff6324521b43c2</split:id>
>      <split:action>Buy</split:action>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>4705000000/1000000</split:value>
>      <split:quantity>50/1</split:quantity>
>      <split:account
> type="guid">211256a1c7fdf9ca2fcf238c7e9d2bee</split:account>
>    </trn:split>
>    <trn:split>
>      <split:id type="guid">3fd0a6171b7a1df3ff870c9a202f2c37</split:id>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>1000000/1000000</split:value>
>      *<split:quantity>0/100</split:quantity>*
>      <split:account
> type="guid">033b2bf15b0cf3a8b544718cd64bf76b</split:account>
>    </trn:split>
>    <trn:split>
>      <split:id type="guid">2999340a9cc926839245daf36bacfc57</split:id>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>-4706000000/1000000</split:value>
>      *<split:quantity>0/100</split:quantity>*
>      <split:account
> type="guid">8b867a55d99bfb70c38319b00235f43e</split:account>
>    </trn:split>
>  </trn:splits>
> </gnc:transaction>
>
>
> EXAMPLE 2
> <trn:description>Buy 50 FXY at USD 94.10 Fixed</trn:description>
>  <trn:splits>
>    <trn:split>
>      <split:id type="guid">3cd7e512b355667e5223d9e7af502a33</split:id>
>      <split:action>Buy</split:action>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>470500/100</split:value>
>      <split:quantity>50/1</split:quantity>
>      <split:account
> type="guid">211256a1c7fdf9ca2fcf238c7e9d2bee</split:account>
>    </trn:split>
>    <trn:split>
>      <split:id type="guid">b32dc3758f2559e127de5dd3ac8aa728</split:id>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>-470400/100</split:value>
>      *<split:quantity>-470400/100</split:quantity>*
>      <split:account
> type="guid">8b867a55d99bfb70c38319b00235f43e</split:account>
>    </trn:split>
>    <trn:split>
>      <split:id type="guid">6a6ac01e3fc446bde33aa9f26f504cd2</split:id>
>      <split:reconciled-state>n</split:reconciled-state>
>      <split:value>-100/100</split:value>
>      *<split:quantity>-100/100</split:quantity>*
>      <split:account
> type="guid">033b2bf15b0cf3a8b544718cd64bf76b</split:account>
>    </trn:split>
>  </trn:splits>
> </gnc:transaction>
>
>
>
>
>
> 2009/11/28 Ken <kmailuk at googlemail.com>:
>
> > Hi. I am having a strange problem with some transactions.  I have
> > attached an image of an example.
> >
> > In the top part of the picture you will see I entered a transaction to
> > Buy 50 shares of FXY which costs 4,706 from my brokerage account.
> >
> > The bottom part of the picture shows the line in the brokerage account
> > but you will see that all the transaction value fields are blank.
> >
> > I have created some test transactions but they appear to work
> > correctly.  I can not understand why GnuCash is showing the values of
> > the transactions correctly in the register of the stock but not
> > correctly in the register for the brokerage account for this
> > transaction (but does work for some test transactions).
> >
> > Has anyone experienced this issue and know a solution?
> >
> > Thanks,
> > Ken
> >
>
>
-------------- next part --------------
<gnc:transaction version="2.0.0">
  <trn:id type="guid">5d532572dcaa7b757743b21d5cd3d859</trn:id>
  <trn:currency>
    <cmdty:space>ISO4217</cmdty:space>
    <cmdty:id>XAU</cmdty:id>
  </trn:currency>
  <trn:date-posted>
    <ts:date>2008-07-02 00:00:00 +0100</ts:date>
  </trn:date-posted>
  <trn:date-entered>
    <ts:date>2009-11-28 11:00:02 +0000</ts:date>
  </trn:date-entered>
  <trn:description>Buy 50 FXY at USD 94.10</trn:description>
  <trn:splits>
    <trn:split>
      <split:id type="guid">57c6efd5ba6e01ea03ff6324521b43c2</split:id>
      <split:action>Buy</split:action>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>4705000000/1000000</split:value>
      <split:quantity>50/1</split:quantity>
      <split:account type="guid">211256a1c7fdf9ca2fcf238c7e9d2bee</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">3fd0a6171b7a1df3ff870c9a202f2c37</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>1000000/1000000</split:value>
      <split:quantity>0/100</split:quantity>
      <split:account type="guid">033b2bf15b0cf3a8b544718cd64bf76b</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">2999340a9cc926839245daf36bacfc57</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>-4706000000/1000000</split:value>
      <split:quantity>0/100</split:quantity>
      <split:account type="guid">8b867a55d99bfb70c38319b00235f43e</split:account>
    </trn:split>
  </trn:splits>
</gnc:transaction>

<gnc:transaction version="2.0.0">
  <trn:id type="guid">8b254ec080fe456bf93242c556df3e37</trn:id>
  <trn:currency>
    <cmdty:space>ISO4217</cmdty:space>
    <cmdty:id>USD</cmdty:id>
  </trn:currency>
  <trn:date-posted>
    <ts:date>2008-07-02 00:00:00 +0100</ts:date>
  </trn:date-posted>
  <trn:date-entered>
    <ts:date>2009-11-28 17:41:09 +0000</ts:date>
  </trn:date-entered>
  <trn:description>Buy 50 FXY at USD 94.10 Fixed</trn:description>
  <trn:splits>
    <trn:split>
      <split:id type="guid">3cd7e512b355667e5223d9e7af502a33</split:id>
      <split:action>Buy</split:action>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>470500/100</split:value>
      <split:quantity>50/1</split:quantity>
      <split:account type="guid">211256a1c7fdf9ca2fcf238c7e9d2bee</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">b32dc3758f2559e127de5dd3ac8aa728</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>-470400/100</split:value>
      <split:quantity>-470400/100</split:quantity>
      <split:account type="guid">8b867a55d99bfb70c38319b00235f43e</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">6a6ac01e3fc446bde33aa9f26f504cd2</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>-100/100</split:value>
      <split:quantity>-100/100</split:quantity>
      <split:account type="guid">033b2bf15b0cf3a8b544718cd64bf76b</split:account>
    </trn:split>
  </trn:splits>
</gnc:transaction>