Category: NS Implementation

All articles / code related to Netsuite implementation

Accessing email data send from email plugin inside Suitelet script

The data can be send to a suitelet from a email capture plugin implementation javascript file using ‘POST’ method.If the suitelet is triggered in ‘POST’ method, we can access this data.The data transferred using ‘POST’ method will be inside ‘scriptContext.request.body’. Since this is transferred as JSON file, the first step on using the datais to… Continue reading Accessing email data send from email plugin inside Suitelet script

Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation

Client came with  the requirement to balance the amount in particular bank a/c in a subsidiary which showed different amount than the actual bank balance in balance sheet  due to the exchange rate variation. Solution: Go to Transaction> Financial > Revalue Open Currency Balance(admin role) Select the period and the subsidiary in which the account… Continue reading Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation

Delete All Hidden Rows or Columns in Excel

If you want to delete all hidden rows or columns in Excel, just do the following steps: 1. click File tab, and select Info menu from the popup menu list. 2. click Check for Issues button in the Info page. And select Inspect Document from the drop-down list. The Document Inspector dialog box will appear. 3. click Inspect button in the Document Inspector window. 4. click Remove All button in the Hidden Rows and Columns section.

Merging of accounts

We can merge one account into another if they are the same account type and the account we want to merge has no attached subaccounts. You can combine an account with a parent account or with a subaccount. To merge accounts: Go to Setup > Accounting > Manage G/L > Chart of Accounts (Administrator) Click… Continue reading Merging of accounts

Inventory Level Warning

In-order to give alerts when inventory levels reach or decrease below a reorder point and preferred stock levels, we can enable Inventory level warnings under Transactions sub-tab of Set preferences.

Inventory Detail

The inventory detail sub-record is available when the Advanced Bin / Numbered Inventory Management feature is enabled. This record stores values related to bin numbers or serial/lot numbers for items, including line items on transactions. Arrow : The arrow icon indicates that the inventory detail is available for the item and needs to be configured. It appears only… Continue reading Inventory Detail

Vendor Prepayments

The Vendor Prepayments feature records and tracks deposit amounts paid to vendors prior to the acceptance of a purchase order by the vendor.We can apply these prepayment amounts against open bills for the vendor.  We can apply the prepayment manually or  we can configure NetSuite to apply the prepayment automatically. Vendor Prepayment feature can be enabled by; Go… Continue reading Vendor Prepayments

To create a campaign email address record:

Creating a campaign email address record for Marketing Campaigns: Go to Setup > Marketing > Setup Tasks > Email Addresses > New. On the Campaign Email Address page, enter the email address you want to use. If you check the Private box, only the person that entered this campaign email address record can: View this email address record… Continue reading To create a campaign email address record: