User Defined Tables

Yahoo Archive
21
Is there a way to have a number randomly generated to uniquely identify a record on a user defined table? For instance, when a user goes into UD01 maintenance and clicks the "New" icon, I would like the key1 field to be populated with a unique value.  When the first user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 001. When a second user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 002. And so on. Any thoughts on how this can be accomplished?

THanks,

Dustin Biniek




[Non-text portions of this message have been removed]
22
Here's my reply to this question, which is definitely a FAQ at this point. You could easily adapt this for UD* tables.

-bws

http://groups.yahoo.com/group/vantage/files/Vantage%208.X%20Customizations/CustVendID.zip

This is a customization we're using to auto-set CustID and VendorID for new records. It get triggered when the client clicks on the "new" button. The next available ID for Customers and Vendors is stored in Company.Number01 and Company.Number02 respectively and incremented.

You could modify this code to add a prefix to your IDs. To set a particular starting value just modify Company.Number01, etc. for your company.

One thing that could improve this is to roll back the increment if the new record isn't actually saved. You will have gaps in your sequence if someone hits "New" and then doesn't actually create a new record, and this can make auditors nervous.

-bws

If (args.NotifyType = EpiTransaction.NotifyType.AddRow) Then
If (args.Row > -1) Then
Dim compAdapt As CompanyAdapter = New CompanyAdapter(CustomerEntryForm)
compAdapt.BOConnect()
Dim company As String = CustomerEntryForm.Session.CompanyID
Dim ret As Boolean = compAdapt.GetByID(company)

Dim newCompID As Integer = compAdapt.CompanyData.Tables("Company").Rows(0)("Number01")

view.dataView(args.Row)("CustID") = newCompID.ToString()
view.Notify(New EpiNotifyArgs(CustomerEntryForm, view.Row, view.Column))

newCompID = newCompID + 1

compAdapt.CompanyData.Tables("Company").Rows(0).BeginEdit()
compAdapt.CompanyData.Tables("Company").Rows(0)("Number01") = newCompID
compAdapt.CompanyData.Tables("Company").Rows(0).EndEdit()

compAdapt.Update()

compAdapt.Dispose()


End If
End If

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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nick
Sent: Monday, February 02, 2009 9:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Auto Calculating Customer/Supplier ID

Is anybody out there using a customization to automatically generate Customer or Supplier ID's?

I would like to have Customer and Supplier ID's generated automatically upon creation of a new record. They would be a 6 digit number with a prefix of S or C. I basically need to find the highest number and increment it by one.

Is this a job for BPM, or would a button with some VB be necessary? Or could I drive it off of the CustNum record generated by Vantage?

Thanks for the help!

Nick

--
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 melissa hietala
Sent: Monday, February 15, 2010 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] User Defined Tables

Is there a way to have a number randomly generated to uniquely identify a record on a user defined table? For instance, when a user goes into UD01 maintenance and clicks the "New" icon, I would like the key1 field to be populated with a unique value.  When the first user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 001. When a second user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 002. And so on. Any thoughts on how this can be accomplished?
23
Goodmorning,

I am attempting to setup the following code so that when a user creates a new record on the "UD01" table, a unique # will automatically be generated into a UD field on the table. However, I keep getting an error which states: "Type 'CompanyAdapter' is not defined." Any thoughts on where I may be going wrong on this and how I can fix it?

Thanks,
Dustin Biniek

Private Sub edvUD01_EpiViewNotification(view As EpiDataView, args As EpiNotifyArgs) Handles edvUD01.EpiViewNotification
  '// ** Argument Properties and Uses **
  '// view.dataView(args.Row)("[FieldName]")
  '// args.Row, args.Column, args.Sender, args.NotifyType
  '// NotifyType.Initialize, NotifyType.AddRow, NotifyType.DeleteRow, NotifyType.InitLastView, NotifyType.InitAndResetTreeNodes
    If (args.NotifyType = EpiTransaction.NotifyType.AddRow) Then
           If (args.Row > -1) Then
               Dim compAdapt As CompanyAdapter = New CompanyAdapter(UD01Form)
               compAdapt.BOConnect()
               Dim company As String = UD01Form.Session.CompanyID
               Dim ret As Boolean = compAdapt.GetByID(company)
              Â
               Dim newCompID As Integer = compAdapt.CompanyData.Tables("Company").Rows(0)("Number01")
             Â
               view.dataView(args.Row)("ShorChar01") = newCompID.ToString()
               view.Notify(New EpiNotifyArgs(UD01Form, view.Row, view.Column))
              Â
               newCompID = newCompID + 1
              Â
               compAdapt.CompanyData.Tables("Company").Rows(0).BeginEdit()
               compAdapt.CompanyData.Tables("Company").Rows(0)("Number01") = newCompID
               compAdapt.CompanyData.Tables("Company").Rows(0).EndEdit()
              Â
               compAdapt.Update()
              Â
               compAdapt.Dispose()
  Â
  Â
           End If
       End If
   End Sub
Â
Dustin Biniek




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Mon, February 15, 2010 3:12:42 PM
Subject: RE: [Vantage] User Defined Tables

Â
Here's my reply to this question, which is definitely a FAQ at this point. You could easily adapt this for UD* tables.

-bws

http://groups. yahoo.com/ group/vantage/ files/Vantage% 208.X%20Customiz ations/CustVendI D.zip

This is a customization we're using to auto-set CustID and VendorID for new records. It get triggered when the client clicks on the "new" button. The next available ID for Customers and Vendors is stored in Company.Number01 and Company.Number02 respectively and incremented.

You could modify this code to add a prefix to your IDs. To set a particular starting value just modify Company.Number01, etc. for your company.

One thing that could improve this is to roll back the increment if the new record isn't actually saved. You will have gaps in your sequence if someone hits "New" and then doesn't actually create a new record, and this can make auditors nervous.

-bws

If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
If (args.Row > -1) Then
Dim compAdapt As CompanyAdapter = New CompanyAdapter( CustomerEntryFor m)
compAdapt.BOConnect ()
Dim company As String = CustomerEntryForm. Session.CompanyI D
Dim ret As Boolean = compAdapt.GetByID( company)

Dim newCompID As Integer = compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" )

view.dataView( args.Row) ("CustID" ) = newCompID.ToString( )
view.Notify( New EpiNotifyArgs( CustomerEntryFor m, view.Row, view.Column) )

newCompID = newCompID + 1

compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .BeginEdit( )
compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" ) = newCompID
compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .EndEdit( )

compAdapt.Update( )

compAdapt.Dispose( )


End If
End If

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

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Nick
Sent: Monday, February 02, 2009 9:14 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Auto Calculating Customer/Supplier ID

Is anybody out there using a customization to automatically generate Customer or Supplier ID's?

I would like to have Customer and Supplier ID's generated automatically upon creation of a new record. They would be a 6 digit number with a prefix of S or C. I basically need to find the highest number and increment it by one.

Is this a job for BPM, or would a button with some VB be necessary? Or could I drive it off of the CustNum record generated by Vantage?

Thanks for the help!

Nick

--
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 melissa hietala
Sent: Monday, February 15, 2010 2:54 PM
To: vantage@yahoogroups .com
Subject: [Vantage] User Defined Tables

Is there a way to have a number randomly generated to uniquely identify a record on a user defined table? For instance, when a user goes into UD01 maintenance and clicks the "New" icon, I would like the key1 field to be populated with a unique value.  When the first user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 001. When a second user goes into UD01 maintenance and creates a new record, the "Key1" field would be assigned a value of 002. And so on. Any thoughts on how this can be accomplished?







[Non-text portions of this message have been removed]
24
You need to add the three company dll files as custom assembly
references.

Ross


On Feb 25, 2010, at 8:28 AM, melissa hietala <kevmel822@...>
wrote:

> Goodmorning,
>
> I am attempting to setup the following code so that when a user
> creates a new record on the "UD01" table, a unique # will
> automatically be generated into a UD field on the table. However, I
> keep getting an error which states: "Type 'CompanyAdapter' is not
> defined." Any thoughts on where I may be going wrong on this and
> how I can fix it?
>
> Thanks,
> Dustin Biniek
>
> Private Sub edvUD01_EpiViewNotification(view As EpiDataView, args As
> EpiNotifyArgs) Handles edvUD01.EpiViewNotification
> '// ** Argument Properties and Uses **
> '// view.dataView(args.Row)("[FieldName]")
> '// args.Row, args.Column, args.Sender, args.NotifyType
> '// NotifyType.Initialize, NotifyType.AddRow,
> NotifyType.DeleteRow, NotifyType.InitLastView,
> NotifyType.InitAndResetTreeNodes
> If (args.NotifyType = EpiTransaction.NotifyType.AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> (UD01Form)
> compAdapt.BOConnect()
> Dim company As String = UD01Form.Session.CompanyID
> Dim ret As Boolean = compAdapt.GetByID(company)
>
> Dim newCompID As Integer =
> compAdapt.CompanyData.Tables("Company").Rows(0)("Number01")
>
> view.dataView(args.Row)("ShorChar01") =
> newCompID.ToString()
> view.Notify(New EpiNotifyArgs(UD01Form, view.Row,
> view.Column))
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyData.Tables("Company").Rows
> (0).BeginEdit()
> compAdapt.CompanyData.Tables("Company").Rows(0)
> ("Number01") = newCompID
> compAdapt.CompanyData.Tables("Company").Rows
> (0).EndEdit()
>
> compAdapt.Update()
>
> compAdapt.Dispose()
>
>
> End If
> End If
> End Sub
>
> Dustin Biniek
>
>
>
>
> ________________________________
> From: Brian W. Spolarich <bspolarich@...>
> To: vantage@yahoogroups.com
> Sent: Mon, February 15, 2010 3:12:42 PM
> Subject: RE: [Vantage] User Defined Tables
>
>
> Here's my reply to this question, which is definitely a FAQ at this
> point. You could easily adapt this for UD* tables.
>
> -bws
>
> http://groups. yahoo.com/ group/vantage/ files/Vantage% 208.X
> %20Customiz ations/CustVendI D.zip
>
> This is a customization we're using to auto-set CustID and VendorID
> for new records. It get triggered when the client clicks on the
> "new" button. The next available ID for Customers and Vendors is
> stored in Company.Number01 and Company.Number02 respectively and
> incremented.
>
> You could modify this code to add a prefix to your IDs. To set a
> particular starting value just modify Company.Number01, etc. for
> your company.
>
> One thing that could improve this is to roll back the increment if
> the new record isn't actually saved. You will have gaps in your
> sequence if someone hits "New" and then doesn't actually create a
> new record, and this can make auditors nervous.
>
> -bws
>
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> ( CustomerEntryFor m)
> compAdapt.BOConnect ()
> Dim company As String = CustomerEntryForm. Session.CompanyI D
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer = compAdapt.CompanyDa ta.Tables
> ( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("CustID" ) = newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( CustomerEntryFor m, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" ) =
> newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> bspolarich@advanced photonix. com ~ 734-864-5618 ~
> www.advancedphotoni x.com
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf Of Nick
> Sent: Monday, February 02, 2009 9:14 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Auto Calculating Customer/Supplier ID
>
> Is anybody out there using a customization to automatically generate
> Customer or Supplier ID's?
>
> I would like to have Customer and Supplier ID's generated
> automatically upon creation of a new record. They would be a 6 digit
> number with a prefix of S or C. I basically need to find the highest
> number and increment it by one.
>
> Is this a job for BPM, or would a button with some VB be necessary?
> Or could I drive it off of the CustNum record generated by Vantage?
>
> Thanks for the help!
>
> Nick
>
> --
> 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 melissa hietala
> Sent: Monday, February 15, 2010 2:54 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] User Defined Tables
>
> Is there a way to have a number randomly generated to uniquely
> identify a record on a user defined table? For instance, when a
> user goes into UD01 maintenance and clicks the "New" icon, I would
> like the key1 field to be populated with a unique value. When the
> first user goes into UD01 maintenance and creates a new record, the
> "Key1" field would be assigned a value of 001. When a second user
> goes into UD01 maintenance and creates a new record, the "Key1"
> field would be assigned a value of 002. And so on. Any thoughts on
> how this can be accomplished?
>
>
>
>
>
>
>
> [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
>
>
>
25
Ross,

I'm not exactly sure how I would go about doing this. Could you give me an example???

Thanks,

Dustin Biniek




________________________________
From: Ross Hughes <ross.hughes@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, February 25, 2010 8:46:13 AM
Subject: Re: [Vantage] User Defined Tables

Â
You need to add the three company dll files as custom assembly
references.

Ross

On Feb 25, 2010, at 8:28 AM, melissa hietala <kevmel822@yahoo. com>
wrote:

> Goodmorning,
>
> I am attempting to setup the following code so that when a user
> creates a new record on the "UD01" table, a unique # will
> automatically be generated into a UD field on the table. However, I
> keep getting an error which states: "Type 'CompanyAdapter' is not
> defined." Any thoughts on where I may be going wrong on this and
> how I can fix it?
>
> Thanks,
> Dustin Biniek
>
> Private Sub edvUD01_EpiViewNoti fication( view As EpiDataView, args As
> EpiNotifyArgs) Handles edvUD01.EpiViewNoti fication
> '// ** Argument Properties and Uses **
> '// view.dataView( args.Row) ("[FieldName] ")
> '// args.Row, args.Column, args.Sender, args.NotifyType
> '// NotifyType.Initiali ze, NotifyType.AddRow,
> NotifyType.DeleteRo w, NotifyType.InitLast View,
> NotifyType.InitAndR esetTreeNodes
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> (UD01Form)
> compAdapt.BOConnect ()
> Dim company As String = UD01Form.Session. CompanyID
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer =
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("ShorChar01" ) =
> newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( UD01Form, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0)
> ("Number01") = newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
> End Sub
>
> Dustin Biniek
>
>
>
>
> ____________ _________ _________ __
> From: Brian W. Spolarich <bspolarich@advanced photonix. com>
> To: vantage@yahoogroups .com
> Sent: Mon, February 15, 2010 3:12:42 PM
> Subject: RE: [Vantage] User Defined Tables
>
>
> Here's my reply to this question, which is definitely a FAQ at this
> point. You could easily adapt this for UD* tables.
>
> -bws
>
> http://groups. yahoo.com/ group/vantage/ files/Vantage% 208.X
> %20Customiz ations/CustVendI D.zip
>
> This is a customization we're using to auto-set CustID and VendorID
> for new records. It get triggered when the client clicks on the
> "new" button. The next available ID for Customers and Vendors is
> stored in Company.Number01 and Company.Number02 respectively and
> incremented.
>
> You could modify this code to add a prefix to your IDs. To set a
> particular starting value just modify Company.Number01, etc. for
> your company.
>
> One thing that could improve this is to roll back the increment if
> the new record isn't actually saved. You will have gaps in your
> sequence if someone hits "New" and then doesn't actually create a
> new record, and this can make auditors nervous.
>
> -bws
>
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> ( CustomerEntryFor m)
> compAdapt.BOConnect ()
> Dim company As String = CustomerEntryForm. Session.CompanyI D
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer = compAdapt.CompanyDa ta.Tables
> ( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("CustID" ) = newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( CustomerEntryFor m, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" ) =
> newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> bspolarich@advanced photonix. com ~ 734-864-5618 ~
> www.advancedphotoni x.com
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Nick
> Sent: Monday, February 02, 2009 9:14 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Auto Calculating Customer/Supplier ID
>
> Is anybody out there using a customization to automatically generate
> Customer or Supplier ID's?
>
> I would like to have Customer and Supplier ID's generated
> automatically upon creation of a new record. They would be a 6 digit
> number with a prefix of S or C. I basically need to find the highest
> number and increment it by one.
>
> Is this a job for BPM, or would a button with some VB be necessary?
> Or could I drive it off of the CustNum record generated by Vantage?
>
> Thanks for the help!
>
> Nick
>
> --
> 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 melissa hietala
> Sent: Monday, February 15, 2010 2:54 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] User Defined Tables
>
> Is there a way to have a number randomly generated to uniquely
> identify a record on a user defined table? For instance, when a
> user goes into UD01 maintenance and clicks the "New" icon, I would
> like the key1 field to be populated with a unique value. When the
> first user goes into UD01 maintenance and creates a new record, the
> "Key1" field would be assigned a value of 001. When a second user
> goes into UD01 maintenance and creates a new record, the "Key1"
> field would be assigned a value of 002. And so on. Any thoughts on
> how this can be accomplished?
>
>
>
>
>
>
>
> [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]
26
Sure. In Developer Mode, enter your customization and select Assembly Reference Manager from the Tools menu.

Press the Add Custom Reference button and add the following three files. Press OK and test your customization.

Epicor.Mfg.AD.Company.dll
Epicor.Mfg.BO.Company.dll
Epicor.Mfg.IF.ICompany.dll

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Thursday, February 25, 2010 8:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] User Defined Tables

Ross,

I'm not exactly sure how I would go about doing this. Could you give me an example???

Thanks,

Dustin Biniek




________________________________
From: Ross Hughes <ross.hughes@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, February 25, 2010 8:46:13 AM
Subject: Re: [Vantage] User Defined Tables


You need to add the three company dll files as custom assembly
references.

Ross

On Feb 25, 2010, at 8:28 AM, melissa hietala <kevmel822@yahoo. com>
wrote:

> Goodmorning,
>
> I am attempting to setup the following code so that when a user
> creates a new record on the "UD01" table, a unique # will
> automatically be generated into a UD field on the table. However, I
> keep getting an error which states: "Type 'CompanyAdapter' is not
> defined." Any thoughts on where I may be going wrong on this and
> how I can fix it?
>
> Thanks,
> Dustin Biniek
>
> Private Sub edvUD01_EpiViewNoti fication( view As EpiDataView, args As
> EpiNotifyArgs) Handles edvUD01.EpiViewNoti fication
> '// ** Argument Properties and Uses **
> '// view.dataView( args.Row) ("[FieldName] ")
> '// args.Row, args.Column, args.Sender, args.NotifyType
> '// NotifyType.Initiali ze, NotifyType.AddRow,
> NotifyType.DeleteRo w, NotifyType.InitLast View,
> NotifyType.InitAndR esetTreeNodes
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> (UD01Form)
> compAdapt.BOConnect ()
> Dim company As String = UD01Form.Session. CompanyID
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer =
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("ShorChar01" ) =
> newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( UD01Form, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0)
> ("Number01") = newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
> End Sub
>
> Dustin Biniek
>
>
>
>
> ____________ _________ _________ __
> From: Brian W. Spolarich <bspolarich@advanced photonix. com>
> To: vantage@yahoogroups .com
> Sent: Mon, February 15, 2010 3:12:42 PM
> Subject: RE: [Vantage] User Defined Tables
>
>
> Here's my reply to this question, which is definitely a FAQ at this
> point. You could easily adapt this for UD* tables.
>
> -bws
>
> http://groups. yahoo.com/ group/vantage/ files/Vantage% 208.X
> %20Customiz ations/CustVendI D.zip
>
> This is a customization we're using to auto-set CustID and VendorID
> for new records. It get triggered when the client clicks on the
> "new" button. The next available ID for Customers and Vendors is
> stored in Company.Number01 and Company.Number02 respectively and
> incremented.
>
> You could modify this code to add a prefix to your IDs. To set a
> particular starting value just modify Company.Number01, etc. for
> your company.
>
> One thing that could improve this is to roll back the increment if
> the new record isn't actually saved. You will have gaps in your
> sequence if someone hits "New" and then doesn't actually create a
> new record, and this can make auditors nervous.
>
> -bws
>
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> ( CustomerEntryFor m)
> compAdapt.BOConnect ()
> Dim company As String = CustomerEntryForm. Session.CompanyI D
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer = compAdapt.CompanyDa ta.Tables
> ( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("CustID" ) = newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( CustomerEntryFor m, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" ) =
> newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> bspolarich@advanced photonix. com ~ 734-864-5618 ~
> www.advancedphotoni x.com
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Nick
> Sent: Monday, February 02, 2009 9:14 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Auto Calculating Customer/Supplier ID
>
> Is anybody out there using a customization to automatically generate
> Customer or Supplier ID's?
>
> I would like to have Customer and Supplier ID's generated
> automatically upon creation of a new record. They would be a 6 digit
> number with a prefix of S or C. I basically need to find the highest
> number and increment it by one.
>
> Is this a job for BPM, or would a button with some VB be necessary?
> Or could I drive it off of the CustNum record generated by Vantage?
>
> Thanks for the help!
>
> Nick
>
> --
> 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 melissa hietala
> Sent: Monday, February 15, 2010 2:54 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] User Defined Tables
>
> Is there a way to have a number randomly generated to uniquely
> identify a record on a user defined table? For instance, when a
> user goes into UD01 maintenance and clicks the "New" icon, I would
> like the key1 field to be populated with a unique value. When the
> first user goes into UD01 maintenance and creates a new record, the
> "Key1" field would be assigned a value of 001. When a second user
> goes into UD01 maintenance and creates a new record, the "Key1"
> field would be assigned a value of 002. And so on. Any thoughts on
> how this can be accomplished?
>
>
>
>
>
>
>
> [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]



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

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
27
Thank you Ross! Looks like that did the trick!

Thanks,

Dustin BiniekÂ




________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Thu, February 25, 2010 9:13:26 AM
Subject: RE: [Vantage] User Defined Tables

Â
Sure. In Developer Mode, enter your customization and select Assembly Reference Manager from the Tools menu.

Press the Add Custom Reference button and add the following three files. Press OK and test your customization.

Epicor.Mfg.AD. Company.dll
Epicor.Mfg.BO. Company.dll
Epicor.Mfg.IF. ICompany. dll

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of melissa hietala
Sent: Thursday, February 25, 2010 8:57 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] User Defined Tables

Ross,

I'm not exactly sure how I would go about doing this. Could you give me an example???

Thanks,

Dustin Biniek

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
Sent: Thu, February 25, 2010 8:46:13 AM
Subject: Re: [Vantage] User Defined Tables

You need to add the three company dll files as custom assembly
references.

Ross

On Feb 25, 2010, at 8:28 AM, melissa hietala <kevmel822@yahoo. com>
wrote:

> Goodmorning,
>
> I am attempting to setup the following code so that when a user
> creates a new record on the "UD01" table, a unique # will
> automatically be generated into a UD field on the table. However, I
> keep getting an error which states: "Type 'CompanyAdapter' is not
> defined." Any thoughts on where I may be going wrong on this and
> how I can fix it?
>
> Thanks,
> Dustin Biniek
>
> Private Sub edvUD01_EpiViewNoti fication( view As EpiDataView, args As
> EpiNotifyArgs) Handles edvUD01.EpiViewNoti fication
> '// ** Argument Properties and Uses **
> '// view.dataView( args.Row) ("[FieldName] ")
> '// args.Row, args.Column, args.Sender, args.NotifyType
> '// NotifyType.Initiali ze, NotifyType.AddRow,
> NotifyType.DeleteRo w, NotifyType.InitLast View,
> NotifyType.InitAndR esetTreeNodes
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> (UD01Form)
> compAdapt.BOConnect ()
> Dim company As String = UD01Form.Session. CompanyID
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer =
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("ShorChar01" ) =
> newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( UD01Form, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0)
> ("Number01") = newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows
> (0).EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
> End Sub
>
> Dustin Biniek
>
>
>
>
> ____________ _________ _________ __
> From: Brian W. Spolarich <bspolarich@ advanced photonix. com>
> To: vantage@yahoogroups .com
> Sent: Mon, February 15, 2010 3:12:42 PM
> Subject: RE: [Vantage] User Defined Tables
>
>
> Here's my reply to this question, which is definitely a FAQ at this
> point. You could easily adapt this for UD* tables.
>
> -bws
>
> http://groups. yahoo.com/ group/vantage/ files/Vantage% 208.X
> %20Customiz ations/CustVendI D.zip
>
> This is a customization we're using to auto-set CustID and VendorID
> for new records. It get triggered when the client clicks on the
> "new" button. The next available ID for Customers and Vendors is
> stored in Company.Number01 and Company.Number02 respectively and
> incremented.
>
> You could modify this code to add a prefix to your IDs. To set a
> particular starting value just modify Company.Number01, etc. for
> your company.
>
> One thing that could improve this is to roll back the increment if
> the new record isn't actually saved. You will have gaps in your
> sequence if someone hits "New" and then doesn't actually create a
> new record, and this can make auditors nervous.
>
> -bws
>
> If (args.NotifyType = EpiTransaction. NotifyType. AddRow) Then
> If (args.Row > -1) Then
> Dim compAdapt As CompanyAdapter = New CompanyAdapter
> ( CustomerEntryFor m)
> compAdapt.BOConnect ()
> Dim company As String = CustomerEntryForm. Session.CompanyI D
> Dim ret As Boolean = compAdapt.GetByID( company)
>
> Dim newCompID As Integer = compAdapt.CompanyDa ta.Tables
> ( "Company" ).Rows(0) ("Number01" )
>
> view.dataView( args.Row) ("CustID" ) = newCompID.ToString( )
> view.Notify( New EpiNotifyArgs( CustomerEntryFor m, view.Row,
> view.Column) )
>
> newCompID = newCompID + 1
>
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .BeginEdit( )
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) ("Number01" ) =
> newCompID
> compAdapt.CompanyDa ta.Tables( "Company" ).Rows(0) .EndEdit( )
>
> compAdapt.Update( )
>
> compAdapt.Dispose( )
>
>
> End If
> End If
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> bspolarich@advanced photonix. com ~ 734-864-5618 ~
> www.advancedphotoni x.com
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Nick
> Sent: Monday, February 02, 2009 9:14 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Auto Calculating Customer/Supplier ID
>
> Is anybody out there using a customization to automatically generate
> Customer or Supplier ID's?
>
> I would like to have Customer and Supplier ID's generated
> automatically upon creation of a new record. They would be a 6 digit
> number with a prefix of S or C. I basically need to find the highest
> number and increment it by one.
>
> Is this a job for BPM, or would a button with some VB be necessary?
> Or could I drive it off of the CustNum record generated by Vantage?
>
> Thanks for the help!
>
> Nick
>
> --
> 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 melissa hietala
> Sent: Monday, February 15, 2010 2:54 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] User Defined Tables
>
> Is there a way to have a number randomly generated to uniquely
> identify a record on a user defined table? For instance, when a
> user goes into UD01 maintenance and clicks the "New" icon, I would
> like the key1 field to be populated with a unique value. When the
> first user goes into UD01 maintenance and creates a new record, the
> "Key1" field would be assigned a value of 001. When a second user
> goes into UD01 maintenance and creates a new record, the "Key1"
> field would be assigned a value of 002. And so on. Any thoughts on
> how this can be accomplished?
>
>
>
>
>
>
>
> [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]

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

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]
28
Karl,

I pasted the entire script editor below.  This generates a unique value into the "UD01.Key1" field

Dustin Biniek

'//**************************************************
'// Custom VB.NET code for UD01Form
'// Created: 2/24/2010 4:44:25 PM
'//**************************************************
Imports System
Imports System.Data
Imports System.Diagnostics
Imports System.Windows.Forms
Imports System.ComponentModel
Imports Microsoft.VisualBasic
Imports Epicor.Mfg.UI
Imports Epicor.Mfg.UI.FrameWork
Imports Epicor.Mfg.UI.ExtendedProps
Imports Epicor.Mfg.UI.FormFunctions
Imports Epicor.Mfg.UI.Customization
Imports Epicor.Mfg.UI.Adapters
Imports Epicor.Mfg.UI.Searches
Imports Epicor.Mfg.BO

Module Script

 '// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **
 '// Begin Wizard Added Module Level Variables **
 Private WithEvents edvUD01 As EpiDataView
 '// End Wizard Added Module Level Variables **

 '// Add Custom Module Level Variables Here **

 Sub InitializeCustomCode()

  '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Intialization' lines **
  '// Begin Wizard Added Variable Intialization
  edvUD01 = CType(oTrans.EpiDataViews("UD01"), EpiDataView)
  '// End Wizard Added Variable Intialization
  '// Begin Custom Method Calls
  '// End Custom Method Calls
 End Sub

 Sub DestroyCustomCode()

  '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
  '// Begin Wizard Added Object Disposal
  edvUD01 = Nothing
  '// End Wizard Added Object Disposal
  '// Begin Custom Code Disposal
  '// End Custom Code Disposal
 End Sub

 Private Sub edvUD01_EpiViewNotification(view As EpiDataView, args As EpiNotifyArgs) Handles edvUD01.EpiViewNotification
  '// ** Argument Properties and Uses **
  '// view.dataView(args.Row)("[FieldName]")
  '// args.Row, args.Column, args.Sender, args.NotifyType
  '// NotifyType.Initialize, NotifyType.AddRow, NotifyType.DeleteRow, NotifyType.InitLastView, NotifyType.InitAndResetTreeNodes
    If (args.NotifyType = EpiTransaction.NotifyType.AddRow) Then
           If (args.Row > -1) Then
               Dim compAdapt As CompanyAdapter = New CompanyAdapter(UD01Form)
               compAdapt.BOConnect()
               Dim company As String = UD01Form.Session.CompanyID
               Dim ret As Boolean = compAdapt.GetByID(company)
              Â
               Dim newCompID As Integer = compAdapt.CompanyData.Tables("Company").Rows(0)("Number01")
             Â
               view.dataView(args.Row)("Key1") = newCompID.ToString()
               view.Notify(New EpiNotifyArgs(UD01Form, view.Row, view.Column))
              Â
               newCompID = newCompID + 1
              Â
               compAdapt.CompanyData.Tables("Company").Rows(0).BeginEdit()
               compAdapt.CompanyData.Tables("Company").Rows(0)("Number01") = newCompID
               compAdapt.CompanyData.Tables("Company").Rows(0).EndEdit()
              Â
               compAdapt.Update()
              Â
               compAdapt.Dispose()
  Â
  Â
           End If
       End If
   End Sub

