--- title: New Way to Easily Manage Custom Information description: "SYSPRO is full of “listviews”: the data tables you see on-screen in queries, when entering data, just about everywhere. They display lots of useful information, but have you ever wanted more?" --- [![](https://customer.syspro.com/hs-fs/hubfs/SYSPRO_WORD_COBALT.png?width=1200&height=319&name=SYSPRO_WORD_COBALT.png)](http://syspro.com) ![Customer View](https://customer.syspro.com/hs-fs/file-746879232-png/customer_blog/customer-view-tangram.png?width=450&name=customer-view-tangram.png "Customer View") - [SYSPRO Home](http://www.syspro.com/) - [Blog Home](https://customer.syspro.com) - [Support Zone](http://support.syspro.com/distributor/main.php) - [Contact](http://www.syspro.com/contact/) ## [New Way to Easily Manage Custom Information](https://customer.syspro.com/new-way-to-easily-manage-custom-information) Posted by [Canada Support Team](https://customer.syspro.com/author/canada-support-team) Apr 16, 2015 7:30:00 AM SYSPRO is full of “listviews”: the data tables you see on-screen in queries, when entering data, just about everywhere. They display lots of useful information, but have you ever wanted more? One of the top enhancements in SYSPRO 7: Update 1 is the ability to add custom information to your listviews. And it is very simple to do. ## What it is Prior to Update 1, you were limited to a selection of commonly used columns. Admittedly there were a lot of them but sometimes you really wanted that special piece of information in that one place that will speed up day to day processing. Now in Update 1 for clients running SYSPRO on SQL Server you can have it: - Select from *any* of the many columns of information that live in the ‘master file’ where you are working (e.g., all the sales order information). - Select from *any* of the related columns of information in the many *related* master files (e.g. the links between customer orders and inventory information). - Select from *any* custom columns you have added and display these too! This last point bears repeating. If you have created a custom field in SYSPRO, you can now add that as a column of information in your listview. That’s very powerful. ## How it works SYSPRO makes this ability easy to deploy. Normally you would go to any listview and right-click on the table headings and select the **Field Chooser**. This lets you pick and choose from a large handful of columns to add or remove. ![field-chooser-contextual-menu](https://customer.syspro.com/hubfs/customer_blog/field-chooser-contextual-menu.png) With Update 1 you can still do this but now you can also add custom data. Go to your listview, right-click on the table headings, but open the **Customize** sub-menu to select **Add Custom Columns**. ![custom-columns-contextual-menu](https://customer.syspro.com/hubfs/customer_blog/custom-columns-contextual-menu.png) We could do many things but let’s look at adding the **Supplier** to the **Sales Order Entry** program. Because we know the **Supplier** is already part of the Inventory system, we select **Master table** to add that column. We could equally have selected to add a custom data column. ![Custom Columns Window](https://customer.syspro.com/hubfs/customer_blog/custom-columns-window.png "Custom Columns Window") As soon as we select that we want to look at linked Master tables, we get the following window where we can scroll through all the many linked tables, each with their own many data fields. This makes it easy and painless to experiment and try out different columns. In this example we select **Inventory Master** and click **Add** next to the **Supplier**. And we are done. ![custom-column-fields](https://customer.syspro.com/hubfs/customer_blog/custom-column-fields.png)   SYSPRO is striving to make your software as simple as possible for you to tailor to your ever-evolving needs. We think we have hit this one out of the park. [![support-zone-registration](https://customer.syspro.com/hs-fs/hub/239680/file-700683845.png)](http://support.syspro.com/log_in.php?event=register&read=true) [![SYSPRO7](https://customer.syspro.com/hs-fs/hub/239680/file-1095819675.jpg)](http://infozone.syspro.com/syspro7) ### Subscribe to Email Updates ### Recent Posts ### Module Spotlight - [![](https://customer.syspro.com/hs-fs/file-700182983-png/customer_blog/module_graphics/inventory-forecasting.png)](http://www.syspro.com/resources/factsheets/inventory_forecasting_factsheet.pdf) ### Inventory Forecasting Produce and measure automatic or manual forecasts. - [![](https://customer.syspro.com/hs-fs/file-701839046-png/customer_blog/module_graphics/lot-traceability.png)](http://www.syspro.com/resources/factsheets/lot_factsheet_h-res.pdf) ### Lot Traceability Track materials through receipt, manufacture, assembly, inspection, stocking and distribution. ### Become a Customer Case Study   - Raise your company's image - Promote your brand - Demonstrate your leadership [Learn More](https://digital.syspro.com/become-customer-case-study) ### From the Smarter ERP BLog © 2026 Syspro ![](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/1062870112/?value=1.00¤cy_code=CAD&label=vimiCOirmgMQ4Ljo-gM&guid=ON&script=0)