Inspection Test Queue

This program displays all sample tests that were created using the Inspection Test Design program and allows inspectors to update the tests assigned to them.

The sample tests are saved in the SqmTestStatus table.

Exploring

Things you can do in this program include:

  • View the sample tests that are linked to the selected inspection test

  • Assign serial numbers to the inspection test

  • Assign an inspector to the inspection test and sample tests

  • Add instructions and documents to the inspection test

  • Put the inspection test on hold

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

  • Program List > Quality Management > Processing

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 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 adding a document in the Inspection Test Queue program.

Controls access when adding an expected end date for the sample test within the Inspection Test Queue program.

Controls access when assigning an inspector for the sample test within the Inspection Test Queue program.

Controls access when assigning a serial number for the sample test within the Inspection Test Queue program.

Controls access when using the Amend test function to correct a test within in the Inspection Test Queue program.

Controls access when performing, i.e. posting the inspection within the Inspection Test Queue program.

Controls access when placing an inspection on hold within the Inspection Test Queue 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/defined:

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

You design the inspection test using the Inspection Test Design program.

  1. Enter the test name.

  2. Select the Design test form button to add all the fields that you want to display on the form and for which the inspector will record the results as they inspect the product.

    1. The left-hand side is a preview of the test form.

    2. Enter a description for the field at the Caption field, select a type and appearance detail, then click on Add field.

    3. The field will be displayed in the preview (i.e. left-hand side of the window).

    4. Save your changes once you have added all the fields.

      You will return to the Inspection Test Design window.

  3. In the Inspection Test Design window you can select each field and apply the field metrics, such as the field inspection level, whether validation is required and the tolerances allowed.

  1. Depending whether you are inspecting purchased or manufactured items, receipt items into inspection and count the received quantities using the Purchase Order Receipts or WIP Inspection Maintenance program.

  2. Select the inspection level using the Inspection Level Select program.

    This program will only be displayed if the Sample basis field is defined as Sample quantity within the Inspection Level Review program.

  3. Once the inspection level is selected, the following fields within the Purchase Order Receipts or WIP Inspection Maintenance program are updated:

    • The QM inspection status reflects Y - In progress, as the items have been counted.

    • The number of items that must be inspected is reflected at the Quantity in quarantine field.

  4. Inspect the items and submit the results of the sample tests using the Inspection Test Queue program.

    Once all the quarantined items are inspected and the test results submitted, the Inspection complete field displays Yes and the Inspection status is updated to Y - Passed inspection or N - Failed inspection.

  5. Accept items into stock (or scrap, send for rework, reject, or QM return items) using the the Purchase Order Receipts or WIP Inspection Maintenance programs.

    The QMS inspection status reflects C - Complete.

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.

  1. Depending whether you are inspecting purchased or manufactured items, receipt items into inspection and count the received quantities using the Purchase Order Receipts or WIP Inspection Maintenance program.

  2. Select the inspection level using the Inspection Level Select program.

    This program will only be displayed if the Sample basis field is defined as Sample quantity within the Inspection Level Review program.

  3. Once the inspection level is selected, the following fields within the Purchase Order Receipts or WIP Inspection Maintenance program are updated:

    • The QM inspection status reflects Y - In progress, as the items have been counted.

    • The number of items that must be inspected is reflected at the Quantity in quarantine field.

  4. Inspect the items and submit the results of the sample tests using the Inspection Test Queue program.

    Once all the quarantined items are inspected and the test results submitted, the Inspection complete field displays Yes and the Inspection status is updated to Y - Passed inspection or N - Failed inspection.

  5. Accept items into stock (or scrap, send for rework, reject, or QM return items) using the the Purchase Order Receipts or WIP Inspection Maintenance programs.

    The QMS inspection status reflects C - Complete.

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 displays data according to the selection criteria indicated. The function is enabled when you first load the program and then by selecting the Change Criteria option.

This lets you change the currently configured review criteria.

Field Description

Include

 

WIP inspections

Select this to include inspection tests for the Work in Progress module in the listview.

PO inspections

Select this to include inspection tests for the Purchase Orders module in the listview.

Test complete

Select this to include completed inspections with completed sample tests in the listview, i.e. inspection tests that have the status Y - In progress and at least one sample test within the inspection test that has the status F - Complete / Failed or P - Complete / Passed.

Inspection complete

Select this to include completed inspection tests in the listview, i.e. inspection tests that have the status C - Complete.

Exceeds expected end date

Select this to include inspection tests that have not been completed by the expected end date, i.e. the expected end date has lapsed and the inspection test status is R - Not started or Y - In progress.

Expected end date

Select this to include inspection test in the listview that have a specific expected end date.

Stock code on hold

Select this to include inspection tests for stock codes that have been placed on hold.

Inspection on hold

Select this to include inspection tests that have been placed on hold.

Warehouses

This lets you select the warehouse(s) for which you want to perform an inspection.

Stock codes

This lets you select the stock code(s) for which you want to perform an inspection.

WIP inspection

This lets you select the WIP inspection reference number for which you want to perform an inspection.

Jobs

This lets you select the job(s) for which you want to perform an inspection.

GRN

This lets you select the GRN number(s) for which you want to perform an inspection.

Purchase orders

This lets you select the purchase order(s) for which you want to perform an inspection.

Inspectors

This lets you select the inspector(s) to whom the inspection tests were assigned that you want to view in the listview.

Sample tests

This lets you select the sample test(s) for which you want to view the inspection tests in the listview.

This lets you assign a serial number to the selected inspection test.

This lets you assign an inspector the selected inspection test.

This displays the Expected End Date window where you can specify an end date by which the selected inspection test must be completed.

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

Field Description

Inspection type

 PO inspect indicates that this is a purchase order inspection.

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

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 item that is assigned to the inspection.

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.

Start date

This indicates the start date of the sample test.

Expected end date

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

No. of tests

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

Completed tests

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

Status

This indicates the status of the sample test.

Inspector

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

Critical

This indicates the status of the sample test for the critical defects.

Major

This indicates the status of the sample test for the major defects.

Minor

This indicates the status of the sample test for the minor defects.

End date

This indicates the end date of the sample test.

Result

This indicates the status of the completed sample test.

Serial

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

Special instructions

This indicates any instructions for the inspector who inspects the sample.

You can enter instructions using the Instructions button at the Sample Tests pane.

This lets you capture the test results of each sample test.

This lets you assign an inspector to the inspection test.

This lets you maintain or amend the inspection test.

Field Description

Inspection type

 PO inspect indicates that this is a purchase order inspection.

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

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.

Sample test

This indicates the number of samples that will be tested.

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).

Test name

This indicates the name of the test that will be used for the inspection.

Test version

This indicates the version of the test that will be used for the inspection.

Start date

This indicates the start date of the inspection.

End date

This indicates the end date of the inspection.

Status

This indicates the status of the QM inspection test.

Inspector

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

The fields in this pane that were already described at the listview panes, aren't listed again.

This displays the Inspection Hold Status window where you can place the inspection on hold and enter the reason the inspection has been placed on hold.

This displays the Inspection Document window where you can select a file that you want to attach to the inspection.

This lets you remove an attached document from the inspection. You will be prompted to confirm that you want to remove the document.

Field Description

Stock code

This indicates the stock code for which you are maintaining the inspection level.

Stock code description

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

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 complete

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

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 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

 

QM inspection document

Select the View document hyperlink to view the inspection document.

You can attach a document using the Attach document button at the Inspection Details pane.

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.
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 you are maintaining the inspection level.

Warehouse description

This indicates the description of the warehouse.

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.

Branch

This indicates the branch 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 you are maintaining the inspection level.

Inspection dates

 

Lot

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

Inspection start date

This lets you specify the start date of the inspection.

Inspection end date

This lets you specify the end date of the inspection.