End Module




________________________________
From: Karl Dash <dashkarl@...>
To: melissa hietala <kevmel822@...>
Sent: Fri, March 12, 2010 10:13:16 AM
Subject: Re: [Vantage] User Defined Tables


Could you send me a copy of the complete contents of the script editor for the customization you completed with Ross's assistance on Feb 25?

Regards,
-Karl Dash




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Fri, March 12, 2010 7:56:47 AM
Subject: [Vantage] Prod Dtl Report - QA - ADJ Subreport

Â
Hello All,

In the Production Detail report there is a sub-report called "QA-ADJ". Within this subreport there is a field called "PartTran. Calc_DtlPrintArea. " Could someone please tell me the formula behind this field?  We do not have SDK so I don't believe there is a way that I can go into the Report Data Definition and do this myself.

Thanks,
 Dustin Biniek

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








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

I'm new to this so bear with me.

I'm using Epicor 9 and I want to be able to automatically send an e-mail to suppliers when we process their invoice and pay them.

The BPM part is done except for the Vendor's e-mail address is not available as a field to use within the context of the BPM (I'm running it from the CheckHead table.)

My thought was that I could create a UD table which would link VendorNum from the CheckHead table with the e-mail address field from the Vendor Table.

However, I'm struggling a bit (a lot!).

I've used the Wizard to create a UD table (I think) but I have no way of populating it with data or linking it to the vendor table.

Reading the help files I need to be pretty good at VB.Net? Is there not a wizard for linking and selecting tables?

I did VB a looooooong time ago so I wouldn't be confident in programming anything.

any help or advice you can give would be gratefully received.

Many thanks in advance.

Matt
30
As long as you have the vendor number you can do a find on the vendor table to get the email address within the BPM.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "matthew.sprague@..." <matthew.sprague@...> wrote:
>
> Hi All
>
> I'm new to this so bear with me.
>
> I'm using Epicor 9 and I want to be able to automatically send an e-mail to suppliers when we process their invoice and pay them.
>
> The BPM part is done except for the Vendor's e-mail address is not available as a field to use within the context of the BPM (I'm running it from the CheckHead table.)
>
> My thought was that I could create a UD table which would link VendorNum from the CheckHead table with the e-mail address field from the Vendor Table.
>
> However, I'm struggling a bit (a lot!).
>
> I've used the Wizard to create a UD table (I think) but I have no way of populating it with data or linking it to the vendor table.
>
> Reading the help files I need to be pretty good at VB.Net? Is there not a wizard for linking and selecting tables?
>
> I did VB a looooooong time ago so I wouldn't be confident in programming anything.
>
> any help or advice you can give would be gratefully received.
>
> Many thanks in advance.
>
> Matt
>
31
Hi Jim

you'll have to excuse me for asking dumb questions but how do I "do a find"

My apologies. I'm fairly new to this.

Matt

--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> As long as you have the vendor number you can do a find on the vendor table to get the email address within the BPM.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "matthew.sprague@" <matthew.sprague@> wrote:
> >
> > Hi All
> >
> > I'm new to this so bear with me.
> >
> > I'm using Epicor 9 and I want to be able to automatically send an e-mail to suppliers when we process their invoice and pay them.
> >
> > The BPM part is done except for the Vendor's e-mail address is not available as a field to use within the context of the BPM (I'm running it from the CheckHead table.)
> >
> > My thought was that I could create a UD table which would link VendorNum from the CheckHead table with the e-mail address field from the Vendor Table.
> >
> > However, I'm struggling a bit (a lot!).
> >
> > I've used the Wizard to create a UD table (I think) but I have no way of populating it with data or linking it to the vendor table.
> >
> > Reading the help files I need to be pretty good at VB.Net? Is there not a wizard for linking and selecting tables?
> >
> > I did VB a looooooong time ago so I wouldn't be confident in programming anything.
> >
> > any help or advice you can give would be gratefully received.
> >
> > Many thanks in advance.
> >
> > Matt
> >
>
32
Here's an example bit from BPM that sends email. You'll need to change
the FIND to the Vendor table etc. There is no need to link the Vendor
table or a UD table in the screen customization (Visual Basic) -
instead, the BPM can look up the info it needs.



