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
MEDAVIE1 1/16/2019 8:48:27 AM

VOIDDATE Field in GP Tables doesn't match with VOIDDATE labels on Receivables Screens

I have a question regarding void date in the RM20101 (Open Transactions) Table.

When I go into GP, from "Posted Transactions", select my customer and payment, (Which brings me to the "Receivables Posted Transactions Maintenance" screen, I fill in the field "Void Date" with "January 1st, 2019", and I put "January 3rd, 2019", in the "Posting Date" field.  I then click Void.

Now, when I query the RM20101 Table for that document number, I see the "January 3rd, 2019" appearing in the "VOIDDATE" field.   And the date I entered as the void date, "January 1st, 2019" seems to be appearing in the "DINVPDOF" (Date invoice paid off field).

To make it even stranger, if go into Inquiry -> Transaction By Document, and drill down to my document, there is a field on there called "Date Voided", and it's also showing the proper date of "January 1st, 2019"  

Can anyone explain why this is behaving this way?  Why do the fields on the GP screens have a label of "VOIDDATE", but GP isn't actually storing the value in that "VOIDDATE" field in the table?


Version: GP 2015
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