Generic Import Setup

 

This section describes the setup needed to support importing .CSV files through the Generic Import option in Payment Management.

 

The following describes the setup needed to support the Generic Import and in the suggested order of operation.

 

Note

Layout of the Generic Import is the same as that of a van line statement.

 

 

Setup

Description

Generic Import File Format

Each statement imported into Payment Management must be in a .CSV file with the correct format. A template for the import file is available along with field descriptions in the Generic Import File Format topic.

Files must exist in a folder accessible to the MoversSuite application, such as the location of any van line statement files currently being used. Once a file is imported, it is copied to a Processed folder within the statement folder, e.g. “c:\Van Line Statements\Processed”.

Import Auto Apply Options

Enable auto apply for an import file by setting the Import Auto Apply Options files for the user. These options are referenced by default when the CSV file is imported. Additionally, there is an Auto Apply flag in the CSV file header that enables Auto Apply and produces the through Statement Import Summary (Generic Import), as well.

Service Code Setup

Item Code Setup

If you want the process to automatically apply to items imported, then verify that the Service Codes defined within MoversSuite match up to those set within the Service Code field in the import file (refer to the Service Code field setting within Generic Import File Format).

Service Codes are groupings of Item Codes, so you may need to reference the Item Code Setup as well.

XML Interface Setup

Use this setup to define each type of file to import through the Generic Import option.

 

Setting

Description

Vendor Name

Set this to a particular customer, vendor, or process to be recognized by the Generic Import process. For example, for a lock box statement use the financial institute the checks are issued from.

Van Line Item

Ignored for generic imports

Branch

 

Ignored for generic imports

 

 

XML System Setup

Create a single “Statement” type system record to link to the XML Interface Setup record.

 

Important

The System Data Type field set within the import .CSV file must match the Name established within the data type mapping section of this setup.

 

Setting

Description

Interface

Select the Vendor Name defined for the process within XML Interface Setup

Internal System

Enter the Vendor Name defined for the process within XML Interface Setup

External System

Enter the Vendor Name defined for the process within XML Interface Setup

XML System Option

Ignored for generic imports

XML System Data Type Map

Create a single record with the Xml System Date Type set to “Statement.”

Set the Name to the Vendor Name defined for the process within XML Interface Setup. The System Data Type field set within the import .CSV (see Generic Import File Format) must match the Name value set here.

The Clear previous XML errors before reprocessing is ignored for generic imports

 

 

Statement Payment Code Setup

Create one or more Interface Items to supported payment types for the defined Payment Codes.

 

Important

The Payment Code field set within the import .CSV file must match the External Payment Code established within this setup.

 

Setting

Description

Payment Code

Create multiple records for each supported Payment Code values (defined in Statement Payment Code Setup).

Interface Item

Create multiple Interface Items for the support

Select the Vendor Name defined for the process within XML Interface Setup

External Payment Code

Set this code to align with the Payment Code. For generic imports, this can be any value, however it must match the Payment Code set within the import file (see Generic Import File Format).

 

 

User Setup for SQL Security

The MssAPI service user must have MssGPExec rights to the appropriate company-specific Microsoft Dynamics GP database. Refer to User Setup for SQL Security for instructions.

 

Once setup is complete, you can follow these steps to build and import the .CSV file into MoversSuite:

 

Step

Description

1

Open the CSV template (see Generic Import File Format)

2

Enter all needed lines of data using Microsoft Excel.

Use the Find and Replace (CTRL+F) and the Copy and Paste (CTRL+C, CTRL+V) features to assist you in setting up forms quickly

3

Save the file as a .CSV file type to a folder accessible to the MoversSuite application, e.g. “c:\\Statement Files”

In Microsoft Excel, save the file through File > Save As > Save type as > CSV (Comma delimited).

Note: MoversSuite recommends saving to a folder that easy to find and discern its purpose, such as “Statement Files” or “Statement Import.” When MoversSuite processes an import file, it places it in a sub-folder titled, “Processed.”

4

Open Payment Management

5

Locate and import the saved .CSV file through the Import > Generic Import (.CSV) function.

6

Verify the data in the Statement Import Summary (Generic Import) screen and set Import As to “Cash Receipts” and optionally modify Journal/Deposit Date, Branch, Batch Name, and Cash/Clearing Account values

7

Press Import

8

Process the import using general Payment Management procedures