Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
sg360 3/4/2013 1:05:28 PM

Finding Related Payments to a Voided Check

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?




Version: GP 2010
Section: Dynamics GP, eConnect, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables