x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 74 subscribers
  • Views 92 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
berghuismeereboerk

Table Level Scrip on Person not firing when Person added via Sage SOAP webservice

Posted By

Hi,

In our implementation of Sage - on premise 2017 R2 - we add persons via the Sage SOAP webservice. We have a TLS on person. The script works perfectly when a person is updated or inserted via the application. But it does not fire when inserted via the webservice. My question is: Should this work?

Even if we make a TLS script that just fills in ErrorStr, we don't see the message in the Log of the TLS.

Thanks in advance,

Karin Berghuis

  • 0

    Problem solved.

    Apparently the script was not correct, now it works.

    Filling ErrorStr does not result in a log record in the TLS. Logging by generating a sql stmt that is not correct works better, the message appears in the SQL Log.

    In update use Values collection for the new values and in postinsert use FindRecord to read the db record that is inserted.

*Community Hub is the new name for Sage City