{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Functional Requirements","Change management Requirements","Accreditation and Certification","Technical Requirements","Evaluation Criteria"],"not_rendered":{"images":2,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Functional Requirements","index":0,"n_rows":864,"n_cols":10,"rows_kept":864,"merged":[[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,1,7],[1,8,2,8]]}
["Council for Geoscience Functional Requirements"]
["Section","Process","No","Must Have","Nice to have ","Description","Response",null,"Give a description of the module which provides this funtionality "]
[{"$nulls":6},"COMPLY","NOT COMPLY"]
["Human Resource Management","Recruitment Management",1,"ü",null,"The system should have a facility to create or import a job profile online  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",2,"ü",null,"The system should have a facility to create and access staff requisitions online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",3,"ü",null,"The system should have a facility to search for eligible applicants from a list of previously submitted applications online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",4,"ü",null,"The system should have a facility for applicants to apply for positions online",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",5,"ü",null,"The system should have facility to import CVs from the Internet or email ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",6,"ü",null,"The system should be able to filter through applicants and shortlist ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",7,"ü",null,"The system should enable workflow for forwarding application forms and CVs to reviewers and approvers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",8,"ü",null,"The system should allow for tracking of forwarded applications ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",9,"ü",null,"The system should have a facility to schedule interviews on-line through sending an email to the shortlisted candidate ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",10,null,"ü","The system should have a facility to route and track interview results ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",11,"ü",null,"The system should have a facility to customise recruitment letters by merging files with a word processing template ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",12,"ü",null,"The system should have a facility to track progress of the application throughout the process which includes motivations for appointments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",13,"ü",null,"Should have a facility to derive competencies automatically from existing job profiles ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",14,"ü",null,"The system should enable competency matching between applicants’ competencies and vacancies and provide an initial shortlist of candidates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Recruitment Management",15,"ü",null,"Cater for employee onboarding (i.e. notify IT, Protection Services, SHEQ etc if necessary) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",16,"ü",null,"The system should have a central database containing all employee information with restricted access",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",17,"ü",null,"The system should have a facility to search through employee records for information on experience and skills",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",18,"ü",null,"The system should track and store information on employee education and training",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",19,"ü",null,"The system should enable updating capability to the employee",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",20,"ü",null,"The system should provide an employee record in a database that stores personal information, experience, training, competency profile, promotions, performance appraisals and salary reviews ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",21,"ü",null,"The system should update employee competency profile with competencies acquired from training ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",22,"ü",null,"The system should have a personnel file structure as defined by the HR Department and Management",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Profiling",23,"ü",null,"The system should have a facility to identify gaps between an employee's competency profile and the competency profile of their job ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",24,"ü",null," The system should have Employee Self Service (ESS) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",25,"ü",null,"Employee Self Service Module to satisfy the following (not limited to the below): Requesting and approval of leave (initiate workflow for leave to be approved), Request correction of personal information, Submit timesheets, View training record, View performance details, Upload & update of CV’s, Capturing of travel claim, Cancellation of leave that has been approved ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",26,"ü",null,"The system should be able to do a leave trend analysis to assist in identifying leave abnormalities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",27,"ü",null,"The system must have multi-level approval",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",28,"ü",null,"The ESS must have record of all documentation and records relating to an employee",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",29,"ü",null,"The ESS must have functionality to query employee retirement plans, bonus, annual increment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",30,"ü",null,"The system must automate the workflow for benefits changes between Service Provider (Med Aid), HR and Payroll ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Employee Self Service",31,"ü",null,"The system should define entities and organisational units within the company ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",32,"ü",null,"The system should enable organisational structures to be defined using a matrix or a hierarchy and management of the organisational structure with vacancy and people identification ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",33,"ü",null,"The system should enable restricted access to the organisational structure and department information ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",34,"ü",null,"The system should allow for drag-and-drop to be used to change the organisational structure, with changes automatically updated in the employee records",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",35,"ü",null,"The system should have a facility for the organisational structure to be used to define role-based information and database access ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",36,"ü",null,"The system must be able to flag any alterations to information on the Organisational structure and/or personnel structure to ensure that necessary updates are made ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Structures",37,"ü",null,"The system should maintain personnel structure",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",38,"ü",null,"The system should flag vacant posts to ensure that they are identified and filled accordingly ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",39,"ü",null,"The system should be able to provide automated time and attendance (Access control)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",40,"ü",null,"The system should be able to identify the job position ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",41,"ü",null,"The system must keep record of employee position movements ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",42,"ü",null,"The system must provide reminders and notifications for end of contract (starting 6 months prior to contract end) to relevant HR personnel, the line-manager and relevant employee",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Organisational Management",43,"ü",null,"The system should track disciplinary/ grievance processes from initiation until closure and maintain all related documentation",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",44,"ü",null,"The system should have position or job title descriptions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",45,"ü",null,"The system should indicate the position by organisation, location, job code, title, shift, and work days",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",46,"ü",null,"The system should indicate employment status - full, part-time, contract or intern  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",47,"ü",null,"The system should show employee standard work hours ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",48,"ü",null,"The system should list skills, training, and education required for the position",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",49,"ü",null,"The system should have fields for descriptions of job activities, requirements, and experience ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",50,"ü",null,"The system should describe a job or task including employee skill set and profile ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",51,"ü",null,"The system should allow for multiple jobs to be entered for each  task grouping ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",52,"ü",null,"The system should assign multiple grades or codes to personnel with cross-training requirements",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",53,"ü",null,"The system should have user-defined salary grading ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",54,"ü",null,"The system should track salary grades and pay bands",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",55,"ü",null,"The system should indicate employee's current and previous assignments, as well as experience and job grades",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",56,"ü",null,"The system should indicate employee grading including corresponding rewards and salary scale ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",57,"ü",null,"The system should have standard salary band tables",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Job Positions & Salary Profiles",58,"ü",null,"The system should have a facility to create individual development plans (IDPs) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",59,"ü",null,"The system should identify any training, courses, and development activities in which employees have participated ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",60,"ü",null,"The system should source the course description and schedules ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",61,"ü",null,"The system should match the IDP with available courses ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",62,"ü",null,"The system should enable the reporting of training costs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",63,"ü",null,"The system should enable the updating of employee records in the employee database with training undertaken",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",64,"ü",null,"The system should provide the capability to administer training ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",65,"ü",null,"The system should automatically communicate course information to participants ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",66,"ü",null,"The system should maintain bursary records ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",67,"ü",null,"The system should provide for the automatic generation of workplace skills reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",68,"ü",null,"The system should allow for adjustable rules for incentives or bonus plans ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",69,"ü",null,"The system must have a skills matrix that will be updated by employees on an annual basis ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Training and Development",70,"ü",null,"The system must provide reminders to employees to update the skills matrix ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Management of Rewards",71,"ü",null,"The system should generate reports on the costs of rewards and incentives ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Management of Rewards",72,null,"ü","The system should manage and update the history of individual employee rewards and incentives",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Management of Rewards",73,"ü",null,"The system should link performance management with reward management ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Management of Rewards",74,"ü",null,"The system should track and analyse compensation and salary, by employee ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Management of Rewards",75,"ü",null,"The system should have the capability to send reminders in line with performance management diary ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",76,"ü",null,"Enable capture of scorecard, enable cascading",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",77,"ü",null,"The system should automate performance reviews and score calculations ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",78,"ü",null,"The system should produce reports of evaluations and scores by departments/business units ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",79,"ü",null,"The system should produce a bell curve by department/business unit/organisation ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",80,"ü",null,"The system should have a dashboard of the CGS corporate scorecard to track overall performance including dashboards for departments/business units/organisation",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Performance Management",81,"ü",null,"The system should automatically link performance with reward, incentive and remuneration",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Reporting",82,"ü",null,"The system must enable business to produce statutory, standard and ad-hoc HR reports",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Reporting",83,"ü",null,"The system must enable reporting on HR related statistics on a monthly, quarterly and annual basis",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Reporting",84,"ü",null,"The system must be able to produce a graphic view of data required for reporting ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","General",85,"ü",null,"The system must generate reminders for specified processes and events",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","General",86,"ü",null,"The system must be able to allow HR to operate in a paperless environment and move away from physical files",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","General",87,"ü",null,"The system must have document management capability",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Leave Management",88,"ü",null,"The system should be able to manage leave applications and approvals.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Human Resource Management","Leave Management",89,"ü",null,"The system should assist in managing leave and annual shutdown period to ensure that relevant resources don’t go on leave at a time they are needed most.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",90,"ü",null,"The system must be able to easily integrate with a banking system",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",91,"ü",null,"The system must be able to support reversal of a single payslip ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",92,"ü",null,"The system must support the employees on a database that contains all relevant employee files and records.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",93,"ü",null,"The system should support non UIF paying members.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",94,"ü",null,"The system must support capability to handle negative payments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",95,"ü",null,"The system should support different pay structures (as per CGS policy)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",96,"ü",null,"The system should support all relevant payroll reporting including (but not limited to): Tax calculations, Fringe benefit calculations, COID (Compensation for Occupation Injury and Diseases)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",97,"ü",null,"The system must be able to produce budgets and various scenarios thereof ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",98,"ü",null,"The system should synchronise with time management system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",99,"ü",null,"The system must provide MSS (Manager Self Service) options ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",100,"ü",null,"The system must manage allowances and benefits ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",101,"ü",null,"The system must facilitate overtime management ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",102,"ü",null,"The system must support automated time and attendance register ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",103,"ü",null,"The system must support seamless integration with SARS ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Payroll",104,"ü",null,"The system must support reimbursements and advances which do not happen at same time and may not be taxable at advance stage",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",105,"ü",null,"Maintain a complete audit trail of transactions for internal and external auditing ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",106,"ü",null,"User-assigned security rules that restrict entry and query access to specific GL accounts or ranges of accounts. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",107,"ü",null,"Allow for the fiscal calendar to be defined by the user ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",108,"ü",null,"Allow for calendar periods to be defined by the user ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",109,"ü",null,"Support for multiple calendars ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",110,"ü",null,"Fiscal monthly period options to track year end adjustment, audit adjustments and roll over.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",111,"ü",null,"Facility to open any number of fiscal years or calendar periods at the same time ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",112,"ü",null,"Facility to choose between batch and real-time posting modes ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",113,"ü",null,"User-defined criteria for system purges for G/L transactions, journal vouchers, and data relating to accounts payable (A/P) based on the number of years or months that the data is required to maintain for",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",114,"ü",null,"Automatic check to ensure that prior to deleting a financial record, the account balance must be zero ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",115,"ü",null,"A flexible general ledger (G/L) key with multiple levels ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",116,"ü",null,"Exception reporting with drill-down capabilities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",117,"ü",null,"Automatic year-end rolling of balances in sub ledgers and G/L control accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",118,"ü",null,"Automatic linking and posting of control accounts from related sub ledger accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",119,"ü",null,"User-defined field names for tables ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",120,"ü",null,"Method for validating inputs to ensure only appropriate records are updated ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",121,"ü",null,"Archiving of transaction history as well as purge from active files ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",122,"ü",null,"Chart of account structures may be user defined ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",123,"ü",null,"Account numbers may contain a mininum of thirty characters ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",124,"ü",null,"Facility for users to enter just the required numbers rather than the entire account number (Auto-complete function)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",125,"ü",null,"Common chart of accounts to be used for the ledgers and the sub ledgers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",126,"ü",null,"Account numbers must be alphanumeric ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",127,"ü",null,"Accounts, cost centres and units numbered in a logical manner ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",128,"ü",null,"Account creation cannot occur until the initial transaction posting has taken place. (Transaction batch should not be entered into the relevant GL account until it has been posted. Transactions in a sub ledger must be posted in order to go into GL.) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",129,"ü",null,"Maintain account balances for the previous sixty (60) months: prior, current and next three years. Five years to view and five years reporting. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",130,"ü",null,"Minimum of 200 department and cost centre entities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",131,"ü",null,"Track multiple organisational divisions such as units and cost centres ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",132,"ü",null,"Multilevel hierarchy roll-ups as defined by the authorized user ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",133,"ü",null,"Drag and drop facility to manage account hierarchies. Drill down functions on transactions. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",134,"ü",null,"Specify accounting periods, including monthly, quarterly, and year to date ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",135,"ü",null,"Accounting periods may be designated by calendar or fiscal years ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",136,"ü",null,"Maintain budget accounts for the prior, current and atleast the next three (3) years ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",137,"ü",null,"Maintain history for viewing and reporting (As per regulations)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",138,"ü",null,"Standard chart of accounts that can be automatically copied from one ledger to a new ledger (from one year to the next) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",139,"ü",null,"Divide sub ledger into smaller components for units, cost centres, projects, etc. drill down functions on transactions. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","General Ledger (G/L) ",140,"ü",null,"Allow matching of sub ledger to the control account ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",141,"ü",null,"Automatic Accounts Payable (A/P) entries and maintenance by interfacing with modules and systems.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",142,"ü",null,"Inventory records must be kept up-to-date in this system and must be in sync with another accounting system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",143,"ü",null,"Automatic cash account entries and maintenance by interfacing with modules and systems.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",144,"ü",null,"Facilitate direct journal entry input ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",145,"ü",null,"Real-time journal entries update the daily journal file and balances without delay ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",146,"ü",null,"Facilitate online journal entry input, containing user commentary ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",147,"ü",null,"Facilitate debits and credits having separate columns in the journal voucher entry screen ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",148,"ü",null,"Facility to automatically reverse (providing date of reversal & route for approval) or post recurring journal entries ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",149,"ü",null,"Have comment/reason section for approval of reversal ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",150,"ü",null,"Input journal vouchers available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",151,"ü",null,"Facility to upload bulk (typically from Excel) created journal vouchers directly into the system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",152,"ü",null,"Automatically number journal entries  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",153,"ü",null,"Specify a recurring journal entry as the G/L template for repeating every period ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",154,"ü",null,"Create a journal entry by reversing an existing entry while maintaining an audit trail ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",155,"ü",null,"Real-time comparison of journal entries (individual or batch) for validation and balancing ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",156,"ü",null,"Facility for batch totals and batch checking. Bulk upload into system. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",157,"ü",null,"Facility to spread a single entry over multiple accounts based on predefined user criteria ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",158,"ü",null,"Journal report information covering all journal entries including identification ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",159,"ü",null,"User-assigned security rules restrict entry and query access to specific entities, accounts, or ranges of entities and accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Journals",160,"ü",null,"Ability to allocate, view and change rights to relevant users ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",161,"ü",null,"Financial reporting that complies with generally recognised accounting practice (GRAP)  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",162,"ü",null,"Cash flow statement reporting that complies with GRAP ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",163,"ü",null,"List chart of accounts report ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",164,"ü",null,"Trial balance reports at summary and detail level ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",165,"ü",null,"Report for the profit and loss statement and balance sheet ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",166,"ü",null,"Budget statement comparison reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",167,"ü",null,"Detail and summary level in G/L reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",168,"ü",null,"Customisable financial statement report formats ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",169,"ü",null,"Statutory report on entity accounts, sub-accounts, cost centre and project ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",170,"ü",null,"Facility to write user-defined flexible reports and on-demand reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",171,"ü",null,"Facility to include graphics in reports, including pie charts, histograms and bar charts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",172,"ü",null,"Facility to export data to a third-party report writing tool ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",173,"ü",null,"Function buttons to print, export and PDF. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",174,"ü",null,"Distinction on classification of suppliers,  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting",175,"ü",null,"Facility to export data to spreadsheets",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",176,"ü",null,"Account activity and balances for the current period, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",177,"ü",null,"Account activity and balances for the current year, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",178,"ü",null,"Account balance for the previous year, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",179,"ü",null,"Budgeted amount designated for a project, from ledger, report available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",180,"ü",null,"Online comparison of actuals with budgeted amount ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Online Enquiry Reporting",181,"ü",null,"Standard account enquiry that drills down to the source of the transaction in real time  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",182,"ü",null,"Facility to register vendors",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",183,"ü",null,"Facility to verify registered vendors",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",184,"ü",null,"Facility to automatically convert a requisition into a purchase order",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",185,"ü",null,"Add contract number to PO's (for contract PO's) or allow for contract number to be captured on PO",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",186,"ü",null,"Route PO to End User, Procurement and Vendor once complete",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",187,"ü",null,"Facility to consolidate several Purchase Requisitions (PR) into one PO, but to keep the line items",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",188,"ü",null,"Facility to route POs to approvers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",189,"ü",null,"POs should be reviewed and approved on the system",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",190,"ü",null,"Capture the electronic PO approver's signature",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",191,"ü",null,"Facility to monitor and track POs sent to approvers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",192,"ü",null,"Facility to escalate POs sent to approvers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",193,"ü",null,"Facility to cancel POs",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",194,"ü",null,"Facility to monitor and track POs sent to suppliers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",195,"ü",null,"Assign sequential PO numbers automatically",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",196,"ü",null,"Facility to monitor an estimate of funds committed by the PO once it has been approved",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",197,"ü",null,"Facility to monitor the funds committed by the PO once the PO has been approved ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",198,"ü",null,"Facility to allocate funds committed by the PO to project budgets",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",199,"ü",null,"Individual POs can handle multiple line items",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",200,"ü",null,"Facility to associate subcontracted purchase orders with the project number ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",201,"ü",null,"Allow for the fulfilment of a complete order or portions of an incomplete order",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",202,"ü",null,"PO line item comments may be entered in a user-defined or standard predefined format",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",203,"ü",null,"Facility to set line-item-specific delivery dates",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",204,"ü",null,"Maintain a price and discount table ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",205,"ü",null,"Automatic update of an item's record based on the item's most recent purchase price",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",206,"ü",null,"POs should be generated in any currency",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",207,"ü",null,"Facility to prompt end user to update the PO if the invoice is more than the order with required approval",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",208,"ü",null,"Link credit note to order ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",209,"ü",null,"Facility to add back credit notes on the order value",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",210,"ü",null,"Facility to differentiate between contract POs, normal operational POs and others",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Purchase Orders",211,"ü",null,"Maintain a central supplier database",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",212,"ü",null,"Account activity and balances for the current period, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",213,"ü",null,"Account activity and balances for the current year, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",214,"ü",null,"Account balance for the previous year, available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",215,"ü",null,"Budgeted amount designated for a project from Ledger, report available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",216,"ü",null,"Online comparison of actuals with budgeted amount ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",217,"ü",null,"Standard account enquiry that drills down to the source of the transaction in real time  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",218,"ü",null,"Classification of business types  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",219,"ü",null,"Common supplier database with supply chain ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",220,"ü",null,"Reference to Purchase Orders (PO) placed with suppliers available on database. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",221,"ü",null,"Facility to classify suppliers by business type. Ability to draw age analysis per supplier type. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",222,"ü",null,"Ability to capture all possible supplier details and be able to draw a report selecting one of the criteria.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accounts Payable",223,"ü",null,"There should be approval of all changes in the database. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",224,"ü",null,"Only valid supplier invoices posted to the A/P ledger  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",225,"ü",null,"Facility to pay supplier invoices immediately ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",226,"ü",null,"No new supplier records can be created without supply chain approval ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",227,"ü",null,"Supplier invoices scanned when received if not received electronically ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",228,"ü",null,"Scanned invoice images available online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",229,"ü",null,"Distribute invoices to different accounts within separate units or locations ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",230,"ü",null,"Link invoices to assets register (Fixed Assets - F/A) for purchased assets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",231,"ü",null,"Facility to allocate supplier invoice costs to projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",232,"ü",null,"Facility for paperless matching of POs and proofs of receipt with supplier invoices ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",233,"ü",null,"Facility to make one payment for multiple invoices  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",234,"ü",null,"Facility to link credit notes or cost adjustments to the original invoice and purchase order",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",235,"ü",null,"Maintain invoice details as required per requlations (current year plus four prior years) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",236,"ü",null,"Suspend or put on hold an individual vendor, individual invoice or individual line (A vendor is a supplier that has been successfully been loaded onto our creditors system)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",237,"ü",null,"Route invoices for approval online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",238,"ü",null,"Track the status of an invoice for approval from the recipient of the invoice ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",239,"ü",null,"Provide alerts for outstanding items ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",240,"ü",null,"Facility to apply three-way checking: invoice, PO and receiving document match ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",241,"ü",null,"Invoice batch edits for checking data input prior to update ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",242,"ü",null,"System should be able to give alerts of non-payment of invoice with increments of ten days relative to invoice date. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",243,"ü",null,"Invoice enquiry supporting search by Rand amount, invoice number, supplier number, supplier name or key word or company type, BEEE ranking/ status, Government suppliers, municipalities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",244,"ü",null,"Online access to PO information, receiving document information and credit note information through the A/P system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",245,"ü",null,"Three-way matching must be automatic and accommodate tolerances ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",246,"ü",null,"Ability to pay invoice via P.O  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",247,"ü",null,"Distinctions or classification of suppliers   ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",248,"ü",null,"Tracking of changes within the vendor environment  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",249,"ü",null,"First entry into the database must be approved & any changes thereafter ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",250,"ü",null,"Link of business database with Central Supplier Database (CSD) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Supplier Invoice  Processing",251,"ü",null,"The system should be able to facilitate alerts on bank account changes ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",252,"ü",null,"Verification to prevent a supplier with an open PO or unpaid invoice from being deleted ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",253,"ü",null,"Verification to prevent a supplier active in the current year from being deleted ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",254,"ü",null,"Facility to review items for payment online before releasing payment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",255,"ü",null,"Facility to release payment at vendor level, invoice level or line item ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",256,"ü",null,"Facility to make payments using cheques or electronic funds transfer ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",257,"ü",null,"Automatically calculate discounts according to payment terms ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",258,"ü",null,"Set frequency of recurring payments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",259,"ü",null,"Set recurring payments on weekly, monthly, quarterly, annual, or semi-annual basis ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",260,"ü",null,"Set recurring payments at irregular intervals ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Control of Payments",261,"ü",null,"Online views of the vendors with current unpaid balances ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",262,"ü",null,"Online entry for all A/P transactions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",263,"ü",null,"All A/P transactions updated in real time ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",264,"ü",null,"Online batch total or voucher balances ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",265,"ü",null,"Validate vendor invoices to avoid duplication ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",266,"ü",null,"Correct distribution errors online without having to re-enter or reverse entries and transactions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",267,"ü",null,"All transactions are posted daily to the A/P ledger and are automatically posted to the G/L ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",268,"ü",null,"Report the total value of all transactions that occurred in a specified period to the G/L account ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","A/P Transactions & Controls",269,"ü",null,"Provide a G/L distribution report ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",270,"ü",null,"Provide a fixed assets register that tracks assets throughout their life cycle ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",271,"ü",null,"Track assets by number, description, type, serial number, location, PO, image, invoice or lease or responsible person. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",272,"ü",null,"Track leased assets and intangible assets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",273,"ü",null,"Create unique asset tag numbers by using tag controls ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",274,"ü",null,"Specify the original PO number and vendor ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",275,"ü",null,"Capture asset data such as A/P reference, date of purchase and cost ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",276,"ü",null,"Track the depreciation of an asset throughout its life cycle ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",277,"ü",null,"Allow for online asset transfer administration (i.e Record date of asset transfer etc.)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",278,"ü",null,"Record asset disposal date and value ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",279,"ü",null,"Integrate with the capital budget ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",280,"ü",null,"Online views of fixed assets and transaction records ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",281,"ü",null,"Online asset tracking ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",282,"ü",null,"Generate reports on all leased assets, their details and payment information ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",283,"ü",null,"Record values of asset appraisals and evaluations, additions, adjustments, add-ons and write offs. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",284,"ü",null,"Register should integrate with other modules and should have facility to use scanner. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",285,"ü",null,"Automatically match and clear Asset Control account. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",286,"ü",null,"Transfer asset options (including fully or partially), for the current period or retroactively and mass transfer ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",287,"ü",null,"Generate transaction reports for the period including additions, transfers, disposals and depreciation by asset type and cost centre ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",288,"ü",null,"Automatic end-of-period updates to G/L ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",289,"ü",null,"Update fixed assets from an A/P entry ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",290,"ü",null,"Balance a manually entered fixed asset entry with the entry in the A/P records ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",291,"ü",null,"Update assets register (F/A) records automatically whenever a transfer or disposal is recorded ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",292,"ü",null,"Generate exception reports for F/A and A/P reconciliation ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",293,"ü",null,"Generate reports for all operating lease payments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",294,"ü",null,"Asset Register should be able to print and export in detail or in summary.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Assets Register (F/A)",295,"ü",null,"Distinction between CGS and Project owned Assets. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",296,"ü",null,"Provide an up-to-date cash balance report",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",297,null,"ü","Must project cash resources from aging reports (accounts receivable) (A/R) and miscellaneous cash ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",298,null,"ü","Must project cash utilisation from purchasing, A/P and miscellaneous cash ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",299,"ü",null,"Every transaction that leaves the bank account has to be allocated to any other module and you must be able to give it detail… project number, description, etc.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",300,null,"ü","Check committed funds against cash reserves or availability ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",301,null,"ü","Report cash projections ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",302,"ü",null,"Views of inflows and outflows from cash book ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",303,"ü",null,"Record cash payments and receipts via electronic banking functions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",304,"ü",null,"Notify and report on statement discrepancies ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",305,"ü",null,"Record journal entries to the G/L cash accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",306,"ü",null,"Print account statements ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",307,"ü",null,"Automatically record bank cash receipts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",308,"ü",null,"Ability to reverse rejected payments and receipts. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",309,"ü",null,"Must be able to capture local and foreign values. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",310,"ü",null,"Each bank account should be uniquely identified. All functionalities should be the same across all bank accounts. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",311,"ü",null,"All transactions captured in Cash Book (C/B) should automatically update in A/P, A/R modules. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cash Management",312,"ü",null,"Cash book should have a currency table linked to SA forex and must be able to print out report of transactions received in foreign values. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",313,"ü",null,"Budget control may be defined at any area of the account structure or for any number of levels ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",314,"ü",null,"Establish mandatory budgets for selected balance sheet accounts and profit and loss accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",315,"ü",null,"Income, expense, liability, assets, and equity accounts may be used in the budgeting process ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",316,"ü",null,"Multiple budgets may be created from a single account to create what-if scenarios and for forecasting ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",317,"ü",null,"Annual, quarterly, monthly or customised budget periods ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",318,"ü",null,"Create financial statements in conjunction with budgets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",319,"ü",null,"Budgeting for projects linked to Objectives, Mandate and Strategy. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",320,"ü",null,"Variance report between actual and budget. Must have facility to approve changes. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Control",321,"ü",null,"Pro rata distribution of annual budgets over different periods, including quarterly, monthly or other customised periods ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",322,"ü",null,"Worksheet tools for developing budgets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",323,"ü",null,"Develop budgets from project planning input ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",324,"ü",null,"Develop budgets from demand management projections ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",325,"ü",null,"Generate budget using historical budget and actuals  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",326,"ü",null,"Template to consolidate budget per line item in GL. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",327,"ü",null,"Provide budget report summaries for executive or management review ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",328,null,"ü","Base future costs and revenues on different rates, volumes and user-specified factors ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",329,"ü",null,"View budgets online and interactively. Drill down view of budget per business unit. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",330,"ü",null,"Must have capital budgeting tool. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",331,"ü",null,"Use historical budgets and actuals to automatically project trends ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",332,"ü",null,"Store historical data for a minimum of five years (60) months (As per policy/regulations) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget Development",333,"ü",null,"Generate and update budgets in real time ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",334,"ü",null,"Formatting of budget reports similar to standard financial reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",335,"ü",null,"Formatting of roll-ups and consolidations similar to standard financial reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",336,"ü",null,"Produce a consolidated entity budget  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",337,"ü",null,"Reports may compare last year's actuals or budgetary amounts with current year's actuals ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",338,"ü",null,"Enable download of the file from the system to create a spreadsheet version of the file for manipulation and editing by other users, then upload the altered file to the system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Budget reports",339,"ü",null,"Maintain budget and forecast comparative data in the G/L and sub ledgers for viewing and reporting on balance sheet accounts and income statement accounts",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",340,"ü",null,"Accept online manual entry of invoices, receipts and adjustments with G/L accounts and effective dates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",341,"ü",null,"Accept debit memo and credit memo transactions as adjustments to the customer accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",342,"ü",null,"Identify each transaction via a reference number  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",343,"ü",null,"Invoice, cash receipts or adjustment transactions may be entered in batches ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",344,"ü",null,"Reject or suspend batches not balancing on either item or Rand totals ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Accounts Receivable (A/R)",345,"ü",null,"Invoice, cash receipt or adjustment transactions may be entered directly, by-passing batch entry requirements ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",346,"ü",null,"Create flexible customer invoices based on online input from units ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",347,"ü",null,"Allow either open item or balance forward processing of receivables ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",348,"ü",null,"Facility to compute late payment interest linked to legislation for customers not paying within a defined time period ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",349,"ü",null,"Provide a purge process that moves A/R master file records to a history file ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",350,"ü",null,"Consolidate multiple-location customer billings into a single open item ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",351,"ü",null,"Automatically balance the A/R master file and check the total file balance against the accounts in the G/L master file ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",352,"ü",null,"The A/R master file should automatically internally balance individual open item A/R records against corresponding account balances in the customer master file and report exceptions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",353,"ü",null,"Track advance payments and post them to A/R when a sale has been finalised ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",354,"ü",null,"Provide automated numbering of customers with user-defined sorting and sequencing capabilities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",355,"ü",null,"Maintain a central customer database ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Processing Requirements",356,"ü",null,"Automatically prepare detailed G/L journal entries  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",357,"ü",null,"Upon request, print and export a batch listing, showing every item in a particular batch ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",358,"ü",null,"Statutory, regulatory or adhoc"]
["Financial Management","Reporting Requirements",359,"ü",null,"Produce an A/R journal that lists all activity posted to the A/R master file, and sort report line items either by batch and line number or by customer number ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",360,"ü",null,"Age the receivables according to user-definable time buckets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",361,"ü",null,"Age receivables either according to invoice date or to due date ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",362,"ü",null,"A/R ageing report makes provision for a line item for each invoice posted to the A/R master file ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",363,"ü",null,"Create A/Rs ageing report with one-line item per customer ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",364,"ü",null,"Balance forward system produces a period end A/R trial balance showing the open period balance for each account, with each posting activity and closing balance. (Detailed age analysis) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",365,"ü",null,"Provide an A/R exception report  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",366,"ü",null,"Provide a customer contact listing, showing name, phone number and other contact information by customer,(local, foreign, project related) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",367,"ü",null,"Create a management summary or a key indicator report containing a summary of A/R activity ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",368,"ü",null,"Forecast cash receipts based on the historical payment patterns of customer accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",369,"ü",null,"Print customer statements showing detailed activity and net amount due for the period ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",370,"ü",null,"Provide a complete listing of the customer master file, which shows each data element in every record ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",371,"ü",null,"Print or email outstanding payment letters  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Reporting Requirements",372,"ü",null,"Generate forms for required SARS reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",373,"ü",null,"Integrate with the project planning, project management and Time recording module. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",374,"ü",null,"Provide for user definition of project or cost code segments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",375,"ü",null,"Provide user-defined number of actual, commitment and budget for each level of the account structure ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",376,"ü",null,"Define summary accounts in a multilevel hierarchy ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",377,"ü",null,"Free-form notes or text comments may be posted at any level of the structure, with optional notes history, notes notification and notes displayed at summary details ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",378,"ü",null,"Provide cut, copy and paste of coding structure elements between projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",379,"ü",null,"User-defined subproject coding may be applied at any level of the regular cost coding structure to provide a unique breakdown of costs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",380,"ü",null,"Provide an option to budget or commit project expenditures by periods ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",381,"ü",null,"Provide a facility to handle multicurrency ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",382,"ü",null,"Provide Reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Project Accounting - Project and cost coding structure",383,"ü",null,"Must be linked to A/P and A/R ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",384,"ü",null,"A project may be created from a default table containing different project templates containing definitions and separate coding structures. Must have project creation module. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",385,"ü",null,"An existing project structure may be duplicated with no data being transferred ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",386,"ü",null,"A new project type may be created by creating a new task sequence and assigning a cost code structure ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",387,"ü",null,"Support for multiyear projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",388,"ü",null,"Permit multiple phase project definitions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management"," Project Creation",389,"ü",null,"Projects must link to cost centres, unit managers, thrust cost, payroll, HR.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cost Coding Structure Creation & Maintenance",390,"ü",null,"Cost codes may be added to the structure without affecting existing projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cost Coding Structure Creation & Maintenance",391,"ü",null,"Cost codes to G/L account conversion is maintained in an online table ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cost Coding Structure Creation & Maintenance",392,"ü",null,"Use the same accounting calendars as the G/L ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cost Coding Structure Creation & Maintenance",393,"ü",null,"Cost records to integrate with project planning and the project portfolio. Must also integrate with objectives, mandate and strategy  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Cost Coding Structure Creation & Maintenance",394,"ü",null,"Distribution to unlimited project and cost codes accounts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",395,"ü",null,"Running total showing the total debits and credits as they are being entered ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",396,"ü",null,"Automatic creation of G/L transactions with appropriate debit or credit offsets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",397,"ü",null,"Support a posting interface which permits simultaneous updates of the general and cost ledgers when financial transactions are posted to either ledger ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",398,"ü",null,"Report on actual and committed funds versus budget in monthly buckets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",399,"ü",null,"Use the cost coding structure to allow online drill-downs from summary to detail ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",400,"ü",null,"Provide a cost allocation adjustment facility limited to authorised users ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",401,"ü",null,"Provide a tool with spreadsheet interface for flexible project and inter-project reporting  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Transaction Processing",402,"ü",null,"Ability to provide decentralised capability for web-based time sheet entry ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",403,"ü",null,"Timesheets must be electronic, and available on devices / platforms e.g. tablets, mobile phones ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",404,"ü",null,"Import project timesheet data from project execution and control ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",405,"ü",null,"Link / allign from online time sheets or standard time tracking system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",406,"ü",null,"Enter time against activity data relating to the financial year",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",407,"ü",null,"Timesheet compliance report to be provided",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",408,"ü",null,"Facility to view resource allocation and import resource information and generate report. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",409,"ü",null,"Variance report on budgeted and actual hours. Any changes to budgets should follow the approval process.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",410,"ü",null,"Process flow in terms of approval for timesheets. There must be escalation ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",411,"ü",null,"Reminders / escalations to complete and approve timesheets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",412,"ü",null,"Facility to limit hours claimed. User must not be able to capture more hours than allocated to the project. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",413,"ü",null,"Online timesheets must automatically link into the financial system",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",414,"ü",null,"The system must accommodate correction for errors and filters  through to the financial system for entries approved / prosted ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",415,"ü",null,"There must be control on holidays, weekends, overtime, project and admin activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Time recording",416,"ü",null,"Options - date ranges available for Rate Changes, Approvers & Department",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",417,"ü",null,"Export data to project execution and control ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",418,"ü",null,"Import or export to A/P systems ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",419,"ü",null,"Provide for manually entering expenses against activity data ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",420,"ü",null,"Ensure data integrity if, in addition to manual data entry, imports of data are performed ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",421,"ü",null,"Facility for standard reports ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Expense Tracking",422,"ü",null,"Create customisable reports for the installed environment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Advance",423,"ü",null,"Facility for requester to complete Subsistence and Travel Advance Form on the system",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Advance",424,"ü",null,"Travel options foreign or domestic",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Advance",425,"ü",null,"Requesters names must be linked to their employee numbers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Advance",426,"ü",null,"Employee number must be automatically populated after employee name is entered",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim",427,"ü",null,"Field to complete name and automated population of employee details (Employee number, advance number, department, claim number, etc.)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",428,"ü",null,"Facility to attachment of supporting documents (i.e. log book, approved motivations)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",429,"ü",null,"Facility  to enter trip details: Trip date (calendar selection), project number, cost centre,",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",430,"ü",null,"Vehicle information includes: Make, Model, engine capacity, Kilometres travelled based on log book entry, tariff rate based on type of vehicle",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",431,"ü",null,"Allow upload of monthly tariff list received from Department of Transport",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",432,null,"ü","Allow finance to share the DMS number for the tariff list with all employees ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",433,"ü",null,"Facility to attachment of supporting documents (i.e. log book, approved motivations)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",434,"ü",null,"The ability to block payment release if requester is still owing from normal S&T ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Travel & Substistence - Claim for official KM travelled",435,"ü",null,"Be able to generate a report for a required period",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Domestic travel",436,"ü",null,"The system should allow for the capturing of trip details (Location, Duration, Banking Details, Justification, Rate Options and Allowance)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Domestic travel",437,null,"ü","The system should provide approval workflow as defined by the CGS policy",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Domestic travel",438,"ü",null,"Link all employees to their Advance Account number",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Domestic travel",439,"ü",null,"Rejections or errors identified by verifier should be returned to reviewer & errors identified by verifier should be returned to the verifier until resolved ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Foreign travel",440,"ü",null,"The system should provide Foreign rate (as per the SARS rates depends on the country being visited) for daily allowance and accommodation, based on period average",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Foreign travel",441,"ü",null,"Provide a table with daily currency rate in the system to get a view of the period average",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Daily allowance claim",442,"ü",null,"Allow for the capturing of claims including the description, type, project number, cost centre, category, GL number, duration etc.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Daily allowance claim",443,"ü",null,"Automated calculation and population of the quantity based on requirement above (From and to dates and time claimed)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Daily allowance claim",444,"ü",null,"Rate options for selection (subject to change as per National Treasury rates)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Daily allowance claim",445,"ü",null,"Generate amount including VAT",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accommodation Claim",446,"ü",null,"Automated population/generation of GL number that is linked to the category",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accommodation Claim",447,"ü",null,"Duration selection - From (date and time) and to (date and time) selection on a calendar ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","Accommodation Claim",448,"ü",null,"Automated calculation and population of the quantity based on requirement above (From and to dates and time claimed)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","All other expenses",449,"ü",null,"The ability to capture expenses details and descriptions",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Financial Management","All other expenses",450,"ü",null,"If amount owed to council, an email by verifier should sent to the requester with banking details or option to have it deducted from his/her salary (25%)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",451,"ü",null,"The system should have the facility to undertake and record needs assessments ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",452,"ü",null,"The system should have the facility to prepare and record product and service specifications ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",453,"ü",null,"The system should provide access to CAPEX and OPEX budgets  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",454,"ü",null,"The system should have the facility to calculate total cost of procurement",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",455,"ü",null,"The system should have the facility to source suppliers and match their capabilities to a set of criteria  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",456,"ü",null,"The system should have a central supplier database with data mining capabilities  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",457,"ü",null,"The system should cater for central product and service database ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",458,"ü",null,"The system should have a facility to classify products and services (Catalogue)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",459,null,"ü","The system should have a facility to store email and fax communications with suppliers in supplier database ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",460,"ü",null,"The system should have a facility to associate product and service specifications with specific suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",461,"ü",null,"The procurement manager should be able to assign SCM team (individuals) for procurement as per the demand plan ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",462,"ü",null,"View of the consolidated demand plan on the system as well as  a breakdown per unit ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",463,null,"ü","The system should have the ability to set a primary supplier for each product or service class ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",464,"ü",null,"The system must prompt business units (end users) to initiate procurement as per demand plan ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Demand Management ",465,"ü",null,"If procurement is not initiated after two reminders, escalation takes place at 3 levels: Manager, Executive, CEO",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Supplier Contracts and Agreements ",466,"ü",null,"The system should be able to manage suppliers’ qualifying documents validity to avoid frustration when a supplier is selected then it turns out that the tax certificate is not up to date.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",467,"ü",null,"Supply Chain Management should be able to upload a notice and/or invitation to tender.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",468,"ü",null,"Updates and queries should be exchanged through the system during the tender period.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",469,"ü",null,"The business (SCM) should be able to access the tenders only after the process closes.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",470,"ü",null,"All tender-related information should be held in a central database, which should be easily searchable and fully audited, with all activities recorded. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",471,"ü",null,"Tender documents must be read or submitted only by authorised parties ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",472,"ü",null,"Users of the system should to be properly identified and registered via controlled access ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",473,"ü",null,"Each tenderer is to be a registered system member — registered in a central database.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",474,"ü",null,"Data is to be encrypted and users authenticated by means such as digital signatures or electronic certificates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",475,"ü",null,"Users are to have a unique username and password to confirm their eligibility to use the system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",476,"ü",null,"The system should ensure that only ‘monitored’ or ‘authorised’ alterations can be made to any tender.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",477,"ü",null,"The tenderer should be able to amend the bid online at any stage up to tender close",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",478,"ü",null,"The tenderer should be able to amend through the correct approval levels",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","E-Procurement (Tender Process) ",479,"ü",null,"The system must be able to calculate the 80/20 and 90/10 (Price and BBBEE points) -  Note: Procurement will be done in line with PFMA regulations",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",480,"ü",null,"The system should have a facility to identify approved suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",481,"ü",null,"The system must maintain a database of service providers  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",482,"ü",null,"The system must have back-up procedures for e-Tender documents. Routine archiving should take place regularly (as required by legislation). ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",483,"ü",null,"The system should have capture fields for supplier data such as shipping methods, item references and conditions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",484,"ü",null,"The system must allow for the uploading of supplier supporting documents ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",485,"ü",null,"The system should have the ability to capture more than one address where suppliers may have more than one address ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",486,"ü",null,"The system should be able to store e-mail addresses, web sites, and fax numbers in vendor profiles ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",487,"ü",null,"The system should be able associate items with vendors’ descriptions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",488,"ü",null,"The system should provide bill-to-entity information including currency, bank, account number, and mode of payment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",489,null,"ü","The system should be able to cater for data related to bank, accounts, payment methods, currency, etc., are included in the payment profile ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Profiling ",490,"ü",null,"The system should be able to cater for vendor group for miscellaneous purposes ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",491,"ü",null,"The system should be able to hold commentary about suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",492,"ü",null,"The system should archive previously used suppliers and their details  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",493,"ü",null,"The system should maintain a record of historical and year-to-date purchases in rand and foreign currency by supplier ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",494,"ü",null,"The system should provide goods and service delivery times and performance maintained as statistics for each supplier ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",495,"ü",null,"The system should enable supplier purchase order fulfilment performance maintained as statistics for each supplier ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",496,"ü",null,"The system should provide a facility to maintain suppliers’ quality ratings  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",497,"ü",null,"The system should provide historical tracking of supplier performance criteria  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Performance",498,"ü",null,"The system should provide a three-year history of statistical performance data ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",499,"ü",null,"The system should support the RFQ process",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",500,"ü",null,"For all items that are numbered, the system should generate sequential numbering"]
["Supply Chain Management","Request for Quotation (RFQ) ",501,"ü",null,"The system should allow creation of requests for quotation (RFQs) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",502,"ü",null,"The system should have the facility to notify RFQs to potential suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",503,"ü",null,"The system should have the facility to publish RFQs on the CGS Website ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",504,"ü",null,"The system should have the facility to monitor and track RFQs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",505,"ü",null,"The system should have the facility to associate quotations with PRs  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",506,"ü",null,"The system should have the facility to route quotations together with PRs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",507,"ü",null,"The system should have the facility to intergrate with the Central Supplier Database (CSD)  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",508,"ü",null,"The system should have the facility to select suppliers on specific products and services from the Central Supplier Database  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",509,"ü",null,"The system must be able to calculate the 80/20 and 90/10 (Price and BBBEE Points)  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Request for Quotation (RFQ) ",510,"ü",null,"The system must generate an RFQ report of the process undertaken",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",511,"ü",null,"The system should provide automatic updating and reporting of supplier rating statistics  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",512,"ü",null,"The system should provide multiple search criteria for supplier data ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",513,"ü",null,"The system should allow online creation of purchase requisitions (PR) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",514,"ü",null,"The system should automatically identify approvers by role, unit and location ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",515,"ü",null,"The system should identify approvers in as per the delegations of authority",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",516,"ü",null,"The system should provide for user-defined, configurable routing or approval process workflow ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",517,"ü",null,"The system should provide a facility to monitor and track PRs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",518,"ü",null,"The system should provide a facility to escalate PRs automatically ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",519,"ü",null,"The system should allow PRs to be reviewed, approved, modified or declined online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",520,"ü",null,"If the PR is declined, the system should advise the requisitioner of the reasons for it being declined ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",521,"ü",null,"The system should provide the approver with a real-time interface with the budget for the requisitioned item ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",522,"ü",null,"The system should provide the approver with a running total of budget remaining  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",523,"ü",null,"The system should have PRs that allow multiple line items and delivery schedules ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",524,"ü",null,"The system should capture the electronic approver’s signature ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase requisitions (PRs) and quotations ",525,"ü",null,"The system should allow PRs to be referenced to project, GL account and contract/SLA",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",526,"ü",null,"The system should allow for calculation of PR estimates by searching price tables before quotations are received ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",527,"ü",null,"The system should have the facility to monitor an estimate of funds committed by the PR once it has been created  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",528,"ü",null,"The system should have the facility to allocate funds committed by the PR to projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",529,"ü",null,"The system should have the facility to automatically convert a requisition into a purchase order ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",530,"ü",null,"The system should have the facility to consolidate several PRs into one PO, but to keep the line items ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",531,"ü",null,"The system should have the ability to show details of the PRs from which the PO was created ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",532,"ü",null,"The system should have the facility to route Pos to approvers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",533,"ü",null,"The system should allow for Pos to be reviewed and approved online ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",534,"ü",null,"The system should capture the electronic PO approver’s signature ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",535,"ü",null,"The system should have the facility to monitor and track Pos sent to approvers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",536,"ü",null,"The system should have the facility to escalate Pos sent to approvers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",537,"ü",null,"The system should have facility to cancel Pos ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",538,"ü",null,"The system should have the facility to route Pos to potential suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",539,"ü",null,"The system should have the facility to monitor and track Pos sent to suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",540,"ü",null,"The system should have the facility to expedite Pos sent to suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",541,"ü",null,"The system should have an alternative facility to manually enter and send purchase order ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",542,"ü",null,"The system should enable the assigning of sequential PO numbers automatically ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",543,"ü",null,"The system should have the facility to create blanket or contract Pos ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",544,"ü",null,"The system should have the facility to monitor an estimate of funds committed by the PO once it has been approved ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",545,"ü",null,"The system should have the facility to automatically release funds committed by a PR once the PO is approved  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",546,"ü",null,"The system should have the facility to monitor the funds committed by the PO once the PO has been approved  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",547,"ü",null,"The system should have the facility to allocate funds committed by the PO to project budgets ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",548,"ü",null,"The system should allow for individual Pos that can handle multiple line items ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",549,"ü",null,"The system should have a product and service database that can relate the supplier reference to the internal reference ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",550,"ü",null,"The system should allow for the fulfilment of a complete order or portions of an incomplete order ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",551,"ü",null,"The system should allow for PO line item comments to be entered in a user-defined or standard predefined format ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",552,"ü",null,"The system should have the facility to set line-item-specific delivery dates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",553,"ü",null,"The system should ensure that price and discount table corresponds to individual suppliers and items are maintained ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",554,"ü",null,"The system should enable automatic update of an item’s record based on the item’s most recent purchase price ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Purchase Orders (Pos) ",555,"ü",null,"The system should the facility to retain PR history ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",556,"ü",null,"The system should enable Pos to be generated in any currency ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",557,"ü",null,"The system should have the facility to add back credit notes on the order value ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",558,"ü",null,"The system should have the facility to differentiate between contract Pos, normal operational Pos and others ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",559,"ü",null,"The system should have the facility to record and maintain suppliers’ contracts and agreements in a central database ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",560,"ü",null,"The system should be able to relate suppliers’ contracts and agreements to the record of suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",561,"ü",null,"The system should be able to record the effective (start and expiry) contract dates  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",562,"ü",null,"The system should be able to send alerts when a contract is approaching its expiry date ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",563,"ü",null,"The system should have a facility to store supplier terms and conditions in the supplier record ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",564,"ü",null,"The system must be able to keep record of contract payments against purchase orders",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",565,"ü",null,"The system should have the facility to send an acknowledgement and a copy of the signed contract to the supplier ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",566,"ü",null,"The system should handle contract approval using document management and electronic signatures ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",567,"ü",null,"The system should have standard documentation types for contracts ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Supplier Contracts and Agreements ",568,"ü",null,"The system should have the controls to report on agreement conditions\ne.g monitoring/management of performance  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",569,"ü",null,"The system should do inventory records interface increments on-hand quantity when a PO is received ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",570,"ü",null,"The system should do inventory records interface decreases on-order quantity  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",571,"ü",null,"End users should sign off or accept receipt of goods ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",572,"ü",null,"The system should be able  reporting on open PO by supplier, item number, due date or rand value ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",573,"ü",null,"The system should enable generation of past due reports by supplier or item number in due date sequence ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",574,"ü",null,"The system should be able to send automatic reminder for overdue order to suppliers via fax or email ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",575,"ü",null,"The system should enable reporting on vendor performance by criterion  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",576,"ü",null,"The system should support on-demand printing of the results of an enquiry ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",577,"ü",null,"The system should allow all reports to be previewed on screen prior to printing ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",578,"ü",null,"The system should allow data to be exported to standard reporting packages ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Reporting for Supply Chain Management ",579,"ü",null,"Report number of orders to CSD as required (i.e. supplier rating, number of orders etc.)  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",580,"ü",null,"The system should enable reporting on purchasing management performance ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",581,"ü",null,"The system must be able to run automated material requirements material to cater for returns to stores ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",582,"ü",null,"Should support reporting throughout the procurement process, on progress on demands ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",583,"ü",null,"The system must be able to automate goods receipts processes ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",584,"ü",null,"The system must accommodate the coding and tagging of goods in stores ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",585,"ü",null,"The system must be able to cater for returns to stores ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",586,"ü",null,"The system must be able to cater for returns from suppliers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",587,"ü",null,"The system must have stock counting and stock tracking (including Work In Progress) capabilities ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",588,"ü",null,"The system must be able to attach product pictures and descriptions to new stock items. The system must be able to cater for links to the drawings maintained by the Drawings document management system ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",589,"ü",null,"The system must be able to carter for stock levels visibility  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",590,"ü",null,"The system must be able to transfer of stock from one store to another and to secondary locations ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",591,"ü",null,"The system must be able to handle recurring orders  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",592,"ü",null,"The system must be able to create and manage multiple bins/locations/delivery points ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",593,"ü",null,"The system must have the ability to attach supporting documents (invoices, delivery notes, material data sheets).  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",594,"ü",null,"The system must have warehousing capabilities (e.g. what stock is in the warehouse and on which location in the warehouse) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",595,"ü",null,"The system must have warehousing configuration capabilities, incorporating Safety Standards ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",596,"ü",null,"The system must be able to cater for revaluating of stock item costs ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",597,"ü",null,"The system must be able to integrate between scrap sales (for disposing of assets), procurement, and inventory ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",598,"ü",null,"The system must be able to do stock reservations for projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",599,"ü",null,"The system must be able to categorise and catalogue stock in order to filter stock information when searching on the system (i.e. Electrical/ consumable) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",600,"ü",null,"The system must be able to report inventory visibility across departments at management level for record keeping ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",601,"ü",null,"The system must be able to cater for all types of stock losses (shrinkages, handling losses, leakages, etc.) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",602,"ü",null,"The system must be able to assign priority levels to stock items. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",603,"ü",null,"The system must be able to support functional location priority. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",604,"ü",null,"The system must be able to identify stock that cannot be substituted ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",605,"ü",null,"The system must be able to maintain the history of stock purchased and from which supplier for tracking of supplier performance and for cost history and price analysis ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",606,"ü",null,"The system needs to be able to identify where a stock item is used ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",607,"ü",null,"The system needs to be able to interface with maintenance planning so stock items are confirmed available before maintenance is rolled out ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",608,"ü",null,"The system must be able to allow stock items to be grouped by supplier. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",609,"ü",null,"System must be record purchases in different categories (i.e. capital, stock and projects etc.) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",610,"ü",null,"The system must track contract amendments/variations when requirements increase ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",611,"ü",null,"The system must interface with CSD for real-time alignment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Material Requirements Planning",612,"ü",null,"Should enable/accommodate internet -find for suppliers that are not in CSD ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",613,"ü",null,"The system should maintain PO history information by item ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",614,"ü",null,"The system should allow authorised users to access Pos and related documents from any work station ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",615,"ü",null,"The system should enable online Pos for goods and services receiving  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",616,"ü",null,"The system should allow for the creation of a receipt based on the order content ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",617,"ü",null,"The system should automatically number receipts in sequence ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",618,"ü",null,"The system should automatically update inventory data for physical goods ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",619,"ü",null,"The system should have a facility for users to log on and report on rejected goods in real time ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",620,"ü",null,"The system should issue a partial delivery note when the quantity of the packing slip differs from the numbers on the receipt ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",621,"ü",null,"The system should be able to issue shipping and credit documents to suppliers for returns ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Supply Chain Management","Receipt of Goods ",622,"ü",null,"The system should be able to update PO when goods are received ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",623,"ü",null,"The system must be able to provide project portfolio management capability",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",624,"ü",null,"Enable the management of the entire life cycle of projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",625,"ü",null,"Provide cross-portfolio information to provide overarching management",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",626,"ü",null,"Manage an unlimited number of projects within an organisation",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",627,"ü",null,"Create, delete and view projects in a project portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",628,"ü",null,"Schedule across projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",629,"ü",null,"Prioritise the projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",630,"ü",null,"Assign resources across projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",631,"ü",null,"Provide the ability to manage risk across projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",632,"ü",null,"Provide the ability to develop and monitor budgets across projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",633,"ü",null,"Enable subproject nesting ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",634,"ü",null,"Provide the ability to assign users to several projects in the portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",635,"ü",null,"Provide the ability to assign different user access rights, depending on the project",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",636,"ü",null,"Provide high-level summary views for project managers, financial managers and executives",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",637,"ü",null,"Ability to tailor a personal view of a project analysis area",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",638,"ü",null,"Provide wizard-based cross-project on-demand reporting",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",639,"ü",null,"Provide the ability to review and manage the progress of a portfolio of projects",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",640,"ü",null,"Provide the real-time status of projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",641,"ü",null,"Provide customisable performance measurement across projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",642,"ü",null,"Provide support for graphical portfolios views",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",643,"ü",null,"Provide the ability to publish portfolio views to dashboards",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",644,"ü",null,"Provide customisable inter-project links",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",645,"ü",null,"Provide dependency links between projects in a portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",646,"ü",null,"Provide metrics and cost calculations that include or exclude dependencies",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",647,"ü",null,"Perform a \"what if\" analysis across projects in the portfolio",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Portfolio Management",648,"ü",null,"Provide a central database for the storage of historical project data with data mining capability",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project initiation",649,"ü",null,"Provide the ability to prepare project estimates",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project initiation",650,"ü",null,"Provide the ability to prepare project feasibility studies",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project initiation",651,"ü",null,"Store and provide access to the project description, charter and related documents",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project initiation",652,"ü",null,"Provide a facility to obtain project approval electronically",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",653,"ü",null,"Provide a facility to create high-level and detailed project plans",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",654,"ü",null,"The system should provide the ability for project governance",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",655,"ü",null,"Facilitate the development of project plans using editable templates",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",656,"ü",null,"Facilitate the development of multilevel work breakdown structure(s) (WBS)",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",657,"ü",null,"Provide for hierarchical WBS numbering",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",658,"ü",null,"Provide for drag and drop WBS editing ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",659,"ü",null,"Provide a facility to create, add and delete activities in a project with relevant approvals",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",660,"ü",null,"Provide a facility to link activities and create a project schedule",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",661,"ü",null,"Include finish-to-start, finish-to-finish and start-to-start links with leads and lags",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",662,"ü",null,"Provide a facility to apply project constraints to project plans",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",663,"ü",null,"Number activities in the schedule according to the WBS numbering ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",664,"ü",null,"Associate activities with required deliverables",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",665,"ü",null,"Provide for the addition of comments at the activity level",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",666,"ü",null,"Provide for the prioritisation of activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",667,"ü",null,"Provide the ability to link multiple documents to projects and activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",668,"ü",null,"Provide the ability to assign resources at activity level ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",669,"ü",null,"Access to human resource profiles for effective resource allocation",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",670,"ü",null,"Provide the ability to share resources across activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",671,"ü",null,"Graphically display the project schedule using a Gantt chart and project network diagram ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",672,"ü",null,"Graphically display the resource allocation using a resource graph",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",673,"ü",null,"Calculate and display the critical path of the project",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",674,"ü",null,"Provide manual and automatic resource levelling",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",675,"ü",null,"Provide for interactive planning and scheduling",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",676,"ü",null,"Track the complete past history of the project plan",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",677,"ü",null,"Provide for customisable project calendars",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",678,"ü",null,"Provide a facility to maintain rates per project with rate history",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",679,"ü",null,"Automatically calculate a project budget",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",680,"ü",null,"Provide a facility for project plan revision control",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",681,"ü",null,"Provide the ability to link and integrate multiple project plans",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project planning",682,"ü",null,"Integrate with the project portfolio management facility",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",683,"ü",null,"Provide a facility to track and monitor projects in real time ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",684,"ü",null,"Provide summary and detailed on-demand project status reports",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",685,"ü",null,"Provide custom views of project status",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",686,"ü",null,"Provide status update notifications to project managers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",687,"ü",null,"Provide drilled-down project financial analysis",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",688,"ü",null,"Provide a facility to notify users of required action via electronic messaging ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",689,"ü",null,"Provide a facility for the online recording of time spent on project activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",690,"ü",null,"Assign time recorded on timesheets to project activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",691,"ü",null,"Automatically assign project activity times to project budgets and cost records",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",692,"ü",null,"Assign costs and expenses to project activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",693,"ü",null,"Automatically assign project activity costs and expenses to project budgets and cost records",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",694,"ü",null,"Provide for automatic or manual rescheduling of activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",695,"ü",null,"Provide for the reprioritisation of activities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",696,"ü",null,"Report on actual hours worked, cross-referenced with the users’ timesheets",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",697,"ü",null,"Provide earned value management reports to track and control project progress and cost ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",698,"ü",null,"Automatically identify approvers and reviewers by unit, location or site",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",699,"ü",null,"Manually identify approvers and reviewers",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",700,"ü",null,"Provide a facility to route objects to appropriate parties for sign-off",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",701,"ü",null,"User-defined, configurable routing or approval process workflow",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project execution and control",702,"ü",null,"Capture electronic sign-off and reviewer signature",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Closure",703,"ü",null,"Provide a facility to create a list of formal project completion criteria",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Closure",704,"ü",null,"Maintain a list of all outstanding tasks and issues",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Closure",705,"ü",null,"Prompt the completion of a lessons learnt report ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Closure",706,"ü",null,"Archive documentation of achievements and lessons learned ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Closure",707,"ü",null,"Record approval of completion criteria",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Risk Management",708,"ü",null,"The system should provide a central register for the management of risks ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Risk Management",709,"ü",null,"Provide a central register for the management of risks",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Risk Management",710,"ü",null,"Provide a facility to create custom risk factors ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Risk Management",711,"ü",null,"Provide a facility to assess the risk factors for each project",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",712,"ü",null,"Projects must be linked to the strategic plan ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",713,"ü",null,"There should be standard project reporting templates for the council ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",714,"ü",null,"Organisation wide view of all projects taking place (being carried out) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",715,"ü",null,"Provide a view (dashboard) of all resource commitment to avoid over commitment of resources to projects ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",716,"ü",null,"End of project must prompt the completion of a lessons learnt report ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",717,"ü",null,"The project plan should allow tracking of project budget ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",718,"ü",null,"Project plans should provide an overall view of project progress, resourcing, budget, facilities  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Geological Resources & Applied Geoscience","Project Management",719,"ü",null,"Should allow for different levels of approval for timesheet (i.e. Project manager, Unit manager) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",720,"ü",null,"Cater for asset maintanance.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",721,"ü",null,"The system must carry a service history record for each asset. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",722,"ü",null,"The system must be able to generate a reminder of service due to allow the maintenance team to order or purchase service spares before the service due date. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",723,"ü",null,"The system must be capable of capturing tasks, preventative measures, service related instructions and strategy for generating decision making information. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",724,"ü",null,"The system must be able to allow approval of requests electronically ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",725,"ü",null,"The system must be able to capture supporting documentation for requisitions submitted. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",726,"ü",null,"The record of work done in any branch must be available both in that branch and at the head office.   ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",727,"ü",null,"The system must have workflow capabilities",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",728,"ü",null,"The system must have incident tracking capabilities for reporting purposes. The system must be able to track traffic violations per individual and allow the transport department to escalate violations accordingly.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",729,"ü",null,"The system must be able to integrate with other systems used in transport management. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",730,"ü",null,"The system must have an automated form for booking vehicles with a dropdown menu. People must be able to check availability of requested vehicles on the calendar. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",731,"ü",null,"All vehicles at head office or regional offices must be visible to the fleet manager. Vehicles are not allocated to units, they are operated from one pool. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",732,"ü",null,"For booking purposes, the user must be able to view all vehicles on the calendar and the availability of required vehicle. If the vehicle is available, the user can submit an electronic booking form for the vehicle with required dates. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",733,"ü",null,"Approval will be done on line and if the specified vehicle cannot be approved for the desired dates, changes or swaps can only be done by the fleet manager, not the booking person.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",734,"ü",null,"Approved booking must appear on the calendar for the benefit of other users. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",735,"ü",null,"When a vehicle is returned, once the closing mileage is captured, the vehicle can appear as available for booking. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",736,"ü",null,"The form must have the user’s contact number in case the tracking company needs to verify the safety of the driver and the vehicle at any given time. If more than one driver is using the vehicle, all drivers’ names must appear on the form. This also helps in allocating traffic fines where they occur. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",737,"ü",null,"The form must indicate the opening mileage on the vehicle and the closing mileage must be captured on returning the vehicle. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",738,"ü",null,"The system should have a process that is complete up to the return of the vehicle. Users must know and adhere to the return procedure. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",739,"ü",null,"Vehicle activity reports must be submitted to finance by the 19th of each month. Vehicles booked for longer periods submit mileage at the time of report.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",740,"ü",null,"The system must be designed to facilitate rental procedures, authorisation and claims where individuals have to use their personal vehicles.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",741,"ü",null,"The system must make it easy for the transport manager to know who has what vehicle at any given time.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",742,"ü",null,"The system must have a record of overnight approval for any vehicle if the vehicle will not be returned on the same day, for insurance purposes. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",743,"ü",null,"The system must have a breakdown handling process. The driver should be able to log a call on the system.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",744,"ü",null,"The system should assist with traffic fine notifications received from traffic department in allocating fines to the responsible people so that Finance and HR can then effect deductions of the costs.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",745,"ü",null,"The system should have centralised planning and scheduling to allow all users to see the availability or non-availability of equipment to help match their requirements to unscheduled time frames. Benefits of planning how best to move equipment around will also be realised. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",746,"ü",null,"For Drilling operations, the system must have an electronic request form which must link to an availability calendar for all users to see for their project planning purposes. The system should provide a dashboard view of the current status. That can help shift resources around and highlight what equipment is due or even overdue. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",747,"ü",null,"The system must be able to record adhoc requests that come from top management and have a way of eating into time for scheduled work but the balance score card cannot reflect or account for that time. There must be record evidence of the impact on staff and service delivery. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",748,"ü",null,"Create capacity assessment of fleet capabilities (vehicles captured with all details from date of purchase, prescribed scheduled service intervals must be loaded) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",749,"ü",null,"Fleet management needs to integrate with Asset Management",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",750,"ü",null,"Assess search requirements based on long-term demand analysis",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",751,"ü",null,"Automate booking of vehicles. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",752,"ü",null,"Fleet maintenance (the system should automatically update scheduled services at prescribed intervals) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",753,"ü",null,"Fleet cost management (proper record keeping for all financial aspects on vehicles should be recorded and kept as maintenance records). Reconciliation facilities should be provided ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",754,"ü",null,"Link/integration with Netfleet",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",755,"ü",null,"Link/integration with Netstar",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",756,"ü",null,"The system must be able to maintain and generate service history and monthly statement for each vehicle. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",757,"ü",null,"The system must also be able to generate a report on any user for a defined period",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",758,"ü",null,"If a booked vehicle is not collected at the appointed time, the system must send a reminder to the user and a notification to the fleet manager. Cancellation of booking must automatically be done after 24 hours.  ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",759,"ü",null,"The system must generate reminders for  licence disc renewals",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",760,"ü",null,"If a vehicle is beyond economic repair, the file must be closed and the vehicle will be taken off the system when it is finally disposed of. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",761,"ü",null,"In the event of an accident, the system must allow the user to complete an online claim form and attach accident report, photos, licence and the report must be submitted to the fleet manager and the insurance company. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",762,"ü",null,"The system must generate follow up reminders for claim settlements",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",763,"ü",null,"The system must maintain incident records by incident file ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",764,"ü",null,"The system must generate a report on the use of vehicles ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",765,"ü",null,"The system must have a checklist for the user to acknowledge that necessary inspection was done prior to assuming use of vehicle. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Logistics/Fleet Management",766,"ü",null,"The system must be able to notify the driver by sms if a vehicle is due for service during the period he or she has it for use. If the user does not comply, escalation can be done by the fleet department. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Asset Register",767,"ü",null,"All movement of assets must be updated on the Asset register after the completion of the asset transfer form has been completed and authorisation given ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Asset Register",768,"ü",null,"The system must assign a life cycle to each asset and a disposal process for redundant assets. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Asset Register",769,"ü",null,"Workflow of the asset disposal (sale or donation) process for redundant assets",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Asset Register",770,"ü",null,"The system must enable functionality that enables the breakdown of all assets and assign them to specific business units as opposed to centralisation. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",771,"ü",null,"Component search by serial number ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",772,"ü",null,"Component search by owner, location, or warranty ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",773,"ü",null,"Sales and service activity updates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",774,"ü",null,"Customisable system generated customer order templates for product, installation service, service request, and service contract ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",775,"ü",null,"Visibility and management of remote site or distributed inventories and spares ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",776,"ü",null,"Integration capability with project management ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Service Order Management",777,"ü",null,"Integration capability with work management ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",778,"ü",null,"Maintain shipment history by product or customer ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",779,"ü",null,"Track serial numbers and service agreements ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",780,"ü",null,"Contract numbers and service agreements ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",781,"ü",null,"Service type codes ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",782,"ü",null,"Track warranty numbers and expiration dates ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",783,"ü",null,"Report field service and call activity ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",784,"ü",null,"Track serial numbers ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",785,"ü",null,"Failure type code ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",786,"ü",null,"Customer purchase order number ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",787,"ü",null,"Field sales office ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",788,"ü",null,"Report product failures by type ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Assets and Logistics Management","Field Service Management",789,"ü",null,"Process return-to-supplier transactions ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",790,"ü",null,"The system must have functionality to schedule SHEQ training, audits, medical assessments, Occupational surveys, etc.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",791,"ü",null,"The system must have a fuctionality for reminders of the scheduled all SHEQ events.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",792,"ü",null,"The system myst have a functionality to link with an eDMS software.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",793,null,"ü","Must have funtionality for health and safety risk assessment inputs, mitigation, rating, assigments, reporting, rating etc.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",794,"ü",null,"The system must have a functionality for compliance registers for OSHA.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",795,null,"ü","The system must have a fuctionality to enable nonconformance reporting, assigments, investigations and closing out.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Quality Management",796,"ü",null,"Must have a functionality for statutory SHEQ reports.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Safety Management",797,"ü",null,"The system must have a fuctionality to enable Incidents reporting, assigments, investigations and closing out following an RACT system.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Safety Management",798,"ü",null,"The system must have a fuctionality to customer query reporting, assigments, investigations and closing out.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Safety, Health, Environment & Quality (SHEQ)","Safety Management",799,"ü",null,"The system must have a functionality to manage ISO implementation/reviews planning, following up, assignments and reporting.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Customer Interaction",800,"ü",null,"The system should provide support for stakeholder interactions including but not limited to, customer service support, problem management, trouble ticketing, case management, knowledge based solutions and desktop research",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Customer Interaction",801,"ü",null,"The system should provide integration to stakeholder contact infrastructure (call centre, e-mail, portal, etc.) ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Customer Interaction",802,"ü",null,"The system should provide feedback management functionality e.g. complaints management",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Stakeholder requirements",803,"ü",null,"The system should provide functionality to assess,  capture and analyse stakeholder needs through surveys, interviews and other mechanisms",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Communication",804,"ü",null,"The system should provide capability to segment stakeeholders and develop targeted messages for each segment ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Stakeholder Management",805,"ü",null,"The system must provide online service and product catalogue and account information",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Stakeholder Management",806,"ü",null,"The system should provide assistance with demand forecasting",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Marketing & Communication","Document Management",807,"ü",null,"The system should be able to host a digital photo library. ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Audit",808,"ü",null,"The system must be developed in line with the International Standards for Professional Practice of Internal Auditing ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Audit",809,"ü",null,"The system should have history log (Audit trail) of audit assignments.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Audit",810,"ü",null,"The system should provide for different signing- off levels for all the activities and documents. Also have the ability to determine automatically when an audit was  performed.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Audit",811,"ü",null,"The system should track key milestone dates for an audit assignment.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Audit",812,"ü",null,"The system should have the ability to determine the actual status for any audit step, planning activities, execution activities, audit findings, reporting activities, review notes,  follow-up issues.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Internal Audit plan",813,"ü",null,"The system should support audit plan development with support for budgeting and reporting of deviations to actual project time and accommodate ad-hoc audit assignments.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Internal Audit plan",814,"ü",null,"The system should have the ability to manage the audit universe.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Internal Audit plan",815,"ü",null,"The system should provide functionality to create a 3 year rolling strategic internal audit plan and an annual plan.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Internal Audit plan",816,"ü",null,"The system should provide functionality for automatic calculation of the date an audit project or assignment should next be performed, based upon designated criteria.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Risk",817,"ü",null,"The system should provide for risk assessment using custom risk criteria. The system should provide integration with risk registers or risk module",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Risk",818,"ü",null,"The system should provide functionality to add new risks when developing a plan",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Planning ",819,"ü",null,"The system should enable creation of declaration of interest form, notification letter, engagement letter, request for information, timesheet.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Planning - Reporting",820,"ü",null,"System should enable creation of Agenda, attendance register, minutes of the meetings .i.e opening meeting, closing meeting and client satisfaction survey.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Planning",821,"ü",null,"The system should provide for documenting the following:\n- System description/process flow\n- Objective  \n- Risk\n- Control\n- Audit Procedures",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",822,"ü",null,"The system must provide for team allocation per audit project and audit sections to individual auditor(s).",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",823,"ü",null,"Ability to record audit work performed by auditor.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",824,"ü",null,"Ability to link or embed into software any externally generated documents, MS Office suite, spreadsheets, scanned images, ACL or IDEA data files, sound or video clips, flowcharts, etc.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",825,"ü",null,"Support of hot links to specific MS Word, MS Excel, scanned images, ACL or IDEA, and flow chart documents from audit workpapers.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",826,"ü",null,"Indexing of linked or embedded workpaper attachments/documents.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",827,"ü",null,"Ability to raise a finding, document findings directly in the database, and automatically link to supporting workpapers and audit procedures.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",828,"ü",null,"Ability to print completed workpapers including audit program.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",829,"ü",null,"Ability to capture review notes on the document, also repond on review notes and able to print review notes with version control.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",830,"ü",null,"Ability to write review notes with links to targeted workpaper.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",831,"ü",null,"Ability to search audit findings and projects.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",832,"ü",null,"Ability to review completed audit work and document review notes.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",833,"ü",null,"Secure electronic sign-off for audit steps and review notes.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",834,"ü",null,"Master listing of your own audit programs.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",835,"ü",null,"Ability to add audit steps to an audit program.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",836,"ü",null,"Ability to assign risk severity ratings to findings.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Workpapers",837,"ü",null,"Ability to assign overall rating to audit assignment or project.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Reporting",838,"ü",null,"From the findings raised automatically create and e-mail, print a draft document to present findings.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Reporting",839,"ü",null,"Customization of audit report format included in license fee.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Reporting",840,"ü",null,"Automatically generate audit report in the format your auditees are already used to seeing.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Reporting",841,"ü",null,"Distribute report via e-mail.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Reporting",842,"ü",null,"Ability to have more than one management response, action plan, implementation date and responsible person for each finding.",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Follow-up",843,"ü",null,"Ability to track and automatically follow-up on all audit findings. Ability to send reminder to auditees on unresolved and in progress findings with escalation procedures enabled",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Follow-up",844,"ü",null,"Tracking reports of resolved findings, open items (findings not resolved, findings in progress), repetitive exceptions, statistical data and ability to have dashboard of defined period"]
["Internal Audit","Follow-up",845,"ü",null,"Ability to track and follow-up on multiple action plans."]
["Internal Audit","Follow-up",846,"ü",null,"Ability to track and report follow-up issues ",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Internal Audit","Follow-up",847,"ü",null,"The system must make provisions for the acceptance of risk",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Risk & Compliance Management","Risk Management",848,"ü",null,"Align with the enterprise risk management framework open standard",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Risk & Compliance Management","Risk Management",849,"ü",null,"Enteprise-wide risk management planning, scope and context"]
["Risk & Compliance Management","Risk Management",850,"ü",null,"Development of a risk register for operations, projects and ad-hoc"]
["Risk & Compliance Management","Risk Management",851,"ü",null,"Conduct and capture the risk assesment i.e identify, quantify, analyse and evaluate the risk."]
["Risk & Compliance Management","Risk Management",852,"ü",null,"Implement risk treatment and mitigation controls"]
["Risk & Compliance Management","Risk Management",853,"ü",null,"Record, report andcommunicate on the risk management process and progress"]
["Risk & Compliance Management","Risk Management",854,"ü",null,"Delegate risk ownership and mitigation activities"]
["Risk & Compliance Management","Risk Management",855,"ü",null,"Monitor and review"]
["Risk & Compliance Management","Risk Management",856,"ü",null,"Provide functionality to support risk Identification, Assessment, Mitigation, Monitoring & Reporting",{"$nulls":3},{"$f":"IF(#REF!=\"X\",1,IF(#REF!=\"X\",0,0))","v":{"$error":"#REF!"}}]
["Physical Security","Protection Services",857,"ü",null,"Attendance Management: The system must perform the following:\n• Capture/upload personnel/visitors register\n• Print monthly/quarterly/yearly visitors reports\n• Automate the attendance business process as prescribed for payment of overtimes were neccessary or as per the policy \n"]
["Stratregy Management","Corporate Planning and Reporting",858,"ü",null,"Capture Key strategic pillars, golas, objectives, key performance areas and indicators for CGS as per the corporate plan,  annual perfomance plan and statutory reporting requirements."]
["Stratregy Management","Corporate Planning and Reporting",859,"ü",null,"Set performance targets for Key peronance areas and indicators "]
["Stratregy Management","Corporate Planning and Reporting",860,"ü",null,"Identify and interface with data sources for performance reproting as per the output and outcome indicators of the score card"]
["Stratregy Management","Corporate Planning and Reporting",861,"ü",null,"Generate intelligent reports and dashborads to visualise corporate perfomance accordnig to the pillars, indicators and targets."]

{"sheet":"Change management Requirements","index":1,"n_rows":5,"n_cols":8,"rows_kept":5,"merged":[[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7]]}
["Council for Geoscience  Change Management and Training  Requirements"]
["Process","No","Must Have","Nice to have ","Description","Response",null,"Comments"]
[{"$nulls":5},"COMPLY","NOT COMPLY"]
["Communications and Change management",1,"ü",null,"The Bidder accepts that project team will be required to make assessment and conduct change management processes in relation to ERP project. The cost of such project resources will be for the account of the Bidder. Substantiate by providing an outline the bidder previous involvement in the change management processes\nOutline the bidder previous involvement in the change management processes\n"]
["Training",2,"ü",null,"  Guide, assist, train, mentor and transfer skills during the entire project process for 1st line Technical and functional support, super user and end user training. Trainers will also be assessed by the participants."]

{"sheet":"Accreditation and Certification","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7]]}
["Council for Geoscience Accreditation and Certification  Requirements"]
["Process","No","Must Have","Nice to have ","Description","Response",null,"Comments"]
[{"$nulls":5},"COMPLY","NOT COMPLY"]
["Accreditation",1,"ü",null,"SAP consultant to be deployed on the project must no be less than K4 in terms of SAP consulting gradings  for normal consultants and between K6-7 for the lead and project management due to the complexity of the project. Please provide documentations"]
["Certification",2,"ü",null,"The project team for respective modules must be certified with the OEM. The finance team must at bear minimum have team lead with accounting qualification. Supporting evidence is required for this."]
["Personnel requirements",3,"ü",null,"SAP consultant to be deployed on the project must no be less than K4 in terms of SAP consulting gradings  for normal consultants and between K6-7 for the lead and project management due to the complexity of the project. Please provide documentations"]
["Subject matter expert per  area",4,"ü",null,"A subject matter expert must be provided for every area of expertise as required by the incumbent solution"]

{"sheet":"Technical Requirements","index":3,"n_rows":70,"n_cols":9,"rows_kept":70,"merged":[[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7]]}
["Council for Geoscience ICT Technical Requirements"]
["Process","No","Must Have","Nice to have ","Description","Response",null,"Comments"]
[{"$nulls":5},"COMPLY","NOT COMPLY"]
["Technology",1,"ü",null,"Integration across all modules, e.g. core Financials, Human Resources, projects budgetung, treasury, grants mangment, travel, maintenance, equipment, Payroll as as may be presribed by the client during requirementss gathering and solution development. Agility to  adapt and implement changes for improvement is required in case such is not stipulated anywhee in the requirements.",{"$nulls":3},{"$f":"IF(F4=\"X\",1,IF(G4=\"X\",0,0))","v":0}]
["Technology",2,"ü",null,"Database: MS SQL Server 2016 R2 or higher preferred; will consider Oracle.",{"$nulls":3},{"$f":"IF(F5=\"X\",1,IF(G5=\"X\",0,0))","v":0}]
["Technology",3,"ü",null,"Compatible with Windows 7 and higher desktop client.",{"$nulls":3},0]
["Technology",4,"ü",null,"Web‐enabled or Web‐based architecture with published open API’s. List browsers supported",{"$nulls":3},0]
["Technology",5,"ü",null,"Option that allows for multiple environments, e.g. production, test, training, development, etc.",{"$nulls":3},0]
["Technology",6,"ü",null,"Role‐level security by group or individual to menu and screen level with ability to mask sensitive data fields",{"$nulls":3},0]
["Technology",7,null,"ü","Online configurable role‐level training programs by module. Describe training configuration and options available",{"$nulls":3},0]
["Technology",8,"ü",null,"Online user knowledge base. Describe available options",{"$nulls":3},0]
["Technology",9,"ü",null,"Single sign‐on: MS Active Directory; LDAP compatible",{"$nulls":3},0]
["Technology",10,null,"ü","Support two‐factor authentication for on premise and/or hosted systems",{"$nulls":3},0]
["Technology",11,"ü",null,"Server virtualization on Microsoft VMWare Vsphere and Hyper‐V",{"$nulls":3},0]
["Technology",12,"ü",null,"Microsoft Outlook and Exchange Server integration for Email and workflow approval",{"$nulls":3},0]
["Technology",13,"ü",null,"Office 2016/Office 365 compatible",{"$nulls":3},0]
["Technology",14,"ü",null,"Import/Export to Microsoft Word, Access and Excel; ability to filter data for export",{"$nulls":3},0]
["Technology",15,"ü",null,"List integration technologies, e.g. Web Services, SOA, XML, XBRL, open API’s, etc. Flat file method not preferred",{"$nulls":3},0]
["Technology",16,null,"ü","Indicate experience integrating and proposed method to other Geoscience applications and services (Web Service, etc.)",{"$nulls":3},0]
["Technology",17,null,"ü","a. ArcGIS",{"$nulls":3},0]
["Technology",18,null,"ü","b. ERDAS",{"$nulls":3},0]
["Technology",19,null,"ü","c. ER Mapper",{"$nulls":3},0]
["Technology",20,null,"ü","d. ENVI",{"$nulls":3},0]
["Technology",21,null,"ü","e. Statistica",{"$nulls":3},0]
["Technology",22,"ü",null,"Scan and attach documents, scanned images and MS Office files to records throughout all modules",{"$nulls":3},0]
["Technology",23,"ü",null,"Describe functions supported by mobile technology, e.g. workflow approvals, data lookup’s, inspections, etc.",{"$nulls":3},0]
["Technology",24,"ü",null,"List supported mobile devices and operating systems, e.g. iPads, Surfaces, iOS, Android, Windows, etc.",{"$nulls":3},0]
["Technology",25,"ü",null,"Describe Web/Portal functionality for external user access to tax information, property information, pay online, etc.",{"$nulls":3},0]
["Technology",26,"ü",null,"Describe support for Microsoft SharePoint Enterprise Portal",{"$nulls":3},0]
["General Requirements",27,"ü",null,"Configurable role‐based dashboards to present reports, tasks, notifications, approvals, etc. with drill down to source transactions",{"$nulls":3},0]
["General Requirements",28,"ü",null,"Audit Trail with user, date and time stamp throughout all modules. Before/after history is important ",{"$nulls":3},0]
["General Requirements",29,"ü",null,"User configurable menus, screens, and fields, e.g. hide unused fields, set tab order, define mandatory fields, etc.",{"$nulls":3},0]
["General Requirements",30,"ü",null,"Flexible description field widths throughout the system. Describe where supported",{"$nulls":3},0]
["General Requirements",31,"ü",null,"User‐defined fields that can be used in queries and reports; indicate where available and limitations",{"$nulls":3},0]
["General Requirements",32,"ü",null,"Configurable electronic forms that can be filled in, routed online for approval and update the database, e.g. Personnel Action Form, Permit Application, etc.",{"$nulls":3},0]
["General Requirements",33,"ü",null,"Configurable online user help. Context sensitive is Nice to Have",{"$nulls":3},0]
["General Requirements",34,"ü",null,"Rules‐based workflow routing that can be concurrent or consecutive with electronic signatures",{"$nulls":3},0]
["General Requirements",35,"ü",null,"Visibility to workflow status and approval queue with proper segregation of duties applied.",{"$nulls":3},0]
["General Requirements",36,"ü",null,"Activity or date triggered alerts, flags, and messages, workflows and escalations",{"$nulls":3},0]
["General Requirements",37,"ü",null,"Effective dating of transactions throughout all modules",{"$nulls":3},0]
["General Requirements",38,"ü",null,"Describe enterprise Content Management and Document Management capabilities and 3rd Party partnerships",{"$nulls":3},0]
["General Requirements",39,"ü",null,"Describe data archiving and purge capabilities",{"$nulls":3},{"$f":"IF(F42=\"X\",1,IF(G42=\"X\",0,0))","v":0}]
["Applications",40,"ü",null,"The system must be an Off-the-Shelf application (no development required).",{"$nulls":3},{"$f":"IF(F43=\"X\",1,IF(G43=\"X\",0,0))","v":0}]
["Applications",41,"ü",null,"Must have local (RSA) presence for support and sales. The supplier must have local training facilities in RSA",{"$nulls":3},0]
["Version",42,"ü",null,"Current Version and Release Date",{"$nulls":3},0]
["Version",43,"ü",null,"Proposed Version and Release Date",{"$nulls":3},0]
["Version",44,"ü",null,"What Modules Have Not been Released",{"$nulls":3},0]
["Execution",45,"ü",null,"Faxing within the system. The system must support both email and SMS Notification",{"$nulls":3},0]
["Execution",46,"ü",null,"Must support Flat file interface (bi-directional). The system must support EDI",{"$nulls":3},0]
["Execution",47,"ü",null,"Must provide report writing tool.  The system must be able to incorporate report templates and must support Push and Pull report delivery",{"$nulls":3},0]
["Operations",48,"ü",null,"Must support Change Control ",{"$nulls":3},0]
["Operations",49,"ü",null,"Must support versioning (application changes) and roll back of changes",{"$nulls":3},0]
["Operations",50,"ü",null,"Must support Time based batch scheduling at asub process level",{"$nulls":3},0]
["Operations",51,"ü",null,"Must support Event Based batch scheduling at a sup process level",{"$nulls":3},0]
["Operations",52,"ü",null,"Must provide reporting (exception reports)",{"$nulls":3},0]
["Operations",53,"ü",null,"The system should have monitoring and early watch alert capabilities ",{"$nulls":3},0]
["Operations",54,"ü",null,"The system must support online and offline backup methods",{"$nulls":3},0]
["Operations",55,"ü",null,"Must propose a support model (numerous options) that will ensure that Council for Geoscience is able to maintain the system going forward as well as apply new patches and upgrades where required.",{"$nulls":3},0]
["Operations",56,"ü",null,"The system must support high availability (HA). ",{"$nulls":3},0]
["Operations",57,"ü",null,"The system must support clustering (database) and scalability. ",{"$nulls":3},0]
["Operations",58,"ü",null,"The system must support a centralised system over a distributed network and geographical environment",{"$nulls":3},0]
["Operations",59,"ü",null,"The system must support and manage output (Print, email and Fax)",{"$nulls":3},0]
["Operations",60,"ü",null,"The system must support data and document archiving",{"$nulls":3},0]
["Data Archiving",61,"ü",null,"In order to manage this performance, it must be possible to move data into an archiving database. The system must be able to move data bi-directionally between the transaction database as well as the archiving database."]
["Data Migration",62,"ü",null,"The current system data will need to be migrated into the new solution in order to process requests and queries based on historical data."]
["Interface",63,"ü",null,"The ERP ll also have to be able to interface with a variety of systems relevant to the business functions. These include National Treasury (i.e.  Central Supplier database), SARS, Banks, Payment agencies, South African Post Ofice and  Department of Home Affairs"]
["Access",64,"ü",null,"The system needs to provide for the following with regards to access: User Access Management; Security Management; Accessibility from various devices (i.e. iPads/tablets/smart-phones); Audit Trail of Transactions on System"]
["Recovery",65,"ü",null,"The solution should provide capability of being able to be restored to a secure and adaptable point in event of system failure; to a backup point (either incremental, differential or full) or to a consistent point immediately prior to failure."]
["Solution source code copyright and ownership",66,"ü",null,"The CGS will take ownership of all system documentation and source code for custom development during and upon completion of the project. "]
["Value assurance ",67,"ü",null,"Service provider will perform value assurance with OEM prior and post the implementation"]

{"sheet":"Evaluation Criteria","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"hidden":true,"merged":[[0,0,0,2]]}
["Council for Geoscience Evaluation Criteria"]
["No","Criteria","Scoring","Notes"]
[1,"Provide functional proposal that meets our specifications and related service requirements. A minimun score of 75% is required for each section.\n\n(Meets functional requirements)\n•   Average is 90% - 100% = 40 points\n•   Average is 80% - 89%   = 20 points\n•   Average is 75% - 79%   = 10 points\n•  Average is < 74%             =   0 points\n\nNB: Submit completed specifications spreadsheet (Functional Requirements)",40,{"$f":"IF(F20 <> FALSE, AVERAGE(E11:E19), \"One or more section is less than 75%\")","v":{"$error":"#REF!"}}]
[2,"Provide technical proposal that meets our specifications and related service requirements.\n\n(Meets technical requirements)\n•   Average is 90% - 100% =  20 points\n•   Average is 75% - 89%   =   10 points\n•  Average is < 74%             =   0 points\n\nNB: Submit completed specifications spreadsheet Technical Requirements)",20,{"$f":"E21","v":{"v":0,"d":"0.00"}}]
[3,"Approach and Methodology: Describe the approach, methodology and plan (AMP) to be adopted during the review, implementation, execution and hosting. \n\nThe scoring will be based on the following:\n• No or incomplete AMP = 0 points\n• Complete and detailed AMP = 10 points\n",10]
[4,"Project Plan: Bidders are required to submit a project plan with their proposals. (Note: Go-live must be within 12 months) \n\nProject plan must also include the following tasks and deliverables:\n• Project Initiation\n• Change and Communication Management\n• Requirements Gathering\n• Implementation\n• Training\n• Skills Transfer \n• Data Management\n\nThe scoring will be based on the following:\n• No or incomplete project plan = 0 points\n• Complete and detailed project plan within the requested period = 10 points\n",10]
[5,"Provide signed letters from contactable references stipulating where an ERP implementation project of a similar size (minimum 500 users) has been successfully delivered by the Bidder in the last 10 years\n\n•   5 and more implementation references = 10 points\n•  3 - 4 implementation references = 5 points\n•  0 - 3 implementation references = 0 points",10]
[6,"Capacity and experience of the proposed team. The proposed team must demonstrate experience, qualifications and capabilities. The team leader must have al least 7 years' experience in the ERP environment (Attach CV, profile, past and current projects).\n\n•   7 or more years experience = 10 points\n•   5 -  7 years experience           =   5 points\n•   0 or less than  5 years experience           =   0 points",10]
[]
[null,null,"Total Points Achievable","Total Points Achieved","%","Check if >75"]
[null,"Human Resource Management",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B11)","v":89},{"$f":"SUM('Functional Requirements'!J4:J92)","v":{"$error":"#REF!"}},{"$f":"D11*100/C11","v":{"$error":"#REF!"}},{"$f":"AND(E11>75)","v":{"$error":"#REF!"}}]
[null,"Financial Management",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B12)","v":361},{"$f":"SUM('Functional Requirements'!J93:J453)","v":{"$error":"#REF!"}},{"$f":"D12*100/C12","v":{"$error":"#REF!"}},{"$f":"AND(E12>75)","v":{"$error":"#REF!"}}]
[null,"Supply Chain Management",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B13)","v":171},{"$f":"SUM('Functional Requirements'!J454:J625)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Geological Resources & Applied Geoscience",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B14)","v":97},{"$f":"SUM('Functional Requirements'!J626:J722)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Assets and Logistics Management",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B15)","v":70},{"$f":"SUM('Functional Requirements'!J723:J769)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Safety, Health, Environment & Quality (SHEQ)",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B16)","v":10},{"$f":"SUM('Functional Requirements'!J793:J802)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Marketing & Communication",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B17)","v":9},{"$f":"SUM('Functional Requirements'!J803:J810)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Internal Audit",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B18)","v":40},{"$f":"SUM('Functional Requirements'!J811:J850)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Risk & Compliance Management",{"$f":"COUNTIF('Functional Requirements'!A4:A859,'Evaluation Criteria'!B19)","v":9},{"$f":"SUM('Functional Requirements'!J851:J859)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":5},{"$f":"AND(E11>75, E12>75, E13>75, E14>75, E15>75, E16>75,E17>75,E18>75,E19>75)","v":{"$error":"#REF!"}}]
[null,"Technology",{"$f":"COUNTA('Technical Requirements'!A4:A63)","v":60},{"$f":"SUM('Technical Requirements'!I4:I63)","v":0},{"v":0,"d":"0.00"}]
[]
[]
[]
[null,null,"   "]