Course 80229A: Inventory Control in Microsoft Dynamics® GP 2010

Type: Course
Audience(s):information workers
Technology:Microsoft Dynamics GP
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:1 day
Language(s):English, Spanish

First published:

09 July 2010
About this course
The Microsoft Dynamics GP Inventory Control course explores all aspects of the Inventory Control 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 Purchase Order Processing and Sales Order Processing modules.
This course shows you how to define default system parameters to improve user efficiency and cut down on costly data entry errors. These parameters include General Ledger accounts used in the Inventory Control module, as well as sites, product classes, valuation methods, and more. This course shows you how to group items for pricing, promotional, or analytical purposes and by type, such as finished goods, raw material, component, and more. You learn how to quickly find information such as inventory quantity on hand, quantity available, quantity on back order, costs, and list prices, and where to drill down to transaction details. You learn how to manage multiple sites, multiple bins within sites, negative quantities, and lot/serial numbers. You see how Lot/Serial Number tracking is streamlined during inventory transaction entry. You will also learn how to simplify entry and reconciliation of physical inventory counts.
Audience profile
This course is intended for anyone who plans to implement, use, maintain, consult, or support any part of the Inventory and Order Processing series. The class is targeted toward administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Inventory Control and gain foundational knowledge of the application functionality.
At course completion
After completing this course, students will be able to:
  • Understand how Inventory Control module transactions integrate with other Microsoft Dynamics GP modules
  • Define Inventory Control setup options that allow you to customize the system to better fit your organization's unique needs
  • Use the Inventory Control module to process receipts, make adjustments to inventory, and transfer transactions
  • Use Inventory Control inquiry screens and reports to extract and analyze appropriate information to maintain and improve inventory business processes
  • Create and assemble kits
  • Understand how maintenance screen options affect transactions in the Inventory Control module
  • Process physical inventory transactions and record the results
  • Document month-end processes and close the Inventory Control module
Course details
Course OutlineModule 1: Overview and SetupThis chapter introduces you to the Microsoft Dynamics GP Inventory Control module, and the screens and processes that are used to complete the accounting cycle in Inventory. This chapter focuses on the windows used to set up Inventory Control.Lessons
  • Course Description
  • Module Overview
  • Process Flow
  • Inventory Setup
  • Unit of Measure
  • Price Levels
  • Price Groups
Lab : Overview and Setup
After completing this module, students will be able to:
  • Understand the goals of this training course
  • See how the Inventory Control module fits into the suite of available modules for the Microsoft Dynamics GP system
  • Set up default system parameters throughout the Inventory Control module
Module 2: Item and Pricing SetupThis chapter examines how to set up items and item pricing in Microsoft Dynamics GP Inventory Control. Item parameters are defined at the individual item level and optionally at the item class level. Since each item class typically contains many items, the amount of data entry work required to set up each item can be drastically reduced by defining the parameters at the item class level and then rolling down those options to each item in the class. 
This training reviews all of the options that can be maintained at the item class and item number levels. Kit items are also examined, along with item quantities, item purchasing options, vendor and customer item options, item sites, item stock count cycles, and item price lists.
  • Item Class Setup
  • Item Maintenance
  • Item Accounts
  • Item Price Lists
  • Item Quantities
  • Item Purchasing Options
  • Item Vendors Maintenance
  • Item Kits
  • Site Maintenance
  • Item Stock Count Cycles
  • Customer Item Maintenance
  • Beginning Quantities
  • Item History
Lab : Item and Pricing Setup
After completing this module, students will be able to:
  • Personalize Inventory Control using the various Inventory setup windows
  • Add Item Classes, Items, Price Lists, and Item Sites
  • Set up item codes and characteristics to better track items and inventory throughout the system
  • Set up inventory sites and bins
  • Enter Beginning balances
  • Create customer and vendor specific item information
Module 3: Daily ProceduresThis chapter introduces the main Inventory Control transaction screens. An inventory transaction is processed whenever an inventory item's quantity or cost information changes. Through this training, you examine how to record issues and returns, adjust quantities and costs, and move items from site to site and bin to bin. You review the processes by which Inventory Control transactions are released to the General Ledger depending on your posting setup. You also examine the methods available for performing physical inventory counts, the steps involved in completing a full physical inventory, and the options available for selecting items to include in cycle counts.Lessons
  • Transaction Entry Overview
  • Posting Overview
  • Inventory Batch Entry
  • Adjustment and Variance Transactions
  • Item Transfers
  • Bin Transfer Entry
  • In-Transit Transfer
  • Stock Count Scheduling
  • Stock Count Entry
Lab : Daily Procedures
After completing this module, students will be able to:
  • Differentiate between Batch posting and Transaction Posting
  • Enter Inventory Transactions (posting to General Ledger), Inventory Transfers, and Inventory Variances
  • Create Stock Count Schedules
  • Enter Stock Counts
  • Transfer items
Module 4: Editing and Removing Records
This chapter examines the process of editing records after they have been saved or posted. This includes making cost, valuation, and price adjustments to existing items in your system. This training addresses which records can be deleted and/or removed from the system if the user desires, along with the detail retention and deletion options that support this function. This training also reviews the inquiry screens and reports that support the Inventory Control module.  
  • Change and Delete Records
  • Reconcile
  • Adjust Costs
  • Change Valuation Methods
  • Change Decimal Places
  • Price List Utilities
  • Remove History
  • Remove Bins
  • Purge In-Transit Transfer
  • Using Inquiry Windows
  • Reports
  • Report Lists
After completing this module, students will be able to:
  • Change Valuation Methods, Costs, and Prices of existing items
  • Remove Bins
  • Delete Item records
  • Remove Historical Data
  • Use the Inventory Control inquiry screens and reports to retrieve and analyze inventory data
Module 5: Period-End ProceduresThis chapter examines the process of closing an accounting period and the fiscal year for the Inventory Control module. The steps necessary to complete each phase of the closing process are discussed for both period and fiscal year-end close. The reports that should be printed before performing the closing process are reviewed. This chapter also examines what actually takes place during the closing process and the approaches that an organization may use for this process.Lessons
  • Period-End Procedures
  • Year-End Closing Procedures
After completing this module, students will be able to:
  • Complete the processes that are performed at the end of an accounting period
  • Complete the processes that performed at the end of a fiscal year
  • Perform the Year-end closing process for Inventory Control
Before attending this course, students must have:
  • General knowledge of Windows
  • Knowledge of basic navigation functions in Microsoft Dynamics GP
  • Completed Microsoft Dynamics GP General Ledger, Receivables Management, and/or Payables Management training

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you