Forum

Welcome Guest! To enable all features please try to register or login.
Prepravak zaglavlja SQLom
Options Go to last post Go to first unread
Previous Topic Next Topic
HD_prijavio
#1 Posted : 21 September 2011 16:47:00(UTC)
HD_prijavio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 1

Was thanked: 2 time(s) in 2 post(s)
Imamo situaciju da je greskom POS vrsta dokumenta nekoliko dana vukla sa pogresnog skladista, da li je moguce SQlom prepraviti the_move ili sta vec da se promet preracuna da ide sa pravog skladista?
HD_odgovorio
#2 Posted : 21 September 2011 16:47:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)
evo nesto pregledam definitivno bi trebalo da moze, znaci kako bi isao sql koji bi prepravio sve racune vrste dokumenta xxx poslije datuma yyy da ih skida sa skladista zzz
da li je potrebno uopste prepravljati the_moveitem?
HD_odgovorio
#3 Posted : 21 September 2011 16:47:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

update the_move
set acissuer=`nazivskladista`
where addate >=`YYYY-MM-DD`
and acdoctype=`xxxx`

gdje je xxxx sifra VD

i nakon toga preracunaj promet...


LP
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0.385 seconds.