Brian.





find first PurAgent where PurAgent.Company =
ttPOheader.Company and PurAgent.BuyerID = ttPOHeader.BuyerID no-lock
no-error.

if available PurAgent and PurAgent.EMailAddress <> ''
then do:

assign vCC = vCC + PurAgent.EMailAddress
+ ";":U.

end.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of matthew.sprague@...
Sent: Thursday, April 12, 2012 9:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] User Defined Tables





Hi All

I'm new to this so bear with me.

I'm using Epicor 9 and I want to be able to automatically send an e-mail
to suppliers when we process their invoice and pay them.

The BPM part is done except for the Vendor's e-mail address is not
available as a field to use within the context of the BPM (I'm running
it from the CheckHead table.)

My thought was that I could create a UD table which would link VendorNum
from the CheckHead table with the e-mail address field from the Vendor
Table.

However, I'm struggling a bit (a lot!).

I've used the Wizard to create a UD table (I think) but I have no way of
populating it with data or linking it to the vendor table.

Reading the help files I need to be pretty good at VB.Net? Is there not
a wizard for linking and selecting tables?

I did VB a looooooong time ago so I wouldn't be confident in programming
anything.

any help or advice you can give would be gratefully received.

Many thanks in advance.

Matt





[Non-text portions of this message have been removed]
33
My suggestion is instead of a UD table, to add a UD field to the Vendor file and keep the email address in there. From Check printing , you must have the vendor number or ID so finding the email address would be quite simple.

--- In vantage@yahoogroups.com, "matthew.sprague@..." <matthew.sprague@...> wrote:
>
> Hi All
>
> I'm new to this so bear with me.
>
> I'm using Epicor 9 and I want to be able to automatically send an e-mail to suppliers when we process their invoice and pay them.
>
> The BPM part is done except for the Vendor's e-mail address is not available as a field to use within the context of the BPM (I'm running it from the CheckHead table.)
>
> My thought was that I could create a UD table which would link VendorNum from the CheckHead table with the e-mail address field from the Vendor Table.
>
> However, I'm struggling a bit (a lot!).
>
> I've used the Wizard to create a UD table (I think) but I have no way of populating it with data or linking it to the vendor table.
>
> Reading the help files I need to be pretty good at VB.Net? Is there not a wizard for linking and selecting tables?
>
> I did VB a looooooong time ago so I wouldn't be confident in programming anything.
>
> any help or advice you can give would be gratefully received.
>
> Many thanks in advance.
>
> Matt
>
34
We are creating a UD table for updating Production Standards and I want to ensure that the latest Revision is targeted and updated. We currently are using the following code:
Dim lastRevCount As Integer = adpPart.PartData.Tables("PartRev").Rows.Count-1
Dim lastRev As String = adpPart.PartData.Tables("PartRev").Rows(lastRevCount)("revisionNum")
Messagebox.Show(lastRev)
However, I noticed in one case, the most current rev was not updated, but a revision that was used prior.
Any suggestions from anyone?
35
Using the effectivedate and approved fields to determine the latest
revision will probably be more accurate.


On Fri, Aug 2, 2013 at 4:22 PM, carol.pelowski <cmpelows@...>wrote:

> **
>
>
> We are creating a UD table for updating Production Standards and I want to
> ensure that the latest Revision is targeted and updated. We currently are
> using the following code:
> Dim lastRevCount As Integer =
> adpPart.PartData.Tables("PartRev").Rows.Count-1
> Dim lastRev As String =
> adpPart.PartData.Tables("PartRev").Rows(lastRevCount)("revisionNum")
> Messagebox.Show(lastRev)
> However, I noticed in one case, the most current rev was not updated, but
> a revision that was used prior.
> Any suggestions from anyone?
>
>
>


[Non-text portions of this message have been removed]
36
That is what I was just looking into, either looking for the the latest effectivedate or if the rev is approved. Just need to get my syntax accurate.

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> Using the effectivedate and approved fields to determine the latest
> revision will probably be more accurate.
>
>
> On Fri, Aug 2, 2013 at 4:22 PM, carol.pelowski <cmpelows@...>wrote:
>
> > **
> >
> >
> > We are creating a UD table for updating Production Standards and I want to
> > ensure that the latest Revision is targeted and updated. We currently are
> > using the following code:
> > Dim lastRevCount As Integer =
> > adpPart.PartData.Tables("PartRev").Rows.Count-1
> > Dim lastRev As String =
> > adpPart.PartData.Tables("PartRev").Rows(lastRevCount)("revisionNum")
> > Messagebox.Show(lastRev)
> > However, I noticed in one case, the most current rev was not updated, but
> > a revision that was used prior.
> > Any suggestions from anyone?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>