Fund codes and company account codes are usually a composite of multiple segments that identify the exact origin of the fund or account in the accounting scheme. To build the fund or account code, you must concatenate the accounting segments into one identifier by designing a composite field that combines multiple data elements. You will be building the code by combining values from text box data elements and specifying a string-type pull-down; for example, designing a field called "Fund Identifier" using a formula that includes Fund Name, Fund No., and location.
Fund and company account codes can be up to 250 characters long, including delimiters (such as dashes or underscores).
Take Extra Care with These Codes!
- Because fund and account codes are at the company level, they have a significant impact on the company’s funding and accounting, and therefore, cost sheets. When you import a fund or account code attribute form into Primavera Unifier, it immediately creates at least one fund/account and one transaction for the fund/account under the funding/account codes sheet.
- Be sure your codes are correct before the attribute form goes into use in Primavera Unifier. If an inaccurate code were put into use, it could not be easily fixed; any corrected code would affect only new funds/accounts. Because of this, you cannot change the code formula once the form is imported and deployed into Unifier production. If you change the formula and attempt to re-import the form, Primavera Unifier will reject it.
To design a formula
- Open the attribute form containing the field for which you want to build the formula.
- Click Detail Form in the Navigator. The Form Designer window opens.
- Click the Properties button on the toolbar. The Elements Properties window opens.
- Select the field and click the Formula button. The Formula Creation window opens.
- Select a delimiter.
The delimiter separates the elements. For example if you select a dash (-) between elements for Account Identifier, it would appear as Account–Record-Location.
You must select the delimiter before adding the element to the right pane. You can select only one delimiter.
- Select an element from the left pane
- Click Add Parameter or double click the element. The element moves to the right pane.
If you select the wrong element, click Undo or Clear All. After you add an element, the element list is disabled and the delimiter icon is activated.
- Click the delimiter icon to add the element into the formula creation field.
- Continue adding other elements following the same procedure.
- Click OK to save the formula and close the window.