Open navigation

Set up an import template to extract Excel data

Modified on Mon, 24 Jul 2023 at 10:27 AM

Aico closing tasks are able to import and attach files as part of a closing task. T and this feature is described here: Attach a file from a file share to a closing task.

Where that file is an Excel (or CSV which Aico will automatically convert to an Excel) then it is possible to use an import template to manipulate the data in the file to create and post a journal. This article describes how this is done.

Setting up the Automation manager task

The task is set up using the Manual workflow task type and all the basic settings are the same as for all other manual tasks. Read this article to find out how to set up a manual task. 

Once your manual task is set up, follow the steps below: 

1. Set your new Aico document template in the task.

2. Once you have chosen a template, the Aico document headers section appears and you can set the report name.

3. The resulting document looks as follows:

As you can see, the report name is set from the Automation manager task but the formula takes the full file name in the Import Filename header. This is then the names of the file that is retrieved.

4. Set the journal headers that you need to be transferred into your journal such as:

  • posting date
  • document name 
  • currency etc.

Warning! The import template is used when the report is imported to extract and manipulate the data in the file and typically populates rows using the import template. It is possible to import data into the headers using this same method so please ensure you do not overwrite any document headers you have already set in the task template in Automation manager. The Excel import template will overwrite headers that are left editable.

Set up the import template on the task

The import template is used to extract and manipulate the file data so you can fill the journal rows which are then transferred into the journal itself.

Using an import template on a task is a standard function in Aico. There are instructions here on how to set up an SAP program with proposed journal which shows you how to create a journal from an SAP report which has already been converted to Excel. The steps here are identical.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article