Out of Stock Products – can I use them?

like implementing Dynamics 365 Field Service for clients in various industries because, in any field service organisation, there are literally dozens (if not hundreds) of rules, approvals and specific processes, and therefore every implementation is unique in many ways. It also underlines how broad and deep the landscape of the product is, to be able to fulfil business requirements in various business verticals.

Photo by ELEVATE on Pexels.com

This article is related to one of those many rules and processes. The question here is:

Do you want system to restrict using an out-of-stock-product or only warn users (field technicians, dispatchers, supervisors etc.)?

An example: Car mechanic (field technician/resource) will need ‘Oil filter’ product to complete a ‘Car Servicing’ Work Order. Currently, there are no Oil filters in the warehouse. Now as the work is being executed, Dispatcher tries to add a filter to work order. At that point:

  1. System can throw an error to say product is not in the warehouse, or
  2. System can let the product be added but warn about stock level.

Note: Approach 2 might seem odd but is actually very common due to challenges in keeping various level of inventory synchronized.

It turns out above scenario is all passing through a simple flag in the system.

The flag

Go to Settings → Purchase tab. There is a flag ‘Use of Products Out of Stock’ with two values: Restrict and Confirm

Play

In our setup, we’ve got a product which currently sits with zero levels in warehouse.

Let’s set the flag to ‘Restrict’. As you try to add this project in a works order, system throws following error:

Let’s just got back and update the flag to Warn. This time when you add the product, it lets you do that with a warning

How does it impact the inventory? It adds the added quantity as -5 (same quantity as mentioned in Work Order Product).

Above commonly-used scenario is implemented using out-of-the-box flag only. Further approvals (as part of the business process) can be added through configurations.


Thanks for reading!

Product Inventory and Work Orders

The two fundamental modules (if you call them) in Dynamics 365 Field Service are Inventory and Work Management. How does Product Inventory works with Work Orders and products consumed in the field, what triggers the change in inventory number, and how does this relate to status of the products – is the topic of this article. So the agenda is to have a look at how products are added, estimated and consumed in the Work Order and how the impact mirros in Product Inventory.

Before jumping on to the system, let’s spend a few minutes on how product inventories are maintained in different businesses from the field service perspective:

  1. You run a business to install network devices, your field technicians carry network devices in vans and once they install at client premises, then inventory numbers are updated
  2. You run a maintenance business and your field technicians are sent out on support tickets to visit client premises and fix installed equipment. At the time of departure from head office/depot, field technicians don’t always know what needs to be carried in the van to fix the equipment so they always carry necessary tools and place extra consumables/materials in the van. In this case, as soon as field technician estimate products to be picked up from the store, inventory numbers are updated to reflect that products are earmarked for the specific support ticket

The difference in these two field service businesses is in the timing of the inventory updates:

  • In the first one, inventory is updated only when products are ‘used’
  • In the second scenario, inventory is updated as soon as it is estimated

Dynamics 365 Field Service supports these both scenarios. The behaviour of the product could be set from the settings. Go to Field Service Settings, click on Other and set ‘Auto Allocate Estimate Products’ to No for the first scenario and Yes for the second scenario

1. Inventory update when products are consumed

Go to Inventory under Field Service app and click on Product Inventory.

Note we have 25 Universal Network Cards available. Let’s create a Work Order Product estimate ‘3’ to be used.

Go back to inventory and you’ll see no impact of this on the inventory numbers.

Open the Work Order Product record again and this time add ‘2’ as the actual quantity and change the status of record as ‘used’.

Go back to inventory to see if inventory numbers are now updated:

They surely did – please note inventory is now updated as 23, thus system deducted the used quantity (2), not the estimated quantity (3).

2. Inventory updates when products are estimated

Go to Inventory under Field Service app and click on Product Inventory.

Note we have 23 Universal Network Cards available.

Next, create a Work Order Product against a work order and let’s estimate ‘5’ to be used

As soon as you save the record, go back to inventory to see the difference:

Inventory numbers are updated to record now only 18 are available while rest of 5 are allocated.

Hope you find this useful, if you have any questions feel free to reach out. I also found product documentation as a good reference for this functionality area.