News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) taIVTransferHeaderInse...

Microsoft Dynamics GP (Archived)

taIVTransferHeaderInsert Class - USRDEFND1 property error

(0) Share

Report

Report

Posted on by Community Member

Hi,

Does anyone one know which table does the E-connect class - taIVTransferHeaderInsert inserts to?

How do I change the data type of USRDEFND1 property since I'm getting the error below when passing a value to this property.

(Microsoft.Dynamics.GP.eConnect.eConnectException) Error converting data type char to smallint.

msdn.microsoft.com/.../ff623396.aspx

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: taIVTransferHeaderInsert Class - USRDEFND1 property error

Figured out the issue, for some reason the parameter sequence for the e-connect sproc - taIVTransferHeaderInsertPost is incorrect. That stored proc is internally called by taIVTransferHeaderInsert.

We modified the taIVTransferHeaderInsertPost stored proc so that @I_vRequesterTrx comes before @I_vUSRDEFND1.
Community Member on at

Like (0)

Report

RE: taIVTransferHeaderInsert Class - USRDEFND1 property error

Thanks for the info Waseem, can you share your sql script so I would know which table to update?
waseem 230 on at

Like (0)

Report

RE: taIVTransferHeaderInsert Class - USRDEFND1 property error

i face the same problem.

i use separate sql script out of econnect to update or insert data in userdefined fields and run it right after the econnect query in dexterity.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans