Hi All
I need to create an integration (with Scribe Insight) for Voided checks. I trigger on insertions to CM20200 for the original check and join to PM30300 for the applied to docs.
My initial thought was to use an update trigger on CM20200 and look for void being 0 in deleted and 1 in inserted. That part seems Ok, but I need to figure out which applied payments have been reversed. After the void, payments are no longer in PM30300. (I'm not sure if they are still there when the trigger fires, but even if they are, I would prefer to join to some persistent data that exists after the void is complete, as it simplifies debugging.)
I'm assuming that there is a record somewhere of which payments the original check was applied to.
Can anyone point me in the right direction?
Regards
Mark