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."