Pharmaceuticals Manufacturing Deviation Report using Ultimate Forms
Vladi Gubler
Vladi Gubler
July 18, 2011 | Sample Applications

Hello,

 


UPDATE: you can now download a self-installing site template here. The package will install trial versions of all the required Infowise products automatically.

 


 

Our Ultimate Forms bundle allows you to build almost any SharePoint-based business application using nothing but your browser.

Today we are showing our regulated process for the pharmaceuticals industry - Manufacturing Deviation Report. The report is a business process where any irregularity detected in the drug manufacturing process must be documented, investigated and acted upon using a set of corrective and preventing actions (CAPA).

Here you can see the report in action:

As you can see, it's quite a complex process, spanning multiple stages and involving many users.

But you will be surprised how easy it is to implement a process like this using our bundle.

 

So let's get started creating this process. You need to download and install the Ultimate Forms bundle from our website. You can also install our Document Link Field for the attached documents functionality, but this is up to you.

First of all, we need a blank site to host our system.

Now let's create several auxiliary lists, before we move on to our main list, the Deviation report itself.

We need the following lists:

  1. Shared Documents - a document library to hold our attachments, no changes to the structure are required.
  2. Batch Statuses - custom list, serving as a data source for the Batch Status lookup column. Includes value such as On Hold, Destroyed, In Process and so on. The actual values depend on your requirements
  3. Departments - custom list, serving as a data source for the Department lookup column. In our example holds the names of different manufacturing departments
  4. Professional Opinions - a Tasks list to hold the request for porfessional opinions. Once created:
    1. Allow content type management.
    2. Add existing content type called Associated Task under Infowise group.
    3. Remove the built-in Task content type.
  5. CAPA Tasks - a Tasks list to manage the corrective and preventive actions. Do the following:
    1. Create a Tasks list called CAPA Tasks
    2. Go to the Content Types gallery of your site and create two new content types: Corrective Action and Preventive Action. Base both of them on the Associated Task content type. Add Approve Closure yes/no column and a signature column.
    3. Add the newly created content types to the CAPA Tasks list, you need to enable content type management in the list settings first.
    4. Remove the built-in Task content type

We can now move on to creating the main list.

  1. Create a custom list called Deviation Reports.
  2. Add columns for each of the stages
  3. Columns
  4. Most of the columns are just regular SharePoint columns, but pay attention to the following:
    1. Batch Details - imports information from a manufacturing system. Can either connect directly to any database or to a web service.
    2. Additional Files - for most stages we allow uploading and linking documents using Document Link Field
    3. Signature columns - using Infowise Electronic Signature field you an sign other columns in the list. In our case, each tab's columns are signed by the signature column on that tab.
    4. Professional Opinions - Associated Tasks field linking to the Professional Opinions list.
    5. Corrective Actions and Preventing Actions - Associated Tasks fields linking to the CAPA Tasks list. Make sure to assign the correct content type for each column.

Once the list is created, we can create the tabs to represent the stages of the process.

  1. Go to List Settings
  2. Click on Tabs and Tab Permissions
  3. Create a tab for Preliminary Report stage
  4. Select the columns to be appear on the tab
  5. Using tab permission, set Write permission to New form and Read permission to Edit and View forms.
  6. Tab 1
  7. Create tab for Production Manager
  8. Define settings as shown below. You can add a user or group to the Write permission to make sure only a specific user can edit this tab. For simplicity sake, we do not use user-based permissions in this demo.
  9. Tab 2
  10. Do the same for the Head Pharmacist
  11. Tab 3
  12. And the Quality Assurance Manager
  13. Tab 4
  14. The same goes for the last tab. Notice how we prevent closing the report when there are still open actions
  15. Tab 5

We now have set the tabs to appear according to our process. Using Advanced Column Permissions, let's set Read permissions to Status, Open Corrective Actions and Open Preventing Actions columns to prevent users from editing them directly.

Using Item ID settings, we can generate the report ID automatically using a template:

Item ID

We are almost done, we just need to plug in a couple of simple SharePoint Designer workflows to make the whole process run.

First, let's add add a workflow to the CAPA Tasks list that will close tasks and update the deviation report when there are no longer any open tasks left either for the Corrective Actions or Preventive Actions field. Notice the new actions and conditions added by the Associated Tasks field. They are capable of checking all items associated with the same parent item.

Task WF

Set the workflow to run when an item is updated.

Now let's create our main workflow that will change the report status depending on user input.

We will simply change the status to the next stage when we detect a signature field being filled.

Report WF

Set the workflow to run when an item is created.

This is it, you can now test the process to make sure it runs successfully. Feel free to use this demo as a basis for your own processes and we will appreciate your feedback!

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.