Fixing a Double AP Void Invoice

Problem

A single AP Invoice gets voided twice.

Solution

Identify and delete the Session No and Trans No of 1 of the 2 invoices in the following tables:

• APTINVHD
• APTINVDT (Session/Trans no=APTINVHD)
• APTCHKDT (AP_SESSION_NO/AP_TRANS_NO = APTINVHD SESSSION_NO/TRANS_NO)
• GLTTRX (SOURCE_SESSION_NO/SOURCE_TRANS_NO = APTINVHD SESSSION_NO/TRANS_NO)
• CMTTRX (SESSION_NO/TRANS_NO = APTCHKDT SESSION_NO/TRANS_NO)