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?