Tuesday, December 15, 2020

PLI Checker Lite Error "Input string was not in a correct format" - Solution

 Error: 

"Input string was not in a correct format"

Solution:
There are some unnecessary blank rows in the Excel file generated from McCamish. That is the root cause of this Error. Download the latest version from the link given below and upgrade your current Application by running the downloaded exe file.
                                                                        
Please run the installer extracted from the zip file downloaded, it will upgrade your current Application without losing your data or install fresh for new users.  Do not uninstall the old version.  

PLI Checker Lite Logo PLI Checker Lite

Tool for comparing PLI/RPLI figures accounted in SAP with premium collected in Mccamish. This tool can generate detailed and consolidated comparison reports along with error extracts if any differences are detected. So you can easily find delinquent offices and ask them to make necessary corrections quickly. Uses SQLite3 as DB, hence data access will be isolated from other computers. Detailed instructions included.  
Requirements
  •  M.S Office 2007 or above
  •  .Net Framework 4.5.2 or above
Features
  •    Uses SQLite3, so usage will be isolated to one PC
  •  Compare PLI/RPLI figures in SAP with collections done in McCamish
  •  Automatic error extract generation
  •  Wrongly mapped offices can be corrected using Office Config Menu in Tools Window
  •  CPC Name included in error extract
  •  Consolidated and Detailed Comparison Reports can generated
  •  Comparison Report for RPLI and PLI can be generated at the same time
  •  Error extract number can be edited and it will increment with every error extract generation
  •  Optimized excel data upload and made the process faster
  •  Layout bug from the month Jul 2020 fixed
  •  Comparison report can be generated as PDF file New
  •  Each error extract can be printed in separate pages New
  •  Error Extracts can be send by eMail for more safety during COVID-19 time New