Author: Anila George

Excel Functions to remove characters from Left and Right ends

Remove characters from left of a text=RIGHT(A2,LEN(A2)-3)=RIGHT(D2,5)Ex: If text is POS12345 result will be 12345 Another methode will be – =REPLACE(A2,1,N,””)Here N will be the number of characters to remove. Remove Charcters from right of a text=LEFT(A2,LEN(A2)-5)=LEFT(A2,3)Ex : If text is POS12345 result will be POS

Proposal for Mass Emailer

Proposal Summary This proposal covers the scope of sending  bulk transaction emails out of Netsuite. Requirement Herbs of Gold Pty Ltd  needs a functionality  to send bulk emails to specific recipients. Our Solution Prerequisites There will be a checkbox to select the email transaction type (Statement, General/Marketing) Description of Task Invoices The invoice emails will… Continue reading Proposal for Mass Emailer

Add Watermark to Advanced PDF Template

A watermark is a text or an image that appears either in front of or behind existing document content, like a stamp. To add Watermark to an advanced PDF template define it in a macro tag so that it is included in all the pages of the template. Sample –  <head> <macrolist> <macro id=”watermark”> <p… Continue reading Add Watermark to Advanced PDF Template

Proposal For Employee Cost Update Per Month

Proposal summary This proposal covers the scope of updating employee Labor Cost per month. Requirement  Neutrinos need to update the employee cost which is used for labor costing calculations in the project module, according to the change in their payroll amounts in Adrenalin. Our Solution The Unit Cost field in the project task record is… Continue reading Proposal For Employee Cost Update Per Month

Saved search to get the contacts of the customer from an invoice.

Requirement – The purpose of this saved search is to run a report on all our contacts and bring in their spend in the past 12 months. The search should display the primary contact of the customer if there is no contact added in the invoice. Solution – Create an invoice saved search including the… Continue reading Saved search to get the contacts of the customer from an invoice.