Skip to main content

Advanced Computer Applications 2 FMGT 4710

Financial Management Course

Course details

In the first half of the course we extend on the work done in FMGT 3720. 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.

Prerequisite(s)

Credits

5.5

Cost

$891.16

Course offerings

Winter 2023

Below is one offering of FMGT 4710 for the Winter 2023 term.

CRN 46361

Duration

Thu Jan 05 - Thu Mar 30 (13 weeks)

  • 13 weeks
  • CRN 46361
  • $891.16
Class meeting times
Dates Days Times Locations
Jan 05 - Mar 30 Thu 18:00 - 22:00 Burnaby SE06 Rm. 102
Instructor

Thrupthy Krishnan

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Credits

5.5

Cost

$891.16

Important information
  1. This is a Bring Your Own Device (BYOD) course. Students are required to use their own laptop during class time. Computing requirements for the School of Business and Media can be found here: www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf. Information about student discounts on technology products can be found here: www.bcit.ca/it-services/student-discounts/. A desktop computer is not suitable for this course.
Status

Learning Outcomes

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

Related Programs

Advanced Computer Applications 2 (FMGT 4710) is offered as a part of the following programs:

School of Business + Media

  1. Accounting
    Diploma Full-time
  2. Accounting
    Diploma Part-time
  3. Computerized Accounting
    Associate Certificate Part-time
  4. Finance
    Diploma Part-time
  5. Financial Management (Finance Option)
    Certificate Part-time
  6. Financial Management (Professional Accounting Option)
    Certificate Part-time
  7. Financial Planning
    Diploma Part-time

Subscribe

Interested in being notified about future offerings of Advanced Computer Applications 2 (FMGT 4710)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.