How do I add a column to my orders?

In inFlow On-Premise you can’t add columns to the order window, but you can add them to the printed documents generated through the order. This is done by creating a custom field in the product’s record, putting the information you want to add in there, and then using a custom document to display that information in a column.

To demonstrate, we will use our sample sales document and add the “Manufacturer” column, added as a custom field under Main Menu > Options > Settings.

Opening a sample document

Custom Document settings

First, open a sample document:

  1. Go to Main Menu > Options > Print Settings
  2. Choose Custom Docs from the icons on the left
  3. Click the Add New Custom Doc button.
  4. Choose the Sales document Header and Line items.
  5. Click Open Sample.

Once you’ve done this, it should open up in Microsoft Word. Next we will need to link the document to a proper data source (which contains all the custom field information).

To link your document:

  1. Open your sample document / template.
  2. Click the Mailings Ribbon and choose Start Mail Merge.
  3. Choose Directory from the list.
  4. Click Select Recipients and choose Use Existing List…

Microsoft Word mail merge

This will open a window in where you can browse to the correct data source (CSV file). There are four available which can be found in C:\Program Files\inFlow Inventory\CustomDocument.

Data source

For this example, choose Sample_Sales_SalesOrderLines.CSV, it contains all the available tags from a sales order including items, sales pricing, sales order info etc. Now that you’ve linked your document to that source file you can move on to the next section, adding a column & tags.

Add a column and tags

The body of the document contains a table for the item names, descriptions, prices, etc. Add a column and adjust the size/width. Then go to the Main Menu > Options > Settings > Custom Fields. Compare your own screen to this example screenshot:

Custom fields settings

Referencing the above, if you wanted the column in your custom document to show the information listed in the 2nd position of your settings, then you would look for “ItemCustom2” in the Insert Merge Field drop-down selection in Microsoft Word.

In our example, we want to show the Manufacturer information, which is on the 6th position so the tag we want to add is ItemCustom6.

Sample document with column

You might have noticed after adding a column, Word shifted the other columns to the right. It’s a little tricky to resize the columns to fit in the table, so we recommend replacing tags in an existing column. Here’s an example of the finished document with a custom column + tags. Replace the column with whichever tag you like, by selecting it from the Insert Merge Field setting. Do not manually type in a tag name, it will not work that way.

When you’re satisfied with your document, import it into inFlow begin using it.

  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.