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
paulchacko 8/30/2017 11:52:03 AM

PO Number in Receivings Transactions SmartList

Hi everyone,

There is a report in GP SmartList under Purchasing [Receivings Transactions] based on the SQL View called 'ReceivingsTransactions'

What I am trying to do is add the PONUMBER field to this report by editing the view. However, the POP10300 does not seem to have a PONUMBER field in there. I could connect POP10310 but then I get multiple lines for the same receipt.

Any thoughts as to how I can accomplish this task?


Paul Chacko

[Note: I fail to understand why PONUMBER is not in the Receiving Header but on the Line Items table - annoyed!]

Version: GP 2013
Section: Dynamics GP, SQL Scripts

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