Mapping set to be auto updated on creation of new project for project segment.
An account segment in TAB needs to be derived as a combination of "Project Number" & "2"(Numerical separator) & "Task Number" (Ex: Project 10000, Task Number: 01 then the segment will be 10000201). Requirement is to automatically update the mapping set.
As explained above our requirement is to derive an account segment through the combination of project, constant and task number selected in project costing fields of a requisition. We have tried to create a user defined formula but TAB documentation states that formulas can't be used, and we also couldn't find the formula while setting up the account rule.
Alternate is to create a mapping set, but we would like it to get it updated automatically instead of updating it every time manually once a project is created. Once a project is approved and active with all relevant combinations for the segment being added into the mapping set.