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
kdravie 7/21/2015 5:44:11 PM

Check Number and Check Date

I have a report requirement that wants me to list the Check Number, the Check Date (the Date the Check was issued), theTEN99AMNT and other stuff for a period of time.

I have a couple of questions having never done anything GP and looking at tables with cryptic names.

1. What field represent the Check Number? I would've thought PM30200.DOCNUMBR but I am seeing some weird things in there like January 2008 or Rent xxxx

2. What field represent the Check Date. Date Check was printed/Issued. PM30200 has DOCDATE, POSTEDDT, PSTGDATE that look like OK candidates for me but the user is telling me she is certain those aren't it.

Version: Unknown or N/A
Section: SQL Scripts, SSRS

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