When creating Sales Order, how to prevent entering of the same Customer Purchase Order Number?

Hello Everyone,

There have been instance that the same Customer PO was process twice. Meaning there was two Sales Order made from the same Customer PO. We want to prevent this from happening. Is there a way to prevent or notify when the user is creating the Sales Order and the user input the Customer Purchase Order, the system should be able to detect if there is a duplicate Customer PO. Or there is already and existing Customer PO.

Looking for your kind response

Rookie Asked on March 18, 2021 in Other.
Add Comment
3 Answer(s)

This is possible by writing a client script that looks for existing Customer PO # upon submit of the Sales Order.



We do the heavy lifting for your NetSuite Development projects so you can focus on growing your business.


Beginner Answered on March 18, 2021.
Add Comment
Post an order-specific string to each order’s externalID value. Because NetSuite enforces that these values be unique, populating this value prevents duplicates entirely.
Rookie Answered on March 18, 2021.

This is exactly what I needed!! Thank you for sharing this!!

on April 5, 2021.
Add Comment

Is there also an example for 2.x ?

Rookie Answered on September 28, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor