7/7/2025 3:30:39 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Copy Opportunity off an SQL trigger
Posted: 30 Jun 10 5:14 PM
|
i have a customer on SLX 7.2.2 that needs me to update the cost and adj price in products and opportunity products when a cost or price change in MAS500. I am using ERP link but that will not update the opportunity products and is a bit slow. Here is the kicker, they want to copy the original opportunity to a status of history before the cost/price change and it has to be as close to real time as possible. Should I create a VB script using standard SLX conventions and attempt to run using cscript on the 2005 SQL server? Has anybody attempted such a thing? Or
Should I simply write a multiple step DTS to create the copy, update the prices using the Sitekeys table to get my next id number for my copy of the opportunity.
thanks much in advance for your advice |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|