Questions tagged [microsoft-dynamics]

0

votes
0

answer
5

Views

DISTINCT based on multiple columns

I have a groupby in linq that looks like this: var grouped = from all in Allergies.Entities.AsEnumerable() group (Guid)all.GetAttributeValue("allergy.new_foodsensitivityid").Value by new { group = all.GetAttributeValue("new_group"), time = all.GetAttributeValue("new_time"), desc = all.GetAttributeVa...
Alan Judi
0

votes
0

answer
5

Views

Unable to connect to the destination mentioned in the KeyVault URL- Azure SQL

I am trying to use the Dynamics 365 Data export service to connect with my Azure SQL with Azure AD connection. When following this tutorial : https://www.youtube.com/watch?v=txms2Yvn6Vc and many more; i figured out how to export my D365 data export service but this tutorial is based on my SQL user....
user10991083
1

votes
2

answer
1.1k

Views

Can't connect to Dynamics 365 with Xrm.Tooling.Connector after 365 update

Our organization uses Dynamics Online and this weekend received a major update from CRM 2016 (8.1) to 365 (8.2), and since then my apps can't connect using the Xrm.Tooling.Connector: CrmServiceClient client1 = new CrmServiceClient(ConfigurationManager.ConnectionStrings["XrmPowerString"].ConnectionSt...
Joao Leme
1

votes
1

answer
1.1k

Views

How to get Process Finish Button event in Dynamics CRM?

I am using Dynamics 365 online instance to integrate sales process. I have one condition where I need to change the Probability field value to 100 when user clicks on Finish button in Close Process Stage. I have done some research and found that (OnProcessStatusChange event) can help to get business...
Cyber
1

votes
1

answer
48

Views

How to see the code under xLanguage standard class?

I need to see the code under the class xLanguage. In order to understand how to get the Language Description, xLanguage::languageID2Description(str languageID) // method
ulisses
1

votes
1

answer
54

Views

SQL/Navision DateTime Issue

I don't know if anyone else has experiencing this issue before I have DateTime Data in a MsSQl table but when displaying the same data in Navison 2013, it is displaying the time wrongly. 2018-12-14 08:20:22.000 is being displayed as 14-12-18 11:20:22 AM Any suggestions ? Thanks in Advance
Alfred Kimotho
0

votes
0

answer
5

Views

MS Dynamics CRM 365 - import data from Excel files

I'm getting into MS Dynamics CRM 365 programming, and have been dealing with data imports of lookup / reference entities. I created a new entity with just the default Name column, stored and published it, and then went to look at in CRM. From the default "main" view, I choose the "Data Import" optio...
marc_s
0

votes
0

answer
14

Views

Left outer join in linq to entites on two entitycollections:

I have two entitycollections that have 3 common attributes. The first entitycollection is called Replacements with attributes of new_time, new_serving, new_desc and other attributes. I have a second entitycollection called NoReplacements which has a bunch of attributes including new_time, new_servin...
Alan Judi
1

votes
2

answer
12.6k

Views

Whats the URL from the Microsoft Dynamics CRM Server? [closed]

Today I installed the Microsoft Dynamics CRM on my Windows Server 2008 r2. Everything was fine, but now I can't find the Link to my Hompage. Can somebody of you tell me the default URL from the Microsoft Dynamics CRM? I just installed the 90 day free Trial version of it. When I type in my browser:...
Marco Laim
1

votes
1

answer
517

Views

Infolog with large amount of messages

I am having an issue using Dynamics Ax 2012 Enterprise Portal where I am displaying every validation error in the infolog to a custom page in a modal dialog. If there are many errors, the infolog will place itself above the page, and I have to click and drag text to force the window to scroll up and...
steckums
1

votes
2

answer
2.8k

Views

Start SQL Job from X++ Job in Axapta

I want to trigger an SQL job which runs an SSIS package from an AX Job, I successfully ran SQL code fetching some records from an SQL table by creating a menu item for the job and have it run on the server instead of the client but the following code runs without errors but the Job's not started? CO...
Mike Dole
1

votes
1

answer
2.8k

Views

Dynamics CRM : Difference between Site and Sales Territory

I am creating organization architecture in dynamics CRM. I have one question regarding - Site vs Sales Territory or BU vs Site When exactly we should create Site, Sales Territory or BU ? Or we can say what are the limitations of them ? I have gone through many forums and websites but not able to...
Mittal Patel
1

votes
1

answer
1.3k

Views

get help text of system command button?

how can i get helptext of system command button , i use a class to browse a node of a form and get helptext of controls contained in the form, i have not to use the tooltip method cause i will use the formrun object and it doesn't work correctly and degrades performance i use a program like this :...
user3203594
1

votes
1

answer
4.3k

Views

Access Dynamics NAV Webservice with Java

I am trying to access a Dynamics NAV 2013 R2 web service from Java. The web service is running and when I enter the URL in the Internet Explorer, I can see the WSDL but first I am prompted for Username and Password. On Wireshark I can see that it uses authentication based on NTLM. Sofar I was only a...
lanoxx
1

votes
3

answer
6.3k

Views

Avoiding inserting duplicate data into table in MS Dynamics AX

I have a custom table that I'm inserting data into. I do not want duplicate data to end up there, so I created a unique index consisting of 20ish fields that I wish to be unique. As expected, when I run my job to insert data it of course fails and tells me it was trying to insert a duplicate record...
codemann8
1

votes
2

answer
2.8k

Views

Dynamics AX 2012 R3: Penny Difference on invoice voucher

I have create an invoice with invoice amount = 96.63 Purchase order: create with one line with amount = 72.24 (with TAX 20%) Header charges on Purchase order = 5.96 (with TAX 20%) In the invoice register when I select the purchase order and put the invoice amount 96.63 it shows me TAX(20%) = 16.11...
Danish
1

votes
1

answer
490

Views

Left outer join in CRM 2013

Is it possible to create a fetchxml/query expression/LINQ expression in Dynamics CRM 2013 that will return all parent entities that don't have a child entity with an attribute set to a specific value? For example, can we retrieve all accounts which don't have an associated contact named Bob Smith? I...
user3614415
1

votes
2

answer
392

Views

Dynamics GP Web Services: Changing policy behavior at runtime

I am creating a payables invoices using Web Services on GP2013. Optionally, my users can provide line item distributions. I can create invoices, but unless I modify the CreatePayablesInvoice policy to "Distributions Will Be Provided" in the dynamics security console, the invoice gets both the syst...
BrianB
1

votes
2

answer
628

Views

Edit FormBuildControl when opening AX form

I have tried the following: AX2009 Loop through all the controls in the form on init, and have been able to loop through all the form controls in the form when opening it. But, for some reason, when i try to edit a form control, it is not working. I have a switch statement like this: switch ( contro...
user3660338
1

votes
1

answer
1.1k

Views

Remove Name and owner in CRM Dynamics

I have created a form for cheque entries. But when i create the form "name" and "owner" field are compulsory and it does not allow to remove either. Any suggestions really appreciated.
Shivprasad Koirala
1

votes
2

answer
520

Views

Can't edit Security Roles from Non-Default Business Unit

When "customising the system" in Dynamics 2013, I cannot see any roles outside of the default business unit (even if I move my "System, Customiser user" to the business unit in question. I have tried a solution and the defauilt solution. How do you see all roles in all business units to customise th...
Ryan
1

votes
2

answer
1.2k

Views

Why is CRM 2013 Online Plugin running under SYSTEM user all the time

I've built a plugin for Microsoft Dynamics CRM 2013 Online platform. The plugin is registered at Delete of my_custom_entity. It is synchronous and post-operational. Impersonation is set to Calling user. As far as I know the plugin should be fired with the calling user's privileges etc. with these se...
kivikall
1

votes
1

answer
1k

Views

What do I do when MorphX won't let me check in?

When I go to check something into MorphX VCS right now, I get the following message: Cannot create a record in SysVersionControlMorphXRevisionTable (SysVersionControlMorphXRevisionTable). The record already exists. With things that have already been checked out once, I've been able to resolve this w...
wax eagle
1

votes
1

answer
1.8k

Views

Generate Mail Merge documents programatically on Microsoft Dynamics CRM 2013

Is there any way to generate a mail merge document programatically via the Microsoft Dynamics CRM 2013? Trying to generate a mail merge document via a custom plugin in the back end. The merged document would then be sent to sharepoint. But... can't find a "Create Merged Document" feature in the CRM...
Lenny
1

votes
1

answer
2k

Views

Microsoft Dynamics AX - Sales Order to Invoice class location

I'm looking to make a modification in the logic where an invoice is made from a Sales Order. In other words, as soon as the Sales Order status changes to "Invoiced", I want to be able to add some additional code there that updates something else. I'm having a lot of trouble finding the class where...
user1300922
1

votes
2

answer
370

Views

crm merging two entities into one, best way to copy info from old entities to new entity

I have two entities in crm that I want to combine into one, I have several thousands records so need some type of batch option. I am considering my options as to what the best way to do this would be? From what I have found SSIS looks like the way to go. Any other options I should consider? Thank...
user541597
1

votes
2

answer
193

Views

Ax2009 Tree node export

Is there another way to export TreeNodes from AX2009 besides TreeNode.treeNodeExport(filename)? Is there possibly a way of doing this based on the UtilElements table? EDIT When calling treeNodeExport while connected with the .Net Business connector, the method .treeNodeExport fails. I was wondering...
user3660338
1

votes
2

answer
1.4k

Views

Import of Solution Fails Without Error Message in Dynamics CRM

We are trying to import a solution from our Sandbox environment to our DEV environment. When we import the solution into DEV, the system shows the Import in Progress window, but eventually it stops. It states that the import of the solution failed, but in the grid below (which shows the solution com...
Hussain Ahmad
0

votes
0

answer
2

Views

AX 2012 retail statement posting involving retail kits

A change from origin with lot ID 025777372 to origin with lot ID 025777770 is not allowed because the values in field ItemInventDimId are not identical. I get this error when posting retail statements. From investigations this is because of retail kits in the sales transactions. The error happens in...
Lawrence
0

votes
0

answer
4

Views

Extension v2 for Dynamics NAV 2017

I got used to develop Extensions for Navision based von V2, so I was wondering, if there is a way to use the AL-Dev-Tools for developing V2 Extensions for Dynamics NAV 2017. I could not find the ALLanguage.vsi for Version 10, only for Version 11 (NAV 2018) and Version 12 (NAV BC). Is there a way to...
luki
2

votes
2

answer
144

Views

Using Dynamics CRM SDK with .NET Core

Is there a way to connect to Dynamics CRM 365 from a .NET Core application via the Dynamics SDK? Or should I use the Web Api? I've read it could be possible, but when I reference the SDK from my .NET Core Class Library and try to connect I get the error: System.IO.FileNotFoundException: 'Could not l...
manipurea
1

votes
2

answer
916

Views

Getting weird behavior when retrieving data from Microsoft CRM using LINQ

I'm having this problem accessing the Contact entity using LINQ. I have the 2 functions below. If I ran the 1st function and then call the 2nd one, I seemed to be missing a lot of fields in the 2nd query. Like firstname and lastname are not showing up. They just shows up as null values. If I ran the...
mrjayviper
1

votes
2

answer
1.5k

Views

How to get current date in workflows (Dynamics CRM 2016)

I would ask about how to get current date in workflows.? For example:- I have field called (Inspection Date) I would like to compare this filed if it equal current date then go into the process. I will create Wait Condition waiting until current date = Inspection date then will do my process . How t...
Majed Al-Omair
1

votes
2

answer
2k

Views

Install permissions are not given to the Dynamics 365 admin [closed]

We've got the Dynamics 365 trial which is release on 1st November 2016 , the trial is in my name (hence I am the Admin). To this, we're trying to add the Project Service Automation from AppSource. When we click on Try, it gives the below error: You do not have install permissions to the Dynamics 365...
student
1

votes
2

answer
134

Views

Dynamics CRM - Register a plug-in when the user logs in

I would like to fire an event when the user logs in to his account on Dynamics CRM ? Such as opening a Web App beside the CRM... Is This possible ? I know that I can write plug-in that allows to augment some business process such as account creation. Any advice will be appreciated !
Hubert Solecki
2

votes
2

answer
3.9k

Views

Dynamics AX 2009 Rollup 7 Enterprise Portal AX_Core ERROR using Windows server 2008 r2 64 bits and sharepoint 2010 foundation

Arquitecture: AOS Server: Running windows server 2008 r2 std 64 bits spanish. Enterprise Portal Server: Running windows server 2008 r2 std 64 bits spanish, SharePoint 2010 Foundation 64 bits, IIS 7.5 DataBase server: Running Window server 2008 r2 std 64 bits spanish, SQL Server 2008 std r2 64 bits s...
2

votes
0

answer
972

Views

Microsoft Dynamics CRM 2011 prevent close as won with javascript

What is the javascript to prevent a user from closing an opportunity as won in crm 2011/2013? If the user wants to close as lost, I want to let them do it. But under certain conditions, I do not want them to close as won if a field is not populated. The CRM 4.0 code no longer works. I have the pass...
Hank Knah
1

votes
1

answer
2.2k

Views

How to decode/unescape HTML in Dynamics AX

I have some HTML encoded within an XML request I get through an AIF web service. The text I'm getting is of course escaped - I get <br> instead of . Is there a proper way to decode it? I don't want to write something for the basic stuff, then deal with bug reports for the next decade, because I for...
Mrki
1

votes
3

answer
7.3k

Views

Navision How to Convert a Text to Option

I have a text variable which I want to convert into a option and set table data with it. How do it convert the variable into a option? Thanks
Florian
1

votes
1

answer
760

Views

Is it possible to create tabbed interface on a form in Dynamics CRM 2011?

Is it possible to add tabs to a Dynamics CRM 2011 form? I'm not talking about the "tabs" that are basically vertical sections on the form, which you can click the links on the navigation portion of the form to jump to. I want a real tabbed interface like the screenshot below. Something like the jQue...
NoodleFolk

View additional questions