Posts

Showing posts from March, 2008

Finding columns in tables

Image
In the past days, I have found a lot of people asking themselves, 'how do I know in which tables I can find xyz column name, and how do I know I have all the tables?' The answer to this question is often used to make database wide updates and perform a number of maintenance functions for master records and transactions that were not recorded as originally intended. The following example query attempts to solve the issue by exposing all tables were the account index (ACTINDX) column is found within the Fabrikam database (TWO). -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Unported License. -- http://creativecommons.org/licenses/by-nc-sa/3.0/legalcode -- DECLARE @ColumnName VARCHAR(30); SET @ColumnName = 'ACTINDX'; SELECT DISTINCT RTRIM(OBJS.NAME) FROM SYS.COLUMNS COLS INNER JOIN SYS.OBJECTS OBJS ON (COLS.OBJECT_ID = OBJS.OBJECT_ID) INNER JOIN SYSINDEXES INDX ON (COLS.OBJECT_ID

Dynamics GP aims at QuickBooks users

Image
I couldn't have let the day gone by without updating you with what's going on in the Microsoft Dynamics GP world. According to the Washington Post, " Microsoft is trying to make it easy for businesses to switch from Intuit's accounting products to its applications ". Read the full article at: http://www.washingtonpost.com/wp-dyn/content/article/2008/03/23/AR2008032301121.html Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Removing Child Records from a National Account

Image
This is an actual problem I faced at an actual customer of mine a few months aback and posted today on the Google's Dynamics GP board . It seems that more often than one could assert, a customer's payment records get assigned to the wrong national account (or parent account). This can cause problems down the road when incorrect statements or aging reports are submitted to the corporate customer. In light of this issue, I developed a two fold solution: 1) The following query identifies the credit documents posted and applied by the parent customer on behalf of the child account. -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Unported License. -- http://creativecommons.org/licenses/by-nc-sa/3.0/legalcode -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Unported License. -- http://creativecommons.org/licenses/by

Payables Transactions not in GL

Image
Picture this: the auditors are in, they asking for myriads of reports, and precisely one of the things they ask is something you cannot easily achieved from the slur of reports and SmartLists available from within Microsoft Dynamics GP. To make matters worst, the "go to" guy for queries and special requests is out of the office sick with the flu. Well worry no more! If you are asked to show all the payables transactions that were never recorded or posted to GL you can run the following query from SQL Server Management Studio (or Query Analyzer if you still happen to be on SQL Server 2000): -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Unported License. -- http://creativecommons.org/licenses/by-nc-sa/3.0/legalcode -- SELECT A.VENDORID, A.DOCNUMBR, A.DOCDATE, A.CNTRLNUM, GL.JRNENTRY, GL.TRXDATE, GL.ACTINDX, C.ACTNUMST, D.ACTDESCR, GL.REFRENCE, GL.ORTRXTYP, GL.ORCTRNUM, GL.ORMSTRID, G

Dynamics GP 10.0 Service Pack 2 Compatible with SQL Server 2008 and Windows 2008

Image
The news everyone was expecting! The Microsoft Dynamics GP 10.0 Development team has "certified" the product will work on both Microsoft Windows Server 2008 and Microsoft SQL Server 2008 release candidates. The team will continue to test the product on the RTM version. According to the team "it is expected that full functional compatibility will be achieved with Microsoft Dynamics GP 10.0 Service Pack 2, which will be made available with the Microsoft Dynamics GP 10.0 Feature Pack 1 release, targeted to RTM in Q2 of CY2008". That's it for now, I will keep you posted on any new events. Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Economic Times and Microsoft ERP Applications

Image
I want to open this blog by commenting on the current economic times and the middle market segment of ERP applications. It's certainly interesting to see how key vendors such as Microsoft, Epicor, Sage, Lawson, among others, are revamping their marketing and sales strategies to gain new customers. The suite of products, VARs, and ISV offerings in this space are especially well positioned to become the " go to " solutions for budget concious organizations looking for well priced and robust products, and never before, has Microsoft been in a better position to advance sales within its Business Solutions division. With a wide array of business applications, global network of partners and ISVs, and short time to market, Microsoft is certainly a force to reckon with. Technology platform can no longer be considered a point of contention for those looking to introduce the " scalability and reliability " argument. With the introduction of the "triple-play" l