Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.

Back

PM Distributions with GL Summary SmartList Builder Template

Published: Sep 01, 2015
Post Author Written by Nicole Albertson

The PM Distributions with GL Summary SmartList Builder setup is built to give you a list of your Payables transactions with their corresponding posted GL Transaction.   This list is designed for those that have their posting setup in summary or to create a Journal Entry per Batch.

ID: PM_DIST_GL_SUM

Name: PM Distributions with GL Summary

Tables 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

 
Screen shots of Setup in SmartList Builder and Excel Report Builder. 

PM_DIST_GL_SUM_SLB

PM_DIST_GL_SUM_ERB


Note:
These templates are designed to be a starting place for your reporting needs.  While we try to make them as accurate as possible, we always recommend you check them with your data as we don’t guarantee their results.  Differences in how data is entered and used in Microsoft Dynamics GP can produce different results with these templates. 

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.