Fixing a Double AP Void Invoice

From KeystoneIntranet
Revision as of 00:01, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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)
Retrieved from "http://in.compucrete.com/index.php?title=Fixing_a_Double_AP_Void_Invoice&oldid=205"