What is Great Plains SmartList?

Definition

Great Plains SmartList is a built-in inquiry and reporting feature in Microsoft Dynamics GP that lets users view, filter, organize, and export business information stored in the system. Rather than navigating through individual transaction screens, finance and operations teams can use SmartList to create focused views of records such as customers, vendors, accounts, transactions, and other master or historical data.

SmartList is particularly useful for answering operational accounting questions. A user can select a list, apply filters, choose the columns to display, sort results, and save frequently used views as favorites. The resulting information can then support reconciliation, account review, transaction investigation, and management reporting.

Table of Contents

How Great Plains SmartList Works

SmartList organizes Dynamics GP information into predefined lists associated with different areas of the application. The user selects a relevant list and then narrows the displayed records according to the question being investigated.

For example, an accounts payable user could work with a vendor or payable-related list, select fields such as vendor name, document number, document date, due date, and amount, and then filter the results to a particular date range or vendor. This creates a targeted dataset without requiring the user to inspect each transaction individually.

The resulting view can be sorted and adjusted to emphasize the information needed for a particular finance task. Frequently used configurations can be saved so that the same inquiry can be repeated consistently.

Key SmartList Capabilities

  • Filtering: Narrow records using fields and conditions relevant to the accounting or operational question.
  • Column selection: Choose which fields appear in the list so the view focuses on useful information.
  • Sorting: Arrange records by dates, amounts, names, document numbers, or other available fields.
  • Saved favorites: Preserve frequently used inquiries for recurring reporting and review activities.
  • Export: Move selected information into formats or applications used for additional analysis and reporting.
  • Drill-down: Use available record details to investigate the underlying transactions or master data behind a result.

SmartList for Financial Operations

SmartList can support routine accounting controls because finance teams often need to locate specific records quickly. During a month-end close, for example, an accountant can use a filtered list to review transactions posted during a particular period, identify unusual amounts, or examine activity associated with a specific account or vendor.

SmartList can also support reconciliation by helping users compare transaction-level information with balances reported elsewhere. When an account contains an unexpected balance, a targeted inquiry can help identify the documents and transactions contributing to that balance.

For reporting teams, consistent SmartList views can provide repeatable operational information without requiring users to rebuild the same filters and column selections each time.

Practical Examples

Consider a controller reviewing vendor activity before a monthly close. The controller can create a vendor transaction list containing vendor names, document numbers, dates, transaction types, and amounts. Filtering the list to the closing period provides a focused population for review and reconciliation.

Another example is an accounts receivable review. A finance user can organize customer-related information by document date, amount, or customer and use filters to isolate records requiring follow-up. The resulting information can help the team investigate outstanding activity and prepare supporting analysis for management.

SmartList therefore works best as an inquiry layer over accounting data: it helps users move from a broad population of records to the specific information needed for a financial decision or control activity.

SmartList and Finance Analysis

SmartList outputs can become useful inputs for broader finance analysis when users consistently define the fields, filters, and reporting periods they need. A saved inquiry can establish a repeatable method for gathering operational accounting information, while exported data can be analyzed alongside budgets, forecasts, and other financial information.

This distinction is useful when considering Great Expectations Finance, which encompasses broader expectations and workflows around financial planning and business management. SmartList itself is focused on accessing and organizing Dynamics GP data, while broader finance processes use that information to evaluate performance and guide decisions.

Best Practices for Using Great Plains SmartList

  • Define the business question first: Select only the fields and records needed to answer the specific accounting or operational question.
  • Use consistent filters: Apply standardized date ranges, account criteria, and transaction conditions for recurring reviews.
  • Validate source data: Confirm that the selected fields and records represent the accounting population being analyzed.
  • Save recurring views: Preserve frequently used configurations so recurring reconciliations and reviews follow a consistent process.
  • Protect sensitive information: Apply appropriate access controls when SmartList views contain financial or vendor information.

Summary

Great Plains SmartList is a Dynamics GP inquiry and reporting feature for organizing and examining accounting and business data. Its filtering, sorting, column selection, saved views, and export capabilities help finance teams investigate transactions, support reconciliations, perform operational reviews, and prepare analysis. Used with clearly defined reporting requirements and consistent controls, SmartList provides a practical way to turn Dynamics GP records into focused financial information for day-to-day decision-making.