24 Şubat 2020 Pazartesi 18:28:53

Sayım girişi ve çıkışı yaparak stok sıfırlama işlemi için sql kodu

7 months ago
#33 Alıntı

INSERT INTO MX_001_STLINE (
ItemsRef, IslemTarihi, IslemTuru, InvoiceRef, SatirNo,
CLCardRef, DepoKodu, Miktar, BirimFiyat, IskontoOran1,
IskontoOran2, IskontoOran3, IskontoTutar, IskontoluBirimFiyati, AraTutar,
Kdv, Tutar, KdvOran, SlsMan, Sign,
SaticiRef, Maliyet, NetFiyat)
SELECT
LogicalRef,
CAST(GETDATE() AS datetime),
CASE WHEN Kalan>0 THEN 5 ELSE 4 END,
NULL,
NULL,
NULL,
cast(0 as int),
CASE WHEN Kalan>0 THEN Kalan ELSE -1*Kalan END,
CAST(Price1 AS DECIMAL(18,4)),
cast(0 as decimal),
cast(0 as decimal),
cast(0 as decimal),
cast(0 as decimal),
null,
cast((CASE WHEN Kalan>0 THEN Kalan ELSE -1*Kalan end)as decimal(18,2)) * cast(((Price1)/(1+(Vat/100)))as decimal(18,2)),
cast((CASE WHEN Kalan>0 THEN Kalan ELSE -1*Kalan end)as decimal(18,2)) *cast(Price1as decimal(18,2))-(cast((CASE WHEN Kalan>0 THEN Kalan ELSE -1*Kalan end) as decimal(18,2))*
cast((Price1)/(1+(Vat/100))as decimal(18,2))) ,
cast((CASE WHEN Kalan>0 THEN Kalan ELSE -1*Kalan end) as decimal(18,2))*cast(Price1 as decimal(18,2)) ,
cast(Vat as tinyint),
'Zensoft',
CASE WHEN Kalan>0 THEN 0 ELSE 1 END,
null,
null,
CAST(Price1 AS DECIMAL(18,4))
FROM
Vw_Stoklar      
WHERE Kalan<>0
4 months ago
#65 Alıntı
cialis cost <a href=http://gennexium40.com/>nexium commercial</a> cialis prices
<a href=http://marasebrarrentacar.com/index.php?option=com_k2&view=itemlist&task=user&id=1512631>sexual dysfunction in men</a>
<a href=http://vetriera12.it/component/k2/itemlist/user/739251>ways to treat erectile dysfunction</a>

http://aldradach.drachenfest.info/forum/viewtopic.php?f=18&t=392872
4 months ago
#66 Alıntı
cialis tadalafil buy levitra online order generic cialis online
ed pills online
ed meds

http://hgy818.phpbbweb.com/posting.php?mode=newtopic&f=1
4 months ago
#67 Alıntı
cialis super active sildenafil without a doctor's prescription cialis 5 mg
ed treatment
ed medications comparison

http://societyforallages.ro/forums/topic/forward-movement-leaning-zisse-4/
4 months ago
#68 Alıntı
cialis for women viagra for women cialis coupons
best ed pills that work
Ed pills

http://edankan.free.fr/forum/reply.php?topic=29&forum=4&post=353&quote=1%20%20%20%20%20pBlo51s4dX
4 months ago
#69 Alıntı
cialis 20mg lyrica effets secondaires cialis daily
home remedies for erectile dysfunction
erectile dysfunction treatments

http://sgpublisher.com/showthread.php?tid=6
4 months ago
#70 Alıntı
cialis pills cost of zoloft cialis cost
erectile dysfunction treatments
Ed pills

http://pcforrum.ru/viewtopic.php?f=3&t=48633
4 months ago
#71 Alıntı
buy cialis difference between viagra and generic sildenafil cialis dosage
ed pills that work quickly
erectile dysfunction treatment

http://fsg.com.ar/forofsg/viewtopic.php?f=2&t=31818
4 months ago
#72 Alıntı
cialis usa canadian pharmacy scam cialis 10 mg
male erectile dysfunction
ways to treat erectile dysfunction

http://132.232.95.80/demo/justnews/forum.php?mod=viewthread&tid=54195&extra=
4 months ago
#73 Alıntı
cialis without prescription natural ed remedies buy cialis pills
erection problems
best ed pills that work

https://forums.freeadsbox.com/viewtopic.php?f=3&t=9265