IPPB cash management report is being generated for the entire IPPB branch instead of SO/HO/BO wise. To overcome the issue while tallying of the IPPB deposit, withdrawal total amounts office wise a small application was made by Aleti Ashok Kumar and attached below. 


Instructions:

  1. Create a folder "IPPB" in D drive.
  2. Download Cash Management Report(at sl.no.3 in HFINRPT of IPPB) in excel format.
  3. Place the downloaded report in "D:\ippb\". The file will be as "D:\ippb\REPORT.xls"
  4. Open the "ippbcmr.mdb" application, click on "Configuration". Enter your office GDS/Postman/PA/SPM IPPB agent IDs, Office names in the table. It is a one time configuration and no need to repeat the same after configuration done.
  5. Click on "Import Data". If your report is available in the above said location, data will be fetched automatically else error will be shown.
  6. Click on "Generate Report" to view the desired report.
  7. Click on "Exit" to close the application.