Payments can be imported from outside systems into an SGA batch. The import format must be in place before importing data into SGA. These are maintained under menu Settings > Accounts Payable > Invoice Payments Imports. The following are the settings for various types of import formats.

Name: The name that will be displayed as the name of the import.

General

Connector type: See import connections for help with setting up a connection to a file to import.

Connection string: See import connections for help with setting up a connection to a file to import.

Connection String Builder: Select the source and format your data import (e.g. Excel, Text).

Has Header: Check this box if the first row contains column headers.

Start Row: Defines the row number where actual data starts, usually to skip over headers or titles.

Reference columns by: This determines how columns are mapped or identified when importing (Name, Number).

Use schema: In certain situations, the import setup may require a way to identify the individual items being imported and/or the type of 

Setup

If not specified on the columns tab, these will be used.

Group payments by check number: The system sorts the data so that all payment records associated with the same check number are grouped together.

Checkbook: Select the checkbook from which this check batch will be processed. (The checkbook to be defaulted is assigned in Settings > Accounts Payable > Payment Options.)

Cash account: Select the G/L cash account in which this check batch will be processed. The account is displayed without the fund#. This G/L cash account must exist for every fund for which invoices are being processed within this batch.

Payment Type: Used to identify which type of payment was made. 

Columns

From Column: Add lines for each spreadsheet column you wish to import. From Column is the column name or number on the external file; see Reference columns by above. 

To Column: Click on the drop-down arrow to select the SGA item that matches what is listed in the From Column. Accounting Period is not a column definition but will be designated when importing the invoices (on the actual import screen). The available columns are: