'kupci
  sql = sql & " append (( shape {select skl, ident, stevdok, pozicija,kolicina from narpromet where sifradok='KUP'and status<>'S'}"
  sql = sql & "        APPEND ({SELECT STEVNAR AS STEVNAR,POZNAR AS POZNAR, DATUMDOK,STEVDOK, KOLICINA "
  sql = sql & " FROM PROMET where (left(sifradok,1)='B' or sifradok='IZD') and status<>'S' }  RELATE STEVDOK TO STEVNAR,POZICIJA TO POZNAR) AS RSizd,"
  sql = sql & " sum(rsizd.kolicina) as izdkol, "
  sql = sql & " calc( iif(kolicina>iif(isnull(izdkol),0,izdkol),kolicina-iif(isnull(izdkol),0,izdkol))) as okol) "
  sql = sql & " relate skl to skl, ident to ident) as rsnar, sum(rsnar.kolicina) as narkol, sum(rsnar.izdkol) as izdkol, "
  'dobavitelji
  sql = sql & "  (( shape {select skl, ident, stevdok, pozicija,kolicina from narpromet where sifradok='DOB'and status<>'S'}"
  sql = sql & "        APPEND ({SELECT STEVNAR AS STEVNAR,POZNAR AS POZNAR, DATUMDOK,STEVDOK, KOLICINA "
  sql = sql & " FROM PROMET where sifradok='DOB'  and status<>'S' }  RELATE STEVDOK TO STEVNAR,POZICIJA TO POZNAR) AS RSdob,"
  sql = sql & " sum(rsdob.kolicina) as dobkol, "
  sql = sql & " calc( iif(kolicina>iif(isnull(dobkol),0,dobkol),kolicina-iif(isnull(dobkol),0,dobkol))) as odobkol) "
  sql = sql & " relate skl to skl, ident to ident) as rsnardob,  "
  
  sql = sql & " sum(rsnar.okol) as onarocila,sum(rsnardob.odobkol) as dobonarocila "