FAQ Database Discussion Community


Shortcut key for *now*

microsoft-dynamics,navision
I'm looking for the shortcut to enter the date and time of now in Microsoft Navision. I know about 't', which will enter today's date, but that leaves the time-part empty. So basically: What key goes at the place of the ? Key Result 't' 06/03/15 00:00:00 ? 06/03/15 14:36:28...

Query to fetch emails tracked in CRM

dynamics-crm-2011,dynamics-crm-2013,microsoft-dynamics
Is there a way to query tracked emails in CRM 2011 or above using SQL(Filtered Views)? Please help.

Enable/Find logging for Dynamics AX Odata service

microsoft-dynamics,dynamics-ax-2012,dynamics-ax-2012-r2,dynamics-ax-2012-r3
I'm trying to connect an external system to AX using the OdataQueryService. Connecting with Excel gives the correct results from the server, however I get an error when using the external system. Is there some logging on the Dynamics AX Odata service that I can enable for troubleshooting? Rob ...

Microsoft CRM 2011 - Created new user unable to access the system

crm,microsoft-dynamics
I have created two accounts from the Active Directory, and those accounts are unable to access the system, but the account that was used to create the Organization for the first time doesn't seem to have that problem. The error on the website with DevError set to On : An...

Relationship between GeneralJournalAccountEntry and LedgerJournalTrans_Project

