Tag: sql

Quick Tip: Passing Date and Time Variables to SQL Server

| 12/16/2011 | 0 Comments

As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server , I wanted to discuss the related topic about passing of date and time variables.

Continue Reading

Quick Tip: Passing Variables to SQL Server

| 12/15/2011 | 0 Comments

Wow, the week is almost over and I am yet to post something.

Continue Reading

Decisions Fall 2011 – GP Day is today

| 12/06/2011 | 0 Comments

Come talk to us about new features in GP Reports Viewer at MSDynamicsWorld’s  Decisions Fall 2011 today. I will be there all day along with our senior developer and SRS expert Mickie Stamm

Continue Reading

SQL Prompt–Intellisense for SQL Server and more

| 12/04/2011 | 0 Comments

Some of you might have started using intellisense with SQL Server 2008. Intellisense is a great feature, and its something I can’t live without when I am coding.

Continue Reading

Analytical Accounting Class Maintenance Error: This record has been created since your attempt to create it. Changes won’t be saved.

WARNING : This post explains a method which is carried out in SQL and also affects an active table record. Consultants / Developers / End Users, who are not aware of GP & SQL processes, MUST NOT carry out this without an experienced consultant’s / developer’s supervision or assistance.

Continue Reading

Perils of Using of DEX_ROW_ID on Customization / Integration – David

Perils of Using of DEX_ROW_ID on Customization / Integration – David

This one is certainly a nasty issue, if we are going to use DEX_ROW_ID value on customization or integration . I have personally fallen into a trap by using DEX_ROW_ID on my customization. But now, it’s all wisdom out of that bad experience

Continue Reading

Quick Tip: Making sure Activity Tracking is enabled for all users

| 11/07/2011 | 0 Comments

This Quick Tip comes to you courtesy of an idea from my friend, Robert Cavill. On a Microsoft Dynamics GP system where Activity Tracking is being used, it needs to be activated for each User ID/Company ID that you want it enabled for. In most cases, you would want the Activity Tracking enabled for all valid User ID and Company ID combinations.

Continue Reading