Import excel data in reconciliation template

[sven]

Hi @Ugis,

You’ll just have to use a reconciliation template and create a custom collection in that with a fori-loop.

Here you’ll find a case, although a bit different as it explains how to setup a collection that should be unavailable for excel-import:

CASE: disable importing reconciliation data for a specific collection

In a account or reconciliation template, there is always the option to import reconciliation data automatically based upon the ledger (in case of an account template) or an excel file (works for both template types): [Screenshot-2019-05-23-at-09-32-03] But what if you wish a certain collection cannot be used for automatic reconciliation? We automatically fetch and display every fori-loop there is in the template. Disabling a fori-loop can actually be done by (mis)using the addnewinputs-tag, l…

Let us known if it works out for you.