New April Hotfix and more changes for VAT
Check out the latest updates to Microsoft Dynamics GP 2016 and 2018.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I posted a script a while ago which used a cursor to return the functional currencies for all companies connected to a system database. However, I have recently revisited this script and created a version which does not use a cursor.
This script has been written to only return the companies which do not have a functional currency set; if you want to see all companies, regardless of the functional currency, remove the highlighted section.
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
CREATE TABLE #FunctionalCurrencies(
DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = STUFF((
''' + INTERID + '''
' + INTERID + '.dbo.MC40000
LEN(FUNLCURR) = 0'
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
INSERT INTO #FunctionalCurrencies
EXEC sys.sp_executesql @SQL
SELECT * FROM #FunctionalCurrencies
DROP TABLE #FunctionalCurrencies
Read original post SQL Script To Return Functional Currencies For All Companies Without a Cursor at azurecurve|Ramblings of a Dynamics GP Consultant
Business Applications communities