Related topics
Note: This program handles the following calculation/redistribution modes:
- Dynamic direct
- Dynamic batch
You select the applicable mode by toggling Shift mode on the main panel. The panel sub-heading differs accordingly.
Options
- Seq
- This column lists the sequence numbers of the rules that exist within the selected base account record. The sequence number that is entered for each rule is used to sort the rules in the listing, and also decides in which sequence the rules, if more than one, should be applied when an entry is made on the base account.
- Percentage
- Displays the percentage for the created transaction in the sequence which is to be posted automatically.
- Dyn opt
- Displays the dynamic base option code defined for the rule.
- Account part 1-8
- The account combinations on which the postings of the automatic entry are to be made are shown on the same line (row) per sequence. The Line type column (if activated) indicates which account combination is of type “dynamic base account”, “into account” or “into contra account”.
One or more account part fields may be completed with underscore (___), completely or a masked part of the account. This means that the automatic entry will be made on an account combination with the same account number as the base account. However, if it matches the underscored account in the “dynamic base account” specification, then the creation of dynamic bases will be repeated for every possible value of the account part (or masked part of it).
For one account part in the “dynamic base account”, and for one account part in the “into account” and/or “into contra account”, the field is completed with dots (…). This dynamic account part is the one from which the balance or budget distribution is generated, to distribute the predefined percentage of the amount or quantity entered on the base account to the “into account” and/or “into contra account”.
If an account part is entered with all ‘-‘ (dash signs), then the creation of the dynamic base account will be independent of this account part.
- Line type
- Indicates the line type of the account combination (“dynamic base account”, “into account” or “into contra account”).
The first line type combination displays the account from which the balance or budget distribution is taken to distribute the amount or quantity to the “into account” and/or “into contra account”.
The second line type combination displays the account on which the “into account” posting of the automatic entry is to be made.
The third line type combination displays the “into contra account”.
Work with calculation/redistribution, Dynamic direct/batch details (FMR00904)
Note: This program handles the following calculation/redistribution modes:
- Dynamic direct
- Dynamic batch
You select the applicable mode by toggling Shift mode on the main panel. The panel sub-heading differs accordingly.
On this and the subsequent panels you can set up a dynamic calculation or redistribution rule within the selected base account record. You can create more than one rule for the base account. The sequence number identifies the rule and defines the order in which the rules, if more than one, should be applied.
For a redistribution rule, the “into contra” accounts will be the same as the base account.
For a calculation rule, neither of the “into account” and “into contra account” set up can be the same as the base account.
The “dynamic base account” must have one account part completed with dots (…), and so must also one or both of the “into account” and “into contra accounts”. The dotted account parts for the “into account” and/or “into contra account” must be the same account part as the dotted account part for the dynamic base account. This dynamic account part is the one from which the balance or budget distribution is generated, to distribute the predefined percentage of the amount or quantity entered on the base account to the “into account” and/or “into contra account”.
Function keys
Dynamic base options | Access program Work with dynamic base options. |
Tip: See Example 1 below for a redistribution description, and Example 2 for further details on the account part strings.
Example 1:
Below is an example of a redistribution.
Type of account | Account part combination | Account part 1 | Account part 2 | Account part 3 |
---|---|---|---|
Base account | 6010 | ____ | 200 |
Dynamic account | 6999 | … | |
Into account | 6011 | ____ | … |
Into contra account | 6010 | ____ | 200 |
The Dynamic base option code is defined as balance previous accounting period. The total percentage to distribute in this example is 100%.
The balance previous period for main account 6999, distributed per all used accounts in Account part 3, is:
Account part combination | Balance | Percentage | ||
---|---|---|---|---|
Account part 1 | Account part 2 | Account part 3 | Balance per Acc part 3 | |
6999 |
|
100 | SEK 250 | 18% |
6999 |
|
200 | SEK 450 | 32 % |
6999 |
|
300 | SEK 700 | 50 % |
Total |
|
|
SEK 1400 | 100 % |
An “into account” booking of SEK 1000 is made on account 6010 1001 200. The redistribution rule creates “into account” postings on accounts:
Account part combination | Amount | Percentage posted to Acc part 3 | ||
---|---|---|---|---|
Account part 1 | Account part 2 | Account part 3 | ||
6011 | 1001 | 100 | SEK 180 | 18 % |
6011 | 1001 | 200 | SEK 320 | 32 % |
6011 | 1001 | 300 | SEK 500 | 50 % |
Total |
|
|
SEK 1000 | 100 % |
The “into contra account” posting of SEK -1000 is posted to account 6010 1001 200.
For a calculation, both the “into account” and “into contra account” can have dots in the same account part in which the “dynamic base account” has dots.
Example 2:
You create a redistribution rule for account 1010 2___, and “into account” posting is to be made on account 1020 3___. When an amount or quantity is posted on account 1010 2019, the automatically created “into account” posting is made on account 1020 3019 and the “into contra account” posting (mandatory) is posted on account 1010 2019.
- Sequence
- Enter a sequence number for the rule you are creating within the selected base account record. The number is used to sort the rules in the listing, and also decides in which sequence the rules, if more than one, should be applied when an entry is made on the base account. For existing records, this field cannot be changed.
- Percentage
- Enter the percentage of the created transaction amount or quantity which should be posted automatically. Note: The percentage must be positive.
- Dynamic base option
- Enter a code from Work with dynamic base options to determine on which parameters the distribution should be made. It can be the balance or budget of the account, and the values can be amount or quantity. The time period for the balance/budget can also be limited to be the values from one accounting period or up to the values from an entire year.
Click Dynamic base options to create or maintain an option, if necessary.
Dynamic base account
- Account part 1-8
- Enter the account combination from which the distribution is to be generated. The system automatically checks that the accounts exist in the Account file, that they are active and that entries can be made on them. The system also checks the combination code for the main account part, if a main account is part of the combination.
The fields can be completed with underscore (___), completely or a masked part of the account. No validation against the Account file will then be possible. The entry must match the underscored account in the “dynamic base account” specification, and then the creation of dynamic bases will be repeated for every possible value of the account part (or masked part of it) at update of the dynamic base file. In this way, you do not have to enter all calculation/redistribution transactions which are for the same purpose.
Note: For one account part in the “dynamic base account”, and for one account part in the “into account” and/or “into contra account”, the field must be completed with dots (…). Note: The dotted account parts for the “into account” and/or “into contra account” must be the same account part as the dotted account part for the dynamic base account. This dynamic account part is the one from which the balance or budget distribution is generated, according to the selected dynamic base option code, to distribute the predefined percentage of the amount or quantity entered on the base account to the “into account” and/or “into contra account”.
If an account part is entered with all ‘-‘ (dash signs), then the creation of the dynamic base account will be independent of this account part. This can be used for more than one account part, but masking is not possible.
- Description
- The description of the account part is automatically retrieved from the Account file during entry.
Scroll to access the next detail panel where you enter the “into account” parameters.
Work with calculation/redistribution, Dynamic direct/batch details, Copy (FMR00905)
- Seq
- Displays the sequence of the record you selected to copy.
- New seq
- Enter a new sequence for the record that you are creating.
Work with calculation/redistribution, Dynamic direct/batch details, Deletion (FMR00908)
Work with calculation/redistribution, Dynamic direct/batch details (FMR00911)
Note: This program handles the following calculation/redistribution modes:
- Dynamic direct
- Dynamic batch
You select the applicable mode by toggling Shift mode on the main panel. The panel sub-heading differs accordingly.
On this panel you enter the parameters for the “into accounts”.
Into account
An “into account” combination cannot be equal to the base account combination, neither for a calculation, nor a distribution rule.
- Account part 1-8
- Enter the account combination that is to be used as the “into account” postings when the system creates the automatic entry. The system automatically checks that the accounts exist in the Account file, that they are active and that entries can be made on them. The system also checks the combination code for the main account part, if a main account is part of the combination.
For all account parts, you can also use underscore (___), completely or a masked part of the account, e.g. 7___, which means that any account in the account part which starts with a 7 is valid for the calculation/redistribution rule. The system will substitute the remaining characters in the account number with the characters from the base account number in that account part.
The “dynamic base account” must have one account part completed with dots (…), and so must also one or both of the “into account” and “into contra accounts”. The dotted account parts for the “into account” and/or “into contra account” must be the same account part as the dotted account part for the dynamic base account.
If this is a redistribution rule, then one account part in the “into account” only must be completed with dots. This dynamic account part will, for the postings that are created, replace the dots with the account numbers in the same account part from which the percentage distribution on the dynamic base account is generated.
Scroll to access the next detail panel where you enter the “into contra account” parameters.
Work with calculation/redistribution, Dynamic direct/batch details (FMR00912)
Note: This program handles the following calculation/redistribution modes:
- Dynamic direct
- Dynamic batch
You select the applicable mode by toggling Shift mode on the main panel. The panel sub-heading differs accordingly.
On this panel you enter the parameters for the “into contra” accounts.
Into contra account
If this is a redistribution rule, then this section is preloaded with the base accounts and cannot be changed. If it is a calculation rule, then the “into contra account” combination cannot be equal to the base account combination.
- Account parts 1-8
- Enter the account combination that is to be used as the “into contra account” postings when the system creates the automatic entry. The system automatically checks that the accounts exist in the Account file, that they are active and that entries can be made on them. The system also checks the combination code for the main account part, if a main account is part of the combination.
For all account parts, you can also use underscore (___), completely or a masked part of the account, e.g. 7___, which means that any account in the account part which starts with a 7 is valid for the calculation/redistribution rule. The system will substitute the remaining characters in the account number with the characters from the base account number in that account part.
The “dynamic base account” must have one account part completed with dots (…), and so must also one or both of the “into account” and “into contra accounts”. The dotted account parts for the “into account” and/or “into contra account” must be the same account part as the dotted account part for the dynamic base account. This dynamic account part is the one from which the balance or budget distribution is generated, to distribute the predefined percentage of the amount or quantity entered on the base account to the “into account” and/or “into contra account”.
- Description
- The description of the account part is automatically retrieved from the Account file during entry.