Archive for March, 2010
Chage Item Option from "None" to "Lot" or "Serial"
To change Item tracking option from None to Lot Number Item Qty on hand must be zero.
March 28, 2010 · 
Sandip Jadhav · 
No Comments
Tags: change track option, dynamics, hand-must, Inventory, lot-item, maintenance, number, number-item, tracking-option, transaction · Posted in: Blogs I Follow Total Views: 98
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
Project Natal for Xbox 360 Coming Soon – Developing for Dynamics …
A blog dedicated to everything to enable Developing for Microsoft Dynamics GP by David Musgrave and the Microsoft Dynamics GP Developer Support Team.
March 17, 2010 · David Musgrave · No Comments
Tags: Dex.ini, Dexterity, dynamics, extender, integration, security, Smartlist Builder, support debugging tool, upgrade · Posted in: Blogs I Follow Total Views: 22
Customer Statements with Multicurrency Information
Folks In this article, I decided to give you some info on printing customer statements from Dynamics GP with multi-currency information. Sometimes, there are requirements to print the customer statements in the originating currency instead of the functional currency. In order to achieve this, there are a couple of forms available in Dynamics GP to [...]
March 13, 2010 · veeyeskay · 2 Comments
Tags: Customer Aging, Customer Statements, Multicurrency · Posted in: Accounts Receivables, Dynamics, Great Plains Total Views: 642
Restrictions on multiple values in Smartlist Builder
Folks Recently there was a request which came up in the news groups on the restrictions in smartlist. The requirement was to add a filter to the smartlist builder object on a range of values, and the important fact was that it was not a continuous range. When I was believing there was no option [...]
March 13, 2010 · veeyeskay · 2 Comments
Tags: Restrictions, Smartlist, Smartlist Builder · Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 605
ReQlogic – Enhanced Requisition Management For Dynamics GP
Hi all I have been witnessing many questions in the news group where people check to see if the Requisition Management module of Business Portal support multi-currency. The second most requested feature is the feasibility of attaching files to requisitions. Unfortunately the out of the box Requisition Management module does not offer both of these [...]
March 5, 2010 · veeyeskay · No Comments
Tags: Business Portal, Multicurrency, ReQlogic, Requisition Management, Tectura, Workflow · Posted in: Dynamics, Great Plains, Purchase Order Processing Total Views: 1,276
Printing Tax Details in Sales Documents
Hi all Recently I was working on a customer request to print tax details on sales documents like Orders/Invoices. On doing some analysis I was able to get it done with some help from my friend David Musgrave. I have decided to post what I have found so that it will be helpful to you [...]
March 5, 2010 · veeyeskay · No Comments
Tags: Currencies, Line Item, Multicurrency, Sales Documents, Summary, Tax Details · Posted in: Dynamics, Great Plains, Sales Order Processing Total Views: 437
Macro to provide access to Transaction Dimension Codes to Users
Hi all In this article, I am going to publish a SQL script which will be helpful to many using Analytical Accounting module. I have come across many clients who have multiple companies and they have hundreds of users spread across each of these companies. Assume the case when a new dimension code value has [...]
March 3, 2010 · veeyeskay · 6 Comments
Tags: Access, Analytical Accounting, Dimension Code, Dimension Code Access, Macro · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 1,804
SQL View for Payables Transactions with AA Codes
Guys There is a smartlist object for AP transactions, but this smartlist does not show the analytical accounting information in it. So in this post, I have decided to post a SQL view to generate a view to show AP transaction information along with the analytical accounting information. IF EXISTS ( SELECT * FROM [...]
March 1, 2010 · veeyeskay · 11 Comments
Tags: AA Codes, Analytical Accounting, Dimension Codes, Payables Transactions, SQL View · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 813
Updating Missing Note Indexes in Tables
Hi All Recently, I came across this article written by David Musgrave, in his blog article, which explains how to update the missing note indexes in GP’s tables. This is such a critical feature, especially where note indexes are missed to be updated when populating records into GP’s tables directly. This article from David Musgrave [...]
March 1, 2010 · veeyeskay · No Comments
Tags: David Musgrave, Missing, Note Index · Posted in: Dynamics, Great Plains, System Total Views: 372