SmartList Combining Payables Distributions to General Ledger Transactions

Here at eOne, it seems we get a lot of requests for a SmartList that gives the Payables transactions with their distributions and the corresponding General Ledger transactions.  So many requests in fact that we decided to create one for everyone to use. 

If you look in the SmartList Builder template list under the Purchasing series, you will find PM Distributions with GL Summary and PM Distributions with GL Detail SmartList and Excel Report templates. The setups are built to give you a list of Payables Transactions with their corresponding General Ledger Transactions. The difference between the two is how they are setup based on if you post to the General Ledger is summary or detail.

What tables Involved are involved?

  • PM Distribution WORK OPEN
  • PM Distribution History File
  • PM Transaction WORK File
  • PM Transaction OPEN File
  • PM Paid Transaction History File
  • PM Vendor Master File
  • Year-to-Date Transaction Open
  • Account Transaction History

How do I get the PM Distributions with GL Summary and PM Distributions with GL Detail SmartList and Excel Report to use in my environment?
There is really only one requirement to get this list from eOne working in your environment, you need to have SmartList Builder.  Once you have SmartList Builder, it is a matter of importing the list into your system.  You can do this by going to Microsoft Dynamics GP – Tools – SmartList Builder – Import.  From there, select the Import from Web tab and select the Product of Microsoft Dynamics GP and the Series of Purchasing.  You will find the lists there to select and import.  Once it is imported, you can use the list or edit as needed to fit your needs.  

You can find more information about the PM Distributions with GL Summary and PM Distributions with GL Detail SmartLists and Excel Reports and all of the other SmartList Builder templates from eOne on the SmartList Builder download page.

1 Comment

  1. Jim L. on October 29, 2018 at 1:15 pm

    As always, you’re awesome!

Leave a Comment


Tech Tuesday: Connecting to Sales 365 with Multi Factor Authentication
SmartConnect Office Hours Recap for April 19th, 2019
What is a Popdock Widget?
Tech Tuesday: Conditionally Auto Opening an Extender Window with Extender Enterprise
Sign Up Ends Soon! SmartConnect Bootcamp for GP or BC/NAV in Las Vegas


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps



open all | close all


CRM Demo Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.