BenD 8/6/2013 9:15:24 AM

Need help with a trigger

Sirs: I need a GP trigger as follows:

 When a record is inserted into PM20000

  • If the document type =  Invoice and the payment priority on the vendor master (PM00100) = PWP
  • Then update HOLD on PM20000 to a 1

 Can anyone help?

Version: GP 2010, GP 10
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
3