Mapping set to be auto updated on creation of new project for project segment.
Summary:
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.
Content:
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.