Customization - how to autopopulate fields in a UD table

I was working on something similar. What you need is the UD03Adapter, not the InvTransferAdapter. This is how it should look:

Dim varUD03Adapter As UD03Adapter = New UD03Adapter(RecptToInvEntry)

Instead of "BAQReportForm", use "RecptToInvEntry". That is the name of the form you are calling the adapter from. In this case if you want to use the Job Receipt To Inventory form. (I'm fairly new, but I'm pretty sure I have the right name there.)

Where he has UD101, you want UD03. He only used UD10 once, as a declared name, so it didn't really have anything to do with the table. As you can see by his code, you can substitute any field name in the UD03 table and assign a value to it. The only restriction is the Key 1 field, or combination of key fields need to be unique, if I understand that correctly. I haven't done this exact thing, so no guarantees.

I hope that helps.


--- In vantage@yahoogroups.com, "Karen Schoenung" <kschoenung@...> wrote:
>
> Sean,
>
>
>
> I am getting back to this now, but don't quite understand the code...
>
>
>
> I am using UD03 as the child table and want to use the information on
> the Job Receipt to Inventory form to populate Key1, Key 2 and Key5,
> while entering values for Key3 and Key4.
>
>
>
> I think I would use UD03 where you have UD10...
>
>
>
> I think this would be my Dim statement:
>
> Dim varUD03Adapter As InvTransferAdapter = New
> InvTransferAdapter(BAQReportForm)
>
>
>
> I do not understand what should be listed in place of UD101 in reference
> to the Job Receipt to Inventory form...Or does this code only work with
> UD tables as parent/child?
>
> Please help if you get a moment.
>
> Thanks,
>
> Karen
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Sean McDaniel
> Sent: Tuesday, March 16, 2010 7:03 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Customization - how to autopopulate fields in a
> UD table
>
>
>
>
>
> BPM's can't insert records into another table. However, this can be done
> via
> customization.
>
> You can use the adapters to do this.
>
> Here is a tiny snippet showing some of the code to do this. You can set
> up
> the UD101 UI in a menu and then do a trace to get the exact method calls
> that are made.
>
> --Sean
>
> Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)
>
> varUD10Adapter.BOConnect()
>
> if varUD10Adapter.GetaNewUD101()=true then
>
> varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text
>
> varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text
>
> varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text
>
> varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
> RandomClass.Next().tostring()
>
> varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty
>
> Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")
>
> 'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
> """"""
>
> varUD10Adapter.Update()
>
> end if
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> advantage@... <mailto:advantage%40wcoil.com>
> Sent: Tuesday, March 16, 2010 5:20 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Customization - how to autopopulate fields in a
> UD
> table
>
> Based on what data a BPM will do
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "karen_schoenung" <kschoenung@...
> <mailto:kschoenung%40fisher-barton.com>
> <mailto:kschoenung%40fisher-barton.com> >
> Date: Tue, 16 Mar 2010 21:04:16
> To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> >
> Subject: [Vantage] Customization - how to autopopulate fields in a UD
> table
>
> How can I autopopulate fields in a UD table based on current record from
> another form?
>
> Thx in advance.
>
> [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]
>
How can I autopopulate fields in a UD table based on current record from another form?

Thx in advance.
Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...>
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com>
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from another form?

Thx in advance.




[Non-text portions of this message have been removed]
BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean



Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table





Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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





[Non-text portions of this message have been removed]
BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table





BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

[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]
Actually they can now. Epicor has renegotiated a new license with Progress for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches) in my test environment, but it worked. I've been too nervous to inflict it on my production environment.

Support should be able to assist in getting you the updated license code.

--
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 Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table





BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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



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

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
That is AWESOME! (Scary but AWESOME!) :o)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, March 17, 2010 2:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table





Actually they can now. Epicor has renegotiated a new license with Progress
for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches)
in my test environment, but it worked. I've been too nervous to inflict it
on my production environment.

