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

Sign Up Now!Log In
lloyduh 8/28/2014 2:24:33 PM

Get all SOP shipments for a date range.

I need a query that returns all shipments to customers for a given date range. It needs to include all usage scenarios, i.e. fulfillment orders, invoices.

Apologies for the newbie type of question. 


It looks like I can just use IV30300 for Transaction Document Types = 6.

Version: All
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