TaxTemplate DRILLDOWN - NetSuite Backup

Baserecordtypebaserecordtype

customrecord_tax_template

Customformcustomform

Standard Tax Report Template Form

Ishandlebarscustrecord_ishandlebars

No

Isinactiveisinactive

No

Lastmodifiedlastmodified

5/19/2023 4:32 pm

Linenumberlinenumber

327

Namename

DRILLDOWN

Nameorignameorig

DRILLDOWN

Ownerowner

Mihir Bhatnagar

Owneridownerid

7

Rectyperectype

Tax Report Template

Rectype 73 481 maxnkeyrectype_73_481_maxnkey

533

Rectype 92 587 maxnkeyrectype_92_587_maxnkey

30

Scriptidscriptid

value_327_3776644_349

Submitnext tsubmitnext_t

customrecordentry

Submitnext ysubmitnext_y

75

Tax template notecustrecord_tax_template_note

Generic Drill Down Template for Non-EU Countries

Tax template shortcustrecord_tax_template_short

<html> <head> <title>Detailed Report</title> <style> .rowtotal {background: #c0c0c0} .dh {font: 15px Verdana,Arial,Helvetica,sans-serif; text-align:center; align:center;} .dh7 {font: Verdana,Arial,Helvetica,sans-serif; text-align:center; align:center;} </style> <script type="text/javascript"> {library} </script> <script type="text/javascript"> function isNullOrUndefined(value) { if (value === null || value === undefined){ return true; } } var totalstore; Ext.onReady(function() { if (typeof Ext.version === 'string' && parseFloat(Ext.version) >= 3) { drilldownExt3() } else { drilldown() } function drilldownExt3() { totalstore = new Ext.data.ArrayStore({ autoLoad: true, url: '{drilldownurl}&actiontype=drilldowntotal', root: 'data', fields: [{name: 'taxcode', mapping: 0, type: 'string'}, {name: 'trandate', mapping: 1, type: 'string'}, {name: 'entity', mapping: 2, type: 'string'}, {name: 'tranno', mapping: 3, type: 'string'}, {name: 'trantype', mapping: 4, type: 'string'}, {name: 'netamount', mapping: 5, type: 'float'}, {name: 'taxamount', mapping: 6, type: 'float'}, {name: 'grossamount', mapping: 8, type: 'float'} ] }); var settings = { symbol : "{currencysymbol}", precision :{precision}, thousand : "{thousand}", decimal : "{decimal}", format: {pos: "{poscurrencyformat}", neg:"{negcurrencyformat}", zero:"{zerocurrencyformat}"} }; var detailstore = new Ext.data.ArrayStore({ autoLoad: true, url: '{drilldownurl}&actiontype=page', idIndex: 16, totalProperty: 'total', messageProperty: "message", successProperty: "success", root: 'data', fields: [{name: 'taxcode', mapping: 0, type: 'string'}, {name: 'trandate', mapping: 1, type: 'string'}, {name: 'entity', mapping: 2, type: 'string'}, {name: 'tranno', mapping: 3, type: 'string'}, {name: 'trantype', mapping: 4, type: 'string'}, {name: 'netamount', mapping: 5, type: 'float'}, {name: 'taxamount', mapping: 6, type: 'float'}, {name: 'timestamp', mapping: 10, type: 'string'}, {name: 'trantypeinternalid', mapping: 11, type: 'string'}, {name: 'grossamount', mapping: 17, type: 'float'}, {name: 'tranid', mapping: 15, type: 'string'} ], listeners: { exception: function(proxy, type, action, options, res, arg) { Ext.getCmp("btnexcel").disable(); Ext.getCmp("pgbar").disable(); var respobj = Ext.util.JSON.decode(res.responseText); alert(respobj.message); }, datachanged: function(obj) { Ext.getCmp("pgbar").refresh.hide(); }, beforeload: function(obj, option) { Ext.getCmp("pgbar").refresh.show(); } } }); var grid = new Ext.grid.GridPanel({ store: detailstore, id: 'detailpanel', region: 'center', enableColumnHide: false, enableColumnMove: false, enableHdMenu: false, cm: new Ext.grid.ColumnModel({ defaults: { sortable: true }, columns: [ {id: 'taxcode', header: "{taxcodeheader}", width: 100, dataIndex: 'taxcode'}, {id: 'trandate', header: "{dateheader}", width: 100, dataIndex: 'trandate'}, {id: 'entity', header: "{entityheader}", width: 200, dataIndex: 'entity', renderer : function(value, p, record) { if (!value || value === "- None -" || value === '- No Entity -') { return value; } else { return [ "<a href='", "{drilldownurl}&actiontype=entityrec", "&tranno=" + record.get("tranno"), "&tranid=" + customEncodeURIComponent(record.get('tranid')), "&entity=" + customEncodeURIComponent(value), "&trantypeinternalid=" + record.get('trantypeinternalid'), "&timestamp=" + record.get('timestamp'), "&grossamount=" + Number(record.get('grossamount')), "'>", value ? value:"*", "</a>"].join(""); } } }, {id: 'tranno', header: "{trannoheader}", width: 100, dataIndex: 'tranno', renderer : function(value, p, record) { return [ "<a href='", "{drilldownurl}&actiontype=tranrec", "&tranno=" + value, "&tranid=" + customEncodeURIComponent(record.get('tranid')), "&trantypeinternalid=" + record.get('trantypeinternalid'), "&grossamount=" + Number(record.get('grossamount')), "&timestamp=" + record.get('timestamp'), "'>", value?value:"*", "</a>"].join(""); } }, {id: 'trantype', header: "{tranttypeheader}", width: 100, dataIndex: 'trantype'}, {id: 'netamount', header: "{netamountheader}", width: 150, dataIndex: 'netamount', align: "right", renderer : function(value) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } }, {id: 'taxamount', header: "{taxamountheader}", width: 150, dataIndex: 'taxamount', align: "right", renderer : function(value) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } }, {id: 'grossamount', header: "{grossamountheader}", width: 150, dataIndex: 'grossamount', align: "right", renderer : function(value, p, record) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } } ]} ), stripeRows: true, height: 0, border: true, layout: 'fit', margins: {bottom: 10}, viewConfig: {forceFit: true}, fbar: new Ext.Toolbar({ items: [ {xtype: 'tbfill'}, { xtype: 'button', id: "btnexcel", text: "{exportexcel}", align: "right", listeners: {afterrender: function() { Ext.select('.x-btn-text').setStyle({'font-size': '14px','color': '#333333','font-weight': 600,'padding':'0px 12px','height':'23px'});}}, handler: generateExcel } ] }), bbar: { xtype: "panel", border: false, items: [ new Ext.Toolbar({ layout: "fit", border: false, bodyStyle: "background: #FF0000;", items: [{ xtype: "grid", store: totalstore, border: false, height: 50, hideHeaders: true, disableSelection: true, layout: "fit", columns: [ {id: 'taxcode', header: "{taxcodeheader}", width: 100, dataIndex: 'taxcode'}, {id: 'trandate', header: "{dateheader}", width: 100, dataIndex: 'trandate'}, {id: 'entity', header: "{entityheader}", width: 200, dataIndex: 'entity'}, {id: 'tranno', header: "{trannoheader}", width: 100, dataIndex: 'tranno'}, {id: 'trantype', header: "{tranttypeheader}", width: 150, dataIndex: 'trantype', renderer : function(value) { return "<b>" + value + "</b>"; } }, {id: 'netamount', header: "{netamountheader}", width: 150, dataIndex: 'netamount', align: "right", renderer : function(value) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } }, {id: 'taxamount', header: "{taxamountheader}", width: 150, dataIndex: 'taxamount', align: "right", renderer : function(value) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } }, {id: 'grossamount', header: "{grossamountheader}", width: 150, dataIndex: 'grossamount',align: "right", renderer : function(value, p, record) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } } ], viewConfig: {forceFit: true} }] }), new Ext.PagingToolbar({ id: "pgbar", pageSize: {pagesize}, store: detailstore, displayInfo: true, displayMsg: '{displaymsg}', emptyMsg: "{emptymsg}", afterPageText: "{pageoflabel} {0}", beforePageText: "{pagelabel}", listeners: { change: function (obj, data) { if (data.total > 0) { var pagestore = obj.store; var pagetotal = {netamount: 0, taxamount: 0, grossamount: 0} for(var irow = 0; irow < pagestore.getCount(); irow++) { pagetotal.netamount += Number(pagestore.getAt(irow).get("netamount")); pagetotal.taxamount += Number(pagestore.getAt(irow).get("taxamount")); pagetotal.grossamount += Number(pagestore.getAt(irow).get("grossamount")); } var pagerec = totalstore.getAt(0); if (pagerec) { pagerec.set("netamount", Number(pagetotal.netamount)); pagerec.set("taxamount", Number(pagetotal.taxamount)); pagerec.set("grossamount", Number(pagetotal.grossamount)); pagerec.commit(); } } } } }) ] } }); var myBorderPanel = new Ext.Panel({ id: 'mainpanel', renderTo: 'maindiv', width: 0, height: 0, layout: 'border', bodyCfg : { style: {'background-color':'white'}}, border: false, items: [ { region: 'north', height: 60, html: "<div id='northdiv'><h1 class='dh'><b>{company}</b></h1><h2 class='dh'>{box}</h2><h3 class='dh'>{reportingperiod}</h3></div>", collapsible: false, layout: 'fit', border: false, margins: {bottom: 10} }, grid ] }); var objsize = Ext.getBody().getViewSize(); if (Ext.isIE) { myBorderPanel.setWidth(objsize.width-20); } else { myBorderPanel.setWidth(objsize.width-40); } myBorderPanel.setHeight(objsize.height - 170); } function drilldown() { totalstore = new Ext.data.ArrayStore({ autoLoad: true, proxy: { type: 'ajax', url: '{drilldownurl}&actiontype=drilldowntotal', reader: { type: 'json', rootProperty: 'data', }, timeout: 150000 }, fields: [{name: 'taxcode'}, {name: 'trandate'}, {name: 'entity'}, {name: 'tranno'}, {name: 'trantype'}, {name: 'netamount'}, {name: 'taxamount', type: 'float'}, {name: 'notionalamount', type: 'float'}, {name: 'grossamount', type: 'float'}, ], }); var settings = { symbol : "{currencysymbol}", precision :{precision}, thousand : "{thousand}", decimal : "{decimal}", format: {pos: "{poscurrencyformat}", neg:"{negcurrencyformat}", zero:"{zerocurrencyformat}"} }; var detailstore = new Ext.data.ArrayStore({ autoLoad: true, pageSize: {pagesize}, proxy: { type: 'ajax', url: '{drilldownurl}&actiontype=page', reader: { type: 'json', rootProperty: 'data', totalProperty: 'total' }, timeout: 150000 }, fields: [{name: 'taxcode'}, {name: 'trandate'}, {name: 'entity'}, {name: 'tranno'}, {name: 'trantype'}, {name: 'netamount', type: 'float'}, {name: 'taxamount', type: 'float'}, {name: 'notionalamount', type: 'float'}, {name: 'trantypeid'}, {name: 'taxcodeid'}, {name: 'timestamp'}, {name: 'trantypeinternalid'}, {name: 'transactiontype'}, {name: 'timestampid'}, {name: 'amount1'}, {name: 'amount2'}, {name: 'amount3'}, {name: 'grossamount', type: 'float'}, //Below fields are only placeholders for ExtJS7 update// {name: 'amount4'}, {name: 'amount5'}, {name: 'amount6'}, {name: 'amount7'}, {name: 'amount8'}, {name: 'amount9'}, {name: 'amount10'}, {name: 'amount11'}, {name: 'amount12'}, {name: 'amount13'}, {name: 'amount14'} ], listeners: { exception: function(proxy, type, action, options, res, arg) { alert(respobj.message); } } }); var grid = new Ext.grid.GridPanel({ store: detailstore, id: 'detailpanel', region: 'center', enableColumnHide: false, enableColumnMove: false, enableHdMenu: false, columns: [ {text: "{taxcodeheader}", width: 100, dataIndex: 'taxcode', flex: 1}, {text: "{dateheader}", width: 100, dataIndex: 'trandate', flex: 1}, {text: "{entityheader}", width: 200, dataIndex: 'entity', flex: 2, renderer : function(value, p, record) { if (!value || value === "- None -" || value === '- No Entity -') { return value; } else { return [ "<a href='", "{drilldownurl}&actiontype=entityrec", "&tranno=" + record.get("tranno"), "&tranid=" + customEncodeURIComponent(record.get('tranid')), "&entity=" + customEncodeURIComponent(value), "&trantypeinternalid=" + record.get('trantypeinternalid'), "&timestamp=" + record.get('timestamp'), "&grossamount=" + Number(record.get('grossamount')), "'>", value ? value:"*", "</a>"].join(""); } } }, {text: "{trannoheader}", width: 100, dataIndex: 'tranno', flex: 1, renderer : function(value, p, record) { return [ "<a href='", "{drilldownurl}&actiontype=tranrec", "&tranno=" + value, "&tranid=" + customEncodeURIComponent(record.get('tranid')), "&trantypeinternalid=" + record.get('trantypeinternalid'), "&grossamount=" + Number(record.get('grossamount')), "&timestamp=" + record.get('timestamp'), "'>", value?value:"*", "</a>"].join(""); } }, {text: "{tranttypeheader}", width: 100, dataIndex: 'trantype', flex: 1}, {text: "{netamountheader}", width: 150, dataIndex: 'netamount', align: "right", flex: 1, renderer : function(value) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } }, {text: "{taxamountheader}", width: 150, dataIndex: 'taxamount', align: "right", flex: 1, renderer : function(value) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } }, {text: "{grossamountheader}", width: 150, dataIndex: 'grossamount', align: "right", flex: 1, renderer : function(value, p, record) { return "<p style='padding-right: 10px'>" + accounting.formatMoney(value, settings) + "</p>"; } } ], stripeRows: true, height: 0, border: true, layout: 'fit', margins: {bottom: 10}, viewConfig: {forceFit: true}, bbar: { xtype: "panel", border: false, items: [ new Ext.Toolbar({ layout: "fit", border: false, bodyStyle: "background: #FF0000;", items: [{ xtype: "grid", store: totalstore, border: false, height: 50, hideHeaders: true, disableSelection: true, layout: "fit", columns: [ {text: "{taxcodeheader}", width: 100, dataIndex: 'taxcode', flex: 1}, {text: "{dateheader}", width: 100, dataIndex: 'trandate', flex: 1}, {text: "{entityheader}", width: 200, dataIndex: 'entity', flex: 1}, {text: "{trannoheader}", width: 100, dataIndex: 'tranno', flex: 1}, {text: "{tranttypeheader}", width: 150, dataIndex: 'trantype', flex: 1, renderer : function(value) { return "<b>" + value + "</b>"; } }, {text: "{netamountheader}", width: 150, dataIndex: 'netamount', align: "right", flex: 1, renderer : function(value) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } }, {text: "{taxamountheader}", width: 150, dataIndex: 'taxamount', align: "right", flex: 1, renderer : function(value) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } }, {text: "{grossamountheader}", width: 150, dataIndex: 'grossamount', align: "right", flex: 1, renderer : function(value, p, record) { return "<p style='padding-right: 10px'><b>" + accounting.formatMoney(value, settings) + "</b></p>"; } } ], viewConfig: {forceFit: true} }] }), new Ext.PagingToolbar({ id: "pgbar", pageSize: {pagesize}, store: detailstore, displayInfo: true, displayMsg: '{displaymsg}', emptyMsg: "{emptymsg}", afterPageText: "{pageoflabel} {0}", beforePageText: "{pagelabel}", listeners: { change: function (obj, data) { if (data.total > 0) { var pagestore = obj.store; var pagetotal = {netamount: 0, taxamount: 0, grossamount: 0} for(var irow = 0; irow < pagestore.getCount(); irow++) { pagetotal.netamount += Number(pagestore.getAt(irow).get("netamount")); pagetotal.taxamount += Number(pagestore.getAt(irow).get("taxamount")); pagetotal.grossamount += Number(pagestore.getAt(irow).get("grossamount")); } var pagerec = totalstore.getAt(0); if (pagerec) { pagerec.set("netamount", Number(pagetotal.netamount)); pagerec.set("taxamount", Number(pagetotal.taxamount)); pagerec.set("grossamount", Number(pagetotal.grossamount)); pagerec.commit(); } } } } }), { xtype: 'tbfill', flex: 1, docked: "bottom",}, { xtype: 'button', id: "btnexcel", text: "{exportexcel}", docked: "bottom", align: "right", listeners: { afterrender: function() { Ext.select('.x-btn-text').setStyle({'font-size': '14px','color': '#333333','font-weight': 600,'padding':'0px 12px','height':'23px'}); } }, handler: generateExcel } ] } }); var myBorderPanel = new Ext.Panel({ id: 'mainpanel', renderTo: 'maindiv', width: 0, height: 0, layout: 'border', bodyCfg : { style: {'background-color':'white'}}, border: false, items: [ { region: 'north', height: 60, html: "<div id='northdiv'><h3 class='dh7'>{company}</h3><p class='dh7'>{box}<br/>{reportingperiod}</p></div>", collapsible: false, layout: 'fit', border: false, margins: {bottom: 10} }, grid ] }); var objsize = Ext.getBody().getViewSize(); if (Ext.isIE) { myBorderPanel.setWidth(objsize.width-20); } else { myBorderPanel.setWidth(objsize.width-40); } myBorderPanel.setHeight(objsize.height - 170); } function customEncodeURIComponent(text) { return encodeURIComponent(text).replace(/[!'()*]/g, escape); } }); function generateExcel() { window.open("{drilldownurl}&actiontype=exceldrilldown&company={company}&reportingperiod={reportingperiod}&boxlabel={box}"); } </script> </head> <body> <div id="maindiv"></div> </body> </html>

Templatestoredtemplatestored

No

Typetype

custrecordentry

DRILLDOWN

General

System & IDs