Which Patch on 8 is everyone on? Is 8.06B safe?

Sorry, I misread your post, we are on Vantage. My bad



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, February 22, 2006 4:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Which Patch on 8 is everyone on? Is 8.06B safe?



I'm on B, seems OK.

Not sure what you mean about part tracker, except that in 806 you have
to use the context menu (right click) to access the numerous areas that
use to be on tabs.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Becky Venneman
Sent: Wednesday, February 22, 2006 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Which Patch on 8 is everyone on? Is 8.06B safe?



Starting back down the path of evaluating when & whether to move to 8.0
in
Vista or stay on Vista 6.1?
Checking on Latest Patches available & verifying reliability of before
IT
installs on the weekend.

Advise on what the patches 8.06 & 8.06B have solved?
Does the parts tracker work yet?

Currently on 8.05c. (Vista)

I will be attending CRM training on 8 this Friday, so that can receive
the
license code & get it set up so that others internally can view as part
of
advance decision on whether to change to 8? Another impact of this
decision
is How long is 6.1 going to be supported? Then, second decision will be
whether we will remain on Linux server with 8? Several add-on modules
seem
to possibly not be compatible with Linux? When will standard modules no
longer be compatible? If any users have their recommendations or
experiences to share, please feel free to contact me via email.

- Becky S. Venneman, CMA, SPHR
Finance/Human Resource Coordinator
Technical Services, Inc.
57006 241st Street; Ames, IA 50010
Phone: 515-232-3188; Fax: 515-232-2953
E-mail: <mailto:beckyv@...> beckyv@...
<http://www.tsiames.com/> www.tsiames.com; www.razorgage.com
<http://www.razorgage.com/>

Live Network: Vista 6.1, Linux Red Hat, Crystal 8.5
Test Network: Vista 8.804, Linux Red Hat, Crystal 10
Evaluating: Whether Windows Server would be supported better than Linux
by
Epicor???


[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/>
<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]



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]
I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...





[Non-text portions of this message have been removed]
Rich,
Try changing the onorder-sum to onorderSum....eliminate the dash.
Progress probably sees it
As a minus operator.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 10:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P

I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.
Tried that and no dice any other suggestions.



_____

From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, February 22, 2006 10:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculate demand in .P



Rich,
Try changing the onorder-sum to onorderSum....eliminate the dash.
Progress probably sees it
As a minus operator.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 10:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P

I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



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]
Do you need take into account partial shipped quantities and or
stock?


--- In vantage@yahoogroups.com, "RICH WAGNER" <rwagner@...> wrote:
>
> Tried that and no dice any other suggestions.
>
>
>
> _____
>
> From: PLAMAN DICK [mailto:dick.plaman@...]
> Sent: Wednesday, February 22, 2006 10:39 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Calculate demand in .P
>
>
>
> Rich,
> Try changing the onorder-sum to onorderSum....eliminate the dash.
> Progress probably sees it
> As a minus operator.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of RICH WAGNER
> Sent: Wednesday, February 22, 2006 10:25 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Calculate demand in .P
>
> I am trying to calculate the demand of a product when an order is
> placed. My formula seems to be calculating the demand wrong. Can
any see
> my mistake?
>
>
>
> FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND
>
> (OrderRel.PartNum =
OrderDtl.PartNum) AND
>
> (OrderRel.OpenRelease = yes)
>
> NO-LOCK.
>
> onorder-sum = onorder-sum + OrderRel.OurReqQty.
>
> END.
>
>
>
> 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+so
ftw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase
> +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+mortg
age
>
+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+mortgag
e+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata
> 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+sof
twa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+
> 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+mortg
age
>
+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+mortga
ge+
>
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]
>
Why don't you try also setting OrderNum and OrderLine in OrderRel and
OrderDtl to be equal.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 7:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P


I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...





[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/.
(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]
I need the demand for the part regardless of the order.



_____

From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 22, 2006 11:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculate demand in .P



Why don't you try also setting OrderNum and OrderLine in OrderRel and
OrderDtl to be equal.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 7:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P


I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...





[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]



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]
I will eventually need to take the partial shipped into account but as
of right now for my testing I am just trying to add the OurReqQty of
open relesase.



_____

From: brychanwilliams [mailto:brychanw@...]
Sent: Wednesday, February 22, 2006 11:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Calculate demand in .P



Do you need take into account partial shipped quantities and or
stock?


