ISTech Support Forum http://www.istechforum.com/YaBB.pl Crystal Reports, ODBC & Access >> ODBC General Issues >> Help with SQL Syntax to recreate SO-O-A report http://www.istechforum.com/YaBB.pl?num=1722371370 Message started by JeffH on 07/30/24 at 13:29:30

Title: Help with SQL Syntax to recreate SO-O-A report Post by JeffH on 07/30/24 at 13:29:30 I am trying to use an Excel power query to auto populate a worksheet with all the current Open Sales Orders but still having issues in getting the query correct to match the output I can see in the report. Reviewing the code that I found in http://www.istechforum.com/YaBB.pl?num=1439907533 I was able to get the Open PO interface to work...my assumption is that the query needs to access more than the just the BKARINV table and based upon the PO query it will require me to filter out BKARINV.BKAR_INV_INVCD <> 'Y' or something Does anyone have any sample SQL to recreate the SO-O-A report? Any help is appreciated?

ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved.