Dimension rules

Created by Erik Åkerlund, Modified on Mon, 20 Feb 2023 at 02:30 PM by Erik Åkerlund

Dynamic accounting rules to create the Account

Dimension rules is a sub menu to Accounting

In Dimension rules the user can set up the dynamic accounting account based on translation of bank account or for example currency. 

The most common dynamic dimension rules is for bank accounts. Usually one fictive or real bank account has its own accounting account to mirror what has happened in the bank account. 

  1. Open System settings / accounting and check field Dynamic account format. should be {0}. If two dynamic accounts are used to build the account then type {0}{1} It is also possible to add a special sign for example - between {0}-{1} then the - will always be added between the two dynamic accounts.
  2. Enter the rule/rules creating the dynamic account. E.g. Bank account, In condition expression type a condition for which accounts the rule should be applied. All accounts that StartsWith(Account), '19'). See below. In the table below all bank account name for each legal entity are translated to a accounting account. TRSEBSEK (Treasury) = 1922 etc. Don't forget to tick is dynamic for all rules creating the accounting account!
  3. Note, when a deal is entered and saved the dynamic accounts are set and shown if you click on icon "Accounting" or drill down in "Accounting View".   

Dimension rules to set mandatory information for the ERP system

Here you can set up all the accounting Dimensions (extensions) used in the ERP system/systems. For example if you have dimension 3 Counterparty and it is needed for all internal profit and loss accounts a dimension rule needs to be set up for which account it should be applied to and also a translation of what the different Counterparties are called in the accounting system. See example rule 3 below in this case the only used profit and loss accounts StartsWith(Account,'8') and the tag selected is counterpart. If this only should be applied to internal deals it could be added as a selection choose company type Internal. If the company is called something else in the ERP system a translation can be done in the table below. Click on the plus sign and choose what codes that should be translated. Add the translation in the Text field,  SEB = ESESSESS, SHB = HANDSESS etc. Note if the counterparty have the same name in the ERP system as in Treasury systems select code "Same value" and leave text blank, the SEB = SEB in the accounting file. Select Default FINANS  

If an Expression is applied StartsWith('','') it defaults '' but if [Account] is choosen no '' should be applied before and after correct set up is show in print screen below. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article