Basically try to generate some sample reports that are pre-populated in the sql folder which gets executed on activation and is usable on enablement of permissions for the desired role.

Some points were discussed earlier here but couldn't get solution to it.

However the line

$file =  $comp_path.'/'.user_company(). '/pdf_files/'.$id.'.pdf';

can be fixed as below

$file =  $SysPrefs->comp_path.'/'.user_company(). '/pdf_files/'.$id.'.pdf';

I think this is a very broken extension. Are you sure its worth keeping it? Unless it works for someone else which I doubt.

1) I needed to change to

$file =  company_path().'/pdf_files/'.$id.'.pdf';

instead of

$file =  $comp_path.'/'.user_company(). '/pdf_files/'.$id.'.pdf';

to get it to kick start ..this is for my two different environments.
2) Inserting anything (garbage) in the test Sql box passes with flying green colors.

Something is genuinely wrong with this extension.

I am ready to spend time testing if you guide me to something that is useful..

Your issue is with the path not properly set in the official version of the extension and possibly permissions issue with the said folder if it still persists.