Dynamics GP to D365 Business Central: How to Pull Open AR and Open AP from SmartLists for Import

By Deb Schaffer | January 7, 2022

search sales transactions

Within Dynamics GP, users can pull reports using SmartLists that can be exported directly to Excel and then used for import into Dynamics 365 Business Central. This document walks through how to add columns to the existing Receivables, Sales Transactions, and Payables transactions views that are available out of the box.

Similar actions can be done to pull Open Purchase Orders information.

To open SmartLists, navigation to Microsoft Dynamics GP > SmartLists. This will open the SmartList window as shown below.

For the reports listed above, users can follow similar steps to add columns and restrict search criteria.

Expand the Sales Transaction folder and click on the view identified with the *. The * is always the default view.

Next, click on the Columns button on the top menu.

SmartLists columns

This will open the Change Column Display window as shown below.

Change column display

Click on the Add button to open the Columns window. This list is all of the columns that are available to be added to the view. For open records, users will need to pull the Document Amount, Document Status, and Due Date. Click on OK. Once the columns have been added to the Change Column Display window, they can be arranged in different orders using the arrow keys on the far right side of the window. Once column order has been identified, click on OK to return to the SmartList The data will refresh based on the column information.

Next, click on Search button to enter in up to 4 restrictions for searching the data and to identify the number of records that should be searched. The Search window is shown below.

Search sales transactions

Click on the lookup for Column Name in Search Description 1. For this example, I’ve selected Document Type and filtered on the results to equal Invoice. For Search Description 2 I’ve selected Document Status and selected Posted.

At the bottom of the window, the Maximum Records are defaulted in at 1000. If GP has been in use for a long time, you will want to put in a large number to make sure all data is included in the results (something like 9999999999).

Click on OK at the top of the window and the report will refresh based on the Search selections made.

Users will be able to see when the report is complete at the bottom of the SmartList.

Once you have the report the way you want it, click on Favorites at the top and give the report a name and save the report – now the report can be run whenever it is needed and data on the report will refresh with any addition of transactions meeting the criteria selected.

Users can also choose to export the results to Excel by clicking on the Excel button.

These same similar steps can be followed to run Open AP, Open AR, and Open Purchase Orders.

Open AR in SmartList

Open AP in SmartList

Related Posts

Recommended Reading:

Stoneridge Software Selected for 2022 Microsoft US Partner Award – Dynamics 365 Business Central

Stoneridge Software is honored to be selected as a 2022 Microsoft US (MSUS) Partner Award winner for Dynamics 365 Business […]

Read the Article
6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!