Zaloga = 0, vrednost 0 Options

Previous Topic Next Topic

borism		#1 Posted : 08 January 2013 09:18:18(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		kako iščete takšne primere (Zaloga = 0, vrednost <>0)?
User Profile View All Posts by User View Thanks

dejan		#2 Posted : 08 January 2013 09:39:43(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		Boris na pregledu trenutne zaloge prelistaj tistih 5 strani artikov pa bos videl kje je zaloga 0 in se pojavi kakšna vrednost.
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

borism		#3 Posted : 08 January 2013 09:41:32(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		temu sem se želel izogniti... ;)
User Profile View All Posts by User View Thanks

dejan		#4 Posted : 08 January 2013 09:57:19(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		Lenuh :) Potem pa si izvozi izpis v excel.. pa se tam igraj :)
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

dejan		#5 Posted : 08 January 2013 09:59:11(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		Da nebos pol še vprašal, kako popravit te ko imajo zalogo 0 in vrednost par 1000€ :) nekje so navodila menda se reče vrednostno preknjiženje.
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

borism		#6 Posted : 08 January 2013 09:59:34(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		a sem edini ? ;)) select * from tHE_Stock where anStock = 0 and anValue <> 0 pa je seznam predolg... katera vrednost je tista prava "vrednost za vrednotenje"?
User Profile View All Posts by User View Thanks

borism		#7 Posted : 08 January 2013 10:02:15(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		ps. da ne bo pomote... zadevo imam že urejeno, ampak me zanima kako optimizirati postopek... (še Steve Jobs bi se skril... haha)
User Profile View All Posts by User View Thanks

dejan		#8 Posted : 08 January 2013 10:04:33(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		anValue
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

borism		#9 Posted : 08 January 2013 10:10:49(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		ampak na tem seznamu so stvari, ki jih spredaj ne vidim... pa vrednosti so na x decimalk... kako ostali urejate to zadevo (zate že vem Dejan ;))) )?
User Profile View All Posts by User View Thanks

markobu		#10 Posted : 08 January 2013 14:38:30(UTC)
Rank: Advanced Member Joined: 08/11/2011(UTC) Posts: 41 Was thanked: 1 time(s) in 1 post(s)		V oblikovanju izpisa trenutne zaloge omejiti izpis samo na artikle, kjer je zaloga = 0. Dovolj je samo ta kriterij. Tak izpis shranimo pod novim imenom in to je to. lp Marko Bučar
User Profile View All Posts by User View Thanks

borism		#11 Posted : 08 January 2013 15:37:21(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		je kdo probal taisto zadevo narediti s predlogo obrazca v "Pregled trenutne zaloge" npr v izpisu 313?
User Profile View All Posts by User View Thanks

sladmin		#12 Posted : 09 January 2013 11:41:07(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 4		Zadevo lahko naredite v vseh obrazcih Pregleda trenutne zaloge.
User Profile View All Posts by User View Thanks

borism		#13 Posted : 09 January 2013 13:12:51(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		kako? preko predloge ne gre... potrebno bi bilo narediti nov izpis, kjer bi bila količina fiksirana izboljšan SQL stavek select * from tHE_Stock where anStock = 0 and round(anValue,4) <> 0
User Profile View All Posts by User View Thanks

dejan		#14 Posted : 09 January 2013 13:17:54(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		Boris na buildu 910 imas na tem izpisu trenutne zaloge spodaj kriterij ZALOGA in samo daš = 0 in to bo pokazalo samo te, kateri imajo zalogo 0 in neko vrednost.
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

borism		#15 Posted : 10 January 2013 08:57:58(UTC)
Rank: PA User Joined: 09/01/2010(UTC) Posts: 271 Thanks: 1 times		ah, ah... kje je še build 910... trenutno sem na 710... je kaj buggy? ;(
User Profile View All Posts by User View Thanks

dejan		#16 Posted : 10 January 2013 12:42:38(UTC)
Rank: PA User Joined: 24/04/2009(UTC) Posts: 579 Was thanked: 9 time(s) in 9 post(s)		Nadgradi in boš videl :) Pri meni za 1x dela vse ok
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

Rss Feed  Atom Feed

Users browsing this topic

Guest