50225 Inventory Costing in Microsoft Dynamics NAV 2009
About this Course
The focus of the two-day Inventory Costing course is to provide explanations of costing concepts and matters related to general inventory management concerned with the handling of goods purchased for resale in Microsoft Dynamics NAV 2009. This course has been designed to give the consultants and implementers of Microsoft Dynamics NAV with a focus on cost management a solid explanation of the principles and mechanisms on which the program is built. Based on this explanation, course participants develop confidence in how the program records and calculates all the relevant inventory costs.
Audience Profile
This course is intended for individuals on the implementation team, administrating or using the modules in Microsoft Dynamics NAV 2009. This audience typically includes individuals who will be implementing and assisting Microsoft Dynamics NAV 2009 users. Additionally, individuals responsible for training or supporting Microsoft Dynamics NAV 2009 benefit from the course.
Prerequisites
To successfully participate in the inventory costing course, participants must have passed the Microsoft Dynamics NAV Essentials test or have equivalent experience with the Microsoft Dynamics NAV application. Additionally, participants should have a background in distribution/logistics to understand the underlying principles of these businesses.
At Course Completion
After completing this course, students will be able to:
Interpret the basic inventory accounting and inventory costing concepts
- Interpret the basic inventory accounting and inventory costing concepts
- Explain how the value of inventory is calculated in Microsoft Dynamics NAV 2009
- Interpret how the posting flow in Microsoft Dynamics NAV 2009 determines the cost of items, based on the defined costing methods
- Define how the program calculates unit cost and average cost
- Perform inventory revaluation, rounding, adjustment, and general ledger posting
- Set up inventory costing
Course Outline
Module 1: Inventory Costing Overview
This module introduces the basic concepts and terms commonly used in inventory accounting.
Lessons
- Inventory Costs
- Inventory Accounting
After completing this module, students will be able to:
- Interpret the basic concepts behind calculation of inventory value.
- Differentiate capitalized and non-capitalized costs.
- Understand the valuation of cost objects in relation to their direct and indirect costs.
- Distinguish the cost flow assumptions that support the various costing methods.
Module 2: Inventory Costing Principles
This module explains in broad terms how Microsoft Dynamics NAV 2009 records the cost of goods sold through the posting process and eventually calculates the value of ending inventory.
Lessons
- Accounting for Inventory
After completing this module, students will be able to:
- Follow the process of recording quantity and value changes in entries.
- Distinguish the different types of information that are recorded in item ledger entries and value entries.
- Define how inventory values are posted in the general ledger.
- Interpret the concept of inventory periods.
Module 3: Inventory Costing Functionality
This module provides the details as to how the program calculates the flow of cost from acquisitions to outbound transactions and how adjustments to those costs are made with the adjustment batch job.
Lessons
- Inventory Acquisition
- Cost of Goods Sold
- Inventory Transfers and Returns
- Inventory Adjustment
- Rounding
After completing this module, students will be able to:
- Follow the process of assigning costs to acquisitions, including unit cost calculation.
- Interpret the flow of costs from purchases to sales for the various costing methods.
- Interpret how various entries are applied against each other.
- Create and remove application entries.
- Follow the cost flow for transfers and returns.
- Explain the purpose and functioning of the inventory adjustment batch job.
- Define how and why the program creates rounding value entries.
Module 4: Inventory Valuation Functionality
This module explains in detail how the program calculates the value of inventory and posts that value to the general ledger, as well as how the value can be adjusted and revalued.
Lessons
- Inventory Valuation
- Posting Inventory Costs to the General Ledger
- Inventory Revaluation
- Physical Inventory
After completing this module, students will be able to:
- Interpret how inventory value is calculated in Microsoft Dynamics NAV 2009
- Post inventory value from value entries to the accounts in the general ledger
- Trace G/L entries to source value and item ledger entries
- Explain how the program handles expected costs, both in normal posting flow and in posting to the general ledger
- Monitor the status of reconciliation between G/L and item ledger
- Revalue inventory items using the revaluation journal
- Perform physical inventory counting
Module 5: Setting Up Inventory Costing
This module explains how to set up the program to handle a company’s inventory costing needs.
Lessons
- Inventory Costing Setup
After completing this module, students will be able to:
- Set up inventory periods for a company in Microsoft Dynamics NAV 2009.
- Set up the inventory costing options.
- Set up individual items to use the correct costing method.