Row level security for customized accounting unit

Derived Accounting Unit is a field that is available for customizing Accounting unit security. Row level security that is applicable to the Accounting Unit is applied to the Derived Accounting Unit. Derived Accounting unit field will be the same as Accounting Unit unless it is customized. Derived Accounting unit is customized through the AccountingUnitStartPosition and AccountingUnitEndPosition variables while processing the data. AccountingUnitStartPosition variable is 0 and AccountingUnitEndPosition variable is 50, by default.

For example:

Accounting Unit: 100234

Custom Accounting Unit: 100234.456,100234.457

In the example, Custom Accounting Unit is the combination of Accounting Unit and Location code. Accounting unit can be extracted using the AccountingUnitStartPosition and AccountingUnitEndPosition variables. In this example the Derived Accounting Unit can be extracted as 100234 by adjusting the variables.

AccountingUnitStartPosition: 0

AccountingUnitEndPosition: 6

Note: Starting position is 0, ending position is the position after the last one that should be included.

The value 100234 can be given to the user in Accounting Unit security spread sheet which will give him the access to Accounting unit 100234.