Skip to content


Tech Tuesday: Automatically changing Dynamics GP SOP distributions based on business rules

The Flexicoder product is one of the most interesting ones in the mix offered from eOne. Businesses that need it, REALLY need it while the businesses that don’t, REALLY don’t. Let me explain, when you have an internal business need to track your Sales or COGS (or other accounts) by something other than just the account attached to the item or customer you introduce a manual process. Manual processes introduce humans into the equation and humans make mistakes!
Flexicoder helps you eliminate the time-consuming and error prone processes by defining the business rules one time and having the system automatically apply the rules for each transaction. I will outline two scenarios where you can see Flexicoder applied to change one or more of your account segments based upon the rule you setup.
Scenario 1: Change the first account segment based on Salesperson
One common scenario we see is a need to recode one of your Segments based on a Salesperson or Sales Territory. Both of these options are available to you with a host of others as well. In the image below you can see that it will automatically fill with the values for your Salespeople and then you can assign the values that are appropriate for your business case. The example below shows assigning some of the segments and leaving others to stay with the standard account.

This is a simple example of using the Sales distribution type but you have the ability to recode Accounts Receivable, Cash, COGS, Freight, Inventory, Markdown, Miscellaneous, Sales and Trade Discount types in the Sales Order Processing area and quite a few others in the Receivables area.
Scenario 2: Change the first and third segments based on Salesperson and additional Extender fields
This scenario shows that we can recode multiple segments and can use Extender windows to hold information to recode a segment. In this example I have an Extender window on the Sales Transaction Entry form in Dynamics GP that simple tracks a Subscription Type field as Monthly or Annual. I will see any Extender window attached to the Sales Transaction Entry, Item, or Customer windows in Dynamics GP.

One other thing to point out is that in the image above is the Exception area on the bottom right corner. This is a great tool to have if you need to exclude certain accounts, document types, batches or customers from the predefined process.
Finally, in order for this to work, you simply save the transaction and then pull it up again to view the distributions that have changed.
If you have a need for this try it out in the sample company and see if it will reclaim an hour a day to do something better than change distributions manually.
If you have any questions regarding Flexicoder or simply would like more information please email and we would be happy to assist you!

Leave a Comment


Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock
Tech Tuesday: Popdock User Security in D365 Business Central
Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING


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.