web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / XML file import to SQL...
Microsoft Dynamics GP (Archived)

XML file import to SQL server

(0) ShareShare
ReportReport
Posted on by Community Member

I"m trying to take a XML file and display in sql. before doing the insert statement i'm running a select statement to make sure i have the data i need and that is where i'm running into issues. image below shows my code and a the test xml data. as you can see in the xml that  (PersonName,Tel [1,2,3],email,address and document) are all in the same sublevel under customer and then traveler. in my code i can only do one sub-item weather it would be name, tel, email etc. i need to see all. how can i achieve this. i really hope i explained my issue well!

code.png

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Can you use the code block to paste both the code and the xml? Use a separate code block for each

  • Community Member Profile Picture
    Community Member on at 
    My code: 

    USE OPENXMLTesting
GO
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
SELECT @XML = XMLData FROM XMLwithOpenXML
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML
SELECT DOB, Gendr,Title,FName,MName,LName
FROM OPENXML(@hDoc, 'Traveler/Customer/PersonName')
WITH 
(
DOB [datetime] '../@BirthDate',
Gendr [nvarchar](3) '../@GenderCode',
Title [varchar](5) 'NamePrefix',
FName [varchar](5) 'GivenName',
MName [varchar](5) 'MiddleName',
LName [varchar](5) 'SurName'
)
EXEC sp_xml_removedocument @hDoc
GO

     XML File: 

    		<Traveler>
			<Customer BirthDate="1979-01-19" GenderCode="M">
				<PersonName>
					<NamePrefix>MR</NamePrefix>
					<GivenName>John</GivenName>
					<MiddleName>Junior</MiddleName>
					<SurName>Smith</SurName>
				</PersonName>
				<Telephone LocationTypeCode="BUS" DisplaySequenceNo="1" OrderSequenceNo="1">
					<ParsedPhoneNumber AreaCd="48" PhoneNumber="123422365"/>
				</Telephone>
				<Telephone LocationTypeCode="MOB" DisplaySequenceNo="2" OrderSequenceNo="2">
					<ParsedPhoneNumber AreaCd="48" PhoneNumber="666654554"/>
				</Telephone>
				<Telephone LocationTypeCode="HOM" DisplaySequenceNo="3" OrderSequenceNo="3">
					<ParsedPhoneNumber AreaCd="48" PhoneNumber="777788854"/>
				</Telephone>
				<Email EmailAddress="TEST@EMIAL.COM" DisplaySequenceNo="1" OrderSequenceNo="1"/>
				<Address LocationTypeCode="HOM">
					<AddressLine>Road</AddressLine>
					<CityName>City</CityName>
					<CountryCode>PNG</CountryCode>
				</Address>
				<Document DocID="AS12345" DocTypeCode="PSPT" EffectiveDate="2017-01-01" ExpireDate="2027-01-01">
				</Document>
				<CustLoyalty VendorTypeCode="AL" VendorCode="U0" MembershipID="100000003" OrderSequenceNo="1">
					<MembershipLevel MembershipLevelTypeCode="TI" MembershipLevelValue="01"/>
					<CustLoyaltyTotals AccountBalance="1000" MembershipStartDate="2017-01-01" MilesToExpire="500" MilesExpireDate="2017-09-01"/>
				</CustLoyalty>
			</Customer>
			<PrefCollections>
				<AirlinePref TripTypeCode="AZ">
					<AirlineSeatPref>
						<SeatInfo SeatPreferenceCode="NSSW"/>
					</AirlineSeatPref>
					<AirlineMealPref>
						<MealInfo MealTypeCode="CHKN"/>
					</AirlineMealPref>
				</AirlinePref>
				<LoungePref TripTypeCode="AZ" VendorTypeCode="AL" VendorCode="U0">
					<PreferredDrink DrinkName="Water"/>
				</LoungePref>
			</PrefCollections>
			<TPA_Extensions>
				<SSR SSRCode="WCHS"/>
			</TPA_Extensions>
		</Traveler>
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Adal,

    I created a file called "Travelers.xml" and put it in the C:\temp folder of my machine. The file contains the xml document you posted previously above -- reposting here for clarity sake:

    Filename: Travelers.xml

    <Traveler>
	<Customer BirthDate="1979-01-19" GenderCode="M">
		<PersonName>
			<NamePrefix>MR</NamePrefix>
			<GivenName>John</GivenName>
			<MiddleName>Junior</MiddleName>
			<SurName>Smith</SurName>
		</PersonName>
		<Telephone LocationTypeCode="BUS" DisplaySequenceNo="1" OrderSequenceNo="1">
			<ParsedPhoneNumber AreaCd="48" PhoneNumber="123422365"/>
		</Telephone>
		<Telephone LocationTypeCode="MOB" DisplaySequenceNo="2" OrderSequenceNo="2">
			<ParsedPhoneNumber AreaCd="48" PhoneNumber="666654554"/>
		</Telephone>
		<Telephone LocationTypeCode="HOM" DisplaySequenceNo="3" OrderSequenceNo="3">
			<ParsedPhoneNumber AreaCd="48" PhoneNumber="777788854"/>
		</Telephone>
		<Email EmailAddress="TEST@EMIAL.COM" DisplaySequenceNo="1" OrderSequenceNo="1"/>
		<Address LocationTypeCode="HOM">
			<AddressLine>Road</AddressLine>
			<CityName>City</CityName>
			<CountryCode>PNG</CountryCode>
		</Address>
		<Document DocID="AS12345" DocTypeCode="PSPT" EffectiveDate="2017-01-01" ExpireDate="2027-01-01">
		</Document>
		<CustLoyalty VendorTypeCode="AL" VendorCode="U0" MembershipID="100000003" OrderSequenceNo="1">
			<MembershipLevel MembershipLevelTypeCode="TI" MembershipLevelValue="01"/>
			<CustLoyaltyTotals AccountBalance="1000" MembershipStartDate="2017-01-01" MilesToExpire="500" MilesExpireDate="2017-09-01"/>
		</CustLoyalty>
	</Customer>
	<PrefCollections>
		<AirlinePref TripTypeCode="AZ">
			<AirlineSeatPref>
				<SeatInfo SeatPreferenceCode="NSSW"/>
			</AirlineSeatPref>
			<AirlineMealPref>
				<MealInfo MealTypeCode="CHKN"/>
			</AirlineMealPref>
		</AirlinePref>
		<LoungePref TripTypeCode="AZ" VendorTypeCode="AL" VendorCode="U0">
			<PreferredDrink DrinkName="Water"/>
		</LoungePref>
	</PrefCollections>
	<TPA_Extensions>
		<SSR SSRCode="WCHS"/>
	</TPA_Extensions>
