In the General Ledger Transaction Entry window there are now two new user defined fields. When users enter transactions into the General Ledger, they like to add information/comments regarding the transactions.

User Define labels for the user defined fields are at the bottom of the General Ledger Setup Window.

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

The field length for the User defined label is the same as the other user defined label fields which is 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 and Posting journal.
  • The fields are available in Report Writer to be added to other reports as needed.
  • The size of the user defined fields is 30 characters in the transaction entry window.

Table Changes:

Columns added to existing tables.

General Ledger Setup - GL40000 columns - - usrdrpr5 and usrdrpr6

General Ledger Transaction tables - GL10000, GL20000, GL30000 - - user_defined_text01, user_defined_text02


Due to table changes with 18.3 release for General Ledger, after applying any update, you should Reconfigure change tracking for your MR Data Mart.  This is located In the Management Reporter Configuration Console, under the data mart integration, Reconfigure change tracking.

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

To see the User Defined fields you setup above you can go to Transaction choose Financial and General.

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 Extra fields to a SmartList. We can also use the new feature to quickly add multiple fields at once to a SmartList!

For more documentation on our new features please check out our Microsoft Dynamics GP New Feature Blog Series!

Thank you,

Margi Jandro

Microsoft Support