Skip to main content
Try for free

How to Use AQL (Acceptable Quality Level) in Cetec ERP

Set up your AQL sampling plan once, and Cetec fills in the sample size on inspections from the AQL and the lot size.

Updated Nov 9 2026

How to Use AQL (Acceptable Quality Level) in Cetec ERP

Allow external media cookies to watch this video.

Before you start

  • Setting up the plan is done in Admin > Maintenance > Data Maintenance. You need the Can Edit Maintenance function (the Maintenance role by default; Admin always), or access to the AQL table through your role.
  • Incoming Inspections is under Warehouse > Receiving and is shown to the Warehouse role.
  1. Set up the AQL table

    1. Go to Admin > Maintenance > Data Maintenance.
    2. Click the filter search bar (Filter or search…), choose Data Type, type AQL and click Apply (1). The chip reads Data Type is AQL.
    3. Click AQL (Acceptable Quality Level). The page Data Maintenance For AQL (Acceptable Quality Level) opens with the columns Inspection Type, Aql, Lot Size and Sample Size.
    4. Click Add Record. Cetec saves a new row straight away (Rows Created: 1) and shows it at the top of the table with Inspection Type set to Default.
    5. Fill in the row:
      • Inspection Type: which inspections the row is for.

        Inspection TypeUsed on
        IncomingIncoming (receiving) inspections
        In ProcessWork order inspections
        Kit AuditKit audits on the work order
        DefaultAny of the three, when no row of that inspection's own type matches
      • Aql: the AQL, for example 1.0 or 2.5.

      • Lot Size: the range of lot quantities the row covers, from the first box to the second. Leave the second box (over) empty for "and above".

      • Sample Size: how many to inspect for that range.

    6. Click Submit. Cetec saves the row without a message; the numbers come back with five decimals, for example 1.00000.
    7. Add one row per lot-size range, and repeat for each AQL you use. Add Record is greyed out until you've clicked Submit for the row you added.

    A row you added but don't want stays in the table, even empty: tick its Delete box and click Submit to remove it.

    Ranges for the same Inspection Type and Aql can't overlap. If they do, Submit is refused with Lot size range overlaps another row for the same inspection type and AQL (row id n, range …), which names the row it clashes with. The page reloads with the saved values, so retype your change.

  2. Use AQL on an incoming inspection

    1. Go to Warehouse > Receiving > Incoming Inspections. The Incoming Inspections list shows recent inspections. To find an older one, click the filter search bar (Filter or search…), choose a field such as PO, Prcpart or Status, set it and click Apply (n).
    2. Click the inspection's number to open it.
    3. In AQL Value, pick an AQL from the drop-down. It lists the Incoming and Default rows with their lot ranges, for example 1 (Lot: 1 - 500) or 1 (Lot: 3201 - Infinity); Default rows start with Default:. You're choosing the AQL only: Cetec picks the row from the AQL and the Lot Size, whichever range you clicked. The drop-down only lists AQLs that contain what's in the box, so when an AQL is already set (say 1) you see only rows matching it; clear the box to see every row, including the Default ones.
    4. Check Lot Size. On an inspection that has no lot size yet, it starts at the receipt's Qty Received; if one was already saved (even 0), it keeps it. Enter your lot quantity.
    5. Sample Size fills in from the AQL table about half a second after you change the AQL or lot size. You can type over it. If no row matches, it shows 0.
    6. Before you save, check that Sample Size fits the lot. It only updates while Lot Size is 1 or more: clearing the lot size or setting it to 0 leaves the last sample size in place.
    7. Finish the inspection as usual and click Submit (bottom right). Cetec shows Incoming Inspection updated and saves the AQL, lot size and sample size on the inspection. Inspected At is set to the time you submit.
  3. Use AQL on work order inspections and kit audits

    Work order inspections (opened from a work instruction step that has an inspection form, in the order's Work view) and kit audits have the same AQL Value, Lot Size and Sample Size fields. They use the In Process or Kit Audit rows (and Default), and Lot Size starts at the quantity still to build on the order line.

    On a work order inspection, the fields only appear when the step's inspection form (a custom form) has fields named aql and sample_size. Ask whoever maintains your custom forms to add them.