Tax ID unique

Kinetic ERP
1

Hi everyone
I need suggestions on the best approach for the following: I require that the Tax ID should not be duplicated; it must be unique. I need to know if I should handle this via BPM, Customization, or if there’s a simpler way to control this.
image

2

I would go with a preprocessing BPM on Vendor.Update

3 Likes
3

There doesn’t seem to be any method calls specific to changing TaxID’s. So yeah, as @TDray said, you’ll have to settle for a pre-proc BPM on Vendor.Update.

You can probably get by with a “if the number of rows in this query is more than 0” widget. Then, in the query, grab any records matching your tenative TaxID. If true (more than 0 rows), throw error.

1 Like
4

I just created a BPM in Vendor.Update as you guys mentioned

Thanks for your help