Project COA Mask
Use Project Mask Create (25.3.9.3.1) to specify the ranges of GL accounts, sub-accounts, and cost centers that you can use in combination with a particular project when posting.
You then associate the COA mask with a project by specifying the project COA mask code in the COA Mask field in Project Create. See
Creating Projects.
If you have activated project COA masks in Domain Create, you must specify ranges in at least one of the three grids in Project Mask Code Create.
Project COA Mask Code Create (25.3.9.3.1)
The field character restrictions are the same as those for Sub-Account Mask Create. See
Sub-Account COA Mask.
Example:
Sub-account 28 is assigned the following COA mask:
Sub-Account COA Mask: SAMatrix1 |
GL Account From | GL Account To | Disallowed? |
010 | 1999 | No |
2002 | 3000 | No |
2050 | 2055 | Yes |
Cost center Dep2 is assigned the following COA mask:
Cost Center COA Mask: CCMatrix2 |
GL Account From | GL Account To | Disallowed? | | Sub-Account From | Sub-Account To | Disallowed? |
010 | 1999 | No | | 01 | 99 | No |
2010 | 3000 | No | | 102 | 199 | No |
2050 | 2055 | Yes | | | | |
The project code Engineering is assigned the COA mask, PrjMatrix1. Project COA mask PrjMatrix1 contains the following ranges:
Project COA Mask: PrjMatrix1 |
GL From | GL To | Disallowed? | S-A From | S-A To | Disallowed? | CC Fr | CC To | Disallowed? |
001 | 999 | No | 01 | 99 | No | Dep1 | Dep 2 | No |
1002 | 2999 | No | 101 | 150 | Yes | Dep6 | Dep8 | Yes |
| | | | | | Dep8 | Dep9 | No |
The COA masks are used to validate the postings listed in the following table:
Postings and Validation Result
GL Account | Sub-Account | Cost Center | Project | Validated? |
998 | 100 | Dep1 | Engineering | No |
1004 | 28 | Dep2 | Engineering | Yes |
2000 | 10 | Dep8 | Engineering | No |
2997 | 123 | Dep9 | Engineering | No |
The posting with GL account 998, sub-account 100, and cost center Dep1 fails to validate because sub-account 100 is not defined in the sub-account range for the project mask.
The posting with GL account 1004, sub-account 28, and cost center Dep2 is validated because:
• The sub-account mask assigned to sub-account 28 includes GL account 1004 within its valid ranges.
• The cost center mask assigned to Dep2 includes GL account 1004 and sub-account 28 within its valid ranges.
• The project mask assigned to project Engineering includes GL account 1004, sub-account 28, and cost center Dep2 within its valid ranges.
The posting with GL account 200, sub-account 10, and cost center Dep8 fails to validate because Dep8 is part of a disallowed range.
The posting with GL account 2997, sub-account 123, and cost center Dep9 fails to validate because sub-account 123 is part of a disallowed range.