Hello,
i will use an amount from my report (custom made) in my reconciliation.
It seems that it works, but i have a problem that it will not appear on my template.
{% t= "Detail van de kosten" fr:"Détails des frais" %}
{% t= "Fiscale beperking" fr:"Limite fiscale" %}
{% t= "Aftrekbaar" fr:"Déductible" %}
{% t= "Ontvangsten/Baten" fr:"Chiffre d'affaires" %}
{% t= "Beginvoorraad" fr:"Stock initial" %}
{% t= "Eindvoorraad" fr:"Stock final" %}
{% t= "Verkochte voorraad" fr:"Stock vendu" %}
{% t= "Brutowinst" fr:"Résultat brute" %}
{% t= "Sociale bijdragen" fr:"Cotisations sociales" %}
{% t= "Toekenning meewerkende echtgeno(o)t(e)" fr:"Octroi époux/-ouse cooperative" %}
{% t= "Kosten" fr:"Frais" %}
{% t= "Nettoresultaat" fr:"Résultat net" %}
{% t= "niet toegewezen bedrag" fr:"comptant non affectués" %}
{% t= "Kosten mbt bedrijfslokalen" fr:"La location et les frais de location" en:"Rent and rental expenses" %}
{% t= "Kosten mbt voertuigen" fr:"L'entretien et les réparation" en:"Maintenance and repair" %}
{% t= "Kantoorkosten" fr:"Les fournitures et les services" en:"Supplies and services" %}
{% t= "Vergoeding aan derden" fr:"Les frais de tiers" en:"Remuneration to third parties" %}
{% t= "Kantoorkosten"%}
{% t= "Administratiekosten"%}
{% t= "Kosten mbt verzekeringen"%}
{% t= "Specifieke kosten"%}
{% t= "Uitzendkrachten"%}
{% t= "Personeelskosten"%}
{% t= "Persoonlijke bijdragen"%}
{% t= "Afschrijvingen"%}
{% t= "Financiële kosten"%}
{% t= "Andere bedrijfsopbrengsten"%}
{% t= "Financiële opbrengsten"%}
{% t= "Totaal" fr:"Le Total" en:"Total" %}
{% t= "Andere bedrijfskosten" fr:"Les Divers" en:"Miscellaneous" %}
{% t= "Extra toelichting" fr:"Explication supplémentaire" en:"Additional explanation" %}
{% t= "Nr." fr:"N°" en:"No." %}
{% t= "Bedrag" fr:"Montant" en:"Amount" %}
{% if cost_categories_string == blank or cost_keys_string == blank %}
{% assign cost_categories_string = "Kosten mbt bedrijfslokalen|Kosten mbt voertuigen|Kantoorkosten|Administratiekosten|Kosten mbt verzekeringen|Vergoeding aan derden|Specifieke kosten|Uitzendkrachten|Persoonlijke bijdragen|Personeelskosten|Afschrijvingen|Andere bedrijfskosten|Financiële kosten|Andere bedrijfsopbrengsten|Financiële opbrengsten" %}
{% assign cost_keys_string = "lokalen|voertuigen|kantoor|admin|verzek|derden|specifiek|interim|leider|persoon|personeel|Afschrijving|andere|finkost|bedropbr|finopbr" %}
{% endif %}
{% assign cost_categories = cost_categories_string | split:"|" %}
{% assign cost_keys = cost_keys_string | split:"|" %}
{% capture table %}
-----------------------------------------------------------------------------------------------------------
|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+
| **{% t "Detail van de kosten" %}** |**{{ period.year_end_date | date:'%Y' }}**| **{% t "Fiscale beperking" %}** | **{% t "Aftrekbaar" %}**
-----------------------------------------------------------------------------------------------------------
{% for cost_category in cost_categories %}{% assign $11 = 0 %}{% assign $13 = 0 %}{% assign $14 = 0 %}{% assign category_key = cost_keys[forloop.index0] %}
| **{{ cost_category }}** {% input custom[category_key].accounts as:account_collection range:6,7 accounts_var:costs %} |
|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+{% for account in costs %}
|{{ account.name }}|{%=$11+ -1*account.value %}|{% input custom[account.number].beperking as:percentage %}{% if custom[account.number].beperking == blank %}{% assign beperking = 1 %}{% else %}{% assign beperking = 1-custom[account.number].beperking %}{% endif %}{% $13+ -1*beperking*account.value %}|{%=$14+ -1*beperking*account.value %}{% if forloop.last %}
| | **{% =$21+ $11 | currency %}** | **{% =$23+ $11-$13 | currency %}** | **{% =$1+ $14 | currency %}**{% result category_key $14 %}
|{% endif %}{% endfor %}{% endfor %}
-----------------------------------------------------------------------------------------------------------
|-----------40%--------------:|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+
| **{% t "Totaal" %}** | **{{ $21 | currency }}** | {{ $23 | currency }} | **{{ $1 | currency }}**
-----------------------------------------------------------------------------------------------------------
{% endcapture %}
{% if custom.detail.goederen == blank %}{% assign goederen_range = '60'%}{% else %}{% assign goederen_range = custom.detail.goederen %}{% endif %}
{% assign goederen = period.accounts | range:goederen_range %}
|---------------------|-------15%-------:|-------15%-------:|-------15%-------:+
| {% t "Ontvangsten/Baten" %} {% input custom.detail.omzet as:account_collection range:7 default:'70' accounts_var:omzet %}| | | {%=$10+ -1*omzet.value | currency %}{% for account in omzet %}
| {{ account.name }}|{{ -1*account.value | currency }}{% endfor %}{% ifi goederen.value != 0 %}
| {% t "Handelsgoederen, grond en hulpstoffen" %} {% input custom.detail.goederen as:account_collection range:60' %}| |{{ -1*goederen.value | currency }}{%
for account in goederen %}
| {{ account.name }}|{{ -1*account.value | currency }}{% endfor %}
| {% t "Beginvoorraad" %} {% input custom.detail.beginvoorraad as:account_collection range:6,7 accounts_var:beginvoorraad %} {% input custom.beginvoorraad.doc as:file %}| | {{ -1*beginvoorraad.value | currency}}
| {% t "Eindvoorraad" %} {% input custom.detail.eindvoorraad as:account_collection range:6,7 accounts_var:eindvoorraad %} {% input custom.eindvoorraad.doc as:file %}| |_{{ -1*eindvoorraad.value | currency}}_
| {% t "Verkochte goederen" %}|||_{%=$10+ -1*(beginvoorraad.value+goederen.value+eindvoorraad.value) | currency %}_
| {% t "Brutowinst" %} ||| **{{ $10 | currency }}**{% endifi %}{% ifi $30 != blank %}{%
for account in sociale_bijdrage %}
| {{ account.name }}|{{ account.value | currency }}{% endfor %}
| {% t "Toekenning meewerkende echtgeno(o)t(e)" %} | {%=$30+ -1*period.reports.kostenverg.perc_mw | currency %}|| {%=$10+ -1*$30 | currency %} {% endifi %}{% assign bruto_winst = $10 %}
| {% t "Kosten" %} | | |_{% =$10+ $1 %}_
| {% t "Nettoresultaat" %} | | | **{{ $10 | currency }}**
|{% fori extra_account in custom.extra_accounts %}
|{% input extra_account.name %} {% input extra_account.accounts as:account_collection range:6,7 %}{% input extra_account.doc as:file %} | | |{% assign accounts = period.accounts | range:extra_account.accounts %}{%=$20+ -1*accounts.value | currency %}{% endfori %}
|
|{% capture detailmeerminderwaarde %}
-----------------------------------------------------------------------------------------------------------
|-----------40%---------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+
| **{% t "Detail van de meer- en minderwaarden" %}** |**{{ period.year_end_date | date:'%Y' }}**| **{% t "% Fiscaal beperkt" %}** | **{% t "Belastbaar" %}**
{% stripnewlines %}
{% newline %}
-----------------------------------------------------------------------------------------------------------
{% newline %}
{% newline %}
{% newline %}{% ifi custom.meerwaarde.accounts != blank %}
|-----------40%--------------|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+
{% newline %}
| **Meerwaarde**{% input custom.meerwaarde.accounts as:account_collection range:76 accounts_var:meerwaarde %}||||
{% newline %}
{% for meer in meerwaarde %}
{% assign toegewezen = toegewezen | append: account.number | append:";" %}
| {{ meer.name }}
| {%=$2+ -1*meer.value | currency %}
| {% input custom[meer.number].beperking as:percentage placeholder:'0.00%' %}
{% if custom[meer.number].beperking == blank %}
{% assign beperking = 1 %}
{% else %}
{% assign beperking = 1-custom[meer.number].beperking %}
{% endif %}
{% $5+ -1*beperking*meer.value*meer.value as:currency %}
| {%=$4+ -1*beperking*meer.value as:currency %}
{% newline %}
{% endfor %}
{% newline %}
{% newline %}{% endifi %}
{% newline %}{% ifi custom.minderwaarde.accounts != blank %}
{% newline %}
| **Minderwaarde**{% input custom.minderwaarde.accounts as:account_collection range:66 accounts_var:minderwaarde %}|
{% newline %}
{% for account in minderwaarde %}
{% assign toegewezen = toegewezen | append: account.number | append:";" %}
| {{ account.name }}
| {%=$2+ -1*account.value | currency %}
| {% input custom[account.number].beperking as:percentage placeholder:'0.00%' %}
{% if custom[account.number].beperking == blank %}
{% assign beperking = 1 %}
{% else %}
{% assign beperking = 1-custom[account.number].beperking %}
{% endif %}
{% $5+ -1*beperking*account.value*account.value as:currency %}
| {%=$4+ -1*beperking*account.value as:currency %}
{% newline %}
{% endfor %}
{% newline %}{% endifi %}
{% newline %}
{% newline %}
{% newline %}
{% newline %}
{% endstripnewlines %}
|----------40%---------------:|---------------15%-----------:|---------------30%-----------:|---------------15%-----------:+
| **{% t "Totaal" %}** | **{{ $2 | currency }}** | | **{{ $4 | currency }}**
-----------------------------------------------------------------------------------------------------------
{% endcapture %}
| {% t "Verworpen uitgaven" %} | | {% assign verworpen_uitg = $23 %}{% result 'verworpen_uitg' $23 %}| {{ $23 | currency }}
| {% t "Investeringsaftrek" %} | | | {% input custom.detail.investaftrek as:currency %}{% assign investafrek = custom.detail.investaftrek %}{% result 'investaftrek' custom.detail.investaftrek %}
{% assign proef= ($10+$23-$30) %}
{% ic %}*{% t "proef" %} {{ proef | currency }}*{% endic %}
{% newpage %}
{{ table }}
{% ifi anderebo.value != 0 %}
{{ detailmeerminderwaarde }}{% endifi %}
{% assign niet_toegewezen = #6-#619999+#7+(bruto_winst+$0+$21+$20+$2)-(-1*custom.detail.echtgenote) %}
{% unexplained niet_toegewezen %}
{% ic %}*{% t "niet toegewezen bedrag" %} {{ niet_toegewezen | currency }}*{% endic %}
{% ifi custom.extra.bijlage.document or custom.extra.toelichting != blank %}<br>
{% stripnewlines %}
|------
|------
{% newline %}
| **{% t "Extra toelichting" %}**
| {% input custom.extra.bijlage as:file placeholder:'' %}
{% endstripnewlines %}
{% input custom.extra.toelichting as:text size:mini placeholder:'' %}
{% endifi %}