MISys Manufacturing Software Qualification - Example Document by JC3
MISys Manufacturing Software Qualification - Example Document by JC3
MISys Manufacturing Software Qualification - Example Document by JC3
1.0 PURPOSE
The purpose of this Operational Qualification (OQ) Protocol is to define and execute a process that
will validate the capabilities of the MISys software to satisfy the requirements of Good Automated
Manufacturing Practices fifth edition (GAMP 5) published by the International Society for
Pharmaceutical Engineering (ISPE). More specifically this application will be tested in conjunction
with the relevant procedures SOP’s (Standard Operating Procedures) and WI’s (Work Instructions)
that are or will be used by the Company in its operating environment.
2.0 SCOPE
This protocol will be used to qualify elements of the MISys manufacturing software that will be used to
support the company’s manufacturing and quality processes. Within the MISys application and the
related business processes, the focus will include:
Other business software - Note: list here any other “relevant” software applications; e.g. Quickbooks,
which may integrate or interface with MISys and indicate whether or not they will be included in this
validation protocol.)
3.0 REFERENCES
4.1 References - (NOTE: Here it is suggested that you list the applicable SOP’s or Work
Instructions that will be referenced during the Validation process such as “Adding and
Maintaining Bills of Material”, “Processing Purchase Orders”, etc.
Page 1
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
4.2 Definitions: (Note: Here you should list and define the various terms that will be used
repeatedly throughout the document. Some examples are provided below)
TERM DEFINITION
Computer software that automate a specific business process or
Application
processes.
Computer equipment including servers, printers, disk drives, tape
Hardware drives, I/O equipment, communication equipment, workstations, and
other devices as required to host and interface with software.
Shared boundary across which information is passed between
Interface
systems.
Standard Operating
Instructions for executing a process.
Procedure (SOP)
Work Instruction (WI)
Document that links user requirements and/or functional specifications
contained in the SRS to the tests conducted in the IQ, OQ, PQ test
Traceability Matrix (TM)
protocols, in order to verify that all requirements and specifications
have been verified.
Documented evidence that provides a high degree of assurance that a
Validation
system performs its intended functions accurately and reliably.
Risk The possibility of incurring harm.
4.2 Primary documents to be released or updated: Note: here you s list the primary documents
(SOP’s, etc) that will be either updated or newly released during the implementation
process.
Page 2
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
4.2.1 .
4.2.2 .
4.2.3
4.4 Software Environment – Provide a description of the network operating system and all
related software applications
4.4.1 Operating Systems – Microsoft Windows Server ….
4.4.2 Software Packages
4.4.2.1 Intuit QuickBooks ….
4.4.2.2 MISys Manufacturing Version….
4.4.2.3 Microsoft SQL ….
4.4.2.4
4.5 Security - the server is housed (Describe where it is housed and who has physical access)
System administration - is currently provided by: Provide a description of the IT organization
or outside provider. The specific components of the security environment include:
4.5.1 Operating system –
4.5.2 Database – Stored on:
4.5.3 Server console – Access limited to:
4.5.4 MISys Manufacturing – Defined security roles are established within the application.
Users are assigned to security roles based on their job responsibilities
4.7 Disaster Recovery Plan - the disaster recovery plan includes the computerized systems and
associated equipment. The plan defines the business procedures in order to continue business
operations (including possible interim manual operations). The resources for the disaster
recovery plan include the following:
4.7.1 Hardware inventories – Maintained by:
4.7.2 Software inventories - Maintained by:
4.7.3 System recovery includes:
4.7.3.1 Full back up including system state of all servers to local and offsite storage
medium – Describe frequency and provider including audits, etc.
4.7.3.2 Email is maintained by:
4.7.3.3 All other servers (file, application, etc.) are hosted at:
4.7.3.3.1 Server Disasters – Describe how they will be handled
4.7.3.3.2 Site Disasters or Regional Disasters – (flooding, earthquake, etc.) that
impacts more than one single hardware server will be treated on a case by case
basis as follows:
4.7.3.3.2.1 Assess damage – An inventory and assessment of functional
equipment will be performed to determine proper course of action.
Page 3
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
7.0 RESPONSIBILITIES
Role Responsibilities
Project management and planning
Control of project activities, resources and costs
Monitor progress and initiate corrective actions where
necessary
Ensure issues and project objectives are addressed and
resolved
Project Manager Setting-up and monitoring the test database environment
and validation process
Report to sponsor and/or senior management
Work with quality to ensure compliance by submitting a
summary report describing the results of this OQ exercise,
which shall then be approved by Operations,
Manufacturing and QA/RA
Ensure compliance with appropriate regulatory and quality
requirements as well as company policies and procedures
Quality
Review and approve deliverables
Approve system release for production use
Implement and manage the system for the user
System Owner/Business
community
Owner
Review and approve deliverables
Executing protocol, collecting test data, and signing off
Functional Business Users
test cases they perform
Author deliverables
Validation Review and approve deliverables
Assist with execution of protocols
Page 4
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Role Responsibilities
Establish and maintain computer infrastructure equipment
Information Technology
per corporate policies and procedures
Page 5
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
8.1 Pre-Qualification - The initial migration phase of critical data into the MISys database shall be
done as described below. This phase will be completed prior to execution of this validation
protocol.
8.1 Item Master data – the controlled list of components, assemblies and their associated
data values shall be transferred to pre-formatted Excel spreadsheets. After initial review
and verification, the data from these spreadsheets shall be electronically imported into
the MISys database using standard data import functionality contained in the application
software. Subsequent to the initial data loading, MISys-generated standard reports shall
be used to verify the accuracy of the data loading process and results of the Item Master
data load shall be documented in the trace matrix in Section 9.0.
Item Master Data
Source Data Target Data
Part Number Itemid
Description Descry
Revision Ref
Unit of Measure uOfM
Purchasing Unit of Measure poUOfM
Conversion Factor uConvFact
Account Set Glld
Part Type Type
Lot/Serial Track Track
Standard Cost cStd
Lot/Serial Method lotMeth
8.1 Product Structure data (bills of material) –the controlled source of product structure
data, including both prior and current revisions, shall be transferred to pre-formatted
Excel spreadsheets and imported into the MISys database in a manner similar to 8.1.
Again, MISys-generated standard reports have been used to verify the accuracy of the
data loaded into the MISys database and results of the Bill of Material data load shall be
documented in the trace matrix in Section 9.0.
Bill of Material Header
Source Data Target Data
Bill of Material Item bomItem
Bill of Material Rev bomRev
Rollup Rollup
Multiples Mult
Yield Yield
Auto Build autoBuild
Last Maintenance Date lstMainDate
ECO Number ecoNum
Overide Ovride
Assembly Lead Time assyLead
Quantity Per Lead Time ‘qPerLead
Revision Date revDate
Effective Start Date effStartDate
Page 6
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
8.1 Supplier Master – The Company’s principal source of supplier information is contained
in the QuickBooks accounting software application. The MISys software functionality will
have been used to import supplier data into the MISys database. Subsequent to the data
loading, MISys-generated standard reports will have been used to verify the accuracy of
the data loading process and results of the Supplier data load shall be documented in the
trace matrix in Section 9.0.
8.2 Post Qualification - following the successful conclusion of this protocol, the following additional
critical data will be migrated into the MISys database just prior to “going live”:
8.2 Inventory data – a complete physical inventory will be taken of all items used in the
Company’s production environment including their lot # and serial # identification data.
This will be done for all stocking locations. After management audit and acceptance, this
data will be loaded into the MISys database using the MISys software’s standard physical
inventory functionality.
8.2 Supplier commitments – all relevant data pertaining to outstanding purchase order
commitments for production-related materials will be manually loaded into the MISys
database. Again, standard MISys reports will be printed and user shall verify the
accuracy of this data.
8.2 Production orders – at the onset of using MISys in the production environment, the
users shall begin loading entirely new manufacturing orders into the MISys database
following the established procedures.
The trace matrix lists the business requirements, test case summaries, and acceptance criteria. The
detailed test cases are included in Appendix A.
Page 7
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Page 8
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Page 9
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
C4. The system shall TC-C4: Process a vendor invoice and TC-C4: The invoice
perform a 3-way match apply it to the purchase order receipt matching is
between the purchase insuring that there is a 3-way match performed
order, receipt, and between the PO receipt transaction, the accurately resulting
invoice. vendor’s packing slip and the vendor in the correct
invoice. updating of the
Order Invoice
Value report and
the invoice is
updated correctly
in QuickBooks.
C5. The system shall TC-C5: Process transactions returning TC-C5: Both types
allow previously material to vendors. The first transaction of return
received materials to is for a return against a purchase order transactions are
be subsequently which is still open. The second is done processed
returned to the after the originating PO is closed. successfully and
supplier the appropriate
data are updated
correctly.
C6. The system shall TC-C6: Produce reports for all purchasing TC-C6: The reports
provide PO information and Inventory-related transactions for correctly display all
to R&D to aid in the R&D location only thereby aiding PO and Inventory-
disposition decisions. R&D in its disposition decisions. The related transaction
reports should be able to be filtered by with appropriate
both data and transaction type. filtering.
C7. The system shall be TC-C7: Produce detailed reports covering TC-C7: The system
able to report on all purchase order receiving activities correctly displays
purchase order receipts showing quantities, dollars, scheduled the transaction
showing quantities, delivery and actual PO receipt date. detail for all PO
dollars, scheduled receiving activities.
delivery and PO receipt
date.
C8. The system shall TC-C8: Produce detailed reports TC-C8: The system
report on purchasing displaying variances in quantity and cost reports the
quantity and cost for all closed purchase orders. purchasing quantity
variances. and cost variances.
C9. The system shall be TC-C9: Produce a report summarizing a TC-C7: The report
able to report on supplier’s on-time delivery performance. provides the ability
supplier on-time to report on a
delivery performance. supplier’s on-time
delivery
performance.
Page 10
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Page 11
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
D7. The system shall TC-D7: Change a Lot’s status from TC-D7: The lot #’s
allow a lot to be placed “Active” to “On-Hold.” The lot is now status is changed to
on hold. longer able to be transacted while in this “On-Hold”
status.
D8. The system shall TC-D8: Produce a report showing the TC-D8: The report
provide inventory inventory quantity and resulting dollar displays a complete
quantity and dollar valuation for all items in the database. listing of all
valuation reports by quantities and
item. dollar valuation in
the database.
D9. The system shall TC-D9: Change the standard cost of a TC-D9: All updated
allow for roll-up of component item. Then roll-up the costs cost data must
standard costs for of its parent assembly. Run the MISys agree with source
items & BOM’s on a report and compare the cost data for data and the
controlled basis. each item (parent and component) to assembled item
the previous data on the previous report cost must
run in Step (1) above. accurately reflect
the rolled cost of its
component items.
D10. The system shall TC-D10: Run the accounting report of TC-D10: The
report the cost impact Unposted Transaction detail and identify accounting entries
of changes to standard the accounting entries generated by the on the report must
costs. cost change and cost roll-up activities agree with the
from [D9] above. Review and confirm accounting entries
the accuracy of these entries. displayed on the
source data.
E. Processing manufacturing orders
E1. The system shall TC-E1: Open and release (2) TC-E1: The
allow manufacturing manufacturing orders. The first one component
orders to be entered should be for an assembly that is also a requirements for
and printed. The component of the assembly of the each order must
manufactured item’s second manufacturing order. The agree with the list
must Revision # be component material requirements listed of component
printed on the for each manufacturing order must be requirements on
document compared to the bill of materials (BOM) their current BOM
listing for each of the parent assembly file.
items. The revision must print for both
the parent and component items.
Page 12
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
E2. The system shall TC-E2: Print the “Picklist” for the order TC-E2: The Picklist
allow for issue of and confirm that “unreleased” lots (Lots displays and allows
component materials still in the Quarantine location) are not issue of only
to a Manufacturing displayed as “available” for issue on the “released” lots in
Order but prevent use document or accessible on the screen on the manufacturing
of unreleased lots. which components are transferred area to WIP.
(issued) to WIP. Issue the required Released
quantities of each component to WIP. components are
The revision must print for both the correctly issued to
parent and component items on the WIP. The revision
Picklist document. data prints
correctly.
E3. The system shall TC-E3: Complete and close the TC-E3: The order is
allow for the manufacturing order for the first completed and all
completion of assembly including assignment of serial parent and
assemblies to stock numbers and linking of component lots component
from Manufacturing to the parent serial #’s. The Serial #’s requirements are
Orders being received is consistent with the transacted
“existing” format that is currently in use. correctly. In
addition, the Serial
# format is the
same as the current
format in use.
E4. The system shall TC-E4: Complete and close the TC-E4: The order is
allow for additional manufacturing order for the second completed and the
component issues to assembly after adding an incremental additional
manufacturing orders. requirement for a component item to component
account for scrapping or other requirement is
unplanned requirement. processed
correctly.
E5. The system shall TC-E5: Print a report showing the TC-E5: The
report manufacturing quantity and cost variances for the (2) reported variances
order quantity and cost closed manufacturing orders. Review are correct and
variances. and confirm the accuracy of the consistent with the
reported variances. report printed in
TC-E3.
Page 13
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Page 14
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
H3. A user can only see TC-H3: Sign on by testing the new User TC-H3: User is only
and access the menus ID and Password. Confirm that sign-on is able to sign-on
and screens and not able to be done with an incorrect using a valid User
perform the functions password. Then confirm that the user is ID and Password. In
for which they are able to see the menus and screens set addition, the User
authorized. up for the User’s Security Group as well can only see the
as experience controls over view vs. menus and screens
update capabilities. for the Security
Group and
Page 15
TEST PROTOCOL
DOCUMENT NO.: REV.: DCO NO.: Rev. Date:
TITLE: SAMPLE - MISys Manufacturing Software Qualification
Test Cases will verify that the Business Requirements are met by the MISys Manufacturing
system. Each Test case will be assigned a unique number, document the Business Requirement
being tested by referring back to the Business Process Requirement and document the Pass/Fail
result of the Test Case. All the Test Cases will be Pre and Post Approved by the Project
Management team.
Test Cases which have failed will be evaluated for the cause of failure, including inadequate
procedures, inadequate test data, misunderstood Test Case execution and/or a Risk Mitigation
proposed. Failed Test Cases can have the following activities performed:
Revise the Business Procedure to correct the failure
Revise the test data to correct the failure
Re-execute the revised Test Case using a new Test Case number and referencing the
old Test Case number
Page 16