3 Basic Tips for Microsoft Dynamics GP Reporting and SmartLists

Read Dynamics GP consultants Jeff Smith & John DeHaven presentation on 3 tips as part of their “Getting More out of Dynamics GP: 50 Tips in 50 Minutes”

Table of Content

    Ohio Microsoft Dynamics GP consultants Jeff Smith and John DeHaven presented these three tips as part of their “Getting More out of Dynamics GP: 50 Tips in 50 Minutes” presentation at Aspire, the annual conference held by Ohio Dynamics Partner, Socius.

    These are basic level tips for Microsoft Dynamics GP (formerly Ohio Microsoft Great Plains) users:

    Rename SmartList Columns
    If you don’t like columns in your SmartList to have names like ATYALLOC, simply rename them.

    • Open a SmartList
    • Select Columns
    • Pick an item in the Display Name column and change the name
    • Save it as a Favorite to save changes

    Impose Order with Multiple Sorts
    SmartList lets you sort by clicking on the column title.  To sort by multiple columns:

    • Click Search
    • Select Order By
    • Add columns to search by

    Ease Printing with Report Groups
    Report groups let you add multiple reports to a group and then print them all at once.  This feature is especially useful for month end reports.

    • Select Reports within an area (i.e. Sales Reports)
    • Select the Groups option
    • Name the Group
    • Add Report Options (Report Settings*)
    • Run the report

    *It is best to use settings like “Beginning of Previous Month” and “End of Previous Month” in the report options; otherwise you have to change all of the dates and it defeats the purpose of creating the group.

    For intermediate and advanced SmartList and Reporting tips for Ohio Microsoft Dynamics GP, access the whole presentation.


    Dynamics GPEnterprise Resource Planning (ERP)On-Premises Dynamics
    The MedTech Conference
    October 9-11
    Learn More
    AXIO for Dynamics 365 FinanceDistributionDynamics 365 Business CentralDynamics 365 ERPDynamics 365 Finance and OperationsEnterprise Resource Planning (ERP)
    Dynamic Communities Summit ’23
    October 15-20, 2023
    Learn More
    Advanced Projects for D365 Business CentralAgribusinessAnalytics, Business Intelligence & WorkflowsAXIO Advanced ProjectsAXIO for Dynamics 365 FinanceBusiness ProductivityCloudCommercial HVACData FabricDealer ManagementDistributionDynamics 365 Business CentralDynamics 365 Customer Engagement & Dynamics CRMDynamics 365 ERPDynamics 365 Finance and OperationsDynamics AXDynamics GPDynamics NAVDynamics SLEnterprise Resource Planning (ERP)Field ServiceGenerative AIIndustry InsightsMarketing AutomationMicrosoft (Office) 365Microsoft CopilotNon-ProfitOn-Premises DynamicsPower AppsPower AutomatePower BIPower PlatformProject Centric BusinessProject Service AutomationRansomware & CybersecurityRestaurant Equipment DistributionSharePoint