Case study 1 Product information management and inventory management

Objectives

Create and manage products.
Manage inventory pricing and costing.
Configure inventory management.
Manage and process inventory activities.

Scenario

Company Information

USMF is a United States company that manufactures products for several different industries and has a diverse portfolio of products.

Business Challenges and Requirements

USMF recently implemented Dynamics 365 Supply Chain Management. They hired a new full-time team to manage the warehouse and inventory, the new staff doesn’t have Dynamics 365 Supply Chain management knowledge.

Your Role

You are the Dynamics 365 Supply Chain Management functional consultant that implemented the solution. You are called to help the new staff in multiple areas.

Exercise #1 Adding products to a new warehouse using basic inventory management

Objective: Add products to a new warehouse using basic inventory management.

You are the supply chain management functional consultant on a project team advising your customer on best way to create new warehouse to store the overflow of new products.

Your customer is managing a small warehouse that does not require the full capabilities of warehouse management systems (WMS).

you and the Solution architect are in favor of using basic inventory management to help them creating the new warehouse.

What would you do?

Set the default location capacity

Access the Microsoft Dynamics 365 Supply Chain Managment website and log in with your user credentials.
On the Finance and Operations dashboard page, expand the left navigation pane and select the Inventory management under the Modules tab.
On the Inventory management page select the Setup > Inventory and warehouse management parameters.
Select the Locations tab.
In the Standard width field, enter 450.
In the Standard depth field, enter 250.
In the Standard height field, enter 200.
Select Save.
Close the page.

Define the location name format

On the Finance and Operations dashboard page, expand the left navigation pane and select the Inventory management under the Modules tab. On the Inventory management page select Setup > Inventory breakdown > Warehouses.
Select New.
In the Warehouse field, enter 17.
In the Name field, enter Raw materials.
In the Site field, select the drop-down button to open the lookup.
In the list, find and select site 1.
Expand the Location names section. The options in this section define the default format for location names. In our example, we’ll include the aisle number, rack number and shelf number.
Set the Include aisle option to Yes.
Set the Include rack option to Yes.
In the Format field, for the rack, enter -##
Set the Include shelf option to Yes.
In the Format field, for the shelf, enter -##
Select Save.

Define warehouse locations

On the Action Pane, select Warehouse.
Select Location Wizard.
On the Welcome screen, select Next.
De-select the Outbound docks option.
De-select the Bulk locations option.
Select Next.
On the Create inventory aisles screen, select Next.
On the Edit and delete aisles screen, select Next.
On the Create inbound docks screen, select Next.
On the Edit and delete inbound docks screen, select Next.
On the Create picking locations screen, select Next.
Review the physical dimensions shown on the the Specify additional information for all your picking locations screen and select Next.

Note The physical dimensions shown on this page are the ones that you set at the start of this procedure.
On the Edit and delete picking locations screen, select Next.
Select Finish.
Close all pages.

Exercise #2 Creating a standard cost version that uses a specific model group

Objective: Create a standard cost version to record certain model group products.

The warehouse employee at USMF, need to create a standard cost version to record products that use the item model group with inventory model of Standard. The items must be grouped based on FIFO inventory model.

What would you do to help this employee?

Create cost version

Go to Cost management > Predetermined cost policies setup > Costing versions.
Select New.
In the Costing type field, select Standard cost.
In the Version field, enter SeahorseST.
In the Name field, enter Seahorse Standard Costing.
In the Block activation field, select No.
Select Save.
Close the page.

Create item model group

Go to Cost management > Inventory accounting policies setup > Item model groups.
Select New.
In the Item model group field, enter STDN.
In the Name field, enter Standard Cost.
In the Inventory model field, select Standard cost.
Expand the Inventory policies section.
In the Approved vendor check method field, select No check.
Select New.
In the Item model group field, enter FIFO2.
In the Name field, enter FIFO 2.
Select Save.
Close the page.

Create tracking number group

Go to Inventory management > Setup > Dimensions > Tracking number groups.
Select New.
In the Number group field, enter ASer.
In the Name field, enter Auto-Serial.
Turn off the Date toggle to No.
Turn off the Lot ID toggle to No.
Turn on theNumber sequence No. toggle to Yes.
Turn on the Only for inventory transactions toggle to Yes.
Turn on the On physical update toggle to Yes.
Select New.
In the Number group field, enter USer.
In the Name field, enter Unique-Serial.
Turn off the Date toggle to No.
Turn off the Lot ID toggle to No.
Turn on the Number sequence No. toggle to Yes.
In the Number sequence code field, choose any number sequence of your choice.
Turn on the Only for inventory transactions toggle to Yes.
Turn on the On physical update toggle to Yes.
Set Per qty. to 1.
Select New.
In the Number group field, enter Batch.
In the Name field, enter Auto Batch.
Turn off the Date toggle to No.
Turn off the Lot ID toggle to No.
Turn on the Number sequence No. toggle to Yes.
In the Number sequence code field, choose any number sequence of your choice
Turn on the Only for inventory transactions toggle to Yes.
Turn off the On physical update toggle to No.
Close the page.

Exercise #3 Adding and releasing new products to a warehouse

Objective: Add new products with and without variants.

Some new products are introduced by USMF and must be added to the new warehouse. As supply chain manager, you will have to create 2 new products:

A V-neck T-shirt with multiple variants that has different colors and sizes. This item will be available in size Small, Medium and Large and in colors: Black and Red.
The product type should set to: Product with no variance for the cabinets

What would you do?

Create product masters

Navigate to Product information management>Products>Released products.
Select New.
In the Product type field, select Item.
In the Product subtype field, select Product master.
In the Product number field, enter GTLS001.
In the Product name field, enter V Neck T-Shirt.
In the Search name field, enter VNeckTShirt.
In the Retail category field, select Apparel and Footwear and select OK.
In the Product dimension group field, select ColorSize.
In the Configuration technology field, select Predefined variant.
In the Item model group field, select FIFO (First In-First Out).
In the Item group field, select Audio.
In the Storage dimension group field, select SiteWH.
In the Tracking dimension group field, select None.
In the Inventory unit field, select ea.
In the Purchase unit field, select ea.
In the Sales unit field, select ea.
In the BOM unit field, select ea.
In the Sales Taxation, Item sales tax group field, select ALL (All sales tax codes).
In the Purchase Taxation, Item sales tax group field, select ALL (All sales tax codes).
Select OK.
Close all pages.
Navigate to Product information management>Products>Released products.
Using quick filter search by item number for GTLS001.
Select item GTLS001 to open the product master record.
On the Action Pane, select the Product tab, select Product dimensions listed under the Product master section.
Select the Sizes tab.
Select New in the Define sizes for a product master section.
In the Size field, enter Small.
In the Name field, enter Small.
In the Description field, enter Small Size.
Select New.
In the Size field, enter Medium.
In the Name field, enter Medium.
In the Description field, enter Medium Size.
Select New.
In the Size field, enter Large.
In the Name field, enter Large.
In the Description field, enter Large Size.
Select the Colors tab.
Select New in the Define sizes for a product master section.
In the Color field, enter Black.
In the Name field, enter Black.
In the Description field, enter Black color.
Select New.
In the Color field, enter Red.
In the Name field, enter Red.
In the Description field, enter Red color.
Select Save.
Close the form.
Select Released product variants listed under the Product master section.
Select Variant suggestions listed under the Released product Variants section.
Select Suggest all from the Variant suggestions and then select Select all from the Suggested variants.
Select Create.

Close all pages.

Exercise #4 Using the inventory movement journal to initialize stock levels in a warehouse

Objective: Initialize stock levels in a warehouse by using movement journals.

USMF company has some inventory opening balance for one of its products and is it necessary to add to that stock. There are no specific purchase order references for the items, so the opening balance will have to be forced into the system.

The warehouse manager, will have to use the inventory movement journal to add the opening balance and use an offset account to balance the transaction in the general ledger.

In USMF, its possible to update the on-hand inventory manually using an Inventory movement journal.

It is also possible to update on-hand inventory by importing transactions in data entities.

What would you do to guide the warehouse manager?

Initialize stock levels in the warehouse using movement journals

Go to Inventory management > Journal entries > Items > Movement.
Select New.
In the Name field, select the drop-down button to open the lookup.
Select Imov. It is a good practice to use different journal name templates for the different business purposes.
In the Offset account field, specify the values 140200.

NoteThis is the offset account that will be the default account on the journal lines. It is possible to override the default to assign different offset accounts per line.
Select OK.
Select New in the Journal lines fast tab.
In the Item number field, select the drop-down button to open the lookup.
Select item A0001.
In the Site field, select the drop-down button to open the lookup.
Select site 1.
In the Warehouse field, select the drop-down button to open the lookup.
Select warehouse 13.
In the Location field, select the drop-down button to open the lookup.
Select location 13.
In the Quantity field, enter a number.
Review changes in the Line details FastTab.
Select Save.
Select Post.
Toggle on or toggle off the Transfer all posting errors to a new journal field.

Note If you enable this option, any lines that fail to post will be copied to a new journal. You can use the information in the log to correct the issues and then re-post the lines.
Select OK.
Close all pages.

Exercise #5 Using the inventory transfer journal to move items to a new location in the warehouse

Objective: Move items from a plate-controlled location to a location that is not license plate controlled.

Transfer physical inventory within the warehouse using transfer journals

