Inventory in Microsoft Dynamics SL 7.0

8966: Inventory in Microsoft Dynamics SL 7.0 (1 Day)

About this Course

The Microsoft Dynamics SL Inventory class explores all aspects of the Inventory module from the initial setup of inventory items and the multiple methods of valuation supported, to the types of inventory transactions available and the tight integration to the Purchasing and Order Management modules.

Course Outline

Module 1: Inventory Overview and Setup

This overview chapter introduces you to the Inventory module of the Microsoft Dynamics SL product and training course, and the windows and processes that are used to complete the accounting cycle in Inventory. This chapter also examines the core processes that are used in the Inventory module. We introduce each step in the accounting cycle, briefly discuss its purpose and primary features, and focus on its function in the accounting cycle. Please note that this chapter is not intended to provide you with a detailed primer on each of these topics. Furthermore, this chapter examines the windows that need to be completed prior to creating inventory items. You learn how to create product classes and lines, warehouse bin locations, and assign defaults to inventory items.

Lessons

• Course Description
• Module Overview
• Process Flow
• Other Features
• Procedures for Processing Inventory Transactions
• Transaction Overview
• Procedures for Setting up Inventory Items
• Product Classes
• Product Lines
• Warehouse Bin Locations

Lab : Lab

• Create a new product class for paper
• Create a new product class for chairs
• Create a new product class for copiers
• Create a new product class for bicycle manufacturing
• Create a new product class for office supplies
• Create a new bin locations for new products
• Assign default bin locations for the new products

After completing this chapter, students will be able to:

• Understand the goals of this course.
• See how the Inventory module fits into the suite of available modules for the Microsoft Dynamics SL system.
• Follow the flow of transactions through Inventory.
• Understand the process of entering Receipt, Transfer, Adjustment, and Issue transactions.
• Understand the windows that should be completed before setting up inventory items.

Module 2: Inventory Items

This chapter explains how to create inventory items. You learn how to create inventory items, attributes and cross reference.

Lessons

• Inventory Items
• Item Cross References
• Inventory Item History
• Inventory Sites
• Attribute Definitions
• Physical Attributes

After completing this chapter, students will be able to:

• Set up inventory items.
• Set up attributes and cross references.

Module 3: Inventory Kits, Reason Codes, Receipts

This chapter discusses the process for creating inventory items to represent a kit and the components of a kit. Learn how inventory kits facilitate inventory production, management and ordering. You learn the basic differences between stock and non stock kits. In this chapter, you examine the process for using the Inventory Receipts window to establish beginning balance quantity and value information for inventory items. We also discuss the use of Reason Codes to identify the purpose of particular inventory transactions.

Lessons

• Procedures for Creating Kits
• Inventory Kits
• Types of Kits
• Assembly Plans
• Updating Kit Standard Costs
• Reason Codes
• Receipts

After completing this chapter, students will be able to:

• Understand the purpose of Inventory Kits.
• Define Kits in Inventory.
• Set up Reason Codes to provide standard reasons why particular Inventory transactions, such as Returns, are being done.
• Enter beginning balances.

Module 4: Inventory Transactions

This chapter introduces four main inventory transaction windows. An inventory transaction is processed whenever an inventory item's quantity or cost information changes. You gain an understanding of how Inventory transactions can be used to record issues and returns, to adjust quantities and costs, to move items from site to site, and to produce kit assemblies. You see the process by which Inventory transactions are released to the General Ledger through the Inventory Batch Release Process.

Lessons

• Overview of Transactions
• Types of Transactions (Issues, Transfers, Receipts, Sales, Kit Assembly)

After completing this chapter, students will be able to:

• Understand the types of transactions that are entered in the Inventory module.
• Understand the two different methods used to accomplish transfers.
• Enter Inventory Issues.
• Enter Inventory Adjustments.
• Enter an Inventory Kit Assembly.

Module 5: Inquiry Windows

This chapter reviews the series of windows available for viewing inventory item balances and easily drilling down to the transaction details. The Inquiry windows allow you to quickly view item information without having to print reports.

Lessons

• Inventory Status Inquiry
• Inventory Item Lookup

After completing this chapter, students will be able to:

• Understand the windows available in the Inventory module for viewing transaction and status information.

Module 6: Standard Costs, Physical Inventory, and Closing

This chapter examines the methods for performing physical inventory counts. We discuss how to complete a full physical inventory and the various options available for selecting items to include in a cycle count. This chapter also teaches you to create a closing checklist to ensure all transactions and activities have been completed for the accounting period, produce appropriate audit trail reports, correct an out of balance condition, and close only the Inventory module or all modules for the period.

Lessons

• Updating Standard Costs
• Physical Inventory Concepts
• Performing a Physical Inventory
• Physical Inventory Windows
• Physical Inventory Reports
• Balance to the General Ledger
• Close for the Month or Year
• Perform IN Integrity Check

After completing this chapter, students will be able to:

• Understand the Physical Inventory process.
• Prioritize inventory prior to counting.
• Freeze Inventory and generate inventory count tags.
• Enter and reconcile counts.
• Understand how the system adjusts inventory.
• Understand the timing of closing the Inventory module with the other Distribution modules.
• Determine the possible cause of out-of-balance conditions in Inventory
• Use the module integrity check

Module 7: Appendix: Inventory Setup

Appendix A helps you understand the defaults and user options defined in the Inventory Setup window. Even though these options are typically not changed after the product is implemented, you will gain understanding of default values and processes through the settings in this window.

Lessons

• Inventory Policies
• Inventory Setup Checklist
• Module Implementation Worksheet
• Sites
• Inventory Setup
• Unit Conversions
• Material Types

Module 8: Appendix: Inventory Case Study

This case study is a comprehensive exercise for the Inventory functionality within Microsoft Dynamics SL.

Before attending this course, students must have:

• General knowledge of Microsoft Windows.
• Knowledge of basic navigation functions in Microsoft Dynamics SL.
• Completion of General Ledger, Accounts Receivable, and/or Accounts Payable training courses required.