Share via

Truncation of data on the Project Timesheet Lines Comment Field

  • Article

Scenario:
Customers experiencing truncation of the comment field on the lines of the Project Timesheet.

Resolution:
may consider making the following changes to their system to help resolve the issue.

  1. Change EDT TransTxt to be at least stringsize of 255.
  2. For ProjJournalTrans Table change the EDT for field Txt from TSComment to TransTxt.

Note: It is important to perform step 1 before step 2 to ensure no data is lost in the EDT conversion from TSComment to TransTxt. We highly recommened these changes are tested in a test environment before deploying in production.