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.

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.