{"id":3322,"date":"2014-04-21T22:08:32","date_gmt":"2014-04-22T02:08:32","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3322\/how-do-i-add-a-column-to-my-orders\/"},"modified":"2018-05-17T16:37:56","modified_gmt":"2018-05-17T20:37:56","slug":"how-do-i-add-a-column-to-my-orders","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/33821234\/how-do-i-add-a-column-to-my-orders\/","title":{"rendered":"How do I add a column to my orders in inFlow On-Premise?"},"content":{"rendered":"

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.<\/p>\n

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

Opening a sample document<\/h2>\n\n

\"Custom<\/div><\/p>\n\n

First, open a sample document:<\/strong><\/p>\n

    \n
  1. Go to Main Menu > Options > Print Settings<\/em><\/li>\n
  2. Choose Custom Docs<\/em>\u00a0from the icons on the left<\/li>\n
  3. Click the Add New Custom Doc<\/em>\u00a0button.<\/li>\n
  4. Choose the Sales document Header and Line items<\/em>.<\/li>\n
  5. Click Open Sample<\/em>.<\/li>\n<\/ol>\n

    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).<\/p>\n

    To link your document:<\/strong><\/p>\n

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

      \"Microsoft<\/div><\/p>\n\n

      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<\/code>.<\/p>\n\n

      \"Data<\/div><\/p>\n\n

      For this example, choose Sample_Sales_SalesOrderLines.CSV, <\/strong>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.<\/p>\n\n

      Add a column and tags<\/h2>\n

      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<\/em>. Compare your own screen to this example screenshot:<\/p>\n\n

      \"Custom<\/div><\/p>\n

      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<\/em>\u00a0drop-down selection in Microsoft Word.<\/p>\n

      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.<\/p>\n\n

      \"Sample<\/div><\/p>\n\n

      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<\/a>. Replace the column with whichever tag you like, by selecting it from the\u00a0Insert Merge Field<\/em> setting.\u00a0Do not manually type in a tag name<\/strong>, it will not work that way.<\/p>\n

      When you’re satisfied with your document, import it into inFlow begin using it<\/a>.<\/p>\n\n","protected":false},"excerpt":{"rendered":"

      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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,22],"tags":[46,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3322"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=3322"}],"version-history":[{"count":12,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3322\/revisions"}],"predecessor-version":[{"id":25493,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3322\/revisions\/25493"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}