Tuesday, August 27, 2013

Tech Tuesday – Sum Document Line Amounts Using Global Variables

Today's Tech Tuesday article comes to you from our Professional Service Director, Lorren Zemke:

Depending on the data source, there may be a time where you need to sum amounts from the line items into a document header. You may have a document that contains distribution details that need to be rounded or multiple data elements that need to be added together to store at the document header level. For this article we will be talking about summing amounts from an Excel file that has distribution amounts we need to sum together to create the voucher amount.

First, we will create a Global Variable that can be used to sum the values at a document line level and stored at a document header level. We start by creating a global variable which we will call GBL_PAYABLESTRXAMOUNT and assign a default value of 0. You can view a previous blog entry on how to create Global Variables and assign default values. http://eonesolutions.blogspot.com/2011/04/tech-tuesday-global-variables.html

We will start with our Distribution node to create our calculated amounts that need to be summed. Our document source contains debit and credit amounts that may be negative or positive so we will create a calculated column for each.  Below is our DEBITCALC amount and we will do the opposite for the CREDITCALC.




We map the calculated Credit and Debit amounts to the distribution Credit Amount and Debit Amount destination columns respectively.



In the Restrictions script we sum the Debit and Credit calculated amounts to our Global Variable since the Restrictions script runs for each line in our data source while creating the Payables Distribution.

 


We are returning true in all cases for our Restriction because we are not restricting any lines just using the process for summing our values.

Now, we move to the Payables Header node where we take the summed amount and map it to the Payables amount.  To get the global variable amount create a new calculated column to return the global variable since we cannot use the global variable as a source column.

 


Normally in our calculated column we would clear the global variable for this document so the system would not continue to add amounts for multiple documents together. But Payables also has another destination column where we want to use the same amount as our purchases amount we will create another calculated column and clear our global variable in that calculation.
 



Once the document amount calculations have been created, map them to the destination columns.

Have further questions or comments on what Lorren shared? Drop him a line at lorren.zemke@eonesolutions.com.

Monday, August 26, 2013

Top 10 Reasons to use Extender

Extender is one of the most critical tools a company using GP can have in their tool belt. Here are the Top Ten Reasons to take a look at Extender:


1. Extender Makes GP Fit Your Business: Stop trying to make your business fit into GP, use the most flexible solution available to configure GP, just the way you want.
 
2. Extender Grows as You Do: Make changes to the data you capture when your business grows and changes.
 
3. Extender Lets You Eliminate Spreadsheets: Get rid of spreadsheets that duplicate GP data and track what you need, where you need it.
 
4. Extender Improves Your Data Quality: Never doubt your data again. Trust your data in GP.
 
5. Extender Saves You Money: Invest in the solution that is about 1/10th of the cost of customizations.
 
6. Extender Provides Easy Upgrades...and Less Expensive Ones, too!: Since you're not spending time sorting through a developer's code, you can update quickly & easily.
 
7. Extender Lets You Trigger Dex Code Anywhere, Anytime in GP: No other solution gives you so much flexibility with GP.
 
8. Extender Lets You Own Your Solution: You can switch partners, do all changes in house, whatever you want - you have the freedom!
 
9. Extender is Built by the ISV with the Most Customers Using Their Products in GP: With over 4,000 Extender customers to date, there are amazing Extender solutions out there and we can help add your solution to that list.
 
10. Extender is Supported By the Best: Highly experienced GP guru's who can train, advise, review and support your Extender solution are the people you'll be dealing with on the help desk.
 

Sound like a solution you want to add? Want to know more? Contact Abbey or Danielle by emailing sales@eonesolutions.com for more info!

Wednesday, August 21, 2013

SmartConnect Excel Data Entry Templates for Microsoft Dynamics GP 2013

We've heard your requests loud and clear and are pleased to announce the release of our new, SmartConnect Excel Data Entry templates for Microsoft Dynamics GP 2013. We've vastly improved their functionality and usability. Take a moment to learn about some of the key features:

1. No need to load SOAP.
2. Run data to multiple companies right from the Excel sheet.
3. Rows added dynamically to sheet as the last row is used.
4. Change/refresh all underlying data sources from one simply screen.
5. Readme with complete instructions INSIDE of the Excel sheet.
6. Lookup by ID or descriptions (eg Account/Account Name, Customer ID/Customer Name, Item/Description)
7. Round to 2 decimal places everywhere.
8. Added Payables default distributions.
9. Added generic template to pass in whatever data you want.
10. All templates zipped in one file or downloaded individually...but still FREE.

You can find the templates here:
 
If you have any questions, let us know! We hope these are a huge help to you. The data entry templates provide you with ways for users to do their data entry outside of GP - saving on GP users needed and keeping things simple.
 
Need help setting up your SmartConnect integrations? Let us know - we'd be happy to help!
 

Tuesday, August 20, 2013

Tech Tues: Organizing the SmartConnect Map List

Today’s article is a bit less “techy” but covers a few organization tips that will help clean up how SmartConnect looks once you get a large amount of maps created. All of the grouping and organizing done in the video can be set per user, so each person can customize their view of the maps within SmartConnect.