Back to the FAQ

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.

FAQ categories

Narrow down your search
  1. Show all
  2. Custom Fields
  3. Document Archive
  4. Document Creator
  5. Document Mail Queue
  6. General
  7. Inventory Availability Indicators
  8. Licensing/Subscriptions
  9. PDF Merge
  10. Price and Item Management

Related questions

We run into an error that says “A task was canceled.”. What can we do about this? (On-Premise) The designer does not start anymore after reconfiguring my PC. What can I do to resolve this? How can we add Item pictures to our document layouts? Can we put Document Creator report layouts under source control? How do we upgrade Document Creator when upgrading to a newer BC version? (On-Premise)
Copyright © 2024 Apportunix | Terms & Conditions | Privacy