📜 ⬆️ ⬇️

Simple automation of the management of acts of marriage on SharePoint with examples and pictures

Introduction


This article is aimed at those who have SharePoint and who do not know what to do with it. :)

There is a lot of talk about business process everywhere, but few mean by this a truly process approach, rather imagine some kind of black box where, at best, there is input and output, sometimes even structured - it’s determined what we have at the input and output. In fact, if more than two people are responsible for the process in the box, easy chaos is provided for you, and with an increase in the number of those involved, an exponential increase in entropy is ensured. :)

The process of managing an organization is a set of actions repeated over time, with a specific beginning and end, the purpose of which is to create value for external and internal customers. In fact - the transformation of resources at the entrance to the product at the output, the product can be any - both tangible and intangible knowledge. Conversion in a box can be extremely simple, does not require decomposition, and can be very complex, involving a lot of staff and time, having many conditions and dependencies. The question of the level of decomposition of the process lies in the plane of rationality, expediency and common sense, I like the methodological principle of "Occam's Razor", which says that "It is not necessary to involve new entities without extreme necessity", where you can do without formalizing the action - to formalize action is not worth it. :)

')

The essence of the matter


Easy immersion in the theory ended, back to our case. We have a manufacturing enterprise, which, like all others, in addition to the main product, produces a marriage, where without it. And there is a Quality Department (OC) at that enterprise, the purpose of whose existence is to fix a marriage, to promote elimination, to prevent and stop in every possible way. Yes, that there the Quality Department, the whole Quality Management System (QMS), is implemented at the enterprise, conforming and certified according to ISO 9001. It would seem, there is OK, there is QMS, all the processes are written on paper, everything corresponds to the international level, do not work want!

But! The act of marriage or the act of admission control can go a month or two, taking into account weekends and holidays between departments and employees of the enterprise. How so? The act of entrance control, getting to the legal adviser, was already late for drawing up a claim to the supplier, all the deadlines for the delivery contract for returning were issued. And how many such cases? And how many acts do we have at work? And at what stage are they? And at what stage do they get stuck the most? Which unit generates more defects? And who is the culprit? And who eliminates more often? Which supplier has worse quality? And how many claims sent to suppliers and without an answer? What are the costs we incur? And many other questions. We will analyze paper logs and folders with acts, explanatory, costing?

What to do?


- And let us, instead of paper journals, make acts electronic, will we create a sequential process of working on an act?
- Let's!
- We have SharePoint, is it right?
- Of course!
- The whole process has already been described here, we just need to move.
- Easily!
As you can see, the solution was found quickly and the work began to boil.

Documentation!


Having learned from bitter experience, I will say one seemingly obvious thing that I will not even argue with anyone about, I just say it as a fact - always start an automation project by developing a process flowchart, make a detailed document describing the scheme along the way and never start development without these agreed documents!

You can not believe me and work without a scheme and a detailed description, infinitely changing the process under the new brilliant ideas of the participants.

Reengineering!


Another point is that you should not completely rely on the competence of the process owner and expect him to become your main consultant. Your common sense should be your main consultant. All actions of the process, all dependencies and conditions should be questioned - ask questions "Why?", "What is the reason for this?", "Can we refuse it?". The easier your process will turn out - the more chances it has to start and remain efficient in an organizational sense. It is also likely that the process will have to be transformed, taking into account the technical features of the chosen automation platform. Your task is to optimize the process, make it maximally human-independent, transparent, manageable and time-limited to achieve maximum efficiency. This is called reengineering. Occam's razor to help you!

Go!


Having studied the process of managing acts of marriage, described in the QMS and examining the physical process, it became clear that everything is not so simple.
The process is described very poorly and in general terms, but physically it turned out to be very complex - at every step the new condition “IF” and every new step draws new dependencies.

Putting two physical processes on the scheme - the act of marriage and the act of input control, it turned out that they are almost identical - they use the same data, the same actions, and differ slightly in the output. So, it is not necessary to produce unnecessary entities - we unite!

