How to create a csv file of saved search using script

Use the task module    //Create a task for saved search             let searchTask = task.create({                    taskType: task.TaskType.SEARCH                });                searchTask.savedSearchId = saved search internal id;searchTask.filePath = filePath//where the… Continue reading How to create a csv file of saved search using script

How to check condition in PDF template

In the PDF template, we can check the condition using <#if>. Here we are showing an image only if the sales order location is ‘Outlet Center’. <#if record.custbody_aha_sales_location=”Outlet Center”> <#if companyInformation.logoUrl?length != 0> Airport Home Appliance –Builder Division${record.location.address1}${record.location.city} ${record.location.state} ${record.location.zip}${record.custbody_aha_sales_location.phone} Sales Invoice #${record.tranid} ${record.trandate} The source code is metioned below. <#if record.custbody_aha_sales_location=”Outlet Center”> <img src=”src… Continue reading How to check condition in PDF template

Proposal for Employee Price Automation

Client need an automation.Every time when we change the “Item defined cost” (costestimate), we want to update the “Employee Price”.The “Employee Price” should be 20% on top of “Item defined cost” rounded off to the next full Dollar amount.Example: New “Item defined cost” is $6.52, the “Employee Price” should be CEIL({costestimate}*1.2) = $8. Proposal Proposal… Continue reading Proposal for Employee Price Automation