select 
fs.ESCONO as inc_cono,
fs.ESCINO as INV_NO,
fs.ESIVDT as INV_DATE,
fs.ESDUDT as DUE_DATE,
sum(fs.ESCUAM) as TOT_AMOUNT,
fs.ESPYNO as CUS_NO,
cu.OKCFC1 as CUS_AREA
from MVXJDTA.FSLEDG as fs 
INNER JOIN MVXJDTA.OCUSMA as cu ON fs.ESPYNO=cu.OKCUNO
where 
(ESRECO in('0','8')) and (ESPYRS<>'90') and (ESTRCD in('10','20')) 
and fs.ESIVDT NOT LIKE ('2014%')
and fs.ESCINO NOT LIKE ('17%')
AND cu.OKCONO = '410'
AND fs.ESCONO = '410'
AND OKSTAT = '20' AND OKCUCL IN ('102','104') AND OKCUNO NOT LIKE 'R0%'
AND convert(float, fs. ESCINO COLLATE Latin1_General_BIN) not in   (SELECT INVO FROM [DATA_OMS].[dbo].INVOICE_ERROR)
-- and fs.ESIVTP <> 'DR'
group by fs.ESCINO,fs.ESIVDT,fs.ESDUDT,fs.ESPYNO,cu.OKCFC1,fs.ESCONO,cu.OKCONO
HAVING sum(fs.ESCUAM)<>0  
ORDER BY fs.ESCINO   
<HR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [5009]