</Traveler>

    The T-SQL part is not difficult to figure out, but does require a bit of understanding of the XML structure. The deepest layer in your document, is the AirlineSeatPref node. You can choose that as the anchor node for the openxml statement or you can decide to chose a section, i.e., Customer and use the Telephone node, for example, as the deepest node. Everything from there on is relative to the anchor node selected. So here's the query:

    if object_id('dbo.travelers_xml') is null 
	create table travelers_xml (Id int identity primary key, XmlDoc xml, loaded_date datetime default getdate());
go
truncate table travelers_xml;
go
insert into travelers_xml(XmlDoc)
select convert(xml, BulkColumn) as BulkColumn
from openrowset(bulk 'C:\temp\travelers.xml', single_blob) as XmlDoc; 

select * from travelers_xml;
go

declare @xmlDoc as xml, @hDoc as int, @sql nvarchar(max);

select @xmlDoc = XmlDoc from travelers_xml;
exec sp_xml_preparedocument @hDoc output, @xmlDoc;

-- select @hDoc

select DOB, NamePrefix, GivenName, MiddleName, SurName, LocationTypeCd, AreaCode, PhoneNumber, EmailAddress, AddressType, AddressLine, CityName, CountryCode, DocID, DocTypeCode
  , VendorTypeCode, MembershipID, AccountBalance, SeatPreferenceCode
from openxml(@hDoc, 'Traveler/Customer/Telephone')
with
(   DOB datetime '.././@BirthDate'
  , NamePrefix varchar(10) '.././PersonName/NamePrefix'
  , GivenName varchar(30) '.././PersonName/GivenName'
  , MiddleName varchar(30) '.././PersonName/MiddleName'
  , SurName varchar(30) '.././PersonName/SurName'
  , LocationTypeCd varchar(5) './@LocationTypeCode'
  , AreaCode varchar(3) './ParsedPhoneNumber/@AreaCd'
  , PhoneNumber varchar(15) './ParsedPhoneNumber/@PhoneNumber'
  , EmailAddress varchar(100) '.././Email/@EmailAddress'
  , AddressType varchar(5) '.././Address/@LocationTypeCode'
  , AddressLine varchar(40) '.././Address/AddressLine'
  , CityName varchar(40) '.././Address/CityName'
  , CountryCode varchar(40) '.././Address/CountryCode'
  , DocID varchar(15) '.././Document/@DocID'
  , DocTypeCode varchar(15) '.././Document/@DocTypeCode'
  , VendorTypeCode varchar(5) '.././CustLoyalty/@VendorTypeCode'
  , MembershipID varchar(20) '.././CustLoyalty/@MembershipID'
  , AccountBalance numeric(19,5) '.././CustLoyalty/CustLoyaltyTotals/@AccountBalance'
  , SeatPreferenceCode varchar(10) '../.././PrefCollections/AirlinePref/AirlineSeatPref/SeatInfo/@SeatPreferenceCode'
);

exec sp_xml_removedocument @hDoc;


    Note that my query first creates a table called travelers_xml to host the data coming from the travelers.xml file. I then use the openrowset statement to read from the file into the table. The SELECT statement then simply uses the openxml, using the Traveler/Customer/Telephone node as anchor. Everything else is relative to that node. For example, pay attention to the SeatPreferenceCode, which is a part of the PrefCollections/AirlinePref/AirlineSeatPref/SeatInfo node. I hope this helps. 

    Also, full keys, i.e., AddressLine do not use the @ sign. This is reserved for properties within that node.

    The document is too big for me to write a full query for you, but if you have any doubts or questions please post back.

  • Community Member Profile Picture
    Community Member on at

    Thank you Mariano for the great assistance, that actually helped quiet bit. i do have a question though; the Telephone part, there are three lines with the same header "telephone" how do handle that to show all three lines. if i write "telephone" tag multiple times, i get the same repeated data 3 times? Thanks again

  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Adal,

    The query I created above does create 3 lines, one for each number. That's why I anchored it at the PhoneNumber level to begin with :-) 

    phones.jpg

  • Community Member Profile Picture
    Community Member on at

    Mariano you are amazing, thank you for the assistance. I'm sorry that i didn't give you full information before. i'm attaching the updated xml file and my code below. The xml structure is like this: Extract > Profile (which there will be multiple profiles) > Traveler (i'm assuming there could be multiple traveler's within one profile) > Customer (and again i'm assuming there could be multiple Customers within Traveler). with that being said I took your code that you had sent before and wrote the code i have below. it works, but i'm only seeing one line. i figure i'll use the parent (extract) as my anchor and then use "./" to display results. if you could assist me in this i would be greatly appreciative. Thanks again

    <Extract>
  <Profile CreateDateTime="2012-03-14T18:01:32.984Z" UpdateDateTime="2012-03-14T18:01:32.984Z" PrimaryLanguageIDCode="EN">
    <TPA_Identity ClientCode="AS" ClientContextCode="UPL" UniqueID="100000003" ProfileTypeCode="TVL" DomainID="U0" ProfileStatusCode="AC">
      <ProfileSubType SubTypeCode="FFP" />
    </TPA_Identity>
    <Traveler>
      <Customer BirthDate="1979-01-19" GenderCode="M">
        <PersonName>
          <NamePrefix>MR</NamePrefix>
          <GivenName>John</GivenName>
          <MiddleName>Junior</MiddleName>
          <SurName>Smith</SurName>
        </PersonName>
        <Telephone LocationTypeCode="BUS" DisplaySequenceNo="1" OrderSequenceNo="1">
          <ParsedPhoneNumber AreaCd="48" PhoneNumber="123422365" />
        </Telephone>
        <Telephone LocationTypeCode="MOB" DisplaySequenceNo="2" OrderSequenceNo="2">
          <ParsedPhoneNumber AreaCd="48" PhoneNumber="666654554" />
        </Telephone>
        <Telephone LocationTypeCode="HOM" DisplaySequenceNo="3" OrderSequenceNo="3">
          <ParsedPhoneNumber AreaCd="48" PhoneNumber="777788854" />
        </Telephone>
        <Email EmailAddress="TEST@EMIAL.COM" DisplaySequenceNo="1" OrderSequenceNo="1" />
        <Address LocationTypeCode="HOM">
          <AddressLine>Road</AddressLine>
          <CityName>City</CityName>
          <CountryCode>PNG</CountryCode>
        </Address>
        <Document DocID="AS12345" DocTypeCode="PSPT" EffectiveDate="2017-01-01" ExpireDate="2027-01-01" />
        <CustLoyalty VendorTypeCode="AL" VendorCode="U0" MembershipID="100000003" OrderSequenceNo="1">
          <MembershipLevel MembershipLevelTypeCode="TI" MembershipLevelValue="01" />
          <CustLoyaltyTotals AccountBalance="1000" MembershipStartDate="2017-01-01" MilesToExpire="500" MilesExpireDate="2017-09-01" />
        </CustLoyalty>
      </Customer>
      <PrefCollections>
        <AirlinePref TripTypeCode="AZ">
          <AirlineSeatPref>
            <SeatInfo SeatPreferenceCode="NSSW" />
          </AirlineSeatPref>
          <AirlineMealPref>
            <MealInfo MealTypeCode="CHKN" />
          </AirlineMealPref>
        </AirlinePref>
        <LoungePref TripTypeCode="AZ" VendorTypeCode="AL" VendorCode="U0">
          <PreferredDrink DrinkName="Water" />
        </LoungePref>
      </PrefCollections>
      <TPA_Extensions>
        <SSR SSRCode="WCHS" />
      </TPA_Extensions>
    </Traveler>
  </Profile>
  <Profile CreateDateTime="2010-03-14T18:01:32.984Z" UpdateDateTime="2012-03-14T18:01:32.984Z" PrimaryLanguageIDCode="EN">
    <TPA_Identity ClientCode="AS" ClientContextCode="UPL" UniqueID="100000004" ProfileTypeCode="TVL" DomainID="U0" ProfileStatusCode="AC">
      <ProfileSubType SubTypeCode="FFP" />
    </TPA_Identity>
    <Traveler>
      <Customer BirthDate="1959-01-19" GenderCode="M">
        <PersonName>
          <NamePrefix>MR</NamePrefix>
          <GivenName>John</GivenName>
          <MiddleName>Senior</MiddleName>
          <SurName>Smith</SurName>
        </PersonName>
        <Telephone LocationTypeCode="MOB" DisplaySequenceNo="2" OrderSequenceNo="2">
          <ParsedPhoneNumber AreaCd="48" PhoneNumber="123321221" />
        </Telephone>
        <Email EmailAddress="TEST2@EMIAL.COM" DisplaySequenceNo="1" OrderSequenceNo="1" />
        <Address LocationTypeCode="HOM">
          <AddressLine>Road</AddressLine>
          <CityName>City</CityName>
        </Address>
        <Document DocID="AS12345" DocTypeCode="PSPT" EffectiveDate="2017-01-01" ExpireDate="2027-01-01" />
        <CustLoyalty VendorTypeCode="AL" VendorCode="U0" MembershipID="100000004" OrderSequenceNo="1">
          <MembershipLevel MembershipLevelTypeCode="TI" MembershipLevelValue="02" />
          <CustLoyaltyTotals AccountBalance="10000" />
        </CustLoyalty>
      </Customer>
    </Traveler>
  </Profile>
</Extract>

    USE OPENXMLTesting
