BPM - 4GL Transferring data between 2 table fields. noob Questio

Yahoo Archive
1
I have been on Jury duty for a week so sorry if this has already been
covered.





Just before the find of Quote detail I also do a



For each ttOrderDtl where ttOrderDtl.RowMod = 'A' or ttOrderDtl.RowMod =
'U':







Just before the "Export Done" line add a end for the above "For Each"



End.







The "IF NOT AMBIGUOUS part AND AVAILABLE part THEN"



Should be



IF NOT AMBIGUOUS QuoteDtl AND AVAILABLE QuoteDtl THEN



Need a period after the Export "Assigned" line





Hope this helps





Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of roomurray
Sent: Monday, August 24, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM - 4GL Transferring data between 2 table
fields. noob Question





I'm Still struggling with this one!! Although some of your suggestions
work and the data in the order field in the display screen is shown -
the data is not in fact written to the new table! Wierd I know!

I've had Epicor onto this and they came back with the same results as I
have had. (which I'm kind of glad about!!!)

If I can find anything else out on this I will let you know.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>
> Oh yeah and at the end do OUTPUT close.
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
> Sent from Jacksonville, FL, United States
>
> On Thu, Jul 30, 2009 at 9:04 AM, Jose Gomez <jose@...> wrote:
>
> > Are you sure the BPM is being triggered? If you are not try putting
this
> > code in the BPM to test
> >
> > OUTPUT To "C:\Debug.Txt" Append.
> >
> > Then whwnever you want to put something there use
> > EXPORT "EQUALS " (orderdtl.unitprice * orderdtl.orderqty)
> >
> > For example using the BPM above you could do soemthing llike this.
> >
> > OUTPUT To "C:\Debug.Txt" Append.
> > EXPORT "BPM FIRED".
> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> > ttOrderDtl.QuoteLine NO-ERROR
> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> > DO:
> > EXPORT "FOUND".
> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> > EXPORT "ASSIGNED"
> > END.
> > EXPORT "DONE".
> >
> >
> >
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> >
> > On Thu, Jul 30, 2009 at 5:56 AM, roomurray <rupert@...>wrote:
> >
> >>
> >>
> >>
> >>
> >> Thanks for the replies
> >>
> >> I'm running this as a pre processing
> >>
> >> I've tried it on getbyid and orderupdate (both pre and post) but
the field
> >> data is not being transferred.
> >>
> >> I can't work out where i'm going wrong - (there's data in the
> >> quotedtl.shortchar01!!)
> >>
> >> (i'm using 8.3.405)
> >>
> >> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<vantage%40yahoogroups.com>, Jose Gomez
> >> <jose@> wrote:
> >> >
> >> > Are you putting that BPM on post Processing ? or pre processing?
Here is
> >> a
> >> > BPM we have running on Pre=Processing it works fine. Take a look
at how
> >> we
> >> > do it and see if it modifying it works for you.
> >> >
> >> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> >> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> >> > ttOrderDtl.QuoteLine NO-ERROR
> >> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> >> > DO:
> >> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> >> > END.
> >> >
> >> > If that doesn't work move the BPM to a different place. IE Order
getbyid
> >> or
> >> > Order Update.
> >> >
> >> >
> >> > Sincerely
> >> > Jose C Gomez
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
2
I created the following in Createorderfromquote in salesorder BO (For the pull)
(most of which was taken from snippets of previous posts)

Where have I gone wrong? the error log isn't exactly telling me what I've done wrong.

Find QuoteDtl Where (QuoteDtl.Company = ttOrderDtl.Company) and
(QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum) and
(QuoteDtl.QuoteLine = ttOrderDtl.QuoteLine) no-lock.

if avail QuoteDtl then do:

Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.



END.
3
I don't think you're doing anything wrong. I think it's that Vantage is not working the way you think it is.

If you turn off your BPM, turn on Tracing and follow the normal procedure, you'll see that Vantage actions the SalesOrder.CreateOrderFromQuote BO and immediately follows it with SalesOrder.GetByID BO.

I could be wrong, but I think Vantage is creating the order in the background without using the ttOrder tables and, once it's finished, it then loads in the now-created order onto the screen and into the tt tables for further user-editing.

You could try creating your BPM on the GetByID BO and maybe set a flag (say OrderHed.CheckBox01) within the BPM so that if this order is loaded in again you'll know you've already copied over the fields.

HTH,

Nigel.


--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
>
> I created the following in Createorderfromquote in salesorder BO (For the pull)
> (most of which was taken from snippets of previous posts)
>
> Where have I gone wrong? the error log isn't exactly telling me what I've done wrong.
>
> Find QuoteDtl Where (QuoteDtl.Company = ttOrderDtl.Company) and
> (QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum) and
> (QuoteDtl.QuoteLine = ttOrderDtl.QuoteLine) no-lock.
>
> if avail QuoteDtl then do:
>
> Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
>
>
>
> END.
>
4
Vantage's API isn't *really* intended to be consumed by someone who doesn't have access to the entire source code base. :-) BPMs are very much second-class citizens in the Vantage world.

And the BOs are *really* BOs in the way you would think about them, but basically veneers over the assemblies that each separate client program uses. Its not like there's a single BO say to manage TransferOrders, etc.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nigel Kerley
Sent: Wednesday, July 29, 2009 2:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM - 4GL Transferring data between 2 table fields. noob Question

I don't think you're doing anything wrong. I think it's that Vantage is not working the way you think it is.

If you turn off your BPM, turn on Tracing and follow the normal procedure, you'll see that Vantage actions the SalesOrder.CreateOrderFromQuote BO and immediately follows it with SalesOrder.GetByID BO.

I could be wrong, but I think Vantage is creating the order in the background without using the ttOrder tables and, once it's finished, it then loads in the now-created order onto the screen and into the tt tables for further user-editing.

You could try creating your BPM on the GetByID BO and maybe set a flag (say OrderHed.CheckBox01) within the BPM so that if this order is loaded in again you'll know you've already copied over the fields.

HTH,

Nigel.


--- In vantage@yahoogroups.com, "roomurray" <rupert@...> wrote:
>
> I created the following in Createorderfromquote in salesorder BO (For the pull)
> (most of which was taken from snippets of previous posts)
>
> Where have I gone wrong? the error log isn't exactly telling me what I've done wrong.
>
> Find QuoteDtl Where (QuoteDtl.Company = ttOrderDtl.Company) and
> (QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum) and
> (QuoteDtl.QuoteLine = ttOrderDtl.QuoteLine) no-lock.
>
> if avail QuoteDtl then do:
>
> Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
>
>
>
> END.
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
5
Are you putting that BPM on post Processing ? or pre processing? Here is a
BPM we have running on Pre=Processing it works fine. Take a look at how we
do it and see if it modifying it works for you.

Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
ttOrderDtl.QuoteLine NO-ERROR
IF NOT AMBIGUOUS part AND AVAILABLE part THEN
DO:
Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
END.

If that doesn't work move the BPM to a different place. IE Order getbyid or
Order Update.


Sincerely
Jose C Gomez

http://www.josecgomez.com


On Wed, Jul 29, 2009 at 2:28 PM, Brian W. Spolarich <
bspolarich@...> wrote:

>
>
> Vantage's API isn't *really* intended to be consumed by someone who doesn't
> have access to the entire source code base. :-) BPMs are very much
> second-class citizens in the Vantage world.
>
> And the BOs are *really* BOs in the way you would think about them, but
> basically veneers over the assemblies that each separate client program
> uses. Its not like there's a single BO say to manage TransferOrders, etc.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> bspolarich@... <bspolarich%40advancedphotonix.com> ~
> 734-864-5618 ~ www.advancedphotonix.com
>
> -----Original Message-----
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of Nigel
> Kerley
> Sent: Wednesday, July 29, 2009 2:21 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BPM - 4GL Transferring data between 2 table fields.
> noob Question
>
> I don't think you're doing anything wrong. I think it's that Vantage is not
> working the way you think it is.
>
> If you turn off your BPM, turn on Tracing and follow the normal procedure,
> you'll see that Vantage actions the SalesOrder.CreateOrderFromQuote BO and
> immediately follows it with SalesOrder.GetByID BO.
>
> I could be wrong, but I think Vantage is creating the order in the
> background without using the ttOrder tables and, once it's finished, it then
> loads in the now-created order onto the screen and into the tt tables for
> further user-editing.
>
> You could try creating your BPM on the GetByID BO and maybe set a flag (say
> OrderHed.CheckBox01) within the BPM so that if this order is loaded in again
> you'll know you've already copied over the fields.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, "roomurray"
> <rupert@...> wrote:
> >
> > I created the following in Createorderfromquote in salesorder BO (For the
> pull)
> > (most of which was taken from snippets of previous posts)
> >
> > Where have I gone wrong? the error log isn't exactly telling me what I've
> done wrong.
> >
> > Find QuoteDtl Where (QuoteDtl.Company = ttOrderDtl.Company) and
> > (QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum) and
> > (QuoteDtl.QuoteLine = ttOrderDtl.QuoteLine) no-lock.
> >
> > if avail QuoteDtl then do:
> >
> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> >
> >
> >
> > END.
> >
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]
6
Thanks for the replies

I'm running this as a pre processing

I've tried it on getbyid and orderupdate (both pre and post) but the field data is not being transferred.

I can't work out where i'm going wrong - (there's data in the quotedtl.shortchar01!!)

(i'm using 8.3.405)

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Are you putting that BPM on post Processing ? or pre processing? Here is a
> BPM we have running on Pre=Processing it works fine. Take a look at how we
> do it and see if it modifying it works for you.
>
> Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> ttOrderDtl.QuoteLine NO-ERROR
> IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> DO:
> Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> END.
>
> If that doesn't work move the BPM to a different place. IE Order getbyid or
> Order Update.
>
>
> Sincerely
> Jose C Gomez
7
Oh yeah and at the end do OUTPUT close.
Sincerely
Jose C Gomez

http://www.josecgomez.com
Sent from Jacksonville, FL, United States

On Thu, Jul 30, 2009 at 9:04 AM, Jose Gomez <jose@...> wrote:

> Are you sure the BPM is being triggered? If you are not try putting this
> code in the BPM to test
>
> OUTPUT To "C:\Debug.Txt" Append.
>
> Then whwnever you want to put something there use
> EXPORT "EQUALS " (orderdtl.unitprice * orderdtl.orderqty)
>
> For example using the BPM above you could do soemthing llike this.
>
> OUTPUT To "C:\Debug.Txt" Append.
> EXPORT "BPM FIRED".
> Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> ttOrderDtl.QuoteLine NO-ERROR
> IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> DO:
> EXPORT "FOUND".
> Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> EXPORT "ASSIGNED"
> END.
> EXPORT "DONE".
>
>
>
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
>
> On Thu, Jul 30, 2009 at 5:56 AM, roomurray <rupert@...>wrote:
>
>>
>>
>>
>>
>> Thanks for the replies
>>
>> I'm running this as a pre processing
>>
>> I've tried it on getbyid and orderupdate (both pre and post) but the field
>> data is not being transferred.
>>
>> I can't work out where i'm going wrong - (there's data in the
>> quotedtl.shortchar01!!)
>>
>> (i'm using 8.3.405)
>>
>> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Jose Gomez
>> <jose@...> wrote:
>> >
>> > Are you putting that BPM on post Processing ? or pre processing? Here is
>> a
>> > BPM we have running on Pre=Processing it works fine. Take a look at how
>> we
>> > do it and see if it modifying it works for you.
>> >
>> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
>> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
>> > ttOrderDtl.QuoteLine NO-ERROR
>> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
>> > DO:
>> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
>> > END.
>> >
>> > If that doesn't work move the BPM to a different place. IE Order getbyid
>> or
>> > Order Update.
>> >
>> >
>> > Sincerely
>> > Jose C Gomez
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
8
Are you sure the BPM is being triggered? If you are not try putting this
code in the BPM to test

OUTPUT To "C:\Debug.Txt" Append.

Then whwnever you want to put something there use
EXPORT "EQUALS " (orderdtl.unitprice * orderdtl.orderqty)

For example using the BPM above you could do soemthing llike this.

OUTPUT To "C:\Debug.Txt" Append.
EXPORT "BPM FIRED".
Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
ttOrderDtl.QuoteLine NO-ERROR
IF NOT AMBIGUOUS part AND AVAILABLE part THEN
DO:
EXPORT "FOUND".
Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
EXPORT "ASSIGNED"
END.
EXPORT "DONE".




Sincerely
Jose C Gomez

http://www.josecgomez.com


On Thu, Jul 30, 2009 at 5:56 AM, roomurray <rupert@...> wrote:

>
>
>
>
> Thanks for the replies
>
> I'm running this as a pre processing
>
> I've tried it on getbyid and orderupdate (both pre and post) but the field
> data is not being transferred.
>
> I can't work out where i'm going wrong - (there's data in the
> quotedtl.shortchar01!!)
>
> (i'm using 8.3.405)
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Jose Gomez
> <jose@...> wrote:
> >
> > Are you putting that BPM on post Processing ? or pre processing? Here is
> a
> > BPM we have running on Pre=Processing it works fine. Take a look at how
> we
> > do it and see if it modifying it works for you.
> >
> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> > ttOrderDtl.QuoteLine NO-ERROR
> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> > DO:
> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> > END.
> >
> > If that doesn't work move the BPM to a different place. IE Order getbyid
> or
> > Order Update.
> >
> >
> > Sincerely
> > Jose C Gomez
>
>
>


[Non-text portions of this message have been removed]
9
I'm Still struggling with this one!! Although some of your suggestions work and the data in the order field in the display screen is shown - the data is not in fact written to the new table! Wierd I know!

I've had Epicor onto this and they came back with the same results as I have had. (which I'm kind of glad about!!!)

If I can find anything else out on this I will let you know.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Oh yeah and at the end do OUTPUT close.
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
> Sent from Jacksonville, FL, United States
>
> On Thu, Jul 30, 2009 at 9:04 AM, Jose Gomez <jose@...> wrote:
>
> > Are you sure the BPM is being triggered? If you are not try putting this
> > code in the BPM to test
> >
> > OUTPUT To "C:\Debug.Txt" Append.
> >
> > Then whwnever you want to put something there use
> > EXPORT "EQUALS " (orderdtl.unitprice * orderdtl.orderqty)
> >
> > For example using the BPM above you could do soemthing llike this.
> >
> > OUTPUT To "C:\Debug.Txt" Append.
> > EXPORT "BPM FIRED".
> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> > ttOrderDtl.QuoteLine NO-ERROR
> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> > DO:
> > EXPORT "FOUND".
> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> > EXPORT "ASSIGNED"
> > END.
> > EXPORT "DONE".
> >
> >
> >
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> >
> > On Thu, Jul 30, 2009 at 5:56 AM, roomurray <rupert@...>wrote:
> >
> >>
> >>
> >>
> >>
> >> Thanks for the replies
> >>
> >> I'm running this as a pre processing
> >>
> >> I've tried it on getbyid and orderupdate (both pre and post) but the field
> >> data is not being transferred.
> >>
> >> I can't work out where i'm going wrong - (there's data in the
> >> quotedtl.shortchar01!!)
> >>
> >> (i'm using 8.3.405)
> >>
> >> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Jose Gomez
> >> <jose@> wrote:
> >> >
> >> > Are you putting that BPM on post Processing ? or pre processing? Here is
> >> a
> >> > BPM we have running on Pre=Processing it works fine. Take a look at how
> >> we
> >> > do it and see if it modifying it works for you.
> >> >
> >> > Find QuoteDtl WHERE QuoteDtl.Company=ttOrderDtl.Company AND
> >> > QuoteDtl.QuoteNum = ttOrderDtl.QuoteNum AND QuoteDtl.QuoteLine =
> >> > ttOrderDtl.QuoteLine NO-ERROR
> >> > IF NOT AMBIGUOUS part AND AVAILABLE part THEN
> >> > DO:
> >> > Assign ttorderdtl.ShortChar01 = Quotedtl.shortchar01.
> >> > END.
> >> >
> >> > If that doesn't work move the BPM to a different place. IE Order getbyid
> >> or
> >> > Order Update.
> >> >
> >> >
> >> > Sincerely
> >> > Jose C Gomez
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>