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

SOLVED

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

Parents
  • 0
    SUGGESTED

    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.

Reply
  • 0
    SUGGESTED

    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.

Children