git.roojs.org Git - Pman.Xtuple/blob - Pman.Dialog.XtupleInvoice.bjs

   1 {
   2     "id": "roo-file-16",
   3     "name": "Pman.Dialog.XtupleInvoice",
   4     "parent": false,
   5     "title": "",
   6     "path": "/home/edward/gitlive/web.xtuple/Pman/Xtuple/Pman.Dialog.XtupleInvoice.bjs",
   7     "items": [
   8         {
   9             ".builderCfg": "{\"cols\":[{\"table\":\"cobmisc\",\"column\":\"cobmisc_shipvia\",\"columnshort\":\"cobmisc_shipvia\",\"ctype\":\"text\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_freight\",\"columnshort\":\"cobmisc_freight\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_payment\",\"columnshort\":\"cobmisc_payment\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_notes\",\"columnshort\":\"cobmisc_notes\",\"ctype\":\"text\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_shipdate\",\"columnshort\":\"cobmisc_shipdate\",\"ctype\":\"date\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_invcdate\",\"columnshort\":\"cobmisc_invcdate\",\"ctype\":\"date\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_misc_descrip\",\"columnshort\":\"cobmisc_misc_descrip\",\"ctype\":\"text\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_curr_id\",\"columnshort\":\"cobmisc_curr_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"curr_id\",\"deps\":[{\"table\":\"curr_symbol\",\"column\":\"cobmisc_curr_id_curr_base\",\"columnshort\":\"curr_base\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"curr_symbol\",\"column\":\"cobmisc_curr_id_curr_name\",\"columnshort\":\"curr_name\",\"ctype\":\"varchar\",\"desc\":\"\"},{\"table\":\"curr_symbol\",\"column\":\"cobmisc_curr_id_curr_symbol\",\"columnshort\":\"curr_symbol\",\"ctype\":\"varchar\",\"desc\":\"\"},{\"table\":\"curr_symbol\",\"column\":\"cobmisc_curr_id_curr_abbr\",\"columnshort\":\"curr_abbr\",\"ctype\":\"varchar\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\",\"display\":\"cobmisc_curr_id_curr_abbr\"},{\"table\":\"cobmisc\",\"column\":\"cobmisc_taxzone_id\",\"columnshort\":\"cobmisc_taxzone_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"taxzone_id\",\"deps\":[{\"table\":\"taxzone\",\"column\":\"cobmisc_taxzone_id_taxzone_code\",\"columnshort\":\"taxzone_code\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"taxzone\",\"column\":\"cobmisc_taxzone_id_taxzone_descrip\",\"columnshort\":\"taxzone_descrip\",\"ctype\":\"text\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\",\"display\":\"cobmisc_taxzone_id_taxzone_descrip\"}],\"cols_ex\":[\"cobmisc_curr_id_curr_abbr\",\"cobmisc_taxzone_id_taxzone_descrip\"],\"table\":\"cobmisc\",\"xtype\":\"LayoutDialog\",\"|xns\":\"Roo\"}",
  10             "closable": true,
  11             "collapsible": false,
  12             "height": 600,
  13             "modal": true,
  14             "resizable": false,
  15             "title": "Edit / Create Invoice",
  16             "width": 900,
  17             "xtype": "LayoutDialog",
  18             "|xns": "Roo",
  19             "items": [
  20                 {
  21                     "|xns": "Roo",
  22                     "xtype": "LayoutRegion",
  23                     "*prop": "center"
  24                 },
  25                 {
  26                     "*prop": "north",
  27                     "height": 270,
  28                     "xtype": "LayoutRegion",
  29                     "|xns": "Roo"
  30                 },
  31                 {
  32                     "region": "north",
  33                     "xtype": "NestedLayoutPanel",
  34                     "|xns": "Roo",
  35                     "items": [
  36                         {
  37                             "|xns": "Roo",
  38                             "xtype": "BorderLayout",
  39                             "*prop": "layout",
  40                             "items": [
  41                                 {
  42                                     "|xns": "Roo",
  43                                     "xtype": "LayoutRegion",
  44                                     "*prop": "center"
  45                                 },
  46                                 {
  47                                     "*prop": "east",
  48                                     "titlebar": true,
  49                                     "width": 250,
  50                                     "xtype": "LayoutRegion",
  51                                     "|xns": "Roo"
  52                                 },
  53                                 {
  54                                     "listeners": {
  55                                         "|activate": "function() {\n    _this.cmpanel = this;\n\n}"
  56                                     },
  57                                     "background": false,
  58                                     "fitContainer": true,
  59                                     "fitToframe": true,
  60                                     "region": "east",
  61                                     "tableName": "cmhead",
  62                                     "title": "Apply Credit Memos",
  63                                     "xtype": "GridPanel",
  64                                     "|xns": "Roo",
  65                                     "items": [
  66                                         {
  67                                             "listeners": {
  68                                                 "|render": "function() \n{\n    _this.cmgrid = this; \n    \n}",
  69                                                 "cellclick": "function (_self, rowIndex, columnIndex, e)\n{\n\n       if (columnIndex > 0 ) {\n           return;\n       } \n       var d = this.ds.getAt(rowIndex);\n       var f = this.cm.getDataIndex(columnIndex);\n       \n       // toggle it..\n    \n       d.set(f, d.data[f] * 1 ? 0 : 1);\n        \n        // sort out shipping.\n       _this.form.findField('cobapply_list').update();\n          \n       \n}",
  70                                                 "rowdblclick": "function (_self, rowIndex, e)\n{\n    var s = _this.cmgrid.ds.getAt(rowIndex);\n\n    Pman.Dialog.XtupleCreditMemo.show({\n        cmhead_id : s.data.join_aropen_cmhead_id\n    },function() {\n        _this.cmgrid.ds.load({});\n    \n    });\n}"
  71                                             },
  72                                             "*prop": "grid",
  73                                             "autoExpandColumn": "aropen_docnumber",
  74                                             "loadMask": true,
  75                                             "xtype": "Grid",
  76                                             "|xns": "Roo.grid",
  77                                             "items": [
  78                                                 {
  79                                                     "|xns": "Roo",
  80                                                     "xtype": "Toolbar",
  81                                                     "*prop": "toolbar",
  82                                                     "items": [
  83                                                         {
  84                                                             "|xns": "Roo.Toolbar",
  85                                                             "xtype": "Fill"
  86                                                         },
  87                                                         {
  88                                                             "listeners": {
  89                                                                 "|click": "function()\n{\n    var postit = function(params){\n        new Pman.Request(\r\n        {\r\n            url : baseURL + '/Roo/Cmhead',\r\n            mask: params.mask,\r\n            method : 'POST',\r\n            params : params.postdata,\r\n            success : function(res)\r\n            {\r\n                 _this.cmgrid.ds.load({});\n                (function(){\n                    _this.cmgrid.ds.each(function(d){\n                        if(d.data.join_aropen_cmhead_id == res.data){\n                            d.set('toapply', 1);\n                            return false;\n                        }\n                    })\n                }).defer(500);\r\n            } \r\n        });\r\n    }\n    var opendialog  = function(data){\n        Pman.Dialog.XtupleCreditMemo.show( data , function(res) {\n            if(!res.has_item){\n               Roo.MessageBox.confirm(\r\n                    \"Confirm\",\r\n                    \"These is no any credit items in this credit memo! Press YES to reopen the dialog for editing, Press NO will delete this credit memo.\",\r\n                    function(r) {\r\n                        if (r != 'yes') {\n                            // delete the credit memo\n                            Roo.log('deleting');\n                            var params = {\n                                postdata : {\n                                    _delete : res.cmhead_id\n                                },\n                                mask : 'Deleting'\n                            };\n                            postit(params);\r\n                            return;\r\n                        }\n                        // reopen\r\n                        opendialog({cmhead_id : res.cmhead_id});\n                        return;\r\n                    }\r\n                ); \n                return;\n            }\n            \n            Roo.MessageBox.confirm(\r\n                \"Confirm Posting\",\r\n                \"Are you sure this credit memo is complete? <B>Voiding a Credit memo involves creating a sales order and invoice </b>, so make sure this is correct before posting! Press YES will post it, Press NO to reopen the dialog for editing.\",\r\n                function(r) {\r\n                    if (r != 'yes') {\n                        opendialog({cmhead_id : res.cmhead_id});\n                        return;\r\n                    }\r\n                    // postit\n                    var params = {\n                        postdata : {\n                            cmhead_id : res.cmhead_id,\n                            _post : 1\n                        },\n                        mask : 'Posting'\n                    };\n                    postit(params);\n                   \n                    return;\r\n                }\r\n            );\n            \n            \n            \n        })\n    }\n    \n    \n    \n    var cmdata = {\n            cmhead_cust_id : _this.data.cmdata.cm_cust_id,\n            cmhead_cust_id_cust_name : _this.data.cmdata.cm_cust_id_cust_name,\n            cmhead_curr_id : _this.data.cmdata.cm_curr_id,\n            cmhead_curr_id_curr_name : _this.data.cmdata.cm_curr_id_curr_name,\n            cmhead_terms_id : _this.data.cmdata.cm_terms_id,\n            cmhead_terms_id_terms_descrip : _this.data.cmdata.cm_terms_id_terms_descrip,\n            cmhead_salesrep_id : _this.data.cmdata.cm_salesrep_id,\n            cmhead_salesrep_id_salesrep_name : _this.data.cmdata.cm_salesrep_id_salesrep_name,\n            cmhead_docdate : new Date(),\n            cmhead_taxzone_id : _this.data.cmdata.cm_taxzone_id,\n            cmhead_taxzone_id_taxzone_descrip : _this.data.cmdata.cm_taxzone_id_taxzone_descrip,\n            cmhead_billto_cntct_id : _this.data.cmdata.cm_billto_cntct_id,\n            cmhead_billto_cntct_id_cntct_name : _this.data.cmdata.cm_billto_cntct_id_cntct_name,\n            cmhead_location_id : _this.data.cmdata.cm_location_src,\n            cmhead_location_id_location_name : _this.data.cmdata.cm_location_src_location_name,\n            billto_address : _this.data.cmdata.cm_billto_address\n            \n            \n    };\n    \n    opendialog(cmdata);\n    \n}\n"
  90                                                             },
  91                                                             "cls": "x-btn-text-icon",
  92                                                             "text": "Add",
  93                                                             "xtype": "Button",
  94                                                             "|icon": "Roo.rootURL + 'images/default/dd/drop-add.gif'",
  95                                                             "|xns": "Roo.Toolbar"
  96                                                         }
  97                                                     ]
  98                                                 },
  99                                                 {
 100                                                     "listeners": {
 101                                                         "beforeload": "function (_self, o)\n{\n    o.params = o.params || {};\n    o.params.limit = 999;\n    o.params._opencm = 1;\n    o.params._for_cohead = _this.form.findField('cobmisc_cohead_id').getValue();\n    o.params._for_cobmisc_id = _this.form.findField('cobmisc_id').getValue();\n}",
 102                                                         "load": "function (_self, records, options)\n{\n     _this.form.findField('cobapply_list').update();\n}"
 103                                                     },
 104                                                     "*prop": "dataSource",
 105                                                     "remoteSort": true,
 106                                                     "xtype": "Store",
 107                                                     "|sortInfo": "{ field : 'aropen_docnumber', direction: 'DESC' }",
 108                                                     "|xns": "Roo.data",
 109                                                     "items": [
 110                                                         {
 111                                                             "*prop": "proxy",
 112                                                             "method": "GET",
 113                                                             "xtype": "HttpProxy",
 114                                                             "|url": "baseURL + '/Roo/aropen.php'",
 115                                                             "|xns": "Roo.data"
 116                                                         },
 117                                                         {
 118                                                             "|xns": "Roo.data",
 119                                                             "xtype": "JsonReader",
 120                                                             "totalProperty": "total",
 121                                                             "root": "data",
 122                                                             "*prop": "reader",
 123                                                             "id": "id",
 124                                                             "|fields": "[\n    {\n        'name': 'cmhead_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_number',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_posted',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_invcnumber',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_custponumber',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_cust_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_docdate',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'cmhead_shipto_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_shipto_name',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_address1',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_address2',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_address3',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_city',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_state',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_zipcode',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_salesrep_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_freight',\n        'type': 'float'\n    },\n    {\n        'name': 'cmhead_misc',\n        'type': 'float'\n    },\n    {\n        'name': 'cmhead_comments',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_printed',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_billtoname',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtoaddress1',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtoaddress2',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtoaddress3',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtocity',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtostate',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_billtozip',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_hold',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_commission',\n        'type': 'float'\n    },\n    {\n        'name': 'cmhead_misc_accnt_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_misc_descrip',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_rsncode_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_curr_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_freighttaxtype_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_gldistdate',\n        'type': 'date',\n        'dateFormat': 'Y-m-d'\n    },\n    {\n        'name': 'cmhead_billtocountry',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_shipto_country',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_rahead_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_taxzone_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_prj_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_curr_id_curr_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_curr_id_curr_base',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_curr_id_curr_name',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_curr_id_curr_symbol',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_curr_id_curr_abbr',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_taxzone_id_taxzone_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_taxzone_id_taxzone_code',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_taxzone_id_taxzone_descrip',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_number',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_name',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_descrip',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_status',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_so',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_wo',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_po',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_owner_username',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_start_date',\n        'type': 'date'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_due_date',\n        'type': 'date'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_assigned_date',\n        'type': 'date'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_completed_date',\n        'type': 'date'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_username',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_prj_id_prj_recurring_prj_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_freighttaxtype_id_taxtype_id',\n        'type': 'int'\n    },\n    {\n        'name': 'cmhead_freighttaxtype_id_taxtype_name',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_freighttaxtype_id_taxtype_descrip',\n        'type': 'string'\n    },\n    {\n        'name': 'cmhead_freighttaxtype_id_taxtype_sys',\n        'type': 'int'\n    }\n]"
 125                                                         }
 126                                                     ]
 127                                                 },
 128                                                 {
 129                                                     "*prop": "colModel[]",
 130                                                     "dataIndex": "toapply",
 131                                                     "header": "Apply",
 132                                                     "width": 50,
 133                                                     "xtype": "ColumnModel",
 134                                                     "|renderer": "function(v,x,r) { \n\n    return     '<img class=\"x-grid-check-icon' + \n                    (v*1 ? '-checked' : '')  + '\" src=\"' + Roo.BLANK_IMAGE_URL + '\"/>';\n                                        \n    \n}",
 135                                                     "|xns": "Roo.grid"
 136                                                 },
 137                                                 {
 138                                                     "*prop": "colModel[]",
 139                                                     "dataIndex": "aropen_docnumber",
 140                                                     "header": "Number#",
 141                                                     "width": 150,
 142                                                     "xtype": "ColumnModel",
 143                                                     "|renderer": "function(v) { return String.format('{0}', v); }",
 144                                                     "|xns": "Roo.grid"
 145                                                 },
 146                                                 {
 147                                                     "*prop": "colModel[]",
 148                                                     "align": "right",
 149                                                     "dataIndex": "balance",
 150                                                     "header": "Amount Avail",
 151                                                     "width": 75,
 152                                                     "xtype": "ColumnModel",
 153                                                     "|renderer": "function(v,x,r) { \n    if (r.data.applied*1.0 > 0.0)  {\n        return String.format('{0}', r.data.applied*1.0); \n    }\n\n    return String.format('{0}', v); \n}",
 154                                                     "|xns": "Roo.grid"
 155                                                 }
 156                                             ]
 157                                         }
 158                                     ]
 159                                 },
 160                                 {
 161                                     "region": "center",
 162                                     "xtype": "ContentPanel",
 163                                     "|xns": "Roo",
 164                                     "items": [
 165                                         {
 166                                             "listeners": {
 167                                                 "|actioncomplete": "function (_self,action) {\n     if (action.type == 'setdata') {\n        if (_this.data.cobmisc_id) {\n            this.load({ method: 'GET', params: { '_id' : _this.data.cobmisc_id }});\n           return;\n       }      \n       \n           \n       \n       _this.saveBtn.show();\n       // see if we can create an invoice...\n       new Pman.Request({\n            url : baseURL + '/Roo/Cobmisc',\n            params : {\n                _canCreate : _this.data.cobmisc_cohead_id\n            },\n            method : 'GET',\n            success: function(r) {\n                if (r.data.canCreate * 1 > 0 ) {\n                    Roo.MessageBox.alert(\n                        \"Error\", \"An unposted Bill already exists for this order\"\n                    );\n                    _this.dialog.hide();\n                    return;\n                }\n\n               // _this.form.findField('cobmisc_misc').setValue(r.data.cohead.cohead_misc);\n                _this.form.findField('cobmisc_misc').setValue(r.data.cohead.cohead_pretax_discount);\n                _this.form.findField('cobmisc_cohead_id_cohead_pretax_discount').setValue(r.data.cohead.cohead_pretax_discount);\n                _this.form.findField('cobmisc_posttax_discount').setValue(\n                    (1* r.data.cohead.cohead_posttax_discount) //- (1*r.data.cohead.cohead_pretax_discount)\n                );\n               // _this.form.findField('cobmisc_cohead_id_cohead_posttax_discount').setValue(r.data.cohead.cohead_posttax_discount);\n                _this.form.findField('cobmisc_misc_descrip').setValue(r.data.cohead.cohead_misc_descrip);\n               _this.grid.ds.load({});\n            }\n        });\n             \n        \n    }\n    if (action.type == 'load') {\n        var d = action.result.data;\n        \n        \n        if(d.cobmisc_misc != 0 && d.cobmisc_posttax_discount == 0 && d.cobmisc_cohead_id_cohead_pretax_discount == 0){\n            _this.form.findField('cobmisc_cohead_id_cohead_pretax_discount').setValue(d.cobmisc_misc);\n        }\n        \n        _this.form.findField('cobmisc_posttax_discount').setValue(d.cobmisc_misc - d.cobmisc_cohead_id_cohead_pretax_discount);\n        \n        if (d.cobmisc_invchead_id *1 > 0) {\n                Roo.MessageBox.alert(\n                        \"Warning\", \"This invoice has been posted, you must void it before you can edit it\"\n                    );\n\n                _this.saveBtn.hide();\n            \n        } else {\n            _this.saveBtn.show();\n        }\n         _this.grid.ds.load({});\n        return;\n    }\n    if (action.type =='submit') {\n    \n        _this.dialog.hide();\n    \n         if (_this.callback) {\n            _this.callback.call(_this, _this.form.getValues());\n         }\n         _this.form.reset();\n         return;\n    }\n    \n}\n",
 168                                                 "|rendered": "function (form)\n{\n    _this.form= form;\n}\n"
 169                                             },
 170                                             "method": "POST",
 171                                             "style": "margin:10px;",
 172                                             "xtype": "Form",
 173                                             "|recalc": "function() {\n    // recalc prices.\n    var error = 0;\n    var ic = 0.0;\n    var total_tax = 0.0;\n    _this.grid.ds.each(function(r) {\n        ic += ((r.data.cobill_qty * r.data.coitem_price).toFixed(2) * 1);\n        if (r.data.calc_tax) {\n            // either full, or a proportion of...\n            total_tax += (r.data.cobill_qty == r.data.coitem_qtyord) ? \n                (1*r.data.calc_tax) : (\n                    (1*r.data.calc_tax) * (r.data.cobill_qty / r.data.coitem_qtyord)\n                );\n        }\n    \n    });\n    \n    _this.form.findField('cobmisc_itemcost').setValue(ic.toFixed(2));    \n    _this.form.findField('cobmisc_total_tax').setValue( total_tax.toFixed(2));\n\n    \n    var total  = (_this.form.findField('cobmisc_itemcost').getValue() * 1.0) +\n         ( _this.form.findField('cobmisc_freight').getValue() * 1.0)  + \n \n         ( _this.form.findField('cobmisc_cohead_id_cohead_pretax_discount').getValue() * 1.0)  + \n         ( _this.form.findField('cobmisc_posttax_discount').getValue() * 1.0)  + \n         ( _this.form.findField('cobmisc_total_tax').getValue() * 1.0)   \n         ;\n\n    // special handling for credit memos.\n    \n    var val = 0.0;\r\n    var count = 0;\r\n    _this.cmgrid.ds.each(function(r) {\r\n        if (r.data.toapply *  1)  { \r\n            count = count + 1;\r\n            if (r.data.applied *1.0 > 0.0) {\r\n                val += parseFloat(r.data.applied);\r\n                return;\r\n            }\r\n            val += parseFloat(r.data.balance);\r\n        }\r\n       \r\n    });\r\n    if(count == 1 && total < val){\n        val = total;\n    }\n    \n    _this.form.findField('cobmisc_cm_total').setValue( (val * -1).toFixed(2));\n    _this.form.findField('cobmisc_total').setValue((total - val).toFixed(2));\n    _this.form.findField('cobapply_total').setValue((val * -1).toFixed(2));\n    \n    /*\n    if (total < 0.0) {\n        // this is an error condition.\n        _this.form.findField('cobmisc_total').setValue(total);\n        return;\n    \n    }\n \n   \n    var cmlist =  _this.form.findField('cobapply_list').getValue();\n    var cmval =  _this.form.findField('cobapply_total').getValue() * 1.0;\n    \n    if (total + cmval >= 0.0 ) {\n        _this.form.findField('cobmisc_total').setValue(((total + cmval) * 1.0).toFixed(2));\n        return; \n    }\n    if (cmlist.length || cmlist.split(',').length > 1) {\n        _this.form.findField('cobmisc_total').setValue(total + cmval);         \n        return;\n    }\n    // fixme we need to work out the correct value...\n    \n     _this.form.findField('cobmisc_cm_total').setValue( (total * -1).toFixed(2));\n    \n    _this.form.findField('cobmisc_total').setValue(0.0);         \n        \n    */\n    \n}\n",
 174                                             "|url": "baseURL + '/Roo/cobmisc.php'",
 175                                             "|xns": "Roo.form",
 176                                             "items": [
 177                                                 {
 178                                                     "width": 750,
 179                                                     "xtype": "Row",
 180                                                     "|xns": "Roo.form",
 181                                                     "items": [
 182                                                         {
 183                                                             "width": 250,
 184                                                             "xtype": "Column",
 185                                                             "|xns": "Roo.form",
 186                                                             "items": [
 187                                                                 {
 188                                                                     "legend": "Invoice Details",
 189                                                                     "style": "width:230px",
 190                                                                     "xtype": "FieldSet",
 191                                                                     "|xns": "Roo.form",
 192                                                                     "items": [
 193                                                                         {
 194                                                                             "fieldLabel": "Invoice Date",
 195                                                                             "format": "Y-m-d",
 196                                                                             "name": "cobmisc_invcdate",
 197                                                                             "width": 100,
 198                                                                             "xtype": "DateField",
 199                                                                             "|xns": "Roo.form"
 200                                                                         },
 201                                                                         {
 202                                                                             "fieldLabel": "Shipment Date",
 203                                                                             "format": "Y-m-d",
 204                                                                             "name": "cobmisc_shipdate",
 205                                                                             "width": 100,
 206                                                                             "xtype": "DateField",
 207                                                                             "|xns": "Roo.form"
 208                                                                         }
 209                                                                     ]
 210                                                                 },
 211                                                                 {
 212                                                                     "labelAlign": "top",
 213                                                                     "xtype": "Row",
 214                                                                     "|xns": "Roo.form",
 215                                                                     "items": [
 216                                                                         {
 217                                                                             "fieldLabel": "Notes",
 218                                                                             "height": 100,
 219                                                                             "name": "cobmisc_notes",
 220                                                                             "width": 240,
 221                                                                             "xtype": "TextArea",
 222                                                                             "|xns": "Roo.form"
 223                                                                         }
 224                                                                     ]
 225                                                                 }
 226                                                             ]
 227                                                         },
 228                                                         {
 229                                                             "labelAlign": "left",
 230                                                             "style": "margin-left:10px",
 231                                                             "width": 350,
 232                                                             "xtype": "Column",
 233                                                             "|xns": "Roo.form",
 234                                                             "items": [
 235                                                                 {
 236                                                                     "labelAlign": "right",
 237                                                                     "labelWidth": 220,
 238                                                                     "legend": "Charges",
 239                                                                     "style": "width:330px",
 240                                                                     "xtype": "FieldSet",
 241                                                                     "|xns": "Roo.form",
 242                                                                     "items": [
 243                                                                         {
 244                                                                             "allowDecimals": true,
 245                                                                             "cls": "roo-align-right",
 246                                                                             "decimalPrecision": 3,
 247                                                                             "fieldLabel": "Item(s) Total",
 248                                                                             "name": "cobmisc_itemcost",
 249                                                                             "readOnly": true,
 250                                                                             "width": 80,
 251                                                                             "xtype": "NumberField",
 252                                                                             "|xns": "Roo.form"
 253                                                                         },
 254                                                                         {
 255                                                                             "listeners": {
 256                                                                                 "keyup": "function (_self, e)\n{\n   _this.form.recalc();\n}"
 257                                                                             },
 258                                                                             "allowDecimals": true,
 259                                                                             "cls": "roo-align-right",
 260                                                                             "decimalPrecision": 3,
 261                                                                             "fieldLabel": "Shipping",
 262                                                                             "name": "cobmisc_freight",
 263                                                                             "width": 80,
 264                                                                             "xtype": "NumberField",
 265                                                                             "|xns": "Roo.form"
 266                                                                         },
 267                                                                         {
 268                                                                             "allowDecimals": true,
 269                                                                             "cls": "roo-align-right",
 270                                                                             "decimalPrecision": 3,
 271                                                                             "fieldLabel": "Pre Tax discount:",
 272                                                                             "name": "cobmisc_cohead_id_cohead_pretax_discount",
 273                                                                             "readOnly": true,
 274                                                                             "width": 80,
 275                                                                             "xtype": "NumberField",
 276                                                                             "|xns": "Roo.form"
 277                                                                         },
 278                                                                         {
 279                                                                             "labelAlign": "top",
 280                                                                             "width": 430,
 281                                                                             "xtype": "Row",
 282                                                                             "|xns": "Roo.form",
 283                                                                             "items": [
 284                                                                                 {
 285                                                                                     "fieldLabel": "Discount after Tax Description ",
 286                                                                                     "name": "cobmisc_misc_descrip",
 287                                                                                     "width": 205,
 288                                                                                     "xtype": "TextField",
 289                                                                                     "|xns": "Roo.form"
 290                                                                                 },
 291                                                                                 {
 292                                                                                     "listeners": {
 293                                                                                         "keyup": "function (_self, e)\n{\n   _this.form.recalc();\n   _this.form.findField('cobmisc_misc').recalc();\n}"
 294                                                                                     },
 295                                                                                     "allowDecimals": true,
 296                                                                                     "cls": "roo-align-right",
 297                                                                                     "decimalPrecision": 3,
 298                                                                                     "fieldLabel": "Amount",
 299                                                                                     "name": "cobmisc_posttax_discount",
 300                                                                                     "width": 80,
 301                                                                                     "xtype": "NumberField",
 302                                                                                     "|xns": "Roo.form"
 303                                                                                 }
 304                                                                             ]
 305                                                                         },
 306                                                                         {
 307                                                                             "allowDecimals": true,
 308                                                                             "cls": "roo-align-right",
 309                                                                             "decimalPrecision": 3,
 310                                                                             "fieldLabel": "Tax",
 311                                                                             "name": "cobmisc_total_tax",
 312                                                                             "readOnly": true,
 313                                                                             "width": 80,
 314                                                                             "xtype": "NumberField",
 315                                                                             "|xns": "Roo.form"
 316                                                                         },
 317                                                                         {
 318                                                                             "allowDecimals": true,
 319                                                                             "cls": "roo-align-right",
 320                                                                             "decimalPrecision": 3,
 321                                                                             "fieldLabel": "Credit Memos Applied",
 322                                                                             "name": "cobmisc_cm_total",
 323                                                                             "readOnly": true,
 324                                                                             "width": 80,
 325                                                                             "xtype": "NumberField",
 326                                                                             "|xns": "Roo.form"
 327                                                                         },
 328                                                                         {
 329                                                                             "allowDecimals": true,
 330                                                                             "cls": "roo-align-right",
 331                                                                             "decimalPrecision": 3,
 332                                                                             "fieldLabel": "Total",
 333                                                                             "minValue": 0,
 334                                                                             "name": "cobmisc_total",
 335                                                                             "readOnly": true,
 336                                                                             "width": 80,
 337                                                                             "xtype": "NumberField",
 338                                                                             "|xns": "Roo.form"
 339                                                                         }
 340                                                                     ]
 341                                                                 }
 342                                                             ]
 343                                                         }
 344                                                     ]
 345                                                 },
 346                                                 {
 347                                                     "name": "cobmisc_misc",
 348                                                     "xtype": "Hidden",
 349                                                     "|recalc": "function() {\r\n    var d = _this.form.getValues();\r\n    this.setValue( \r\n        parseFloat(d.cobmisc_cohead_id_cohead_pretax_discount) + \r\n        parseFloat(d.cobmisc_posttax_discount) );\r\n}\r",
 350                                                     "|xns": "Roo.form"
 351                                                 },
 352                                                 {
 353                                                     "name": "cobmisc_cohead_id",
 354                                                     "xtype": "Hidden",
 355                                                     "|xns": "Roo.form"
 356                                                 },
 357                                                 {
 358                                                     "name": "cobmisc_id",
 359                                                     "xtype": "Hidden",
 360                                                     "|xns": "Roo.form"
 361                                                 },
 362                                                 {
 363                                                     "name": "cobapply_total",
 364                                                     "xtype": "Hidden",
 365                                                     "|xns": "Roo.form"
 366                                                 },
 367                                                 {
 368                                                     "name": "cobapply_list",
 369                                                     "xtype": "Hidden",
 370                                                     "|update": "function() {\n   var ret = [];\n   var val = 0.0;\n   var count = 0;\n    _this.cmgrid.ds.each(function(r) {\n    \n        if (r.data.toapply *  1)  {\n            count = count + 1;\n            ret.push(r.data.aropen_id);\n            if (r.data.applied *1.0 > 0.0) {\n                val += parseFloat(r.data.applied);\n                return;\n            }\n\n            val += parseFloat(r.data.balance);\n        }\n    });\n    \n    var total  = (_this.form.findField('cobmisc_itemcost').getValue() * 1.0) +\r\n                 ( _this.form.findField('cobmisc_freight').getValue() * 1.0)  + \r\n         \r\n                 ( _this.form.findField('cobmisc_cohead_id_cohead_pretax_discount').getValue() * 1.0)  + \r\n                 ( _this.form.findField('cobmisc_posttax_discount').getValue() * 1.0)  + \r\n                 ( _this.form.findField('cobmisc_total_tax').getValue() * 1.0)   \r\n                 ;\r\n\r\n    if(count > 1 && total < val){\r\n        Roo.Msg.alert('Error', 'Credit memo total goes over the invoice total');\r\n    }\r\n    this.setValue(ret.join(','));\n    _this.form.findField('cobmisc_cm_total').setValue( (val * -1).toFixed(2));\n    _this.form.findField('cobapply_total').setValue( (val * -1).toFixed(2));\n    _this.form.recalc();\n}\n",
 371                                                     "|xns": "Roo.form"
 372                                                 },
 373                                                 {
 374                                                     "name": "billitems",
 375                                                     "xtype": "Hidden",
 376                                                     "|xns": "Roo.form"
 377                                                 }
 378                                             ]
 379                                         }
 380                                     ]
 381                                 }
 382                             ]
 383                         }
 384                     ]
 385                 },
 386                 {
 387                     "listeners": {
 388                         "|activate": "function() {\n    _this.panel = this;\n    \n    if (_this.isBuilder) {\n        return;\n    }\n    \n   \n    if (_this.grid) {\n        _this.grid.ds.load({});\n    }\n}"
 389                     },
 390                     ".builderCfg": "{\"cols\":[{\"table\":\"coitem\",\"column\":\"coitem_linenumber\",\"columnshort\":\"coitem_linenumber\",\"ctype\":\"int4\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Item#\"},{\"table\":\"coitem\",\"column\":\"coitem_itemsite_id\",\"columnshort\":\"coitem_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"itemsite_id\",\"deps\":[{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_item_id\",\"columnshort\":\"itemsite_item_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warehous_id\",\"columnshort\":\"itemsite_warehous_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_qtyonhand\",\"columnshort\":\"itemsite_qtyonhand\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_reorderlevel\",\"columnshort\":\"itemsite_reorderlevel\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordertoqty\",\"columnshort\":\"itemsite_ordertoqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cyclecountfreq\",\"columnshort\":\"itemsite_cyclecountfreq\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastcount\",\"columnshort\":\"itemsite_datelastcount\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastused\",\"columnshort\":\"itemsite_datelastused\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_loccntrl\",\"columnshort\":\"itemsite_loccntrl\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_safetystock\",\"columnshort\":\"itemsite_safetystock\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_minordqty\",\"columnshort\":\"itemsite_minordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_multordqty\",\"columnshort\":\"itemsite_multordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_leadtime\",\"columnshort\":\"itemsite_leadtime\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_abcclass\",\"columnshort\":\"itemsite_abcclass\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_issuemethod\",\"columnshort\":\"itemsite_issuemethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_controlmethod\",\"columnshort\":\"itemsite_controlmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_active\",\"columnshort\":\"itemsite_active\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_plancode_id\",\"columnshort\":\"itemsite_plancode_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costcat_id\",\"columnshort\":\"itemsite_costcat_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_eventfence\",\"columnshort\":\"itemsite_eventfence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_sold\",\"columnshort\":\"itemsite_sold\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_stocked\",\"columnshort\":\"itemsite_stocked\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_freeze\",\"columnshort\":\"itemsite_freeze\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_id\",\"columnshort\":\"itemsite_location_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparams\",\"columnshort\":\"itemsite_useparams\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparamsmanual\",\"columnshort\":\"itemsite_useparamsmanual\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_soldranking\",\"columnshort\":\"itemsite_soldranking\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createpr\",\"columnshort\":\"itemsite_createpr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location\",\"columnshort\":\"itemsite_location\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_comments\",\"columnshort\":\"itemsite_location_comments\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_notes\",\"columnshort\":\"itemsite_notes\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_perishable\",\"columnshort\":\"itemsite_perishable\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_nnqoh\",\"columnshort\":\"itemsite_nnqoh\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoabcclass\",\"columnshort\":\"itemsite_autoabcclass\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup\",\"columnshort\":\"itemsite_ordergroup\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_disallowblankwip\",\"columnshort\":\"itemsite_disallowblankwip\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_maxordqty\",\"columnshort\":\"itemsite_maxordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_mps_timefence\",\"columnshort\":\"itemsite_mps_timefence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createwo\",\"columnshort\":\"itemsite_createwo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warrpurc\",\"columnshort\":\"itemsite_warrpurc\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoreg\",\"columnshort\":\"itemsite_autoreg\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costmethod\",\"columnshort\":\"itemsite_costmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_value\",\"columnshort\":\"itemsite_value\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup_first\",\"columnshort\":\"itemsite_ordergroup_first\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_supply_itemsite_id\",\"columnshort\":\"itemsite_supply_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_planning_type\",\"columnshort\":\"itemsite_planning_type\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_wosupply\",\"columnshort\":\"itemsite_wosupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_posupply\",\"columnshort\":\"itemsite_posupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_lsseq_id\",\"columnshort\":\"itemsite_lsseq_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cosdefault\",\"columnshort\":\"itemsite_cosdefault\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopr\",\"columnshort\":\"itemsite_createsopr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopo\",\"columnshort\":\"itemsite_createsopo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_dropship\",\"columnshort\":\"itemsite_dropship\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyord\",\"columnshort\":\"coitem_qtyord\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Qty\"},{\"table\":\"coitem\",\"column\":\"coitem_unitcost\",\"columnshort\":\"coitem_unitcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Unit Cost\"},{\"table\":\"coitem\",\"column\":\"coitem_price\",\"columnshort\":\"coitem_price\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Price\"},{\"table\":\"coitem\",\"column\":\"coitem_custprice\",\"columnshort\":\"coitem_custprice\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Cust Price\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreturned\",\"columnshort\":\"coitem_qtyreturned\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#Returned\"},{\"table\":\"coitem\",\"column\":\"coitem_prcost\",\"columnshort\":\"coitem_prcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"prcost?\"},{\"table\":\"coitem\",\"column\":\"coitem_price_uom_id\",\"columnshort\":\"coitem_price_uom_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"uom_id\",\"deps\":[{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_name\",\"columnshort\":\"uom_name\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_descrip\",\"columnshort\":\"uom_descrip\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_item_weight\",\"columnshort\":\"uom_item_weight\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"Unit of\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreserved\",\"columnshort\":\"coitem_qtyreserved\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#reserved\"}],\"cols_ex\":[\"coitem_price_uom_id_uom_descrip\"],\"table\":\"coitem\",\"xtype\":\"GridPanel\",\"|xns\":\"Roo\"}",
 391                     "fitContainer": true,
 392                     "fitToframe": true,
 393                     "region": "center",
 394                     "tableName": "coitem",
 395                     "title": "Order Items",
 396                     "xtype": "GridPanel",
 397                     "|xns": "Roo",
 398                     "items": [
 399                         {
 400                             "listeners": {
 401                                 "|render": "function() \n{\n    _this.grid = this; \n    //_this.dialog = Pman.Dialog.FILL_IN\n    if (_this.panel.active) {\n       this.ds.load({});\n    }\n}",
 402                                 "|rowdblclick": "function (_self, rowIndex, e)\n{\n    \n}\n",
 403                                 "afteredit": "function (e)\n{\n    //Roo.log('afteredit');\n   // Roo.log(e);\n    if (e.field == 'item_number') {\n        // afterselect handles this...\n        return;\n    }\n    e.record.commit();\n}"
 404                             },
 405                             "*prop": "grid",
 406                             ".builderCfg": "{\"cols\":[{\"table\":\"coitem\",\"column\":\"coitem_linenumber\",\"columnshort\":\"coitem_linenumber\",\"ctype\":\"int4\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Item#\"},{\"table\":\"coitem\",\"column\":\"coitem_itemsite_id\",\"columnshort\":\"coitem_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"itemsite_id\",\"deps\":[{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_item_id\",\"columnshort\":\"itemsite_item_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warehous_id\",\"columnshort\":\"itemsite_warehous_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_qtyonhand\",\"columnshort\":\"itemsite_qtyonhand\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_reorderlevel\",\"columnshort\":\"itemsite_reorderlevel\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordertoqty\",\"columnshort\":\"itemsite_ordertoqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cyclecountfreq\",\"columnshort\":\"itemsite_cyclecountfreq\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastcount\",\"columnshort\":\"itemsite_datelastcount\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastused\",\"columnshort\":\"itemsite_datelastused\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_loccntrl\",\"columnshort\":\"itemsite_loccntrl\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_safetystock\",\"columnshort\":\"itemsite_safetystock\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_minordqty\",\"columnshort\":\"itemsite_minordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_multordqty\",\"columnshort\":\"itemsite_multordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_leadtime\",\"columnshort\":\"itemsite_leadtime\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_abcclass\",\"columnshort\":\"itemsite_abcclass\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_issuemethod\",\"columnshort\":\"itemsite_issuemethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_controlmethod\",\"columnshort\":\"itemsite_controlmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_active\",\"columnshort\":\"itemsite_active\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_plancode_id\",\"columnshort\":\"itemsite_plancode_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costcat_id\",\"columnshort\":\"itemsite_costcat_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_eventfence\",\"columnshort\":\"itemsite_eventfence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_sold\",\"columnshort\":\"itemsite_sold\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_stocked\",\"columnshort\":\"itemsite_stocked\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_freeze\",\"columnshort\":\"itemsite_freeze\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_id\",\"columnshort\":\"itemsite_location_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparams\",\"columnshort\":\"itemsite_useparams\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparamsmanual\",\"columnshort\":\"itemsite_useparamsmanual\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_soldranking\",\"columnshort\":\"itemsite_soldranking\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createpr\",\"columnshort\":\"itemsite_createpr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location\",\"columnshort\":\"itemsite_location\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_comments\",\"columnshort\":\"itemsite_location_comments\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_notes\",\"columnshort\":\"itemsite_notes\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_perishable\",\"columnshort\":\"itemsite_perishable\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_nnqoh\",\"columnshort\":\"itemsite_nnqoh\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoabcclass\",\"columnshort\":\"itemsite_autoabcclass\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup\",\"columnshort\":\"itemsite_ordergroup\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_disallowblankwip\",\"columnshort\":\"itemsite_disallowblankwip\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_maxordqty\",\"columnshort\":\"itemsite_maxordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_mps_timefence\",\"columnshort\":\"itemsite_mps_timefence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createwo\",\"columnshort\":\"itemsite_createwo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warrpurc\",\"columnshort\":\"itemsite_warrpurc\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoreg\",\"columnshort\":\"itemsite_autoreg\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costmethod\",\"columnshort\":\"itemsite_costmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_value\",\"columnshort\":\"itemsite_value\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup_first\",\"columnshort\":\"itemsite_ordergroup_first\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_supply_itemsite_id\",\"columnshort\":\"itemsite_supply_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_planning_type\",\"columnshort\":\"itemsite_planning_type\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_wosupply\",\"columnshort\":\"itemsite_wosupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_posupply\",\"columnshort\":\"itemsite_posupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_lsseq_id\",\"columnshort\":\"itemsite_lsseq_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cosdefault\",\"columnshort\":\"itemsite_cosdefault\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopr\",\"columnshort\":\"itemsite_createsopr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopo\",\"columnshort\":\"itemsite_createsopo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_dropship\",\"columnshort\":\"itemsite_dropship\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyord\",\"columnshort\":\"coitem_qtyord\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Qty\"},{\"table\":\"coitem\",\"column\":\"coitem_unitcost\",\"columnshort\":\"coitem_unitcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Unit Cost\"},{\"table\":\"coitem\",\"column\":\"coitem_price\",\"columnshort\":\"coitem_price\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Price\"},{\"table\":\"coitem\",\"column\":\"coitem_custprice\",\"columnshort\":\"coitem_custprice\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Cust Price\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreturned\",\"columnshort\":\"coitem_qtyreturned\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#Returned\"},{\"table\":\"coitem\",\"column\":\"coitem_prcost\",\"columnshort\":\"coitem_prcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"prcost?\"},{\"table\":\"coitem\",\"column\":\"coitem_price_uom_id\",\"columnshort\":\"coitem_price_uom_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"uom_id\",\"deps\":[{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_name\",\"columnshort\":\"uom_name\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_descrip\",\"columnshort\":\"uom_descrip\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_item_weight\",\"columnshort\":\"uom_item_weight\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"Unit of\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreserved\",\"columnshort\":\"coitem_qtyreserved\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#reserved\"}],\"cols_ex\":[\"coitem_price_uom_id_uom_descrip\"],\"table\":\"coitem\",\"xtype\":\"GridPanel\",\"|xns\":\"Roo\"}",
 407                             "autoExpandColumn": "item_descrip1",
 408                             "clicksToEdit": 1,
 409                             "loadMask": true,
 410                             "xtype": "EditorGrid",
 411                             "|xns": "Roo.grid",
 412                             "items": [
 413                                 {
 414                                     "*prop": "sm",
 415                                     "enter_is_tab": true,
 416                                     "xtype": "CellSelectionModel",
 417                                     "|xns": "Roo.grid"
 418                                 },
 419                                 {
 420                                     "listeners": {
 421                                         "|beforeload": "function (_self,o) {\n    if (! _this.form.findField('cobmisc_cohead_id').getValue()) {\n        return false;\n    }\n    o.params = o.params || {};\n    \n    o.params.coitem_cohead_id = _this.form.findField('cobmisc_cohead_id').getValue();\n    o.params.limit = 999;\n    o.params.cobmisc_id = _this.form.findField('cobmisc_id').getValue();\n    \n}",
 422                                         "load": "function (_self, records, options)\n{\n   (function() { _this.form.recalc(); }).defer(100);\n   _this.cmgrid.ds.load({});\n}",
 423                                         "update": "function (_self, record, operation)\n{\n  _this.form.recalc();\n}"
 424                                     },
 425                                     "*prop": "dataSource",
 426                                     "remoteSort": true,
 427                                     "xtype": "Store",
 428                                     "|sortInfo": "{ field : 'coitem_linenumber', direction: 'ASC' }",
 429                                     "|xns": "Roo.data",
 430                                     "items": [
 431                                         {
 432                                             "*prop": "proxy",
 433                                             "xtype": "HttpProxy",
 434                                             "method": "GET",
 435                                             "|url": "baseURL + '/Roo/coitem.php'",
 436                                             "|xns": "Roo.data"
 437                                         },
 438                                         {
 439                                             "|xns": "Roo.data",
 440                                             "xtype": "JsonReader",
 441                                             "totalProperty": "total",
 442                                             "root": "data",
 443                                             ".builderCfg": "{\"cols\":[{\"table\":\"coitem\",\"column\":\"coitem_linenumber\",\"columnshort\":\"coitem_linenumber\",\"ctype\":\"int4\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Item#\"},{\"table\":\"coitem\",\"column\":\"coitem_itemsite_id\",\"columnshort\":\"coitem_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"itemsite_id\",\"deps\":[{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_item_id\",\"columnshort\":\"itemsite_item_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warehous_id\",\"columnshort\":\"itemsite_warehous_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_qtyonhand\",\"columnshort\":\"itemsite_qtyonhand\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_reorderlevel\",\"columnshort\":\"itemsite_reorderlevel\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordertoqty\",\"columnshort\":\"itemsite_ordertoqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cyclecountfreq\",\"columnshort\":\"itemsite_cyclecountfreq\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastcount\",\"columnshort\":\"itemsite_datelastcount\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastused\",\"columnshort\":\"itemsite_datelastused\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_loccntrl\",\"columnshort\":\"itemsite_loccntrl\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_safetystock\",\"columnshort\":\"itemsite_safetystock\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_minordqty\",\"columnshort\":\"itemsite_minordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_multordqty\",\"columnshort\":\"itemsite_multordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_leadtime\",\"columnshort\":\"itemsite_leadtime\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_abcclass\",\"columnshort\":\"itemsite_abcclass\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_issuemethod\",\"columnshort\":\"itemsite_issuemethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_controlmethod\",\"columnshort\":\"itemsite_controlmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_active\",\"columnshort\":\"itemsite_active\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_plancode_id\",\"columnshort\":\"itemsite_plancode_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costcat_id\",\"columnshort\":\"itemsite_costcat_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_eventfence\",\"columnshort\":\"itemsite_eventfence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_sold\",\"columnshort\":\"itemsite_sold\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_stocked\",\"columnshort\":\"itemsite_stocked\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_freeze\",\"columnshort\":\"itemsite_freeze\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_id\",\"columnshort\":\"itemsite_location_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparams\",\"columnshort\":\"itemsite_useparams\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparamsmanual\",\"columnshort\":\"itemsite_useparamsmanual\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_soldranking\",\"columnshort\":\"itemsite_soldranking\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createpr\",\"columnshort\":\"itemsite_createpr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location\",\"columnshort\":\"itemsite_location\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_comments\",\"columnshort\":\"itemsite_location_comments\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_notes\",\"columnshort\":\"itemsite_notes\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_perishable\",\"columnshort\":\"itemsite_perishable\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_nnqoh\",\"columnshort\":\"itemsite_nnqoh\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoabcclass\",\"columnshort\":\"itemsite_autoabcclass\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup\",\"columnshort\":\"itemsite_ordergroup\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_disallowblankwip\",\"columnshort\":\"itemsite_disallowblankwip\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_maxordqty\",\"columnshort\":\"itemsite_maxordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_mps_timefence\",\"columnshort\":\"itemsite_mps_timefence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createwo\",\"columnshort\":\"itemsite_createwo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warrpurc\",\"columnshort\":\"itemsite_warrpurc\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoreg\",\"columnshort\":\"itemsite_autoreg\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costmethod\",\"columnshort\":\"itemsite_costmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_value\",\"columnshort\":\"itemsite_value\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup_first\",\"columnshort\":\"itemsite_ordergroup_first\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_supply_itemsite_id\",\"columnshort\":\"itemsite_supply_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_planning_type\",\"columnshort\":\"itemsite_planning_type\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_wosupply\",\"columnshort\":\"itemsite_wosupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_posupply\",\"columnshort\":\"itemsite_posupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_lsseq_id\",\"columnshort\":\"itemsite_lsseq_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cosdefault\",\"columnshort\":\"itemsite_cosdefault\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopr\",\"columnshort\":\"itemsite_createsopr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopo\",\"columnshort\":\"itemsite_createsopo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_dropship\",\"columnshort\":\"itemsite_dropship\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyord\",\"columnshort\":\"coitem_qtyord\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Qty\"},{\"table\":\"coitem\",\"column\":\"coitem_unitcost\",\"columnshort\":\"coitem_unitcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Unit Cost\"},{\"table\":\"coitem\",\"column\":\"coitem_price\",\"columnshort\":\"coitem_price\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Price\"},{\"table\":\"coitem\",\"column\":\"coitem_custprice\",\"columnshort\":\"coitem_custprice\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Cust Price\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreturned\",\"columnshort\":\"coitem_qtyreturned\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#Returned\"},{\"table\":\"coitem\",\"column\":\"coitem_prcost\",\"columnshort\":\"coitem_prcost\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"prcost?\"},{\"table\":\"coitem\",\"column\":\"coitem_price_uom_id\",\"columnshort\":\"coitem_price_uom_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"uom_id\",\"deps\":[{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_name\",\"columnshort\":\"uom_name\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_descrip\",\"columnshort\":\"uom_descrip\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"uom\",\"column\":\"coitem_price_uom_id_uom_item_weight\",\"columnshort\":\"uom_item_weight\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"Unit of\"},{\"table\":\"coitem\",\"column\":\"coitem_qtyreserved\",\"columnshort\":\"coitem_qtyreserved\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"#reserved\"}],\"cols_ex\":[\"coitem_price_uom_id_uom_descrip\"],\"table\":\"coitem\",\"xtype\":\"GridPanel\",\"|xns\":\"Roo\"}",
 444                                             "*prop": "reader",
 445                                             "id": "id",
 446                                             "|fields": "[\n    {\n        'name': 'coitem_linenumber',\n        'type': 'int'\n    },\n    {\n        'name': 'coitem_itemsite_id',\n        'type': 'int'\n    },\n    {\n        'name': 'coitem_qtyord'\n    },\n    {\n        'name': 'coitem_unitcost'\n    },\n    {\n        'name': 'coitem_price'\n    },\n    {\n        'name': 'coitem_custprice'\n    },\n    {\n        'name': 'coitem_qtyreturned'\n    },\n    {\n        'name': 'coitem_prcost'\n    },\n    {\n        'name': 'coitem_price_uom_id',\n        'type': 'int'\n    },\n    {\n        'name': 'coitem_qtyreserved'\n    }\n]"
 447                                         }
 448                                     ]
 449                                 },
 450                                 {
 451                                     "*prop": "toolbar",
 452                                     "xtype": "Toolbar",
 453                                     "|xns": "Roo",
 454                                     "items": [
 455                                         {
 456                                             "listeners": {
 457                                                 "click": "function (_self, e)\n{\n    _this.grid.ds.each(function(r) {\n        r.set('cobill_qty', Math.max(0, r.data.coitem_qtyord - r.data.cobill_billed));\n    });\n}"
 458                                             },
 459                                             "text": "Invoice all",
 460                                             "xtype": "Button",
 461                                             "|xns": "Roo.Toolbar"
 462                                         },
 463                                         {
 464                                             "text": "Restore from : ",
 465                                             "xtype": "TextItem",
 466                                             "|xns": "Roo.Toolbar"
 467                                         },
 468                                         {
 469                                             "listeners": {
 470                                                 "|select": "function (combo, record, index)\n{\n  //_this.grid.footer.onClick('first');\n  \n   (function() { \n    combo.setValue('');\n   }).defer(100);\n   var data = record.json.data;\n   \n   _this.grid.ds.each(function (r) {\n        if (typeof(data[r.data.coitem_itemsite_id+'']) == 'undefined') {\n            return;\n        }\n        r.set('cobill_qty', parseInt(data[r.data.coitem_itemsite_id+'']));\n   \n   });\n   \n   \n   \n  \n}"
 471                                             },
 472                                             "allowBlank": true,
 473                                             "displayField": "name",
 474                                             "editable": false,
 475                                             "emptyText": "Restore from",
 476                                             "forceSelection": true,
 477                                             "listWidth": 300,
 478                                             "loadingText": "Searching...",
 479                                             "name": "name",
 480                                             "pageSize": 20,
 481                                             "qtip": "Select Action",
 482                                             "queryParam": "query[action]",
 483                                             "selectOnFocus": true,
 484                                             "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{name}</b> </div>",
 485                                             "triggerAction": "all",
 486                                             "typeAhead": true,
 487                                             "valueField": "name",
 488                                             "width": 300,
 489                                             "xtype": "ComboBox",
 490                                             "|xns": "Roo.form",
 491                                             "items": [
 492                                                 {
 493                                                     "listeners": {
 494                                                         "|beforeload": "function (_self, o)\n{\n    o.params = o.params || {};\n    // staff can see all logs, other companies can only see their own.\n     \n    o.params._stash = _this.form.findField('cobmisc_cohead_id').getValue();\n\n}"
 495                                                     },
 496                                                     "*prop": "store",
 497                                                     "remoteSort": true,
 498                                                     "xtype": "Store",
 499                                                     "|sortInfo": "{ field : 'action' , direction : 'ASC' }",
 500                                                     "|xns": "Roo.data",
 501                                                     "items": [
 502                                                         {
 503                                                             "*prop": "proxy",
 504                                                             "method": "GET",
 505                                                             "xtype": "HttpProxy",
 506                                                             "|url": "baseURL + '/Roo/Cobmisc.php'",
 507                                                             "|xns": "Roo.data"
 508                                                         },
 509                                                         {
 510                                                             "*prop": "reader",
 511                                                             "id": "name",
 512                                                             "root": "data",
 513                                                             "totalProperty": "total",
 514                                                             "xtype": "JsonReader",
 515                                                             "|fields": "[\n    {\n        'name': 'name',\n        'type': 'string'\n    }\n \n]",
 516                                                             "|xns": "Roo.data"
 517                                                         }
 518                                                     ]
 519                                                 }
 520                                             ]
 521                                         },
 522                                         {
 523                                             "xtype": "Fill",
 524                                             "|xns": "Roo.Toolbar"
 525                                         },
 526                                         {
 527                                             "listeners": {
 528                                                 "|click": "function()\n{\n     _this.grid.ds.each(function(r) {\n        r.set('cobill_qty', 0);\n    });\n}\n"
 529                                             },
 530                                             "text": "Reset",
 531                                             "xtype": "Button",
 532                                             "|xns": "Roo.Toolbar"
 533                                         }
 534                                     ]
 535                                 },
 536                                 {
 537                                     "xtype": "ColumnModel",
 538                                     ".builderCfg": "{\"table\":\"coitem\",\"column\":\"coitem_linenumber\",\"columnshort\":\"coitem_linenumber\",\"ctype\":\"int4\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Item#\"}",
 539                                     "header": "Item#",
 540                                     "width": 75,
 541                                     "dataIndex": "coitem_linenumber",
 542                                     "|renderer": "function(v) { return String.format('{0}', v); }",
 543                                     "|xns": "Roo.grid",
 544                                     "*prop": "colModel[]"
 545                                 },
 546                                 {
 547                                     "xtype": "ColumnModel",
 548                                     ".builderCfg": "{\"table\":\"coitem\",\"column\":\"coitem_itemsite_id\",\"columnshort\":\"coitem_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"itemsite_id\",\"deps\":[{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_item_id\",\"columnshort\":\"itemsite_item_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warehous_id\",\"columnshort\":\"itemsite_warehous_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_qtyonhand\",\"columnshort\":\"itemsite_qtyonhand\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_reorderlevel\",\"columnshort\":\"itemsite_reorderlevel\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordertoqty\",\"columnshort\":\"itemsite_ordertoqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cyclecountfreq\",\"columnshort\":\"itemsite_cyclecountfreq\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastcount\",\"columnshort\":\"itemsite_datelastcount\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastused\",\"columnshort\":\"itemsite_datelastused\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_loccntrl\",\"columnshort\":\"itemsite_loccntrl\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_safetystock\",\"columnshort\":\"itemsite_safetystock\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_minordqty\",\"columnshort\":\"itemsite_minordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_multordqty\",\"columnshort\":\"itemsite_multordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_leadtime\",\"columnshort\":\"itemsite_leadtime\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_abcclass\",\"columnshort\":\"itemsite_abcclass\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_issuemethod\",\"columnshort\":\"itemsite_issuemethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_controlmethod\",\"columnshort\":\"itemsite_controlmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_active\",\"columnshort\":\"itemsite_active\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_plancode_id\",\"columnshort\":\"itemsite_plancode_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costcat_id\",\"columnshort\":\"itemsite_costcat_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_eventfence\",\"columnshort\":\"itemsite_eventfence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_sold\",\"columnshort\":\"itemsite_sold\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_stocked\",\"columnshort\":\"itemsite_stocked\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_freeze\",\"columnshort\":\"itemsite_freeze\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_id\",\"columnshort\":\"itemsite_location_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparams\",\"columnshort\":\"itemsite_useparams\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparamsmanual\",\"columnshort\":\"itemsite_useparamsmanual\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_soldranking\",\"columnshort\":\"itemsite_soldranking\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createpr\",\"columnshort\":\"itemsite_createpr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location\",\"columnshort\":\"itemsite_location\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_comments\",\"columnshort\":\"itemsite_location_comments\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_notes\",\"columnshort\":\"itemsite_notes\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_perishable\",\"columnshort\":\"itemsite_perishable\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_nnqoh\",\"columnshort\":\"itemsite_nnqoh\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoabcclass\",\"columnshort\":\"itemsite_autoabcclass\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup\",\"columnshort\":\"itemsite_ordergroup\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_disallowblankwip\",\"columnshort\":\"itemsite_disallowblankwip\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_maxordqty\",\"columnshort\":\"itemsite_maxordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_mps_timefence\",\"columnshort\":\"itemsite_mps_timefence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createwo\",\"columnshort\":\"itemsite_createwo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warrpurc\",\"columnshort\":\"itemsite_warrpurc\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoreg\",\"columnshort\":\"itemsite_autoreg\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costmethod\",\"columnshort\":\"itemsite_costmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_value\",\"columnshort\":\"itemsite_value\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup_first\",\"columnshort\":\"itemsite_ordergroup_first\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_supply_itemsite_id\",\"columnshort\":\"itemsite_supply_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_planning_type\",\"columnshort\":\"itemsite_planning_type\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_wosupply\",\"columnshort\":\"itemsite_wosupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_posupply\",\"columnshort\":\"itemsite_posupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_lsseq_id\",\"columnshort\":\"itemsite_lsseq_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cosdefault\",\"columnshort\":\"itemsite_cosdefault\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopr\",\"columnshort\":\"itemsite_createsopr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopo\",\"columnshort\":\"itemsite_createsopo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_dropship\",\"columnshort\":\"itemsite_dropship\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\"}",
 549                                     "header": "Item Code",
 550                                     "width": 75,
 551                                     "dataIndex": "item_number",
 552                                     "|renderer": "function(v) { return String.format('{0}', v); }",
 553                                     "|xns": "Roo.grid",
 554                                     "*prop": "colModel[]"
 555                                 },
 556                                 {
 557                                     "*prop": "colModel[]",
 558                                     ".builderCfg": "{\"table\":\"coitem\",\"column\":\"coitem_itemsite_id\",\"columnshort\":\"coitem_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\",\"maps_to\":\"itemsite_id\",\"deps\":[{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_item_id\",\"columnshort\":\"itemsite_item_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warehous_id\",\"columnshort\":\"itemsite_warehous_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_qtyonhand\",\"columnshort\":\"itemsite_qtyonhand\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_reorderlevel\",\"columnshort\":\"itemsite_reorderlevel\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordertoqty\",\"columnshort\":\"itemsite_ordertoqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cyclecountfreq\",\"columnshort\":\"itemsite_cyclecountfreq\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastcount\",\"columnshort\":\"itemsite_datelastcount\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_datelastused\",\"columnshort\":\"itemsite_datelastused\",\"ctype\":\"date\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_loccntrl\",\"columnshort\":\"itemsite_loccntrl\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_safetystock\",\"columnshort\":\"itemsite_safetystock\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_minordqty\",\"columnshort\":\"itemsite_minordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_multordqty\",\"columnshort\":\"itemsite_multordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_leadtime\",\"columnshort\":\"itemsite_leadtime\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_abcclass\",\"columnshort\":\"itemsite_abcclass\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_issuemethod\",\"columnshort\":\"itemsite_issuemethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_controlmethod\",\"columnshort\":\"itemsite_controlmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_active\",\"columnshort\":\"itemsite_active\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_plancode_id\",\"columnshort\":\"itemsite_plancode_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costcat_id\",\"columnshort\":\"itemsite_costcat_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_eventfence\",\"columnshort\":\"itemsite_eventfence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_sold\",\"columnshort\":\"itemsite_sold\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_stocked\",\"columnshort\":\"itemsite_stocked\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_freeze\",\"columnshort\":\"itemsite_freeze\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_id\",\"columnshort\":\"itemsite_location_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparams\",\"columnshort\":\"itemsite_useparams\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_useparamsmanual\",\"columnshort\":\"itemsite_useparamsmanual\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_soldranking\",\"columnshort\":\"itemsite_soldranking\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createpr\",\"columnshort\":\"itemsite_createpr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location\",\"columnshort\":\"itemsite_location\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_location_comments\",\"columnshort\":\"itemsite_location_comments\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_notes\",\"columnshort\":\"itemsite_notes\",\"ctype\":\"text\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_perishable\",\"columnshort\":\"itemsite_perishable\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_nnqoh\",\"columnshort\":\"itemsite_nnqoh\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoabcclass\",\"columnshort\":\"itemsite_autoabcclass\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup\",\"columnshort\":\"itemsite_ordergroup\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_disallowblankwip\",\"columnshort\":\"itemsite_disallowblankwip\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_maxordqty\",\"columnshort\":\"itemsite_maxordqty\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_mps_timefence\",\"columnshort\":\"itemsite_mps_timefence\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createwo\",\"columnshort\":\"itemsite_createwo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_warrpurc\",\"columnshort\":\"itemsite_warrpurc\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_autoreg\",\"columnshort\":\"itemsite_autoreg\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_costmethod\",\"columnshort\":\"itemsite_costmethod\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_value\",\"columnshort\":\"itemsite_value\",\"ctype\":\"numeric\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_ordergroup_first\",\"columnshort\":\"itemsite_ordergroup_first\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_supply_itemsite_id\",\"columnshort\":\"itemsite_supply_itemsite_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_planning_type\",\"columnshort\":\"itemsite_planning_type\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_wosupply\",\"columnshort\":\"itemsite_wosupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_posupply\",\"columnshort\":\"itemsite_posupply\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_lsseq_id\",\"columnshort\":\"itemsite_lsseq_id\",\"ctype\":\"int4\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_cosdefault\",\"columnshort\":\"itemsite_cosdefault\",\"ctype\":\"bpchar\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopr\",\"columnshort\":\"itemsite_createsopr\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_createsopo\",\"columnshort\":\"itemsite_createsopo\",\"ctype\":\"bool\",\"desc\":\"\"},{\"table\":\"itemsite\",\"column\":\"coitem_itemsite_id_itemsite_dropship\",\"columnshort\":\"itemsite_dropship\",\"ctype\":\"bool\",\"desc\":\"\"}],\"use\":1,\"use_ex\":\"\",\"title\":\"\"}",
 559                                     "dataIndex": "item_descrip1",
 560                                     "header": "Item Description",
 561                                     "width": "150.00",
 562                                     "xtype": "ColumnModel",
 563                                     "|renderer": "function(v, x, r) {\n\n    var vv = v;\n    if (r.data.coitem_memo && r.data.coitem_memo.length) {\n        vv = r.data.coitem_memo;\n    }\n    return String.format('{0}', vv); \n \n }",
 564                                     "|xns": "Roo.grid"
 565                                 },
 566                                 {
 567                                     "*prop": "colModel[]",
 568                                     "align": "right",
 569                                     "dataIndex": "coitem_custprice",
 570                                     "header": "List Price",
 571                                     "width": 80,
 572                                     "xtype": "ColumnModel",
 573                                     "|renderer": "function(v) { return String.format('{0}', (v *1.0).toFixed(2)); }",
 574                                     "|xns": "Roo.grid"
 575                                 },
 576                                 {
 577                                     "*prop": "colModel[]",
 578                                     "align": "right",
 579                                     "dataIndex": "coitem_price",
 580                                     "header": "Sell @",
 581                                     "width": 80,
 582                                     "xtype": "ColumnModel",
 583                                     "|renderer": "function(v) { return String.format('{0}', (v *1.0).toFixed(2)); }",
 584                                     "|xns": "Roo.grid"
 585                                 },
 586                                 {
 587                                     "*prop": "colModel[]",
 588                                     "align": "right",
 589                                     "dataIndex": "calc_tax",
 590                                     "header": "Tax",
 591                                     "width": 80,
 592                                     "xtype": "ColumnModel",
 593                                     "|renderer": "function(v) { return String.format('{0}', (v *1.0).toFixed(2)); }",
 594                                     "|xns": "Roo.grid"
 595                                 },
 596                                 {
 597                                     "*prop": "colModel[]",
 598                                     ".builderCfg": "{\"table\":\"coitem\",\"column\":\"coitem_qtyord\",\"columnshort\":\"coitem_qtyord\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Qty\"}",
 599                                     "align": "right",
 600                                     "dataIndex": "coitem_qtyord",
 601                                     "header": "Ordered Qty",
 602                                     "width": 70,
 603                                     "xtype": "ColumnModel",
 604                                     "|renderer": "function(v) { return String.format('{0}', v); }",
 605                                     "|xns": "Roo.grid"
 606                                 },
 607                                 {
 608                                     "*prop": "colModel[]",
 609                                     "align": "right",
 610                                     "dataIndex": "cobill_billed",
 611                                     "header": "Not Billed Qty",
 612                                     "width": 70,
 613                                     "xtype": "ColumnModel",
 614                                     "|renderer": "function(v,x,r) {\n\n     Roo.log(v);\n     return String.format('{0}', r.data.coitem_qtyord - v); \n }",
 615                                     "|xns": "Roo.grid"
 616                                 },
 617                                 {
 618                                     "*prop": "colModel[]",
 619                                     ".builderCfg": "{\"table\":\"coitem\",\"column\":\"coitem_qtyord\",\"columnshort\":\"coitem_qtyord\",\"ctype\":\"numeric\",\"desc\":\"\",\"use\":1,\"use_ex\":\"\",\"title\":\"Qty\"}",
 620                                     "align": "right",
 621                                     "dataIndex": "cobill_qty",
 622                                     "header": "Bill Qty",
 623                                     "width": 100,
 624                                     "xtype": "ColumnModel",
 625                                     "|renderer": "function(v,x,r) { \n    \n    var vv = parseInt(v);\n    vv = isNaN(vv) ? 0 : vv;\n    r.data.cobill_qty = vv; // get rid of decimal.\n    if (r.data.cobill_billed + vv > r.data.coitem_qtyord) {\n            return String.format('<b style=\"background-color:red;color:yellow\">{0}</b>', vv); \n    }\n    // not fully fullfilled\n    if (r.data.cobill_billed + vv != r.data.coitem_qtyord) {\n            return String.format('<b style=\"background-color:blue;color:yellow\">{0}</b>', vv); \n    }   \n    return String.format('{0}', vv); \n    \n}",
 626                                     "|xns": "Roo.grid",
 627                                     "items": [
 628                                         {
 629                                             "*prop": "editor",
 630                                             "xtype": "GridEditor",
 631                                             "|xns": "Roo.grid",
 632                                             "items": [
 633                                                 {
 634                                                     "*prop": "field",
 635                                                     "allowDecimals": true,
 636                                                     "decimalPrecision": 0,
 637                                                     "minValue": 0,
 638                                                     "style": "text-align:right",
 639                                                     "xtype": "NumberField",
 640                                                     "|xns": "Roo.form"
 641                                                 }
 642                                             ]
 643                                         }
 644                                     ]
 645                                 }
 646                             ]
 647                         }
 648                     ]
 649                 },
 650                 {
 651                     "listeners": {
 652                         "click": "function (_self, e)\n{\n    _this.dialog.hide();\n}"
 653                     },
 654                     "*prop": "buttons[]",
 655                     "text": "Cancel",
 656                     "xtype": "Button",
 657                     "|xns": "Roo"
 658                 },
 659                 {
 660                     "listeners": {
 661                         "click": "function (_self, e)\n{\n    var hasListDiscount = false;\n    var orderQty = 0;\n    var billQty = 0;\n    \n    var ar = [];\n    _this.grid.ds.each(function(r) {\n        if(r.data.item_number == 'Z-LIST-DISCOUNT'){\n            hasListDiscount = true;\n        }\n        orderQty += r.data.coitem_qtyord;\n        billQty += r.data.cobill_qty;\n        \n        ar.push({\n            cobill_coitem_id : r.data.coitem_id,\n            cobill_qty : r.data.cobill_qty \n        });\n    });\n    var doSubmit = function(){\n        _this.form.findField('billitems').setValue(JSON.stringify(ar));\n        _this.form.doAction(\"submit\");   \n    \n    }\n    if(hasListDiscount && orderQty != billQty){\n        Roo.MessageBox.confirm(\"Confirm\", \"This Invoice contains a pre-tax discount - you can still invoice the customer however the calculations for discount will be inaccurate.\",\n            function (res) {\n                if(res!='yes') {\n                    return;\n                }\n                doSubmit();\n         });\n         return;\n     }\n     \n    doSubmit();\n\n}",
 662                         "render": "function (_self)\n{\n _this.saveBtn = _self;\n}"
 663                     },
 664                     "*prop": "buttons[]",
 665                     "text": "Save",
 666                     "xtype": "Button",
 667                     "|xns": "Roo"
 668                 }
 669             ]
 670         }
 671     ],
 672     "permname": "",
 673     "modOrder": "001"
 674 }