Extender 2013 Feature of the Day: Lists/Note Types

What has changed?

When setting up a list field, you can now enter in the list items all in one window.  You can separate each list item with a comma or carriage return. 

When selecting to add new items to the list, you will see the following window where you can type in the list of items to add or cut and paste the list of items from another source such as Excel.  The Add Note Types window looks and works the same as the Add List Items window.
 
 

Copying a list is as easy as copying the data you want to make a part of the list and then pasting it in the Add List Items window. 
 
When you then Add those items, the values are parsed into a list of items.

Read this article:
Extender 2013 Feature of the Day: Lists/Note Types

March 8, 2013 · Nicole Albertson · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 147

Using CTEs with SQL Reporting Services with Microsoft Dynamics GP

Christina Phillips explores Common Table Expressions (CTEs) and how they can be used to simplify selecting data for comparisons when creating SQL Reports for Microsoft Dynamics GP.  She walks through the structure of a SQL statement containing CTEs and then uses the statement to create a comparative sales report with Report Builder 3.0.

See original article:
Using CTEs with SQL Reporting Services with Microsoft Dynamics GP

March 8, 2013 · Christina Phillips · No Comments
Tags: ,  · Posted in: Blogs I Follow Total Views: 112

Using CTEs with SQL Reporting Services & Dynamics GP

We had a great time doing a webinar recently for the GPUG Special Interest Group (SIG) for SQL Reporting Services. We talked about using Common Table Expressions (CTE) to simplify queries for reports. CTEs were new in SQL Server 2005 and can replace using derived tables. Essentially, they create temporary result sets using nested SQL statements. CTEs also are useful in contrast to derived tables because they can self-reference and be referenced multiple times.

Here is a sample CTE used to compare year-over-year sales information for customers:

–1st CTE

WITH CTE_Customer

AS (select CUSTNMBR, PERIODID, YEAR1, SMRYSALS from RM00104 where HISTTYPE=1 and YEAR1=@YEARFIRST),

–2nd CTE

CTE_CustomerCompare

AS (select CUSTNMBR AS CUSTNMBR2, PERIODID as PERIODID2, YEAR1 as YEAR2, SMRYSALS as SMRYSALS2  from RM00104 where HISTTYPE=1 and YEAR1=@YEARSECOND)

–Overall SELECT statement

Select CTE_Customer.*, CTE_CustomerCompare.* from CTE_Customer left outer join CTE_CustomerCompare  on CTE_Customer.CUSTNMBR=CTE_CustomerCompare.CUSTNMBR2 and CTE_Customer.PERIODID=CTE_CustomerCompare.PERIODID2

Note the use of WITH to define the first CTE (called CTE_Customer); a comma precedes the second CTE (called CTE_CustomerCompare). The SELECT statement for each CTE is nested after AS. Last but not least, we have the SELECT statement that actually pulls the information from the CTEs.

In Report Builder (for SQL Reporting Services), we can then create a dataset using our CTE statement as follows:

Note the use of two parameters (@YEARFIRST and @YEARSECOND) to make the report dynamic, so we can select two different years for comparison based on our needs. After creating the dataset, we can design the report using the fields selected from the CTEs.

Then when we run the report, we can specify the two years (based on the parameters in the statement) and review our report:

Email cphillips@bkd.com for more CTE examples and sample RDLs of reports created with CTEs.

Read More:
Using CTEs with SQL Reporting Services & Dynamics GP

March 7, 2013 · Christina Phillips · No Comments
Tags: , , , , ,  · Posted in: Blogs I Follow Total Views: 168

Management Reporter 2012 with AA Budget Tree Reporting

April Olson has posted a couple of cool videos in her blog article where she demonstrates the following: Generate a report at Account Level when using a Budget Tree Generate a report at Tree Level when using a Budget Tree Take a look at her article in the link below. Reporting on Dynamics GP Analytical Accounting Budget Trees You can watch the videos from the links below. Reporting on Analytical Accounting Budget Trees – Part 1 of 2 Reporting on Analytical Accounting Budget Trees – Part 2 of 2 I hope the community finds these videos interesting and new learning…

More:
Management Reporter 2012 with AA Budget Tree Reporting

March 7, 2013 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 397

New Quote feature on the eOne Site!

Have you heard about the new feature on our website that allows you to create quotes for products and services? Prior to this week, you could only auto-generate a quote for renewals. With so many requests for product and service quotes however, we decided to make things much easier for you. All you need to do is:

1. Login to our website if you’re a partner. If you’re not, that’s ok, direct customers can skip this part and still generate a quote.
2. Click on “eOne Shop.”
3. Add the products, services, and support packages to your cart that you’d like.
4. Click “Go to Checkout.”
5. Review the items in your cart and click “Get Quote” at the bottom.

That’s all there is to it! In less time than it takes to email in your request, you can have a quote in your hands and off to the customer.
A few things to remember when you generate quotes on your own:

1. eOne quotes are valid for 30 days from the date on the quote.
2. Don’t forget to include support, services, and/or training on your quote. The product and maintenance purchases do notinclude those items!
3. If you have questions or need helping deciding what to include on your quote – we’re here to help – give us a call!

Do you like the new site? Has it made your life easier? I’d love to hear from you. Feel free to drop me a line: abbey.cooper@eonesolutions.com.

Continue Reading:
New Quote feature on the eOne Site!

March 6, 2013 · Abbey · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 180

Web Services Management Tools Error – Could not … – azurecurve

View azurecurve’s Feed on Twitter View azurecurve’s pheed View azurecurve’s facebook page · View azurecurve’s Google+ View not access the SecurityService service. The request failed with HTTP status 404: Not Found

View article:
Web Services Management Tools Error – Could not … – azurecurve

March 6, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 148

Microsoft Dynamics Convergence 2013 New Orleans is almost here

David Meego - Click for blog homepageUnless you have been hiding, you should know that Microsoft Dynamics Convergence 2013 in New Orleans is just around the corner.

It is being held at the Ernest N. Morial Convention Center (NOMCC) in New Orleans, Louisiana, USA on Monday 18th March 2013 to Thursday 21st March 2013.

The conference will have all your favourite sessions (Keynotes, General Sessions, Concurrent Sessions, Interactive Discussions, Deep Dive Sessions, User Group Sessions, Roundtable Discussions, Sponsor Sessions, Hands on Labs and more).

It will also have all your favourite people, the Microsoft Dynamics GP product and support teams, the Microsoft Dynamics GP MVPs, and lots of great partners and customers. And not forgetting Keynote speakers Kirill Tatarinov and Kofi Annan and the excellent band Matchbox Twenty performing at the closing celebration.

However, sadly … not me. This year I was unable to persuade the “powers that be” to bring me over to the US for Convergence. That said, I will be there in spirit and am working hard on some cool new features in the Support Debugging Tool.

My friend Mariano Gomez will be demonstrating the features in his session on the tool. Check out his posts to see the other sessions he will be presenting:

 

This is going to be a fantastic event. Hopefully I can make it next year.

David

View article:
Microsoft Dynamics Convergence 2013 New Orleans is almost here

March 6, 2013 · David Musgrave · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 177