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
mark4yesu 12/12/2017 2:01:51 PM

Moving doc from AP History to AP Open


We have a situation at a client where an AP Payment was voided (in history).  the Payment was marked as voided, BUT the Invoice stayed in History with the apply information intact.

I am thinking of deleting the historically info, but need to know the best way to move the Invoice from History to Open (including distributions and all other tables).  Don't I also need to update the PM00400 table?  

If anyone has a script, I'd love to use it!



Version: GP 2015, GP 2013, GP 2010, GP 10
Section: Dynamics GP

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