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

Hi:

Is there anywhere online from where I can obtain learning exercises for Microsoft Dynamics Business Central or the latest version of NAV?  

I'd like some practice, in order to better understand the functionality.

Thank you!

Software Engineer
0
Hi:

A Microsoft Dynamics GP 2016 end user is on Outlook 2016.  When she e-mails sales invoices in PDF to customers from GP, the file name of the PDF is a long "drawn out" name beginning with the following path: c:\username\appdate\local.

She said that, prior to about a year ago, the file name was much shorted and simply composed of "obvious data" such as the invoice number.  She does not know if a recent upgrade or anything along those lines could have caused this change.

Is there a way of setting the format of the e-mailed file name of the PDF, or will this situation require say an upgrade to Office 365?

Thank you!

Software Engineer
0
i have no idea what i am doing here... short story - our phone system is capable of integrating with our CRM but it isn't working. i believe the problem is that the phone number of the incoming caller is being passed from the phone system to the crm without any hyphens in the string but all the phone numbers stored in the crm have hyphens in them and the match never takes place. i have confirmed this by hard coding a phone number into the xml "xsi" template stored on the phone server that facilitates the query of the crm - when i do this, it finds a match and everything is happy.

so, my question is - is there a way in the xml file to "transform" the string being passed from the phone system and add a hyphen to it? i have almost no experience with xml.

it seems the value in the xml file is called Number and is used like this: $filter=contains(telephone1,'[Number]')

i would love to create a variable that i could use instead of Number and put a hyphen in it and just use that everywhere instead of '[Number]'.

am i making any sense? many thanks in advance.
0
Hi All:

Does anyone know of any online tutorials or books that offer the quickest and most effective way of learning Microsoft Dynamics 365 Business Central?

Thank you!

Software Engineer
0
Hello:

In using the eConnect tool to import purchasing receipts for Microsoft Dynamics GP, I'm getting the following error on the Line Item node (taPopRcptLineItemInsert):

Decimal Places Passed in on Unit Cost Does Not Match Setup.

This error makes absolutely, positively, without a shadow of a doubt no flippin’ sense whatsoever.

True, the decimal placement of the Unit Cost field of some of the records in the database goes beyond 2.  But, for a similar import for purchase orders, I eliminated the error by using the following calculation for the Unit Cost field:

return fn.ROUND (UNITCOST, 2 ).

But, for the receivings map and for a record whose Unit Cost is 6.72, it is throwing this error – whether I use this calculation or not.  And, I have tried resolving this a million ways to Sunday.

Here’s what I don’t get.  The Unit Cost, in this example, actually does not go beyond 2 decimal places.  It is, simply, a figure of 6.72.  And, the GP Purchase Order Processing Setup window is set to 2 for Currency Decimal placement of noninventoried items.

Any ideas?

Thank you!

Software Engineer
0
Hi:

In the Microsoft Dynamics GP Credit Card Setup window, is there a way of tying a credit card to more than one G/L account?

An end user has three separate Cash accounts in the chart of accounts but does not want to create a separate Visa credit card for each account.  She wants the one Visa credit card - not three.

Thanks!

Software Engineer
0
Hi:

As of two months ago, a Microsoft Dynamics GP 2013 end user has experienced slow payables posting.  She is not aware of any changes, from two months ago.

She uses Citrix with local modified reports dictionaries located on the Citrix box.  The PJOURNAL job is running and is successfully removing these from the companies.  They reboot the SQL box, every night.  She is not the only user experiencing this issue and it is occurring in all companies.

Is there a "silver bullet" that will allow for speeding up the posting?

Thanks!

Software Engineer
0
Hi:

A Microsoft Dynamics GP 2018 end user showed me where the "Remit To" Address ID in a posted payables invoice is not showing the same Remit To ID as what is showing in Vendor Maintenance.

She says that she does not know of anyone making any changes to the invoice once entered in Payables Transaction Entry or in the Edit Payables Transaction window after entry.

Are there any other ways where the incorrect Remit To Address ID could have been derived?

Thanks!

Software Engineer
0
I have Microsoft CRM 2011 installed  & one user intermittently gets this message when he tries to create or open a quote (see attached).  I am wondering if someone can help us with this.
dec12capture.PNG
0
Hi:

For Microsoft Dynamics GP, has anyone ever found a definitive solution to the following error:

a get/change operation on table 'Batch_Headers' failed. A record was already locked

Thanks!

