Map a Sales Order Detail UDF to an Invoice Detail UDF

Home | FAQs & Troubleshooting

                   

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

Use this procedure to create and map a Sales Order Detail user-defined field (UDF) to a Sales Order Invoice Detail UDF.

 

To create and map a Sales Order Detail UDF to a Sales Order Invoice Detail UDF

  1. Create the manual entry UDF to map in the SO Sales Order Detail table. For more information, see Create a User-Defined Field (UDF).

  2. Select Custom Office Main menu > User-Defined Field and Table Maintenance.

  3. Select Sales Order menu > SO Invoice Detail, and click the Edit Fields button.

  4. In the User-Defined Fields window, click the Add button. For more information, see User-Defined Fields - Fields.

  5. In the Add Field window, enter the field name and description. For more information, see Add Field - Fields.

  6. Select Manual Entry and click OK. A second Add Field window appears.

  7. In the second Add Field window:

  1. Click the Data Sources tab, and select the Select check box for SO_InvoiceDetail_bus: CopyFromSalesOrder.

  2. In the Data Source field, select SO_SalesOrderDetail.

  3. In the Column field, select the UDF created in step 1, and click OK.

  1. In the second Add Field window, click OK.

  2. In the User-Defined Fields window, click OK.

  3. When you are prompted to update the data dictionary and UDF data files, click OK.

The Sales Order Detail UDF is mapped to the Sales Order Invoice Detail UDF.