I’m making a document where i want to have/create a list of all new investments in a year. These investment are already explained in the details in the right account but i want them to use in another document.
So if there are 2 new cars explained on the account 241000:
Datum fact. omschrijving AW vorige afschr. afschrijving Tot. afsch. BW L/D Jr
12/01/2016 20170001 Car1 10.000 EUR 0 EUR 2.000 EUR 2.000 EUR 8.000 EUR L 5 jaar
24/02/2016 20170012 Car2 20.000 EUR 0 EUR 4.000 EUR 4.000 EUR 16.000 EUR L 5 jaar
I want to use those details in a document. Can u help me how to program this?
@sven Thanks!
Where will i find a list off the changes?
I have 2 questions left:
Number 1
This is wat i have:
Te bespreken: 30/06/2016 - 30/06/2017
but i want the first day of the fiscal year so: 01/07/2016 - 30/06/2017
How do i define this?
Number 2:
I have the following result:
Te ontvangen119.269,61EUR
with the folowwing code:
{% assign belastingen = 1*period.reconciliations.belastingberekening.results.vennootschapsbelasting %}
So details are attached to the current_account. If you want to get the variables in another text-template f.i., you’ll have to define your current_account first (otherwise there is no way to get the details) :
{% assign current_account = #21__26 %}
So you can get every detail of accounts 21 till 26.
With a forloop, you can call now upon the variables you want :
{% for detail in current_account.details %}
{{ detail.date }} {{ detail.custom.fact }}
{% endfor %}
We still need to get a better alternative for this, but we still need to update our templates for that (guessing it will be after 2 weeks after @Mathias is back in the office).
But for now, I hope this can be an alternative for you to start.
@sven Thanks! That really helped me. I’m looking forward to the update.
In the meantime i’m using you’re code. I have just one question left.
this is my code:
{% assign current_account = #231100 %}
|Materiaal
|------20%------|-----10%----|-----40%-----|----15%-----|:----15%-----:+ {% for detail in current_account.details %}
| {{ detail.date }}| {{ detail.custom.fact }} |{{ detail.custom.title }}| {{ detail.custom.value }} |{{ detail.custom.l_d }}
{% endfor %}
en this is te result:
Materiaal
2015-12-05 201600010 Geluidsmeter Full Option 3800.0 D
2015-12-21 201600014 SVAN 971 integrerende klasse 1 met geluidsmeter 1834.8 D
2015-12-21 201600014 SVA Octave analysis option 700.13 D
2015-12-21 201600014 Tapping machine 4060.0 D
2016-01-14 201600027 2AMC 300 + Sylomer veren 1024.0 D
2016-05-06 201600040 NOR 140 klasse 1 geluidsmeter 7688.25 D
2016-06-08 201600043 Uitbereiding NOR 2265.0 D
but only the first line is correct that they respect the % of the colomn. The other lines do not respect the % of the table. how do this come?
@sven the result of this is i get a list off all investement trought the years but i want only the new investement in a specific accountic period. How can i do this?
You can do this by making an if-statement, for example (for new investments):
{% if detail.date.to_date >= period.year_start_date %} show investment {% else %} don't show investment {% endif %}
for example (in a specific accounting period):
{% if detail.date.to_date >= period.year_start_date and detail.date.to_date <= period.year_end_date %}show investment {% else %} don't show investment {% endif %}
Or, depending on what you want to do, you could do a “hideunlessi”. You can see this in action, if you take a look at the code of the “Investeringstabel” template in your template collection.