Quotes module line items columns make them adjustable?

Hi all, in the Quotes module, many of the columns for line items are too wide which then makes users scroll horizontally and they hate that.

is there a way to make them adjustable please?

Thank you

  •  

    Hello,

    Go to custom/modules/Quotes/metadata/editviewdefs.php , If file is not exist then copy it from modules/Quotes/metadata/editviewdefs.php and
    modify name field array to have
    'displayParams'=>array('size'=>100),

    Do quick repair & rebuild from admin.

    Bruce McIntyre

  • You can modify the width of QLIs columns by adding the attribute 'widthClass' inside each field def:

    <?php
    $viewdefs['Products']['base']['view']['quote-data-group-list'] = array (
      'panels' => 
      array (
        0 => 
        array (
          'name' => 'products_quote_data_group_list',
          'label' => 'LBL_PRODUCTS_QUOTE_DATA_LIST',
          'fields' => 
          array (
            0 => 
            array (
              'name' => 'line_num',
              'label' => NULL,
              'widthClass' => 'cell-xsmall',
              'css_class' => 'line_num tcenter',
              'type' => 'line-num',
              'readonly' => true,
            ),
            1 => 
            array (
              'name' => 'product_template_name',
              'label' => 'LBL_ITEM_NAME',
              'widthClass' => 'cell-xlarge',
              'type' => 'quote-data-relate',
              'required' => true,
              'initial_filter_label' => 'LBL_FILTER_POPUP',
              'filter_populate' => 
              array (
                'stage_c' => 
                array (
                  0 => 'ativo',
                ),
              ),
            ),
            2 => 
            array (
              'name' => 'unit_quantity_c',
              'label' => 'LBL_UNIT_QUANTITY',
              'widthClass' => 'cell-small',
              'css_class' => 'quantity',
              'type' => 'float',
            ),
            3 => 
            array (
              'name' => 'unit_measure_c',
              'label' => 'LBL_UNIT_MEASURE',
              'type' => 'varchar',
            ),
            4 => 
            array (
              'name' => 'unit_price_c',
              'label' => 'LBL_UNIT_PRICE',
              'type' => 'currency',
              'convertToBase' => true,
              'showTransactionalAmount' => true,
              'related_fields' => 
              array (
                0 => 'unit_price_c',
                1 => 'currency_id',
                2 => 'base_rate',
              ),
            ),
            5 => 
            array (
              'name' => 'quantity',
              'label' => 'LBL_QUANTITY',
              'widthClass' => 'cell-small',
              'css_class' => 'quantity',
              'type' => 'float',
              'related_fields' => 
              array (
                0 => 'packing_quantity_product_c',
                1 => 'unit_quantity_c',
              ),
            ),
            6 => 
            array (
              'name' => 'discount_price',
              'label' => 'LBL_DISCOUNT_PRICE',
              'type' => 'currency',
              'convertToBase' => true,
              'showTransactionalAmount' => true,
              'related_fields' => 
              array (
                0 => 'discount_price',
                1 => 'currency_id',
                2 => 'base_rate',
                3 => 'quantity',
                4 => 'unit_price_c',
                5 => 'unit_quantity_c',
              ),
            ),
            7 => 
            array (
              'name' => 'product_unit_item_c',
              'label' => 'LBL_PRODUCT_UNIT_ITEM',
              'type' => 'varchar',
            ),
            8 => 
            array (
              'name' => 'operation_type_c',
              'label' => 'LBL_OPERATION_TYPE',
              'type' => 'enum',
            ),
            9 => 
            array (
              'name' => 'warehouse_c',
              'label' => 'LBL_WAREHOUSE',
              'type' => 'enum',
            ),
            10 => 
            array (
              'name' => 'quality_certificate_c',
              'label' => 'LBL_QUALITY_CERTIFICATE',
              'type' => 'bool',
            ),
            11 => 
            array (
              'name' => 'customer_item_position_c',
              'label' => 'LBL_CUSTOMER_ITEM_POSITION',
              'type' => 'int',
            ),
            12 => 
            array (
              'name' => 'item_number_xped_c',
              'label' => 'LBL_ITEM_NUMBER_XPED',
              'type' => 'int',
            ),
            13 => 
            array (
              'name' => 'ncm_item_c',
              'label' => 'LBL_NCM_ITEM',
              'type' => 'varchar',
            ),
            14 => 
            array (
              'name' => 'icms_tax_c',
              'label' => 'LBL_ICMS_TAX',
              'type' => 'float',
            ),
            15 => 
            array (
              'name' => 'st_value_c',
              'label' => 'LBL_ST_VALUE',
              'type' => 'currency',
            ),
            16 => 
            array (
              'name' => 'ipi_tax_c',
              'label' => 'LBL_IPI_TAX',
              'type' => 'float',
            ),
            17 => 
            array (
              'name' => 'total_amount',
              'label' => 'LBL_SUM_SUBTOTAL_TAX',
              'convertToBase' => true,
              'showTransactionalAmount' => true,
            ),
            18 => 
            array (
              'name' => 'packing_quantity_product_c',
              'label' => 'LBL_PACKING_QUANTITY_PRODUCT',
            ),
          ),
        ),
      ),
    );

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • Hi

    I'm not a full dev, so before I attempt or ask a dev to package this up for me, can you confirm the expectations of this customisation, will it allow users to adjust column widths using mouse same as other similar layouts ?

  • hi Andre'

    Cann you let me know if I understood your solution correctly please?

    so does it mean each field width needs to be hardcoded, wheras solution from Bruce would allow each user to set the widths as they want?

  • hello Tony,

    a few ideas that might be of help to reach better user adoption with less additional investments:
    1.Show users how to hide right Panel View
    2. Review a list of QLI columns, keeping really necessary fields in it - the list of fields to view in the QLI list is configurable in the Admin section
    3. Hardcode the size of the QLI columns by setting columns widths that enable reviewing 80% of Quotes with no scrolling - might need some developers efforts
    4. Equip users with higher resolution monitors - this could look confusing, but it is often reasonably cheaper than paying for hours of raw code development /testing/deployment or custom styles adjustments according to regular US/EU/UK rates

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

  • Yes, the solution I provided is a hardcoded size for each column. The solution from Bruce will not work once metadata/editviewdefs.php is not loaded anymore since version 7.0.

    André Lopes
    Lampada Global
    Skype: andre.lampada