Home » Archives
Security Restrictions for Command Forms
Written on 28 Apr, 2009 at 11:46 in Dynamics, Great Plains, System | viewed 1 views times | 0 Comments
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... (Continue reading)
SQL Code for GL Trial Balance
Written on 26 Apr, 2009 at 10:15 in Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 6 Comments
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_GLTrialBalance]')... (Continue reading)
String Parser SQL Function
Written on 20 Apr, 2009 at 18:44 in SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 0 Comments
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... (Continue reading)