Tag: accounting

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

Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports

| 06/03/2014 | 0 Comments

Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports – Part 1 I was in Johannesburg, South Africa this past week visiting a customer with the distinct challenge of working with an extensive number of company databases – one for each company division. While I was there to provide Microsoft Dexterity training , undoubtedly other topics of conversations tend to surface at various points. In this occasion, I was the one doing some learning as the customer pointed me to a method they devised to deploy SQL Reporting Services Reports (SSRS) to multiple companies by using the standard Microsoft Dynamics GP Reporting Tools Setup window

Continue Reading

First look to Dynamics GP 2013 R2

| 05/29/2014 | 0 Comments

I just upgraded to GP2013 R2! I liked the way the changed the “Login” form, this to apply the identity management process! Next thing I liked is the new look and feel: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Rearrange your Area Pages

GP 2013 introduced additional ways to customize how your area pages are arranged.  I wasn’t real fond of the arrangement in my test system, so I arranged them as in the following screenshot: With this arrangement, I can easily see all the menu categories.  To make a specific category appear in the expanded mode, click on the little square icon in the upper right corner of each window.  Additionally, I went through each module and arranged the menu categories so they all fall in the same sequence. The key to creating this type of arrangement is selecting the desired ‘ Column Stack ‘ selection in the Customize Home Page window ( Home Page> > Customize this page

Continue Reading

Disable “Remember Company” checkbox

| 05/21/2014 | 0 Comments

I got a request from one of my customers to disable the flag of “Remember Company” that exists on the company login form below: I have made this using VBA, please download the code using the link below: http://di.jo/Files/RememberCompany.zip Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading