![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/2014\/yenitasarim\/header\/pazarlama.jpg\"){kind=logo} <\/td>\n<\/tr>\n | ||||||||||||||||||||||||||||||||||||||||||||
| \n De\u011ferli \u0130\u015f Ortaklar\u0131m\u0131z,<\/div>\n <\/div>\n ERP \u00fcr\u00fcnleri i\u00e7in 2.47.00.00 s\u00fcr\u00fcm\u00fc kullan\u0131ma sunulmu\u015ftur. Bu s\u00fcr\u00fcmde yap\u0131lan d\u00fczeltme ve geli\u015ftirmeler a\u015fa\u011f\u0131da yer almakta olup s\u00fcr\u00fcm dosyalar\u0131na ftp sitemizden eri\u015febilirsiniz.<\/div>\n <\/div>\n \u00d6nemli Uyar\u0131 :<\/strong><\/div>\n <\/div>\n Kurulum dosyalar\u0131nda g\u00fcncellemeler yap\u0131lm\u0131\u015f olup, kurulumdan \u00f6nce bu dok\u00fcman\u0131 incelemenizi rica ederiz.<\/div>\n Dikey \u00e7\u00f6z\u00fcmlerin tamam\u0131 kurulmad\u0131\u011f\u0131nda a\u00e7\u0131l\u0131\u015fta dikey \u00e7\u00f6z\u00fcmlerle ilgili uyar\u0131 al\u0131nabilir. Uyar\u0131 al\u0131nmamas\u0131 i\u00e7in add-ons.ini dosyas\u0131n\u0131n i\u00e7erisinde istenmeyen sat\u0131rlar\u0131n ba\u015f\u0131na – (eksi) i\u015fareti konulmal\u0131d\u0131r.<\/div>\n Program klas\u00f6r\u00fcnde bulunan add-ons.ini dosyas\u0131n\u0131n i\u00e7erisinde program a\u00e7\u0131l\u0131rken y\u00fcklenecek \u00e7\u00f6z\u00fcmler se\u00e7ilmektedir. Kullanmad\u0131\u011f\u0131n\u0131z uygulamalara ait sat\u0131rlar\u0131n ba\u015f\u0131na – (eksi) i\u015fareti koyarak program a\u00e7\u0131l\u0131\u015f\u0131n\u0131n daha k\u0131sa s\u00fcrede tamamlanmas\u0131n\u0131 sa\u011flayabilirsiniz.<\/div>\n <\/div>\n Sql 2005 ile birlikte gelen schema binding \u00f6zellikli view’lar 2.14.00 s\u00fcr\u00fcm\u00fc ile kullan\u0131ma ba\u015flanm\u0131\u015ft\u0131r.Muhasebe toplam tablolar\u0131 yerini bu view’lara b\u0131rakm\u0131\u015ft\u0131r. Bu sebeple SQL server 2000 s\u00fcr\u00fcm\u00fc kesinlikle desteklenmemektedir.<\/div>\n Muhasebe toplamlar\u0131 i\u00e7in yeni eklenen view : LV_FFF_DD_EMUHTOT<\/div>\n 2.16.00.00 s\u00fcr\u00fcm\u00fcnde baz\u0131 altyap\u0131 d\u00fczenlemeleri yap\u0131ld\u0131\u011f\u0131ndan, s\u00fcr\u00fcm\u00fc kullan\u0131ma almadan \u00f6nce verilerin yede\u011finin al\u0131nmas\u0131n\u0131 ve m\u00fc\u015fterileriniz i\u00e7in \u00f6nemli oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fcz i\u015flemleri ge\u00e7i\u015f \u00f6ncesinde test etmenizi tavsiye ederiz.<\/div>\n S\u00fcr\u00fcme ait uyar\u0131lar b\u00f6l\u00fcm\u00fcn\u00fc okuman\u0131z \u00f6nemle rica olunur.<\/div>\n Y\u00fckleme i\u015flemlerine ba\u015flamadan \u00f6nce mutlaka 3. nesil lisanslama i\u00e7in y\u00fckleme d\u00f6k\u00fcmanlar\u0131n\u0131 okuman\u0131z\u0131 \u00f6neririz.<\/div>\n <\/div>\n Genel Uyar\u0131lar:<\/strong><\/div>\n <\/div>\n \u2022 Genel Tablo Y\u00f6netimi alt\u0131ndan daha \u00f6nce olu\u015fturulmu\u015f ve kullan\u0131lan tablolar var ise g\u00fcncelle i\u015flemi yap\u0131n\u0131z. Genel Tablo Y\u00f6netimi tablolar\u0131n\u0131n g\u00fcncelleme i\u015flemini, firma g\u00fcncelleme i\u015fleminden \u00f6nce yap\u0131n\u0131z.<\/div>\n \u2022 1.7x.xx,1.8x.xx versiyonlar\u0131ndan ge\u00e7i\u015flerde \u201cTablolar\u0131 S\u00fcr\u00fcme G\u00f6re G\u00fcncelle\u201d i\u015flemi yap\u0131lmal\u0131d\u0131r.<\/div>\n \u2022 Firmaya ait d\u00f6nemler i\u00e7in Veri Taban\u0131 Ara\u00e7lar\u0131 olu\u015fturulmal\u0131d\u0131r.<\/div>\n \u2022 G\u00fcncelleme i\u015flemi istenirse b\u00fct\u00fcn firmalar i\u00e7in toplu olarak ba\u015flat\u0131labilir.<\/div>\n \u2022 Unity Objects ve OD kullan\u0131m\u0131 mevcut ise bu s\u00fcr\u00fcme uygun ara\u00e7lar update edilmelidir.<\/div>\n <\/div>\n \u2022 2.00 s\u00fcr\u00fcm\u00fc \u00f6ncesindeki s\u00fcr\u00fcmlerden ge\u00e7i\u015f yapan kullan\u0131c\u0131lar\u0131m\u0131z versiyon de\u011fi\u015fimi yapmadan \u00f6nce t\u00fcm ek paket ve kullan\u0131c\u0131 artt\u0131r\u0131mlar\u0131n\u0131 y\u00fcklemeli sonras\u0131nda versiyon de\u011fi\u015fimlerini yapmal\u0131.<\/div>\n <\/div>\n 2.04.00.00 Versiyonundan \u00d6nceki Versiyonlardan Ge\u00e7i\u015fleri \u0130\u00e7in Uyar\u0131lar :<\/div>\n Veritaban\u0131 mimarisinde de\u011fi\u015fiklik yap\u0131lm\u0131\u015ft\u0131r.Yap\u0131lan d\u00fczenlemeler do\u011frultusunda SEQ tablolar\u0131 kullan\u0131mdan kald\u0131r\u0131lm\u0131\u015f, tablolar identity \u00f6zelli\u011fine d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015ft\u00fcr. Tablolar\u0131n identity \u00f6zelli\u011fine d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi i\u015flemi Genel tablolar i\u00e7in Sistem \u0130\u015fletmenine giri\u015fte ve Genel Tablo Y\u00f6netimi G\u00fcncellenerek, Firma tablolar\u0131 i\u00e7inse firmalar \u00fczerinde tablolar\u0131n s\u00fcr\u00fcme g\u00f6re g\u00fcncellenmesi i\u015flemiyle yap\u0131lacakt\u0131r.Firma tablolar\u0131n\u0131n g\u00fcncellenmesi \u00f6nceki versiyon ge\u00e7i\u015flerine g\u00f6re biraz daha uzun s\u00fcrebilir, i\u015flemi yar\u0131da kesmeyiniz.<\/div>\n 2.04 versiyona ge\u00e7i\u015f i\u015fleminde IDENTITY g\u00fcncelleme s\u0131ras\u0131nda program haricinde eklenmi\u015f olan INDEX ler silinebilir bu y\u00fczden ge\u00e7i\u015ften \u00f6nce kullan\u0131c\u0131lar taraf\u0131ndan eklenmi\u015f olan index lerin yede\u011fi al\u0131narak ge\u00e7i\u015f sonras\u0131nda tekrar olu\u015fturulmal\u0131d\u0131r.<\/div>\n Ge\u00e7i\u015f \u00f6ncesinde, veri taban\u0131nda SCHEMABINDING kullan\u0131larak olu\u015fturulmu\u015f viewlar var ise bu viewslar silinmelidir.<\/div>\n Identity ge\u00e7i\u015finden sonra eski s\u00fcr\u00fcm programlarla Identity ge\u00e7i\u015fi yap\u0131lan veritaban\u0131na ba\u011flant\u0131 m\u00fcmk\u00fcn olmayacakt\u0131r. T\u00fcm firmalar ge\u00e7ilmese dahi ortak tablolar\u0131n yap\u0131s\u0131 de\u011fi\u015fecek ve SEQ uzant\u0131l\u0131 tablolar silinecektir. SEQ uzant\u0131l\u0131 tablolar\u0131n olmamas\u0131 eski s\u00fcr\u00fcmlerde datan\u0131n kullan\u0131lamayacak olmas\u0131 anlam\u0131na gelir.<\/div>\n <\/div>\n 2.12.00.00 Versiyonuna \u00d6zel Uyar\u0131lar :<\/strong><\/div>\n <\/div>\n \u00dcr\u00fcnlerimizde Microsoft .Net Framework 4.0 \u00f6zellikleri kullan\u0131lmaya ba\u015fland\u0131\u011f\u0131ndan hem sunucularda hem de istemci terminallerde Microsoft .Net Framework 4.0 kurulmu\u015f olmal\u0131d\u0131r. E\u011fer sunucu veya istemci bilgisayarlarda Microsoft .Net Framework 4.0 kurulu de\u011filse program\u0131 y\u00fckleme ve programa giri\u015f s\u0131ras\u0131nda uyar\u0131 al\u0131nacakt\u0131r. Microsoft .Net Framework 4.0 kurmak i\u00e7in bu ba\u011flant\u0131 kullan\u0131labilir.<\/div>\n <\/div>\n 2.12.00.00 s\u00fcr\u00fcm\u00fcyle birlikte ek paket ve ana paket kurulumlar\u0131 birle\u015ftirilip tek bir kurulum dosyas\u0131 haline getirilmi\u015ftir. Kurulum s\u0131ras\u0131nda girilen anahtar de\u011ferlendirilerek ek paket veya ana paket olmas\u0131na g\u00f6re kurulum ger\u00e7ekle\u015ftirilmektedir.<\/div>\n <\/div>\n 2.13.00.00. Versiyonuna \u00d6zel Uyar\u0131lar :<\/strong><\/div>\n <\/div>\n 2.13.00.00 s\u00fcr\u00fcm\u00fc ile birlikte \u00fcr\u00fcnlerimizin veritaban\u0131na ekledi\u011fi kay\u0131tlar bir anahtar ile \u015fifrelenmeye ba\u015flad\u0131. Bu anahtar sayesinde veritaban\u0131na \u00fcr\u00fcnlerimiz ve ara\u00e7lar\u0131m\u0131z (Logo Objects, Logo Object Designer ve XML) ile eklenen kay\u0131tlar, farkl\u0131 y\u00f6ntemler kullan\u0131larak eklenen kay\u0131tlardan ay\u0131rt edilebiliyor. D\u0131\u015f ortamdan eklendi\u011fi anla\u015f\u0131lan kay\u0131tlar i\u00e7in uygulamalar\u0131m\u0131zda bu s\u00fcr\u00fcm i\u00e7in herhangi bir engelleme yap\u0131lmam\u0131\u015ft\u0131r. Sadece kay\u0131tlar\u0131n d\u0131\u015f ortamdan geldi\u011fi ilgili kay\u0131t browser\u2019\u0131nda farkl\u0131 \u015fekilde (\u00fczeri \u00e7izili olarak) g\u00f6sterilerek ay\u0131rt edilmi\u015ftir.<\/div>\n Oracle veritaban\u0131 kullanan firmalarda bu versiyon kullan\u0131lmamal\u0131d\u0131r. Oracle veritaban\u0131 kullanan firmalar i\u00e7in ayr\u0131ca bilgilendirme yap\u0131lacakt\u0131r.<\/div>\n Logo BI Basic \u00fcr\u00fcnleri 20 Mart 2012 tarihinden itibaren ana paket ve ge\u00e7i\u015f paketleri ile birlikte bundle olarak sunulmaktad\u0131r. Uygulaman\u0131n setuplar\u0131 2.13.00.00 s\u00fcr\u00fcm\u00fc ile birlikte yeniden d\u00fczenlenerek otomatik kurulur olmas\u0131 sa\u011fland\u0131. Bundle BI Basic \u00fcr\u00fcn\u00fc hakketmi\u015f bir ana paket veya ge\u00e7i\u015f paketi kurulumu s\u0131ras\u0131nda BI Basic \u00fcr\u00fcn\u00fc de otomatik olarak kurulabilmektedir. Logo BI y\u00fckleme detaylar\u0131 i\u00e7in g\u00fcncellenen y\u00fckleme dok\u00fcman\u0131ndan (Y\u00fckleme D\u00f6k\u00fcman\u0131) yararlanabilirsiniz.<\/div>\n \u0130K programlar\u0131 ile entegrasyon kuruldu\u011fu durumlarda hem \u0130K program\u0131n\u0131n hem de ERP program\u0131n\u0131n s\u00fcr\u00fcmleri 2.13.00.00 olmal\u0131d\u0131r, s\u00fcr\u00fcm farkl\u0131l\u0131\u011f\u0131 olmamal\u0131d\u0131r.<\/div>\n 2.12.01.00 ara s\u00fcr\u00fcm i\u00e7eri\u011fine ait maddeler de hat\u0131rlatma ama\u00e7l\u0131 olarak madde listesinin sonuna eklenmi\u015ftir.<\/div>\n <\/div>\n 2.14.00.00 Versiyonuna \u00d6zel Uyar\u0131lar :<\/strong><\/div>\n <\/div>\n Sql2005 ile birlikte gelen schema binding \u00f6zellikli view’lar 2.14.00 s\u00fcr\u00fcm\u00fc ile kullan\u0131ma ba\u015flanm\u0131\u015ft\u0131r.Muhasebe toplam tablolar\u0131 yerini bu view’lara b\u0131rakm\u0131\u015ft\u0131r. Bu sebeple SQL server 2000 s\u00fcr\u00fcm\u00fc kesinlikle desteklenmemektedir.<\/div>\n Muhasebe toplamlar\u0131 i\u00e7in yeni eklenen view : LV_FFF_DD_EMUHTOT<\/div>\n <\/div>\n 2.19.00.00 versiyonuna \u00f6zel uyar\u0131lar :<\/strong><\/div>\n <\/div>\n 2.19.00 versiyonu ile bilikte Malzeme ve Hizmet toplam tablolar\u0131 View yap\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015ft\u00fcr. Yeni view’lar veri taban\u0131 g\u00fcncelleme i\u015flemi s\u0131ras\u0131nda a\u015fa\u011f\u0131daki isimler ile olu\u015fturulacakt\u0131r. Bu nedenle veri taban\u0131 g\u00fcncelleme i\u015flemi \u00f6nceki s\u00fcr\u00fcm ge\u00e7i\u015flerine g\u00f6re daha fazla zaman alacakt\u0131r. Data b\u00fcy\u00fckl\u00fcklerine g\u00f6re farkl\u0131la\u015facak veritaban\u0131 g\u00fcncelleme s\u00fcrelerinin\u00a0 tespiti i\u00e7in, g\u00fcncellemenin \u00f6ncelikle test ortam\u0131nda yap\u0131lmas\u0131 \u00f6nerilir.<\/div>\n LV_FFF_DD_SRVNUMS<\/div>\n LV_FFF_DD_SRVTOT<\/div>\n LV_FFF_DD_STINVENS<\/div>\n LV_FFF_DD_STINVTOT<\/div>\n LV_FFF_DD_VRNTINVENS<\/div>\n LV_FFF_DD_VRNTINVTOT<\/div>\n Bu versiyonla birlikte LG_ ba\u015flayan eski tablolara i\u015flem yap\u0131lmayacakt\u0131r. Bu tablolar veritaban\u0131ndan silinmeyecektir. Rapor yada form tasar\u0131mlar\u0131ndaki stok toplam tablolar\u0131ndan bilgi alan tan\u0131ml\u0131 alanlar kontrol edilerek view’lardan bilgi alacak \u015fekilde yeniden d\u00fczenlenmelidir.<\/div>\n <\/div>\n 2.25.00.00 versiyonuna \u00f6zel uyar\u0131lar :<\/strong><\/div>\n <\/div>\n 2.25.00.00 s\u00fcr\u00fcm\u00fcne ge\u00e7i\u015fle birlikte mevcut tablolara yeni kolonlar\u0131n eklenmesi gerekmektedir. Kolon eklenmesi ve kolonlar\u0131n g\u00fcncellenmesi s\u0131ras\u0131nda performans sorunu ya\u015fanmamas\u0131 i\u00e7in s\u00fcr\u00fcm g\u00fcncelleme i\u015flemi \u00f6ncesinde a\u015fa\u011f\u0131daki sorgular\u0131n \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 gerekmektedir.<\/div>\n <\/div>\n FFF : firma numaras\u0131 (001,002 gibi); DD : d\u00f6nem numaras\u0131 (01, 02, 03 gibi).<\/div>\n <\/div>\n ALTER TABLE LG_FFF_DD_CLFLINE DISABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_BNFLINE DISABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_KSLINES DISABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_EBOOKDETAILDOC DISABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_EMFLINE DISABLE TRIGGER ALL<\/div>\n <\/div>\n ALTER TABLE LG_FFF_DD_CLFLINE\u00a0 ADD “EMFLINEREF” int NULL<\/div>\n ALTER TABLE LG_FFF_DD_BNFLINE\u00a0 ADD “EMFLINEREF” int NULL<\/div>\n ALTER TABLE LG_FFF_DD_KSLINES\u00a0 ADD “EMFLINEREF” int NULL<\/div>\n ALTER TABLE LG_FFF_DD_EBOOKDETAILDOC\u00a0 ADD “EMFLINEREF” int NULL<\/div>\n ALTER TABLE LG_FFF_DD_EMFLINE\u00a0 ADD “CODEREF” int NULL<\/div>\n ALTER TABLE LG_FFF_DD_EMFLINE ADD “LINETYPE” smallint NULL<\/div>\n <\/div>\n UPDATE LG_FFF_DD_CLFLINE SET EMFLINEREF=0 WHERE EMFLINEREF IS NULL<\/div>\n UPDATE LG_FFF_DD_BNFLINE SET EMFLINEREF=0 WHERE EMFLINEREF IS NULL<\/div>\n UPDATE LG_FFF_DD_KSLINES SET EMFLINEREF=0 WHERE EMFLINEREF IS NULL<\/div>\n UPDATE LG_FFF_DD_EBOOKDETAILDOC SET EMFLINEREF=0 WHERE EMFLINEREF IS NULL<\/div>\n UPDATE LG_FFF_DD_EMFLINE SET CODEREF=0, LINETYPE=0 WHERE LINETYPE IS NULL<\/div>\n <\/div>\n ALTER TABLE LG_FFF_DD_CLFLINE ENABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_BNFLINE ENABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_KSLINES ENABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_EBOOKDETAILDOC ENABLE TRIGGER ALL<\/div>\n ALTER TABLE LG_FFF_DD_EMFLINE ENABLE TRIGGER ALL<\/div>\n <\/div>\n 2.31.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/strong><\/div>\n <\/div>\n \u00dcr\u00fcn g\u00f6rsel altyap\u0131s\u0131ndaki g\u00fcncellemelerden dolay\u0131 2.31.00.00 ve sonras\u0131ndaki s\u00fcr\u00fcmlerde Tema kullan\u0131lmamas\u0131 gerekmektedir.<\/div>\n <\/div>\n 2.34.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/div>\n <\/div>\n 2.34.00 versiyonu ile birlikte Cari Hesap toplam tablolar\u0131 View yap\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015ft\u00fcr. Yeni view’lar veri taban\u0131 g\u00fcncelleme i\u015flemi s\u0131ras\u0131nda a\u015fa\u011f\u0131daki isimler ile olu\u015fturulacakt\u0131r. Bu nedenle veri taban\u0131 g\u00fcncelleme i\u015flemi \u00f6nceki s\u00fcr\u00fcm ge\u00e7i\u015flerine g\u00f6re daha fazla zaman alabilir.<\/div>\n <\/div>\n LV_FFF_DD_CLTOTFIL<\/div>\n LV_FFF_DD_CLTOTFILV1<\/div>\n LV_FFF_DD_GNTOTCL<\/div>\n <\/div>\n Bununla birlikte; LG_FFF_DD_GNTOTCL, LG_FFF_DD_CLTOTFIL\u00a0 tablolar\u0131 art\u0131k kullan\u0131lmayacakt\u0131r. Bu tablolar veritaban\u0131ndan silinmeyecektir. Rapor ya da form tasar\u0131mlar\u0131ndaki cari hesap toplam tablolar\u0131ndan bilgi alan tan\u0131ml\u0131 alanlar (SQLINFO) ve raporlar kontrol edilerek view’lar dan bilgi alacak \u015fekilde yeniden d\u00fczenlenmelidir.<\/div>\n <\/div>\n 2.35.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :\u00a0<\/strong><\/div>\n <\/div>\n Cari hesap toplamlar\u0131n\u0131n view yap\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi ile birlikte Oracle veri taban\u0131 kullanan m\u00fc\u015fterilerimizde i\u015fyeri baz\u0131nda Cari hesap toplamlar\u0131n\u0131n d\u00fczg\u00fcn listelenebilmesi i\u00e7in versiyon de\u011fi\u015fimi sonras\u0131 cari hesap toplam servis \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.<\/div>\n <\/div>\n 2.36.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :\u00a0<\/strong><\/div>\n <\/div>\n –\u00a0 Toplu ger\u00e7ekle\u015fen \u00fcretim emri maliyet hesaplamada performans artt\u0131r\u0131m\u0131 sa\u011flamak i\u00e7in\u00a0 Tablolar\u0131 s\u00fcr\u00fcme g\u00f6re g\u00fcncelleme i\u015flemi s\u0131ras\u0131nda LG_FFF_DD_STFICHE tablosunda olan baz\u0131 kolonlar LG_FFF_DD_STLINE tablosuna yaz\u0131lmaktad\u0131r.\u00a0 Tablolar\u0131 s\u00fcr\u00fcme g\u00f6re g\u00fcncelleme s\u0131ras\u0131nda performans sorunu ya\u015famamak i\u00e7in \u00f6ncesinde;<\/div>\n <\/div>\n ALTER TABLE LG_ FFF_DD _STLINE ADD “PORDERFICHENO” varchar(17) NULL<\/div>\n ALTER TABLE LG_ FFF_DD _STLINE ADD “QPRODFCREF” int NULL<\/div>\n ALTER TABLE LG_ FFF_DD _STLINE ADD “RELTRANSFCREF” int NULL<\/div>\n <\/div>\n UPDATE<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0LG_FFF_DD_STLINE<\/div>\n SET<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0PORDERFICHENO = STFIC.PORDERFICHENO, QPRODFCREF = STFIC.QPRODFCREF, RELTRANSFCREF = STFIC.RELTRANSFCREF<\/div>\n FROM<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0LG_ FFF_DD _STLINE STRNS<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0LEFT OUTER JOIN LG_FFF_DD _STFICHE STFIC ON (STRNS.STFICHEREF\u00a0 =\u00a0 STFIC.LOGICALREF)<\/div>\n WHERE<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0STRNS.QPRODFCREF IS NULL<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0AND ((STFIC.PORDERFICHENO <> ”) OR (STFIC.QPRODFCREF > 0) OR (STFIC.RELTRANSFCREF > 0))<\/div>\n <\/div>\n UPDATE<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0LG_FFF_DD_STLINE<\/div>\n SET<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0QPRODFCREF = 0, RELTRANSFCREF = 0<\/div>\n WHERE<\/div>\n \u00a0 \u00a0 \u00a0 \u00a0QPRODFCREF IS NULL<\/div>\n <\/div>\n \u0130lgili Queryler firmada numaras\u0131na g\u00f6re \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131ktan sonra Tablolar\u0131 s\u00fcr\u00fcme g\u00f6re g\u00fcncelleme i\u015flemi yap\u0131lmal\u0131d\u0131r.<\/div>\n <\/div>\n <\/div>\n – Skonsol.exe \u00fczerinden e-Ar\u015fiv faturas\u0131 g\u00f6nderimi ve e-Ar\u015fiv Format\u0131nda yazd\u0131r\u0131labilmesi sa\u011flanm\u0131\u015f olup otomatik e-Ar\u015fiv g\u00f6nderimi yapabilmek i\u00e7in a\u015fa\u011f\u0131daki d\u00fczenlemelerin yap\u0131lmas\u0131 gerekecektir;<\/div>\n <\/div>\n \u2022 Sistem i\u015fletmeni\/Firma detaylar\u0131ndaki e-devlet tab\u0131na eklenen “e-Ar\u015fiv Entegrat\u00f6r Bilgileri” alanlar\u0131 doldurulmal\u0131d\u0131r.<\/div>\n \u2022 \u0130\u015fyeri baz\u0131nda e-Ar\u015fiv uygulamas\u0131 kullan\u0131lmas\u0131 durumunda, \u0130\u015fyeri tan\u0131m\u0131ndaki e-devlet tab\u0131na eklenen “e-Ar\u015fiv Entegrat\u00f6r Bilgileri” alanlar\u0131 doldurulmal\u0131d\u0131r.<\/div>\n \u2022 Ticari Sistem Y\u00f6netimi\/Sat\u0131\u015f ve Da\u011f\u0131t\u0131m parametrelerindeki “Otomatik Fatura Bas\u0131m\u0131:Evet” olarak se\u00e7ilmeli.<\/div>\n \u2022 Cari hesap kart\u0131nda \u201cPerakende Cari Hesap\u201d checkbox se\u00e7ene\u011fi i\u015faretli olan cari hesap kartlar\u0131 fatura i\u00e7erisinde se\u00e7ildi\u011fi durumda F9 – e-Ar\u015fiv bilgileri alan\u0131ndaki cari hesaba ait alanlar\u0131n girilmesi zorunludur.<\/div>\n <\/div>\n –\u00a0 e-Ar\u015fiv uygulamas\u0131 kapsam\u0131nda; tek seferlik sat\u0131\u015f yap\u0131lan cari hesaplar i\u00e7in e-Ar\u015fiv bilgilerinin cari hesap kart\u0131ndan de\u011fil fatura i\u00e7erisindeki e- Ar\u015fiv bilgileri alan\u0131ndan girilebilmesi sa\u011flanm\u0131\u015ft\u0131r.<\/div>\n Bunun i\u00e7in Cari Hesap Kart\u0131\u2019ndaki LogoConnect tab\u0131 alt\u0131nda bulunan e-Ar\u015fiv Bilgileri alan\u0131na \u201cPerakende Cari Hesap\u201d se\u00e7ene\u011fi eklenmi\u015f ve bu se\u00e7ene\u011fin i\u015faretli oldu\u011fu cari hesap kartlar\u0131 fatura i\u00e7erisinde se\u00e7ildi\u011fi durumda, fatura i\u00e7erisindeki F9 – e-Ar\u015fiv Bilgileri alan\u0131ndaki cari hesaba ait alanlar\u0131n girilmesi zorunlu hale getirilmi\u015f ve buradaki bilgilerin e-Ar\u015fiv uygulamas\u0131nda dikkate al\u0131nmas\u0131 sa\u011flanm\u0131\u015ft\u0131r.<\/div>\n <\/div>\n 2.37.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/strong><\/div>\n <\/div>\n Firma \u00fczerinde “Tablolar\u0131 S\u00fcr\u00fcme G\u00f6re G\u00fcncelle” i\u015flemi yap\u0131ld\u0131\u011f\u0131nda; Procedure, Trigger, view ve viewlara ait indexler i\u00e7in “Veritaban\u0131 ara\u00e7lar\u0131n\u0131 olu\u015fturulacakt\u0131r” mesaj\u0131 gelmektedir. Vazge\u00e7 i\u015flemi yap\u0131ld\u0131\u011f\u0131 zaman Procedure, Trigger , view ve viewlara ait indexler olu\u015fturulmamaktad\u0131r. Bir versiyon \u00f6ncesinden ge\u00e7i\u015f yap\u0131l\u0131yorsa performans sorunu ya\u015famamak i\u00e7in “Vazge\u00e7” ile ge\u00e7ilmelidir.<\/div>\n Tablolar\u0131 s\u00fcr\u00fcme g\u00f6re g\u00fcncelleme sonras\u0131nda Procedure, Trigger ve Viewlar\u0131n olu\u015fmas\u0131 isteniyorsa D\u00f6nem \u00fczerinde “Veritaban\u0131 Ara\u00e7lar\u0131n\u0131 Olu\u015ftur” i\u015flemi yap\u0131labilir<\/div>\n <\/div>\n 2.39.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/strong><\/div>\n <\/div>\n EBOOKDETAILDOC Tablosunda m\u00fckerrer e-Defter belge detay\u0131n\u0131n uygulama d\u0131\u015f\u0131ndan aktar\u0131m\u0131n\u0131n engellenmesi i\u00e7in Firma \u00fczerinde “Tablolar\u0131 S\u00fcr\u00fcme G\u00f6re G\u00fcncelle” i\u015flemi yap\u0131ld\u0131\u011f\u0131nda; EBOOKDETAILDOC tablosunda IXXX_XX_EBOOKDETAILDOC_I5 index’i eklenecektir.<\/div>\n EBOOKDETAILDOC\u00a0 Tablosunda m\u00fckerrer kay\u0131t olmas\u0131 durumunda index eklenemeyece\u011finden firma g\u00fcncelleme \u00f6ncesi a\u015fa\u011f\u0131daki sorgu \u00e7al\u0131\u015ft\u0131r\u0131larak m\u00fckerrer kay\u0131tlar EBOOKDETAILDOC\u00a0 tablosundan kald\u0131r\u0131lmal\u0131d\u0131r.<\/div>\n <\/div>\n DELETE LG_FFF_DD_EBOOKDETAILDOC WHERE LOGICALREF IN (<\/div>\n SELECT TMP.LOGICALREF FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY EMFICHEREF ORDER BY LOGICALREF ASC) AS ‘Row’,<\/div>\n EMFICHEREF,LOGICALREF FROM LG_FFF_DD_EBOOKDETAILDOC WHERE EMFLINEREF=0 AND EMFICHEREF IN<\/div>\n (SELECT EMFICHEREF FROM LG_FFF_DD_EBOOKDETAILDOC WHERE EMFLINEREF=0 GROUP BY EMFICHEREF HAVING\u00a0 COUNT(EMFICHEREF)>1)<\/div>\n GROUP BY EMFICHEREF,LOGICALREF ) TMP<\/div>\n WHERE TMP.Row<>1<\/div>\n <\/div>\n 2.42.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/strong><\/div>\n <\/div>\n 2.42.00 s\u00fcr\u00fcm\u00fcm\u00fcz ile birlikte \u00fcr\u00fcn kurulum i\u015flemi s\u0131ras\u0131nda server minimum donan\u0131m gereksinimlerini (Konfigurasyonunu) kontrol eden mekanizma geli\u015ftirilmi\u015ftir.<\/div>\n Geli\u015ftirilen bu mekan\u0131zma ile birlikte \u00fcr\u00fcn kurulumu s\u0131ras\u0131nda y\u00fckleme yap\u0131lan server i\u00e7in sistem ihtiya\u00e7lar\u0131 dok\u00fcmanlar\u0131m\u0131zda da belirtti\u011fimiz minimum donan\u0131m gereksinimlerinin sa\u011flan\u0131p sa\u011flanmad\u0131\u011f\u0131 kontrol edilmekte ve bilgi ama\u00e7l\u0131 uyar\u0131 verilmektedir.<\/div>\n <\/div>\n 2.44.00.00 \/ 2.45.00.00 s\u00fcr\u00fcm\u00fcne \u00f6zel uyar\u0131 :<\/strong><\/div>\n <\/div>\n 2.44.00 s\u00fcr\u00fcm \u00f6ncesi eklenen cari hesap kartlar\u0131nda ISPERCURR alan\u0131 NULL olmas\u0131 durumunda ilgili cari hesaba ait e-ar\u015fiv faturalar\u0131n Form Bs’de listelenmeme sorunu ortaya \u00e7\u0131kmaktad\u0131r.\u00a0 \u00c7\u00f6z\u00fcm i\u00e7in; NULL olan bu kay\u0131tlar\u0131n ‘0’ s\u0131f\u0131r olarak g\u00fcncellenmesi gerekir. Bu i\u015flem i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek sorgu kullan\u0131labilir.<\/div>\n <\/div>\n UPDATE LG_500_CLCARD SET ISPERCURR=0 WHERE ISPERCURR IS NULL<\/div>\n <\/div>\n ERP 16 Ekim 2017 S\u00fcr\u00fcm\u00fc :<\/strong><\/div>\n <\/div>\n
|
![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/go3_2016.png\"){kind=logo}
![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/10-05-2016%2013-33-38.png\"){kind=logo}
![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/tiger3(2).png\"){kind=logo}
![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/TigerEnterprise3(1).png\"){kind=logo}
![](\"http:\/\/cmc.logo.com.tr\/images\/uploads\/images\/tiger-enterprise-3.png\"){kind=logo}
<\/p>\n![\"\"](\"https:\/\/jira.logo.com.tr\/images\/border\/spacer.gif\"){kind=spacer}
![\"\"](\"https:\/\/jira.logo.com.tr\/images\/icons\/link_out_bot.gif\"){kind=logo}
Ana Kay\u0131tlar – Malzemeler<\/td>\n<\/tr>\n