Convergence 2011 IT Professional Track

Convergence 2011 – IT Professional Class Offerings

 

CSGP06-R1 Getting More Out of Microsoft Dynamics GP: 50 Tips in 50 Minutes

Track: Microsoft Dynamics GP

Speaker(s): Mark Polino

Room: Marcus Auditorium

Audience: IT Professional, Technical Decision Maker, Business Decision Maker, Power User, End User

Skill Level: 100 – Introductory

Industry:

Tuesday, April 12

15:00-16:00

Add to Calendar

Session Details 

Back by popular demand, this fast-paced workshop delivers something for everyone–beginners, intermediate and advanced users–as we share Microsoft Dynamics GP tips that you’ll want to race back and implement. With a briefcase of little nuggets that ‘wow’, including the how-to’s of the custom links feature, deleting auto complete entries and adding comments without using a comment ID, you don’t want to miss this. Past attendees have shared that this was the most useful session of the conference.

CSGP07-R1 SQL Reporting Services Using Microsoft SQL Server 2008

Track: Microsoft Dynamics GP

Speaker(s): Jen Olson

Room: A410

Audience: Prospect, Technical Decision Maker, End User, IT Professional, Business Decision Maker, Power User

Skill Level: 200 – Intermediate

Industry:

Tuesday, April 12

15:00-16:00

Add to Calendar

Session Details 

Attend this session and you’ll soon see the flexibility at your fingertips when you discover how to use Microsoft SQL Reporting Services 2008 and the Report Builder 2.0 tool to create reports and gauges with your Microsoft Dynamics GP data. See how the reports you have created can be deployed and integrated with your Microsoft Dynamics GP client and rendered within your report manager web page.

CSGP08-R1 Connect & Collaborate with Business Portal

Track: Microsoft Dynamics GP

Speaker(s): Tom Higginbotham, John Dooley

Room: A305

Audience: Technical Decision Maker, IT Professional, Business Decision Maker, Power User

Skill Level: 200 – Intermediate

Industry:

Tuesday, April 12

9:00-10:00

Add to Calendar

Session Details 

Join us as we showcase how to leverage the Microsoft SharePoint platform to extend the reach of Microsoft Dynamics GP in your organization and enhance the capabilities of Business Portal. Explore tools that are available–many which do not require deep programming knowledge or large dollar investment–and investigate how you can take advantage of them to build collaborative solutions. You’ll see scenarios that show how to harness the power of the platform as well as how to make your people more productive.

CSGP09-R1 Installing & Troubleshooting Business Portal 5.1

Track: Microsoft Dynamics GP

Speaker(s): Jerad Plesuk

Room: A313/314

Audience: Technical Decision Maker, IT Professional

Skill Level: 200 – Intermediate

Industry:

Tuesday, April 12

10:30-11:30

Add to Calendar

Session Details 

Business Portal 5.1 for Microsoft Dynamics GP 2010 is the newest version of Business Portal, and the first designed to utilize all the advantages that a 64-bit environment has to offer. Learn the best practices, tips, and hints for installing

PO Returns Chunks File

 

When invoicing a receipt in POP, this customization will check the previous quantity invoiced and the quantity returned for the line item. The maximum quantity allowed to be invoiced is based the following formula: Quantity Shipped minus (Previous Quantity Invoiced plus Quantity Returned). This customization will not allow invoicing of more than this amount.  If this is the tool you need, then you may use the attached file.  Please unzip the file from the link above and read the PO Returns 10 word file for the install instructions.

 
 

SSRS Page Totals can be a bit Challenging! See how here!

In SSRS, the best way to get a page total is to first create a page footer and add a text box to it.  Add an expression to the text box to create the sum of the
field you want.  In footers you cannot sum actual fields in the report, so you have to sum the textbox that the field is located in.  For instance, if
you want to have a page total of the field “
extprice”, then you have to use an expression referring to the textbox that the field "extprice" is located in.
It looks like this.  =Sum(ReportItems!
extprice.Value) or yours may say =Sum(ReportItems!Textbox1.Value) That will give you a pagetotal on each page.  

 

As far as a Grand total on the last page, and you probably need it to line up even or lower than the page total you have, you need to go a slightly different

route.  Add a footer to your Matrix.  So, insert a row that is outside of the grouping below and then create a sum for the specific field that you want like this.

=SUM(Fields!extPrice.Value).  That will give you the grand total at the bottom of the Matrix.  To get it to be in the pagefooter and to make it show up only
on the last page you do this:  Set hidden=True for the visibility property of the grand total row of the matrix.  Create another text box in the page footer.

Create an expression referencing that grand total you just created.  Only this time, do not sum it because it is already summed in the Matrix.   =ReportItems!TotalDue.Value