How to Add UDF to PO Detail Table from PO Header Table

Question

I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me? 
 User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right-->Field name: Est Del Date--> Source for UDF Date: Business Object 
 Under Business Object, I can't find PO Header Table. Therefore, I can't add created UDF, Estimated Delivery Date, to PO Detail Table. 
 Luke

Natasha Chang · Accepted Answer

You can do it with a few lines of scripting. 
 Select PO_PurchaseOrderDetail table 
 Go into User Defined Scripts. 
 Event = Table - Set Default Values 
 retVal = 0 
 delDate = "" 
 retVal = oHeaderObj.GetValue("UDF_EstDelDate$",delDate) 
 retval = oBusObj.SetValue("UDF_EstDelDate$", delDate)

LukeLeXu · Answer

Thank you very much. It works. 
 However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. 
 Also, what are all abbreviation of different type of tables, such as header table, wrk table, detail table, etc when we do scripting. Is there a list? 
 oHeaderObj - Header 
 oBusObj - Detail 
 ... 
 Thanks again for your great help! 
 Luke

Natasha Chang · Answer

Sage U has a VB scripting class: 
 sageu.csod.com/.../SearchAdvanced.aspx

Sage 100

How to Add UDF to PO Detail Table from PO Header Table

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING