x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 10 replies
  • Subscribers 76 subscribers
  • Views 3199 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Steve Parker

An error has occurred in a CRM .net customisation. Please contact your vendor to resolve.

Posted By

On Sage 300 2019 PU1 and Sage CRM 2018 R3.

Within the Sage 300 Administration it allows me to Synchronise Tables and completes that without an error. However, when trying to import customers I get

"An error has occurred in a CRM .net customisation. Please contact your vendor to resolve"

If I try to "Promote to Sage 300", when I have entered a Customer Number that doesn't currently exist and then click Promote to Customer, the screen eventually appears with the Sage 300 Customer web screen, but the customer information then has to be manually put in and then saved.

I am using the Admin user with full rights, and I have allowed Admin WebAPI access. Updating customer information also works going from Sage 300 to CRM.

Any ideas would be appreciated.

Thanks in advance

Parents
  • 0

    Apologies for the delay, here is the ewaresql.log

    Mar 20 2019 15:29:51.896 4200 4232 1 fqopen,time,sql,errormsg 125 SELECT Capt_UK FROM Custom_Captions WHERE Capt_Family='pers_salutation' AND Capt_deleted IS NULL AND UPPER(Capt_UK) = 'ADRIAN'

    Argument data type ntext is invalid for argument 1 of upper function

    Mar 20 2019 15:29:58.221 4200 4232 1 fqopen,time,sql,errormsg 78 SELECT Capt_US FROM Custom_Captions WHERE Capt_Family='pers_salutation' AND Capt_deleted IS NULL AND UPPER(Capt_US) = 'ADRIAN'

    Argument data type ntext is invalid for argument 1 of upper function

Reply
  • 0

    Apologies for the delay, here is the ewaresql.log

    Mar 20 2019 15:29:51.896 4200 4232 1 fqopen,time,sql,errormsg 125 SELECT Capt_UK FROM Custom_Captions WHERE Capt_Family='pers_salutation' AND Capt_deleted IS NULL AND UPPER(Capt_UK) = 'ADRIAN'

    Argument data type ntext is invalid for argument 1 of upper function

    Mar 20 2019 15:29:58.221 4200 4232 1 fqopen,time,sql,errormsg 78 SELECT Capt_US FROM Custom_Captions WHERE Capt_Family='pers_salutation' AND Capt_deleted IS NULL AND UPPER(Capt_US) = 'ADRIAN'

    Argument data type ntext is invalid for argument 1 of upper function

Children
No Data

*Community Hub is the new name for Sage City