There were a lot of such moments. Along the way, we informed all the participants involved in the process about all the changes, and, probably, after the tenth variant of the process, we decided with the owner and everything that everything was ready, the option was final, it was possible to finish and run.
We decided to convene a meeting, inviting everyone involved to tell and demonstrate, walking through all the stages, how the new process will work, where and whose responsibility. And they immediately found out with the legal adviser that it is very desirable that the stage of processing the claim to the supplier under the act of incoming control be monitored and, in the event of a refusal or partial refusal, in the event of the expiration of the allotted time, involved in the work of the legal adviser and only In some cases, the processing of a claim is an absolutely ordinary process. And then they found out that the stage of processing the claim after negotiations with the supplier can change the decision on the act from returning to the supplier to, say, a correction on its own with partial reimbursement of costs by the supplier. Various trifles were also taken into account, it seems, of the requirements and wishes of the accounting department on the printed form of the act and the live signatures, the wishes of the chief engineer for the automatic creation of the claim.

Either the eleventh, or the twelfth version turned out to be the final one and another meeting fully approved it. By the way, without a scheme your meetings would be boring - the participants simply would not understand you, would leave and agree, they say, "Let's do it, but we'll see."

Boring technical part


I'll tell you a little about how the process is implemented technically.
In the SharePoint site, custom lists have been created that are used as journals or reference books. Links between them are provided by using lookup columns and workflows.

Standard forms have been improved through SharePoint Designer and new ones have been created, for example, accumulation of connected data in the form of viewing the marriage certificate, the printed form of the act or the printed form of the claim to the supplier.
Customizing the display of forms is an extensive question and has the same set of solutions. For example, you can simply hide certain fields in different forms with the parameters ShowInDisplayForm, ShowInEditForm, ShowInNewForm. There are many applications for setting parameters - for example, SharePoint Manager. For convenience, some fields can be displayed in the edit form, but you can assign the Disabled attribute to an element using simple Javascript. In general, Javascript always saves, for example, you need to create a comment while being in the contract viewing card, or executing on a job memo, press the “Create” button, in which you pass the ID of the current element to the form of creating a new element. The script takes the ID and select the desired value in the Input element.
You can also create from scratch any forms in SharePoint Designer, and someone might like InfoPath.
In the 2007 and 2010 versions, you can use the Office Toolbox extension, where everything is simple and convenient to be ticked, including the field can be displayed in the edit form, but Read Only.

Workflows are created through the SharePoint Designer. Workflows provide both the business process itself and data consistency in some cases.
In 2007, SharePoint versions sometimes help Useful Sharepoint Designer Custom Workflow Activities, for example, when after editing you need to leave only read permissions for an item. In the 2010-2013 versions there are no such problems - everything is out of the box, in general, in the new versions, the presence of an impersonation step somewhat changes the approach to the design of the process logic - considerably simplifying.
Restriction of stages in time is organized by creating an additional workflow with a timer, which waits for the allotted time and after its expiration checks for filling in the required fields. If everything is bad, set “Deviation equals Yes” and sends notifications to all interested parties. For better visualization, you can add a hyperlink type field to which you can write links to standard indicator pictures, for example, a created one that requires a reaction — a yellow icon, a timely filled-in element — green, and a deviation — respectively, red.

The process is ready!


This is how our documentation looks like, which was put into effect by order:

Diagram of the process of dealing with marriage acts
image

Regulations work with acts of marriage
Full text

Regulations work with acts of marriage



Terms and Definitions

Controller - the person responsible for quality control taken at the production and suppliers of finished products, materials, raw materials (controller or head of quality department).
Economist - the person responsible for planning and the actual calculation of material and labor costs (economist normalizer or head of the financial and economic department).
The technical department is the person responsible for the design and technological preparation of production (Chief Designer, Chief Technologist or Deputy).
Accountant - the person responsible for the accounting of production costs and payroll calculation (accountant for production, cost, salary or Chief Accountant).
Chief Engineer - a person who has the right to sign documents, in his absence - a person acting as the chief engineer.
The list is a spreadsheet (journal) with columns, where each row (record) is a separate element.
A list item is a list string with a unique identifier that may contain attachments of documents, have limited user access rights, and run workflows.
Workflow (RP) is a program that determines the logic of actions and is performed automatically upon the occurrence of certain events, such as the creation or modification of an element / document in the list, the occurrence of a specified date.

general description

To organize the process of managing electronic marriage acts, the lists of the “Quality Department” node of the enterprise portal are used, located at portal.domain.ru/SiteDirectory/quality
Lists can be presented as paper logs, where there are lines and fields to fill in, each line is a unique entry that has attributes. The difference is that the entry in the electronic list can have attachments, run workflows to automate actions, for example, send a notification, change any value, entries in the list can be dynamically sorted, grouped, calculated any attribute values ​​and sum up.
Using the specified lists, as well as automated action logic, configured through the use of programmable workflows, processes for managing electronic marriage acts (non-conformity) have been created.

The processes of registration and processing of acts of marriage

1. Creation of the Act by the controller

For registration of acts, a list of “Acts of marriage” (https://portal.domain.ru/SiteDirectory/quality/Lists/List) was created. The registration of marriage acts is carried out by the controller of the quality department in accordance with the rules adopted in the organization.

When you create an entry in the "Act of marriage" are filled in the following fields:
Input control - select Yes / No (indicates Yes if there is a discrepancy in the input control of materials and finished products from an external supplier)
Detected - selection of a workshop where a discrepancy is detected (mandatory)
Occurred - selection of the workshop where a discrepancy occurred (mandatory)
Controller - choice of the name of the responsible controller of the quality department (mandatory)
Products - the name of non-compliant products (mandatory)
Quantity - the number of non-conforming products (mandatory)
Non conformance - detailed description of product non conformance (mandatory)
Itinerary / Operation / Worker - transfer of production characteristics (mandatory)
Note - optional text field

The record may also have file attachments (photos, drawings, documents).

When editing a record, the same fields are available as during creation.

2. Decision making JCC

After registration of the marriage certificate, an item is automatically created in the “Decisions on marriage” list (https://portal.domain.ru/SiteDirectory/quality/Lists/List6) and a notification is sent to the quality department.
The quality manager or responsible engineer must make a decision.
When you change an entry in the “Decisions on marriage” list, the following fields are filled in:
Solution - selection of values ​​from the “Solutions” directory (https://portal.domain.ru/SiteDirectory/quality/Lists/List7) Return to supplier / Correction / Retreat / Disposal (mandatory)
Elimination Workshop - selection of values ​​from the “Divisions” directory (https://portal.domain.ru/SiteDirectory/quality/Lists/List1) (mandatory)
Correction - description of measures to eliminate inconsistencies (mandatory)

When viewing an item, the following fields are available:
Decided - the account of the employee of the quality department who made the decision on the nonconformity, the field is filled automatically after saving the item
Deadline - within 4 business hours of receipt of the notification.

3. Defining corrective actions

After registration of the marriage certificate, an item is automatically created in the “Corrective actions” list (https://portal.domain.ru/SiteDirectory/quality/Lists/List11) and a notification is sent to the head of the department where the discrepancy has occurred. The status of the Act is changed to "Decision of the head of the JCC".

The head of the unit must respond by filling in the required fields.

When you change an entry in the “Decisions on marriage” list, the following fields are filled in:

The cause of the mismatch is the choice of value from the “Mismatch” reference book (https://portal.domain.ru/SiteDirectory/quality/Lists/List5)
The culprit - name of the artist or supplier name
Corrective actions - measures taken or planned to prevent similar inconsistencies in the future

When viewing an item, the following fields are available:
Decided - the account of the head of the department where the discrepancy occurred, who made the decision on the inconsistency, the field is filled automatically after saving the item
Deadline - within 16 working hours of receipt of the notification.

4. Coordination of the decision of the Technical Department

After a decision is made on the non-compliance, the head of the quality department automatically creates an item in the “Approval of the decision” list (https://portal.domain.ru/SiteDirectory/quality/Lists/List9) and sends a notification to the Technical Department head. The status of the Act is changed to "Coordination of the Technical Department."

The head of the Technical Department must agree or reject the solution proposed by the quality department.

When changing an entry in the list, the following fields are filled:
Agreed - select Agreed / Declined (mandatory)
Comment - text box with explanations (required)

Fields available when viewing a record:
Agreed - the account of the employee of the Technical Department who agreed or rejected the decision on non-compliance, the field is filled in automatically after the item is saved.

At the stage of approval of the decision, two scenarios are possible:
  • 1. The technical department rejected the proposed solution.
    It returns to stage 2 of the workflow when a solution is created for the head of the quality department. The status of the Act is changed to "Decision of the head of the JCC". The previous decision is kept for history.
  • 2. The technical department agreed on the proposed solution.
    Go to stage 5 of the process.
    Deadline - within 4 business hours of receipt of the notification.


5. Costing

After agreeing on the decision, an item is automatically created in the “Costing” list (https://portal.domain.ru/SiteDirectory/quality/Lists/List8) and sent a notification to the normalizer of the unit selected by the head of the quality department as an eliminator. The status of the Act is changed to "Costing".

An employee of the economic department must perform a cost estimate (material, labor, direct and indirect) associated with this discrepancy, with the implementation of the solution to resolve the discrepancy.

The record may also have file attachments (photos, drawings, documents).

When changing an entry in the list, the following fields are filled:
Semi-finished products - the sum of the costs of semi-finished products in rubles (mandatory)
Materials - the sum of expenses for materials in rubles (mandatory)
Salary - the amount of wage costs in rubles (mandatory)
Description - text field with explanations (required)
Completed - the logical field Yes / No (Value Yes (tick) is put at the end of the calculation)

Fields available when viewing a record:
Pension - the sum of expenses for pension insurance contributions in rubles (calculated field using the formula “= ROUND ((Salary * 0.321); 2)”)
General - the sum of overhead costs in rubles (calculated field using the formula “= ROUND ((Salary * 2.18); 2)”)
Amount - the sum of all expenses in rubles (calculated field using the formula “= Semi-finished products + Materials + Salary + Pension + General”)
Completed - an account of an employee of the economic department who performed costing for nonconformity, the field is filled in automatically after saving the item.

Deadline - within 8 working hours of receipt of the notification.

5.1 Check conditions

After the calculation is completed, the conditions are checked and the corrective actions are determined from stage 3 of the process.

If the definition of corrective actions from stage 3 of the process is not fulfilled, the status of the Act is changed to “Definition of corrective actions”.

After the determination of corrective actions by the head of the unit where the discrepancy has occurred, two scenarios are possible:
  1. Costs are zero.
    Transition to stage 5.2 of the process.
  2. Costs are greater than zero.
    Go to stage 6 of the process.


5.2 Check conditions

After checking the conditions for compliance with the type of the “Input control” act and the “Return to supplier” JCC solution, 2 scenarios are possible:

  1. Input control - No.
    Go to stage 9 of the process.
  2. Input control - Yes.
    Transition to stage 8 of the process.


6. Decision Making by Chief Engineer

After performing the cost estimate, determining the corrective actions, and if the costs are greater than zero, an item is automatically created in the “Cost Matching” list (https://portal.domain.ru/SiteDirectory/quality/Lists/List10) and a notification is sent to the Chief Engineer. The status of the Act is changed to “Coordination by the Chief Engineer”.

The chief engineer must decide where to include the costs associated with the discrepancy.

When changing an entry in the list, the following fields are filled:
To attribute costs - the choice of the value On the culprit / On the production / On the supplier (mandatory)
Comment - text box with explanations (required)

Fields available when viewing a record:
Decided - the account of the Chief Engineer who made the decision on the allocation of costs associated with the discrepancy, the field is filled automatically after saving the item.

At the stage of approval of the decision, two scenarios are possible:
  1. The chief engineer decided to assign the cost of production or perpetrator
    Go to stage 7 of the process.
  2. The chief engineer decided to charge the cost to the supplier
    Transition to stage 8 of the process.


Deadline - within 4 business hours of receipt of the notification.

7. Closing the Act

After the decision is made by the Chief Engineer for the allocation of production costs, the status of the Act is changed to “Closed”, notifications are sent to the Quality Department, the Economic Department, Accounting and the Head of the unit where the discrepancy has occurred.

The head of the department must print the Act, sign it himself, take the signature from the culprit, sign it with the chief engineer and transfer the Act to the accounting department.

Deadline - within 8 working hours of receipt of the notification.

8. Making a claim

After the decision is made by the Chief Engineer to assign costs to the supplier or in the absence of costs, but with the decision of incoming control to return to the supplier, the status of the Act is changed to "Claim processing", an entry is automatically created in the list "Claim results" (https: //portal.smz .ru / SiteDirectory / quality / Lists / List12), a link to the print form of the claim is formed, notifications are sent to the Quality Department, the Chief Engineer, the Economic Department and the Head of the subdivision where the discrepancy has occurred.

The chief engineer must print out the Claim, sign, put the stamp of the company and transfer the Claim to the Head of the department responsible for the supply of non-conforming products.

Go to stage 10 of the process.

9. Closing the Act

After calculating the costs and determining the corrective actions, the status of the Act is changed to “Closed”, notifications are sent to the Quality Department, Chief Engineer, Economic Department and Head of Department, where there is a discrepancy.

10. Claim processing

The head of the unit responsible for this delivery sends the Claim to the supplier, carries out all the necessary activities related to the return of non-conforming products and, based on the results of the work, makes changes to the corresponding entry in the "Results of the claim" list (https://portal.domain.ru/SiteDirectory/quality / Lists / List12).

When changing an entry in the list, the following fields are filled:
Claim satisfied - select Yes / No / Partial / Decision cancel (mandatory)
Comment - text box with explanations (required)

Fields available when viewing a record:
I made a decision - the account is the Head of the department who reported on the processing of the Claim, the field is filled in automatically after the item is saved.

At the stage of processing the claims, there are three possible scenarios:
  1. Result of Satisfying Claims - Yes
    Go to stage 11 of the process.
  2. Result of satisfaction of the Claim - No or Partially
    Go to stage 12 process.
  3. Result of satisfaction of the Claim - Cancellation
    Go to stage 2 process. All changes are discarded and a new solution is created for the head of the quality department. The status of the Act is changed to "Decision of the head of the JCC". The previous decision, costing and all approvals are kept for the history.

Term - within 30 days from the date of receipt of the notification.

11. Closing the Act

The claim is fully satisfied, the status of the Act is changed to “Closed”, notifications are sent to the Quality Department, Chief Engineer, Economic Department and Accounting.

12. Closing the Act

The claim is partially satisfied or not satisfied, the status of the Act is changed to “Closed”, notifications are sent to the Quality Department, Chief Engineer, Economic Department, Accounting and Legal Counsel.



Promised pictures


The host home page contains web parts targeted to different user groups. Web Parts display items that are addressed to the user and require a response.
SharePoint Home Page

The Act Viewer page contains a form for viewing an element that displays the required fields, as well as web parts, linked lists displaying all elements related to this act.
Marriage Act Review Page

The printed form of the act (for example, is necessary in the case of recovery of damage from the perpetrator)
Marriage Act Printed Form

The printed form of the claim to the supplier (formed in the case of an act of input control and the allocation of costs to the supplier)
Printed Supplier Claim Form

Summary


The introduction of such a process has reduced the processing time of the act to 1-3 days. Naturally, increased transparency and controllability of the process. The process has become tangible, measurable and accordingly controlled. As a result, the personal responsibility of the participants involved has increased. Significantly reduced the amount of manual labor, even from such a simple thing as printing a claim to the supplier. When processing a claim, the legal adviser can respond in a timely manner, reducing losses, and any process reporting is available to management in real time.

Labor costs - 2-3 weeks of specialist work. Do you consider the cost of implementation yourself?

I have a lot of similar cases, to continue? :)

Source: https://habr.com/ru/post/281356/


All Articles