PROCEDURE:

1. DOWNLOAD THE DAILY TRANSACTION REPORT - SUMMARY file as ".XLS" format from Finacle MIS server using HFINRPT menu.

2. After downloading, open the concerned Excel file and copy the whole sheet using CNTRL + A

3.Paste the copied sheet in the sheet "PASTING SHEET" of the attached file.

4. Daily Report will be fetched in the sheet "DAILY ACCOUNT"

5. Missing GL code will be displayed in the right side of the column .

Type the missing GL code in Column C. After that, automatically missing GL code will be updated.

6. From this sheet all channel data will be fetched like a daily account format.

[DOWNLOAD]

General Ledger extracts to ERROR REPORT in CSI

 

Respected Sir/Madam,

I am directed to convey the following

The following are the reasons for movement of GL extracts to ERROR REPORT in CSI.

1. Unbalanced GL extract

2. Incorrect / Invalid Facility ID

3. Transactions in Unmapped GL

Only Incorect Facility ID and Unmapped GL can be corrected using T CODE ZFSI_ERROR. Amount cannot be modified in ZFSI_ERROR.

1. Customer Account Ownership issue

1. Customer leg of the Account Opening/Transactions done through RICT device is reflecting in Account Office instead of Branch Office. This is due to A/c Ownership issue. CIF of that particular account has been opened as EMPLOYEE CIF and not as CUSTOMER CIF. Due to technical issues, these particular accounts are reflecting in ACCOUNT OFFICE and NOT IN BO resulting in Unbalanced entry. Patch will be deployed shortly for this issue. Till such time, entire CBS transactions lying in ERROR REPORT need to be manually posted through voucher posting using GL Daily Transaction - Summary or Error report downloaded in excel. In case if this particular transaction is available as single line item in error report , BO FACILITY ID can be updated in error report for balancing the extract. Once these entries are balances, all CBS transactions will be posted both in BO facility ID and Account Office facility id.

Transactions reflecting under Channel ID : SDP - CONNECT24 CHANNEL ID without BO facilty id reflecting under the SOL is the account which is creating unbalanced entry. Identify the account number /CIF to check whether the account is having EMPLOYEE as a/c ownership.

2. RD Rebate of BO reflecting in Account Office

RD Rebate transaction done through RICT DEVICE reflecting in Account Office instead of Branch office resulting in unbalanced entry. Patch will be deployed shortly. Till such time, manual voucher posting for these CBS transactions both for account office and branch office to be done using GL Daily Transaction - Summary or Error report downloaded in excel.

3. BO Code mapped during account opening and BO New account debited is different

Account office while opening new account of Branch Office has mapped one BO code and debited BO new account of other BO resulting in unbalanced entires between these 2 Branch Offices. Manual voucher posting is to be done using GL Daily Transaction - Summary or Error report downloaded in excel.

4. BO Code DELETED or MODIFIED after transaction done through RICT device

Bo Code should not be deleted or modified if the TRANSACTION is done through RICT device. Deletion or Modification of BO code should be done on next day of transaction. Validation is also being requested for the same. Till such time, manual posting is to be done for these 2 BOs using GL Daily Transaction - Summary or Error report downloaded in excel.

Transactions are reflecting in the sols which are closed / merged in CSI but these SOLs are still not closed due to non transfer of customer accounts. These SOLS are updated in finacle with dummy facility ids as no faciilty id will be available in CSI for closed/merged offices. New SOL facilty id to be updated in place of dummy facility id . Once new faciilty id is updated in both credit and debit GLs, these transactions will reflect in NEW /MERGED SOL. Manual voucher posting is not required for this error.

This has the approval of DDG FS sir.

Thanks and Regards

Gopinath S Inspector Posts

Data Migration Command Centre(CBS)

Chennai 600 002

9962067155

Bulk voucher posting file creator for CBS GL integration Error file 

Click to Download :

 https://drive.google.com/open?id=1uclFhkDt9X33unkP4CfENKcvweStxTyw

The Tool is designed to facilitate Circle IT team who is monitoring CSI FSI GL integration to generate bulk voucher posing file out of FSI error file.

1. As an occasional activity, generate CSI offices file using zfid by entering facility ID of the Circle and output lay out as /DEF. Right click and export the same to spread sheet. Same need to be generated as and when new offices are being added in the Circle. 

2. Generate CSI FSI error file using zfi_error by providing Circle Facility ID and posting date 

3. In case of any missing facility ID, same can be updated in output generated and saved for auto updation of the same during next auto execution at server level

4. Right click on output file generated and save the same to spreadsheet.

5. Open the generated excel file and carry out required modifications. In case if for any entries facility ID is provided for auto updation at server level, details of the same to be removed in the spread sheet. In case if any extra entries are missed out and need to be added for tallying, same need to be added. In case if any BO transactions are shown in SO then required amount modifications in BO/ SO entries need to be done.

6. Once all the required modifications are done, save the file.

7. Run bulk voucher file creator for FSI error. Select CSI offices file generated through step1. Select FSI error file generated after required modifications at step6. Click on Generate button to generate bulk upload file. 

8. Text file will be generated in exe path with file name as CBSErrVoucherPostingFileddmmyyyyhhmmss.txt and with current date and time which can be uploaded through zbf07. 

Note: In case of any error while clicking on Generate Button, Download and install the Microsoft Access Database Engine 2010 32bit Redistributable available in following link

https://www.microsoft.com/en-US/download/details.aspx?id=13255

Suggestions/ improvements if any may please be intimated over mail to tgy.ap@indiapost.gov.in