Advanced Computer Applications 2 FMGT 4710

Course offerings

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

Subscribe