GO
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
SELECT @XML = XMLData FROM XMLwithOpenXML
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML
SELECT DOB, Gendr,Title,FName,MName,LName,TelType,AreaCode,PhoneNumb,Email,AddType,Addrs,City,CntryCd,DocID,DocType,EffDate,ExpDate,VenTypeCode,VenCode,MembID,MemLevl,
AcctBal,MemStartDate,MilesExp,MileExpDate,SSRCode
FROM OPENXML(@hDoc, 'Extract')
WITH 
(
DOB [date] './Profile/Traveler/Customer/@BirthDate',
Gendr [nvarchar](3) './Profile/Traveler/Customer/@GenderCode',
Title [varchar](5) './Profile/Traveler/Customer/PersonName/NamePrefix',
FName [varchar](5) './Profile/Traveler/Customer/PersonName/GivenName',
MName [varchar](5) './Profile/Traveler/Customer/PersonName/MiddleName',
LName [varchar](5) './Profile/Traveler/Customer/PersonName/SurName',
TelType[varchar](5) './Profile/Traveler/Customer/Telephone/@LocationTypeCode',
AreaCode[varchar](3)'./Profile/Traveler/Customer/Telephone/ParsedPhoneNumber/@AreaCd',
PhoneNumb[varchar](10)'./Profile/Traveler/Customer/Telephone/ParsedPhoneNumber/@PhoneNumber',
Email[varchar](20)'./Profile/Traveler/Customer/Email/@EmailAddress',
AddType[varchar](5)'./Profile/Traveler/Customer/Address/@LocationTypeCode',
Addrs[varchar](20)'./Profile/Traveler/Customer/Address/AddressLine',
City[varchar](15)'./Profile/Traveler/Customer/Address/CityName',
CntryCd[varchar](5)'./Profile/Traveler/Customer/Address/CountryCode',
DocID[varchar](10)'./Profile/Traveler/Customer/Document/@DocID',
DocType[varchar](10)'./Profile/Traveler/Customer/Document/@DocTypeCode',
EffDate[date]'./Profile/Traveler/Customer/Document/@EffectiveDate',
ExpDate[date]'./Profile/Traveler/Customer/Document/@ExpireDate',
VenTypeCode[varchar](3)'./Profile/Traveler/Customer/CustLoyalty/@VendorTypeCode',
VenCode[varchar](3)'./Profile/Traveler/Customer/CustLoyalty/@VendorCode',
MembID[varchar](10)'./Profile/Traveler/Customer/CustLoyalty/@MembershipID',
MemLevl[varchar](3)'./Profile/Traveler/Customer/CustLoyalty/MembershipLevel/@MembershipLevelTypeCode',
AcctBal[int]'./Profile/Traveler/Customer/CustLoyalty/CustLoyaltyTotals/@AccountBalance',
MemStartDate[date]'./Profile/Traveler/Customer/CustLoyalty/CustLoyaltyTotals/@MembershipStartDate',
MilesExp[int]'./Profile/Traveler/Customer/CustLoyalty/CustLoyaltyTotals/@MilesToExpire',
MileExpDate[date]'./Profile/Traveler/Customer/CustLoyalty/CustLoyaltyTotals/@MilesExpireDate',
SSRCode[varchar](5)'./Profile/Traveler/TPA_Extensions/SSR/@SSRCode'
)
EXEC sp_xml_removedocument @hDoc
GO


  • Community Member Profile Picture
    Community Member on at

    Hello Mariano, to simplify my question. I was able to get everything. the only issue i'm having is that i also have two "contact names" rows along withe the three telephone rows. by using your example, i can see three different numbers but for the contact name it is only reading the first row and therefore repeating the same name. how can i fix that? i can send you my updated code if you like? 

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Adal,

    Sorry for the late reply. Maybe I am missing something. From the XML you display above, I did not see contact names anywhere. Nonetheless, the principle is the same, you can anchor your node path at the contact level instead of the telephone, then make all of the other node inquiries relative to the contact.

  • Community Member Profile Picture
    Community Member on at

    Thank you so much for the reply, i was thinking you gave up on me lol. i did try making the contact name as the anchor point. i was able to make the name appear accurately but then however only the first telephone was being repeating.  The contact name is on the same hierarchy level as telephone. there can be multiple rows for contacts, then multiple rows for tel as well (business, mobile, fax) in my case i have two lines first for contact names then after the name (in the same hierarchy level) i have two phones (bus and fax) when i make the tel my anchor point i can see both phone types, but then only one contact shows up twice. when i make contact name my anchor point, then the names come out good but the bus type for phone is repeated for both contacts. i hope that makes sense, i'll post the code real quick so you can see. I really appreciate your help, i almost have it done.

  • Community Member Profile Picture
    Community Member on at

    Here is my updated data:

      <Profile CreateDateTime="2012-06-24T11:30:38.836Z" UpdateDateTime="2012-09-03T11:41:10.518Z" PrimaryLanguageIDCode="EN">
    <Corporation>
      <CorporateInfo CorporationName="ABC Corp" CorporationTypeCode="LRG" NatureOfBusinessCode="GOV" CreditBankInd="N">
        <TaxInfo TaxID="123456" TaxTypeCode="USF" DisplaySequenceNo="1" OrderSequenceNo="1" />
      </CorporateInfo>
      <ContactName GivenName="john" SurName="doe" DisplaySequenceNo="1" OrderSequenceNo="1" LanguageIDCode="EN-US" ContactTypeCode="SM" />
      <ContactName NamePrefix="MR" GivenName="Sara" SurName="Smith" DisplaySequenceNo="2" OrderSequenceNo="1" LanguageIDCode="EN-US" CompanyName="ABC Corp" />
      <Address LocationTypeCode="CMP" DisplaySequenceNo="1" OrderSequenceNo="1">
        <AddressLine>999 Broadway</AddressLine>
        <CityName>Atlanta</CityName>
        <PostalCd>44521</PostalCd>
        <StateCode>GA</StateCode>
        <CountryCode>US</CountryCode>
      </Address>
      <Telephone LocationTypeCode="BUS" DeviceTypeCode="VC" DisplaySequenceNo="1" OrderSequenceNo="1">
        <ParsedPhoneNumber PhoneNumber="111-222-3333" />
      </Telephone>
      <Telephone LocationTypeCode="BUS" DeviceTypeCode="FX" DisplaySequenceNo="2" OrderSequenceNo="2" FaxDevice="Y">
        <ParsedPhoneNumber PhoneNumber="555-666-7777" />
      </Telephone>
      <Email EmailTypeCode="BUS" EmailAddress="john.doe@notreal.com" DisplaySequenceNo="1" OrderSequenceNo="1" />
      <Discounts TypeCode="DIS" ID="DEFAULT" ExpiryDate="2005-12-31" DisplaySequenceNo="1" OrderSequenceNo="1" Percentage="0" Rate="229" />
      <BusinessTravelerSetting DefaultBusTvlTypeCode="AE" DefaultBusTvlStatusCode="AC" />
      <NumberOfAssocProfiles Traveler="7" />
    </Corporation>
  </Profile>


    Here is the updated code:

    USE OPENXMLTesting2
GO
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
SELECT @XML = XMLData FROM XMLwithOpenXML
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML

SELECT *
FROM OPENXML(@hDoc, 'Extract/Profile/Corporation/ContactName')
WITH 
(
ProfCDte[date]'../../@CreateDateTime',
CorpName[nvarchar](50)'../CorporateInfo/@CorporationName',
CorpType[nvarchar](5)'../CorporateInfo/@CorporationTypeCode',
TaxID[nvarchar](15)'../CorporateInfo/TaxInfo/@TaxID',
CntctFName[nvarchar](5) '@GivenName',
CntctLName[nvarchar](5) '@SurName',
TelType[nvarchar](5) '../Telephone/@LocationTypeCode',
TelNum[nvarchar](15)'../Telephone/ParsedPhoneNumber/@PhoneNumber',
EmailType[nvarchar](5)'../Email/@EmailTypeCode',
Email[nvarchar](50)'../Email/@EmailAddress',
NumofProf[int]'../NumberOfAssocProfiles/@Traveler'

)
EXEC sp_xml_removedocument @hDoc
GO


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans