Dear team,
First of all my best wishes.
We tried to create a separate sheet (via “reconciliation template”) which will basically take all the information from your Adjustment report and put that in a different layout (with additional information). The purpose is to add this new sheet in our export package (i.e. we need something different than your standard report). So we were able to build it but we are still struggling with some items.
that’s how it currently looks like
our issues :
- we were not able to insert a blank row or a double line after adjustment #1 and #2 … in order to clearly make a distinction between each adjustment
- column 2 : instead of just taking the tags we created, it also includes " {“name”=> how can we delete that ?
- last column : we would like to include here the amount in credit or debit, only if it relates to a P&L account
- when we add this sheet to our export package, we get a blank page
That’s a lot of question but we’d grateful if you can assist us with
Here are the liquid codes
{% comment %}have the GREY header in INPUT, while having the BLACK LINE header in export{% endcomment %}
{% comment %}GREY header{% endcomment %}
{% stripnewlines %}
| Adjustment nb
| XXX / Client / Audit
| Description
| Account xxx
| Account Client
| Account Name
| Debit
| credit
| P&L impact
{% newline %}
|:----25%----:
|:----25%----:
|:----25%----:
|:----25%----:
{% ic %}#{% endic %} {% comment %}shows GREY header in INPUT mode{% endcomment %}
{% nic %}+{% endnic %}{% comment %}shows BLACK LINE header in OUTPUT mode{% endcomment %}
{% newline %}
{%assign adjs = period.adjustments %}
{% fori adjustment in adjs %}
{%assign lineindex = 0%}{% fori transaction in adjustment.transactions %}
{%assign lineindex = lineindex+1%}
{% assign adj_number = adjustment.number %}
{% assign adj_tags = adjustment.tags %}
{% assign tran_account_XXX = transaction.account.number %}
{% assign tran_account_client = transaction.account.original_number %}
{% assign tran_account_name_client = transaction.account.original_name %}
{% assign tran_description = transaction.description %}
{% assign tran_amount_debit = transaction.value %}
{% assign tran_amount_credit = transaction.credit %}
{% assign tran_amount_P&L = transaction.profit&loss %}
|# {{ adj_number }}
|{{ adj_tags }}
|{{ tran_description }}
|{{ tran_account_xxx }}
|{{ tran_account_client }}
|{{ tran_account_name_client }}
| {% if transaction.value > 0 %}{%assign tranval = transaction.value %}{%else%}{%assign tranval = - %}{% endif %} {{ tranval | currency }}
| {% if transaction.value < 0 %}{%assign tranval = (-1)*transaction.value %}{%else%}{%assign tranval = - %}{% endif %} {{ tranval | currency }}
|{% assign tran_amount_P&L = balance_sheet %}
|{%newline%}
{%endfori%}
{%endfori%}
{% endstripnewlines %}