Update the new UDF field for the existing Payment Header records with the CC last 4 digits

Question

Hi, 
 We are working on a requirement, where we have to update the UDF field for the existing Credit Card Payment records with the last 4 digits of CC before the user clears off the CC details. I am trying to code the same in the VBScript, the Post Validate script on CC_Id compiles correctly with no issues, however, it's not executing it correctly on the fly. Any suggestions/recommendations please share. 
 Thanks/AJ

David Speck · Accepted Answer

Pre write occurs when a record is new or has been edited and still allows you to use the oBusObj.GetValue on any field that oBusObj maintains. 
 Just make sure you are targeting the correct table.

David Speck · Answer

You may need to experiment with the different events for that table and find one that works. I don't mess with CC much inside of sage 100 so i don't have a definitive answer for you but you might need to try the table's pre write event. 
 You can always try enabling debug mode and using the trace window to determine whether or not events are firing, if you don't want to bother with the trace window, then use oSession.AsObject(oSession.UI).MessageBox "", "Your message here." 
 Also make sure "Allow External Access" is checked on the Preferences tab in Company Maintenance for the target company and syntax check you scripts, any syntax errors will cause your script to fail silently.

Sage 100

Update the new UDF field for the existing Payment Header records with the CC last 4 digits

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING