Tag: development

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

GP 2013 R2 updates to Report Writer Functions

| 06/10/2014 | 0 Comments
GP 2013 R2 updates to Report Writer Functions

David Musgrave posted an article about updates and additions he has made to the User-Defined functions he added to Report Writer back in release 7.0. I have added a list and description of those functions to my section about User-Defined Report Writer functions. There are some incredibly handy functions now available.

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 Currency Index field across all database

| 06/05/2014 | 0 Comments
Update Currency Index field across all database

You might need to change the currency index for one of your currencies, I needed this during a consolidation project for multiple DYNAMICS databases and needed to change the currency index field for all company tables, take a look into the below script, I have used the “Information_Schema” to get all columns that are called “ CURRNIDX” and updated these using SQL Cursor, considering that I taking a backup for each table before doing the operation: DECLARE @Statement VARCHAR (8000) DECLARE @TABLENAME VARCHAR (500) DECLARE CURR Cursor FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘ CURRNIDX ‘ 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 CURRNIDX = NEW CURRENCY ID WHERE CURRNIDX = OLD CURRENCY ID ‘ EXEC (@Statement) FETCH NEXT FROM CURR INTO @TABLENAME END CLOSE CURR DEALLOCATE CURR Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

| 05/30/2014 | 0 Comments
Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

This morning i been working on the R2 release and been enjoying the newly added features and been playing around the newly added paste feature Factor GP Paste DI Paste Winner Speed (when pasting 1500 rows) 100 seconds 60 seconds DI Data Validation Data validated No data validation Microsoft Coverage* GL Only All forms DI Intercompany** Not Available Available DI Columns Order Modifications** Not available Available DI Update Existing Journal Not available Available DI Paste Multiple Journals** Not available Available DI * All GP forms is covered in purchased version only. **This feature is only currently available with purchased version, we expect this to be free soon

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

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