So you want to add a new type of document to inFlow On-Premise? Perhaps some documents you use are specific to your particular region or industry, or you just want to streamline your process. Good news: you can create a custom document using Microsoft Word’s Mail Merge feature to let you link that document directly to inFlow! It’s important to keep in mind that this is only for purchase or sales related documents.
We’ll cover three things in this article:
- Types of information available
- Making changes to a sample document
- Linking your document to a data source
- Adding tags to your document
The custom documents are primarily used for invoices, but you can also create other documents by removing unnecessary columns. For example, as packing slips don’t usually show the prices, you can just remove those columns to get a custom packing slip!
There’s also a couple of limitations for what information can be shown on the documents:
The custom documents cannot show the following inFlow information:
- item unit weights (from Product Measurements)
- “picked” quantity or “total” quantity
- overall account balance (only the sales order / invoice balance can be shown)
The custom documents can show the following information:
- unit price after discount
- item total weight (requires unit weight in the Product Info > Extra Info tab)
- total order weight (requires unit weight in the Product Info > Extra Info tab)
- item barcode (requires barcode in the Product Info > Extra Info tab)
- line number
- tracking number, from the Ship tab in inFlow’s sales orders
- custom field information (from products, sales orders, purchase orders, vendors, or customers)
Below, we’ll start with the sample document and soon you’ll learn how to show the information listed above!
To begin you’ll want to start with one of our sample documents (these are included with your installation).
This is the easiest way to start using custom documents and lets you play with an existing template to see how it works.
First, open a sample document:
- Go to Main Menu > Options > Print Settings.
- Choose Custom Docs from the icons on the left
- Click the Add New Custom Doc button.
- Choose one of four types of documents (sales or purchasing documents).
- Click Open Sample.
Microsoft Word will open up the sample document so that you can make changes to the placement of certain items, or the information that’s included.
You’ll notice in the picture above that the sample looks like our default Modern template, but instead of the actual item names and prices, you’ll see things like
<<ItemName>>, <<ItemUnitPrice>>, <<ItemQuantity>>, etc. This is referred to as a tag. When imported into inFlow, depending on which order you use the custom document in, it will populate those tags with information in that specific inFlow order.
You can move the placement of these tags. For example, if you want the quantity of the item to be placed on the left column, instead of in the middle, or if you want to move the Order Date/ Number to the left instead of right.
Here are a couple of key things to note before you move things around:
- There is a “rule” in small print just beside the
<<ItemSubtotal>>rows, this is a rule that tells Microsoft Word to move on to the next line if the
<<ItemName>>tag is not blank. Do not remove this! Otherwise you will see only one item repeating itself. This “rule” is repeated except at the very last row. If you decide you want to remove the subtotal column, copy the rule over to another column you are using.
- The custom documents don’t pull information from the General/ Print settings screen in inFlow, so you’ll have to re-input your company details (top left, or wherever you want) and logo.
- Your template should only be one page long. Microsoft Word will repeat the header (customer/vendor info) and totals per page but the items will continue on another page if the order is longer than a page.
If you want to add extra tags (for example: tracking number, custom fields, etc) that don’t normally show up in the default document, you must link Microsoft Word to a data source that contains these extra tags first. The data source is in the Program Files / inFlow inventory folder, and there are different sources depending on if the custom document is going to have purchasing/vendor information or sales/customer information.
This step needs to be followed any time you’re going to ADD tags to a document (whether new or one of our samples). If you’re just removing tags then you can skip this step and just save your document.
To link your document to a data source:
- Open your sample document / template.
- Click the Mailings Ribbon and choose Start Mail Merge.
- Choose Directory from the list.
- Click Select Recipients and choose Use Existing List…
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.
Depending on what information you want available you’ll choose your file, please see below for a short description of each file, which should help give you an idea of which one you might want to link to:
- Sample_Purchasing_PurchaseOrderLines.CSV: all the available tags from a purchase order including items, vendor pricing, purchase order info etc. Use this if you are creating your own purchasing invoice.
- Sample_Purchasing_SingleDocument.CSV: only order level information like your vendor’s address, no items or itemized details. Use this if you want to have inFlow address your envelopes for sending out your purchase orders.
- Sample_Sales_SalesOrderLines.CSV: all the available tags from a sales order including items, sales pricing, sales order info etc.Use this if you are creating your own sales invoice.
- Sample_Sales_SingleDocument.CSV: order level information like your customer’s address, no itemized information. Use this if you want to have inFlow address your envelopes for sending out your invoices.
Now that you’ve linked your document to that source file you can insert the available tags via the Insert Merge Field button. There will be a dropdown list of available tags to add.
Adding tags lets you choose where something should be placed on your document. Let’s say your document is a letter to your customer and you want to call them by their name. In that case it might look something like this:
Thank you for purchasing from our company!
This lets inFlow know that you want the customer’s name placed directly after the “Dear” within the letter.
To add your tag as above:
- Put your cursor where you’d like the new tag to appear.
- In the Mailings tab, click Insert Merge Field.
- Choose the tag you want from the resulting list.
This will place your tag into the document so that inFlow knows where you want that information to be once printed. In the example above, we replaced the “Payment Terms” text field with “Date Paid” and removed the
<<PaymentTerms>> tag. From the “Insert Merge Field” we selected the corresponding
You must select the field from the “Insert Merge Field” button. Simply typing out the tag will not work!
At the top of this article we had mentioned some information you can show in the custom documents. Now that you know how to insert a tag into a document, you can try the following:
- for unit price after discount, use the
- for item total weight, use the
- for total order weight, use the
- for item barcode, use the
- for line number, use the
- for tracking number, use the
When you’re finished adjusting the document, save it to your desktop (or anywhere you can easily locate it).
Now that you’ve created your custom document you’re ready to import the custom document to inFlow to use your custom document.