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...
Read full story (Read 39 views times) Add a comment - 0 users commented on this post
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...
Read full story (Read 21 views times) Add a comment - 0 users commented on this postMacro 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...
Read full story (Read 49 views times) Add a comment - 1 users commented on this postSQL 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...
Read full story (Read 70 views times) Add a comment - 0 users commented on this postUpdating 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...
Read full story (Read 23 views times) Add a comment - 0 users commented on this post
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...
Read full story (Read 31 views times) Add a comment - 0 users commented on this post
Disabling RMA options in Create Return window
Hi all Recently, I saw a post in the newsgroup where a user had a problem with the Create Return window, which opens from Sales Transaction Entry >> Additional >> Create Return. If the Field Service module was a registered module in...
Read full story (Read 23 views times) Add a comment - 0 users commented on this post
Analysis Cubes for Microsoft Dynamics GP (on SQL Server 2008)
Folks In this article, I am planning to give some quick insight into common configuration problems that you might face when installing and configuring Analysis Cubes for Microsoft Dynamics GP on SQL Server 2008. Before we begin, make sure you have SQL...
Read full story (Read 89 views times) Add a comment - 0 users commented on this post
Quick Print Functionality for Sales Transactions
Folks… In this article, I am going to provide some information about a quick printing functionality for Sales Transactions, which will provide an ease in data entry. Once we pick up a Sales Invoice in the Sales Transaction Entry window, go to...
Read full story (Read 56 views times) Add a comment - 1 users commented on this post
Sneak Peek Into Dynamics GP 2010 (v11) – Part III
Folks… In this article, I will give some insight into some of the key enhancements in the Payables and Receivables Series module. Enhancements to Select Checks Process The select checks process has been enhanced so that the user can build check run batches...
Read full story (Read 92 views times) Add a comment - 0 users commented on this post
Sneak Peek Into Dynamics GP 2010 (v11) – Part II
Folks… This is the 2nd part of my series of articles being posted to give a preview of Dynamics GP 2010 (v11). I am going to provide further insight into the enhancements to the foundation series in GP v11. Enhancements to Lookups The...
Read full story (Read 66 views times) Add a comment - 1 users commented on this post
Sneak Peek Into Dynamics GP 2010 (v11) – Part I
Hi All Microsoft recently launched the BETA version of Microsoft Dynamics GP 2010, which is called GP v11. I have decided to post some information on the new additions and improvements on the product in the next couple of articles for...
Read full story (Read 64 views times) Add a comment - 0 users commented on this post
“Alias” in Analytical Accounting
Hi all Wish you all a wonderful new year and may the new year brings in joy, prosperity, happiness and satisfaction to all of you. Today, lets have a sneak peek into a little functionality in Analytical Accounting, which I believe...
Read full story (Read 41 views times) Add a comment - 0 users commented on this postHandling Primary Key Errors in Analytical Accounting
Hi all… It has been some time, since I have posted something here… Was busy at many other assignments. However, here comes an article which will be of interest and use to many, especially those who are using Analytical Accounting module...
Read full story (Read 90 views times) Add a comment - 3 users commented on this postSQL View for Sales Margin Analysis
Guys The next post that I have decided to make is on a SQL view for generating a sales margin analysis report in Dynamics GP. 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269CREATE VIEW dbo.vw_SOPSalesAnalysis AS SELECT CASE dbo.SOP10200.SOPTYPE WHEN 1 THEN 'Quote' ...
Read full story (Read 80 views times) Add a comment - 2 users commented on this postSQL View for Inventory Aging
Guys I have come across many requests from various friends and clients of mine, who have a need to print a stock aging report in GP. There is no out-of-the-box report for stock aging report in GP. So I decided to write...
Read full story (Read 95 views times) Add a comment - 1 users commented on this postSecurity Restrictions for Command Forms
Guys One recent support request which came from a few friends of mine, is, when they try to login to GP, they get an error message “You do not have security access” and log them out of GP. I checked with them...
Read full story (Read 55 views times) Add a comment - 1 users commented on this postSQL Code for GL Trial Balance
Guys Today, I just decided to post a simple code snippet to generate a detailed GL Trial Balance with reference to the various sub ledgers, including the multi-dimensional information. 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186IF EXISTS ( SELECT * FROM dbo.sysobjects ...
Read full story (Read 80 views times) Add a comment - 2 users commented on this post
Deletion of Transaction Dimensions in Analytical Accounting (Even If History Is Present)
Guys Recently, I came up with a requirement where I needed to delete a transaction dimension in Analytical Accounting. But when trying to delete it, I realized that it was used in posted and unposted transactions and that it could not...
Read full story (Read 41 views times) Add a comment - 0 users commented on this postMicrosoft’s Ballmer outlines his seven big bets for 2009
Extract from a ZDNet Article For the past few Februaries, Microsoft CEO Steve Ballmer makes the trek to Wall Street to provide analysts with an annual “Strategic Update” overview, in which he covers the areas where Microsoft plans to invest and...
Read full story (Read 29 views times) Add a comment - 0 users commented on this post
