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.


Monday, August 19, 2013

When to call in an expert?

When to call in an expert?
In any project there comes a point where you need to decide on a ‘DIY” model or whether it is best to call in an expert. How do you make that decision?

When I was growing up you did everything yourself that you could.  There was no ‘career’ (that I knew of) as a residential landscaper as everyone looked after their own yard. You would build gardens, plant trees, water by hand, build a fence, lay your sod etc.   In my street right now there are 5 new homes that are making this decision. 3 homes chose to call in an expert (and pay for it).  These neighbors got to sit back have a coffee and watch experts landscape their gardens. A team of experts turned up with all the tools and machinery they could possibly need. Job done right and fast.  

The other neighbors decided to do it alone. They slaved day after day with wheelbarrows, installing sprinkler systems, pulling weeds, building walls.  I am sure eventually all five gardens will be very fine – but right now there are three great looking gardens – and 2 that are less than great – and yet those 2 ‘not so great’ ones are still working long into each evening while I sip my second chardonnay.

Last week eOne moved into a new office (it is fantastic).  We needed a new keypad lock installed on the front door.  One nameless and very helpful eOne employee stated – ‘that’s easy I have done it before I will install it for you.’ Great – will save $500 and why not?   So 7 hours and 2 trips for new tools later Chris was still fighting with the front door lock and left it in 13 small unassembled pieces.
The next day a locksmith came by to work next door and so Chris grabbed him to take a look. Approximately 7 minutes later the lock was removed and installed.

So the question here is why and when do you decide to use an expert? We like expert doctors, dentists, lawyers and usually accountants. Electricians, plumbers, builders usually. We like bankers and estate agents to know what they are doing.  What about IT? What about IT Reporting? What about IT integration projects?

Something that is unique about the IT world is that we are very prepared to teach our own customers what it is that we know. Imagine calling your plumber and asking for a lesson in installing irrigation so you can do it yourself and not use him?  What about calling you estate agent and asking for a lesson in how to buy a house – so you would not have to use an agent!! Does your doctor give you diagnosis lessons?  The reason why, is that there are hundreds and hundreds of hours and experience going into these people become experts.  

So on your next project do one of the following things:
1.      Seek out top quality training.  It will save you a fortune in both money and time.
2.      Even after training, use an expert where you are out of your depth.
3.      Hand total responsibility to an expert – and you manage the process similar to if you were buying landscaping.