Skip to content


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


Join Us in Chicago at the Zendesk Showcase!
Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!
What is a Data Lake/Data Lake Management?


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



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.