Expand an account number with a fixed value
You renumber the chart of accounts, for example to switch from a 4-digit chart of accounts to a 6-digit chart of accounts. You can do this by adding a code before or after the original account number.
Contents |
Append a fixed value
You expand the ledger account numbers by 'attaching' a code to each number.
Example: The journal structure has a 4-digit chart of accounts linked to it, but your financial administration has a 5-digit chart of accounts. The original numbers have four positions. To expand them on the right with a zero, you have to place the fixed value '0' at target position 5. For this purpose you configure one replacement line that looks as follows:
|
To expand account numbers with a fixed value:
- Go to: HR / Organisation / Employer.
- Open the employer’s properties.
- Go to the tab: Replacement ledger account.
- Click on the action: Maintenance.
- Select the Replacement line maintenance (advanced) entry layout.
- Click on: OK.
- Complete the first entry line, as follows:
- Leave Account number empty (because this line applies to all accounts).
- Select Fixed value in Source.
- Enter the Fixed value.
This is the code with which you want to expand the account numbers.
- Enter the positions you want to replace in Target from and Target to.
- Click on the action: Example chart.
- Close the view with the example.
- Click on: Finish.
Place a fixed value in front
You expand the ledger account numbers by adding a code in front of each ledger account, for example an employer code.
Example:
You have a journal structure with a 4-digit chart of accounts linked to it. Your financial administration has an 8-digit chart of accounts, with the first three positions taken up by the employer code. The code is followed by a period and then the rest of the account number
The original numbers have four positions. To expand the numbers with a code on the left, you configure two replacement lines:
- The new numbers will have eight positions, with the last four positions used for the original account number.
- The first four positions (left) are replaced by '001.'.
During the journalising, the effect is:
- 1800 becomes 001.1800
- 1805 becomes 001.1805
- Etc.
To expand account numbers with a fixed value:
- Complete the first entry line, as follows:
- Leave Account number empty (because this line applies to all accounts).
- Select the original ledger account number in Source.
- Enter the positions you want to replace in Target from and Target to.
- Complete the second entry line, as follows:
- Leave Account number empty (because this line applies to all accounts).
- Select Fixed value in Source.
- Enter 001. in Fixed value.
- Enter the positions you want to replace in Target from and Target to.
- Click on the action: Example chart.
- Close the view with the example.
- Click on: Finish.
Directly to |