Accounts Payable in Microsoft Dynamics SL 7.0

8826: Accounts Payable in Microsoft Dynamics SL 7.0 (1 Day)

About this Course

This one-day course delves into the accounting cycle and the processes required to enter vendor invoices and process checks. This course also shows students how to perform additional functions such as adjustments, prepayments, month-end closing, and cash flow control.Students walk through topics and learn about: setting up vendor discount dates, reducing payable liabilities, selecting the right vouchers for payment by date, vendor, number, or custom query to control cash outlay. Students are shown how to use comprehensive reporting features to present data in different ways, including standard reports such as Aged Accounts Payables, Vendor Trial Balance, Check Register, and the Accounts Payable Batch Register. This course reviews how to define default values that automatically populate data fields and gather information needed by exploring inquiry and lookup functions.Classroom training provides in-depth learning via hands-on interaction. Through demonstrations, presentations, and classroom activities, students can receive hands-on experience with instruction from our certified staff and increase productivity and efficiency by learning tips and tricks from product specialists.

Audience Profile

Accounts Payable training is recommended for anyone who plans to implement, use, maintain, consult, or support Microsoft Dynamics SL. The class is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Accounts Payable and gain foundational knowledge of the application functionality.

At Course Completion

Course completion objectives are:

• Perform all Microsoft Dynamics SL Accounts Payable related data entry functions including vendor invoicing, check processing, recurring vouchers, and manual checks.
• Perform maintenance on accounts payable documents and other records such as vendors and recurring vouchers.
• Select documents for payment and make appropriate adjustments to payment amounts prior to check processing.
• Print standard Microsoft Dynamics SL reports to verify data and financial analysis for audit trail purposes.
• Identify the impact of the Microsoft Dynamics SL Accounts Payable module on other Microsoft Dynamics SL modules.
• Troubleshoot and correct operator input errors including an incorrect Period to post and how to void checks.

Course Outline

Module 1: Overview

The purpose of this chapter is to introduce students to the Microsoft Dynamics SL Accounts Payable module and training course. This chapter introduces the windows and processes that are used to complete the accounting cycle in Microsoft Dynamics SL Accounts Payable.Also, it is important to note that this chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

• Course Description
• Module Overview
• Accounts Payable Process Flow
• Other Features

After completing this chapter, students will be able to:

• Understand the goals of this course.
• See how the Microsoft Dynamics SL Accounts Payable module fits into the suite of available modules for the Microsoft Dynamics SL system.
• Follow the flow of transactions through Microsoft Dynamics SL Accounts Payable.

Module 2: Active Overview

This chapter examines the core processes that are used in the Microsoft Dynamics SL Accounts Payable module. The purpose of this chapter is to introduce each step in the accounting cycle, briefly discuss each step’s purpose and primary features, and focus on the step’s function in the accounting cycle. Please note that this chapter is not intended to provide you with a detailed primer on each of these topics.This chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

• Transaction Flowchart
• Voucher Entry
• Payment Selection
• Check Printing
• Viewing Results

After completing this chapter, students will be able to:

• Identify the basic processes required to enter and pay a vendor invoice.
• Understand the purpose of the Payment Selection process.
• Understand the process for printing a check.
• View the results of transactions.

Module 3: Vendor Maintenance

This chapter examines the setup of vendors. The purpose of this chapter is to describe the information required to define a vendor in the system. A vendor must be defined before Microsoft Dynamics SL Accounts Payable documents can be entered.

Lessons

• Procedures for Maintaining Vendors
• Vendor Maintenance window
• Vendor Class Maintenance window
• Vendor History window

Lab : Vendor Maintenance

• Create new vendors

Lab : Initialize 1099 Amount (Optional exercise, US Government reporting)

• Use Initialize Mode to enter an already reported 1099 amount

After completing this chapter, students will be able to:

• Establish identification codes for vendors.
• Create and maintain vendors and vendor information.
• Understand the uses of the vendor classes.
• View vendor balances.

Module 4: Voucher and Adjustment Entry

This chapter discusses the concept of batch entry. The fields and features of the Voucher and Adjustment Entry window are also discussed. This chapter examines the types of documents that can be entered in the Voucher and Adjustment Entry window and the processes required to update vendor balances. Execute reports to verify information entered.

Lessons

• Procedures for Entering Vouchers
• Voucher and Adjustment Entry window
• Adjustment Debit and Credit documents
• Releasing Microsoft Dynamics SL Accounts Payable documents
• Microsoft Dynamics SL Accounts Payable batch reports

Lab : Voucher Entry

• Enter documents for vendor invoices received.

After completing this chapter, students will be able to:

• Identify the basic processes required to enter and pay a vendor invoice.
• Understand the purpose of the Payment Selection process.
• Understand the process for printing a check.
• View the results of transactions.

