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.
Business Analyzer App for Windows 8.1 If you are not using Business Analyzer today, shame on you.
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.
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!
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.
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 email@example.com http://www.di.jo