Using Collections Management in Microsoft Dynamics GP

Some helpful tips for using Dynamics GP Collections Management: To helps you maintain tight control over your data.

Table of Content

    Using Microsoft Dynamics GP Collections Management help you maintain tight control over Accounts Receivables by providing you with customizable information views, access to information quickly and easily, automated bad-debit management tools, the ability to target overdue customers effectively all while minimizing administrative workload to save your company time and money.

    Managing Collections

    Use the Collections Management Main Window (see screenshot below) to view collection information and to open most of the key windows in Collections Management.

    Navigation: Transactions/Sales/Collection Main

    Dynamics GP Collections Management Main Window

    Field Service Role Based GuideField Service Role Based Guide

    You can use the Collections Management Main Window to complete most of your collections tasks. You can create notes, view financial information, and print letters, statements and invoices or send them by e-mail.

    You also can open these windows from the Collections Management Main Window.

    • Collections Management Notes window
    • Collections Management Build Query window
    • Collections Management Print Selection window
    • Collections Management Task List window
    • Collections Management E-Mail window
    • Customer Payment Summary Inquiry window
    • Collections Management Transaction Inquiry window
    • Collections Management Customer Information window

    Creating a Customer Query

    Use the Collections Management Build Query window to create a list of customers that meet specific user-defined criteria. Query results are saved by collector ID, each collector can run his or her own queries. Lists of customers that match the query criteria are saved so that each collector can work with a separate list of customers.

    Navigation:  Transactions/Sales/Build Query

    Dynamics GP Collections Management Build Query Window

    Process Steps:

    • Open the Collections Management Build Query window  – Transactions >> Sales >> Build Query
    • Enter a query ID or select one from the list. If the query is new, enter a description. To view additional query information, choose the Query ID information button.
    • To create a restriction, choose a tab and enter information. To insert the range information into the query, choose Insert.

    Working with Collector Tasks

    Use the Collections Management Task List to view tasks and the user assigned to the tasks. You can mark tasks completed or paid and print a task list. You also can use the tasks list to locate customer contact information

    Navigation: Transactions /Sales/Collection Tasks 

    Process Steps:

    • Dynamics GP Collections Management Task List WindowOpen the Collections Management Task List window – (Transactions >> Sales >> Collection Tasks
    • Enter or select a collector ID to view tasks for.
    • Enter a range of action dates to view tasks that occur within those dates.
    • Enter a range of action IDs to view tasks for a range of action IDs.
    • To display notes that are completed, select Completed, otherwise, select Uncompleted.
    • You can mark the Show Payment Promises Only option to display notes with attached action IDs that have an action type of Promised to Pay.
    • You can choose Mark Paid to mark notes as completed automatically if the invoices assigned to the notes have been paid and the action ID attached to the notes is marked Promise to Pay in the Collections Management New Action window.
    • Choose File >>Print to print the task list for the selected user.


    More resources:

    Download this manual from Microsoft to give you an understanding of how to use the features of Collections Management, and how it integrates with the Microsoft Dynamics GP.

    Related articles:

    Make Informed Decisions with Dynamics 365 Customer Engagement

    Guide to Moving from Salesforce to Dynamics 365 SalesGuide to Moving from Salesforce to Dynamics 365 Sales