stevegray
4Penny.net
Points: 55509

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
3