Tracking Test Results by Batch in Abel

Posted on 06.07.2023 by Rik

Print Article

A problem many food manufacturers face is tracking multiple test results per batch for products that require exacting standards. Many rely on spreadsheets for this task, with all the attendant problems: manual maintenance; risk of errors and lack of integration with other systems and processes.

For products that require testing to ensure they conform to quality standards or country of eligibility requirements, Abel captures test results per-batch from internal testing or from external laboratories. Capturing test results in Abel replaces error-prone manual processes and provides visibility of the results to key processes that rely on them.

Recording test results in Abel

Abel provides file imports for test results from internal or laboratory testing. We offer a generic test result load, whereby we map an external test result file to Abel’s load format. We’ve also developed test result file imports for a number of external laboratories (please enquire). This means we can tailor new imports relatively quickly to suit most requirements.

Testing and result recording processes are most often used for:

  • Natural ingredients, such as milk or other animal products where the composition of the raw materials can vary
  • Manufactured products that must meet strict product specifications, such as baby formula
  • Products that require different specifications to meet different countries’ regulations
  • Products that can change their composition over time in storage and must be re-tested regularly (and re-graded or re-valued as a result eg: honey).

Batches of product are tested either in-house or by external laboratories. Test results are recorded against each batch. Depending on test results, batches may be suitable for certain export markets, may require re-grading, may require additives or may be rejected as unsuitable.

Viewing test results in Abel

Abel’s batch register screens can be configured to suit particular products. Some operations require multiple batch register screens, configured in different ways for different products or processes. Batch register screens may show test results, country of eligibility data, significant dates, values and other data related to the batch like this example:

Totals for selected Batches

The register screens provide a total that enables you to select combinations of different batches e.g. for blending or other downstream processes. In the batch register, you can select multiple batches and preview the composition that would result if the selected batches were blended. There’s an example in the above screen shot that shows the total of two selected batches.