BPM on ORDER MISC

[system]

Thanks Jose, But still no luck. Any other suggestions?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You are on 8 there is no ttcallcontextdata, also your .P is in a slightly
> different location since you are in 8 it should be RUN bo/SalesOrder.p
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 1:42 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> > Jose, When i tried your code, its not recognizing ttcallcontectbpmdata.
> > Its giving an error unambiguous table.
> > And i tried the following code:
> >
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > ttorderdtl.rowmod='U',first ttorderhed where
> > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> >
> > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOHOrderMsc in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> >
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> >
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > Nothing is happening!! please help.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[system]

Is the BPM firing? are tyou getting any errors in the logs?


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 1:54 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> Thanks Jose, But still no luck. Any other suggestions?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > You are on 8 there is no ttcallcontextdata, also your .P is in a slightly
> > different location since you are in 8 it should be RUN bo/SalesOrder.p
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 1:42 PM, sanjay219@... <sanjay219@...>wrote:
> >
> > > **
>
> > >
> > >
> > > Jose, When i tried your code, its not recognizing ttcallcontectbpmdata.
> > > Its giving an error unambiguous table.
> > > And i tried the following code:
> > >
> > >
> > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > DEFINE VARIABLE icustnum as integer no-undo.
> > > DEFINE VARIABLE iordernum as integer no-undo.
> > >
> > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > ttorderdtl.rowmod='U',first ttorderhed where
> > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > >
> > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > >
> > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > Customer.CustNum=iCustNum:
> > > Assign miscCode = Customer.ShortChar01.
> > > END.
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > > RUN GetNewOHOrderMsc in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > >
> > > END.
> > >
> > > RUN ChangeMiscCode in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > 'OHOrderMsc').
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > ttOHOrderMsc.FreqCode='E'.
> > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > >
> > > END.
> > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > >
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > >
> > > DELETE OBJECT hSalesOrder.
> > >
> > > end.
> > >
> > > Nothing is happening!! please help.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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

[system]

Yes the BPM is firing. Its firing just when I click new line(part). I tried the following code. And it Displays 'TEST1' everytime i add a new line and when i click save:

DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.


{lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.

FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U',first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.

{lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.

RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum=iCustNum:
Assign miscCode = Customer.ShortChar01.
END.
RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).
RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
Assign ttOHOrderMsc.MiscCode='FRGT'.
END.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OHOrderMsc').
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
ttOHOrderMsc.FreqCode='E'.
ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
END.
RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

DELETE OBJECT hSalesOrder.

end.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Is the BPM firing? are tyou getting any errors in the logs?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 1:54 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> > Thanks Jose, But still no luck. Any other suggestions?
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > You are on 8 there is no ttcallcontextdata, also your .P is in a slightly
> > > different location since you are in 8 it should be RUN bo/SalesOrder.p
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Jose, When i tried your code, its not recognizing ttcallcontectbpmdata.
> > > > Its giving an error unambiguous table.
> > > > And i tried the following code:
> > > >
> > > >
> > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > >
> > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > >
> > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > >
> > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > Customer.CustNum=iCustNum:
> > > > Assign miscCode = Customer.ShortChar01.
> > > > END.
> > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > {&output_dataset_SalesOrderDataSet}).
> > > > RUN GetNewOHOrderMsc in
> > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > >
> > > > END.
> > > >
> > > > RUN ChangeMiscCode in
> > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > 'OHOrderMsc').
> > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > ttOHOrderMsc.FreqCode='E'.
> > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > >
> > > > END.
> > > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > >
> > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > {&output_dataset_SalesOrderDataSet}).
> > > >
> > > > DELETE OBJECT hSalesOrder.
> > > >
> > > > end.
> > > >
> > > > Nothing is happening!! please help.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[system]

when you click new line? you don't have a ttOrderDtl.... yet.. this needs
to fire on update after the line has been created...


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 2:06 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> Yes the BPM is firing. Its firing just when I click new line(part). I
> tried the following code. And it Displays 'TEST1' everytime i add a new
> line and when i click save:
>
>
> DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> DEFINE VARIABLE icustnum as integer no-undo.
> DEFINE VARIABLE iordernum as integer no-undo.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
>
>
> FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> ttorderdtl.rowmod='U',first ttorderhed where
> ttorderhed.ordernum=ttorderdtl.OrderNum and
> ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
>
> RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
>
>
> FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> Customer.CustNum=iCustNum:
> Assign miscCode = Customer.ShortChar01.
> END.
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
> RUN GetNewOrderMsc in
>
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> Assign ttOHOrderMsc.MiscCode='FRGT'.
> END.
>
> RUN ChangeMiscCode in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> 'OHOrderMsc').
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> ttOHOrderMsc.FreqCode='E'.
> ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
>
> END.
> RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> DELETE OBJECT hSalesOrder.
>
> end.
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Is the BPM firing? are tyou getting any errors in the logs?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 1:54 PM, sanjay219@... <sanjay219@...>wrote:
> >
> > > **
> > >
> > >
>
> > > Thanks Jose, But still no luck. Any other suggestions?
> > >
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > You are on 8 there is no ttcallcontextdata, also your .P is in a
> slightly
> > > > different location since you are in 8 it should be RUN
> bo/SalesOrder.p
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
>
> > > >
> > > > > **
> > >
> > > > >
> > > > >
> > > > > Jose, When i tried your code, its not recognizing
> ttcallcontectbpmdata.
> > > > > Its giving an error unambiguous table.
> > > > > And i tried the following code:
> > > > >
> > > > >
> > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > >
> > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > ttorderhed.Company=ttorderdtl.Company and
> ttorderhed.TermsCode='CC'.
> > > > >
> > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > >
> > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > Customer.CustNum=iCustNum:
> > > > > Assign miscCode = Customer.ShortChar01.
> > > > > END.
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > RUN GetNewOHOrderMsc in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> iOrderNum,0).
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > >
> > > > > END.
> > > > >
> > > > > RUN ChangeMiscCode in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > 'OHOrderMsc').
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > >
> > > > > END.
> > > > > RUN Update in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > DELETE OBJECT hSalesOrder.
> > > > >
> > > > > end.
> > > > >
> > > > > Nothing is happening!! please help.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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

[system]

So you saying, im wrong in that 'For each' statement?

FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U',first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> when you click new line? you don't have a ttOrderDtl.... yet.. this needs
> to fire on update after the line has been created...
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 2:06 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> > Yes the BPM is firing. Its firing just when I click new line(part). I
> > tried the following code. And it Displays 'TEST1' everytime i add a new
> > line and when i click save:
> >
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> >
> >
> > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > ttorderdtl.rowmod='U',first ttorderhed where
> > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> >
> > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOrderMsc in
> >
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> >
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > Is the BPM firing? are tyou getting any errors in the logs?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > **
> > > >
> > > >
> >
> > > > Thanks Jose, But still no luck. Any other suggestions?
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > >
> > > > > You are on 8 there is no ttcallcontextdata, also your .P is in a
> > slightly
> > > > > different location since you are in 8 it should be RUN
> > bo/SalesOrder.p
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
> >
> > > > >
> > > > > > **
> > > >
> > > > > >
> > > > > >
> > > > > > Jose, When i tried your code, its not recognizing
> > ttcallcontectbpmdata.
> > > > > > Its giving an error unambiguous table.
> > > > > > And i tried the following code:
> > > > > >
> > > > > >
> > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > >
> > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > ttorderhed.Company=ttorderdtl.Company and
> > ttorderhed.TermsCode='CC'.
> > > > > >
> > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > >
> > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > Customer.CustNum=iCustNum:
> > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > END.
> > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > RUN GetNewOHOrderMsc in
> > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > iOrderNum,0).
> > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > >
> > > > > > END.
> > > > > >
> > > > > > RUN ChangeMiscCode in
> > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > 'OHOrderMsc').
> > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > >
> > > > > > END.
> > > > > > RUN Update in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > >
> > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > >
> > > > > > DELETE OBJECT hSalesOrder.
> > > > > >
> > > > > > end.
> > > > > >
> > > > > > Nothing is happening!! please help.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[system]

When is this firing?


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 2:27 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> So you saying, im wrong in that 'For each' statement?
>
> FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> ttorderdtl.rowmod='U',first ttorderhed where
> ttorderhed.ordernum=ttorderdtl.OrderNum and
> ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > when you click new line? you don't have a ttOrderDtl.... yet.. this needs
> > to fire on update after the line has been created...
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 2:06 PM, sanjay219@... <sanjay219@...>wrote:
> >
> > > **
> > >
> > >
>
> > > Yes the BPM is firing. Its firing just when I click new line(part). I
> > > tried the following code. And it Displays 'TEST1' everytime i add a new
> > > line and when i click save:
> > >
> > >
> > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > DEFINE VARIABLE icustnum as integer no-undo.
> > > DEFINE VARIABLE iordernum as integer no-undo.
> > >
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > >
> > >
> > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > ttorderdtl.rowmod='U',first ttorderhed where
> > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > >
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > >
> > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > >
> > >
> > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > Customer.CustNum=iCustNum:
> > > Assign miscCode = Customer.ShortChar01.
> > > END.
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > > RUN GetNewOrderMsc in
> > >
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > END.
> > >
> > > RUN ChangeMiscCode in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > 'OHOrderMsc').
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > ttOHOrderMsc.FreqCode='E'.
> > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > >
> > > END.
> > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > >
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > >
> > > DELETE OBJECT hSalesOrder.
> > >
> > > end.
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
>
> > > >
> > > > > **
> > > > >
> > > > >
> > >
> > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > >
> > > > > > You are on 8 there is no ttcallcontextdata, also your .P is in a
> > > slightly
> > > > > > different location since you are in 8 it should be RUN
> > > bo/SalesOrder.p
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > > >
> > > > > > > **
> > > > >
> > > > > > >
> > > > > > >
> > > > > > > Jose, When i tried your code, its not recognizing
> > > ttcallcontectbpmdata.
> > > > > > > Its giving an error unambiguous table.
> > > > > > > And i tried the following code:
> > > > > > >
> > > > > > >
> > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > >
> > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > ttorderhed.TermsCode='CC'.
> > > > > > >
> > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > >
> > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > Customer.CustNum=iCustNum:
> > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > END.
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > iOrderNum,0).
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > >
> > > > > > > END.
> > > > > > >
> > > > > > > RUN ChangeMiscCode in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > 'OHOrderMsc').
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > >
> > > > > > > END.
> > > > > > > RUN Update in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > >
> > > > > > > end.
> > > > > > >
> > > > > > > Nothing is happening!! please help.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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

[system]

When I add a new order line(part) or when I click save.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> When is this firing?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 2:27 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> > So you saying, im wrong in that 'For each' statement?
> >
> > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > ttorderdtl.rowmod='U',first ttorderhed where
> > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > when you click new line? you don't have a ttOrderDtl.... yet.. this needs
> > > to fire on update after the line has been created...
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > **
> > > >
> > > >
> >
> > > > Yes the BPM is firing. Its firing just when I click new line(part). I
> > > > tried the following code. And it Displays 'TEST1' everytime i add a new
> > > > line and when i click save:
> > > >
> > > >
> > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > >
> > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > >
> > > >
> > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > >
> > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > >
> > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > >
> > > >
> > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > Customer.CustNum=iCustNum:
> > > > Assign miscCode = Customer.ShortChar01.
> > > > END.
> > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > {&output_dataset_SalesOrderDataSet}).
> > > > RUN GetNewOrderMsc in
> > > >
> > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > END.
> > > >
> > > > RUN ChangeMiscCode in
> > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > 'OHOrderMsc').
> > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > ttOHOrderMsc.FreqCode='E'.
> > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > >
> > > > END.
> > > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > >
> > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > {&output_dataset_SalesOrderDataSet}).
> > > >
> > > > DELETE OBJECT hSalesOrder.
> > > >
> > > > end.
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > >
> > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> >
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > >
> > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > >
> > > > > > > You are on 8 there is no ttcallcontextdata, also your .P is in a
> > > > slightly
> > > > > > > different location since you are in 8 it should be RUN
> > > > bo/SalesOrder.p
> > > > > > >
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *
> > > > > > > *
> > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
> > > >
> > > > > > >
> > > > > > > > **
> > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Jose, When i tried your code, its not recognizing
> > > > ttcallcontectbpmdata.
> > > > > > > > Its giving an error unambiguous table.
> > > > > > > > And i tried the following code:
> > > > > > > >
> > > > > > > >
> > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > >
> > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > ttorderhed.TermsCode='CC'.
> > > > > > > >
> > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > > >
> > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > END.
> > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > iOrderNum,0).
> > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > >
> > > > > > > > END.
> > > > > > > >
> > > > > > > > RUN ChangeMiscCode in
> > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > 'OHOrderMsc').
> > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > >
> > > > > > > > END.
> > > > > > > > RUN Update in
> > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > >
> > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > >
> > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > >
> > > > > > > > end.
> > > > > > > >
> > > > > > > > Nothing is happening!! please help.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[system]

Pre-Proc or Post Proc?


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 2:46 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> When I add a new order line(part) or when I click save.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > When is this firing?
>
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 2:27 PM, sanjay219@... <sanjay219@...>wrote:
> >
> > > **
> > >
> > >
>
> > > So you saying, im wrong in that 'For each' statement?
> > >
> > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > ttorderdtl.rowmod='U',first ttorderhed where
> > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > when you click new line? you don't have a ttOrderDtl.... yet.. this
> needs
> > > > to fire on update after the line has been created...
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
>
> > > >
> > > > > **
> > > > >
> > > > >
> > >
> > > > > Yes the BPM is firing. Its firing just when I click new
> line(part). I
> > > > > tried the following code. And it Displays 'TEST1' everytime i add
> a new
> > > > > line and when i click save:
> > > > >
> > > > >
> > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > >
> > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > >
> > > > >
> > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > ttorderhed.Company=ttorderdtl.Company and
> ttorderhed.TermsCode='CC'.
> > > > >
> > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > >
> > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > >
> > > > >
> > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > Customer.CustNum=iCustNum:
> > > > > Assign miscCode = Customer.ShortChar01.
> > > > > END.
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > RUN GetNewOrderMsc in
> > > > >
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> iOrderNum,0).
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > END.
> > > > >
> > > > > RUN ChangeMiscCode in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > 'OHOrderMsc').
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > >
> > > > > END.
> > > > > RUN Update in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > DELETE OBJECT hSalesOrder.
> > > > >
> > > > > end.
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > >
> > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > >
> > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > >
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > >
> > > > > > > > You are on 8 there is no ttcallcontextdata, also your .P is
> in a
> > > > > slightly
> > > > > > > > different location since you are in 8 it should be RUN
> > > > > bo/SalesOrder.p
> > > > > > > >
> > > > > > > >
> > > > > > > > *Jose C Gomez*
> > > > > > > > *Software Engineer*
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@
> >wrote:
> > > > >
> > > > > > > >
> > > > > > > > > **
> > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > ttcallcontectbpmdata.
> > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > And i tried the following code:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > >
> > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > >
> > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > > > >
> > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > END.
> > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > iOrderNum,0).
> > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > >
> > > > > > > > > END.
> > > > > > > > >
> > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > 'OHOrderMsc').
> > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > > >
> > > > > > > > > END.
> > > > > > > > > RUN Update in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > >
> > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > >
> > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > >
> > > > > > > > > end.
> > > > > > > > >
> > > > > > > > > Nothing is happening!! please help.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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

[system]

This is the code:



DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.

{lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.

For each ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U', first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
{lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.

RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum=iCustNum:
Assign miscCode = Customer.ShortChar01.
END.
RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).
RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
Assign ttOHOrderMsc.MiscCode='FRGT'.
END.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OHOrderMsc').
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
ttOHOrderMsc.FreqCode='E'.
ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
END.
RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

DELETE OBJECT hSalesOrder.

end.

> > When is this firing?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 2:27 PM, sanjay219@ <sanjay219@>wrote:
> >
> > > **
> > >
> > >
> > > So you saying, im wrong in that 'For each' statement?
> > >
> > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > ttorderdtl.rowmod='U',first ttorderhed where
> > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > when you click new line? you don't have a ttOrderDtl.... yet.. this needs
> > > > to fire on update after the line has been created...
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > >
> > > > > Yes the BPM is firing. Its firing just when I click new line(part). I
> > > > > tried the following code. And it Displays 'TEST1' everytime i add a new
> > > > > line and when i click save:
> > > > >
> > > > >
> > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > >
> > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > >
> > > > >
> > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > > >
> > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > >
> > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > >
> > > > >
> > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > Customer.CustNum=iCustNum:
> > > > > Assign miscCode = Customer.ShortChar01.
> > > > > END.
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > RUN GetNewOrderMsc in
> > > > >
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > END.
> > > > >
> > > > > RUN ChangeMiscCode in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > 'OHOrderMsc').
> > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > >
> > > > > END.
> > > > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > {&output_dataset_SalesOrderDataSet}).
> > > > >
> > > > > DELETE OBJECT hSalesOrder.
> > > > >
> > > > > end.
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > >
> > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > >
> > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > >
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > >
> > > > > > > > You are on 8 there is no ttcallcontextdata, also your .P is in a
> > > > > slightly
> > > > > > > > different location since you are in 8 it should be RUN
> > > > > bo/SalesOrder.p
> > > > > > > >
> > > > > > > >
> > > > > > > > *Jose C Gomez*
> > > > > > > > *Software Engineer*
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@>wrote:
> > > > >
> > > > > > > >
> > > > > > > > > **
> > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > ttcallcontectbpmdata.
> > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > And i tried the following code:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > >
> > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > >
> > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > > > >
> > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > END.
> > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > iOrderNum,0).
> > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > >
> > > > > > > > > END.
> > > > > > > > >
> > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > 'OHOrderMsc').
> > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > > >
> > > > > > > > > END.
> > > > > > > > > RUN Update in
> > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > >
> > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > >
> > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > >
> > > > > > > > > end.
> > > > > > > > >
> > > > > > > > > Nothing is happening!! please help.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[system]

Is it preproc or post proc?

have you tried putting message boxes through out the code to see how far it
gets?


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 3:21 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
>
>
> This is the code:
>
>
> DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> DEFINE VARIABLE icustnum as integer no-undo.
> DEFINE VARIABLE iordernum as integer no-undo.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
>
> For each ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U',
> first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and
> ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
>
> RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
>
> FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> Customer.CustNum=iCustNum:
> Assign miscCode = Customer.ShortChar01.
> END.
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
> RUN GetNewOrderMsc in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> Assign ttOHOrderMsc.MiscCode='FRGT'.
> END.
>
> RUN ChangeMiscCode in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> 'OHOrderMsc').
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> ttOHOrderMsc.FreqCode='E'.
> ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> END.
> RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> DELETE OBJECT hSalesOrder.
>
> end.
>
> > > When is this firing?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 7, 2013 at 2:27 PM, sanjay219@ <sanjay219@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > So you saying, im wrong in that 'For each' statement?
> > > >
> > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > >
> > > > > when you click new line? you don't have a ttOrderDtl.... yet..
> this needs
> > > > > to fire on update after the line has been created...
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > >
> > > > > > Yes the BPM is firing. Its firing just when I click new
> line(part). I
> > > > > > tried the following code. And it Displays 'TEST1' everytime i
> add a new
> > > > > > line and when i click save:
> > > > > >
> > > > > >
> > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > >
> > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > > >
> > > > > >
> > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > ttorderhed.Company=ttorderdtl.Company and
> ttorderhed.TermsCode='CC'.
> > > > > >
> > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > > >
> > > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > >
> > > > > >
> > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > Customer.CustNum=iCustNum:
> > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > END.
> > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > RUN GetNewOrderMsc in
> > > > > >
> > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> iOrderNum,0).
> > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > END.
> > > > > >
> > > > > > RUN ChangeMiscCode in
> > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > 'OHOrderMsc').
> > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > > >
> > > > > > END.
> > > > > > RUN Update in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > >
> > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > >
> > > > > > DELETE OBJECT hSalesOrder.
> > > > > >
> > > > > > end.
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > >
> > > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > > >
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *
> > > > > > > *
> > > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > > >
> > > > > > >
> > > > > > > > **
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > > >
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > > >
> > > > > > > > > You are on 8 there is no ttcallcontextdata, also your .P
> is in a
> > > > > > slightly
> > > > > > > > > different location since you are in 8 it should be RUN
> > > > > > bo/SalesOrder.p
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > *Jose C Gomez*
> > > > > > > > > *Software Engineer*
> > > > > > > > > *
> > > > > > > > > *
> > > > > > > > > *
> > > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@
> >wrote:
> > > > > >
> > > > > > > > >
> > > > > > > > > > **
> > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > > ttcallcontectbpmdata.
> > > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > > And i tried the following code:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > > >
> > > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > > >
> > > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET
> hSalesOrder.
> > > > > > > > > >
> > > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > > END.
> > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > > iOrderNum,0).
> > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > > >
> > > > > > > > > > END.
> > > > > > > > > >
> > > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > >
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > > 'OHOrderMsc').
> > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > > > >
> > > > > > > > > > END.
> > > > > > > > > > RUN Update in
> > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > > >
> > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > >
> > > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > > >
> > > > > > > > > > end.
> > > > > > > > > >
> > > > > > > > > > Nothing is happening!! please help.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>


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

[system]

This is Pre. Yes I tried putting messages(please check in my code). Only the 1st message(before 1st for each statement) is showing up!

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Is it preproc or post proc?
>
> have you tried putting message boxes through out the code to see how far it
> gets?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 3:21 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> >
> >
> > This is the code:
> >
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> >
> > For each ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U',
> > first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and
> > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> >
> > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOrderMsc in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > > > When is this firing?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 2:27 PM, sanjay219@ <sanjay219@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > So you saying, im wrong in that 'For each' statement?
> > > > >
> > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > >
> > > > > > when you click new line? you don't have a ttOrderDtl.... yet..
> > this needs
> > > > > > to fire on update after the line has been created...
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > >
> > > > > > > Yes the BPM is firing. Its firing just when I click new
> > line(part). I
> > > > > > > tried the following code. And it Displays 'TEST1' everytime i
> > add a new
> > > > > > > line and when i click save:
> > > > > > >
> > > > > > >
> > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > >
> > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > > > >
> > > > > > >
> > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > ttorderhed.TermsCode='CC'.
> > > > > > >
> > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > > > >
> > > > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > >
> > > > > > >
> > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > Customer.CustNum=iCustNum:
> > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > END.
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > RUN GetNewOrderMsc in
> > > > > > >
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > iOrderNum,0).
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > END.
> > > > > > >
> > > > > > > RUN ChangeMiscCode in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > 'OHOrderMsc').
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > > > >
> > > > > > > END.
> > > > > > > RUN Update in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > >
> > > > > > > end.
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > >
> > > > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > > > >
> > > > > > > >
> > > > > > > > *Jose C Gomez*
> > > > > > > > *Software Engineer*
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > > > >
> > > > > > > >
> > > > > > > > > **
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > > > >
> > > > > > > > > > You are on 8 there is no ttcallcontextdata, also your .P
> > is in a
> > > > > > > slightly
> > > > > > > > > > different location since you are in 8 it should be RUN
> > > > > > > bo/SalesOrder.p
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > *Jose C Gomez*
> > > > > > > > > > *Software Engineer*
> > > > > > > > > > *
> > > > > > > > > > *
> > > > > > > > > > *
> > > > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@
> > >wrote:
> > > > > > >
> > > > > > > > > >
> > > > > > > > > > > **
> > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > > > ttcallcontectbpmdata.
> > > > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > > > And i tried the following code:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > > > >
> > > > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > > > >
> > > > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET
> > hSalesOrder.
> > > > > > > > > > >
> > > > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > > > END.
> > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > > > iOrderNum,0).
> > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > > > >
> > > > > > > > > > > END.
> > > > > > > > > > >
> > > > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > > >
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > > > 'OHOrderMsc').
> > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > > > > >
> > > > > > > > > > > END.
> > > > > > > > > > > RUN Update in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > > > >
> > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > >
> > > > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > > > >
> > > > > > > > > > > end.
> > > > > > > > > > >
> > > > > > > > > > > Nothing is happening!! please help.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

[system]

looks like its failing to find the stuff in your for each, eliminate things
form where where clause until it gets through. Remove the code I gave you
and just get the for each loop working then pu t the code back you are
trying to debug a lot of code but its not even getting into the loop. One
piece at a time.


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 3:26 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> This is Pre. Yes I tried putting messages(please check in my code). Only
> the 1st message(before 1st for each statement) is showing up!
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Is it preproc or post proc?
> >
> > have you tried putting message boxes through out the code to see how far
> it
> > gets?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 7, 2013 at 3:21 PM, sanjay219@... <sanjay219@...>wrote:
> >
> > > **
> > >
> > >
> > >
> > >
>
> > > This is the code:
> > >
> > >
> > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > DEFINE VARIABLE icustnum as integer no-undo.
> > > DEFINE VARIABLE iordernum as integer no-undo.
> > >
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > >
> > > For each ttorderdtl where ttorderdtl.RowMod='A' or
> ttorderdtl.rowmod='U',
> > > first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > >
> > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > >
> > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > Customer.CustNum=iCustNum:
> > > Assign miscCode = Customer.ShortChar01.
> > > END.
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > > RUN GetNewOrderMsc in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > END.
> > >
> > > RUN ChangeMiscCode in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > 'OHOrderMsc').
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > ttOHOrderMsc.FreqCode='E'.
> > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > END.
> > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > >
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > >
> > > DELETE OBJECT hSalesOrder.
> > >
> > > end.
> > >
> > > > > When is this firing?
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *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 7, 2013 at 2:27 PM, sanjay219@ <sanjay219@>wrote:
> > >
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > So you saying, im wrong in that 'For each' statement?
> > > > > >
> > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > ttorderhed.Company=ttorderdtl.Company and
> ttorderhed.TermsCode='CC'.
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > >
> > > > > > > when you click new line? you don't have a ttOrderDtl.... yet..
> > > this needs
> > > > > > > to fire on update after the line has been created...
> > > > > > >
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *
> > > > > > > *
> > > > > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > > > > > >
> > > > > > > > **
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > > > > Yes the BPM is firing. Its firing just when I click new
> > > line(part). I
> > > > > > > > tried the following code. And it Displays 'TEST1' everytime i
> > > add a new
> > > > > > > > line and when i click save:
> > > > > > > >
> > > > > > > >
> > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > >
> > > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > > > > >
> > > > > > > >
> > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > ttorderhed.TermsCode='CC'.
> > > > > > > >
> > > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > > > > >
> > > > > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > > >
> > > > > > > >
> > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > END.
> > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > RUN GetNewOrderMsc in
> > > > > > > >
> > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > iOrderNum,0).
> > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > END.
> > > > > > > >
> > > > > > > > RUN ChangeMiscCode in
> > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > 'OHOrderMsc').
> > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > > > > >
> > > > > > > > END.
> > > > > > > > RUN Update in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > >
> > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > >
> > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > >
> > > > > > > > end.
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > > > >
> > > > > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > *Jose C Gomez*
> > > > > > > > > *Software Engineer*
> > > > > > > > > *
> > > > > > > > > *
> > > > > > > > > *
> > > > > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@
> >wrote:
> > > > > >
> > > > > > > > >
> > > > > > > > > > **
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@>
> wrote:
> > > > > > > > > > >
> > > > > > > > > > > You are on 8 there is no ttcallcontextdata, also your
> .P
> > > is in a
> > > > > > > > slightly
> > > > > > > > > > > different location since you are in 8 it should be RUN
> > > > > > > > bo/SalesOrder.p
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > *Jose C Gomez*
> > > > > > > > > > > *Software Engineer*
> > > > > > > > > > > *
> > > > > > > > > > > *
> > > > > > > > > > > *
> > > > > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@
> > > >wrote:
> > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > **
> > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > > > > ttcallcontectbpmdata.
> > > > > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > > > > And i tried the following code:
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > > > > >
> > > > > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > > > > >
> > > > > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET
> > > hSalesOrder.
> > > > > > > > > > > >
> > > > > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > > > > END.
> > > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > > > >
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > > > > iOrderNum,0).
> > > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > > > > >
> > > > > > > > > > > > END.
> > > > > > > > > > > >
> > > > > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > > > >
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > > > > 'OHOrderMsc').
> > > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt +
> 10.
> > > > > > > > > > > >
> > > > > > > > > > > > END.
> > > > > > > > > > > > RUN Update in
> > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > > > > >
> > > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > > >
> > > > > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > > > > >
> > > > > > > > > > > > end.
> > > > > > > > > > > >
> > > > > > > > > > > > Nothing is happening!! please help.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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

[system]

When defining your second loop you have a period at the end of the for statement " and ttorderhed.TermsCode='CC'." instead of a colon ":". That for sure won't work but i'm not even sure how it validates?



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: sanjay219@...
To: vantage@yahoogroups.com
Sent: Friday, June 7, 2013 2:26:54 PM
Subject: [Vantage] Re: BPM on ORDER MISC



This is Pre. Yes I tried putting messages(please check in my code). Only the 1st message(before 1st for each statement) is showing up!

--- In vantage@yahoogroups.com , Jose Gomez <jose@...> wrote:
>
> Is it preproc or post proc?
>
> have you tried putting message boxes through out the code to see how far it
> gets?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 7, 2013 at 3:21 PM, sanjay219@... <sanjay219@...>wrote:
>
> > **
> >
> >
> >
> >
> > This is the code:
> >
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> >
> > For each ttorderdtl where ttorderdtl.RowMod='A' or ttorderdtl.rowmod='U',
> > first ttorderhed where ttorderhed.ordernum=ttorderdtl.OrderNum and
> > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> >
> > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOrderMsc in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > > > When is this firing?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *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 7, 2013 at 2:27 PM, sanjay219@ <sanjay219@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > So you saying, im wrong in that 'For each' statement?
> > > > >
> > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > ttorderhed.Company=ttorderdtl.Company and ttorderhed.TermsCode='CC'.
> > > > >
> > > > > --- In vantage@yahoogroups.com , Jose Gomez <jose@> wrote:
> > > > > >
> > > > > > when you click new line? you don't have a ttOrderDtl.... yet..
> > this needs
> > > > > > to fire on update after the line has been created...
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *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 7, 2013 at 2:06 PM, sanjay219@ <sanjay219@>wrote:
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > >
> > > > > > > Yes the BPM is firing. Its firing just when I click new
> > line(part). I
> > > > > > > tried the following code. And it Displays 'TEST1' everytime i
> > add a new
> > > > > > > line and when i click save:
> > > > > > >
> > > > > > >
> > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > >
> > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > > > > > >
> > > > > > >
> > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > ttorderhed.TermsCode='CC'.
> > > > > > >
> > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > > > > > >
> > > > > > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > > > > > >
> > > > > > >
> > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > Customer.CustNum=iCustNum:
> > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > END.
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > RUN GetNewOrderMsc in
> > > > > > >
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > iOrderNum,0).
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > END.
> > > > > > >
> > > > > > > RUN ChangeMiscCode in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > 'OHOrderMsc').
> > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > > > > >
> > > > > > > END.
> > > > > > > RUN Update in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > >
> > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > >
> > > > > > > end.
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com , Jose Gomez <jose@> wrote:
> > > > > > > >
> > > > > > > > Is the BPM firing? are tyou getting any errors in the logs?
> > > > > > > >
> > > > > > > >
> > > > > > > > *Jose C Gomez*
> > > > > > > > *Software Engineer*
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *
> > > > > > > > *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 7, 2013 at 1:54 PM, sanjay219@ <sanjay219@>wrote:
> > > > >
> > > > > > > >
> > > > > > > > > **
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > > > > Thanks Jose, But still no luck. Any other suggestions?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --- In vantage@yahoogroups.com , Jose Gomez <jose@> wrote:
> > > > > > > > > >
> > > > > > > > > > You are on 8 there is no ttcallcontextdata, also your .P
> > is in a
> > > > > > > slightly
> > > > > > > > > > different location since you are in 8 it should be RUN
> > > > > > > bo/SalesOrder.p
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > *Jose C Gomez*
> > > > > > > > > > *Software Engineer*
> > > > > > > > > > *
> > > > > > > > > > *
> > > > > > > > > > *
> > > > > > > > > > *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 7, 2013 at 1:42 PM, sanjay219@ <sanjay219@
> > >wrote:
> > > > > > >
> > > > > > > > > >
> > > > > > > > > > > **
> > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Jose, When i tried your code, its not recognizing
> > > > > > > ttcallcontectbpmdata.
> > > > > > > > > > > Its giving an error unambiguous table.
> > > > > > > > > > > And i tried the following code:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > > > > > > > > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > > > > > > > > > DEFINE VARIABLE icustnum as integer no-undo.
> > > > > > > > > > > DEFINE VARIABLE iordernum as integer no-undo.
> > > > > > > > > > >
> > > > > > > > > > > FOR EACH ttorderdtl where ttorderdtl.RowMod='A' or
> > > > > > > > > > > ttorderdtl.rowmod='U',first ttorderhed where
> > > > > > > > > > > ttorderhed.ordernum=ttorderdtl.OrderNum and
> > > > > > > > > > > ttorderhed.Company=ttorderdtl.Company and
> > > > > > > ttorderhed.TermsCode='CC'.
> > > > > > > > > > >
> > > > > > > > > > > RUN bo/SalesOrder/SalesOrder.p PERSISTENT SET
> > hSalesOrder.
> > > > > > > > > > >
> > > > > > > > > > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > > > > > > > > > Customer.CustNum=iCustNum:
> > > > > > > > > > > Assign miscCode = Customer.ShortChar01.
> > > > > > > > > > > END.
> > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > > RUN GetNewOHOrderMsc in
> > > > > > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},
> > > > > > > iOrderNum,0).
> > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > > > > > > > > >
> > > > > > > > > > > END.
> > > > > > > > > > >
> > > > > > > > > > > RUN ChangeMiscCode in
> > > > > > > > > > >
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > > > > > > > > > 'OHOrderMsc').
> > > > > > > > > > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > > > > > > > > > ttOHOrderMsc.FreqCode='E'.
> > > > > > > > > > > ttohordermsc.DocMiscAmt= ttohordermsc.DocMiscAmt + 10.
> > > > > > > > > > >
> > > > > > > > > > > END.
> > > > > > > > > > > RUN Update in
> > > > > > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > > > > > > > > > >
> > > > > > > > > > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > > > > > > > > > {&output_dataset_SalesOrderDataSet}).
> > > > > > > > > > >
> > > > > > > > > > > DELETE OBJECT hSalesOrder.
> > > > > > > > > > >
> > > > > > > > > > > end.
> > > > > > > > > > >
> > > > > > > > > > > Nothing is happening!! please help.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>





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

[system]

Thanks jose,
Ok. I got into loop. by changing the for each statement into:
for each ttorderhed where ttorderhed.termscode='CC'.
Its showing both messages.

Then I tried adding your code.


DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.

{lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.



for each ttorderhed where ttorderhed.TermsCode='CC'.

{lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.


RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum=iCustNum:
Assign miscCode = Customer.ShortChar01.
END.
RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).
RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
Assign ttOHOrderMsc.MiscCode='FRGT'.
END.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OHOrderMsc').
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
ttOHOrderMsc.FreqCode='E'.
ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
END.
RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

DELETE OBJECT hSalesOrder.

end.


But when i try to add a new line its showing an error: RECORD NOT FOUND.

Exception caught in: Epicor.Mfg.BO.SalesOrder

Error Detail
============
Message: Record not found.
Type: Error
Program: Server/bo/SalesOrder.p
Method: GetByID
Table: OrderHed
Row:
Field:



Stack Trace
===========
at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()

[system]

You have a few issues to address with that.

You define iordernum but are using iOrderNum down below they need to be the same. Also no where between defining iordernum and using iordernum do you assign a value to it. When you call GetByID right now iordernum is going in empty.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: sanjay219@...
To: vantage@yahoogroups.com
Sent: Friday, June 7, 2013 3:03:11 PM
Subject: [Vantage] Re: BPM on ORDER MISC



Thanks jose,
Ok. I got into loop. by changing the for each statement into:
for each ttorderhed where ttorderhed.termscode='CC'.
Its showing both messages.

Then I tried adding your code.

DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
DEFINE VARIABLE icustnum as integer no-undo.
DEFINE VARIABLE iordernum as integer no-undo.

{lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.

for each ttorderhed where ttorderhed.TermsCode='CC'.

{lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.

RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.

FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
Customer.CustNum=iCustNum:
Assign miscCode = Customer.ShortChar01.
END.
RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).
RUN GetNewOrderMsc in
hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
Assign ttOHOrderMsc.MiscCode='FRGT'.
END.

RUN ChangeMiscCode in
hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
'OHOrderMsc').
FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
ttOHOrderMsc.FreqCode='E'.
ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
END.
RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).

RUN GetByID IN hSalesOrder(INPUT iOrderNum,
{&output_dataset_SalesOrderDataSet}).

DELETE OBJECT hSalesOrder.

end.

But when i try to add a new line its showing an error: RECORD NOT FOUND.

Exception caught in: Epicor.Mfg.BO.SalesOrder

Error Detail
============
Message: Record not found.
Type: Error
Program: Server/bo/SalesOrder.p
Method: GetByID
Table: OrderHed
Row:
Field:

Stack Trace
===========
at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()





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

[system]

Can I assign iOrderNum with ttorderHed.OrderNum??
and for icustnum = ttcustomer.custnum??

--- In vantage@yahoogroups.com, Joshua Giese <jgiese@...> wrote:
>
> You have a few issues to address with that.
>
> You define iordernum but are using iOrderNum down below they need to be the same. Also no where between defining iordernum and using iordernum do you assign a value to it. When you call GetByID right now iordernum is going in empty.
>
>
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
> ----- Original Message -----
>
> From: sanjay219@...
> To: vantage@yahoogroups.com
> Sent: Friday, June 7, 2013 3:03:11 PM
> Subject: [Vantage] Re: BPM on ORDER MISC
>
>
>
> Thanks jose,
> Ok. I got into loop. by changing the for each statement into:
> for each ttorderhed where ttorderhed.termscode='CC'.
> Its showing both messages.
>
> Then I tried adding your code.
>
> DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> DEFINE VARIABLE icustnum as integer no-undo.
> DEFINE VARIABLE iordernum as integer no-undo.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
>
> for each ttorderhed where ttorderhed.TermsCode='CC'.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
>
> RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
>
> FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> Customer.CustNum=iCustNum:
> Assign miscCode = Customer.ShortChar01.
> END.
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
> RUN GetNewOrderMsc in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> Assign ttOHOrderMsc.MiscCode='FRGT'.
> END.
>
> RUN ChangeMiscCode in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> 'OHOrderMsc').
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> ttOHOrderMsc.FreqCode='E'.
> ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> END.
> RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> DELETE OBJECT hSalesOrder.
>
> end.
>
> But when i try to add a new line its showing an error: RECORD NOT FOUND.
>
> Exception caught in: Epicor.Mfg.BO.SalesOrder
>
> Error Detail
> ============
> Message: Record not found.
> Type: Error
> Program: Server/bo/SalesOrder.p
> Method: GetByID
> Table: OrderHed
> Row:
> Field:
>
> Stack Trace
> ===========
> at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

Yes you should be able to do both.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: sanjay219@...
To: vantage@yahoogroups.com
Sent: Friday, June 7, 2013 3:16:42 PM
Subject: [Vantage] Re: BPM on ORDER MISC



Can I assign iOrderNum with ttorderHed.OrderNum??
and for icustnum = ttcustomer.custnum??

--- In vantage@yahoogroups.com , Joshua Giese <jgiese@...> wrote:
>
> You have a few issues to address with that.
>
> You define iordernum but are using iOrderNum down below they need to be the same. Also no where between defining iordernum and using iordernum do you assign a value to it. When you call GetByID right now iordernum is going in empty.
>
>
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
> ----- Original Message -----
>
> From: sanjay219@...
> To: vantage@yahoogroups.com
> Sent: Friday, June 7, 2013 3:03:11 PM
> Subject: [Vantage] Re: BPM on ORDER MISC
>
>
>
> Thanks jose,
> Ok. I got into loop. by changing the for each statement into:
> for each ttorderhed where ttorderhed.termscode='CC'.
> Its showing both messages.
>
> Then I tried adding your code.
>
> DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> DEFINE VARIABLE icustnum as integer no-undo.
> DEFINE VARIABLE iordernum as integer no-undo.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
>
> for each ttorderhed where ttorderhed.TermsCode='CC'.
>
> {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
>
> RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
>
> FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> Customer.CustNum=iCustNum:
> Assign miscCode = Customer.ShortChar01.
> END.
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
> RUN GetNewOrderMsc in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> Assign ttOHOrderMsc.MiscCode='FRGT'.
> END.
>
> RUN ChangeMiscCode in
> hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> 'OHOrderMsc').
> FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> ttOHOrderMsc.FreqCode='E'.
> ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> END.
> RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
>
> RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> {&output_dataset_SalesOrderDataSet}).
>
> DELETE OBJECT hSalesOrder.
>
> end.
>
> But when i try to add a new line its showing an error: RECORD NOT FOUND.
>
> Exception caught in: Epicor.Mfg.BO.SalesOrder
>
> Error Detail
> ============
> Message: Record not found.
> Type: Error
> Program: Server/bo/SalesOrder.p
> Method: GetByID
> Table: OrderHed
> Row:
> Field:
>
> Stack Trace
> ===========
> at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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

[system]

I tried. but same error.

--- In vantage@yahoogroups.com, Joshua Giese <jgiese@...> wrote:
>
> Yes you should be able to do both.
>
>
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
> ----- Original Message -----
>
> From: sanjay219@...
> To: vantage@yahoogroups.com
> Sent: Friday, June 7, 2013 3:16:42 PM
> Subject: [Vantage] Re: BPM on ORDER MISC
>
>
>
> Can I assign iOrderNum with ttorderHed.OrderNum??
> and for icustnum = ttcustomer.custnum??
>
> --- In vantage@yahoogroups.com , Joshua Giese <jgiese@> wrote:
> >
> > You have a few issues to address with that.
> >
> > You define iordernum but are using iOrderNum down below they need to be the same. Also no where between defining iordernum and using iordernum do you assign a value to it. When you call GetByID right now iordernum is going in empty.
> >
> >
> >
> > Joshua Giese
> >
> > CTO
> >
> > 920.437.6400 Ext. 337
> >
> > Site ID: 27450-E905700B2-SQL64
> >
> > ----- Original Message -----
> >
> > From: sanjay219@
> > To: vantage@yahoogroups.com
> > Sent: Friday, June 7, 2013 3:03:11 PM
> > Subject: [Vantage] Re: BPM on ORDER MISC
> >
> >
> >
> > Thanks jose,
> > Ok. I got into loop. by changing the for each statement into:
> > for each ttorderhed where ttorderhed.termscode='CC'.
> > Its showing both messages.
> >
> > Then I tried adding your code.
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> >
> > for each ttorderhed where ttorderhed.TermsCode='CC'.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> >
> > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOrderMsc in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > But when i try to add a new line its showing an error: RECORD NOT FOUND.
> >
> > Exception caught in: Epicor.Mfg.BO.SalesOrder
> >
> > Error Detail
> > ============
> > Message: Record not found.
> > Type: Error
> > Program: Server/bo/SalesOrder.p
> > Method: GetByID
> > Table: OrderHed
> > Row:
> > Field:
> >
> > Stack Trace
> > ===========
> > at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> > at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> > at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

you might have to use ttOrderHed.CustNum try using the messageboxes to ensure your variables are assigned with the data you need.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: sanjay219@...
To: vantage@yahoogroups.com
Sent: Friday, June 7, 2013 3:34:28 PM
Subject: [Vantage] Re: BPM on ORDER MISC



I tried. but same error.

--- In vantage@yahoogroups.com , Joshua Giese <jgiese@...> wrote:
>
> Yes you should be able to do both.
>
>
>
> Joshua Giese
>
> CTO
>
> 920.437.6400 Ext. 337
>
> Site ID: 27450-E905700B2-SQL64
>
> ----- Original Message -----
>
> From: sanjay219@...
> To: vantage@yahoogroups.com
> Sent: Friday, June 7, 2013 3:16:42 PM
> Subject: [Vantage] Re: BPM on ORDER MISC
>
>
>
> Can I assign iOrderNum with ttorderHed.OrderNum??
> and for icustnum = ttcustomer.custnum??
>
> --- In vantage@yahoogroups.com , Joshua Giese <jgiese@> wrote:
> >
> > You have a few issues to address with that.
> >
> > You define iordernum but are using iOrderNum down below they need to be the same. Also no where between defining iordernum and using iordernum do you assign a value to it. When you call GetByID right now iordernum is going in empty.
> >
> >
> >
> > Joshua Giese
> >
> > CTO
> >
> > 920.437.6400 Ext. 337
> >
> > Site ID: 27450-E905700B2-SQL64
> >
> > ----- Original Message -----
> >
> > From: sanjay219@
> > To: vantage@yahoogroups.com
> > Sent: Friday, June 7, 2013 3:03:11 PM
> > Subject: [Vantage] Re: BPM on ORDER MISC
> >
> >
> >
> > Thanks jose,
> > Ok. I got into loop. by changing the for each statement into:
> > for each ttorderhed where ttorderhed.termscode='CC'.
> > Its showing both messages.
> >
> > Then I tried adding your code.
> >
> > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > DEFINE VARIABLE icustnum as integer no-undo.
> > DEFINE VARIABLE iordernum as integer no-undo.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> >
> > for each ttorderhed where ttorderhed.TermsCode='CC'.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> >
> > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> >
> > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > Customer.CustNum=iCustNum:
> > Assign miscCode = Customer.ShortChar01.
> > END.
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> > RUN GetNewOrderMsc in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > END.
> >
> > RUN ChangeMiscCode in
> > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > 'OHOrderMsc').
> > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > ttOHOrderMsc.FreqCode='E'.
> > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > END.
> > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> >
> > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > {&output_dataset_SalesOrderDataSet}).
> >
> > DELETE OBJECT hSalesOrder.
> >
> > end.
> >
> > But when i try to add a new line its showing an error: RECORD NOT FOUND.
> >
> > Exception caught in: Epicor.Mfg.BO.SalesOrder
> >
> > Error Detail
> > ============
> > Message: Record not found.
> > Type: Error
> > Program: Server/bo/SalesOrder.p
> > Method: GetByID
> > Table: OrderHed
> > Row:
> > Field:
> >
> > Stack Trace
> > ===========
> > at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> > at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> > at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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

[system]

CustNum needs to come ttOrderhed.custnun. sorry bud out for the weekend.
Try reading the code and understanding what ti does you should be able to
figure it out
Its all tehre!


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 7, 2013 at 4:34 PM, sanjay219@... <sanjay219@...>wrote:

> **
>
>
> I tried. but same error.
>
>
> --- In vantage@yahoogroups.com, Joshua Giese <jgiese@...> wrote:
> >
> > Yes you should be able to do both.
> >
> >
> >
> > Joshua Giese
> >
> > CTO
> >
> > 920.437.6400 Ext. 337
> >
> > Site ID: 27450-E905700B2-SQL64
> >
> > ----- Original Message -----
> >
> > From: sanjay219@...
> > To: vantage@yahoogroups.com
> > Sent: Friday, June 7, 2013 3:16:42 PM
> > Subject: [Vantage] Re: BPM on ORDER MISC
> >
> >
> >
> > Can I assign iOrderNum with ttorderHed.OrderNum??
> > and for icustnum = ttcustomer.custnum??
> >
> > --- In vantage@yahoogroups.com , Joshua Giese <jgiese@> wrote:
> > >
> > > You have a few issues to address with that.
> > >
> > > You define iordernum but are using iOrderNum down below they need to
> be the same. Also no where between defining iordernum and using iordernum
> do you assign a value to it. When you call GetByID right now iordernum is
> going in empty.
> > >
> > >
> > >
> > > Joshua Giese
> > >
> > > CTO
> > >
> > > 920.437.6400 Ext. 337
> > >
> > > Site ID: 27450-E905700B2-SQL64
> > >
> > > ----- Original Message -----
> > >
> > > From: sanjay219@
> > > To: vantage@yahoogroups.com
> > > Sent: Friday, June 7, 2013 3:03:11 PM
> > > Subject: [Vantage] Re: BPM on ORDER MISC
> > >
> > >
> > >
> > > Thanks jose,
> > > Ok. I got into loop. by changing the for each statement into:
> > > for each ttorderhed where ttorderhed.termscode='CC'.
> > > Its showing both messages.
> > >
> > > Then I tried adding your code.
> > >
> > > DEFINE VARIABLE hSalesOrder AS HANDLE NO-UNDO.
> > > DEFINE VARIABLE miscCode AS CHARACTER NO-UNDO.
> > > DEFINE VARIABLE icustnum as integer no-undo.
> > > DEFINE VARIABLE iordernum as integer no-undo.
> > >
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test1'"}.
> > >
> > > for each ttorderhed where ttorderhed.TermsCode='CC'.
> > >
> > > {lib/PublishInfoMsg.i &InfoMsg = "'Test2'"}.
> > >
> > > RUN bo/SalesOrder.p PERSISTENT SET hSalesOrder.
> > >
> > > FOR EACH Customer WHERE Customer.Company=CUR-COMP AND
> > > Customer.CustNum=iCustNum:
> > > Assign miscCode = Customer.ShortChar01.
> > > END.
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > > RUN GetNewOrderMsc in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet}, iOrderNum,0).
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > Assign ttOHOrderMsc.MiscCode='FRGT'.
> > > END.
> > >
> > > RUN ChangeMiscCode in
> > > hSalesOrder({&input-output_dataset_SalesOrderDataSet},INPUT
> > > 'OHOrderMsc').
> > > FOR EACH ttOHOrderMsc WHERE ttOHOrderMsc.RowMod='A':
> > > ttOHOrderMsc.FreqCode='E'.
> > > ttOHordermsc.DocMiscAmt= ttOHordermsc.DocMiscAmt + 10.
> > > END.
> > > RUN Update in hSalesOrder({&input-output_dataset_SalesOrderDataSet}).
> > >
> > > RUN GetByID IN hSalesOrder(INPUT iOrderNum,
> > > {&output_dataset_SalesOrderDataSet}).
> > >
> > > DELETE OBJECT hSalesOrder.
> > >
> > > end.
> > >
> > > But when i try to add a new line its showing an error: RECORD NOT
> FOUND.
> > >
> > > Exception caught in: Epicor.Mfg.BO.SalesOrder
> > >
> > > Error Detail
> > > ============
> > > Message: Record not found.
> > > Type: Error
> > > Program: Server/bo/SalesOrder.p
> > > Method: GetByID
> > > Table: OrderHed
> > > Row:
> > > Field:
> > >
> > > Stack Trace
> > > ===========
> > > at Epicor.Mfg.Proxy.SalesOrderImpl.Update(SalesOrderDataSet ds)
> > > at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.Update()
> > > at Epicor.Mfg.UI.App.SalesOrderEntry.Transaction.Update()
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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