I developed my own cheat sheet / checklist for setting up the Multicurrency module. I wanted something that I could fit on a single page just to remind me of what I needed to do next. Recently, I’ve had a few colleagues ask me whether I had some kind of easy to follow checklist and I’ve been sending them this one.
You can find this document, as well as a sample report using each one of these functions in the GP Software Development Kit (SDK) You can find the SDK in the Tools folder of the DVD installation media. The functions are separated into four different categories: Numeric Functions String & Text Functions Date & Time Functions Data Functions Multicurrency Functions Below is a listing of each function and how to use it: Numeric RW Functions RW_Abs Module: System Manager Series: System Script type: Global function Form (If a form global): Category: Numeric Manipulation Description: Returns the absolute value for the currency or vcurrency value supplied
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.
Join us for the CRMUG Regional Conferences to connect, learn, and share with over 100 Dynamics CRM professionals representing some of the largest chapters in the region. The conference is designed for end users, administrators/IT, and developers/technical…an opportunity to broaden your knowledge of Dynamics CRM. While we’re there, we’ll be sharing SmartConnect – our CRM
Today is the day many of you (like us) have been looking forward to! We are excited to announce multiple product releases today, many which are needed to be compatible with the Microsoft Dynamics GP 2013 R2 release that was posted by Microsoft on May 28th. We have posted new installs of the following products: Extender 2013 (12.00.0103) – This release includes the compatibility for Microsoft
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 email@example.com http://www.di.jo
After updating the currency index field across all database, one of the users has reported that currency symbol does not match the functional currency symbol defined in the currency setup, and for some screens multiple currencies are shown as below: After looking for this I have found this in MC40000 table, the Currency ID field represents the correct functional currency but the index was referring to another currency, updating the currency index field fixed the issue. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo