Auto Populate Vendor Number Using BPM - Help

[dgreenEA (Dylan Green)]

I’m currently trying to get a BPM and User Code together for setting up the automatic population of Vendor ID’s. The format I’m looking for is to take the first letter of the vendor name add three zeros and then the current number we are on, EX: Vectren = V0001.

I am currently following this thread about how to do it: Auto Numbering - Customer ID. The instructions are on the second posting by Andy.

The part that I currently need help with is the positioning of the second BPM that converts the “AutoAssign” Vendor ID to something usable. Just need a push in the right direction.

Thanks for the help!

[josecgomez]

Auto Sequence Customer ID

@Gabriel011212 Here’s a quick video tutorial of how to do this as well as the “code” needed. This works for Customer but can be done for pretty much any module in Epicor. Note that this is done in Post Processing on Customer.GetNew() because in pre-processing we don’t yet have a Customer row. The video may take a few minutes to render in HD (you-tubes fault) It is a simple one line widget [image] [image] [image] new Ice.Lib.NextValue(Db).GetNextSequence("CustIDSeq").ToString("00000")

[dgreenEA (Dylan Green)]

@josecgomez,
For the numbering this works perfectly! The next error I have run into is that because there is no name entered by the time the post process runs I cannot assign a letter designation in front of the number value. I think I can get past this by using Vendor Update and having it only hit on an added row.

The next issue I foresee is how to have it check letter by letter for number designation for instance: Vector = V001, France = F001, Vancouver = V002, Franklin = F002. Any tips on this?