Data definition - quote to order

system · June 19, 2011, 8:02pm

If I understand correctly and you use it as a BPM then you have to know that there is a different method that runs when turning a quote into a order.

Also I realised you looking up by quotenum and quotepart but the better link is quoteline.

Ephraim
Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: "Rick Hagy" <rhagy@...>
Sender: vantage@yahoogroups.com
Date: Fri, 10 Jun 2011 10:32:00
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: RE: [Vantage] data definition - quote to order

If I turn a quote to a Sales order the data is not coming over to the
order.

If I go to that order and update a line then information comes over.

Thanks,

Rick Hagy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, June 10, 2011 9:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] data definition - quote to order

What do you mean?

Sent from mobile
On Jun 10, 2011 9:37 AM, "Rick Hagy" <rhagy@...
<mailto:rhagy%40openplan.com> > wrote:

> Jose,
>
> Thank you that works if I update the line, but it is not working if I
> move a quote to an order. Any ideas why?
>
> Thanks,
> Rick Hagy
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of Jose Gomez
> Sent: Friday, June 10, 2011 8:48 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] data definition - quote to order
>
> Well your First Order Dtl may not have a Quote Num... try changing

your

> statement a bit, something like
>
> FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
> Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
> IF AVAILABLE QuoteDtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...

<mailto:rhagy%40openplan.com> > wrote:

>
>>
>>
>> Trying to move a field from quotedtl to orderdtl.
>>
>> Here is my equation.
>>
>> for first Orderdtl:
>> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
>> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
>> IF available quotedtl THEN DO:
>> ASSIGN orderdtl.number01 = quotedtl.Number01.
>> END.
>> END.
>>
>> Thanks for the help.
>> Rick
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>

Effective June 1st. Open Plan Systems will enact the following price increases.

Existing pricing provided by OPS will be honored through May 31, 2011. Effective June 1st 3% will be added to quotes dated prior to June 2011. Quotes dated after June 1, 2011 will reflect new pricing. All orders after June 30, 2011 will be based off of the new pricing. The 3% increase will not apply to OPS seating, pedestals or laterals and the OPS2 Tiles.

The price increase does not apply to GSA orders.

To view our latest newsletter navigate to: hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html

To see our new OPS Elevation Seating Line navigate to: http://www.openplan.com/seatingOPS.html

Contact your CSR for discounting information.

Reduce - Reuse - Recycle Buy Open Plan Systems

The content of this message is strictly confidential and is intended for the exclusive use of the addressee. Any unauthorized distribution and copying of this communication is strictly forbidden. If you have received said communication by error, please delete it immediately. HMU, LLC believes that this E-mail and its attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. However, by reading this message and opening any attachments, the addressee accepts full responsibility for taking protective and remedial action about viruses and other defects.

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

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

system · June 9, 2011, 9:49pm

Trying to move a field from quotedtl to orderdtl.

Here is my equation.

for first Orderdtl:
FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
IF available quotedtl THEN DO:
ASSIGN orderdtl.number01 = quotedtl.Number01.
END.
END.

Thanks for the help.
Rick

system · June 10, 2011, 8:48am

Well your First Order Dtl may not have a Quote Num... try changing your
statement a bit, something like

FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
IF AVAILABLE QuoteDtl THEN DO:
ASSIGN orderdtl.number01 = quotedtl.Number01.
END.
END.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...> wrote:

>
>
> Trying to move a field from quotedtl to orderdtl.
>
> Here is my equation.
>
> for first Orderdtl:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
> IF available quotedtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> Thanks for the help.
> Rick
>
>
>

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

system · June 10, 2011, 8:54am

Also, not sure where you're running this, but if it's a BPM you should
likely be using the tt tables.

On Fri, Jun 10, 2011 at 8:48 AM, Jose Gomez <jose@...> wrote:

> Well your First Order Dtl may not have a Quote Num... try changing your
> statement a bit, something like
>
> FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
> Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
> IF AVAILABLE QuoteDtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
> >
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...> wrote:
>
> >
> >
> > Trying to move a field from quotedtl to orderdtl.
> >
> > Here is my equation.
> >
> > for first Orderdtl:
> > FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
> > Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
> > IF available quotedtl THEN DO:
> > ASSIGN orderdtl.number01 = quotedtl.Number01.
> > END.
> > END.
> >
> > Thanks for the help.
> > Rick
> >
> >
> >
>
>
> [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/linksYahoo! Groups Links
>
>
>
>

--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*

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

system · June 10, 2011, 9:37am

Jose,

Thank you that works if I update the line, but it is not working if I
move a quote to an order. Any ideas why?

Thanks,
Rick Hagy

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, June 10, 2011 8:48 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] data definition - quote to order

Well your First Order Dtl may not have a Quote Num... try changing your
statement a bit, something like

FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
IF AVAILABLE QuoteDtl THEN DO:
ASSIGN orderdtl.number01 = quotedtl.Number01.
END.
END.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...> wrote:

>
>
> Trying to move a field from quotedtl to orderdtl.
>
> Here is my equation.
>
> for first Orderdtl:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
> IF available quotedtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> Thanks for the help.
> Rick
>
>
>

[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/linksYahoo! Groups Links

Effective June 1st. Open Plan Systems will enact the following price increases.

Existing pricing provided by OPS will be honored through May 31, 2011. Effective June 1st 3% will be added to quotes dated prior to June 2011. Quotes dated after June 1, 2011 will reflect new pricing. All orders after June 30, 2011 will be based off of the new pricing. The 3% increase will not apply to OPS seating, pedestals or laterals and the OPS2 Tiles.

The price increase does not apply to GSA orders.

To view our latest newsletter navigate to: hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html

To see our new OPS Elevation Seating Line navigate to: http://www.openplan.com/seatingOPS.html

Contact your CSR for discounting information.

Reduce - Reuse - Recycle Buy Open Plan Systems

The content of this message is strictly confidential and is intended for the exclusive use of the addressee. Any unauthorized distribution and copying of this communication is strictly forbidden. If you have received said communication by error, please delete it immediately. HMU, LLC believes that this E-mail and its attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. However, by reading this message and opening any attachments, the addressee accepts full responsibility for taking protective and remedial action about viruses and other defects.

system · June 10, 2011, 9:45am

What do you mean?

Sent from mobile

On Jun 10, 2011 9:37 AM, "Rick Hagy" <rhagy@...> wrote:
> Jose,
>
> Thank you that works if I update the line, but it is not working if I
> move a quote to an order. Any ideas why?
>
> Thanks,
> Rick Hagy
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, June 10, 2011 8:48 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] data definition - quote to order
>
> Well your First Order Dtl may not have a Quote Num... try changing your
> statement a bit, something like
>
> FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
> Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
> IF AVAILABLE QuoteDtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...> wrote:
>
>>
>>
>> Trying to move a field from quotedtl to orderdtl.
>>
>> Here is my equation.
>>
>> for first Orderdtl:
>> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
>> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
>> IF available quotedtl THEN DO:
>> ASSIGN orderdtl.number01 = quotedtl.Number01.
>> END.
>> END.
>>
>> Thanks for the help.
>> Rick
>>
>>
>>
>
>
> [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/linksYahoo! Groups Links
>
>
>
>
> Effective June 1st. Open Plan Systems will enact the following price
increases.
>
> Existing pricing provided by OPS will be honored through May 31, 2011.
Effective June 1st 3% will be added to quotes dated prior to June 2011.
Quotes dated after June 1, 2011 will reflect new pricing. All orders after
June 30, 2011 will be based off of the new pricing. The 3% increase will not
apply to OPS seating, pedestals or laterals and the OPS2 Tiles.
>
> The price increase does not apply to GSA orders.
>
>
> To view our latest newsletter navigate to: hhttp://
www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html
>
> To see our new OPS Elevation Seating Line navigate to:
http://www.openplan.com/seatingOPS.html
>
> Contact your CSR for discounting information.
>
>
>
> Reduce - Reuse - Recycle Buy Open Plan Systems
>
>
> The content of this message is strictly confidential and is intended for
the exclusive use of the addressee. Any unauthorized distribution and
copying of this communication is strictly forbidden. If you have received
said communication by error, please delete it immediately. HMU, LLC believes
that this E-mail and its attachments were free of any virus, worm, Trojan
horse, and/or malicious code when sent. However, by reading this message and
opening any attachments, the addressee accepts full responsibility for
taking protective and remedial action about viruses and other defects.
>
>

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

system · June 10, 2011, 10:32am

If I turn a quote to a Sales order the data is not coming over to the
order.

If I go to that order and update a line then information comes over.

Thanks,

Rick Hagy

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, June 10, 2011 9:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] data definition - quote to order

What do you mean?

Sent from mobile
On Jun 10, 2011 9:37 AM, "Rick Hagy" <rhagy@...
<mailto:rhagy%40openplan.com> > wrote:

> Jose,
>
> Thank you that works if I update the line, but it is not working if I
> move a quote to an order. Any ideas why?
>
> Thanks,
> Rick Hagy
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of Jose Gomez
> Sent: Friday, June 10, 2011 8:48 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] data definition - quote to order
>
> Well your First Order Dtl may not have a Quote Num... try changing

your

> statement a bit, something like
>
> FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
> Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
> IF AVAILABLE QuoteDtl THEN DO:
> ASSIGN orderdtl.number01 = quotedtl.Number01.
> END.
> END.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...

<mailto:rhagy%40openplan.com> > wrote:

>
>>
>>
>> Trying to move a field from quotedtl to orderdtl.
>>
>> Here is my equation.
>>
>> for first Orderdtl:
>> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
>> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
>> IF available quotedtl THEN DO:
>> ASSIGN orderdtl.number01 = quotedtl.Number01.
>> END.
>> END.
>>
>> Thanks for the help.
>> Rick
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>

Effective June 1st. Open Plan Systems will enact the following price increases.

Existing pricing provided by OPS will be honored through May 31, 2011. Effective June 1st 3% will be added to quotes dated prior to June 2011. Quotes dated after June 1, 2011 will reflect new pricing. All orders after June 30, 2011 will be based off of the new pricing. The 3% increase will not apply to OPS seating, pedestals or laterals and the OPS2 Tiles.

The price increase does not apply to GSA orders.

To view our latest newsletter navigate to: hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html

To see our new OPS Elevation Seating Line navigate to: http://www.openplan.com/seatingOPS.html

Contact your CSR for discounting information.

Reduce - Reuse - Recycle Buy Open Plan Systems

The content of this message is strictly confidential and is intended for the exclusive use of the addressee. Any unauthorized distribution and copying of this communication is strictly forbidden. If you have received said communication by error, please delete it immediately. HMU, LLC believes that this E-mail and its attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. However, by reading this message and opening any attachments, the addressee accepts full responsibility for taking protective and remedial action about viruses and other defects.

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

system · June 10, 2011, 10:55am

What Epicor Version are you on?
You could also do the look-up reverse, that is find a quote and then find
the Order.
*
*
*
*
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Fri, Jun 10, 2011 at 10:32 AM, Rick Hagy <rhagy@...> wrote:

>
>
> If I turn a quote to a Sales order the data is not coming over to the
> order.
>
> If I go to that order and update a line then information comes over.
>
> Thanks,
>
> Rick Hagy
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, June 10, 2011 9:46 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] data definition - quote to order
>
>
> What do you mean?
>
> Sent from mobile
> On Jun 10, 2011 9:37 AM, "Rick Hagy" <rhagy@...
> <mailto:rhagy%40openplan.com> > wrote:
> > Jose,
> >
> > Thank you that works if I update the line, but it is not working if I
> > move a quote to an order. Any ideas why?
> >
> > Thanks,
> > Rick Hagy
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>
> Behalf
> > Of Jose Gomez
> > Sent: Friday, June 10, 2011 8:48 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] data definition - quote to order
> >
> > Well your First Order Dtl may not have a Quote Num... try changing
> your
> > statement a bit, something like
> >
> > FOR FIRST Orderdtl where OrderDtl.QuoteNum <> 0:
> > FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum AND
> > Quotedtl.partnum = OrderDtl.partnum NO-LOCK NO-ERROR.
> > IF AVAILABLE QuoteDtl THEN DO:
> > ASSIGN orderdtl.number01 = quotedtl.Number01.
> > END.
> > END.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@... <mailto:jose%40josecgomez.com>
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez>
> > <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez>
> > <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Thu, Jun 9, 2011 at 9:49 PM, Rick <rhagy@...
> <mailto:rhagy%40openplan.com> > wrote:
> >
> >>
> >>
> >> Trying to move a field from quotedtl to orderdtl.
> >>
> >> Here is my equation.
> >>
> >> for first Orderdtl:
> >> FIND FIRST Quotedtl WHERE Quotedtl.quotenum = OrderDtl.QuoteNum and
> >> Quotedtl.partnum = OrderDtl.partnum No-Lock No-Error.
> >> IF available quotedtl THEN DO:
> >> ASSIGN orderdtl.number01 = quotedtl.Number01.
> >> END.
> >> END.
> >>
> >> Thanks for the help.
> >> Rick
> >>
> >>
> >>
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> >
>
> Effective June 1st. Open Plan Systems will enact the following price
> increases.
>
> Existing pricing provided by OPS will be honored through May 31, 2011.
> Effective June 1st 3% will be added to quotes dated prior to June 2011.
> Quotes dated after June 1, 2011 will reflect new pricing. All orders after
> June 30, 2011 will be based off of the new pricing. The 3% increase will not
> apply to OPS seating, pedestals or laterals and the OPS2 Tiles.
>
> The price increase does not apply to GSA orders.
>
>
> To view our latest newsletter navigate to:
> hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html
>
> To see our new OPS Elevation Seating Line navigate to:
> http://www.openplan.com/seatingOPS.html
>
> Contact your CSR for discounting information.
>
> Reduce - Reuse - Recycle Buy Open Plan Systems
>
> The content of this message is strictly confidential and is intended for
> the exclusive use of the addressee. Any unauthorized distribution and
> copying of this communication is strictly forbidden. If you have received
> said communication by error, please delete it immediately. HMU, LLC believes
> that this E-mail and its attachments were free of any virus, worm, Trojan
> horse, and/or malicious code when sent. However, by reading this message and
> opening any attachments, the addressee accepts full responsibility for
> taking protective and remedial action about viruses and other defects.
>
> [Non-text portions of this message have been removed]
>
>
>

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