select 
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 
(OKCFC1 like 'B1%' or OKCFC1 like 'C1%' or OKCFC1 like 'E1%' or OKCFC1 like 'S1%' or OKCFC1 like 'N/E1%' or OKCFC1 like 'N1%')
and fs.ESIVDT NOT LIKE ('2014%')
-- and fs.ESIVTP <> 'DR'
group by fs.ESCINO,fs.ESIVDT,fs.ESDUDT,fs.ESPYNO,cu.OKCFC1
HAVING sum(fs.ESCUAM)<>0  
ORDER BY fs.ESCINO   
<HR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [2447]