Upload Files

This facility enables the manual uploading of certain transaction files.  This is an ad-hoc process, and is available for use whenever the need arises.

 

Also refer to

Supplements

Take-on versus Transfer Values

 

Process for loading an ad-hoc file

From the General menu, select Tables from the sub-menu on the left, then click System Controls

 

 

For Identifier SFUPLOADPATHADH, ensure Text Value is C:\INpensions\Income\Adhoc

 

Run BatchSFLoadDW.exe under \Program Files\Bytes Software\INpensions\.  The Load Income and Splits from Payroll screen will be displayed.

 

 

Ensure that Folder containing Adhoc transactions is set to C:\INpensions\Income\Adhoc

 

From the General menu, select Upload Files from the sub-menu on the left. 

 

 

You can click BROWSE to use the standard Screens functionality to locate the file, or you can insert the file name.  Click SUBMIT FILE.

 

The job is executed by running Member.bat, and the file is placed in the C:\INpensions\Income\Adhoc folder.  Refer to

Processes

Contributions

Income

Income

Submitting Batches

 

The transactions are made available for processing as normal.  Refer to

Processes

Contributions

Income

Income

Select Batch

 

File name and format

The file is comma delimited, and the name of the file is the pay centre name, followed by .TXT, e.g. JHBSALES.TXT

 

Input file example

 

Input file layout

 

Field Name

Description / Value

1

Fund Code

 

2

Reference Number

 

3

Ben Category

 

4

Investment Option

 

5

Investment Type

F (future) – used for transfer values

P (past)

6

Income Type

 

7

Expense Type

 

8

Amount

 

9

Date Effective

 

Note:

There are no header or footer rows.