In the first half of the course we extend on the work done in FMGT3720. We cover the major business processes using Dynamics GP. In the second half Excel is used to analyze data and to build a Financial Model.
This course is computer/lab based where each student requires their own personal workstation. If the course fills, capacity will not be increased or over-ridden. Laptops are not a viable option for this course.
This course offering is in progress and full. Please check back next term or subscribe to receive email updates.
In Progress and Full
Upon successful completion, the student will be able to:
Navigate the principal features in Dynamics GP.
Enter transactions for the major business processes in Dynamics GP.
Understand the difference between Posting Individual transactions and saving Transactions to a batch.
Understand how to Post Batches.
Understand how to Modify transactions before posting the Batch.
Set Batch Posting Options to ensure accuracy and require approval.
Understand the differences between Posting individual transactions and posting batches.
Perform Revenue Cycle activities including Master Record setup, recording transactions and running reports.
Perform Revenue Cycle activities for Inventory items using Sales Order Processing.
Perform Expenditure Cycle activities including Master Record setup, purchase order creation, recording transactions and running reports.
Perform Expenditure Cycle activities for Inventory items using Purchase Order Processing.
Perform Expenditure Cycle activities involving the purchase of non-inventory items and services.
Assign Vendors and Customers to a Class and use Class to load and change default information.
Set up Inventory Master Records and inventory classes.
Maintain Inventory records, including physical count adjustments.
Create a pricing method which will link the Sales Price of an Item to the Purchase Price of the same item.
Run Inventory reports.
Use Smartlist to extract information from Dynamics GP.
Export reports to tab delimited files and then to Excel.
Open and close fiscal periods in Dynamics GP to control financial information.
Create a Pivot table to analyse Payroll information.
Modify and Build Financial Statements in Dynamics GP using Advanced Financial Analysis (subject to time available).
Create, import and export Budgets and explore the budget functionality in Dynamics GP (subject to time available).
Limit user access to the Dynamics GP System (subject to time available).
Create Monthly and Annual Budget Income Statement, Balance Sheet and Cash Flow reports using an Excel model.
Link sales projections, purchase projections and prices to the budget in this model.
Change the projection data and have the budget reports update to reflect these changes in this model.
Use appropriate excel functions to link the data in the model.
Learn how to update this model to deal with changes to the underlying assumptions.
Effective as of Winter 2014
FMGT 4710 is offered as a part of the following programs:
Interested in being notified about future offerings of FMGT 4710 - Advanced Computer Applications 2?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.