--- In vantage@yahoogroups.com, "RICH WAGNER" <rwagner@...> wrote:
>
> Tried that and no dice any other suggestions.
>
>
>
> _____
>
> From: PLAMAN DICK [mailto:dick.plaman@...]
> Sent: Wednesday, February 22, 2006 10:39 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Calculate demand in .P
>
>
>
> Rich,
> Try changing the onorder-sum to onorderSum....eliminate the dash.
> Progress probably sees it
> As a minus operator.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of RICH WAGNER
> Sent: Wednesday, February 22, 2006 10:25 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Calculate demand in .P
>
> I am trying to calculate the demand of a product when an order is
> placed. My formula seems to be calculating the demand wrong. Can
any see
> my mistake?
>
>
>
> FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND
>
> (OrderRel.PartNum =
OrderDtl.PartNum) AND
>
> (OrderRel.OpenRelease = yes)
>
> NO-LOCK.
>
> onorder-sum = onorder-sum + OrderRel.OurReqQty.
>
> END.
>
>
>
> 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/>
> <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+so
ftw
>
are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase
> +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+mortg
age
>
+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+mortgag
e+s
>
oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata
> 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+sof
twa
>
re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+
> 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+mortg
age
>
+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+mortga
ge+
>
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]
>






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]
You may need to subtract off shipments from the release.


Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
RICH WAGNER
Sent: Wednesday, February 22, 2006 9:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P

I am trying to calculate the demand of a product when an order is placed. My
formula seems to be calculating the demand wrong. Can any see my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...





[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/.
(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
Yahoo! Groups Links







This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
Understood but unless your join is correct between the two tables you
have potential for duplicates.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculate demand in .P


I need the demand for the part regardless of the order.



_____

From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 22, 2006 11:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculate demand in .P



Why don't you try also setting OrderNum and OrderLine in OrderRel and
OrderDtl to be equal.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 7:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P


I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...





[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]



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]



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/.
(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]
Rich,
Why not include the logic now.

onorder-sum = onorder-sum + OrderRel.OurReqQty - OurJobShippedQty -
OurStockShippedQty.

Might fix the problem you are having...Specifically if you have releases
that have been opened again after they close by shipping complete.
Also, what is triggering the BAM? Has the current release(s) Quantity been
recorded in the database before the BAM? If you are in a test DB, you can
test this by causing an intentional error in the code and seeing if the
triggering event finished recording before vantage dumps.

Just some things to check.

Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of RICH WAGNER
Sent: Wednesday, February 22, 2006 10:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate demand in .P


I am trying to calculate the demand of a product when an order is
placed. My formula seems to be calculating the demand wrong. Can any see
my mistake?



FOR EACH OrderRel WHERE (OrderRel.Company = OrderDtl.Company) AND

(OrderRel.PartNum = OrderDtl.PartNum) AND

(OrderRel.OpenRelease = yes)

NO-LOCK.

onorder-sum = onorder-sum + OrderRel.OurReqQty.

END.



Thanks,



Rich Wagner

BAW Plastics

Phone: (412)384-3100

E-Mail: rwagner@...
Starting back down the path of evaluating when & whether to move to 8.0 in
Vista or stay on Vista 6.1?
Checking on Latest Patches available & verifying reliability of before IT
installs on the weekend.

Advise on what the patches 8.06 & 8.06B have solved?
Does the parts tracker work yet?

Currently on 8.05c. (Vista)

I will be attending CRM training on 8 this Friday, so that can receive the
license code & get it set up so that others internally can view as part of
advance decision on whether to change to 8? Another impact of this decision
is How long is 6.1 going to be supported? Then, second decision will be
whether we will remain on Linux server with 8? Several add-on modules seem
to possibly not be compatible with Linux? When will standard modules no
longer be compatible? If any users have their recommendations or
experiences to share, please feel free to contact me via email.

- Becky S. Venneman, CMA, SPHR
Finance/Human Resource Coordinator
Technical Services, Inc.
57006 241st Street; Ames, IA 50010
Phone: 515-232-3188; Fax: 515-232-2953
E-mail: <mailto:beckyv@...> beckyv@...
<http://www.tsiames.com/> www.tsiames.com; www.razorgage.com
<http://www.razorgage.com/>

Live Network: Vista 6.1, Linux Red Hat, Crystal 8.5
Test Network: Vista 8.804, Linux Red Hat, Crystal 10
Evaluating: Whether Windows Server would be supported better than Linux by
Epicor???


[Non-text portions of this message have been removed]
You can use the following program to detect corruption Electroimpact has seen during the V6 to V8 conversion. Use "6" when connected to your 6.x database, otherwise "8". Two files will be created, x6.tmp and x8.tmp. After creating x8.tmp, it'll use the Windows file compare program "fc" to detect any changes and store them in x68.txt -- there shouldn't be any.

After running the 8.0.806b Conversion Program 8610 we found 27 corrupt jobs. 8610 doesn't run automatically unless you're converting from 6.x.

def var xver as char init "6" no-undo.
output to value("d:\temp\x" + xver + ".tmp").
for each jobasmbl no-lock use-index bomseq.
put unform jobasmbl.company "~t" jobasmbl.jobnum "~t" jobasmbl.assemblyseq "~n".
end. output close.
if xver eq "8" then dos silent "fc d:\temp\x6.tmp d:\temp\x8.tmp>d:\temp\x68.txt".

----- Original Message -----
From: "Becky Venneman" <beckyv@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, February 22, 2006 12:34 PM
Subject: [Vantage] Which Patch on 8 is everyone on? Is 8.06B safe?


Starting back down the path of evaluating when & whether to move to 8.0 in
Vista or stay on Vista 6.1?
Checking on Latest Patches available & verifying reliability of before IT
installs on the weekend.

Advise on what the patches 8.06 & 8.06B have solved?
Does the parts tracker work yet?

Currently on 8.05c. (Vista)

I will be attending CRM training on 8 this Friday, so that can receive the
license code & get it set up so that others internally can view as part of
advance decision on whether to change to 8? Another impact of this decision
is How long is 6.1 going to be supported? Then, second decision will be
whether we will remain on Linux server with 8? Several add-on modules seem
to possibly not be compatible with Linux? When will standard modules no
longer be compatible? If any users have their recommendations or
experiences to share, please feel free to contact me via email.

- Becky S. Venneman, CMA, SPHR
Finance/Human Resource Coordinator
Technical Services, Inc.
57006 241st Street; Ames, IA 50010
Phone: 515-232-3188; Fax: 515-232-2953
E-mail: <mailto:beckyv@...> beckyv@...
<http://www.tsiames.com/> www.tsiames.com; www.razorgage.com
<http://www.razorgage.com/>

Live Network: Vista 6.1, Linux Red Hat, Crystal 8.5
Test Network: Vista 8.804, Linux Red Hat, Crystal 10
Evaluating: Whether Windows Server would be supported better than Linux by
Epicor???


[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/.
(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
Yahoo! Groups Links







[Non-text portions of this message have been removed]
I'm on B, seems OK.

Not sure what you mean about part tracker, except that in 806 you have
to use the context menu (right click) to access the numerous areas that
use to be on tabs.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Becky Venneman
Sent: Wednesday, February 22, 2006 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Which Patch on 8 is everyone on? Is 8.06B safe?



Starting back down the path of evaluating when & whether to move to 8.0
in
Vista or stay on Vista 6.1?
Checking on Latest Patches available & verifying reliability of before
IT
installs on the weekend.

Advise on what the patches 8.06 & 8.06B have solved?
Does the parts tracker work yet?

Currently on 8.05c. (Vista)

I will be attending CRM training on 8 this Friday, so that can receive
the
license code & get it set up so that others internally can view as part
of
advance decision on whether to change to 8? Another impact of this
decision
is How long is 6.1 going to be supported? Then, second decision will be
whether we will remain on Linux server with 8? Several add-on modules
seem
to possibly not be compatible with Linux? When will standard modules no
longer be compatible? If any users have their recommendations or
experiences to share, please feel free to contact me via email.

- Becky S. Venneman, CMA, SPHR
Finance/Human Resource Coordinator
Technical Services, Inc.
57006 241st Street; Ames, IA 50010
Phone: 515-232-3188; Fax: 515-232-2953
E-mail: <mailto:beckyv@...> beckyv@...
<http://www.tsiames.com/> www.tsiames.com; www.razorgage.com
<http://www.razorgage.com/>

Live Network: Vista 6.1, Linux Red Hat, Crystal 8.5
Test Network: Vista 8.804, Linux Red Hat, Crystal 10
Evaluating: Whether Windows Server would be supported better than Linux
by
Epicor???


[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]