Issue: Amount in the report does not match the amount in the recon template used as base

Hi

In our ‘Resultatenrekening’, we refer to the reconciliation template ‘Analyse personeelskosten’.

We noticed that de amounts in the template do not correspond with the amounts in the report.

Report

The code in the report is:
Report%20code

Reconciliation template:

Code template:

2.3) Opdeling directe kosten vs indirecte kosten

{% stripnewlines %}
| Benaming
| Waarde
{% newline %}
| ----25%-----
| ----20%----:+
{% ic %}#{% endic %}
{% nic %}+{% endnic %}
{% newline %}
| Directe kosten
{% newline %}
| Totaal arbeiders
| {{ TOTARB | currency }}
{% newline %}
| Opgegeven % directe kost
| {{ period.reconciliations.PERFORMANCE.results.percarbeider | percentage }}
{% newline %}
| Directe loonkost arbeiders
{% assign DIRARBEI = TOTARBperiod.reconciliations.PERFORMANCE.results.percarbeider %}
| {{ DIRARBEI | currency }}
{% newline %}
|
{% newline %}
| Totaal bediende
| {{ TOTBED | currency }}
{% newline %}
| Opgegeven % directe kost
| {{ period.reconciliations.PERFORMANCE.results.percbediende | percentage }}
{% newline %}
| Directe loonkost bedienden
{% assign DIRBED = TOTBED
period.reconciliations.PERFORMANCE.results.percbediende %}
| {{ DIRBED | currency }}
{% newline %}
|
{% newline %}
| Directe loonkost werknemers
{% assign DIRWN = DIRBED+DIRARBEI %}
| {{ DIRWN | currency }}
{% result ‘dirwn’ DIRWN %}

{% newline %}
|
{% newline %}
| Indirecte kosten
{% newline %}
| Indirecte loonkost arbeiders
{% assign INDIRARBEI = TOTARB*(1-period.reconciliations.PERFORMANCE.results.percarbeider) %}
| {{ INDIRARBEI | currency }}
{% newline %}
| Indirecte loonkost bedienden
{% assign INDIRBED = TOTBED*(1-period.reconciliations.PERFORMANCE.results.percbediende) %}
| {{ INDIRBED | currency }}

{% newline %}
|
{% newline %}
| Indirecte loonkost werknemers
{% assign INDIRWN = INDIRBED+INDIRARBEI %}
| {{ INDIRWN | currency }}
{% result ‘indirwn’ INDIRWN %}
{% endstripnewlines %}


**_Loonkost interim_**

{% stripnewlines %}
| Benaming
| Waarde
{% newline %}
| ----25%-----
| ----20%----:+
{% ic %}#{% endic %}
{% nic %}+{% endnic %}
{% newline %}
| Kosten interimkrachten
{% assign interim = period.reconciliations.MAPPINGBDRTEMPLATE.results.INTERIMMRESULT %}
| {{ interim | currency }}
{% newline %}
| Opgegeven % directe kost
| {{ period.reconciliations.PERFORMANCE.results.percinter | percentage }}
{% newline %}
| Directe loonkost interim
{% assign DIRINTER = interimperiod.reconciliations.PERFORMANCE.results.percinter %}
| {{ DIRINTER | currency }}
{% result ‘dirinter’ DIRINTER %}
{% newline %}
| Indirecte loonkost interim
{% assign INDIRINTER = interim
(1-period.reconciliations.PERFORMANCE.results.percinter) %}
| {{ INDIRINTER | currency }}
{% result ‘indirinter’ INDIRINTER %}
{% endstripnewlines %}

Hi @sylvia.debaeremaeker

this code looks fine to me. Can you check if this is not a caching issue? So, re-new the report and reconciliation?

Kind regards
Sofie

Hi Sofie

This indeed seems te work. I copy - pasted the code and now it looks OK.