Sage 100

UPDATE:  I just figured out that even thought scripts are attached to the AIA Item file, they're actually triggering during billing data entry.  I'm hitting the pause button on this, so hopefully I didn't waste anyone's time yet.  

Hopefully an easy question for someone.  I'm trying to create a simple script in a MD table for Job Cost.  Champ Systems wrote an enhancement for AIA billing for Job Cost that our customer purchased.  There is a table called J/C AIA Item File (JC_008AIAItem) that seems like it's accessible in the Script Editor window.  But nothing seems to work...almost like Allow External Access is disabled.  The AIA Item screen is accessed from a button on the Job Maintenance screen, but I don't know if that's considered the actual oHeaderObj for the AIA Lines business object.  So far I'm just trying to trigger a simple message box to see if scripting even works.  

Any ideas?  Thanks in advance!



------------------------------
Rob Neal
------------------------------

No experience or access to those tables but instead of column level events, the the table post-read and table re-write events instead. Early on I found that column level events don't always fire when you'd expect them to whereas the table post-read and pre-write do.
Make sure you syntax check the script too, any errors will cause the script to not execute and there will be no indicating of this, it just fails "silently".

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Thanks @David Speck II!  I'll keep you posted.​

------------------------------
Rob Neal
------------------------------

Original Message:
Sent: 06-06-2020 00:29
From: David Speck II
Subject: Script against MD Job Cost Tables

No experience or access to those tables but instead of column level events, the the table post-read and table re-write events instead. Early on I found that column level events don't always fire when you'd expect them to whereas the table post-read and pre-write do.
Make sure you syntax check the script too, any errors will cause the script to not execute and there will be no indicating of this, it just fails "silently".

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------