E9: I would like to do a customization with a UD table

Yahoo Archive
1
First, make sure you take the "no-lock" off the ttShipHead statement -
you're updating those fields. You won't get an error when compiling the
BPM, but the code won't update either. Eventually, you'd find a message on
the app server logs at run time. You'll also need to convert the pack num
to a string to compare to the Key1 field.



Make sure to include the Company in your "Where" statements when linking to
the UD table. All indices on the tables have the Company as the first field
in the index, so if you don't use it - you're doing a full table scan.





And actually, since we're talking about optimizing, anytime you can combine
statements, you're increasing the performance. So, a rewrite of this
statement would be:



for each ttShipHead where ttShipHead.RowMod = "A" And ttShipHead.ShipDate
= today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534,

each UD40 no-lock where UD40.Company = ttShipHead.Company and UD40.key1
= string(ttShipHead.PackNum):

assign ttshiphead.trackingnumber = UD40.ShortChar01.

End.



Hope that helps.

Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scotty K.
Sent: Monday, December 16, 2013 6:49 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: E9: I would like to do a customization with a UD
table





Change you action to ABL with no condition and use the following code.



for each ttShipHead no-lock where ttShipHead.RowMod = "A" And
ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And
ttShipHead.CustNum = 534:



Find First UD40 no-lock where UD40.key1 = ttShipHead.PackNum no-error.

If Avail UD40 then do:

ttshiphead.trackingnumber = UD40.ShortChar01.

End.



End.





Good luck, Scott



On Mon, Dec 16, 2013 at 5:11 PM, Miguel Santillan <msantillan@...
<mailto:msantillan@...> > wrote:



I was able to create the UD Entry Form and my Key 1 and ShortChar01 are
populated.



UD40.Key1 and UD40.ShortChar01



So now I want to be able to take that data and populate into the shipment.



This was my query on the Pre CustShip.Update and I have a informational
message and it opened.



for each ttShipHead no-lock where ttShipHead.RowMod = "A" And
ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And
ttShipHead.CustNum = 534



I want to assign ttshiphead.trackingnumber = UD09.ShortChar01.



but that did not work as the action. I am missing how to link the UD40
table in here.



Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666 <tel:510-661-6666> Office



From: vantage@yahoogroups.com <mailto:vantage@yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage@yahoogroups.com> ] On Behalf
Of bruce.d.ordway@... <mailto:bruce.d.ordway@...>
Sent: Friday, December 13, 2013 8:27 AM
To: vantage@yahoogroups.com <mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: I would like to do a customization with a UD
table





Hi Miguel,





I'm assuming this would be your first customization?

And you have already set up your EpicWeb account?



If so I would start with downloading the Customization Guides.

I think the basic customization chapters will answer your questions.



https://epicweb.epicor.com/Education/Pages/UserGuides.aspx









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

I want to put a daily tracking number in a UD field. Then during shipment, based on customer and ship via and date, the UD field populates onto the tracking number area.

 

1. How would I have it so that the shipping department enters the number directly.

 

2. Can I do something of the sort of

 

if today = Monday, populate with key1 or if today = Tuesday populate with key 2.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

3

Hi Miguel,



I'm assuming this would be your first customization?

And you have already set up your EpicWeb account?


If so I would start with downloading the Customization Guides.

I think the basic customization chapters will answer your questions.


https://epicweb.epicor.com/Education/Pages/UserGuides.aspx


4
A simpler solution would be to use one field for the DOW, and another field for the value that you are saving. Â Then manage the reporting of that data from your BAQ. Â If you then have a one-one relationship with an existing base table, I would just use UD fields in the base table that the data is associated with.


Tanya Denison | IT Manager | NRS, Inc.
2009 S. Main Street, Moscow, IDÂ 83843
c: 208.301.0599 | p: 208.883.7834 Ext 277 | f: 208.882.1744


On Thu, Dec 12, 2013 at 11:20 AM, Miguel Santillan <msantillan@...> wrote:

 
<div>
  
  
  <p>

I want to put a daily tracking number in a UD field. Then during shipment, based on customer and ship via and date, the UD field populates onto the tracking number area.

Â

1. How would I have it so that the shipping department enters the number directly.

Â

2. Can I do something of the sort of

Â

if today = Monday, populate with key1 or if today = Tuesday populate with key 2.

Â

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666Â Office

510-656-0603Â Fax

msantillan@...

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

5

I was able to create the UD Entry Form and my Key 1 and ShortChar01 are populated.

 

UD40.Key1 and UD40.ShortChar01

 

So now I want to be able to take that data and populate into the shipment.

 

This was my query on the Pre CustShip.Update and I have a informational message and it opened.

 

for each ttShipHead no-lock  where ttShipHead.RowMod = "A" And  ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534

 

I want to assign ttshiphead.trackingnumber = UD09.ShortChar01.

 

but that did not work as the action.  I am missing how to link the UD40 table in here.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bruce.d.ordway@...
Sent: Friday, December 13, 2013 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: I would like to do a customization with a UD table

 

 

Hi Miguel,

 

 

I'm assuming this would be your first customization?

And you have already set up your EpicWeb account?

 

If so I would start with downloading the Customization Guides.

I think the basic customization chapters will answer your questions.

 

https://epicweb.epicor.com/Education/Pages/UserGuides.aspx

 

6
Change you action to ABL with no condition and use the following code.
Â

for each ttShipHead no-lock where ttShipHead.RowMod = "A" And ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534:

Â

  Find First UD40 no-lock where UD40.key1 = ttShipHead.PackNum no-error.

  If Avail UD40 then do:

     ttshiphead.trackingnumber = UD40.ShortChar01.

  End.

Â

End.

Â

Â

Good luck, Scott



On Mon, Dec 16, 2013 at 5:11 PM, Miguel Santillan <msantillan@...> wrote:

 
<div>
  
  
  <p>

I was able to create the UD Entry Form and my Key 1 and ShortChar01 are populated.

Â

UD40.Key1 and UD40.ShortChar01

Â

So now I want to be able to take that data and populate into the shipment.

Â

This was my query on the Pre CustShip.Update and I have a informational message and it opened.

Â

for each ttShipHead no-lock where ttShipHead.RowMod = "A" And ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534

Â

I want to assign ttshiphead.trackingnumber = UD09.ShortChar01.

Â

but that did not work as the action. I am missing how to link the UD40 table in here.

Â

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666Â Office

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bruce.d.ordway@...
Sent: Friday, December 13, 2013 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: I would like to do a customization with a UD table

Â

Â

Hi Miguel,

Â

Â

I'm assuming this would be your first customization?

And you have already set up your EpicWeb account?

Â

If so I would start with downloading the Customization Guides.

I think the basic customization chapters will answer your questions.

Â

https://epicweb.epicor.com/Education/Pages/UserGuides.aspx

 

</div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>

7

hmmm, I get it now how to work with the UD fields…thanks for the help.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scotty K.
Sent: Monday, December 16, 2013 3:49 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: E9: I would like to do a customization with a UD table

 

 

Change you action to ABL with no condition and use the following code.

 

for each ttShipHead no-lock where ttShipHead.RowMod = "A" And ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534:

 

   Find First UD40 no-lock where UD40.key1 = ttShipHead.PackNum no-error.

   If Avail UD40 then do:

      ttshiphead.trackingnumber = UD40.ShortChar01.

   End.

 

End.

 

 

Good luck, Scott

 

On Mon, Dec 16, 2013 at 5:11 PM, Miguel Santillan <msantillan@...> wrote:

 

I was able to create the UD Entry Form and my Key 1 and ShortChar01 are populated.

 

UD40.Key1 and UD40.ShortChar01

 

So now I want to be able to take that data and populate into the shipment.

 

This was my query on the Pre CustShip.Update and I have a informational message and it opened.

 

for each ttShipHead no-lock  where ttShipHead.RowMod = "A" And  ttShipHead.ShipDate = today And ttShipHead.ShipViaCode = 'pwf' And ttShipHead.CustNum = 534

 

I want to assign ttshiphead.trackingnumber = UD09.ShortChar01.

 

but that did not work as the action.  I am missing how to link the UD40 table in here.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bruce.d.ordway@...
Sent: Friday, December 13, 2013 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: I would like to do a customization with a UD table

 

 

Hi Miguel,

 

 

I'm assuming this would be your first customization?

And you have already set up your EpicWeb account?

 

If so I would start with downloading the Customization Guides.

I think the basic customization chapters will answer your questions.

 

https://epicweb.epicor.com/Education/Pages/UserGuides.aspx