Using Extended UD fields in BPM's


(system) #1

Greg,

Here is my code (with my test messages) and there are no errors or failures shown in the server logs.


Thanks for any ideas or suggestions.


Tim Lester



Here's the current Action code:


define variable msg as character no-undo.

assign msg = ' Starting BPM Logic '.

{lib/PublishInfoMsg.i 

&InfoMsg = msg

&InfoSeverity = {&MESSAGE_INFO}}


FOR EACH ttOrderHed no-lock where ttOrderHed.RowMod = 'A' or ttOrderHed.RowMod = 'U'.

if available ttOrderHed then do:


FOR EACH OrderHed_UD where OrderHed_UD.ForeignSysRowID = ttOrderHed.SysRowID exclusive-lock.

if available OrderHed_UD and (OrderHed_UD.OrderNumber <> ttOrderHed.OrderNum) then do:

assign msg = 'Pre-Assign OrderNum = ' + string(ttOrderHed.OrderNum) + ' UD-OrderNum = ' + string(OrderHed_UD.OrderNumber).


{lib/PublishInfoMsg.i 

&InfoMsg = msg

&InfoSeverity = {&MESSAGE_INFO}}


assign OrderHed_UD.OrderNumber = ttOrderHed.OrderNum.


assign msg = 'Post Assign OrderNum = ' + string(ttOrderHed.OrderNum) + ' UD-OrderNum = ' + string(OrderHed_UD.OrderNumber).


{lib/PublishInfoMsg.i 

&InfoMsg = msg

&InfoSeverity = {&MESSAGE_INFO}}

END.

END.

END.

END.  



---In vantage@yahoogroups.com, <gpayne@...> wrote:

I am on 702A SQL. Post your bpm code, so we can take a look. have you checked you Appserver log for errors during the transaction?

 

if you look at the sample and my code, I basically just pasted it in and changed the tables.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tlester@...
Sent: Friday, November 01, 2013 12:31 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Using Extended UD fields in BPM's

 

 

Greg,

Would you be willing to discuss this further with me? I am not able to get this to work and curious how you are getting the logic to work. Guess the first question - what version are you on? We are on 9.05.700c with SQL.

 

Tim Lester 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I got the answerbook below from support and have used a couple of times to update the _UD table directly.

 

this snipit is from an update on QuoteQty

 

For FIRST QuoteQty_UD WHERE ttQuoteQty.sysrowid = QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.

 

                                Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 / ttQuoteQty.SellingQuantity.  

                                Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 + ( QuoteQty_UD.Number11 / 100)).

 

                                If QuoteQty_UD.Number11 = 0 Then

                                                QuoteQty_UD.Number11 = 20.0.

                                End.

                                                                                               

 

HTH

 

Greg Payne

 

 

=========================================================

Summary:           BPM - update an extended ud column with a BPM

Book:                    Support Solutions

Page:                     14313MPS

 

PAGE: 14313MPS

 

PROBLEM DESCRIPTION:

I am using extended ud tables and I want to use a BPM to change one of the columns that I added; when I use the BPM wizard, the extended ud columns aren't showing up.

 

PROBLEM RESOLUTION:

At this time, you have to use ABL code to do the join with the _UD table by using the sysrowid of the parent and the foreignsysrowid on the _ud table. For example, if you added some columns to the customer table and you wanted to update customer_ud.shortchar999, you could do so with the ABL code below.

 

FOR EACH ttcustomer WHERE ttcustomer.rowmod = 'u'.

  FOR FIRST customer_ud WHERE ttcustomer.sysrowid = customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.

    IF avail customer_ud THEN DO:

      ASSIGN customer_ud.shortchar999 = 'value goes here'.

    END.

  END.

END.

 

ADDITIONAL INFORMATION:

It is currently impossible to determine on server side whether a particular UD field was changed or not - there is no RowMod in the ttUserDefinedData table. At the moment that type of evaluation could really only be done from the UI side with a UI customization.

 

VERSIONS:

9.05

 

KEYWORDS

BPM

extended ud

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Monday, September 16, 2013 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Extended UD fields in BPM's

 

 

I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)
I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.
Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.
Anyone else run out of UD fields and have a similar issue? If so, were you able to resolve it?

Thanks,
Chris Wineinger
Interior Systems Inc
905.701 SQL Unicode 64bit
(905.702a by the end of the month)

 


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

(system) #2
I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)
I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.
Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.
Anyone else run out of UD fields and have a similar issue? If so, were you able to resolve it?

Thanks,
Chris Wineinger
Interior Systems Inc
905.701 SQL Unicode 64bit
(905.702a by the end of the month)

(system) #3

I got the answerbook below from support and have used a couple of times to update the _UD table directly.

 

this snipit is from an update on QuoteQty

 

For FIRST QuoteQty_UD WHERE ttQuoteQty.sysrowid = QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.

 

                                Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 / ttQuoteQty.SellingQuantity.  

                                Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 + ( QuoteQty_UD.Number11 / 100)).

 

                                If QuoteQty_UD.Number11 = 0 Then

                                                QuoteQty_UD.Number11 = 20.0.

                                End.

                                                                                               

 

HTH

 

Greg Payne

 

 

=========================================================

Summary:           BPM - update an extended ud column with a BPM

Book:                    Support Solutions

Page:                     14313MPS

 

PAGE: 14313MPS

 

PROBLEM DESCRIPTION:

I am using extended ud tables and I want to use a BPM to change one of the columns that I added; when I use the BPM wizard, the extended ud columns aren't showing up.

 

PROBLEM RESOLUTION:

At this time, you have to use ABL code to do the join with the _UD table by using the sysrowid of the parent and the foreignsysrowid on the _ud table. For example, if you added some columns to the customer table and you wanted to update customer_ud.shortchar999, you could do so with the ABL code below.

 

FOR EACH ttcustomer WHERE ttcustomer.rowmod = 'u'.

  FOR FIRST customer_ud WHERE ttcustomer.sysrowid = customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.

    IF avail customer_ud THEN DO:

      ASSIGN customer_ud.shortchar999 = 'value goes here'.

    END.

  END.

END.

 

ADDITIONAL INFORMATION:

It is currently impossible to determine on server side whether a particular UD field was changed or not - there is no RowMod in the ttUserDefinedData table. At the moment that type of evaluation could really only be done from the UI side with a UI customization.

 

VERSIONS:

9.05

 

KEYWORDS

BPM

extended ud

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Monday, September 16, 2013 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Extended UD fields in BPM's

 

 

I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)
I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.
Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.
Anyone else run out of UD fields and have a similar issue? If so, were you able to resolve it?

Thanks,
Chris Wineinger
Interior Systems Inc
905.701 SQL Unicode 64bit
(905.702a by the end of the month)



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

(system) #4

I got the same answerbook.

Maybe I’m missing something but when I try to pull the data from an extended UD to put into another Extended UD field it errors out.

I’ll take another look.

 

Regards,

 

Chris Wineinger

ERP Specialist

Interior Systems, Inc.

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594

 

IT related problem? Contact helpdesk@...

 


(system) #5
PLEASE UNSUSCRIBE

--------------------------------------------
On Mon, 9/16/13, Greg Payne <gpayne@...> wrote:

Subject: RE: [Vantage] Using Extended UD fields in BPM's
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Monday, September 16, 2013, 3:44 PM
















Â













I got the answerbook
below from support and have used a couple of times to update
the _UD table directly.

Â
this snipit is from
an update on QuoteQty
Â
For FIRST
QuoteQty_UD WHERE ttQuoteQty.sysrowid =
QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.
Â
                              Â
Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 /
ttQuoteQty.SellingQuantity. Â

                              Â
Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 +
( QuoteQty_UD.Number11 / 100)).
Â
                              Â
If QuoteQty_UD.Number11 = 0 Then

                              Â
              Â
QuoteQty_UD.Number11 = 20.0.
                              Â
End.
                                                                                              Â

Â
HTH
Â
Greg
Payne
Â
Â
=========================================================

Summary:Â Â Â Â Â Â Â Â Â Â
BPM - update an extended ud column with a BPM
Book:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
Support Solutions
Page:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
14313MPS
Â
PAGE: 14313MPS
Â
PROBLEM DESCRIPTION:

I am using extended ud
tables and I want to use a BPM to change one of the columns
that I added; when I use the BPM wizard, the extended ud
columns aren't showing up.
Â
PROBLEM RESOLUTION:
At this time, you have
to use ABL code to do the join with the _UD table by using
the sysrowid of the parent and the foreignsysrowid on the
_ud table. For example, if you added some columns to the
customer table and you wanted to update
customer_ud.shortchar999, you could do so with the ABL code
below.
Â
FOR EACH ttcustomer
WHERE ttcustomer.rowmod = 'u'.
 FOR FIRST
customer_ud WHERE ttcustomer.sysrowid =
customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.
   IF
avail customer_ud THEN DO:
    Â
ASSIGN customer_ud.shortchar999 = 'value goes
here'.
  Â
END.
 END.
END.
Â
ADDITIONAL
INFORMATION:
It is currently
impossible to determine on server side whether a particular
UD field was changed or not - there is no RowMod in the
ttUserDefinedData table. At the moment that type of
evaluation could really only be done from the UI
side with a UI customization.
Â
VERSIONS:
9.05
Â
KEYWORDS
BPM
extended ud
Â
Â


From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]
On Behalf Of redrhyno13

Sent: Monday, September 16, 2013 2:53 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Using Extended UD fields in
BPM's


Â
Â



I've been working with Epicor on how to map between
Extended UD fields (QuoteHed to OrderHed for example)

I'm able to create the Extended UD tables and I can see
them in a query but I can't run the query or have a BPM
pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.


Epicor finally gave me an SCR 82440 and said this would be a
schema change and won't happen until 10. Of course their
workaround doesn't work.


Anyone else run out of UD fields and have a similar issue?
If so, were you able to resolve it?



Thanks,

Chris Wineinger

Interior Systems Inc

905.701 SQL Unicode 64bit

(905.702a by the end of the month)








CONFIDENTIALITY
NOTICE



The information contained in this communication, including
attachments, is privileged and confidential. It is intended
only for the exclusive use of the addressee. If the reader
of this message is not the intended recipient, or the
employee or agent responsible
for delivering it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of
this communication is strictly prohibited. If you have
received this communication in error, please notify us at
727-578-6280 and immediately
delete the communication.



"This (document/presentation) may contain technical
data as defined in the International Traffic In Arms
Regulations (ITAR) 22 CFR 120.10. Export of this material is
restricted by the Arms Export Control Act (22 U.S.C. 2751 et
seq.) and may not be exported
to foreign persons without prior approval form the U.S.
Department of State."

(system) #6

Please go to the yahoo group and do so….

 

M

 

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of CB
Sent: Thursday, October 10, 2013 7:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UNSUSCRIBE

 

 

PLEASE UNSUSCRIBE

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

On Mon, 9/16/13, Greg Payne <gpayne@...> wrote:

Subject: RE: [Vantage] Using Extended UD fields in BPM's
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Monday, September 16, 2013, 3:44 PM
















 













I got the answerbook
below from support and have used a couple of times to update
the _UD table directly.

 
this snipit is from
an update on QuoteQty
 
For FIRST
QuoteQty_UD WHERE ttQuoteQty.sysrowid =
QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.
 
                               
Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 /
ttQuoteQty.SellingQuantity.  

                               
Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 +
( QuoteQty_UD.Number11 / 100)).
 
                               
If QuoteQty_UD.Number11 = 0 Then

                               
               
QuoteQty_UD.Number11 = 20.0.
                               
End.
                                                                                               

 
HTH
 
Greg
Payne
 
 
=========================================================

Summary:          
BPM - update an extended ud column with a BPM
Book:                   
Support Solutions
Page:                    
14313MPS
 
PAGE: 14313MPS
 
PROBLEM DESCRIPTION:

I am using extended ud
tables and I want to use a BPM to change one of the columns
that I added; when I use the BPM wizard, the extended ud
columns aren't showing up.
 
PROBLEM RESOLUTION:
At this time, you have
to use ABL code to do the join with the _UD table by using
the sysrowid of the parent and the foreignsysrowid on the
_ud table. For example, if you added some columns to the
customer table and you wanted to update
customer_ud.shortchar999, you could do so with the ABL code
below.
 
FOR EACH ttcustomer
WHERE ttcustomer.rowmod = 'u'.
  FOR FIRST
customer_ud WHERE ttcustomer.sysrowid =
customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.
    IF
avail customer_ud THEN DO:
     
ASSIGN customer_ud.shortchar999 = 'value goes
here'.
   
END.
  END.
END.
 
ADDITIONAL
INFORMATION:
It is currently
impossible to determine on server side whether a particular
UD field was changed or not - there is no RowMod in the
ttUserDefinedData table. At the moment that type of
evaluation could really only be done from the UI
side with a UI customization.
 
VERSIONS:
9.05
 
KEYWORDS
BPM
extended ud
 
 


From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]
On Behalf Of redrhyno13

Sent: Monday, September 16, 2013 2:53 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Using Extended UD fields in
BPM's


 
 



I've been working with Epicor on how to map between
Extended UD fields (QuoteHed to OrderHed for example)

I'm able to create the Extended UD tables and I can see
them in a query but I can't run the query or have a BPM
pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.


Epicor finally gave me an SCR 82440 and said this would be a
schema change and won't happen until 10. Of course their
workaround doesn't work.


Anyone else run out of UD fields and have a similar issue?
If so, were you able to resolve it?



Thanks,

Chris Wineinger

Interior Systems Inc

905.701 SQL Unicode 64bit

(905.702a by the end of the month)








CONFIDENTIALITY
NOTICE



The information contained in this communication, including
attachments, is privileged and confidential. It is intended
only for the exclusive use of the addressee. If the reader
of this message is not the intended recipient, or the
employee or agent responsible
for delivering it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of
this communication is strictly prohibited. If you have
received this communication in error, please notify us at
727-578-6280 and immediately
delete the communication.



"This (document/presentation) may contain technical
data as defined in the International Traffic In Arms
Regulations (ITAR) 22 CFR 120.10. Export of this material is
restricted by the Arms Export Control Act (22 U.S.C. 2751 et
seq.) and may not be exported
to foreign persons without prior approval form the U.S.
Department of State."



























(system) #7
If you read the complete emails that you get, you will notice a small line at the bottom.

Here it is to help you.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of CB
Sent: Thursday, October 10, 2013 8:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UNSUSCRIBE

PLEASE UNSUSCRIBE

--------------------------------------------
On Mon, 9/16/13, Greg Payne <gpayne@...> wrote:

Subject: RE: [Vantage] Using Extended UD fields in BPM's
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Monday, September 16, 2013, 3:44 PM






























I got the answerbook
below from support and have used a couple of times to update the _UD table directly.


this snipit is from
an update on QuoteQty

For FIRST
QuoteQty_UD WHERE ttQuoteQty.sysrowid = QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.


Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 / ttQuoteQty.SellingQuantity.


Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 + ( QuoteQty_UD.Number11 / 100)).


If QuoteQty_UD.Number11 = 0 Then



QuoteQty_UD.Number11 = 20.0.

End.



HTH

Greg
Payne


=========================================================

Summary:
BPM - update an extended ud column with a BPM
Book:
Support Solutions
Page:
14313MPS

PAGE: 14313MPS

PROBLEM DESCRIPTION:

I am using extended ud
tables and I want to use a BPM to change one of the columns that I added; when I use the BPM wizard, the extended ud columns aren't showing up.

PROBLEM RESOLUTION:
At this time, you have
to use ABL code to do the join with the _UD table by using the sysrowid of the parent and the foreignsysrowid on the _ud table. For example, if you added some columns to the customer table and you wanted to update
customer_ud.shortchar999, you could do so with the ABL code below.

FOR EACH ttcustomer
WHERE ttcustomer.rowmod = 'u'.
FOR FIRST
customer_ud WHERE ttcustomer.sysrowid = customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.
IF
avail customer_ud THEN DO:

ASSIGN customer_ud.shortchar999 = 'value goes here'.

END.
END.
END.

ADDITIONAL
INFORMATION:
It is currently
impossible to determine on server side whether a particular UD field was changed or not - there is no RowMod in the ttUserDefinedData table. At the moment that type of evaluation could really only be done from the UI
side with a UI customization.

VERSIONS:
9.05

KEYWORDS
BPM
extended ud




From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]
On Behalf Of redrhyno13

Sent: Monday, September 16, 2013 2:53 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Using Extended UD fields in BPM's







I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)

I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.


Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.


Anyone else run out of UD fields and have a similar issue?
If so, were you able to resolve it?



Thanks,

Chris Wineinger

Interior Systems Inc

905.701 SQL Unicode 64bit

(905.702a by the end of the month)








CONFIDENTIALITY
NOTICE



The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible
for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at
727-578-6280 and immediately
delete the communication.



"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et
seq.) and may not be exported
to foreign persons without prior approval form the U.S.
Department of State."





























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

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

(system) #8

Greg,

Would you be willing to discuss this further with me? I am not able to get this to work and curious how you are getting the logic to work. Guess the first question - what version are you on? We are on 9.05.700c with SQL.


Tim Lester 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I got the answerbook below from support and have used a couple of times to update the _UD table directly.

 

this snipit is from an update on QuoteQty

 

For FIRST QuoteQty_UD WHERE ttQuoteQty.sysrowid = QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.

 

                                Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 / ttQuoteQty.SellingQuantity.  

                                Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 + ( QuoteQty_UD.Number11 / 100)).

 

                                If QuoteQty_UD.Number11 = 0 Then

                                                QuoteQty_UD.Number11 = 20.0.

                                End.

                                                                                               

 

HTH

 

Greg Payne

 

 

=========================================================

Summary:           BPM - update an extended ud column with a BPM

Book:                    Support Solutions

Page:                     14313MPS

 

PAGE: 14313MPS

 

PROBLEM DESCRIPTION:

I am using extended ud tables and I want to use a BPM to change one of the columns that I added; when I use the BPM wizard, the extended ud columns aren't showing up.

 

