Archive for April, 2009
Security Restrictions for Command Forms
Guys One recent support request which came from a few friends of mine, is, when they try to login to GP, they get an error message “You do not have security access” and log them out of GP. I checked with them to see if they have any customizations and they had a customized product [...]
April 28, 2009 · 
veeyeskay · 
One Comment
Posted in: Dynamics, Great Plains, System Total Views: 475
SQL Code for GL Trial Balance – GP 10
Guys Today, I just decided to post a simple code snippet to generate a detailed GL Trial Balance with reference to the various sub ledgers, including the multi-dimensional information. IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N’[dbo].[vw_GLTrialBalancev10]‘) AND OBJECTPROPERTY(id, N’IsView’) = 1 ) DROP VIEW [dbo& Read the rest of this entry
April 26, 2009 · veeyeskay · 7 Comments
Tags: General Ledger, GL Trial Balance · Posted in: Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 1,894
String Parser SQL Function
Guys The post I am making now, can be one from a very old school of thought, but is a recurring problem, which the developers face, day in and day out, as they write SQL scripts. It is about parsing a value, which contains a single quote, before passing it into the SQL queries. Many [...]
April 20, 2009 · veeyeskay · No Comments
Posted in: SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 337