Interesting Findings & Knowledge Sharing
Scribblings of a Microsoft Dynamics GP MVP
Handling Primary Key Errors in Analytical Accounting
Hi all…
It has been some time, since I have posted something here… Was busy at many other assignments. However, here comes an article which will be of interest and use to many, especially those who are using Analytical Accounting… Continue reading
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… Continue reading
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… Continue reading
Clearing Invalid Company References from DYNAMICS database
When we come across a situation where, we need to remove out a test company from a GP installation, the most common way by which this is handled is by removing the access to all users from the company.
But… Continue reading
SQL Stored Procedures to get the GP Constant value from SQL Server
Many a times, we do many customizations in GP, using SQL stored procedures and triggers. During these customizations, we might need to use few (or) many of the constants defined in GP for the purpose of various manipulations.
Instead of… Continue reading