Mover’s Suite can create a file containing transaction information that can be uploaded to a banking service provider.   Further, a user can elect to setup the system to automatically upload the generated file to service provider through File Transfer Protocol (FTP).

 

When the file is created within the Advance Processing interface, the user will be prompted to save the file to a location on the application server.   A system administrator can provide a valid location and appropriate access.

 

The following data will be needed from the provider who is to receive the upload file containing advance transactions.

 

Data Needed from Service Provider	Description
Company Number	This is a specific number assigned to a branch (company) by the service provider.  Each branch that will be used to upload files from must have the correct Company Number. This field is set within Web Administration > Common > Branch Setup for each branch that needs to upload files to service provider.
FTP Host Directory	This the target on the application server that will store the upload files for a particular branch. This field is set within Web Administration > Common > Branch Setup for each branch that needs to upload files to service provider.
User Name	The name to use when logging into the service provider’s system. This field is set within Web Administration > Accounting Setup> Advance Setup.
Password	The password for the User Name that grants access to the service provider’s system. This field is set within Web Administration > Accounting Setup > Advance Setup.
FTP Host	The FTP Host, such as “http://bankingservice.com”. This field is set within Web Administration > Accounting Setup> Advance Setup.
FTP Port	The FTP Port to use on the on the service provider’s system, such as “8080”. This field is set within Web Administration > Accounting Setup> Advance Setup.
Account Number	Number assigned to an employee, a group of employees, or a department.  The same Account Number can be used multiple times. This field is set within Web Administration > User Setup > Personnel for each driver involved in the file upload for advances.
Account ID	This is a driver specific number supplied by the service provider. This field is set within Web Administration > User Setup > Personnel for each driver involved in the file upload for advances.

 

 

This section describes how a user can define the setup of the file to upload to a banking service provider.  The setup involves the use of the Web Administration Tool.  Refer to the Web Administration Tool section for more information.

 

Update Banking Service Provider settings to create an upload file

1.   Access the Web Administration Tool,

2.   Open the Accounting Setup > Advance Setup,

3.   Press the Edit button to allow fields within the screen to be edited,

Within the Banking Service Provider section:

Figure 30: Banking Service Provider setup screen

 

4.   Select a Provider from the available list.  Note: If only one provider is established on the system, then that provider will automatically be listed and no selection option will be present,

Note:  Refer to the Driver Advances Transactions Setup section for information on the settings for generating accounting transactions, which includes the Vendor ID and Generate Transactions options.

5.   Place a check in the box next to Generate Upload File to allow the application to create a batch file of advance records to be uploaded to a service provider,

Note:  The Do Not Send to Banking Service option will be ignored if Generate Upload File is not set.  This option is found in Add/Edit Advances window within Mover’s Suite.  Refer to the Advance Management section for more information on accessing this window.

Figure 31: Do Not Send to Banking Service option in Advance Management

 

6.   Check the box next to the Auto Upload to Provider label to allow the system to check for batch files containing records and upload them into the service provider’s system through File Transfer Protocol (FTP),

7.   Enter the User Name, Password, FTP Host (machine name), and FTP Port supplied by the service provider to log into their system with.  If the Auto Upload to Provider field is set then values will be required for these four fields,

The branches that will be used to create an upload file for advance transactions will need to be updated as described below.   The Default Branch of the dispatcher will be used to retrieve the Branch Setup values.

Figure 32: Default Branch setting in Personnel setup

 

8.   Open the Common > Branch Setup setup,

9.   Locate and select the Branch that will be able to generate upload files within,

10.  Open the General tab,

11.  Press the Edit button to allow fields within the screen to be edited,

Within the Advance Setup section:

12.  Enter the Company Number supplied by the banking service provider.  This value is used to name the upload file on a user’s system and is included within each record within the upload file,

13.  Enter the FTP Host Directory on the application server that will contain the files to be uploaded to the banking service provider as part of the automatic upload process,

Figure 33: Advance Setup in Personnel setup

Personnel records for drivers must also contain the account number and identification supplied from the banking service provider in order to be included within the upload file.  Refer to the Setting Up Drivers to Receive Advances section for details on updating a driver’s personnel record.

14.  Press Save to keep the changes made.

 

When properly setup the system will allow advance transactions to be placed in a batch file where it can be uploaded to the service provider. 

 

The upload file will be in Text Document format containing a file extension of TXT.  This file will be named beginning with “PC” and followed by the company number of the branch in which the file was created.  For example, if the Company Number is set to “12345” within the Branch Setup (for the default branch assigned to the dispatcher), then the file name would be PC12345.txt when saved to disc.

 

The source directory of these files will be that specified within the Branch Setup, unless the Auto Upload to Provider option is selected.  In this case, the application will not create a physical file; it will, instead, pull the data directly from the Advance Batch table.

 

Tip: When an upload file is created from within Advance Processing, the contents and related information are contained within the AdvanceBatch table in Mover’s Suite and can be viewed using support Microsoft SQL Server products.  Refer to the AdvanceBatch record within this table to view exactly what was written to the upload file.

 

Only uploads to T-Chek are currently being supported.  Refer to the T-Chek Upload File Format section for the T-Chek file layout.