Qnect 200 and table scripts

Question

I need to implement some business rules when sales orders are saved in CRM, including orders synchronised from Sage 200 using Qnect 200. 
 Has anyone managed to get table scripts to work when orders are inserted from Qnect? Qmulus tech support says "Sage CRM should run its table scripts when records are created/updated by the sync", but my test TLS doesn't seem to run when an order is inserted by Qnect (it does run when an order is inserted by CRM).

John Kingsbury · Accepted Answer

orde_description is updated by the sync after the order is inserted, so "Set from TS Insert" will be overwritten with the new value which will run the UpdateRecord func. So: 1. Sync inserts order 2. InsertRecord, PostInsertRecord runs 3. Sync immediately updates CRM order with some extra details (description, status, opened) to work around the fact that CRM does not allow these to be set in insert for some reason. 4. UpdateRecord runs.

Sage CRM

Qnect 200 and table scripts

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING