Show capital repayments of previous years in evolution table

[Maarten]

Is it possible to automatically display the capital repayments of previous years in the evolution table?
In my report i’m trying with the formula reconciliations.kredieten.results.done_prepayments.value
but this is not working.

[Maarten]

In the preview of the amortisation table the repayments are displayed

and if i edit the reconciliation i think the “totaal_kapitaal_vv” is displaying the data
code here below

| | | {{ dent2 }}{{font_header}}{{ ‘Vervroegde Terugbetalingen’ | upcase }}{{end_font}} | | {% if emz %} | {%endif%}
{% for i in (ditjaar_index…ditjaar_index+number_of_years-1) %}
{% assign j = jaren_chron[i] | remove:‘.’ %}
{% assign totaal_kapitaal_vv = ‘totaalkapitaal’ | append:j | append:‘vv’ %}
{% assign totaal_intrest_vv = ‘totaalintrest’ | append:j | append:‘vv’ %}
{{font}}{{ [totaal_kapitaal_vv] | currency }}{{end_font}} |
{{font}}{{ [totaal_intrest_vv] | currency }}{{end_font}} |
{% if forloop.first %} | {%endif%}
{%endfor%}
{% endif %}

[Kimberly_Vlietinck]

Hi @Maarten,

First of all welcome to the Silverfin Developer Community!

Is my understanding correct that you are trying to present a result coming from a reconciliation template in your report?

As explained here, you can indeed display results from a reconciliation template in a report:

CASE: display results from reconciliation in a report

As explained here, you can take amounts into a result tag to display somewhere else: Let’s say we have a template with a handle “stocks” and there’s a value taken into a result tag called “stock_value”. How can we display this result tag in a report template? This is the way: Add a formula box to the report [07] As formula you’ll link to the result tag [31] So that’s reconciliations.stocks.results.stock_value without the period in the formula!

So in order to use this, you need to make sure that you have created a result in your template and use the correct result name to fetch the value in the report.

In the code snippet you shared I don’t yet see a result that is created for the value of the “totaal_kapitaal_vv”.
Here you can find some more information on how you create a result:

CASE reference values across templates by using result tags

If you want to reference a certain value or variable from recon template A in another template, there’s a way to do it with the so-called result tags in STL. They work like this ( just type in result and press TAB to get this preformatted code ): {% result 'name' content %} where the name is a shortname you can choose, and the content is the value or variable you want to reference to. Let’s say we have this variable done_prepayments in our recon template Prepayments (which is al…

Let me know if this works out for you or if you have any additional questions.

Kind regards,
Kimberly

result result-tags Reports