Saturday, February 12, 2011

Access Drop-Down Menus from iPad

You might find it difficult to get Drop-Down Menus from iPad. Try the following preference:

Home>Set Preferences>Appearance>Centers & Dashboards>Drop-Down Menus : Open when arrow next to tab is clicked

Monday, December 20, 2010

View files attached to a sales order from Customer Center

1. Define a Transaction Subtab “More Information”

2. Define a Transaction Saved Search “Transaction Documents” available as Sublist View. Caveat: Need to define Formula (Text) field for File hyperlink CONCAT('<a href=',CONCAT({file.url},CONCAT('>',CONCAT({},'</a>'))))

3. Define a Transaction Sublist “Attached Documents”

4. View Sales Order from Customer Center

Thursday, June 25, 2009

How NetSuite reorder information is calculated

[Following is extracted from NetSuite SME email which provides another illustration on how reorder point is calculated]

NON-SEASON (Regular):

Lead Time + Safety Stock = Reorder Point
Reorder Point + Days Supply (or Order Cycle) = Preferred Stocking Level
  • Order Cycle is defined as a global value (I don’t think we call it Order Cycle but that’s the standard nomenclature in WD) represented in terms of # of days supply. Think about this as how often do you want to be placing PO’s or how many turns are you trying to achieve.
Let’s say you want a 60 day Order Cycle, Average Lead Time is 7 days and you add a small buffer of 3 more days supply in the form of Safety Stock. Let’s also assume that based on this 60 day “look-back cycle (or audit period)” NetSuite identified the fact that you sold 240 units of product X. Therefore, your demand per day is 4 (240/60).

So, Reorder Point is 28 (7 x 4) + 12 (3 x 4) = 40 units.
Preferred Stocking Level is 40 + 240 (4 x 60) = 280

This is a very standard, yet simplistic way of identifying re-order points and stocking levels (we don’t handle lost sales, exceptional sales or backorder tolerance thresholds) but that’s the formula.


The formula is the same, but the difference is the audit period. Instead of counting back the last 60 days of sales to identify our daily demand rate, we instead go back 1 year from today (or whatever day the computer performs the forecast) and count FORWARD 60 days. Those 60 days become the audit period and then we calculate everything else based on the historical consumption during that audit period. Why do we do this? Because we want to see what our demand was – on this seasonal item – LAST SEASON. Counting back the last 60 days from today is irrelevant to seasonality that comes and goes every 3 months.

Friday, June 12, 2009

NetSuite Clinic in Singapore!

NetSuite will be having its first Singapore NetSuite Clinic!

Details as follows:

DATE: Thursday June 18, 2009

VENUE: Singapore Management University (SMU), School of Economics & Social Sciences
Level 5, Seminar room 5.1, 90 Stamford Road, Singapore 178903

1:30 – 2:00 pm Registration
2:00 – 2:15 pm Welcome and Introductions
2:15 – 3:00 pm Introduction to NetSuite
3:00 – 4:00 pm Live NetSuite Product Demo
4:00 – 5:00 pm Networking Reception

Refreshments will be provided. This is a free event, but space is limited; please register in advance.

Please contact NetSuite at +65 6511 6130 if you are interested.

Don't miss it!

NetSuite Clinics in Manila!

NetSuite had another round of NetSuite Clinics in their Manila Office (RCBC Plaza in Makati) last 9 and 10 June.

While there was a street rally in the heart of the CBD, Prospects and Partners braved through the traffic jam to participate in a great open forum and networking session. Lunch was served to all participants.

Look out for the next one!

Saturday, April 11, 2009

Some Global Search Ideas

If you've been running in NetSuite for a while, the number of records coming back on saved searches gets large. Here's a few tips to help you:


To narrow global search results to records of a single type, use a search prefix made up of some or all of the letters of a standard or custom record type name plus a colon, for example: "cu:" for customer searches, or "it:" for item searches. The whole record name works to help you in some cases, like: "invoice:1002". If you had typed "inv:1002" you would have inventory items in the returns as well as invoices.

Inactive Records

Want to include inactive records? Put a "+" after the keywords; for example, "cu:acme+" will return both active and inactive customers with records containing the letters "acme".

Exact Match

You can get returns limited to those that exactly match your input. Put quotation marks around your keyword. Enter cu:"john" to search for customers with a name of John. Customers with names containing the letters john, like Johnson, Johnston, or Johnny Walker, are not returned. Don't worry about numeric keywords; they automatically return only exact matches. You might have returns of several transaction types with the same number though, so see above about prefixes.

Non-exact Match for Numeric Searches

You can get a list of non-exact matches for your numeric keyword searches by using the wildcard "%". For example, if you wanted to see all inventory items containing the number "100," you can search on "inventory:100%". This returns all inventory items that have the number 100 in their name.

New Window

If you don't want to lose the record you're on while you go look at another record you need to search for, add an extra colon between the prefix and the search string. Your results will open in a new browser window. You could combine this with a wildcard too; as in, "inventory::120%" which would open a new browser window displaying the list of inventory items with name/numbers containing the digits 120.

Happy searching!

Another great tip from one of our favourite contributors, Jay!

Monday, March 16, 2009

Indian Localization for NetSuite

Proquest Solutions Pvt. Ltd. provides customization of NetSuite to cater to Indian taxation. Taxes covered in this module include Tax Deducted at Source (TDS), VAT, Sales Tax along with Statuatory reports to be submitted to the Government.

Call 020-25635383/+919766628333 or email:

Asia Web Designer for NetSuite

Enterprise Global Limited creates tools to custom build specific API's to integrate to NetSuite platform. These tools can be part of a port to NetSuite of an exisitng site or an entirely new build within NetSuite.

Website and Intranet integration (new site build and integration to NetSuite (Custom API's for e-commerce, CRM and ERP). Localised Asian Langauge support.

Mobile Marketing solution for Netsuite

Mobile marketing channel is now available in NetSuite via integration.

A Partner, TheTMSway, provides tools

  • to build rich mobile web sites automatically optimized for all mobiles,

  • to deliver the mobile offer via Mobile alert from all Media (print, web, traditional), and

  • to collect and manage users data.

Wednesday, February 18, 2009

Tip-Bit: Emailing Preferences

For emailing transactions, you can give your users options when sending.

From the Administrator role, go to Setup>Company>Printing, Fax & Email Preferences, and click on the Email subtab. In the Transactions section, check the Use Popup For Main Transaction Email Button checkbox, and then Save.

When users click the Email button on transactions, they will now get a pop-up box with tabs to add additional recipients, add a message, choose how to send; e.g., inline, HTML, PDF, and much more.

Mahalo to Jay for this Tip!