jwall , I believe you are using the right columns. To confirm, run the original SalesMaster (AE-SQL) report first. If you still see Line Cost >0 for the price adjustment CN, reopen that credit note from OE and double check if it is indeed using price adjustment type. The Line Cost in the SalesMaster report comes from table OESHDT column SCSTSALES. OE assigns zero to that field if the credit note is indeed for price adjustment only. In short the issue may not be the report but the type of credit note used.