Skip to content

On demand · Product video

Move inventory automatically when a test passes in Quality Inspector

For warehouse and quality teams that hold received goods in a quarantine bin and want them moved out as soon as they pass inspection.

Recorded May 31, 2023 · 13 minutes

Quality Inspector move inventory video thumbnail

Summary

Quality Inspector can move inventory based on a test result, in a directed pick and put-away location with lot warehouse tracking. The video sets up a test that is created when a warehouse receipt is posted, picks the warehouse reclassification batch for movements, and shows the manual Move Inventory action for a full lot or a set quantity. It then builds a Business Central workflow that moves the whole lot from the quarantine bin to another bin when a test is finished with a pass. The test is recorded and finished in the Business Central phone app, and the movement shows up in the warehouse reclassification journal.

Key topics

  • Create a test automatically when a warehouse receipt is posted
  • Choose the journal batch used for movements
  • Move a lot out of quarantine with a Business Central workflow
  • Record and finish a test in the Business Central phone app
Read the transcript

All right, in this video we’re going to walk through how to do an inventory movement in a directed pick and put-away location, with lot warehouse tracking turned on, through a Business Central workflow for a quality inspection test. To get started, we’re going to start with the Quality Inspector setup. In the receiving section, we have automation to create a test whenever the warehouse receipt is posted.

In the inventory section, we choose which batch we want to use. In this example we’re using a directed pick and put-away location, so we’re using the warehouse reclassification batch. If your location isn’t directed pick and put-away, you can use a normal item reclassification journal. This is the batch that will be used for any of the movement dispositions, whether from the Quality Inspector workflow or from Power Automate.

The next step is the test itself. We create our test plan with this quality inspection template, and in our example for this receipt we’re collecting a few basic questions: a visual state, a weight, a color, a length, and a height. A pretty easy test to create. We also have a test generation rule, which tells the system which template to use under which circumstances. In our Quality Inspector setup we told the system we want to create a test on receipt, and this test generation rule tells it the circumstances. We’re adding no filters for now, so this effectively says that any time I’m purchasing anything, regardless of the item, create a test.

If you want a test for a specific item, you put the item in the condition filter here, and you can filter on basically any field. You could even filter on item category code, or on vendor item number if you needed to. The item we’re using in our test is also lot warehouse tracked. This lets us use bin contents in a directed pick and put-away location, which is the typical configuration when you’re using directed pick and put-away with lot numbers. I created one very similar to our standard ethernet cable. The only difference is that it has a lot warehouse tracking code, configured with all of the lot flags, but specifically the lot warehouse tracking flag.

So now we’re ready to go. Let’s create a purchase order. We click New, choose our vendor, and choose our item to purchase. It’s coming from the standard CRONUS White location, which is directed pick and put-away, and we’re going for a baker’s dozen of 13. We release the purchase order and create our warehouse receipt. At this point we still don’t have the test.

In the real world you’d be using something like WMS Express or Warehouse Insight to fulfill this receipt on scanning guns. For this demo we’re filling it in manually, but you can improve receipt processes by using barcodes. We’ll enter the lot number, based on today’s date and time, and put in the full 13. Now we post this receipt, and when we post it, it should create that quality inspection test for us automatically. We see it created a put-away for us, because that’s how our location is configured.

In this example we’re going to show how to have the inventory moved automatically, but you can also move it manually with an action here called Move Inventory. You can move either a specific quantity or the full quantity. Let’s say you received 100 of a unit but only needed to quarantine 10 out of that lot; you could put that 10 in here. If you needed to quarantine the entire batch, you could move the entire lot or serial, and regardless of which bin it happens to be in, it pulls the entire quantity out of all of those bins, assuming you have lot warehouse tracking turned on, and moves it into the destination bin.

For lot-tracked items, you really should have lot warehouse tracking turned on if you’re in a directed pick and put-away location. If you’re not in a directed pick and put-away location, you can still use this functionality; typically you’re just changing to a location. In that case you might have a quarantine location in Business Central, and that’s fine as well, as long as you’re not moving between a directed pick and put-away location and a non-directed location, in which case you’d have to use a transfer order.

So we have our quality inspection test. Now we need to post our put-away. We find the put-away that was just created, and we see it’s taking the item from the receiving bin and putting it into this other bin, W-05-06. We register that put-away, and now those bin contents are in the bin we’re going to move them from.

Now we’ll review what happens when the quality inspection test passes. To have a transaction like a move happen as soon as a test is passed, we use a Business Central workflow. We navigate to Workflows, create a new workflow, call it Move to Another Bin, and put it in our Quality Inspection examples. We say that when the test has finished and the state is pass, do something. You could use any other state. You could do the opposite and move it to a discard bin or a quarantine bin if you chose. We’re using pass because we’ve received it into a receiving bin, put it away into a quarantine bin, and now we want to move it out of quarantine as soon as it passes.

So when it’s finished and passed, we move the inventory from that test. You’ll notice these options are very similar to the manual option. Even though you do have a specific quantity option here, typically you’d move the entire lot in this circumstance, so we’re moving the entire lot. We’re still in the White location, and we move it from the quarantine bin to the first bin we see in the White location. We’re not going to post it immediately; we’ll just create the journal entries for now. We choose OK and enable it. Now whenever this quality inspection test has passed and we’ve finished it, it automatically moves that inventory.

Now let’s record that test. We’re recording it in the Business Central phone app, using a special role center for Business Central. This is the normal Business Central phone application, and we’re just using a role center optimized for the phone. You can use the normal role center, and we’ve also got another one for tablets, but it’s the same net effect. The phone one has a layout that’s a little more optimized for this activity.

The first thing we do is pick up the test, which assigns it to ourselves. On this view we can see that these tests are all assigned to me. I can unassign it, give it to somebody else, or things of that nature, but right now we’ve assigned it to ourselves. Now we fill in the values. We choose a visual state with no marks, record the weight as 23, the color as blue, the length as 23 again, and the height as 56.

Once we’ve recorded it, the test has entered the pass state, but you’ll notice that it’s still open. At this point there’s still no journal entry for the movement, which lets a quality inspector edit their values before deciding to finish. Now we finish the test. It asks if we’re sure, and as soon as we click Yes, it creates that journal entry behind the scenes.

Let’s go see what it did. We navigate back to Business Central and find the same warehouse reclassification journal, which is Default, and we see that it created a movement from that bin to the bin we chose in the Business Central workflow. So that’s an end-to-end example: we received into a directed pick and put-away location with lot warehouse tracking, received into our receive bin, put it away into our quarantine bin, and once the test passed, moved it from our quarantine bin to another bin.

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