Dynamics Blogger

We get to see an Exchange Rate Entry window every time we try to post a transaction entry in Multicurrency, be it a General Entry or a Transaction in Sales or Purchasing series. This happens whenever a valid exchange rate could not be found in the Multicurrency Exchange Rate Maintenance for the selected currency Rate Type. In some cases, the Exchange rate for certain currencies doesn’t change frequently. In these cases, we can choose to avoid this Exchange Rate Entry window by inserting an exchange rate that stays unexpired as shown below. Adding to this we need to set the Exchange Table ID to search for Unlimited Unexpired Rates as well as assigning a Transaction rate Default to either “ previous Date ” or “ Next Date ”. Now, when we enter a transaction in Multicurrency, the system automatically assigns the recently available rate to the transaction by default until and unless we insert another new rate that would then become the new default. Remember that this setup ...

Can it be just possible? The standard GP functionality reconciles the bank statement against the Checkbook Register. So, How can it be possible to reconcile a bank statement directly with General ledger open transactions? Same question came to my mind when i was writing the scope for a large Client whose business process demanded a Reconciliation module that actually reconciles the bank statement against the GL transactions in Dynamics GP. The client said they also need the reconciliation to provide complete reconciliation history. Then came the Advanced Bank Reconciliation module from Nolan Computers as a big rescue.I’ll cover the functionality of this module in brief in this post just for those clients who are looking for an advanced version of bank reconciliation. Features : 1. Transactions are read directly from the General ledger 2. Can track multiple General Ledger accounts for the same Bank 3. Enhanced Multicurrency support, transaction currency needs to be sam...

Whenever we set up an Account in Financial => Cards => Account, We’d go to Account Currencies window and assign the Multi currencies in case the account will have transactions originating in currencies other than Functional Currency. Besides assigning the Multi currencies here, it also involves to check whether we need those currencies to be revalued or not. If Yes, we need to mark the Revalue Account option and then choose to Post Results to Account or Financial Offset Account. Here, Results mean the the Realized gain / Loss or the Unrealized Gain / loss as the case may be, resulting out of Revaluation of Multi currencies in the Financial Routines ( Financial => Routines => Revaluation ) The basic difference between choosing Post results to an offset A/c and post results to Account is If you choose the Offset a/c, the revaluation results would be posted to a separate account that is defined as Financial Offset A/c in Posting Accounts setup ( Administration => Setup...

In most businesses,we come across the situation where a vendor is become a customer to us and vice versa. In these types of cases, the business needs demands us to consolidate the customer and vendor activity so that the statements reflect true and fair view of the transaction activity. Dynamics GP provides standard functionality to take care of Customer/Vendor Consolidation. Features of Customer/Vendor Consolidations include : 1. Auto Create Vendors and Customers 2. Consolidate balances in Payables or Receivables for a single company 3. Assign Relationships between existing customers and vendors 4. Easily Track the Consolidations using Cross-Module Link 5. Vendor Balances and Customer Balances can be consolidated including National Account Customers 6. All Open Payables/Receivables debit &credit documents can be applied against each other to consolidate the current balances  Setting up Customer/Vendor Consolidations is quite easy to start with. ...

In the General Entry, We have the option to back out a Journal Entry or Back out and post correcting Entry option. Clicking on the Correct option will open the Correct Journal Entry option In this window, when we open the Original Journal Entry lookup, it will take longer time than expected. To avoid this delay in bringing up the results, adding the following index script to the company database will help. The journal entry records will then be displayed much faster. This script was provided by Microsoft support sometime before. (I dont really remember when though). CREATE NONCLUSTERED INDEX [SEE_GL30000PerformanceCustom] ON [dbo]. [GL30000] ( [Back_Out_JE] ASC, [HSTYEAR] ASC ) ON [PRIMARY] go CREATE NONCLUSTERED INDEX [SEE_GL20000PerformanceCustom] ON [dbo]. [GL20000] ( [Back_Out_JE] ASC, [OPENYEAR] ASC ) ON [PRIMARY] go To add the above script, Open SQL Server Management Studio, Click to open the Query Analyzer, Select the Company Database against which you'd want to ...