Microsoft Dynamics

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Share tech news, updates, or what's on your mind.

Sign up to Post

We created a date field in Dynamics 365 that is for contracts that sunset. We would like to have our account owners be automatically notified when the date is within 60 days of expiring. What is the best method of doing this?
Thanks!
0
Learn Ruby Fundamentals
LVL 13
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

I am trying to extract data from AX to use in another system. I need Invoice cost by line but can't see where to get it.

INVENTITEMPRICE table has the costs in I need but I don't know how to match the dates to get the correct cost. E.g. if a sale is done after 01/01/2018 and before 26/04/2018 then the correct cost is 15.72 (See below)

Screenshot of INVENTITEMPRICE table
All I'm trying to do is get a cost price per invoice line but I'm not familiar with the AX data structure, can anyone help?
0
Hello:

A GP 2018 end user reports that a posted purchase receipt for one line item of a quantity of 800 shows up twice in the Purchase Receipts Work table (IV10200) and is, therefore, causing the quantity on hand and available in GP for this item to be doubled (1,600 instead of the correct quantity of 800).

I don't want to run a delete script on this table to remove this additional layer of 800, for obvious reasons.  But, the user has already run both Purchasing and Inventory Reconcile to no effect.

What can be done to fix this?

Thanks!

John
0
I have a user running Microsoft Dynamics NAV Classic 2009 on Windows 10. She cannot export more than 5000 records to Excel. The error is The no. of records in the table exceeds the max. no. of 5000. I've added the line <add key=”MaxNoOfXMLRecordsToSend” value=”100000″/> to her clientusersettings.config file. There is no other file with that name, so it must be the right file.
I cannot change the value using Tools -> Options as I get the message that I cannot type the number in a integer field no matter what number I use. The value here is 5000, but even if I type 5000 I get the error message.

Any ideas?

Thanks,
Ronnie
0
Hi EE,

This is more a general query but I just got a new job as an application support officer and one of the applications that have been allocated to support is Dynamics AX 2012 R3. I have a surface-level knowledge about this application are there any sites, training videos or other online resources that can give me jump start on how to administer this software.

Any assistance is welcome.

Thank you.
0
CRM 2011 for Outlook client fails to install with Outlook 2019
Message:
The installation has failed.  You do not have a supported version of Outlook installed.

It worked with Outlook 2016.  Is it officially unable to install on 2019 or is there a workaround?
0
Hello:

Is "Blank" the only type of Sales Order Processing invoice that can print to Word template format?  I noticed that, if you choose "Other", GP does not seem to let you print an aesthetically pleasing looking document in either Template or Standard format.

Secondly, with being tied down to that one Blank format, is there any way of modifying the invoice for multiple lines of business?

Let me see if can explain.  One set of customers needs to have the sales invoice displaying one way, while the other sets of customers need to have the sales invoice displaying differently.

Can this be done out of the box?

Thanks!

John
0
Any EE can suggest links or how to setup GP web client for GP2018?

Thank u!
0
We are estimating the effort to migrate a CRM 4.0 system to Dynamics 365 CE.  We plan on using Scribe or KingswaySoft to migrate the data, however, we need to estimate the time needed to recreate the custom forms, views and attributes in the new Dynamics 365 instance.  

Any advice or guidance on this process would be appreciated.
0
We need to move CRM 4.0 data into a clean installation of Dynamics 365 CE.  Since version 4.0 doesn’t use solutions, what are the options for moving data (accounts,contacts,leads,opportunities) into D365 CE entities?

We have access to Scribe and KingswaySoft.  We don’t want to go through a stepped upgrade (2011, 2013, 2015, 2016) and want to hear your thoughts on the best way to move our data to D365.  Also, would like to know any downside to moving our data without doing an upgrade.

Thanks
0
OWASP: Avoiding Hacker Tricks
LVL 13
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Hello:

A Microsoft Dynamics GP 2016 end user is having an issue where she needs to void a check dated 11/21/2018.

The check's corresponding invoice shows as voided.  But, the check is nowhere to be found.

When I say that, I mean that the client can see the check in a Bank Reconciliation SmartList as an unreconciled check.

But, when double-clicking on that record of the SmartList, the check does not appear.  The Checkbook Register Inquiry window and a screenshot of the voided historical invoice appears, instead.

When looking through Payables Inquiry windows and payables tables in SQL, this check is not found.

I recreated the payables keys file, including running check links, but to no effect.
Do you all have any thoughts on how to find this check so that it can be voided?

Thank you!

John
0
Hello:

A Microsoft Dynamics GP 2016 client is running into an issue where the quantity displayed within the "Balance" field of Item Stock Inquiry is not matching "Total Stock" in the Item Stock Inquiry window.

This discrepancy appears when the Unit of Measure is changed from the default, by the end user, in the drop-down list of the "Display Units of Measure" field.

The client has run Inventory Reconcile but to no effect.  

I did suggest running Check Links on the Inventory module as the next step, but what other steps can be taken?

Thank you!

John
0
Dear Experts
We are evaluating right fit product for our business processes and we found Microsoft Dynamics NAV (which is going to be business central) is right fit. We cannot keep our data in cloud and understood Dynamics NAV has on premise deployment option. Now the challenge it has become essential to have advanced analytics reporting and dashboards for which Power BI is one of the  option,  understood power BI has on premise deployment option think we have to go for Power BI Reporting server and at this moment I am not clear about licensing the advanced analytics requirement is for 15 users only.
 If we go for on premise power BI deployment, will the installed power BI application on each of the end user systems OR power BI reporting server which is behind my firewall will it send our data which is residing in on premise server to external/internet server for processing and showing up analytics/dashboards, Our requirement is code and data to be processed and rendered within the applications behind my firewall. we cannot allow our data outside our network. Please suggest.
Also if Microsoft power BI cannot work without connecting to their servers then please suggest any BI software which can suit my requirement. Thanks in advance, this is most critical decision that we have to take, please suggest.
0
hello,

Anybody knows where to download setup/userguide on dynamics Project Management GP 2018
0
Dynamics 365 9.1, InsideView

I am trying to create a plugin to update D365 lookups for Country and State.   The source of the updates will be option-set values from Insideview.

I have the basic structure (using statements, IPlugin interface, plugin code) but looking for guidance or examples for updating the lookup guids from the option set values.

Thanks
0
CRM 4.0 to D365 CE upgrade

We are trying to upgrade CRM 4.0 to D365 CE.  Part of the process is to establish the last login of CRM Users.  We have tried the query  below in the CRM 4.0 database but it is not returning the values we want.

select us.FullName, max(a.CreatedOn) as LastLoginDate from Audit a
inner join SystemUser us on a.ObjectId = us.SystemUserId
where
a.Operation = 4 and us.IsDisabled = 0
group by us.FullName

Open in new window

0
Hi I Donno if you can do this or not but thought would ask.

I have a intranet connection that I want to put an excel file on and myself as administrator can add and delete data from it.

I have locations that can view the excel file but  I need it to be in read only and I also need some sort of button in the workbook  that a person can select a row and when click on paid they have to input their name and location and it disappear off the read only screens all over the locations but still be visible to the administrator until he deletes them himself.

Is this possible
0
Dynamics 365 Online 9.1

We have Parent Business Units that own multiple Sub Business Units.  The Sub Units own Connections that show accounts, contacts and opportunities.  The Parent BUs, however, cannot see the accounts, contacts and opportunities visible to the Sub Unit Connections.

What changes need to be done to this structure to allow Parent BUs to see the accounts, contacts and opportunities visible to their Sub Unit Connections?
0
CRM 4, CRM 2011 upgrade

We are doing a CRM 4.0 to CRM 2011 upgrade.  I have been asked if certain vulnerabilities are addressed in CRM 2011 (that were present in CRM 4.0)

Specifically, vulnerabilities are reported in the .ASPX files. It exposes version information from IIS, .ASP NET etc.

Thanks
0
Introduction to Web Design
LVL 13
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

CRM 2013 plugin issue

We are getting a Business Process error when entering information into a specific address field.  The error is below and it indicates a specific plugin.  I am trying to use the plugin profiler to debug the error but I am not getting a log file to download.

The error:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Security.SecurityException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #FA546B2ADetail: 
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>System.Security.SecurityException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #FA546B2A</Message>
  <Timestamp>2019-05-15T16:14:48.6560033Z</Timestamp>
  <InnerFault i:nil="true" />
  <TraceText>

[PluginProfiler.Plugins: PluginProfiler.Plugins.ProfilerPlugin]
[e4515f67-2977-e911-836c-005056aaeab8: CallMuleESB: Update of account (Profiler)]


</TraceText>
</OrganizationServiceFault>

Open in new window

0
Dynamics 365 CRM Online, version 9.1

We have an online Production database that we want to clean up before using it to refresh our Dev and Training environments.  Because of the size of the Prod database, we need to take it to another location (our server, etc) to run the clean-up process.  Exactly how do we move the Prod database to another server to clean-up?

Thanks
0
Dynamics 365 CRM Online 9.1

We are looking for a 3rd party software for multi-currency exchange rates in D365 CRM.  We would like to use the monthly average of rates for various currencies including AUD, EUR, GBP, CAD and others.  Please recommend a software that integrates with D365 CRM that will provide this without programming.

Thank you
0
CRM 2011 upgrade

We are trying to upgrade a CRM 2011 system however the IT group will not allow us to use production data in dev to test the upgrade.  Does anyone have experience working with very confidental data that cant be shown to most users?  

I have worked on some projects where we wrote an encrypt/decrypt program to make the data anonymous during the upgrade and then it was decrypted afterwards when in the new system.

Any suggestions would be helpful.
0
Hello Experts
I was recently appointed as IT Manager at one of the companies.
This company is using microsoft CRM.
The former Director of Information Technology used traditional VPN technology from Internet service providers to connect all the company's branches around the country. Which cost the company a lot of money per month.
While this VPN is only used to run that program in these branches.
What I think if I can develop or modify this system to use cloud technology or any thing else To reduce costs and also to develop the company
0
Hello Experts!

I have read a few articles on advantages and disadvantages of doing an EDI implementation on your own, and I kind of understand it a little bit. I still want to proceed on doing the EDI implementation myself and accept the challenges that it may involve, rather than going with outsourced solution.

Had anyone here implemented EDI on their own, successfully? If so, can you please direct me to some of the resources you have used and some real experience tips and tricks.

I'm kind of looking for some guide how to start this project. We are using Business Central on a SaaS environment.

Thank you in advance!
0

Microsoft Dynamics

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Top Experts In
Microsoft Dynamics
<
Monthly
>