How to add the “Work Description” field as text to my layout?

The "Work Description" field on the sales header stores the text in a BLOB database field. If you would like to add the "Work Description" field of the sales header to your sales document, then please follow these steps:

  1. Open your document layout to edit it in the Document Creator designer. (See the Editing Layouts chapter in the online user manual.
  2. Add a new TextObject to your layout.
  3. Edit the Text of the new TextObject, and enter the following:
    [[SalesHdr.WorkDescription] != null && [SalesHdr.WorkDescription].Length > 0 ? System.Text.Encoding.UTF8.GetString([SalesHdr.WorkDescription]) : ""]
  4. Save and then preview your changes and you will see the Work Description is now visible on your layout.

You can also apply this for any other BLOB field that you have that stores text.