Solved

Vendor ID number generation

  • 4 October 2022
  • 4 replies
  • 262 views

Userlevel 3
Badge

Is it possible for the vendor ID number to be auto generated with the first 3 letters of the vendor, a number to differentiate vendors with the same first 3 letters, and then a V at the end upon vendor creation?

For example, when I add a vendor for West Side Materials, have the system automatically create the vendor ID WES001V. Then add Wesley’s Supplies Co. and have the system create the ID WES002V.

Thank you all for your time!

icon

Best answer by Laura02 4 October 2022, 19:44

View original

4 replies

Badge +16

Hello, what you are requesting might be possible with a developer writing custom code for you. I hope a developer will come along to answer what can be done with custom code.

It’s not possible with standard features of the system, to have the system auto-fill segment one with the first three letters of the vendor’s name (ABC for example), then have the system auto-number the second segment by counting the first segment (How many previous vendors started with ABC?), then have the system auto-fill the third segment with V.

Only 1 segment can be auto-numbered using standard Acumatica segmenting & numbering features.

Userlevel 7
Badge +15

HI @aidenwills15 

It seems you are looking for more of the concatenate function that excel offers. Acumatica does not have this out of the box, as @laura01  you would need a customization or you could set up you import with the vendor ID already populated. Or use the above suggestions and segement the vendor ID.

 

What is the character limitation for Customer/Vendor name? Thanks.

Userlevel 7
Badge

@kdt if you don’t get a response here, you may want to create a new post asking the question. This post is a bit old and may not draw attention.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved