Inspection Dashboard

This dashboard program is used by quality managers to view inspection information, e.g. test results and inspection quantities.

Exploring

Things you can do in this program include:

  • View the results of the sample tests and inspection tests

  • View the data entered or selected by the inspector

  • View the stock quantities that passed or failed the inspection

This program is accessed from the Program List of the SYSPRO menu:

  • Program List > Quality Management > Inspection

The acceptance quality limit is the level of defect that the business can accept in its product.

AQL sampling helps a business determine whether to accept or reject an order based on the number of defects found in the sample size. Every business needs to decide what the critical, major and minor defects are on its components, and what level of defects it can accept in its processes.

You can specify the accept / reject quantity for critical, major and minor defects within the Acceptance Quality Limit program.

The inspection test, also called inspection level test, is the test for the actual inspection of an individual item. Inspection tests are assigned to the sample test, which includes all inspection tests of the item. Once all individual inspection tests are done, the sample test is complete.

The test data, status and results of the individual inspection level tests are saved within the SqmIndTest table.

This encompasses the entire inspection that is performed on a purchase order or job that is received into inspection.

The inspection data, status and the results are saved within the SqmInspect table.

The sample test consist of one or more inspection tests, depending on the number of items that will be inspected, i.e. depending on the size of the sample taken from the entire batch that is received into inspection. A sample test is created for each item that is inspected and actual inspection tests of individual items are assigned to the sample test.

The test data, status and results are saved within the SqmTestStatus table.

Traceability refers to the ability of an organization to verify the history, location, or application of an item based on documented identification records.

Traceability is required in certain industries for a number of reasons:

  • Stock control

  • Asset control

  • Order tracking

  • Food Recall (e.g. being able to trace and account for every unsafe food item suspected of contamination; ranging from items still in the warehouse to those dispatched to customers).

WIP is an abbreviation used for work in process, work in progress, goods in process, or in-process inventory which are a company's partially finished goods waiting for completion and eventual sale. These items are either just being fabricated or waiting for further processing in a queue or buffer storage.

Topics

Inspection Engine

Starting

You restrict operator access to activities within a program using the Operator Maintenance program.

Controls whether the inspection information (e.g. inspection quantities, sample and individual test results, etc) can be viewed using the Inspection Dashboard program.

You can restrict access to the eSignature transactions within a program at operator, group, role or company level (configured using the Electronic Signature Configuration Setup program).

Electronic Signatures provide security access, transaction logging and event triggering that gives you greater control over your system changes.

Controls access when viewing the status of an inspection within the Inspection Dashboard program.

Controls access when viewing the inspection quantities within the Inspection Dashboard program.

You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).

You can restrict operator access to programs by assigning them to roles and applying access control against the role (configured using the Role Management program).

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

To use this feature, the following setup option(s) must be enabled:

Program List > Inventory > Setup - Tracking pane:

  • Quality management

    • QM inspection required

  • Lot traceability control

    • Lot traceability

      This must be defined as Inspection required.

    • Traceable

      This must be defined as With inspection.

    • Allow issues from multiple lots

Solving

The Inspection Engine uses the GRN (goods received number) or WIP inspection reference number as the inspection number.

If the Inspection Engine is used, the value at the Type key field in the SqmInspect table will consist of the GRN number, lot number (if applicable) and a P for purchase order inspections or the WIP reference number, lot number (if applicable) and a W for WIP inspections.

Using

  • Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.

  • Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.

    The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.

    If the Show Captions option is grayed out, it means no captions are hidden for that form.

  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

The following are possible status codes for a sample inspection test used within the Quality Management:

Status Description

N - Not started

This status is displayed when none of the individual tests assigned to the sample test have been started.

The Result column in the listview reflects the status of the inspection test as {blank} - In progress.

I - In progress

This status is displayed once one of the individual tests assigned to the sample test have been started.

The Result column in the listview reflects the status of the inspection test as {blank} - In progress.

F - Complete / Failed

This status is displayed once all individual tests assigned to the sample test have been completed.

If the sample test failed the inspection, then the Result column in the listview reflects the status of the inspection test as N - Failed inspection.

P - Complete / Passed

This status is displayed once all individual tests assigned to the sample test have been completed.

If the sample test passed the inspection, then the Result column in the listview reflects the status of the inspection test as Y - Passed inspection.

The inspection sample test statuses are saved within the SqmTestStatus table and displayed at the Status field within the Inspection Test Queue program.

The individual inspection level test statuses are saved within the SqmIndTest table and the status is displayed at the Result column within the Inspection Test Queue program.

The following are possible status codes for a Quality Management inspection test:

Status Description

{blank} - In progress

This status is displayed while the inspection is still taking place.

When an inspection is placed on hold using the Inspection Test Queue program, the Inspection status is displayed as {blank} - In progress and the Inspection on Hold field reflects Yes.

If the stock code (inspected during the Quality Management inspection) is placed on hold, the Inspection status is displayed as {blank} - In progress and the Stock code on Hold field reflects the stock code status, i.e. Full hold.

N - Failed inspection

This status is displayed when the inspection has been completed, but the inspection criteria weren't met and the QMS inspection failed.

Y - Passed inspection

This status is displayed when the inspection has been completed and approved.

The inspection test statuses are saved within the SqmInspect table and the status is displayed at the Inspection status field and the Result column within the Inspection Test Queue program.

The following are possible status codes for a QM inspection used within the Quality Management:

Status Description

R - Not started

When a job is moved into inspection, the status of the QMS inspection is displayed as R - Not started as the count transaction must first be performed.

Y - In progress

This status is applied once the count transaction has been completed.

C - Complete

This status is displayed once all the sample tests and the QMS inspection have been completed.

N - Not required

This status code is displayed when a stock code is selected that requires inspection, and the QM inspection required option at the Tracking pane within the Stock Code Maintenance program is not enabled (i.e. the inspection will not be done using the Quality Management module).

{blank} - Not required

This status code is displayed when the Quality Management module is not installed.

For purchase order inspections, the inspection statuses are saved within the InvInspect table and displayed at the Inspection status field of the Purchase Order Inspection program.

For Work in Progress inspections, the inspection statuses are saved within the WipInspect table and displayed at the QMS inspection status field of the WIP Inspection program.

Referencing

This lets you select the stock code for which you want to view inspection test results.

This lets you include completed inspection tests on the dashboard.

This lets you include archived inspection tests on the dashboard.

Field Description

Inspection type

PO inspections indicates that this is a purchase order inspection.

WIP inspections indicates that this is a work in progress inspection.

GRN

This indicates the GRN number that is used as the inspection reference number.

WIP inspection reference

This indicates the inspection reference number for WIP inspections.

Lot

This indicates the lot number of the stock item that is assigned to the inspection.

Wh

This indicates the warehouse for which the stock inspection was done.
Purchase order This indicates the purchase order number for which the inspection is done.

Job

This indicates the WIP job number for which the inspection is done.
Revision

If the stock code is defined as an ECC-controlled item, then this field indicates the revision number for the stock item.

The wording displayed for this field defaults to Revision, but is replaced by whatever wording you have assigned to the Revision setup option field.
Release

If the stock code is defined as an ECC-controlled item, then this field indicates the release number for an ECC-controlled item.

The wording displayed for this field defaults to Release, but is replaced by whatever wording you have assigned to the Release setup option field.

This lets you add free format notes using the Admin Notepad Editor (Rich Text) program.

Field Description

Sample Test

This indicates the sample test number.

The number of sample tests per inspection depends on the sample quantity that is calculated by the system.

Status

This indicates the status of the sample test.

QM inspection

This indicates the QM inspection number, which is either the GRN (goods received number) for purchase order receipts or the WIP inspection reference number for WIP receipts.

Reject critical

Yes indicates that the sample test failed the inspection due to a critical defect.

No indicates that the sample test passed the inspection as the stock item had no critical defect.

Not required indicates that no inspection test for critical defects was assigned to the sample test.

In progress indicates that the sample test has not been completed.

Reject major

Yes indicates that the sample test failed the inspection due to a major defect.

No indicates that the sample test passed the inspection as the stock item had no major defect.

Not required indicates that no inspection test for major defects was assigned to the sample test.

In progress indicates that the sample test has not been completed.

Reject minor

Yes indicates that the sample test failed the inspection due to a minor defect.

No indicates that the sample test passed the inspection as the stock item had no minor defect.

Not required indicates that no inspection test for minor defects was assigned to the sample test.

In progress indicates that the sample test has not been completed.
Sample passed

Yes indicates that the sample test passed the inspection.

Start date

This indicates the start date of the sample test.

End date

This indicates the end date of the sample test.

Expected end date

This indicates the date the sample test is expected to end.

Inspector

This indicates the name of the inspector assigned to the sample test.

Number of tests

This indicates the total number of tests that must be carried out on the stock item.

Serial

This indicates the serial number of the stock item that is assigned to the inspection.

Tests complete

This indicates the number of tests that have been carried out on the stock item.

This pane displays the test results of the test selected at the Sample Tests pane.

As the fields in this pane that are already described at the Sample Tests pane, they aren't listed again.

This displays the Inspection Test window that the inspector completed (or that is still incomplete when test is still in progress).

This lets you see which options the inspector selected or entered when they inspected the stock item.

Field Description

QM inspection

This indicates the QM inspection number, which is either the GRN (goods received number) for purchase order receipts or the WIP inspection reference number for WIP receipts.

Lot

This indicates the lot number of the stock code that is inspected.

Stock code

This indicates the stock code that is inspected.

Description

This indicates the description of the stock code that is inspected.
Revision

If the stock code is defined as an ECC-controlled item, then this field indicates the revision number for the stock item.

The wording displayed for this field defaults to Revision, but is replaced by whatever wording you have assigned to the Revision setup option field.
Release

If the stock code is defined as an ECC-controlled item, then this field indicates the release number for an ECC-controlled item.

The wording displayed for this field defaults to Release, but is replaced by whatever wording you have assigned to the Release setup option field.

Warehouse

This indicates the warehouse for which the inspection was done.

Branch

This indicates the branch for which the inspection is done.

Job

This indicates the WIP job number for which the inspection is done.

Purchase order

This indicates the purchase order number for which the inspection is done.

Supply chain type

 Supplier indicates that this is a purchase order inspection.

Customer indicates that this is a work in progress inspection.

Supply chain

This indicates the supplier (for a WIP inspection) or customer (for a purchase order inspection) for which the inspection is done.
Inspection type PO inspect indicates that this is a purchase order inspection.

WIP inspect indicates that this is a work in progress inspection.

Inspection status

This indicates the status of the entire inspection test, which can be {blank} - In progress, N - Failed inspection or Y - Passed inspection.

Inspection complete

Yes indicates that the inspection has been completed, i.e. the inspection test status is C - Complete.

QM inspection document

Select the View document hyperlink to view the inspection document.

Sample basis

This indicates the sample basis selected for the inspection test, which determines the number of items that must be tested.

Sample quantity

This indicates the number of products from the batch that will be inspected.

The sample quantity is calculated by the system using the inspection plan (currently ISO-2859-1) and the inspection level (defined using the Inspection Level Select program).

Quantity inspected

This indicates the sample quantity that has already been inspected.

Inspection status detail

 

Inspection on hold

Yes indicates that the inspection has been placed on hold.

Hold reason

This indicates the reason why the inspection was placed on hold.

Stock code on hold

Yes indicates that the stock code has been placed on hold.

Stock code hold reason

This indicates the reason why the stock code was placed on hold.

Inspection quantities

 

Inspection quantity

This indicates the entire purchase order or job quantity that was received, counted and placed into inspection using the Purchase Order Receipts or WIP Inspection Maintenance programs.

Unit of measure

 This indicates the stock code's unit of measure.
Inspection details  

Inspection level

 This indicates the inspection level (i.e. currently GI, GII or GIII of plan type ISO-2859-1) that is used to determine the sample size of an inspection.

Full test required

 Yes indicates that every sample must be tested irrespective whether the previous sample tests have caused the inspection test to pass or fail.

Warehouse description

This indicates the description of the warehouse.

Inspection dates

 

Inspection start date

This indicates the start date of the inspection.

Inspection end date

This indicates the end date of the inspection.
Field Description
Inspection details  

Inspection level

 This indicates the inspection level (i.e. currently GI, GII or GIII of plan type ISO-2859-1) that is used to determine the sample size of an inspection.

Sample basis

This indicates the sample basis selected for the inspection test, which determines the number of items that must be tested.

Unit of measure

 This indicates the stock code's unit of measure.
Inspection quantities  
Quantity in inspection

This indicates the entire purchase order or job quantity that was received, counted and placed into inspection using the Purchase Order Receipts or WIP Inspection Maintenance programs.

Sample quantity

This indicates the number of products from the batch that will be inspected.

The sample quantity is calculated by the system using the inspection plan (currently ISO-2859-1) and the inspection level (defined using the Inspection Level Select program).

Quantity inspected

This indicates the sample quantity that has already been inspected.

Quantity passed

This indicates the quantity of stock items within this inspection that passed the inspection test.

Quantity failed

This indicates the quantity of stock items within this inspection that failed the inspection test.