Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function customRecordPrint(type, form, request){
- if (type == 'print' || type == 'edit'){
- //create saved search for custom records
- var filters = new Array();
- filters[0] = new nlobjSearchFilter('custrecord_acc_product', null, 'anyof', nlapiGetRecordId());
- var columns = new Array();
- columns[0] = new nlobjSearchColumn('custrecord_acc_period');
- columns[1] = new nlobjSearchColumn('custrecord_acc_col1');
- columns[2] = new nlobjSearchColumn('custrecord_acc_col2');
- columns[3] = new nlobjSearchColumn('custrecord_acc_col3');
- columns[4] = new nlobjSearchColumn('custrecord_acc_total');
- var result = nlapiSearchRecord('customrecord_acc_list', null, filters, columns);
- var customRecords = {columns: columns, results: result};
- //populate current printout with custom record entries
- var columns = customRecords.columns,results = customRecords.results,
- custrecord = form.addField('custpage_custrecord_to_print', 'longtext', '', null, null),
- custrecordArray = [];
- if (results && results instanceof Array){
- for (var i = 0; i < results.length; i++){
- var singleLine = {};
- for (var j = 0; j < columns.length; j++){
- var value = results[i].getValue(columns[j]);
- if (j==0 || j==1 || j==2){
- if (value.indexOf('.')==0 || value.indexOf(',')==0 || value.indexOf('-.')==0 || value.indexOf('-,')==0){
- value = '0'+value;
- }
- }
- singleLine["col"+j] = (value)?value:'';
- }
- custrecordArray.push(singleLine);
- }
- custrecord.setDefaultValue(JSON.stringify(custrecordArray));
- }
- }
- }
Add Comment
Please, Sign In to add comment