DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
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