How To Set Up Import Reconciliation (SweBase)

The functionality for importing reconciliation files from the bank into Business Central is available in SweBase.

The advantage of setting up the Import Reconciliation (SweBase) in Spider is that it enables the user to leverage the Communication Methods available within Spider, such as S/Ftp, Ftp, Azure File Storage, Azure Blob Storage and SharePoint Online.

Tip

If the Eagle app is installed it is possible to import and process the files across multiple companies. See the workflow for Process SweBase File Imports with Spider

Important

To be able to import and process the reconciliation files in Spider it is required that the settings in SweBase such as specifying which journals to use on the Bank file type setup page is done. This documentation provides steps to do this.

Step 1: Create Integration

Note

The following steps focus on the settings that are mandatory.

1. Choose the search icon (ALT+Q), enter Integrations, and then choose the related link.
2. On the General FastTab:
   1. Select New.
   2. Enter a Code.
   3. Select Import Reconciliation (SweBase) in the Integration Type field.
3. On the Communication FastTab:
   1. Select an existing Communication Method.
   2. Enable the Include in Import field, which allows the files to be imported into the Integration Queue without having to manually select them.

Step 2: Specify Bank file type settings in SweBase

1. Choose the search icon (ALT+Q), enter Bank file type setup and then choose the related link.
2. Select New.
3. Select the type of file in the Bank file type field.
4. Select which Journal Template Name and Journal Batch Name to use for each file type. Continue to add all the file types that are used for reconciliation.

Note

The Bank file type setup is used to define which journal template and batch to use for each reconciliation file and it is a feature in the SweBase app. Please visit the SweBase documentation for more information.

See Also

How To Set Up File Imports - Overview
How To Set Up Communication Methods
Workflows - Spider