# Result tag Vaste Activa : full net book value

**URL:** <https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088>\
**Category:** Templates\
**Created:** [May 4, 2021, 2:43pm UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088 "2021-05-04T14:43:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexandra](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Alexandra](https://community.silverfin.com/u/Alexandra)\
**Post date:** [May 4, 2021, 2:43pm UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088/1 "2021-05-04T14:43:22Z")

</div>

Hi,

I would like to link a own reconciliation to the “Vaste Activa” reconciliation from Silverfin.

I would like to get the total net book value of all (in)tangible assets (# 20/21/22/23/24/25/26/27).

I used the following tag : period.reconciliations.vaste\_activa.results.mva\_netto\_bw

But this result tag is limited to #22-27.  
How to add #20/21 ?  
Which result tag I should use ?

Thanks

---

<div class="post-metadata">

**Author:** ![Jelena\_Sutova](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/jelena_sutova/32/599_2.png) [@Jelena\_Sutova](https://community.silverfin.com/u/Jelena_Sutova)\
**Post date:** [May 5, 2021, 1:00pm UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088/2 "2021-05-05T13:00:39Z")

</div>

@Alexandra

Thank you for your question.

In order to proper get back to you, please, can you clarify which of the following do you require:

a) To link results from a custom template into “Vaste Activa” template.  
Here is an explanation how to do it: [CASE Annual Accounts (BE): link custom templates to Silverfin module of the Annual Accounts](https://community.silverfin.com/t/case-annual-accounts-be-link-custom-templates-to-silverfin-module-of-the-annual-accounts/1288)

b) or to use results from “Vaste Activa” template?

Thanks,  
Jelena

---

<div class="post-metadata">

**Author:** ![Peter](https://avatars.discourse-cdn.com/v4/letter/p/278dde/32.png) [@Peter](https://community.silverfin.com/u/Peter)\
**Post date:** [May 6, 2021, 3:12pm UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088/3 "2021-05-06T15:12:31Z")

</div>

> [@Alexandra](#):
>
> conciliation to the “Vaste Activa” reconciliation from Sil

Why not use directly the value of the accounts and use f.e.:  
`{% assign netvalue = #20__27 %}`  
The variable netvalue will give you the amount you need  
`netvalue = {{ netvalue | currency }}`

---

<div class="post-metadata">

**Author:** ![Alexandra](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Alexandra](https://community.silverfin.com/u/Alexandra)\
**Post date:** [May 8, 2021, 10:45am UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088/4 "2021-05-08T10:45:21Z")

</div>

Hi,

Indeed, I prepared a reconciliation which details depreciation for each assets, items by items.  
As we had to select first accounts to display, I would like to be sure that we did not forget to select an account and that my depreciation table corresponds to the vaste activa table. It is why, I put a check at the end of the document to compare the net book value of items from my “depreciation table” to the net book value of the “vaste activa” model.

I used the following tag : period.reconciliations.vaste\_activa.results.mva\_netto\_bw

But this result tag is limited to #22-27.  
How to add #20/21 ?

Here is my code :

  

* * *

→ **TABLEAU DES AMORTISSEMENTS {{ period.year\_end\_date|date:’%d/%m/%Y’ }}** ←

* * *

{%if custom.invest.range == blank%}{%assign account\_range = ‘20\_\_27’%}{%else%}{%assign account\_range = custom.invest.range%}{%endif%}

{%ic%}Sélectionner les comptes qui doivent apparaître : {%endic%}{%input custom.invest.range as:account\_collection range:2 default:account\_range%}

{% assign accounts = period.accounts.starred|range:account\_range%}

{%for current\_account in accounts%}

{%assign $22 = 0%}{%assign $23 = 0%}{%assign $24 = 0%}{%assign $25 = 0%}{%assign $26 = 0%}{%assign $27 = 0%}

|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|  
|||  
|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|  
| **COMPTE** | **{{ current\_account.number }}** | **{{ current\_account.name|upcase }}** ||  
|:------20%------------------------:|:----10%----------------|:—30%----------------:|–40%–+|  
||||

{%capture style\_titre\_amort%}|:—20%—:|:—10%—:|:—6%—:|:—4%—:|:—10%—:|:—10%—:|:—10%—:|:—10%—:|:—10%—:|:—15%—:+{%endcapture%}

{%capture style\_corps\_amort%}|:—20%----|:—10%—:|:—6%—:|:—4%----:|----10%—:|—10%—:|—10%----:|----10%—:|----10%—:|—15%----:+{%endcapture%}

{% stripnewlines%}  
|Description  
|Date Acq.  
|Méthode  
|Durée  
|Valeur  
Acq.  
|Amort.  
antérieurs  
|Solde   
à amortir  
|Amort.  
ex.  
|Amort.  
total  
|Valeur  
nette  
{%newline%}{{ style\_titre\_amort }}{% for detail in current\_account.custom.details %}  
{% capture investment\_key %}investment\_{{ current\_account.mapped\_number }}\_{{ detail.key }}{% endcapture %}  
{% capture investment\_key\_depreciations\_cy %}{{ investment\_key }}\_depreciations\_current\_year{% endcapture %}  
{% assign depreciation\_current\_year = current\_account.results.[investment\_key\_depreciations\_cy] %}  
{%newline%}  
{%newline%}{{ style\_corps\_amort }}  
{%newline%}  
|{{ detail.custom.title}}  
|{{ detail.date |date:’%d/%m/%Y’}}  
|{{ detail.custom.l\_d }}  
|{{ detail.custom.jr }}  
|{%=$22+ detail.custom.value|currency %} {%$32+ detail.custom.value %}  
|{%=$23+ detail.custom.vorige\_afschr|currency %} {%$33+ detail.custom.vorige\_afschr %}  
|{{ detail.custom.value-detail.custom.vorige\_afschr|currency }}{%$24+ detail.custom.value-detail.custom.vorige\_afschr %}{%$34+ detail.custom.value-detail.custom.vorige\_afschr %}  
|{%=$25+ depreciation\_current\_year %} {%$35+ depreciation\_current\_year %}  
|{{ detail.custom.vorige\_afschr+depreciation\_current\_year|currency }}{%$26+ detail.custom.vorige\_afschr+depreciation\_current\_year %}{%$36+ detail.custom.vorige\_afschr+depreciation\_current\_year %}  
|{{ detail.custom.value-detail.custom.vorige\_afschr-depreciation\_current\_year|currency }}{%$27+ detail.custom.value-detail.custom.vorige\_afschr-depreciation\_current\_year %}{%$37+ detail.custom.value-detail.custom.vorige\_afschr-depreciation\_current\_year %}{%endfor%}  
{%newline%}{{ style\_corps\_amort }}  
{%newline%}  
| **Total compte**  
|  
|  
|  
| **{{ $22|currency }}**  
| **{{ $23|currency }}**  
| **{{ $24|currency }}**  
| **{{ $25|currency }}**  
| **{{ $26|currency }}**  
| **{{ $27|currency }}**  
{%newline%}{{ style\_corps\_amort }}  
{%newline%}|||||{% endstripnewlines%}

{%endfor%}

  

{{ style\_corps\_amort }}  
|||  
{{ style\_corps\_amort }}  
{%stripnewlines%}| **TOTAL EXERCICE**  
|  
|  
|  
| **{{ $32|currency }}**  
| **{{ $33|currency }}**  
| **{{ $34|currency }}**  
| **{{ $35|currency }}**  
| **{{ $36|currency }}**  
| **{{ $37|currency }}** {%assign report\_valeur\_nette = period.reconciliations.vaste\_activa.results.mva\_netto\_bw %}{%assign check\_total\_valeurnette = $37-report\_valeur\_nette%}{% if ABS(check\_total\_valeurnette) \<= 0.01 %}{%unreconciled 0 as:indicator%}{%else%}{% unreconciled check\_total\_valeurnette as:indicator %}{% endif %}  
{%newline%}  
{{ style\_corps\_cession }}  
{%newline%}  
|||||  
{%endstripnewlines%}

---

<div class="post-metadata">

**Author:** ![Alexandra](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Alexandra](https://community.silverfin.com/u/Alexandra)\
**Post date:** [May 8, 2021, 10:49am UTC](https://community.silverfin.com/t/result-tag-vaste-activa-full-net-book-value/2088/5 "2021-05-08T10:49:24Z")

</div>

Thank you for your answer.

First, I wanted to link my reconciliation to the vaste activa reconciliation in order to be sure that both reconciliations correspond.

With your solution I will be sure that all (in)tangible assets are full disclosed… It could be a good alternative…