Digging deep into Multicurrency Revaluation
In this post, I am going to explain the MultiCurrency Revaluation feature in GP.
May 15, 2011 · 
Rubal · 
No Comments
Tags: accounts, archives, cards, dynamics, financial, Multicurrency, posting, realized, Revaluation, transaction · Posted in: Blogs I Follow Total Views: 118
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
Multicurrency Revaluation Series – Part III – Summary Balance Checks and Reconciliation
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 articles titled Multicurrency Revaluation Series – Part I – Revaluation Setup and Multicurrency Revaluation Series – Part II – Revaluation Process Logic, I had given some insight [...]
May 15, 2010 · veeyeskay · No Comments
Tags: Multicurrency, Reconciliation, Revaluation, Summary Tables, Transaction Details · Posted in: Dynamics, General Ledger, Great Plains Total Views: 925
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
Issue with Journal Entry Back-outs in Analytical Accounting
Hi all Sorry for not posting for quite some time… Has been a hectic month and a half for me… But I have now come back and I have decided to post an interesting issue that we have faced in Analytical Accounting. The scenario given below is based on the data in Fabricam, in Microsoft [...]
April 26, 2010 · veeyeskay · 2 Comments
Tags: Analytical Accounting, General Ledger, Journal Entry, Revaluation · Posted in: Analytical Accounting, Dynamics, Great Plains Total Views: 1,670
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
Revaluation Setup and Currency Access of GL Accounts
Hi All In this article, I am going to walk through a couple of key things to keep in mind when you are setting up new accounts in a multi currency environment, defining the revaluation setup and defining access to various currencies to the accounts. Integration Manager only allows you to upload the Account Master [...]
March 1, 2010 · veeyeskay · No Comments
Tags: Account Currencies, Currency Access, Currency Account Update, MC00200, Revaluation · Posted in: Dynamics, General Ledger, Great Plains Total Views: 619