Adding & Removing Columns

HARMONiQ allows you to customise object lists by adding and removing columns so users see only the most relevant information.

Below is the standard layout for the Sales Order list with the default columns.

To add a columns, open the Sales Order List. Right-click on any column heading and select Add Columns.

This opens the Property Chooser, which contains all properties related to the Sales Order object.

In this article, we will add three new columns to our Sales Order List:

     1. Deposit Received Total

     2. Picking Note Number

     3. Payment Status

To add the Deposit Received Total, start typing 'deposit' in the list, then select the relevant property. Double-click the property or click Add Column at the bottom of the Property Chooser.

On the Control Type screen, leave the default section and click OK to add the column to your SO List.

To add the Picking Note Number, type 'picking' in the Property Chooser to find the Picking Note property. Click the > arrow next to it to display its sub-properties.

Start typing 'number' and select Number. Double-click the property and click OK to add it to the list. 

Hovering over the column heading will display the full property path, e.g., Picking.Note.Number.

To add Payment Status, repeat the steps above. If the Property Chooser is closed, right-click on any columns heading and select Add Columns to reopen it.

Once the new columns are added, they can be repositioned. Click and drag the Picking Note Number column heading to place it before the Status column. Repeat this for other newly added columns until they are arranged as needed.

Some column names may not be immediately clear. To rename a column, right-click on the Picking Note Number column heading, select Change Caption, enter a new name such as PN Number, and save.

If a column is unnecessary, right-click on the column and select Hide This Column. The column will be removed from the list.

Changes to the column layout are temporary unless saved. If the list is closed without saving, it will revert to the default layout. To save the new layout, click the HARMONiQ icon at the top right of the Sales Order List, select Save Layout, leave the Name field blank, and keep the Layout Context set to Company. Click Continue-F9 to save.

Now when reopening the Sales Order List, all layout changes will be retained.

Link to HQ Manual here - Adding and Removing Columns