'Account.name', 'formatter' => 'longname'); $cols['Sequence'] = array('index' => 'Ledger.sequence', 'formatter' => 'id'); $cols['Open Date'] = array('index' => 'PriorCloseTransaction.stamp', 'formatter' => 'date'); $cols['Close Date'] = array('index' => 'CloseTransaction.stamp', 'formatter' => 'date'); $cols['Comment'] = array('index' => 'Ledger.comment', 'formatter' => 'comment'); $cols['Entries'] = array('index' => 'entries', 'formatter' => 'number'); $cols['Debits'] = array('index' => 'debits', 'formatter' => 'currency'); $cols['Credits'] = array('index' => 'credits', 'formatter' => 'currency'); $cols['Balance'] = array('index' => 'balance', 'formatter' => 'currency'); // Render the grid $grid ->columns($cols) ->sortField('Sequence') ->defaultFields(array('Sequence')) ->searchFields(array('Comment')) ->render($this, isset($config) ? $config : null, array_diff(array_keys($cols), array('Account', 'Open Date', 'Comment')));