Back

Variable Allocation Accounts SmartList Builder Template

Published: Jun 19, 2015
Post Author Written by eOne Solutions

The Variable Allocation Accounts SmartList Builder setup is built to return a list of the distribution and breakdown accounts for the active Variable Allocation accounts.

This SmartList Builder setup is built based on a SQL Script written by Victoria Yudin. You can find the script and many other resources at www.victoriayudin.com. Thank you Victoria for contributing to the SmartList Builder community.

ID: VAR_ALLOC_ACCTS

Name: Variable Allocation Accounts

Tables Involved:   

  • Account Master
  • Variable Allocation Master

 
Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.

 061915_1655_1

  061915_1655_2

 061915_1655_3

 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.