Loan : how to use the "future value" in a scheduled transaction ?

[Derrick Hudson]

Okay, if instanceCount is correct then you probably found a different issue. 

In my case I wanted to start at payment #1 with my new mortgage parameters but since I edited my existing SX it started with payment twenty- or thirty- something.

-Derrick


Yann Le Mouel <yann.lemouel at free.fr> wrote:

Hi Derrick

Well, no the instanceCount is equal to 14 for this gnc:schedxaction.

However, if I go to the corresponding gnc:transaction, here is an extract of
it :
<gnc:transaction version="2.0.0"> 
...
<split:slots>
<slot>
<slot:key>sched-xaction</slot:key>
<slot:value type="frame">
<slot>
<slot:key>account</slot:key>
<slot:value
type="guid">12d0da01a75eb03d77038191f07810fc</slot:value>
</slot>
<slot>
<slot:key>credit-formula</slot:key>
<slot:value type="string"></slot:value>
</slot>
<slot>
<slot:key>credit-numeric</slot:key>
<slot:value type="numeric">0/1</slot:value>
</slot>
<slot>
<slot:key>debit-formula</slot:key>
<slot:value type="string">ppmt( 0,03450 / 12,00 : i : 240,00 :
130000,00 : -46666,01 : 0 )</slot:value>
</slot>
<slot>
<slot:key>debit-numeric</slot:key>
<slot:value type="numeric">240887/1000</slot:value>
</slot>
</slot:value>
</slot>
</split:slots>
...
</gnc:transaction>

which is really different from another with no future value :

<gnc:transaction version="2.0.0"> 
...
<split:slots>
<slot>
<slot:key>sched-xaction</slot:key>
<slot:value type="frame">
<slot>
<slot:key>account</slot:key>
<slot:value
type="guid">559fb8a9032fc66002745c8d2edc37c9</slot:value>
</slot>
<slot>
<slot:key>debit-formula</slot:key>
<slot:value type="string">ppmt( 0,03350 / 12,00 : i : 240,00 :
70000,00 : 0 : 0 )</slot:value>
</slot>
</slot:value>
</slot>
</split:slots>
...
</gnc:transaction>

It looks like as if the "i" is not seen as a variable to be replaced by the
instanceCount when the future value is not equal to zero.

Yann

> -----Original Message-----
> From: Derrick Hudson [mailto:dman at dman13.dyndns.org]
> Sent: lundi 30 janvier 2012 23:56
> To: Yann Le Mouel; gnucash-user at gnucash.org
> Subject: RE: Loan : how to use the "future value" in a scheduled
> transaction ?
> 
> Yann,
> 
> The issue, then, is (probably) the instance count of your scheduled
> transaction. The instance count is not accessible in the GUI, as fa as I
> know. In the XML file, locate the <gnc:schedxaction> element for the
> scheduled transaction in question. Note the <sx:instanceCount> element in
> it. I recently experienced the effect when I edited my mortgage scheduled
> transaction to reflect the parameters after refinancing and needed to
> reset the instance count. Note that manually editing the file is, of
> course, not supported.
> 



_____________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.