{"id":2419,"date":"2017-09-29T11:21:11","date_gmt":"2017-09-29T08:21:11","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=2419"},"modified":"2017-09-29T11:21:57","modified_gmt":"2017-09-29T08:21:57","slug":"logo-2-46-gecis-sonrasi-ihracat-sorunu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-2-46-gecis-sonrasi-ihracat-sorunu\/","title":{"rendered":"Logo 2.46 Ge\u00e7i\u015f Sonras\u0131 ihracat Sorunu"},"content":{"rendered":"<p>Eski versiyondan 2.46 setine ge\u00e7i\u015f sonras\u0131 e fatura olarak g\u00f6nderimi yap\u0131lan ihracat operasyon fi\u015flerinde ihracat bilgileri de\u011fi\u015ftirilmek istendi\u011finde al\u0131nan <span style=\"color: #ff0000;\"><strong>GTIP kodu girilmelidir veya Ambalaj Kodu girilmelidir<\/strong> <\/span>uyar\u0131s\u0131 i\u00e7in a\u015fa\u011f\u0131daki sorgular ile d\u00fczeltme yap\u0131labilir.<\/p>\n<p><span style=\"color: #ff0000;\">Not: Sorgu \u00e7al\u0131\u015ft\u0131r\u0131lmadan \u00f6nce data yede\u011fi al\u0131nmal\u0131 ve sorgu i\u00e7erisindeki firma ve d\u00f6nem bilgileri g\u00fcncellenmelidir.<\/span><\/p>\n<p><strong><span style=\"color: #000080;\">&#8211;\u0130hracat operasyon fi\u015fi sat\u0131r\u0131ndaki <span style=\"color: #ff0000;\">ambalaj kodu bo\u015f<\/span> olan sat\u0131rlar\u0131n detaylardaki ambalaj koduna g\u00f6re update olmas\u0131n\u0131 sa\u011flayan sorgu;<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>UPDATE\u00a0LG_XXX_XX_INVEXIMLINES<\/p>\n<p>SET\u00a0 PCKCODESREF=INFO.PCKCODESREF<\/p>\n<p>FROM<\/p>\n<p>LG_XXX_XX_INVEXIMLINES EXL,\u00a0LG_XXX_XX_INVEXIMINFO INFO<\/p>\n<p>WHERE<\/p>\n<p>EXL.INVOICEREF=INFO.INVOICEREF<\/p>\n<p>AND\u00a0ISNULL(EXL.PCKCODESREF,&#8221;)\u00a0=\u00a0&#8221;<\/p>\n<p>AND\u00a0ISNULL(INFO.PCKCODESREF,&#8221;\u00a0)\u00a0&lt;&gt;\u00a0&#8221;<\/p>\n<p><span style=\"color: #000080;\"><strong>&#8211;\u0130hracat operasyon fi\u015fi sat\u0131r\u0131ndaki<span style=\"color: #ff0000;\"> GTIP kodu bo\u015f olan sat\u0131rlar\u0131n<\/span> detaylardaki GTIP koduna g\u00f6re update olmas\u0131n\u0131 sa\u011flayan sorgu;<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>UPDATE<\/p>\n<p>LG_XXX_XX_INVEXIMLINES<\/p>\n<p>SET<\/p>\n<p>GTIPCODE=I.GTIPCODE<\/p>\n<p>FROM<\/p>\n<p>LG_XXX_XX_INVEXIMLINES EXL,\u00a0LG_XXX_XX_STLINE SL,\u00a0LG_XXX_ITEMS I<\/p>\n<p>WHERE<\/p>\n<p>SL.STOCKREF=I.LOGICALREF<\/p>\n<p>AND\u00a0EXL.STTRANSREF=SL.LOGICALREF<\/p>\n<p>AND\u00a0ISNULL(EXL.GTIPCODE,&#8221;)\u00a0=\u00a0&#8221;<\/p>\n<p>AND\u00a0ISNULL(I.GTIPCODE,&#8221;\u00a0)\u00a0&lt;&gt;\u00a0&#8221;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Eski versiyondan 2.46 setine ge\u00e7i\u015f sonras\u0131 e fatura olarak g\u00f6nderimi yap\u0131lan ihracat operasyon fi\u015flerinde ihracat bilgileri de\u011fi\u015ftirilmek istendi\u011finde al\u0131nan GTIP kodu girilmelidir veya Ambalaj Kodu girilmelidir uyar\u0131s\u0131 i\u00e7in a\u015fa\u011f\u0131daki sorgular ile d\u00fczeltme yap\u0131labilir. Not: Sorgu \u00e7al\u0131\u015ft\u0131r\u0131lmadan \u00f6nce data yede\u011fi al\u0131nmal\u0131 ve sorgu i\u00e7erisindeki firma ve d\u00f6nem bilgileri g\u00fcncellenmelidir. &#8211;\u0130hracat operasyon fi\u015fi sat\u0131r\u0131ndaki ambalaj kodu bo\u015f [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1629,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,8,19,10],"tags":[],"class_list":["post-2419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-fatura","category-logo-genel-destek","category-logorapor","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=2419"}],"version-history":[{"count":3,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2419\/revisions"}],"predecessor-version":[{"id":2422,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2419\/revisions\/2422"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1629"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}