Skip to content

On demand · Product video

Block and unblock lots automatically with Quality Inspector

For quality and warehouse teams that want received lots held until they pass inspection, without blocking and unblocking them by hand.

Recorded May 31, 2023 · 9 minutes

Quality Inspector automatic lot blocking video thumbnail

Summary

Quality Inspector can block a lot when a test is created and unblock it when the test passes, using Business Central workflows. The video sets up a test that is created when a receipt is posted, turns on workflow integration in the Quality Inspector setup, and builds a workflow that blocks the lot on the test whenever a quality inspection test is created. A second workflow unblocks the lot when the test is finished with a pass grade. The video receives a lot, shows it blocked, and shows it stay blocked after the values pass until the test is finished.

Key topics

  • Turn on workflow integration in the Quality Inspector setup
  • Block a lot whenever a quality inspection test is created
  • Unblock the lot when the test is finished with a pass
  • Know why to wait for the finished state, not the grade alone
Read the transcript

In this video we’re going to review how to use quality inspections to automatically block a lot and unblock a lot. The very first thing is the Quality Inspector setup, which we’ve configured to create a test whenever a receipt is posted. This tells the system that whenever we post a receipt, it should automatically create a test. The second step is to have a test. We make sure we have a quality inspection template; in our case it’s a receipt example that asks a few questions, and it has a test generation rule connected to the purchase line with no conditions. That effectively matches any purchase line, so this creates a test for anything we receive in the system.

That’s the background. Now, to automatically block the lot on receipt and automatically unblock it as soon as that test is passed, we use Business Central workflows. Before we do that, in the main section of the Quality Inspector setup there’s a workflow integration setting that you want enabled. This enables specific events, like when a test is created or finished, and some quality inspection responses as well.

Then we navigate to Workflows, create a new workflow, and call it Automatically Block Lot with a Test. Any time we create a quality inspection test for a lot, this automatically blocks it. It doesn’t matter whether the test is created ad hoc, manually, automatically, through Power Automate, or through another workflow; when the test is created, it automatically blocks that lot. We look for the event when a quality inspection test is created. If you want to get fancy, you could say you only care when the template is specifically the receipt example. If you want to block a lot regardless of which template is used, leave it blank. We’ll leave it blank to keep it simple.

Then we choose to block the lot in the test. You’ll notice there’s no extra configuration, because it uses the lot that’s already on the test. This does require that the lot is known when the test is created. A scenario where that may not work would be something like releasing a document, because the lot number could be in flux or not yet known at that point. That’s the general premise, and we enable it. So however the test is created, whether with a button, through Power Automate, through a Business Central workflow, or through the built-in automation for receipts, this workflow runs and blocks the lot in the test.

Let’s see that in action. We create a new purchase order for Progressive Home Furnishings and choose a lot-tracked item, our handy ethernet cable. I’m using the Green location because it happens to have some inventory, and we’re receiving a dozen ethernet cables. We happen to know the lot number ahead of time, so we enter it, based on the time, 11:58 AM, and that’s the lot we use. We release it. This location requires warehouse receipts, so we create the warehouse receipt. At this point there’s still no quality inspection test, because we haven’t posted it.

As soon as we post it, it creates a quality inspection test, in this case for this one item, and that in turn triggers the workflow to automatically block that lot. We post the receipt. It’s created that test for that lot number, and the state is in progress. If we navigate to the lot number information card, we see that the 11:58 AM lot is automatically blocked. That was all done automatically by the system.

To unblock it automatically, we head back into Workflows. You can obviously unblock it manually if you want to, but we could say that whenever the test is passed and finished, we automatically unblock it. We create a workflow called Automatically Unblock Lot and put it in our Quality Inspection examples. This time it’s not when a quality inspection test is created; instead it’s whenever the quality inspection test is finished.

The reason we look for the finished state is that the grade of the test can change as you’re entering it. The grade on the test updates automatically any time you change a value, so it could have a pass value but not be finished yet. We don’t want this to happen just whenever the test is set to pass, because you might change a value back to the fail state, and it would already have unblocked the lot. So we do it when the test is finished, and only when the grade is pass. Then we tell it to unblock the lot, choose OK, and enable it.

Now the system knows that whenever a quality inspection test is finished and the grade code is pass, it can unblock the lot. Let’s test that out. We open our receipt example test and change it to a pass state: we enter 20, today’s date, and “hello.” Now all of the individual grades on the test lines have passed, and the quality inspection test itself has passed, but it’s still open. At this point the lot number should still be blocked, and when we check, it is.

Now we finish the test, and because the test has a pass grade, it should automatically unblock that lot. If we navigate back to lot number information, we see that the lot number is now unblocked. So that’s one way to automatically block and unblock a lot in Business Central using Business Central workflows. You can also do this with Power Automate. We have dispositions available for Power Automate, and all of those API methods are also available with low code.

Questions about this webcast?

Send your question and the Insight Works team will reply by email. Ready to plan a project? Contact your Microsoft Partner.

Ask a question

Webcast Questions