This article is relevant if you are looking to distinguish sale transactions as “New” vs. “Existing”.
Background
Many times, organizations create incentive plans that distinguish sales as either “New” or “Existing”. The idea is that a New sale may receive a different (typically greater) credit than an existing sale. We have a number of clients with sales program that think in these terms. However, this is not easy to do without running searches or reports as needed. Ideally, we need a way to record transactions with this information as it occurs such that any dependent function has the information at hand.
Distinguishing “New” vs. “Existing”
The first thing that must be done is to determine what we mean when we say “New” or “Existing”. Further, what structure is “New” vs. “Existing”. Consider the following:
- Customer: A customer is considered “New” if the most recent sale was within 12 months; else it is “Existing”.
- Item: An item is considered a “New” sale if the the more recent sale was within 6 months; else item sales are “Existing”.
How to Stamp Sales Transactions with “New” vs. “Existing” Information
Get the SuiteBundle
See Related Articles
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
One thought on “Distinguish NetSuite Sales as “New” vs. “Existing””