Tag: accounting

Customizing Integration Manager Logs – Part 1

| 08/26/2014 | 0 Comments

Just recently, I took on a question on the Microsoft Dynamics GP Partner Online Technical Forum  where the original poster asked if it was possible to customize the logs produced by Integration Manager (“IM”).

Continue Reading

Mariano Gomez does the ALS #IceBucketChallenge

| 08/21/2014 | 0 Comments

Thanks to my good friend David Musgrave over at Developing for Dynamics GP for nominating me to the ALS #IceBucketChallenge . David was originally nominated by MVP Jivtesh Singh . See his blog post  and video here: David completed his challenge (and donation yesterday) and posted this article on his blog as proof of his accomplishment.

Continue Reading

Deploying Business Analyzer Companion App Services on Windows Azure Service Bus

| 08/06/2014 | 0 Comments

Business Analyzer App for Windows 8.1 If you are not using Business Analyzer today, shame on you.

Continue Reading

A Business Manager’s Perspective on The Ease of SmartView

A Business Manager’s Perspective on The Ease of SmartView

Upon being employed as the Business Manager at eOne, I realized my most valuable tool was SmartView. Not only for fast reporting, but because it was extremely easy to learn.  I had never used GP, only other accounting software like Quickbooks.

Continue Reading

Is it a Shipment or is it a Receipt?

After years of explaining to GP users that ‘Shipment’ actually means ‘Receipt’ in Purchase Order Processing, I’ve grown tired of having to do so.  Call me lazy but IMHO, the terminology should be consistent throughout the POP windows.  See example below: So is it a Shipment or a Receipt?  My vote goes for ‘Receipt’.  If you’d like to register your vote, please do so here on Microsoft Connect – Vote for Receipt . Thanks!

Continue Reading

Dude, where’s my ‘Go To’ button?

Okay, so I’m playing around with GP 2013 R2, getting familiar with some of the cool new features in it.  I like to be on the leading edge of things.  I leave the bleeding-edge stuff to Polino. I created a new SmartList in SmartList Builder and wanted to add a ‘Go To’ to my new SmartList but could not find the Go To button anywhere.  I looked high and low to see if it had been hidden under one of the other button menus.  I checked the SmartList Builder Help file and it said the button should be there in the ribbon with all the other buttons.  But yet, no Go To button. So, after querying my smarter-than-me colleagues at IBIS, Inc, Ms.

Continue Reading

Update Company ID field across all company database

| 06/05/2014 | 0 Comments
Update Company ID field across all company database

A couple of weeks back I needed to consolidate two DYNAMICS databases and move companies from the first DYNAMICS to the second, this for sure requires Company IDs to be changed as it might be taken by another companies on the main DYNAMICS, to fix this once for all I have wrote the following script: DECLARE @Statement VARCHAR (8000) DECLARE @TABLENAME VARCHAR (500) DECLARE CURR Cursor FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘ CMPANYID ‘ AND COLUMN_DEFAULT IS NOT NULL OPEN CURR FETCH NEXT FROM CURR INTO @TABLENAME WHILE @@FETCH_STATUS = 0 BEGIN SET @Statement = ‘ SELECT * INTO ‘ + @TABLENAME + ‘ _BAK FROM ‘ + @TABLENAME EXEC (@Statement) SET @Statement = ‘ UPDATE ‘ + @TABLENAME + ‘ SET CMPANYID = NEW COMPANY ID WHERE CMPANYID = OLD COMPANY ID ‘ EXEC (@Statement) FETCH NEXT FROM CURR INTO @TABLENAME END CLOSE CURR DEALLOCATE CURR   Hope that this helps. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading