Restricting Dimension Codes Per G/L Account

Jonathan2708

Hi,

I haven't found a way so far but is it possible to restrict the possible dimension values allowed for posting against a particular G/L account? For example if I have a list of values in the COSTCENTRE dimension :

CSTA
CSTB
CSTC

But for G/L account 52100 I only want the user to be able to select CSTA or CSTB. I know you can fix a G/L account to always use the same code, or set it to mandatory so the user has to pick (any) one.

Has anybody done developments around this?

Any help appreciated,

Jonathan

ara3n

you'll have to make a modification.

You will need to create a new table called valid Dimensions that relates to GL Account.

Then during post to test and make sure the dimension is in this new table.

Jonathan2708

Many thanks Rashed, I thought this would be the case.

ara3n

You are welcome, and good luck with modification.

jannestig

Hi John

Another way you could do this is setup a new Dimension of GL account then setup the account values correctly then under Dimension combinations you could setup the scheme of what dimension you can or could not post to the individual accounts

Mike1

Hi,

The solution Jannestig provided was also the first thing that entered my mind.

This will save you the trouble of making modifications

ara3n

jannestig wrote:

Hi John

Another way you could do this is setup a new Dimension of GL account then setup the account values correctly then under Dimension combinations you could setup the scheme of what dimension you can or could not post to the individual accounts

That's a clever way to do it. Didn't think of that.

ssingla

jannestig wrote:

Hi John

Another way you could do this is setup a new Dimension of GL account then setup the account values correctly then under Dimension combinations you could setup the scheme of what dimension you can or could not post to the individual accounts

=D> =D>

Never thought of such a solution.