Is it possible in NS to create cumulative quantity...
# general
l
Is it possible in NS to create cumulative quantity discounts for a specific period of time (not quantity discounts per individual transaction)? Say, the discounts are 1%, 3% and 5% if the customer purchased 1,000, 3,000 and more than 5,000 units CUMULATIVELY, respectively, in one calendar year (taking into consideration the prior sales within the CY). Same is required for the vendor purchases. Hopefully without scripting if there are alternative options.
v
My first thought, scripting. but, if you are flexible, you can probably accomplish this by process. 1. Create a saved search to sum the purchases by customer 2. Export the Saved Search, create columns that will allow you to re-import another transaction 3. Do your math outside of NetSuite for the discount and import a separate transaction like a Credit Memo or something that would align with your discount logic