Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
AsherB 3/27/2014 11:26:59 AM

SQL - Insert into the Dynamics Item Sites table when new items are added

Recently we had a request to add lines to the Dynamics Item Sites table (IV00102) for each LOCNCODE when a new item is added to Dynamics.

We wrote two scripts, one to update all the existing items, and a trigger to catch all the item adds going forward. The article below explains all.     

4Penny.net
Version: All
Section: SQL Scripts






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables