User Defined Fields GP GL

Dynamics GP Tip: Additional User-Defined Fields in General Ledger Transaction Entry

Source: GP Documentation

With the October 2020 release of Dynamics GP, there are now two new user-defined fields in the General Ledger Transaction Entry window.

When users enter transactions into the General Ledger, they like to add information/comments regarding the transactions. User-defined labels for the user-defined fields are at the bottom of the General Ledger Setup window.

Go to the Financial Home Page, under Setup, choose Financial, and then choose General Ledger.

The field length for the user-defined labels is the same as the other user-defined label fields, namely 15. The size of the user-defined fields is 30 characters in the transaction entry window.

The user-defined fields are added to the following reports:

  • Edit list
  • Posting journal

The fields are available in Report Writer to be added to other reports as needed.

Set up the user-defined fields

Go to the Financial Home Page, under Setup, click Financial, and then choose General Ledger.

User Defined Fields GP GL

To see the user-defined fields that you set up earlier, you can go to Transaction, choose Financial, and then choose General.

The following image shows an example report for the General Posting Journal.

Once a transaction has been posted with user-defined information populated, you will be able to see this in the inquiry windows. Located under the Financial Home page, choose Inquiry, then Financial, and Journal Entry Inquiry.

You can also add the new fields to a SmartList. For more information, see Bulk-edit SmartList Columns.

Columns GP

Table Changes

TABLE CHANGES
Table Physical NamesTable Technical NameNew field
GL20000GL_YTD_TRX_OPENUser_Defined_Text01
GL20000GL_YTD_TRX_OPENUser_Defined_Text02
GL30000GL_YTD_TRX_HISTUser_Defined_Text01
GL30000GL_YTD_TRX_HISTUser_Defined_Text02

For more assistance, contact our Dynamics GP experts.

Leave a Comment