how to add two different suffix for two different PO numbers via scripting ?

Dear All, I want to generate two different PO number, by adding suffix before it, I have local vendor and foreign vendor if I choose local vendor the PO will be like “LPO-123” when chose foreign vendor the PO will be like “FPO-123”, I want to make this via scripting.

Rookie Asked on February 10, 2021 in SuiteScript.
Add Comment
2 Answer(s)


Does it matter if there are gaps in each sequence?

I’m thinking that you could let NetSuite generate the number using the default auto-numbering and then update it after that?



Intermediate Answered on February 10, 2021.

yes it is matter, my customer have two types of vendor (local vendor and foreign vendor) and each vendor has his own PO to can be differentiate between them

on February 10, 2021.
Add Comment

Consider using subsidiary specific or location specific auto numbering prefixes.

The suitescript solution to this is to use a user event script after submit entry point to lookup your purchase order’s tranid, then submit the new value. You should basically expect this to double your purchase order’s save time. If that is unacceptably long, then you can differ processing to later using a map/reduce script to do the logic.

Keep in mind that your auto numbering setup must allow overrides to overwrite the tranid.

Advanced Answered on February 12, 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   Limebox   Become a Sponsor   Become a Sponsor