PROBLEM RESOLUTION:

At this time, you have to use ABL code to do the join with the _UD table by using the sysrowid of the parent and the foreignsysrowid on the _ud table. For example, if you added some columns to the customer table and you wanted to update customer_ud.shortchar999, you could do so with the ABL code below.

 

FOR EACH ttcustomer WHERE ttcustomer.rowmod = 'u'.

  FOR FIRST customer_ud WHERE ttcustomer.sysrowid = customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.

    IF avail customer_ud THEN DO:

      ASSIGN customer_ud.shortchar999 = 'value goes here'.

    END.

  END.

END.

 

ADDITIONAL INFORMATION:

It is currently impossible to determine on server side whether a particular UD field was changed or not - there is no RowMod in the ttUserDefinedData table. At the moment that type of evaluation could really only be done from the UI side with a UI customization.

 

VERSIONS:

9.05

 

KEYWORDS

BPM

extended ud

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Monday, September 16, 2013 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Extended UD fields in BPM's

 

 

I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)
I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.
Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.
Anyone else run out of UD fields and have a similar issue? If so, were you able to resolve it?

Thanks,
Chris Wineinger
Interior Systems Inc
905.701 SQL Unicode 64bit
(905.702a by the end of the month)



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

(system) #9

I am on 702A SQL. Post your bpm code, so we can take a look. have you checked you Appserver log for errors during the transaction?

 

if you look at the sample and my code, I basically just pasted it in and changed the tables.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tlester@...
Sent: Friday, November 01, 2013 12:31 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Using Extended UD fields in BPM's

 

 

Greg,

Would you be willing to discuss this further with me? I am not able to get this to work and curious how you are getting the logic to work. Guess the first question - what version are you on? We are on 9.05.700c with SQL.

 

Tim Lester 



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

I got the answerbook below from support and have used a couple of times to update the _UD table directly.

 

this snipit is from an update on QuoteQty

 

For FIRST QuoteQty_UD WHERE ttQuoteQty.sysrowid = QuoteQty_ud.ForeignSysRowID EXCLUSIVE-LOCK.

 

                                Assign ttQuoteQty.Number10 = ttQuoteQty.Number01 / ttQuoteQty.SellingQuantity.  

                                Assign QuoteQty_UD.Number12 = ttQuoteQty.Number01 * (1 + ( QuoteQty_UD.Number11 / 100)).

 

                                If QuoteQty_UD.Number11 = 0 Then

                                                QuoteQty_UD.Number11 = 20.0.

                                End.

                                                                                               

 

HTH

 

Greg Payne

 

 

=========================================================

Summary:           BPM - update an extended ud column with a BPM

Book:                    Support Solutions

Page:                     14313MPS

 

PAGE: 14313MPS

 

PROBLEM DESCRIPTION:

I am using extended ud tables and I want to use a BPM to change one of the columns that I added; when I use the BPM wizard, the extended ud columns aren't showing up.

 

PROBLEM RESOLUTION:

At this time, you have to use ABL code to do the join with the _UD table by using the sysrowid of the parent and the foreignsysrowid on the _ud table. For example, if you added some columns to the customer table and you wanted to update customer_ud.shortchar999, you could do so with the ABL code below.

 

FOR EACH ttcustomer WHERE ttcustomer.rowmod = 'u'.

  FOR FIRST customer_ud WHERE ttcustomer.sysrowid = customer_ud.ForeignSysRowID EXCLUSIVE-LOCK.

    IF avail customer_ud THEN DO:

      ASSIGN customer_ud.shortchar999 = 'value goes here'.

    END.

  END.

END.

 

ADDITIONAL INFORMATION:

It is currently impossible to determine on server side whether a particular UD field was changed or not - there is no RowMod in the ttUserDefinedData table. At the moment that type of evaluation could really only be done from the UI side with a UI customization.

 

VERSIONS:

9.05

 

KEYWORDS

BPM

extended ud

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Monday, September 16, 2013 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Extended UD fields in BPM's

 

 

I've been working with Epicor on how to map between Extended UD fields (QuoteHed to OrderHed for example)
I'm able to create the Extended UD tables and I can see them in a query but I can't run the query or have a BPM pull from QuoteHed.UDfield1 to OrderHed.UDfield1 in a BPM.
Epicor finally gave me an SCR 82440 and said this would be a schema change and won't happen until 10. Of course their workaround doesn't work.
Anyone else run out of UD fields and have a similar issue? If so, were you able to resolve it?

Thanks,
Chris Wineinger
Interior Systems Inc
905.701 SQL Unicode 64bit
(905.702a by the end of the month)

 


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."