Account collection with only starred accounts but which exclude a type of account

[Alexandra]

Is it possible to create an account collection with only starred accounts but which excludes a type of accounts (model of account) ?
In my case, I would like to exclude the model of account “current accounts” from my reconciliation.

Here is my actual code

|**AUTRES DETTES** {% assign standard_range = "48" %}{% assign starred_range = period.accounts[standard_range].starred | map:"number" | join:","  %}{% if custom.accounts.numbers_48 == blank %}{% assign account_range48 = starred_range %}{% else %}{% assign account_range48 = custom.accounts.numbers_48 %}{% endif %}{% input custom.accounts.numbers_48 as:account_collection range:starred_range default:account_range48 accounts_var:accounts_48 %}|
{% assign current_account = accounts_48 %}
|--60%--|-20%--:|-5%-:|-20%-:+{% for account in current_account %}
|         _*{{ account.name }}*_ {%assign acc_key = account.number%}| 

|--60%--|-20%--:|-5%-:|-20%-:+{% for detail in current_account.[acc_key].details %}
|            {{ detail.custom.title }} | {{ detail.custom.value|currency }} {% endfor %}
|                                      |_ _|
|                                      | {{ account.value|currency }}
{% endfor %}

[sven]

Hello @Alexandra,

I think what you’re going for, is described here:

CASE: create unique selectable account ranges

Let’s say we create a forloop over an array, and each item of that array will be used to create a hashtag to select some accounts, like this: [04] Of course, one account can not be linked to more than one categorie. So, how can we make sure that each hashtag show the accounts that have not yet been selected? First of all, this is the code for above example: {% comment %}create different categories to loop over{% endcomment %} {% assign array_categories = "IMVA|MVA|FVA" | split:"|" %} {% ass…

So basically, if you wish to create a string with all type of accounts in it, besides assets eg, you’ll need to loop over all those different accounts, and create one string from it, which you can then use for the range.
Excluding isn’t an option for now, but with a workaround you can however.
Can you let me know if this works out for you?

PS haven’t found many cases in which you’d want t exclude a certain type of account… Most cases, the range is enough for this (definitely in Belgium with our fixed chart of accounts).