A/R Import


Listing this information to be used for the “See import Connections” section…

Command text: When the Connection string is defined, the Commend text will be defaulted to select all items from the external file. The Command text can be modified when there are situations that require the information from the file to be manipulated in some way in order to obtain certain results. An example of this would be when multiple columns from the external file need to be combined into one item to be used as a transaction comment. Another example would be if the information from the external file needs to be sorted or subtotaled in order to create a batch with fewer, or more meaningful, transactions. For additional information on this feature, please contact SGA support.




AR Import


Path: Setup > Imports > AR Imports

Accounts receivable transactions can be imported for both invoices and receipts. 

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.

Command text: See import connections.

Reference columns by: See import connections.

Create new deposit reference for every line: If checked, this will assign a unique number to each transaction amount for cash accounts associated with a checkbook. If this is not checked, the amounts for the same account and same date will be totaled together. This setting will control how the amounts are reflected in the Month End > Bank Reconciliation.

Use schema: In certain situations, the import setup may require a way to name the individual items being imported and/or the type of information (text, decimal, etc.) contained in each column.

Setup

Transaction Type: Select the type of import as either Invoice or Receipt 

Columns

From Column: Add lines for each external 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. The available columns will vary based on the object type.

Column Name

Required

Comments

Object Type

Yes

This identifies the object type of the invoice/receipt.

Payer ID

Yes

This identifies the payer of the invoice/receipt.

Item ID

No

Identifying number to group invoices and receipts.

Amount

Yes

Amount of the transaction.

Account

Yes

GL account to charge.

Date

No

If not specified, today's date will be used.

Receipt Number

No

Receipt Number for payment transactions.

Address ID

No

If not specified, PRIMARY is used.

Check Number

No

Check number of the receipt payment.

Transaction Code

No

Informational and reporting purposes only. The account distribution needs to be specified on the individual rows.

Comments

No

 Description of the transaction.

Deposit Date

No

If specified, the date to be used for the bank reconciliation.

Deposit Reference

No

Deposit reference to be used for the bank reconciliation. If not specified, the Auto number checkbox will control if the imported batch number is used to create a unique deposit. 

Reference

No

Informational only reference to a PO Number