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.

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

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

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

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

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

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 = …

I have not found a way to process payroll in 2 currencies.  What is the best way to use payroll with multi-currency?

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

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.

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?