Author: Anila George

Purchase Order number not available on Inbound Shipments

When there is an issue in selecting Purchase Order Document number on inbound shipments, you can try the following Edit the Purchase Order which is missing on inbound record Close the item lines that are not available on Inbound Shipments using the Closed column on the item line. Close all the item lines if Po has more than one… Continue reading Purchase Order number not available on Inbound Shipments

The account used in vendor Prepayment

The Vendor Prepayments feature records and tracks deposit amounts paid to vendors before they accept purchase orders for a good or service. You can apply these prepayment amounts against open bills for the vendor. Vendor Prepayments enables you to record and track multiple prepayments and prepayment applications for your vendors. After you make a prepayment… Continue reading The account used in vendor Prepayment

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.