Structure relations

If the Accounts tab of your project is not displayed, start with your finance enterprise group setup. If structure relations are used, then AccountToProject or ProjectToAccount records are displayed on the Accounts tab. The accounts list on the posting project is a filtered list of the CodeBlockRelationDetail business class. Records are displayed on the posting project after you run the generate valid pairs.

Note: If you selected Any To Value Allowed on your project rules definition, no records are displayed. Click the Detail tab on your finance structure relation definition for AccountToProject to see the CodeBlockRelationDetail records created. If the project key field is All, no records are displayed on the Accounts tab. A record is not created for a specific posting project. The Accounts tab is a method to view valid pairs for the specific posting project. The tab is not required for rules validation.

A rule where both the project and account category can be blank is required if both of these items are true:

  • You are using a project to account category structure relation
  • You have set up rules for project to account category.

You cannot create a blank project to blank account category record without manually creating a rule. This scenario applies to all rules where the dimension is not required and you can leave the value blank

Note: When first creating a structure relation, set the Active property to No. After setup is completed, change Active to Yes. Selecting Yes before setup is complete can cause issues for users on the system.

For finance structure rules, you must have a rule for every valid pair or combination. Projects are generally assigned only to income statement accounts. Because a project is optional, you must have a rule where the project can be blank. The rule is required for finance structure setup and journal entries that do not include a project. Select the check box for blank values to be permitted for projects when setting up your finance structure rule.

  • CreateBlankToValueForEachValidFromValue: This option indicates that a unique detail record is created for each valid From value with the To value as blank. This option is in addition to creating the standard From/To detail record as selected by your records being processed. This option is only valid if the To side of the relation is not required.
  • The AnyToValueAllowed functionality was added to minimize the number of detail records. For a specific set of From values, you can use any To value.
  • AllowBlankToValue is only used with AnyToValueAllowed and indicates whether blank values can be used with any To value. When a From value is selected and AnyToValueAllowed is used with this option, the To side can be blank or any specified value.