Hi, I have a various exchange rates in excel. I want to get rates in reconciliation template and apply them to other reconciliation templates. Is there a way to import rates in a reconciliation template to avoid typing them manually every month? Thanks, Ugis

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: [image] CASE: disable import…

Hi Sven, Thanks for the reply. It was useful. I managed to link imported exch rates in one template to template where based on selected currency it gives me the rate. I want to push it a little further and see if I can use exchange rates that I imported in client A to apply them in client B. Is …

Hi @Ugis , Well, yes you can :smirk: [image] CASE reference values across templates by using result tags Workbook & Cases If you want to reference a certain value or variable from recon template A in another template, there’s a way to do it with the so-called result tags i…

Hi @sven , Thanks for the article. I managed to get value from template A and display it in Template B. When I change company form company C1 to company C2 I want to get value from C1-> template A and display in company C2 -> template B. Without the option to pin point company to look at templat…

Hi @Ugis , You can not access data from one client file to another. Related to rates: we are aware that an integration with Silverfin that would add this info (automatically or not) would be beneficial, and we are looking at possibilities but for now, I’m afraid to disappoint you.

Thanks for the update @sven . Glad to hear it is on your road map :slight_smile: Ugis

Import excel data in reconciliation template

Templates

sven August 30, 2019, 2:31pm 4

Hi @Ugis,

Well, yes you can

Hope that case is enough to tackle this further. If not, let us known

Topic		Replies	Views
POST reconciliation data to account entry template API	1	635	October 9, 2019
Retrieve data from one reconciliation into the other Templates	1	612	March 1, 2017
Importing reconcilation data: filter Templates	6	634	February 19, 2021
How to copy input from a reconciliation to another period? Templates export	11	1136	January 7, 2020
CASE reference values across templates by using result tags Cases references , result , use_case	0	1415	August 28, 2018

Import excel data in reconciliation template

Related topics