Search
 
 
Navigation
Directory
Functional Areas
Sales Automation
Marketing Automation
Customer Service
Partner Relationship Management
Website & Ecommerce
Service Bookings Total
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
Reduce Amount By Discount
Inventory Management
Services Management
Fulfillment
Billing, Time & Expense
Vendor Management
Employee Management
Financial Management
General Tools
Industries
All Solutions


Discounts (in %) the line item.
company_netsuite_logo.jpg Problem:
Apply discounts at body, item and quantity level.

Solution:
Discount can be applied at 3 levels:
 
- at body level to reduce a specific amount from the total amount.
- at line item level to reduce a specific amount from the amount at line item.
- at unit quantity level to apply discount for every unit quantity. So, 4 units would have 4 times the discount.
 
User would like to provide discount (in %) at unit quantity (level 3).
Using percentage provided by user and rate of the item, discount value is calculated. This value is reduced from the rate; the net rate = (rate - discount) is used to find amount worth of line item
 
Functionality:
Discounts (in %) the line item.

Deployment: Sales Order
Event triggering the script: Validate Line.

Custom Fields:
ID: _discpercent
Type: Percent
Level: Column
Description: It holds discount in percent at line items 

Type of Code Client SuiteScript; Calculation
Version 1.0
NetSuite Version (Minimum) 11.0.3
Script URL http://prdownloads.sourceforge.net/netsuiteroot/NS_SO_DiscountPercentPerQty.js?download
Date Created 10/18/2006
Last Modified 10/18/2006

Contributor: NetSuite Professional Services

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