Wednesday, February 19, 2014

eOne Partnership Programs


We have had a few questions recently regarding the eOne partner program, the need to stay current on the program by renewing the partner agreement and the options for those smaller and less active partners. I wanted to recap some of the details of our partner program here. 

From the day eOne started as an ISV we have been focused on helping both Microsoft and our partners sell more Dynamics GP and more recently more Microsoft CRM. Having formerly been a VAR we understand the need to differentiate yourself in the market by offering clever and configurable solutions that keep the costs down for prospects and customers. 

There are two reseller programs available for those organizations that work as resellers of eOne products. 

Full Partner: It is our wish that all our partners become full eOne partners. We have designed this partner program to ensure the best possible experience as a reseller of eOne Software. Paid up partner program members receive the following benefits: 

1. Rights to resell all eOne software.

2. A very healthy set margin on both software sales and renewals.

3. Access to NFR keys to all eOne software (eXtender Enterprise, SmartConnect, SmartList Builder, SmartView, Flexicoder, Node Builder, SmartPost, etc.)

4. 4 hours of product support with the eOne help desk.

5. Access to free templates for all our products (SLB, Extender, SmartConnect (CRM to GP, Excel Templates)).

6. Marketing assistance, marketing material, marketing campaign templates to help you maximize your revenue opportunity.

7. Regular online product update webinars, feature demos.

8. Full access to our online knowledge base, online manuals and a regularly updated blog.

9. Tech Tuesday blog articles. Every Tuesday.

10. Access to eOne’s demonstration environment that includes all eOne products ready to demo. This environment contains hundreds of examples including demo scripts for all common scenarios.

All eOne partners are required to pay a $1,000 annual renewal fee to maintain access to all of the above benefits.
In return we expect our reselling partners to:

1. Pay the annual $1000 partner fee.

2. Process all new sales and renewals online via credit card.

3. Actively promote our products to prospects customers.

4. Maintain a high level of expertise in eOne products. There are regular training opportunities available both online and in a classroom setting.

5. Make use of our marketing assistance, to maximize revenue opportunities.
 
Registered Partner: This is a limited program for those smaller partners that are not in a position to take advantage of all the opportunities above – but already have a small number of clients using eOne software. The program requires no annual charge and provides:

1. Rights to resell all eOne software.

2. A 10% margin on both software and renewals.

3. Access to NFR keys for use in demonstrations or internal use.

4. No access to eOne support. Support can be purchased in blocks of 4hrs at $165p/hr.
 
Interested in becoming an eOne full or referral partner? Please reach out to us at sales@eonesolutions.com!

Tuesday, February 18, 2014

Tech Tuesday: Line Sequence Numbering

In a previous post I discussed using Global Variables to sum amounts for detail lines. This method can be used for additional purposes such as incrementing sequence line numbers. To accomplish this correctly and quickly we need to understand how SmartConnect processes calculated fields. Basically SmartConnect runs through the calculations for each destination node for a document (the key fields) and then sends that document. Then it moves to the next source record and processes again. This blog article will walk through that process.

I'll use the example of creating inventory item transfers that include items with Serial Numbers. We need to calculate the sequence number for the serial number line since we don't have it available in our source file and we are letting eConnect default the next line sequence number.

Our data source has standard inventory item information. ItemCode, Serial Number, Quantity, Current Location, New Location and Transaction Date.

We will set our key field to the Transaction Date since we want to have one Transfer Document per date in our file.   



Here are the Microsoft Dynamics GP Destination nodes we will map for this transfer integration. We will Create Inventory Transfer header, Add Line Items and Assign Serial Numbers to those line items.

Processing

SmartConnect will take the data source and process each Key Field set, or data grouping, as one document, running through the Assign Serial Number node, Add Line Item Node and then the Create Inventory Transfer Node doing all of the calculations in each node consecutively. The next step is to move on to the Pre Document tasks before sending the data to the destination. After the document process has returned from the destination, the post document tasks are processed.

Data

In this dataset, I have only one transaction date so it will run through this set once.


In this next dataset, SmartConnect will run each process twice since we have two different transaction dates.


The reason for all of the above information is to show how to calculate values correctly within Smart Connect.

Setup

In this example, I need to make sure the Serial Number line will have the same line item sequence as the inventory transaction line where they belong. If we don't, we will get errors like the Line Item Quantity does not match the Serial Number Quantity.

First, we set up two Global Variables using the Global Variables option from the Maintenance menu. We will call one GBL_TRANSFERLINESEQUENCE and the other GBL_SERIALNUMBERSEQUENCE.

In the Assign Serial Number node, we will use the Restriction script to determine the next Transaction Line Sequence number, by checking to see if our Item Number is different. If it is a new Item Number, we increment our line by 16384.

If _ITEMCODE <> GBL_CURRENTITEMNUMBER then
GBL_SERIALNUMBERSEQUENCE += 16384
end if
GBL_CURRENTITEMNUMBER = _ITEMCODE

' Only map this line if there is a serial number
If _SN > "" Then
Return true
Else
Return false
End If

Assign Serial Number Node 

In the Assign Serial Number node, we will create a calculated column called NEXTSERIALLOTSEQUENCE to return the current line sequence number that is calculated in the restriction script using the code below. (This is the VB.NET version). This will give us the Sequence number from the transaction line.

Dim mysequencenumber as integer
mysequencenumber = GBL_SERIALNUMBERSEQUENCE
Return mysequencenumber

Then we will map this to the Line Sequence Number column in our destination.

Add Line Item Node

We can now move on to mapping the line which requires creating a calculated field to increment the Line Sequence, just as we did in the Assign Serial Number line, however we will increment our other global variable.

Create a calculated column called NEXTLINESEQUENCE that increments the GBL_TRANSFERLINESEQUENCE global variable for each item in our group. This assumes we have grouped our data for this node by the Key Fields and then Item Number to create a new line for each item in our data set.

Use this code for the calculated column

dim mysequencenumber as integer
mysequencenumber = GBL_TRANSFERLINESEQUENCE
GBL_TRANSFERLINESEQUENCE = GBL_TRANSFERLINESEQUENCE + 16384
return mysequencenumber

Then map this calculated field to the Line Item Sequence.

Create Inventory transfer Node

The Create Inventory Transfer node does not require any special settings and can be mapped as follows.

Final Step

As a final step we need to reset the global variables to make sure the calculations are correct for the next document. We will create a Script Task that runs before the document which can be misleading however. This really means the task is executing before it is sent to the destination not before the data is gathered for processing. What we are really doing is clearing the variables before the next document begins processing.

Here is the code we will use for this Pre-Document Task

GBL_TRANSFERLINESEQUENCE = 16384
GBL_CURRENTITEMNUMBER = String.Empty

return true

Here is the screen showing the Document Task

Summary

To summarize, SmartConnect executes each node separately for a given document, defined by the key fields of the map, before sending the document to the destination. The order the nodes are processed is the order they appear in the destination.

Happy Integrating!!


Interested in learning more about SmartConnect? Feel free to reach us at sales@eonesolutions.com!

Thursday, February 13, 2014

eOne at Convergence 2014

Convergence is just 19 days away! 

If you're like us, you're busy prepping for your trip and planning your schedule. With that in mind, we want to make sure you know how to get in touch with our team. We'll have our developers, consultants, sales people, and wearers-of-many-hats in Atlanta, ready to meet customers and partners alike. So, here's where to find us! 

1. Stop by our booth. We'll be at booth #1140 - in shifts. So if you have someone in mind that you'd like to see when you stop by, email them early to make sure you set up a time. 

2. Line up a Meeting with the Team. We are at Convergence to help customers & partners in any way we can. If you'd like to sit down and meet with the team, email me (abbey.cooper@eonesolutions.com) what you'd like to meet about and what time works well and I will get you connected. 

3. Join us at one of our 12 sessions. We're thrilled to have the opportunity to present 12 sessions at Convergence and would love to have you join us:

Tuesday, March 4th
3:30 pm - Excel Report Builder: To Excel & back
5:00 pm - Intro to Extender

Wednesday, March 5th
9 am - GP SmartList Builder: Going all the way
11 am - GP SmartLists Panel
3:30 pm - GP SmartLists Panel  (Repeat)

Thursday, March 6th 
9 am - GP Extender: You've built a few windows, what's next? 
9 am - Using SmartList Builder effectively
11 am - SmartList Builder: Building lists from scratch
2 pm - Using SmartList Builder effectively (Repeat)
2 pm - 50 Tips in 50 Minutes: The Builders
3:30 - GP SmartLists Panel (Repeat) 

Friday, March 7th
11 am - Ask the experts: Integration Tools

Again, please reach out to me if you'd like to line up a meeting as I would be happy to connect you. See you in Atlanta! 

Wednesday, February 12, 2014

New Releases of SmartView 2013 and SmartView External

We are happy to announce that we have released new builds of SmartView 2013 and SmartView External, which you can find here.  

The major change to SmartView and SmartView External is allowing them to take advantage of the new SmartList Builder features such as the Auto Refresh and Modify/New buttons.

There is also a new feature for the viewing of the different document statuses. Depending on the transaction list you are running, you will have the option to mark a status to quickly view only the documents that match that status.

The look and navigation of SmartView and SmartView External has also changed to update the icons and display grids.

Have you had a moment to check out SmartView? If not, sign up for our weekly demo here or take a look at some of our SmartView videos. 

Tuesday, February 11, 2014

Tech Tuesday: SmartList Builder 2013 no longer requires Service Pack 2

Due to a high volume of requests, we have built a version of SmartList Builder with our new features included that now works with any release of Microsoft Dynamics GP 2013. 

All of the new features in the latest SmartList Builder 2013 release will work with any release of GP 2013. There is just one small portion of the release that won't be available until Service Pack 2 is installed. This is the option to hit the New and Modify buttons in SmartList to open SmartList Builder directly from SmartList and create either a new SmartList or Modify an existing SmartList.  If Service Pack 2 for Microsoft Dynamics GP isn't installed, you will have to open SmartList Builder from the menu and then create a new one or modify and existing SmartList.

Want to become a SmartList Builder Rockstar? Join me for online training or before Convergence! Emailed sales@eonesolutions.com for more information.