John
0
Hello:

This client used Microsoft Dynamics GP's Professional Services Tools Library to combine accounts.  Afterward, the client rebuilt the Data Mart.

Now, only unposted transactions are appearing.  On reports where both posted and unposted data to to show per the Report Definition, only posted data shows.

And, when the trial balance is run, the top of the page says that this report contains no data.

We ran Financial Reconcile in GP and ran Refresh Cached Data in MR but to no effect.

The really interesting thing is that Management Reporter was showing data earlier today, even after the accounts were combined.

Any ideas?

Thanks!

John
0
I'm trying to extract from AX the above data, does anyone know which tables I need to use and how to link. I do not have access to the AX client only the SQL database.

I'm being told to use CUSTTABLE, EMPLTABLE AND DIREPARTY table but I cannot work out how to link these.

Can anyone help?
0
Hi:

In Microsoft Dynamics GP 2018, upon copying the URL from the GP's Publish OData window, the end user gets the http 404 error.  

After trying every troubleshooting document out there in cyberspace, no joy.

Any ideas?

Thanks!

John
0
Dear Experts
We have implemented CRM application( web based ).  our customer will login to this and this application for reports and analytics. our customer is in a different country hence they want the news/update on certain products that is in our country, they have asked to provide the solution for them. Our CRM developer says he can integrate certain news channels so that customer can login to CRM and see the news updates, As an IT security point of view I have asked which all websites but he is not sure at the moment which all websites will have to integrate ,
1.      I have informed them we may have to look for different solution instead of CRM application for this until technical approach or detailed tech specs are shared with me. However would like understand is it a right way, is the CRM application using for this is it as right tool
2.       instead should we have to develop a portal and store all the details and share the portal to them.
3.      As CRM has sensitive data integration with new sites will it be recommended , when it comes to integration please suggest the measures to be taken
4.      What solution we need to go for news capturing and store it and share it with customer please suggest .
please help with above , thanks in adance.
0
I have written a page that posts data for a client into the above, It works as part of a new website as the only page (used for testing) when I copy the code or paste the page into the web application I have been developing it for I get an error, I've used Nuget to ensure all the correct dll's are added.

This is the error

"An existing connection was forcibly closed by the remote host
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host"

This line is causing the error:
Dim myresponse As HttpResponseMessage = client.SendAsync(myrequest).Result


Can anyone suggest a solution or reason why the same code fails in one web application but not the other?

Here is the code

Imports System.Net.Http
Imports System.Net.Http.Headers
Imports System.Threading.Tasks
Imports Microsoft.IdentityModel.Clients.ActiveDirectory
Imports Newtonsoft.Json.Linq
Imports System.Collections.Generic
Public Class CRM_Contact
    Inherits System.Web.UI.Page

    Public myclientId As String = Convert.ToString(ConfigurationManager.AppSettings("clientid"))
    Public redirectUrl As String = Convert.ToString(ConfigurationManager.AppSettings("redirecturl"))
    Public serviceUrl As String = …
0
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
I have not found a way to process payroll in 2 currencies.  What is the best way to use payroll with multi-currency?
0
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
I am trying to build a query for Great Plains Dynamics but am running into some issues and cannot figure out why--I think it may be due to the JOIN commands I am using. When I do a search for a record for which I now there is only one I end up with 100's and 100's of query results, or errors so not sure what I am doing wrong. Here are the tables I need info from
SOP10100 is the Shipping Address Table
SOP10106 is the Shipping Details Table
SYO1200 is the email table
RM00102      MAIN Customer Info and ADDRESS Table

SOP10106 tied to SOP10100 by SOPNUMBE
SOP10100 tied to RM00102 by CUSTNMBR
RM00102 tied to SYO1200 by ADRSCODE

This is the script I generated using the SQL Server Enterprise Manager graphical "query" feature. This script does not generate any errors when I run it in SQL Enterprise Manager -- I know there is only one record that meets the criteria and yet it show more than 100 results. But when using SQL Query Analyzer I get these errors
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SOP10106'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SOP10100'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'RM00102'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SY01200'.

Here is the script generated and used
SELECT SOP10106.SOPNUMBE, SOP10100.SOPNUMBE AS SOPNum, RM00102.CUSTNMBR, RM00102.ADRSCODE, SY01200.ADRSCODE AS ADRCOD, SOP10100.CUSTNMBR AS CSTMRNO

FROM SOP10106 INNER JOIN …
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

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
>