Table Structure Definitions – Multicurrency Account Master
Hi all Today, I am starting a series of articles where I am planning to explain the table structure of some of the tables in Dynamics GP. To begin with, I am going to explain the Multicurrency Summary Master (as revaluations is one of the concepts which I like most in a multicurrency environment). The [...]
May 3, 2011 · 
veeyeskay · 
No Comments
Tags: Account Currencies, Net Change, Period Balances, Post Results To, Revaluation, Revaluation Options · Posted in: Dynamics, General Ledger, Great Plains, Multicurrency Total Views: 365
SQL Query for GL Summary Balances
Hi all The first post for today is an SQL script for viewing the summary balances for all GL accounts and for all fiscal years and periods, with both the net change amount and the period balance (cumulative) amounts. SELECT Z.* FROM ( SELECT RTRIM(B.[ACTNUMST]) AS GPACCOUNTNO, RTRIM(C.[ACTDESCR]) AS DESCRIPTION, A.[YEAR1] AS Read the rest [...]
November 9, 2010 · veeyeskay · One Comment
Tags: Net Change, Period Balances, Summary Balances, Summary Tables · Posted in: General Ledger, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 759
Multicurrency Revaluation Series – Part II – Revaluation Process Logic
Hi all This is the second part of the series of articles I am planning to write up on multi-currency revaluation process in Dynamics GP. In the earlier article titled Multicurrency Revaluation Series – Part I – Revaluation Setup, I had given some insight into the basic revaluation setup. In this article, I am going [...]
May 15, 2010 · veeyeskay · One Comment
Tags: Average Exchange Rate, Multicurrency, Period Balances, Realized Gain, Realized Loss, Revaluation, Total Functional Balances, Total Originating Balances · Posted in: Dynamics, General Ledger, Great Plains Total Views: 1,252
Multicurrency Revaluation Series – Part I – Revaluation Setup
Hi all This is the first part of the series of articles I am planning to write up on multi-currency revaluation logic in Dynamics GP, so that it can help many users who use this functionality in GP. To begin with all accounts that have to be revalued, will have to have the correct revaluation [...]
May 15, 2010 · veeyeskay · 2 Comments
Tags: Financial Offset, Multicurrency, Net Change, Period Balances, Realized Gain, Realized Loss, Revaluation · Posted in: Dynamics, General Ledger, Great Plains Total Views: 1
SQL Script for Revaluation Process
Hi all During this week, I just thought of writing a simple SQL script to calculate the gain (or) loss for a particular currency/account combination based on a specific date that has been provided. The script has been written for the following assumptions. All accounts revalue at Period Balances Revaluation is done using an Exchange [...]
March 18, 2010 · veeyeskay · One Comment
Tags: Exchange Rate, Exchange Table, Multicurrency, Period Balances, Realized Gain, Realized Loss, Revaluation · Posted in: Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 706
SQL Script for GL Period Balances
Hi all Today, I have decided to post a SQL script for reporting on the period balance tables for General Ledger in Dynamics GP. SELECT RTRIM(B.ACTNUMST) AS GPACCOUNTNO , C.ACTDESCR AS DESCRIPTION , A.YEAR1 , CASE WHEN A.PERIODID = 0 THEN ‘Beginning Balance’ ELSE {FN MONTHNAME(D.PERIODDT)} END AS PERIOD , ISNULL(A.PERDBLNC, 0) A Read the [...]
January 20, 2010 · veeyeskay · No Comments
Tags: Period Balances · Posted in: Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 130