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

DynDeveloper.com

Sign Up Now!Log In
sgray128 6/6/2018 10:43:51 AM

Add a line to AAG00401 for each SOP Transaction entered

Received a requirement today from a client that adds an AA Dimension for each SOP transaction entered. The requirement was to automatically insert it when a SOP document is keyed. The code below is the result of that work.

In doing the work, we also discovered that we needed to add a line to AAG00602 at the same time, in order to populate the 'linked to node' field (see below)

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