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)


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?

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

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?

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

Thank u!

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

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

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.

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

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

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

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>

Select all Open in new window

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

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