Go to Inventory management>Journal entries>Items>Transfer.
Select New.
In the Name field, enter or select ITrf.
Select OK.
Select New in the Journal lines fast tab.
In the Item number field, enter or select A0001.
In the From site field, enter or select 2.
In the To site field, enter or select 2.
In the From warehouse field, enter or select 24.
In the To warehouse field, enter or select 24.
In the From location field, enter or select FL-001.
In the To location field, enter or select BULK-001.
In the Quantity field, enter a number.
Select the Inventory dimensions tab in the Line details fast tab.
In From inventory dimensions, enter 24 in the License plate field.
Select Save.
Select Post.
Select OK.
Select Inventory in the Journal lines fast tab.
Select Transactions to see the transfer.
Close all pages.

Exercise #6 Adjusting stock levels using the inventory adjustment journal

Objective: Adjust stock levels after an error by using the inventory adjustment journal.

During the transfer journal processing a user recorded the wrong number of items moved to the new location.

You were asked to use the inventory adjustment journal to fix quantity.

You will also need to adjust the stock levels of products in the warehouse.

How would you perform this?

Adjust stock levels in the warehouse

Go to Inventory management > Journal entries > Items > Inventory adjustment.
Select New.
In the Name field, select the drop-down button to open the lookup.
Select IAdj.
Select OK.
Select New in the Journal lines fast tab.
In the Item number field, select D0001.
In the Site field, select the drop-down button to open the lookup.
In the list, select site 1.
In the Warehouse field, select the drop-down button to open the lookup.
In the list, select warehouse 13. If you have selected an item with Location as a mandatory dimension, you would have to specify the location here.
In the Quantity field, enter a number. The cost price field specifies the cost per unit for inventory receipts. If the cost is not specified for the item number or if you wanted to change it manually, you would do this here.
Select Validate.
Select OK.

Note that the Journal is OK, and select Post. When you post this kind of journal, an inventory receipt or issue is posted, the inventory level and value are changed, and ledger transactions are generated.
Select OK.
Close all pages.

Exercise #7 Using the inventory counting journal to compare D365 inventory amounts to manually counted quantities

Objective: Use the inventory counting journal to compare manually counted amounts to the on hand recorded amounts in D365 supply chain and post the transaction.

A few days after you have adjusted stock levels, the warehouse manager decide to manually count the items in that specific area of the warehouse.

The warehouse manager wants to enter the manually counted quantity and not sure what to use.

How would you help?

Use counting journals

Go to Inventory management > Journal entries > Item counting > Counting.
Select New.
In the Name field, select the drop-down button to open the lookup.
In the list, select on the inventory counting journal Icnt.
In the Worker field, select the drop-down button to open the lookup.
In the list, select the worker you want to use.
Select Select.
Select OK.
Select New in the Journal lines fast tab.
In the Item number field, select the drop-down button to open the lookup.
In the list, find and select A0001.
In the Site field, select the drop-down button to open the lookup.
In the list, find and select site 2.
In the Warehouse field, select the drop-down button to open the lookup.
In the list, find and select warehouse 24.
In the Location field, select the drop-down button to open the lookup.
In the list, find and select location BULK-001.
In the Counted field, enter a number.
If you enter a counted number that’s different than the number shown in the On-hand field, the Quantity field is updated to show the discrepancy.
Select Save.
Select Post. When you post an inventory counting journal, if the counted amount differs from the amount that’s reported in the On-hand field, an inventory receipt or issue is posted, the inventory level and value are changed, and ledger transactions are generated.
Select OK.
Close all pages.

Exercise #8 Creating a BOM in the BOM designer (Bonus)

Objective: Create a BOM in the BOM designer with a title, item group, site and quantities.

The designer at USMF has received a new specification for the enclosure side of a cabinet. and she has requested your assistance. You see that an item is not set up for this specification, so you only need to create a simple BOM with component lines. Use employee 000020, Julia Funderburk, to approve the BOM.

Create a BOM titled “High Quality Speaker” and assign it to the Audio item group at site 1. Use the BOM designer to add items with warehouse 11 and the following quantities:

1 qty of M0008 / High End Cabinet / Black
2 qty of M0002 / Mid-Range Speaker Unit
1 qty of M0009 / Protective Corners

You will:

Create a BOM in the BOM designer

Go to Product information management > Bills of materials and formulas > Bills of materials.
Select New.
In the Name field, enter High Quality Speaker.
In the Site field, enter 1.
In the Item group field, enter or select Audio.
On the Maintain tab, select Designer.
Select BOM lines.
Select Add to component BOM.
In the list, find and select M0008 / High End Cabinet / Black.
Select OK.
Select BOM lines.
Select Add after line.
In the list, find and select M0009 / Protective Corners.
Select OK.
Select BOM lines.
Select Add before line.
In the list, find and select M0002 / Mid-Range Speaker Unit.
Select OK.
Close the page.
Refresh the page. This will allow the BOM lines to appear in the grid for the BOM.
In the list of Bill of materials lines, find and select the row for M0002 / Mid-Range Speaker Unit.
Set Quantity to 2.0000.
In the Maintain tab, select Approval. Select 000020, Julia Funderburk.
Select OK.
Close all pages.