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