SOP table 1

[hungtran817]

I'm creating a report that shows all orders for a particular day but can't get the correct data.
I'm looking for a table that contains both SOP live and history. I've tried using SOP10100 and SOP30200 but had no success. Is there a table that has this or what other tables do I need to join to achieve this?

Thanks,
Hung

GP9

 

[VictoriaYudin]

You're not going to get one table that contains both 'live' (open/unposted) and history in SOP because GP does not store SOP transactions that way. For that matter, unless you're looking for header information only, you would need multiple tables even within the same 'type' of transaction.

All that said, here is code for a SQL view that returns all SOP transactions:

http://victoriayudin.com/2009/05/17/sql-view-with-all-sop-line-items/.

You could create this view in SQL, then restrict on dates or whatever other criteria you need for your report.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[hungtran817]

It works , thanks. My other options was inserting a subreport.