Pat Clarke
Member
I need to Purge AP records from F0411 based on
however I also need to purge associated F0413 & F0414 records where the GL date <= {variable date} and there is no open amounts. Has anyone done this before and if so could you please supply the SQL statement required to achieve this purge without compromising the integrity of AP?
RPDGJ<={variable date} and
RPPOST='D' and
RPPST='P' and
RPAAP=0
however I also need to purge associated F0413 & F0414 records where the GL date <= {variable date} and there is no open amounts. Has anyone done this before and if so could you please supply the SQL statement required to achieve this purge without compromising the integrity of AP?