I HAVE AN ERP SYSTEM AND I WANT TO WRITE A SCRIPT FOR POSTING DATA, THIS ERP NATURE WORKS AS FOLOW WHEN I WRITE JOURNAL VOUCHER AND SAVE IT AND AFTER THAT IF I WANT IT TO BE APPROVED I PRESS A MENU BOTTON TO APPROVE IT AND AUTOMATICALLY THIS JOURNAL VOUCHER POSTED TO THE FINANCE MODULE AND DISAPPEAR FROM THE JOURNAL VOUCHER SCREEN AND YOU CAN SEE IT APPROVED IN ANOTHER SCREEN, WHAT I WANT IS,HOW CAN I WRITE THIS SCRIPT(POSTING DATA FROM TABLE TO TABLES)ALTHOUGH I DONT KNOW WHAT THE AFFECTED TABLES BY APPROVING THIS VOUCHER I, IN SMALL WORDS I DONT KNOW WHAT CAN I USE FOR THE CONDITION FOR POSTING IN THE SQL STATMENT(INSERT ON A TRIGGER BASED ON UPDATE)….. ANY ONE PLEASE GIVES ME HOW TO KNOW THE AFFECTED TABLES WHEN POSTING, AND THE GENERAL STATMENT TO DO POSTING….
BEST REGARDS
THANX
SASA