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. 

Thanks.

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
3