Search
 
 
Navigation
Directory
Functional Areas
Sales Automation
Marketing Automation
Customer Service
Partner Relationship Management
Website & Ecommerce
Line Item Profit on Estimate
Calculate QTY Sum
Transaction Line Count
Markup Percent (%) on Line Item Amount
Add Markup Price ($) to Item Line Amount
Gross Profit Percent (%) at Line Level
Gross Profit at Line Level
Discounts (in %) the line item.
Reduce Amount By Discount
Inventory Management
Services Management
Fulfillment
Billing, Time & Expense
Vendor Management
Employee Management
Financial Management
General Tools
Industries
All Solutions


Service Bookings Total
company_netsuite_logo.jpg Problem:
Need to track service bookings seperately and expose it on clearly in the order's body.
 
Solution:
Using a combination of custom fields and SuiteScript, add up all item lines marked as service items, and store the total in the Service Bookings transaction body custom field.
 
SERVICE BOOKING TOTAL
• service bookings example – adds up all items marked as service and stores the total in the Service Bookings transaction body custom field
• script: sampleRecalc
• prerequisites:
 
   o add item custom field: Service Item
      • Type: Checkbox
      • Subtab: Basic
      • Applies To: Service
      • ID: _service_item
      • Note: need to assign Service Item checkbox to all service items.
   o add transaction column custom field: Service Item
      • Type: Checkbox
      • Source List: Item
      • Source From: Service Item
      • Display Type: Disabled
      • Help: You could make this field hidden, but I have chosen to leave it visible, but locked, so that you may see what the custom code is reacting to.
      • ID: _service_item      
      • Applies To: Sale
   o add transaction body custom field: Service Bookings
      • Type: Currency
      • Subtab: Main
      • Display Type: Disabled
      • Help: Stores the total of all services items from the transaction.
      • ID: _service_bookings
      • Applies To: Sale
     
• code: sampleRecalc 

Type of Code
Version 1.0
NetSuite Version (Minimum)
Script URL http://prdownloads.sourceforge.net/netsuiteroot/NS-ServiceBookingTotal.js?download
Date Created 18-JUN-05
Last Modified 18-OCT-06

Contributor: NetSuite Product Management

Contributor Overview: Founded in 1998, NetSuite, Inc. is the leading provider of integrated business application software for small and midsize businesses. With thousands of customers using NetSuite's online products and professional services, companies are enabled to manage all key business operations—in a single hosted system, including: customer relationship management (CRM); order fulfillment; inventory; finance and product assembly; ecommerce; Web site management; and employee productivity.

Website: http://www.netsuite.com