Archive for April 29, 2011

What is Days Sales Outstanding (DSO) and how it is calculated?

The concept that I learned in past 2 days is this: Days Sales Outstanding (DSO) and the way you calculate it.

Joshua Burnett has posted an article on this way back in March 2009. Read it here: The DSO Calculation (Days Sales Outstanding).

It’s quite simple and yet very deep in concept. I simply loved to read and learn. I am sure it would be useful to some people out there, trying to understand what DSO is all about.

VAIDY

See original here:
What is Days Sales Outstanding (DSO) and how it is calculated?

April 29, 2011 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 973

Hey Canadian partners please come visit me in Toronto at Virtual Launch Event

I’ll be there in person but you can also view online. We invite all Canadian technology partners for Microsoft Dynamics GP to view this virtual launch from the comfort of their home or office

Visit link:
Hey Canadian partners please come visit me in Toronto at Virtual Launch Event

April 29, 2011 ·  · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 275

Feature of the Day: Reporting Ledger Functionality for Fixed Assets Management

Reporting Ledger Functionality for Fixed Assets Management Why this feature is cool! This feature allows the user to set up a reporting ledger whether Base, International Financial Reporting Standards (IFRS), or Local ledgers for a book ID to report Fixed Assets transactions.

See more here:
Feature of the Day: Reporting Ledger Functionality for Fixed Assets Management

April 29, 2011 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 290

Dexterity I class scheduled for May 16th – 20th, 2011 will be running as scheduled

There are 3 seats left and still time to sign up!

Come join us in Orlando for Dexterity Basics training.

The Dex I class is being held at the facility of Integrated Business Group (IBG). IBG is a Certified Partner for Learning Resources and have the best classrooms I have ever seen. Comfortable chairs and lots of room to spread out!

For more information and to register call Roxanna Alvarez @ 407-677-0370 or e-mail her directly ralvarez@ibgnet.com.
Date and Location:

  • When: May 16th – May 20
  • Where: Orlando Florida

This class is very hands-on and starts at the beginning; no previous Dexterity experience is necessary.

A synopsis of the class is below this post.

I hope to see you there!

Until Next Post!
Leslie Vail

Dexterity I – Product Fundamentals
Synopsis:

Dexterity Product Fundamentals will teach you about the development environment used to build the Microsoft Dynamics GP family of products. This course will provide you with the foundation you need to build integrated, database-independent applications. In addition, you will learn how to provide powerful application functionality for Microsoft Dynamics GP.

By actively participating in these classes, you should learn:
Basic programming techniques used by Microsoft Dynamics GP to develop their core modules.

  • How to modify existing Dynamics GP forms and reports in order to make customizations for customers.
  • How to develop add-on applications that will interact with the Dynamics GP products to meet specific requests by customers.
  • How to package and ship your dictionary allowing Microsoft Dynamics GP to make updates to Dynamics GP without affecting the developer’s dictionary.
  • How to register your product with Microsoft Dynamics GP using a unique Product ID to ensure no duplication of add-on applications with the same name.
  • How to develop add-on applications that will “look and feel” like Dynamics GP and provide seamless interface between the applications to ensure a professional finished product.
  • How to use object triggers, which are scripts in your applications that are invoked by events in Dynamics GP, allowing several developers to deliver enhancements to the same Dynamics GP form.

Who should attend?

Customers or Partners who will be customizing or building add-on or standalone applications to integrate with the Microsoft Dynamics GP products.

General Prerequisites:
Prior to attending the course, it is highly recommended that students prepare for the course by going through the Dexterity Quick Start reference manual and working through the lessons in that manual. The Quick Start manual is located on the second CD of Dynamics GP and can be found under the Help-Online Manuals option from within Dexterity. Also, necessary is knowledge of basic programming concepts.
Price: $2,995 for 5 day course
Accepted Payment Methods: Check, Visa, MasterCard, American Express

See the original post here:
Dexterity I class scheduled for May 16th – 20th, 2011 will be running as scheduled

April 29, 2011 · Leslie Vail · No Comments
Tags: , , , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 280

T-SQL "UNION" Vs "TABLE variable"

Very recently I learned this. And what a change it has made to all of my SQL based projects! I am sure people who are hardcore SQL programmers would already know this. Thought of sharing this for those who would want to know something interesting.

I had a SQL Stored Procedure that is about to retrieve records of a same table from two different databases. The usual approach was something like below:

SELECT column_name_1, column_name_2, column_name_3, …
FROM db_name_1..table_name

UNION

SELECT column_name_1, column_name_2, column_name_3, …
FROM db_name_2..table_name

This was working till these tables contained records less than 30000 rows. And it started taking significantly unacceptable time (like 10-15 seconds). I then thought of creating a temporary table and dump records from one DB then from other. There is a potential issue in that, in the form MULTI-USER environment. When two different users invoke this stored procedure at the same time, this temporary table must cater for both. I was not really sure about how I can address this.

Then came this idea of using TABLE VARIABLE. It’s like a Structure in C++. This is how I modified my stored procedure:

DECLARE @TABLE_NAME TABLE
(
Column_1 DATATYPE,
Column_2 DATATYPE,

)

INSERT INTO @TABLE_NAME (Column_1, Column_2, …)
SELECT column_name_1, column_name_2, …
FROM db_name_1..table_name

INSERT INTO @TABLE_NAME (Column_1, Column_2, …)
SELECT column_name_1, column_name_2, …
FROM db_name_2..table_name

SELECT Column_1, Column_2, …
FROM @TABLE_NAME

After this, the program started taking around 2-5 seconds with more than 50000 records to handle. Not to forget, this program contained several grouping and calculations.

I don’t have to worry about delay and also TEMP TABLE issues that are potentially disastrous. I am still not sure how this is handled in terms of memory allocation. What happens after this program completes it’s process, is also a factor that I am yet to figure out.

But, so far, I have found this as one of the best methods in recent times.

VAIDY

Here is the original post:
T-SQL "UNION" Vs "TABLE variable"

April 29, 2011 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 576

Integration Manager Customer Address Update does not generate an error and does not update

I worked on a Integration Manager 2010 case recently for a Customer update integration. We ran across an issue when the customer you are updating has the Send Email Statement box marked in the Customer Maintenance Option window. I also had the previous Customer’s address getting updated with the information from the Customer that had the Send Email Statements marked.

See the original post:
Integration Manager Customer Address Update does not generate an error and does not update

April 29, 2011 · David Musgrave · No Comments
Tags: , , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 402