{"id":357,"date":"2014-09-18T10:23:16","date_gmt":"2014-09-18T07:23:16","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=357"},"modified":"2015-01-15T23:36:25","modified_gmt":"2015-01-15T21:36:25","slug":"2-19-ve-uzeri-stok-miktarlari-hatali","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/2-19-ve-uzeri-stok-miktarlari-hatali\/","title":{"rendered":"2.19 ve \u00dczeri Stok Miktarlar\u0131 Hatal\u0131."},"content":{"rendered":"

2.19.00 versiyonu ile birlikte Malzeme ve Hizmet toplam tablolar\u0131 View yap\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015ft\u00fcr.\u00a0 Bu y\u00fczden Bak\u0131m i\u015flemleri alt\u0131nda yer alan; Malzeme, Sipari\u015f, Hizmet Toplamlar\u0131<\/p>\n

servisi bu sorunu \u00e7\u00f6zmeyecektir.<\/p>\n

 <\/p>\n

Veri Toplamlar\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong>\u00e8 Malzeme, Sipari\u015f, Hizmet Toplamlar\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :<\/strong> Bu servisin kullan\u0131m amac\u0131; Sipari\u015f sat\u0131rlar\u0131ndaki CLOSED ve SHIPPEDAMOUNT kolonlar\u0131n\u0131 d\u00fczenlemek i\u00e7in kullan\u0131l\u0131r.\u00a0 Da\u011f\u0131t\u0131m emri sat\u0131rlar\u0131ndaki Kalan miktar bilgileri d\u00fczenlenmektedir.<\/p>\n

<\/p>\n

Malzeme kart\u0131 \u00fczerindeki miktar ile Malzeme Ekstresi aras\u0131nda sorun varsa veya Rezerve edilen sipari\u015f hatal\u0131 g\u00f6r\u00fcn\u00fcyorsa yada Malzeme Durum Penceresinde sorun varsa yedek al\u0131narak ekteki queryler kullan\u0131labilir.<\/p>\n

 <\/p>\n

STSHIPEDMOAUNT_Insert.sql \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :<\/strong> Sipari\u015f fi\u015fine ba\u011fl\u0131 sevk edilmi\u015f sipari\u015f miktar toplam\u0131 tekrar d\u00fczenlenmektedir. 100 Adet sipari\u015f girip buna ba\u011fl\u0131 120 adet sevk edildiyse LG_XXX_YY_STSHIPPEDAMOUNT<\/strong> tablosunda 100 adet olmal\u0131 bu sat\u0131r ilgili tablodan silinerek tekrar yaz\u0131lmas\u0131 sa\u011flanmaktad\u0131r.<\/p>\n

 <\/p>\n

STSHIPEDMOAUNT_\u0130ade_Miktar_Update.sql :<\/strong> Sipari\u015f fi\u015fine ba\u011fl\u0131 sevk edilmi\u015f miktar iade i\u015flemi sonucu geri al\u0131n\u0131yorsa LG_XXX_YY_STSHIPPEDAMOUNT<\/strong> tablosunda miktar bilgisi 0 olmal\u0131d\u0131r bu query ile iade hareketlerinin LG_XXX_YY_STSHIPPEDAMOUNT<\/strong> tablosunda miktar bilgisi 0 olarak update edilmektedir. (\u00d6ncelikle \u00fcstteki queryi \u00e7al\u0131\u015ft\u0131r\u0131l\u0131p kontrol edilmeli sorun \u00e7\u00f6z\u00fclmeze malzeme baz\u0131nda bu query \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.)<\/p>\n

 <\/p>\n

Malzeme toplamlar\u0131 viewa ge\u00e7tikten sonra STLINE ve ORFLINE tablolar\u0131 aras\u0131nda sorun olup olmad\u0131\u011f\u0131 kontrol edilmelidir;<\/p>\n

 <\/p>\n

SELECT<\/strong> * FROM LG_099_01_STLINE WHERE ORDTRANSREF>0 AND ORDTRANSREF NOT IN (SELECT LOGICALREF FROM LG_099_01_ORFLINE)<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

SELECT<\/strong> * FROM LG_099_01_STLINE WHERE ORDFICHEREF>0 AND ORDFICHEREF NOT IN (SELECT LOGICALREF FROM LG_099_01_ORFICHE)<\/strong><\/p>\n

 <\/p>\n

Hatal\u0131 sonu\u00e7 d\u00f6n\u00fcyorsa d\u00fczeltilmelidir.<\/p>\n

\u00a0<\/strong><\/p>\n

Not : Bu i\u015flemler yap\u0131lmadan \u00f6nce mutlaka yedek al\u0131nmal\u0131 yada g\u00fcncel yede\u011fin oldu\u011fu kontrol edilmelidir.<\/strong><\/p>\n

 <\/p>\n

STSHIPEDMOAUNT_\u0130ade_Miktar_Update.sql<\/strong><\/h2>\n

UPDATE LG_099_01_STSHIPPEDAMOUNT SET SHIPPEDAMOUNT=0
\nWHERE TRANSREF IN
\n(
\nSELECT
\nL.LOGICALREF
\nFROM
\nLG_099_01_STLINE L WITH(NOLOCK)
\nLEFT OUTER JOIN LG_099_ITEMS I WITH(NOLOCK) ON L.STOCKREF=I.LOGICALREF AND L.LINETYPE NOT IN (2,3,4)
\nWHERE
\n(CANCELLED = 0)
\nAND (ORDTRANSREF <> 0)
\nAND (LINETYPE <> 2)
\nAND (LINETYPE <> 3)
\nAND I.CODE LIKE ‘KLM’ — MALZEME KODUNA G\u00d6RE
\nAND L.TRCODE=3
\n)<\/p>\n

 <\/p>\n

STSHIPEDMOAUNT_Insert.sql<\/strong><\/h2>\n

if exists (select * from dbo.sysobjects where id = object_id(N’TG_TEST’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)
\nBEGIN
\ndrop table TG_TEST
\nEND
\nGO
\nSELECT
\nL.LOGICALREF,L.AMOUNT,L.ORDTRANSREF,L.DATE_,L.SOURCELINK, L.UINFO1, L.UINFO2 , 0 AS TG
\nINTO TG_TEST
\nFROM
\nLG_099_01_STLINE L WITH(NOLOCK)
\nLEFT OUTER JOIN LG_099_ITEMS I WITH(NOLOCK) ON L.STOCKREF=I.LOGICALREF AND L.LINETYPE NOT IN (2,3,4)
\nWHERE
\n(CANCELLED = 0)
\nAND (ORDTRANSREF <> 0)
\nAND (LINETYPE <> 2)
\nAND (LINETYPE <> 3)
\nAND I.CODE LIKE ‘KLM’ — MALZEME KODUNA G\u00d6RE
\nORDER BY
\nDATE_
\n————————————
\nDECLARE @C_LOGICALREF INT, @C_AMOUNT FLOAT
\n,@C_ORDTRANSREF INT, @C_TRANSDATE DATETIME, @C_SOURCELINK INT
\n,@C_UNIT1CFACT FLOAT, @C_UNIT2CFACT FLOAT
\nDECLARE SHIPPED_CURS CURSOR FOR
\n————————————-
\nSELECT
\nL.LOGICALREF,L.AMOUNT,L.ORDTRANSREF,L.DATE_,L.SOURCELINK, L.UINFO1, L.UINFO2
\nFROM
\nTG_TEST L
\nWHERE
\nL.TG=0
\n————————————-
\nOPEN SHIPPED_CURS
\nFETCH NEXT FROM SHIPPED_CURS
\nINTO @C_LOGICALREF, @C_AMOUNT ,@C_ORDTRANSREF, @C_TRANSDATE, @C_SOURCELINK, @C_UNIT1CFACT, @C_UNIT2CFACT
\nWHILE @@FETCH_STATUS = 0
\nBEGIN
\n————————————-
\nDELETE FROM LG_099_01_STSHIPPEDAMOUNT WHERE TRANSREF=@C_LOGICALREF
\n————————————-
\nEXECUTE LG_UPDSHIPPEDAMOUNT_099_01
\n@C_LOGICALREF, @C_ORDTRANSREF, @C_SOURCELINK, @C_AMOUNT, @C_TRANSDATE, @C_UNIT1CFACT, @C_UNIT2CFACT, 1
\n————————————-
\nUPDATE TG_TEST SET TG=1 WHERE LOGICALREF=@C_LOGICALREF
\n————————————-
\nFETCH NEXT FROM SHIPPED_CURS
\nINTO @C_LOGICALREF, @C_AMOUNT, @C_ORDTRANSREF, @C_TRANSDATE, @C_SOURCELINK, @C_UNIT1CFACT, @C_UNIT2CFACT
\nEND
\nCLOSE SHIPPED_CURS
\nDEALLOCATE SHIPPED_CURS<\/p>\n","protected":false},"excerpt":{"rendered":"

2.19.00 versiyonu ile birlikte Malzeme ve Hizmet toplam tablolar\u0131 View yap\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015ft\u00fcr.\u00a0 Bu y\u00fczden Bak\u0131m i\u015flemleri alt\u0131nda yer alan; Malzeme, Sipari\u015f, Hizmet Toplamlar\u0131 servisi bu sorunu \u00e7\u00f6zmeyecektir.   Veri Toplamlar\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00e8 Malzeme, Sipari\u015f, Hizmet Toplamlar\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Bu servisin kullan\u0131m amac\u0131; Sipari\u015f sat\u0131rlar\u0131ndaki CLOSED ve SHIPPEDAMOUNT kolonlar\u0131n\u0131 d\u00fczenlemek i\u00e7in kullan\u0131l\u0131r.\u00a0 Da\u011f\u0131t\u0131m emri sat\u0131rlar\u0131ndaki Kalan miktar bilgileri […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-357","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/357","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=357"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/357\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/357\/revisions\/358"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}