Show/Hide All

 Overview

Use this procedure to create and map a data entry UDF for the Sales Order or Accounts Receivable module to a General Ledger detail posting UDF.

 

To create and map a data entry UDF to a General Ledger detail posting UDF

1. Create the manual entry UDF to map in one of the following tables:

   • Select the SO Daily Posting Work table to create a Sales Order invoices UDF.

   • Select the AR Daily Posting Work table to create an Accounts Receivable invoices UDF.

For more information, see Create a User-Defined Field (UDF).

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

3. Select General Ledger menu > GL Daily Posting.

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:

1. Enter the field name and description. For more information, see Add Field - Fields.

2. In the Business Object field, select one of the following:

   • Select SO_SalesJournal_upd to map a Sales Order invoices UDF.

   • Select AR_SalesJournal_upd to map a Accounts Receivable invoices UDF.

3. In the Column field, select the UDF created in step 1. Click OK. A second Add Field window appears.

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

7. In User-Defined Field and Table Maintenance, select General Ledger menu > GL Detail Posting.

8. In the User-Defined Fields window, click the Add button.

9. In the Add Field window:

1. Enter the field name and description.

2. In the Business Object field, select GL_DailyTransaction_upd.

3. In the Data Source field, select GL_DailyPosting.

4. In the Column field, select the UDF created in the GL Daily Posting table. Click OK. A second Add Field window appears.

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

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

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

The data entry UDF is mapped to the General Ledger detail posting UDF.