Visualisation applicable annual accounts templates

Hi!

Our goal is to visualize all the annual accounts templates currently in use. While we could iterate through all the handles of the annual accounts to verify their existence and starred status, this approach has limitations. Some templates may still be starred and exist in the background, even though they are not applicable or visible through conventional methods.


Could you provide us with the logic to retrieve all potentially applicable templates? Specifically, we are interested in those templates that are displayed in the dashboard on top of the applicable templates.

Thank you

Kind regards
Jelle

Hi @JelleBe

I’ve send your question through to the team that maintains these templates, they’ll provide you with an answer here soon.

Kind regards
Romy

Thank you Romy!

Hi @JelleBe

Based on information that is selected in the identification details, we have lists (arrays) that we use for the micro, abridged or full model of the Annual Accounts.

We have 2 sets of templates that we display in the Annual Accounts:

Templates that have handles vol_xx are being used for the full model and templates with handles vkt_xx are used for the micro and abridged model (these are quite similar).

The dropdown of the chosen model is the following: period.reconciliations.vkt_1.custom.model.model_type

This dropdown has a value of 1, 2 or 3:
1 = micro
2 = abridged
3 = full

We use the following lists based on the chosen model.

The first list contains the handle of the template (we use this for the link) and the second list contains the number as you can see displayed in the header.

Micro

{% assign vkt_array = "vkt_1;vkt_2_1;vkt_2_2;vkt_3_1;vkt_3_2;vkt_4;vkt_5;vkt_6_1_1;vkt_6_1_2;vkt_6_1_3;vkt_6_2;vkt_6_5;vkt_6_6;vkt_6_8;vkt_6_9;vkt_7_1;vkt_7_2;vkt_9;vkt_10;vkt_11;vkt_12;vkt_remuneratieverslag;vkt_notulen_belangenconflicten;vkt_verslag_raad_v_toezicht;vkt_jaarrekeningen;vkt_andere_doc" | split:";" %}
{% assign vkt_view = "1;2.1;2.2;3.1;3.2;4;5;6.1.1;6.1.2;6.1.3;6.2;6.3;6.4;6.5;6.6;7.1;7.2;8;9;10;11;12;13;14;15;16" | split:";" %}

Abridged

{% assign vkt_array = "vkt_1;vkt_2_1;vkt_2_2;vkt_3_1;vkt_3_2;vkt_4;vkt_5;vkt_6_1_1;vkt_6_1_2;vkt_6_1_3;vkt_6_2;vkt_6_3;vkt_6_4;vkt_6_5;vkt_6_6;vkt_6_7;vkt_6_8;vkt_6_9;vkt_7_1;vkt_7_2;vkt_8;vkt_9;vkt_10;vkt_11;vkt_12;vkt_remuneratieverslag;vkt_notulen_belangenconflicten;vkt_verslag_raad_v_toezicht;vkt_jaarrekeningen;vkt_andere_doc" | split:";" %}
{% assign vkt_view = "1;2.1;2.2;3.1;3.2;4;5;6.1.1;6.1.2;6.1.3;6.2;6.3;6.4;6.5;6.6;6.7;6.8;6.9;7.1;7.2;8;9;10;11;12;13;14;15;16;17" | split:";" %}

Full

{% assign vol_templates_array = "vkt_1;vol_2_1;vol_2_2;vol_3_1;vol_3_2;vol_4;vol_5;vol_6_1;vol_6_2_1;vol_6_2_2;vol_6_2_3;vol_6_2_4;vol_6_2_5;vol_6_3_1;vol_6_3_2;vol_6_3_3;vol_6_3_4;vol_6_3_5;vol_6_3_6;vol_6_4_1;vol_6_4_2;vol_6_4_3;vol_6_5_1;vol_6_5_2;vol_6_6;vol_6_7_1;vol_6_7_2;vol_6_8;vol_6_9;vol_6_10;vol_6_11;vol_6_12;vol_6_13;vol_6_14;vol_6_15;vol_6_16;vol_6_17;vol_6_18_1;vol_6_18_2;vol_6_19;vol_6_20;vol_7;vol_8;vol_9;vol_10;vol_remuneratieverslag;vol_verslag_enige_ah;vol_verslag_raad_v_toezicht;vol_jaarrekeningen;vol_andere_doc" | split:";" %}
{% assign vol_descr_array = "1;2.1;2.2;3.1;3.2;4;5;6.1;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.3.1;6.3.2;6.3.3;6.3.4;6.3.5;6.3.6;6.4.1;6.4.2;6.4.3;6.5.1;6.5.2;6.6;6.7.1;6.7.2;6.8;6.9;6.10;6.11;6.12;6.13;6.14;6.15;6.16;6.17;6.18.1;6.18.2;6.19;6.20;7;8;9;10;11;12;13;14;15" | split:";" %}

This should help you get started.
Based on the information in these arrays further logic can be done on for example starred templates.

Kind regards
Robbe

Great Robbe!

Thank you for your help.