Retrieving Price Level and Quantity-Based Pricing in NetSuite

Overview: This saved search retrieves Inventory Items that are associated with a specific Price Level (e.g., Price Level 12) and provides critical data such as Minimum Quantity, Unit Price, and promotional status. This search is especially useful for businesses that have tiered pricing based on customer groups or regions.

Saved Search Explanation

This search includes the following key features:

1. Filters for active inventory items (isinactive: F).
2. Pricing filter to focus only on items associated with a specific price level (pricing.pricelevel: 12).
3. Columns like Price Level, Minimum Quantity, and Unit Price from the Pricing record.

javascript

Copy

Edit
var inventoryitemSearchObj = search.create({
   type: "inventoryitem",
   filters: [
      ["type", "anyof", "InvtPart"],
      "AND", 
      ["isinactive", "is", "F"],
      "AND",
      ["pricing.pricelevel", "anyof", "12"]
   ],
   columns: [
      search.createColumn({name: "itemid", label: "Name"}),
      search.createColumn({name: "salesdescription", label: "Description"}),
      search.createColumn({name: "custitem20", label: "Included in Promotion"}),
      search.createColumn({
         name: "pricelevel",
         join: "pricing",
         label: "Price Level"
      }),
      search.createColumn({
         name: "minimumquantity",
         join: "pricing",
         label: "Minimum Quantity"
      }),
      search.createColumn({
         name: "unitprice",
         join: "pricing",
         label: "Unit Price"
      })
   ]
});

Key Columns and Filters:

• Price Level: Filters for inventory items that use Price Level 12. This could represent a specific pricing tier or customer group.
• Minimum Quantity: Shows the minimum quantity required for a specific price level or discount.
• Unit Price: Displays the price per unit associated with the pricing level.
• Included in Promotion: Indicates whether the item is part of a promotional offer.

How to Use It:

1. Price Level Insights: This saved search is ideal for analyzing items sold under specific pricing tiers (Price Level 12 in this case). You can track which items are in that price tier and see how their prices compare to others.
2. Volume Pricing and Discounts: The Minimum Quantity and Unit Price columns help identify items that are eligible for discounts based on the quantity purchased. For example, items might have a set price for up to 10 units, and a discount for quantities exceeding that amount.
3. Promotional Tracking: The Included in Promotion column shows if an item is part of a promotion, helping you track which products are being sold under promotional pricing, depending on the price level and quantity.

Code Enhancements for Further Customization:

• Add Price List Information: If you have multiple price levels or price lists, you can add more filters or columns to see how different price levels interact.

javascript

Copy

Edit
search.createColumn({
   name: "pricelevel",
   join: "pricing",
   label: "Price Level"
});

• Get Discount Information: You can include Discount columns to better understand the pricing strategies.

javascript

Copy

Edit
search.createColumn({
   name: "discount",
   join: "pricing",
   label: "Discount"
});

Conclusion:

This saved search provides valuable insights for businesses that use multiple price levels for different customer groups or regions. By including Price Level, Minimum Quantity, and Unit Price, it allows for comprehensive analysis of volume-based pricing strategies.