About the File Preparation Utility
FPU is a stand alone application which can be installed on a PC and will enable :
User to create the MIS file. The user need not prepare the complete file every time. For subsequent uploads, the intermediate file may be used after modification in relevant fields. FPU will also provide facility to open such files and edit at a later time for preparing subsequent MIS files.
Menus & Buttons
File - Open
This option can be used to open an intermediate file. On selection of this option system will display browser window to select the file stored at any location on the PC. Shortcut key to select the option is Ctrl + O
File - Save
This option can be used to save the digitised records as intermediary file. Shortcut key to select this function is Ctrl + S
File - Save As
This function can be used to save open file with another name at desired location.
Edit - Cut OR Edit - Copy & Edit - Paste
This series of functions can be used to Cut or Copy selected records from any line and than paste on desired line. Shortcut Keys for these functions are as follows:
Edit : Cut : Ctrl + X
Edit : Copy : Ctrl + C
Edit : Paste : Ctrl + V
Edit : Delete
This function can be used to clear selection area
Edit - Find
A Find search function enables to search the entire records for specific keyword. This function can be accessed using shortcut key Ctrl + F
Edit - Replace/Replace All
This function search for the value specified and replaces it with the new value specified by user. Shortcut key for this function is Ctrl + R
To replace one common field in the file in the single run the user can use the Replace all option for replacing that common field.
Edit - Paste from Excel
This function is used to Paste the data selected from MS Excel. Copy the data from the excel sheet and select the place in the contribution file where the data to be pasted. Shortcut key for this function is Ctrl + Space
Command Button Create File
This button is to be used to create a MIS File (.txt) and save the same at desired location
Command Button Add Rows
This button can be used to add specified no. of rows to the existing file
Command Button Delete a Row
This option can be used to delete specified row
Quitting the Application
To quit the File Preparation Utility user can select option File ? Exit or directly close the application using shortcut key Alt + F4
FIELD DESCRIPTION
Tab 1: MIS POP SP Details
POP-SP Reg. No.
User shall enter POP-SP Reg. No. provided by CRA. This is an mandatory field to create the file
POP-SP Office Name
User shall enter POP-SP Office Name which is an optional field
Request File Type
This is the drop-down option to select the type of file to be created. Two options are available namely Original and Correction
Original Batch ID
This field would be activated only if the option Correction is selected. In this field user shall enter
the batch ID of the original file.
Request Type
This is the drop-down option to select the request type for the MIS file to be generated
Total Subscriber Records
Application will display total count subscribers present in the file. This is an auto generated field
Tab 2: MIS File Details
Request Type
This is an auto generated field that will show the request type which is selected for the current MIS file.
Total Subscriber Records
This is an auto generated number which will show total count of Subscriber Records for particular MIS file
POP-SP Reg. No.
This is an auto generated number which will show the POP-SP Reg. No. for the current MIS file
Receipt No. (1-9 digits)
This is an auto generated number which will show the constant part (first 9 digits) of the Receipt No. depending upon the POP-SP Reg. No. and request type selected.
Note: All the fields for a particular request type visible in the grid are mandatory for creating the file. (except Remarks in 'Dishonored Cheque')
Sr. No
This is a default line number or serial number of a record displayed at leftmost side. To delete a row user shall specify this number pertaining to the record
Receipt No.(10-17 digits)
User shall enter the second part (10-17 digits) of the Receipt No. The 17 digit Receipt No. will be written in the text file.
Receipt No. Date(dd/MM/yyyy)
User shall enter the Receipt No. generation Date in dd/MM/yyyy format.
PRAN
User shall enter Permanent Retirement Account Number allotted by CRA to each Subscriber.
Subscriber Name
User shall enter Name of the Subscriber under this column.
Subscribers Contribution Amount
User shall enter Amount of Contribution paid by the subscriber here.
Subscriber's net contribution amount
User shall enter the Net contribution amount credited into subscriber's Tier I account after deducting the charges levied for the transaction.
Mode of Payment
User shall select Mode of Payment from drop-down list provided in the application.
Dishonored Cheque Reason
User shall select the reason for dishonoring the cheque from drop-down list provided in the application.
Remarks
User shall enter remarks if any. This field is mandatory in case where Dishonored cheque reason is 'Cheque Rejected'
Subscriber contribution Type
User shall select the Subscriber contribution Type from drop-down list provided in the application.
FC Registration number
User shall enter the FC Registration Number to which POP-SP has/will submit Subscriber Registration / Modification / Tier II Activation form.