Auto Assign Project ID with BPM in Epicor

If your company wants to streamline its project entry process, you can customize Epicor to auto-assign a project ID.

Step 1. Create a BPM method directive on the “GetNewProject” method belonging to the Project business object.

This should be a post-processing directive.

Step 2. Create a new action to execute ABL code.

/*Assign Project ID
When a new project is created, lookup Company.Number01 and increament it by 1.
Use that number as the new project ID. */define variable newNum as integer.
define variable newNumString as character.

for each ttProject where ttProject.RowMod = ‘A’ or ttProject.RowMod = ‘U’:

/* Lookup the Company that the Project is being created in */
find first Company exclusive-lock where Company.Company = ttProject.Company.
If available Company then do:

/* Increment project count by 1 */
assign newNum = Company.Number01 + 1.

/* Update Company.Number01 */
assign Company.Number01 = newNum.

/* Put the letter ‘P’ in front and pad with leading zeros */
assign newNumString = “P” + string(newNum,”999999″).

assign ttProject.ProjectID = newNumString.

End. /* If */
End. /* For Each */

Step 3. Add the code to the ABL action screen.

Step 4. Enable the customization.

Step 5. Go to the Project Entry screen and create a new project. The ProjectID will be automatically generated.

Suggested

• More blogs by Charles Johnson
• The Datix Blog
• Meet our Consultants
• Learn more about Datix ERP consulting services