Support should be able to assist in getting you the updated license code.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
<mailto:advantage%40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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]
Brian, Can I ask what version? Do you have more documentation on this or can
you tell me where to get it?

Thanks,

Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, March 17, 2010 2:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table





Actually they can now. Epicor has renegotiated a new license with Progress
for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches)
in my test environment, but it worked. I've been too nervous to inflict it
on my production environment.

Support should be able to assist in getting you the updated license code.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
<mailto:advantage%40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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]
I saw this post once before and called my Epicor rep. He checked into it and no one at Epicor seems to know anything about a new Progress license for Vantage. Is there any more information about this you could share with us? I would be really interested in this.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Wed, March 17, 2010 2:11:34 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

Â
Actually they can now. Epicor has renegotiated a new license with Progress for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches) in my test environment, but it worked. I've been too nervous to inflict it on my production environment.

Support should be able to assist in getting you the updated license code.

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

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter( BAQReportForm)

varUD10Adapter. BOConnect( )

if varUD10Adapter. GetaNewUD101( )=true then

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key1") = Key1.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key2") = Key2.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key3") = Key3.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4") =
RandomClass. Next().tostring( )

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key5") = String.Empty

Key4.text = varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4")

'varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Character01" ) =
""""""

varUD10Adapter. Update()

end if

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
advantage@wcoil. com <mailto:advantage% 40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@fisher- barton.com
<mailto:kschoenung% 40fisher- barton.com>
<mailto:kschoenung% 40fisher- barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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







[Non-text portions of this message have been removed]
My CAM (Jeff Larson) knew about it, and James Nalls in Tech Support was able to help me install it. Some of the CAMs may be out of the loop…ask them to ask Jeff Larson maybe? J



-bws





Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

bspolarich@... <mailto:bspolarich@...> ~ 734-864-5618 ~ www.advancedphotonix.com <http://www.advancedphotonix.com>



From: Steven Gotschall [mailto:sgotschall@...]
Sent: Wednesday, March 17, 2010 2:22 PM
To: vantage@yahoogroups.com
Cc: Brian W. Spolarich
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD table



I saw this post once before and called my Epicor rep. He checked into it and no one at Epicor seems to know anything about a new Progress license for Vantage. Is there any more information about this you could share with us? I would be really interested in this.



________________________________

From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Wed, March 17, 2010 2:11:34 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table



Actually they can now. Epicor has renegotiated a new license with Progress for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches) in my test environment, but it worked. I've been too nervous to inflict it on my production environment.

Support should be able to assist in getting you the updated license code.



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com <mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~ www.advancedphotoni x.com <http://x.com/>

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter( BAQReportForm)

varUD10Adapter. BOConnect( )

if varUD10Adapter. GetaNewUD101( )=true then

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key1") = Key1.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key2") = Key2.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key3") = Key3.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4") =
RandomClass. Next().tostring( )

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key5") = String.Empty

Key4.text = varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4")

'varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Character01" ) =
""""""

varUD10Adapter. Update()

end if

From: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
advantage@wcoil. com <mailto:advantage%40wcoil.com> <mailto:advantage% 40wcoil.com <http://40wcoil.com/> >
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@fisher- barton.com <mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung% 40fisher- barton.com <http://barton.com/> >
<mailto:kschoenung% 40fisher- barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups .com <mailto:vantage%40yahoogroups.com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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 <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 <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links







[Non-text portions of this message have been removed]
Thanks for the info Brian.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: Steven Gotschall <sgotschall@...>; vantage@yahoogroups.com
Sent: Wed, March 17, 2010 2:36:20 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

Â
My CAM (Jeff Larson) knew about it, and James Nalls in Tech Support was able to help me install it. Some of the CAMs may be out of the loop…ask them to ask Jeff Larson maybe? J



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

bspolarich@advanced photonix. com <mailto:bspolarich@advanced photonix. com> ~ 734-864-5618 ~ www.advancedphotoni x.com <http://www.advanced photonix. com>



From: Steven Gotschall [mailto:sgotschall@yahoo. com]
Sent: Wednesday, March 17, 2010 2:22 PM
To: vantage@yahoogroups .com
Cc: Brian W. Spolarich
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD table



I saw this post once before and called my Epicor rep. He checked into it and no one at Epicor seems to know anything about a new Progress license for Vantage. Is there any more information about this you could share with us? I would be really interested in this.



____________ _________ _________ __

From: Brian W. Spolarich <bspolarich@advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Wed, March 17, 2010 2:11:34 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table



Actually they can now. Epicor has renegotiated a new license with Progress for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches) in my test environment, but it worked. I've been too nervous to inflict it on my production environment.

Support should be able to assist in getting you the updated license code.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com <mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~ www.advancedphotoni x.com <http://x.com/>

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> [mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> [mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter( BAQReportForm)

varUD10Adapter. BOConnect( )

if varUD10Adapter. GetaNewUD101( )=true then

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key1") = Key1.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key2") = Key2.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key3") = Key3.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4") =
RandomClass. Next().tostring( )

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key5") = String.Empty

Key4.text = varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4")

'varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Character01" ) =
""""""

varUD10Adapter. Update()

end if

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
advantage@wcoil. com <mailto:advantage% 40wcoil.com> <mailto:advantage% 40wcoil.com <http://40wcoil. com/> >
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@ fisher- barton.com <mailto:kschoenung% 40fisher- barton.com>
<mailto:kschoenung% 40fisher- barton.com <http://barton. com/> >
<mailto:kschoenung% 40fisher- barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroup s .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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 <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 <http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links






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







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

I got my license today. Here is what it said in the PDF:

Dear Valued Epicor Customer,
Â
Epicor is pleased to deliver the OpenEdge 10.1b 4GL Licenses for use within the Epicor Framework to simplify
your next upgrade of Epicor Software. The software is included in your OpenEdge 10.1b DVD. Your license
code to access the 4GL license is below.
 xxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
 This license is intended to support additional Business Process Management(BPM) and Business Activity
Management(BAM) functionality in Epicor’s Vantage and Vista 8.03.4x applications. This license allows BPM
and BAM business processes the ability to manipulate data (Create/Update/Delete) in addition to the query
(Read) functionality. THIS LICENSE IS LIMITED TO USE WITHIN THE EPICOR FRAMEWORK ONLY and may
not be invoked by anyone or any application outside of the Epicor framework.
Â
OpenEdge Studio or OpenEdge Architect continue to be required for use with the Epicor SDK. These robust
development environments will continue to be recommended for advanced functionality such as structured
procedures, methods, and web service creation.
Â
If you have questions regarding the limited use of the OpenEdge 4GL licenses, please contact your customer
account manager.



________________________________
From: Brian W. Spolarich <bspolarich@...>
To: Steven Gotschall <sgotschall@...>; vantage@yahoogroups.com
Sent: Wed, March 17, 2010 2:36:20 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

Â
My CAM (Jeff Larson) knew about it, and James Nalls in Tech Support was able to help me install it. Some of the CAMs may be out of the loop…ask them to ask Jeff Larson maybe? J



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

bspolarich@advanced photonix. com <mailto:bspolarich@advanced photonix. com> ~ 734-864-5618 ~ www.advancedphotoni x.com <http://www.advanced photonix. com>



From: Steven Gotschall [mailto:sgotschall@yahoo. com]
Sent: Wednesday, March 17, 2010 2:22 PM
To: vantage@yahoogroups .com
Cc: Brian W. Spolarich
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD table



I saw this post once before and called my Epicor rep. He checked into it and no one at Epicor seems to know anything about a new Progress license for Vantage. Is there any more information about this you could share with us? I would be really interested in this.



____________ _________ _________ __

From: Brian W. Spolarich <bspolarich@advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Wed, March 17, 2010 2:11:34 PM
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table



Actually they can now. Epicor has renegotiated a new license with Progress for OpenEdge that will enable you to CREATE records.

Basically it required me to reinstall OpenEdge (and all of the SPs/patches) in my test environment, but it worked. I've been too nervous to inflict it on my production environment.

Support should be able to assist in getting you the updated license code.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com <mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~ www.advancedphotoni x.com <http://x.com/>

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> [mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On Behalf Of Sean McDaniel
Sent: Wednesday, March 17, 2010 7:06 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD table

BPM's can't insert using 4GL code, but you can create a BPM that uses the
business objects to do this.

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> [mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On Behalf Of
Sean McDaniel
Sent: Tuesday, March 16, 2010 8:03 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Customization - how to autopopulate fields in a UD
table

BPM's can't insert records into another table. However, this can be done via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter( BAQReportForm)

varUD10Adapter. BOConnect( )

if varUD10Adapter. GetaNewUD101( )=true then

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key1") = Key1.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key2") = Key2.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key3") = Key3.text

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4") =
RandomClass. Next().tostring( )

varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key5") = String.Empty

Key4.text = varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Key4")

'varUD10Adapter. UD101Data. Tables("UD101" ).Rows(0) ("Character01" ) =
""""""

varUD10Adapter. Update()

end if

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
advantage@wcoil. com <mailto:advantage% 40wcoil.com> <mailto:advantage% 40wcoil.com <http://40wcoil. com/> >
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@ fisher- barton.com <mailto:kschoenung% 40fisher- barton.com>
<mailto:kschoenung% 40fisher- barton.com <http://barton. com/> >
<mailto:kschoenung% 40fisher- barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroup s .com <mailto:vantage% 40yahoogroups. com> <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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

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

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 <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 <http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links






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







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



I am getting back to this now, but don't quite understand the code...



I am using UD03 as the child table and want to use the information on
the Job Receipt to Inventory form to populate Key1, Key 2 and Key5,
while entering values for Key3 and Key4.



I think I would use UD03 where you have UD10...



I think this would be my Dim statement:

Dim varUD03Adapter As InvTransferAdapter = New
InvTransferAdapter(BAQReportForm)



I do not understand what should be listed in place of UD101 in reference
to the Job Receipt to Inventory form...Or does this code only work with
UD tables as parent/child?

Please help if you get a moment.

Thanks,

Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Tuesday, March 16, 2010 7:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization - how to autopopulate fields in a
UD table





BPM's can't insert records into another table. However, this can be done
via
customization.

You can use the adapters to do this.

Here is a tiny snippet showing some of the code to do this. You can set
up
the UD101 UI in a menu and then do a trace to get the exact method calls
that are made.

--Sean

Dim varUD10Adapter As UD101Adapter = New UD101Adapter(BAQReportForm)

varUD10Adapter.BOConnect()

if varUD10Adapter.GetaNewUD101()=true then

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key1") = Key1.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key2") = Key2.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key3") = Key3.text

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4") =
RandomClass.Next().tostring()

varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key5") = String.Empty

Key4.text = varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Key4")

'varUD10Adapter.UD101Data.Tables("UD101").Rows(0)("Character01") =
""""""

varUD10Adapter.Update()

end if

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
Sent: Tuesday, March 16, 2010 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Customization - how to autopopulate fields in a
UD
table

Based on what data a BPM will do
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "karen_schoenung" <kschoenung@...
<mailto:kschoenung%40fisher-barton.com>
<mailto:kschoenung%40fisher-barton.com> >
Date: Tue, 16 Mar 2010 21:04:16
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: [Vantage] Customization - how to autopopulate fields in a UD
table

How can I autopopulate fields in a UD table based on current record from
another form?

Thx in advance.

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