axapta,microsoft-dynamics,dynamics-ax-2012
We are attempting to relate GL transactions GeneralJournalAccountEntry with their appropriate Project Category Id LedgerJournalTrans_Project, but are having a very difficult time relating the two tables. We can get there by this route: GeneralJournalAccountEntry.GeneralJournalEntry = GeneralJournalEntry.RecId (Many to 1) GeneralJournalEntry.SubLedgerVoucher = LedgerJournalTrans.Voucher (1 to Many) LedgerJournalTrans.RecId = LedgerJournalTrans_Project.RefRecId (1 to...

Unit price is not updating while create items on eConnect

c#,microsoft-dynamics,dynamics-gp,econnect,gp
I was using eConnect to connect my .NET application to the Dynamics GP. This is my C# eConnect code to create/update an item on Dynamics GP. taUpdateCreateItemRcd GpLineItem = new taUpdateCreateItemRcd(); GpLineItem.ITEMNMBR = "iPartNumber"; GpLineItem.ITEMDESC = "iDescription"; GpLineItem.CURRCOST = 50.65; GpLineItem.ITMCLSCD = "classID"; GpLineItem.ITEMTYPE = 1; GpLineItem.Purchase_Tax_Options = 2; GpLineItem.UOMSCHDL...

List Entity Relationships in Dynamics CRM 2013/2015

c#,powershell,dynamics-crm,crm,microsoft-dynamics
Is it possible to return a list of relationships on a particular type of entity (not an individual record) using the CRM/XRM SDK? For example, if I have an entity called "Case" and I need to see if it has a relationship with "MyCustomEntity" is it possible to query the...

Configuring a picklist in CRM Online 2015

microsoft-dynamics,dynamics-crm-4,dynamics-crm-2015,picklist
We currently have a CRM Dyanmics 4.0 system and as part of our Account Entity we have a field new_accountstatus with the following set up: Schema Display Name: Account Status Name: new_accountstatus Requirement Level: No Constraint Searchable: Yes Description: "V1.0" Type Type: Picklist Overdiew 2. Active 3. Suspended 4.De-Energise 5.Terminated...

Javascript in Ms CRM (with odata query) is not working?

javascript,crm,microsoft-dynamics
I created a javaScript(by the way i learned it yesterday only ) this script is set to fire upon OnSave event of Accounts entity . I build a odata query using query builder tool that i found on Internet which is supposed to retrive all the tasks ($select=ActivityId,CreatedOn ) and...

Microsoft Dynamics CRM 2013 - Create Popup/Dialog

popup,crm,microsoft-dynamics
I'm currently trying to create a popup like this: http://i.stack.imgur.com/faqQA.png But i don't know where to start. Is it a Webresource? If yes is it done via JScript or ASPX?...

Dynamics CRM xrm.cs compile error

c#,crm,microsoft-dynamics,xrm
I'm trying to connect to CRM using steps declared in this link https://msdn.microsoft.com/en-us/library/gg695790.aspx Error Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler...

Form data source edit method on a view - AX 2009

axapta,microsoft-dynamics,dynamics-ax-2009
I am trying to add a edit method to my grid from my data source in the form. I have the following code for the edit method: edit boolean markLine( boolean set, Datasource _datasource, boolean _mark ) { if (set) { if (!_mark) { if (selectedLines.exists(_datasource.RecId)) { selectedLines.remove(_datasource.RecId); } }...

How to migrate AX 4.0 (SP2) on Oracle to a SQL server platform

sql-server,oracle,axapta,microsoft-dynamics
I'm facing a problem with MS Dynamics AX 4.0 SP2 while I migrate data from oracle (version 10) to SQL Server 2008 R2 and I am using SSMA tool to transfer data. The AX system with Oracle is customized in 3 layers 'var', 'cus', 'usr'. I have already done these...

How to get CRM 2013 Online Database schema

dynamics-crm-2011,dynamics-crm,crm,dynamics-crm-2013,microsoft-dynamics
How can i get database schema for my Dynamics CRM 2013 Online? Is it possible in CRM 2013 online? If it is possible to get database schema, can you tell me any procedure?

new to CRM, how to get CRM environment for learning and work around

dynamics-crm,microsoft-dynamics,dynamics-crm-online,dynamics-crm-2015
I m a .net developer and new to CRM. Unfortunately at my work we don't have CRM. I m intrested in learning CRM but not sure how I can get CRM environment for practice and learning. Please guide should I go for CRM 2015 ? Should it be installed on...

Set Partylist value using array in JavaScript

javascript,arrays,microsoft-dynamics
I'm trying to set the value of the partylist from an array, which formatted from selected contacts. But I got exception indxIds is undefined, tried a lot to figure it out but couldn't do so. Here is in the following what I'm trying to do: //arrIds is the array of...

Not all query datasources available on ListPage

axapta,microsoft-dynamics,dynamics-ax-2012
In the MSDN tutorial on adding data sources to a list page, it says Expand the Data Sources node for the list page. The node includes the query that you added and the data sources associated with that query. However I noticed not all the datasources of the query for...

Error: Query with id 'DAXSecurityUsersAndRoles' does not exist. How to resolve this?

reporting-services,microsoft-dynamics,dynamics-ax-2012,ssrs-2012,dynamics-ax-2012-r3
I am trying to run a report in Dynamics AX "Menu/Sys Admin/Reports/Security/Roles and Users Attached List" which is throwing me below error Query with id 'DAXSecurityUsersAndRoles' does not exist. Anybody faced this before? What to do to fix this?...

Build an Improved CRM dynamics 2011,13,15 Online Import Tool

crm,microsoft-dynamics,xrm
Wanted to build an online import tool for CRM dynamics 2011,13,15. It is not a tool to compete with Scribe or SSIS adapter. Rather it is tool to help the normal business users to use. Or data professional who wants to upload a small amount of data without using a...

What is the TECHNICAL Difference between Entity.Contains AND Entity.Attributes.Contains

dynamics-crm-2011,dynamics-crm,dynamics-crm-2013,microsoft-dynamics
What is the TECHNICAL Difference between Entity.Contains AND Entity.Attributes.Contains. I know both of them work, but looking for some technical details.

Is it possible to add and configure Dynamics CRM workflows with Powershell

powershell,dynamics-crm,crm,microsoft-dynamics
Is it possible to deploy a managed solution to Microsoft Dyanamics CRM 2013/2015 with plugin assemblies via the UI, then use a PowerShell script to add workflows, and steps?

Spring Integration: call REST endpoint using outbound gateway with oAuth?

rest,oauth-2.0,spring-integration,microsoft-dynamics
I have been using SI outbound gateway to call a REST endpoint protected using NTLM (Microsoft Dynamics backend). It was simple enough, just configure the HttpComponentsMessageSender credentials to use Apache HttpClient's NTCredentials, and it works transparently. Now however they've gone and protected it with ADFS, which requires oAuth 2.0 authentication....

How do you find a user's last used printer in SysLastValue

printing,axapta,microsoft-dynamics,dynamics-ax-2009,dynamics-ax-2012-r2
I've been trying to find where a user's last used printer is stored so that I can clear this usage data (as a few users have an issue where the remembered printer keeps defaulting to the XPS writer, despite us having KB981681 installed & the printer being available; just not...

Init Ledger Journal Trans offset account

axapta,microsoft-dynamics,x++
I am trying to create (and post) ledger journals from data received via AIF inbound service. The data is written in a custom staging table with all necessary fields. Now, I need to create journals and journal trans records from this staging table. I am able to create LedgerJournalTable record...

How do I create a supplier in Microsoft Dynamics CRM 2015?

dynamics-crm-2013,microsoft-dynamics,dynamics-crm-2015
Microsoft CRM 2015.. a great little customer management system, but why did do they leave suppliers out? Anyway how do I create and manage suppliers using Dynamics CRM? or do you need different software for that? Cheers,...

Dynamics Ax 2012 Dialog - Questioning Training material

axapta,microsoft-dynamics,x++,dynamics-ax-2012
In the training material I am going over it is setting 3 DialogFields as such(I also am showing the table declaration: CustTable custTable; dlgCust = dlg.addField(extendedTypeStr(CustVendAc),"Customer account"); dlgGrp = dlg.addField(extendedTypeStr(CustGroupId)); dlgCur = dlg.addField(extendedTypeStr(CurrencyCode)); Then it tries to save the values from the dialog box into the custTable custTable.AccountNum = dlgCust.value();...

Microsoft Dynamics Error: Developing SSRS report using Report Data Provider

dynamics-crm-2013,microsoft-dynamics,aot
I am trying to create a class coding in AOT in my Microsoft Dynamics AX. What I am doing is to develop a SSRS report in Microsoft DynamicsAX 2012. Hence, for practice purposes I am actually following through this tutorial link: http://www.dynamics101.com/2013/09/developing-ssrs-report-using-report-data-provider-microsoft-dynamics-ax-2012/. Please Help. THank you However, I am getting...

CRM 2015 Outlook Plugin error

outlook,crm,microsoft-dynamics,dynamics-crm-2015
I am getting the following when trying to install the CRM 2015 plugin for Outlook: I have Outlook 2010 32 bit version installed and I downloaded the 32 bit version of the CRM 2015 Outlook plugin. thanks, Stephen...