Tech Tuesday: Extender Window Table Links

For this week’s Tech Tuesday we will feature an Extender demo video from Nicole Albertson, our Extender Product Specialist. She will take you through using Table Links to make sure that your Extender data and your Microsoft Dynamics GP data stays in synch. Please note that this video utilizes Extender in Microsoft Dynamics GP 2013.

Curious about what else Extender has to offer? We’d be happy to share with you and answer your Extender questions at sales@eonesolutions.com.

Read More:
Tech Tuesday: Extender Window Table Links

September 24, 2013 · Abbey · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 256

First and Last day of Previous Month

In the accounting world I so often need to limit my selection criteria to the first and last day of the previous month. This is certainly not a secret formula, but I now have a place where I can look it up. Sadly, I have not memorized this formula

First Day of Previous Month:

DATEADD (m,-1, DATEADD(d,1-DATEPART(d,GETDATE()),GETDATE()))

Last Day of Previous Month:

DATEADD(d,-DATEPART(d,GETDATE()),GETDATE())

Example:

SELECT * FROM SOP30200
WHERE  

VOIDSTTS = 0 and DOCDATE between
DATEADD (m,-1, DATEADD(d,1-DATEPART(d,GETDATE()),GETDATE())) and
DATEADD(d,-DATEPART(d,GETDATE()),GETDATE())

Until next post!

View article:
First and Last day of Previous Month

September 21, 2013 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 237

A Peak into a Conversation on Integration Manager

From time to time, we are privy to conversations between a customer & a partner where the customer expresses frustration in their current solution and the partner decides that putting a band aid on the problem is not a solution. Here is an example of one of those conversations we received yesterday. (Note that all names have been changed to protect the customer and partner.)

Joe the Customer: “Integration Manager crashed TWICE before finally working (I hate that program). So each time it crashed it caused an invoice to get stuck somewhere that I can’t see. Could you go in and find those invoices and delete them?”

Paul the Partner: “Which company?”

Joe the Customer: “Company A.”

Paul the Partner: (One day after initial reported problem – due to emails back and forth.) “Ok, take a look now.”

Joe the Customer: “That worked. Thank you.”

Joe the Customer: (One day later) “Argh. I had to repost this batch, and forgot to turn off AA. So the same thing just happened. Is there any way you can do this again?? Annoying!!”

Paul the Partner: “No problem. What are the invoice numbers? By the way – have you thought of using SmartConnect?”

Joe the Customer: “Should be the only one in there… and yes, I would like to try SmartConnect. I just don’t know where to begin.”

Paul the Partner: “I’ll reach out to eOne to have them provide info on using SmartConnect in Fabrikam to test it out.”

From this conversation, the eOne team was able to provide the customer and partner information on testing out SmartConnect in Fabrikam without needing reg keys, pointed to the great resources and online manual available to utilize for their tests and shared training and support options to get the customer up and running.

If you feel like Joe the Customer or Paul the Partner, reach out to us and learn how SmartConnect can replace Integration Manager. Email sales@eonesolutions.com for more info.  

Originally posted here:
A Peak into a Conversation on Integration Manager

September 20, 2013 · Abbey · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 230

Microsoft Dynamics GP Technical Airlift 2013 – More on Day 1

How does one manage to talk about a Conference when not in attendance? Well, you get reporters on the ground to tell you what’s going on.

Sivakumar Venkataraman with Microsoft reminds everyone of the different tracks and sessions features in each:

My good friend Thomas Franz over at Integrity Data had a few things to relay, starting from a shout out to Microsoft and GPCC for the great content. His appreciation however goes to the one-off conversations with the Microsoft team and members of the GP community. While Thomas was entertained, elsewhere his coworker, Bobby, managed to pin down my good friend Brian Roney for a possible solution to a big customer request. Kudos to Brian and Michael Hammond who were kind enough to pickup the session I was going to deliver, Developing for the Web Client: a Microsoft Dexterity perspective. Thomas also attended the opening session with Chad an Errol and enjoyed all the roadmap talks. You can read more about the roadmap in my Day 1 coverage. Thomas also attended the Web Client Customization with VST session and noted the flexibility it provided for some of the work they are doing over at Integrity Data. I covered a great deal of this in my article VST: Rendering WinForms in Microsoft Dynamics GP web client

Thomas also attended the Deploying Microsoft Dynamics GP 2013 on Windows on Azure session presented by my good friend Daryl Anderson. He was looking at this for a possible SharePoint hosting solution for their U-LINC customers. 

After the day of sessions, they headed outside for the welcome reception were discussions revolved around current project issues.  Somehow, the Integrity folks managed to muster some energy to host a coding party in Bobby’s room at the hotel. Bobby and Nick started proving out Brian Roney’s suggestion and I provisioned a new SharePoint server on Azure.  Where else do you get to do this stuff?

I am sure there was a lot of serious conversations going on at the Welcome Reception, but I find that some people just prefer to enjoy life for what it is… you go ladies!

Windi Epperson (The Knaster Group)
Linda Brock (The Knaster Group)

More on Day 1:

GP Airlift 2013 – Day 1 (Kuntz Consulting Blog)

Thanks to my reporters Thomas Franz with Integrity Data and Tanya Henderson with S2 Technology.

Day 2 updates to follow.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Excerpt from:
Microsoft Dynamics GP Technical Airlift 2013 – More on Day 1

September 20, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 276

Date Function Errors from SmartList Account Transactions fixed in Microsoft Dynamics GP 2013 Service Pack 2

David Meego - Click for blog homepageA little while ago I spent some time in a long screen sharing session to identify the cause of some really unusual errors being generated from SmartList Account Transactions favourite in Microsoft Dynamics GP 2013 Service Pack 1. This issue has now been fixed for Microsoft Dynamics GP 2013 Service Pack 2.

The errors did not occur on the RTM build, before Service Pack 1 was installed, and do not occur with all transactions listed in the SmartList. The script errors will be in the form:

Unhandled script exception:
Invalid year ’20’ in date function. Script terminated.
EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE
SCRIPT_CMD_SETDATE

Unhandled script exception:
Invalid month ’13’ in date function. Script terminated.
EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE
SCRIPT_CMD_SETDATE

After some research including capturing logs with the Support Debugging Tool, reviewing the source code and analysing the way the source code works using Runtime Execute and SQL Execute scripts in the Support Debugging Tool, we were able to identify the cause of the issue.

Service Pack 1 contains a fix for Problem Report 56666: Drill back on recurring transaction from Account Transaction Report in SmartList brings up incorrect transaction information. The code changes for this fix work most of the time, but fails for a recurring transaction that has been repeated more than 9 times.

This fix adds the Recurring TRX Sequence number and Transaction Date (in YYYYMMDD format) to the hidden string field in the SmartList window used for linking back to the transactions.

For example:

1                   1                   1GL_Normal      120141.0000020131231

The code that extracts the date from this string expects the Year, Month and Day in specific positions:

l_year = substring(l_string, 69, 4);   = 2013
l_month = substring(l_string, 73, 2);  = 12
l_day = substring(l_string, 75, 2);    = 31

giving a date of 31/12/2103 (in DD/MM/YYYY format)

However, when the Recurring Sequence Number is greater than 9.00000, it causes the string to grow and the date information to be shifted:

5426                57185               1GL_Normal      12013266.0000020130701

This example has a sequence number of 266.00000 which causes the date to be shifted two more characters to the right.

l_year = substring(l_string, 69, 4);   = 0020  — Not valid
l_month = substring(l_string, 73, 2);  = 13    — Not valid
l_day = substring(l_string, 75, 2);    = 07

Giving a date of 07/13/0020 (in DD/MM/YYYY format)

Depending on the date and the number of characters shifted, you will get date function errors for year, month or day.

This issue was reported and is now fixed in Microsoft Dynamics GP 2013 Service Pack 2.

While the customer waited for Service Pack 2, I created a fix using the Support Debugging Tool. I used a Non-Logging Trigger to update the hidden string when a line in the SmartList is clicked on. The trigger script removes some of the decimal place characters from the Recurring Sequence Number so that the date is then in the expected position.

For example: 266.00000 is reduced to 266.000 which is still the 7 expected characters. Which in turn leaves the 8 characters of the date (in YYYYMMDD format) in the correct location.

The trigger is attached to the bottom of this article for your reference, however, the best solution is to install Service Pack 2. If the trigger is installed on Service Pack 1, it will need to be removed once Service Pack 2 is installed to allow the fixed code to work.

Hope you find this useful.

David

View original post here:
Date Function Errors from SmartList Account Transactions fixed in Microsoft Dynamics GP 2013 Service Pack 2

September 20, 2013 · David Musgrave · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 699

Attention: Our website & email will be down this weekend!

Attention eOne Partners –

This weekend, beginning Friday, Sept. 20th at 5 pm CST until Sunday, Sept. 22nd at 5 pm CST, eOne’s website and email will be down due to scheduled system updates.
 
If you have scheduled installs or plan to work at a customer site over the weekend, we highly encourage you to download the builds and reg keys you need by tomorrow at 5 pm CST.
 
If you have any questions or concerns regarding our website or email, please feel free to reach out to us (before Friday at 5 pm) at sales@eonesolutions.com.

Thank you and have a wonderful weekend!

More:
Attention: Our website & email will be down this weekend!

September 19, 2013 · Abbey · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 245

Microsoft Dynamics GP 2013 Service Pack 2 Feature of the Day: VS Tools

This is one of my favorite features in Microsoft Dynamics GP 2013 Service Pack 2.

More:
Microsoft Dynamics GP 2013 Service Pack 2 Feature of the Day: VS Tools

September 19, 2013 · Pam Misialek · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 214