The product grids on Quotes, Sales Orders and Invoices in OpenCRM allow for the addition of up to ten extra columns which will each contain one field.  These can be activated from the "Product Grid Custom Column Settings" from within the Studio settings. 

The custom columns can have data in a number of different types:

• Number - a text input field which will only accept numerical input
• Text area - a box similar to the description box
• Drop-Down - a drop down box with a number of options.  The options in these need to be customised through the relevant pick list settings
• Checkbox
• Date field - a date box with a calendar picker
• Text box - a normal text field to allow any characters

The setup screen for each module looks like the following:

The items in the column name fields can be edited to display something more relevant to the field.  The text in this box will be the title of the column on the product grid.  The column type specifies the type of field which will be displayed in that column.  Setting the option to "None" will turn the field off.

The information entered into these will be carried over to the others upon conversion only if the corresponding field is turned on for the module being converted to i.e. if custom column 1 and 2 are turned on in quotes, but only custom column 1 is turned on in Sales Orders, when you convert from a quote to a sales order only the data from the field in custom column 1 will be carried across.

• Rate This Article

  
  
• Feedback and Comments

  Name:

  
  

You may also be interested in:

• How can I add standard product fields onto the product grids on Quote / Sales Order / Invoice / Purchase Order PDFs?  Updated : 31-10-2012 10:46
  OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Products
• How do I use multi-currency / currency fields in PDF Templates?  Updated : 08-01-2013 14:48
  OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Settings OpenCRM::Settings::Templates
• How can I change the fields visible on the Basic and Advanced Search screens?  Updated : 03-04-2012 15:11
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk
• I need to bulk update a set of records in OpenCRM, how do I do this?  Updated : 17-02-2012 12:47
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Documents OpenCRM::Contracts OpenCRM::Events OpenCRM::Campaigns

• How do I use the mail merge option in OpenCRM? Can I use WORD or Open Office to create Templates?  - Revised for v.3.02

    Updated : 09-03-2013 09:06
  OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Settings::Templates OpenCRM::Opportunities
• Custom PDF troubleshooting. Dealing with some of the more common questions about Custom PDF templates.  Updated : 14-02-2012 12:38
  OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Settings::Templates

• How does Product Kitting work? How can I sell products as part of a bundle?

    Updated : 17-12-2012 17:08
  OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Invoice OpenCRM::Products
• 

  What are Action Plans in OpenCRM and how can I use them to get the most out of my OpenCRM solution? And what are Conditional Action Plans?

    Updated : 14-05-2012 16:34
  OpenCRM::Leads OpenCRM::Emails OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk OpenCRM::Documents OpenCRM::Events OpenCRM::Campaigns OpenCRM::Settings OpenCRM::Settings::Additional

• How can I control the style of the product rows and sub total rows using the PDF templates?

    Updated : 13-04-2012 13:15
  OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Settings OpenCRM::Settings::Templates
• Fields are not merging in RTF Templates. Product grids or rows are not merging in RTF templates.  Updated : 19-10-2011 11:38
  OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Settings OpenCRM::Settings::Templates