Advise needed on screw up correction

Nope...not what I want to hear...lol But thanks.



--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>
> Probably not what you want to hear but the easiest solution may be
to
> restore from backup. Though, depending on what coast you're
on...you'll
> either lose half a day or almost a full day assuming you have a good
> backup from last night.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Darren Mann
> Sent: Thursday, May 04, 2006 12:19 PM
> To: Vantage User Group (vantage@yahoogroups.com)
> Subject: [Vantage] Advise needed on screw up correction...
>
>
>
> I had trouble with an index in the Job Oper table this morning and
ran a
> database conversion utility to repair/fix operations cost/hours
(5090).
> Well it didn't work and now it screwed up all my inventory counts
for
> Job
> Operations set to auto receive to inventory. It recreated all Mfg-
STK
> and
> ADJ-CST transactions!!! NICE! Anyway I'm sure no one has ran into
this
> similar problem but I was hoping someone might give me some ideas
on how
> to
> back these out.
>
> Thanks in advance.
>
> Darren Mann
> IT Manager
> Miller Products Co.
> 1015 N. Main St.
> Osceola, IA 50213
> Ph. 641-342-2103
> Fax 641-342-3222
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
>
> Manufacturing software
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+sof
tw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se
> +marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
>
> Membership database software
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Man
>
ufacturing+software&w2=Membership+database+software&w3=Database+mortga
ge
>
+software&w4=Pda+database+software&w5=Database+management+software&w6=
Da
> tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
>
> Database mortgage software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manuf
>
acturing+software&w2=Membership+database+software&w3=Database+mortgage
+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Da
ta
> base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
>
> Pda database software
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufactur
>
ing+software&w2=Membership+database+software&w3=Database+mortgage+soft
wa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databas
e+
> marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
>
> Database management software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Man
>
ufacturing+software&w2=Membership+database+software&w3=Database+mortga
ge
>
+software&w4=Pda+database+software&w5=Database+management+software&w6=
Da
> tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
>
> Database marketing software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manu
>
facturing+software&w2=Membership+database+software&w3=Database+mortgag
e+
>
software&w4=Pda+database+software&w5=Database+management+software&w6=D
at
> abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> ________________________________
>
>
>
> [Non-text portions of this message have been removed]
>
I had trouble with an index in the Job Oper table this morning and ran a
database conversion utility to repair/fix operations cost/hours (5090).
Well it didn't work and now it screwed up all my inventory counts for Job
Operations set to auto receive to inventory. It recreated all Mfg-STK and
ADJ-CST transactions!!! NICE! Anyway I'm sure no one has ran into this
similar problem but I was hoping someone might give me some ideas on how to
back these out.

Thanks in advance.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222





[Non-text portions of this message have been removed]
Probably not what you want to hear but the easiest solution may be to
restore from backup. Though, depending on what coast you're on...you'll
either lose half a day or almost a full day assuming you have a good
backup from last night.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Thursday, May 04, 2006 12:19 PM
To: Vantage User Group (vantage@yahoogroups.com)
Subject: [Vantage] Advise needed on screw up correction...



I had trouble with an index in the Job Oper table this morning and ran a
database conversion utility to repair/fix operations cost/hours (5090).
Well it didn't work and now it screwed up all my inventory counts for
Job
Operations set to auto receive to inventory. It recreated all Mfg-STK
and
ADJ-CST transactions!!! NICE! Anyway I'm sure no one has ran into this
similar problem but I was hoping someone might give me some ideas on how
to
back these out.

Thanks in advance.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222





[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]