checked the Pentaho ETL then coordinate to sir Jimmy & Mark the status of checking, fixed the script added condition for generating Hachiko code if the vendor code is not on the list, then advised the user to try again with the new generated polling file