Module 5: Vendor Inquiry

The objective of this chapter is to examine the series of windows available for viewing vendor balances and drilling down to the transaction details. The Inquiry windows allow viewing vendor balances and documents without having to print reports. Learn to view balances and drill down to the details of the transactions.

Lessons

• Vendor Inquiry Window
• Vendor Documents Report
• Vendor History

Lab : Vendor Inquiry

• Use the Vendor Inquiry window to view Microsoft Dynamics SL Accounts Payable data

After completing this chapter, students will be able to:

• Perform vendor inquiries.
• Locate vendor documents.
• Drill down to document details.

Module 6: Recurring Vouchers

Use the recurring voucher feature to make repetitive documents more efficient. This chapter shows how to define a recurring item and execute the process to create the voucher each period.

Lessons

• Procedures for using Recurring Vouchers
• Recurring Voucher Maintenance
• Generate Recurring Vouchers

Lab : Create a Recurring Voucher

• Create a recurring item for a monthly service contract
• Generate the recurring voucher

Lab : Recurring Vouchers

• Create a recurring voucher for a quarterly payment to a vendor

After completing this chapter, students will be able to:

• Determine which vouchers should be defined as Recurring Vouchers.
• Set up recurring items.
• Process Recurring Vouchers to generate a batch.

Module 7: Payment Selection

The objective of this chapter is to examine the reports that help determine which vouchers to pay. The chapter shows how to select the right vouchers for payment by date, vendor, number, or a custom query. Learn which options to use to take advantage of vendor discounts and pay invoices at the right time. Learn to create multiple check printing batches.

Lessons

• AP Check Diagram
• Procedures for Processing Checks
• Cash Requirements Report
• Aged AP Report
• Payment Selection
• Editing Payment Selections

Lab : Payment Selection

• Print the Cash Requirements report and select documents for check processing

Lab : Edit/Select Documents for Payment

• Make changes to a Payment Selection batch

Lab : Clearing Payment Selections

• Clear all items from a Payment Selection batch

After completing this chapter, students will be able to:

• Decide which documents should be paid.
• Determine the best method to use for payment selection.
• Edit amounts, discounts, and items selected for payment.
• Clear Payment Selections.

Module 8: Check Processing

This chapter explores the check printing process and the various options available for processing checks after printing. Learn how to handle situations such as check forms that are loaded incorrectly or not at all. View the check preview to understand how checks display as a result of processing options.

Lessons

• Check Printing
• AP Check Update
• Manual Check Entry

Lab : Check Printing

• View the Check Preview, Print Checks, and use the Check Update process

Lab : Using Check Update

• Print Checks, update the system, and view the Check Register report

After completing this chapter, students will be able to:

• Print Checks.
• Evaluate the printed check forms.
• Update check documents in the system.

Module 9: Voiding Checks

This chapter discusses how to void a check after it has been issued, view the reinstated voucher, and understand the steps to issue a new check.

Lessons

• Procedures for Voiding Checks
• Void Check Entry

Lab : Void Check

• Void an issued check and view the resulting documents

After completing this chapter, students will be able to:

• Void a check that has been printed and processed.
• Decide if the voucher is to be re-paid.

Module 10: Check Reconciliation

This chapter explores the check reconciliation function within Microsoft Dynamics SL Accounts Payable. Comparisons are made to the Cash Manager module so students using Cash Manager understand the differences. Use the Check Reconciliation report to evaluate outstanding items.

Lessons

• Procedures to Reconcile Checks
• Check Reconciliation Report
• Check Reconciliation Window

Lab : Reconcile Checks

• Use the Reconciliation process in Microsoft Dynamics SL Accounts Payable to mark checks as "Cleared"

After completing this chapter, students will be able to:

• Clear checks issued to vendors.
• Evaluate the Check Reconciliation Report.

Module 11: Quick Voucher and Prepayment

The objective of this chapter is to introduce the ways checks can be printed. The chapter discusses how to manage pre-payment checks, print checks quickly, enter voucher information, and immediately print a check, and apply pre-payment checks to vouchers when the invoice is received from the vendor.

Lessons

• Overview of Quick Voucher and Prepayments
• Quick Voucher and Prepayment Window
• Apply Prepayments to Vouchers

Lab : PrePayments

• Issue a check to pay a deposit prior to receiving an invoice

Lab : Quick Voucher and Check

• Enter a voucher and print a check in one step

Lab : Applying Prepayments

• Associate a prepayment with the vendor invoice

After completing this chapter, students will be able to:

• Understand when to use the Quick Voucher and Prepayment options.
• Issue a check while and enter a voucher in one step.
• Issue prepayments and apply them to vendor invoices.

Module 12: Month End Procedures and Closing

This chapter shows how to create a closing checklist to ensure all transactions and activities have been completed for the accounting period. Produce appropriate audit trail reports and learn to correct an out of balance condition. Close only Microsoft Dynamics SL Accounts Payable, or all modules for the period. This chapter also discusses the detail retention and deletion options.

Lessons

• Balance the Microsoft Dynamics SL Accounts Payable module to the Microsoft Dynamics SL General Ledger
• Correct an Out of Balance Condition
• Close for the Month or Year
• Delete Microsoft Dynamics SL Accounts Payable Detail
• Perform Microsoft Dynamics SL Accounts Payable Integrity Check

After completing this chapter, students will be able to:

• Understand Month-End processes and procedures.
• Balance Microsoft Dynamics SL Accounts Payable to General Ledger.
• Decide when to close Microsoft Dynamics SL Accounts Payable for the period.
• Execute the Closing process.
• Delete detail for Microsoft Dynamics SL Accounts Payable.
• Understand the AP Integrity Check and when to use it.

Module 13: 1099 Processing (US Government Reporting)

This chapter discusses the 1099 reporting process, reviews how to enter vouchers that reference a 1099 box, and explains how 1099 boxes are updated as checks are issued and voided. Also, learn to print 1099 Miscellaneous forms.

Lessons

• Procedures for preparing 1099s
• 1099 Preview Report
• 1099 Forms
• 1099 Magnetic Media
• 1099 Calendar Year Control

After completing this chapter, students will be able to:

• Understand how 1099 boxes are updated.
• Print 1099 Forms.

Module 14: Appendix: Accounts Payable Setup

Understand the defaults and user options defined in the AP Setup window. Even though these options are typically not changed after the product is implemented, learn about the default values and processes through the settings in this window.Also, it is important to note that this chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

• Microsoft Dynamics SL Accounts Payable Setup Checklist
• Microsoft Dynamics SL Accounts Payable Implementation Worksheet
• Procedures for entering initial documents and history
• Initializing Existing Activity

After completing this chapter, students will be able to:

• Understand the options in the Microsoft Dynamics SL Accounts Payable AP Setup window.
• Understand how the Microsoft Dynamics SL Accounts Payable setup options impact the Microsoft Dynamics SL Accounts Payable module.
• Initialize existing history.

Module 15: Appendix: Sales Tax Maintenance

This chapter discusses the options for tracking Sales Tax. Learn to define taxes and enter updated tax rates. Set default tax IDs for customers/vendors and use taxes in data entry.This chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

• Sales Tax Procedures
• Tax Maintenance
• Tax Categories
• Tax Groups
• Assigning Taxes to Vendors
• Using Taxes in Data Entry
• Tax Reporting

After completing this chapter, students will be able to:

• Define Sales Taxes.
• Understand Tax Groups.
• Understand Tax Categories.
• Use taxes in data entry.

Module 16: Appendix: Terms Maintenance

Define payment terms for customers/vendors. Learn to set up terms with discount options. Multiple installments can be defined using standard frequencies or user defined payment dates and amounts.This chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

• Shared Information Terms Maintenance
• Multiple Installments
• Using Multiple Installment Terms

After completing this chapter, students will be able to:

• Define Terms for use in Data Entry.
• Create Multiple Installment Terms.
• Use multiple installment Terms.

Module 17: Appendix: Case Study

This case study takes students through the typical functions related to Accounts Payable. Follow each portion of the case in sequence since many of the tasks build on previously completed steps.

Lessons

• AP Setup
• Vendor Maintenance
• Voucher and Adjustment Entry
• Document Maintenance
• Payment Selection
• Print Checks
• Reports
• Balance Accounts Payable to General Ledger

After completing this chapter, students will be able to:

• Set up Accounts Payable.
• Create Vouchers and Adjustments
• Edit released documents.
• Create a Payment Selection batch.
• Print Checks
• Review results through reports
• Balance Accounts Payable to General Ledger

Module 18: Appendix: Electronic Document Delivery for Microsoft Dynamics SL Accounts Payable and Purchasing documents

This appendix reviews the Shared Information Electronic Document Delivery Setup and Electronic Document Delivery Inquiry window windows as they relate to the Microsoft Dynamics SL Accounts Payable module.

Lessons

• Shared Information - Electronic Document Delivery Setup.
• Shared Information Electronic Document Inquiry.

After completing this chapter, students will be able to:

• Complete Electronic Document Delivery Setup.
• Define default electronic document delivery preferences for purchase orders.
• Search and view electronic requests created for purchase orders sent electronically.

Before attending this course, students must have:

• General knowledge of Microsoft Windows.
• Knowledge of basic navigation functions in Microsoft Dynamics SL.
• Completion of General Ledger training course is helpful but not required.

*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.