In SAP Business One, you can assign a fixed asset to multiple projects and distribution rules. When you create a transaction for the asset, the projects and distribution rules are then displayed in the corresponding journal entries.
To consolidate the journal entry rows by projects and distribution rules, you can select the Consolidate Journal Entry Rows by Projects and Consolidate Journal Entry Rows by Distribution Rules checkboxes in, for example, the retirement and manual depreciation documents.
Scenario 1
If you select the checkbox Consolidate Journal Entry Rows by Distribution Rules, the system consolidates the journal entry rows by both G/L accounts and distribution rules.
JE # |
Amount |
G/L Account |
Distribution Rule |
Project |
1 |
$ 30 |
100 |
D1 |
P2 |
2 |
$ 20 |
300 |
D3 |
P1 |
3 |
$ 450 |
300 |
D3 |
P2 |
4 |
$ 32 |
300 |
D1 |
P1 |
5 |
$ 12 |
200 |
D4 |
P1 |
6 |
$ 80 |
100 |
D2 |
P3 |
7 |
$ 43 |
200 |
D1 |
P3 |
8 |
$ 23 |
100 |
D1 |
P2 |
9 |
$ 21 |
100 |
D1 |
P3 |
10 |
$ 45 |
100 |
D2 |
P2 |
$ 756 |
JE # |
Amount |
G/L Account |
Distribution |
1 |
$ 74 |
100 |
D1 |
2 |
$ 125 |
100 |
D2 |
3 |
$ 43 |
200 |
D1 |
4 |
$ 12 |
200 |
D4 |
5 |
$ 32 |
300 |
D1 |
6 |
$ 470 |
300 |
D3 |
$ 756 |
Scenario 2
If you select the checkbox Consolidate Journal Entry Rows by Projects, the system consolidates the journal entry rows by both G/L accounts and projects.
JE # |
Amount |
G/L Account |
Distribution Rule |
Project |
1 |
$ 30 |
100 |
D1 |
P2 |
2 |
$ 20 |
300 |
D3 |
P1 |
3 |
$ 450 |
300 |
D3 |
P2 |
4 |
$ 32 |
300 |
D1 |
P1 |
5 |
$ 12 |
200 |
D4 |
P1 |
6 |
$ 80 |
100 |
D2 |
P3 |
7 |
$ 43 |
200 |
D1 |
P3 |
8 |
$ 23 |
100 |
D1 |
P2 |
9 |
$ 21 |
100 |
D1 |
P3 |
10 |
$ 45 |
100 |
D2 |
P2 |
$ 756 |
JE # |
Amount |
G/L Account |
Project |
1 |
$ 78 |
100 |
P1 |
2 |
$ 101 |
100 |
P3 |
3 |
$ 12 |
200 |
P1 |
4 |
$ 43 |
200 |
P3 |
5 |
$ 52 |
300 |
P1 |
6 |
$ 450 |
300 |
P3 |
$ 756 |
Scenario 3
If you select both checkboxes, the system consolidates the journal entry rows by both G/L accounts, projects, and distribution rules.
JE # |
Amount |
G/L Account |
Distribution Rule |
Project |
1 |
$ 30 |
100 |
D1 |
P2 |
2 |
$ 20 |
300 |
D3 |
P1 |
3 |
$ 450 |
300 |
D3 |
P2 |
4 |
$ 32 |
300 |
D1 |
P1 |
5 |
$ 12 |
200 |
D4 |
P1 |
6 |
$ 80 |
100 |
D2 |
P3 |
7 |
$ 43 |
200 |
D1 |
P3 |
8 |
$ 23 |
100 |
D1 |
P2 |
9 |
$ 21 |
100 |
D1 |
P3 |
10 |
$ 45 |
100 |
D2 |
P2 |
$ 756 |
JE # |
Amount |
G/L Account |
Distribution Rule |
Project |
1 |
$ 53 |
100 |
D1 |
P2 |
2 |
$ 20 |
300 |
D3 |
P1 |
3 |
$ 450 |
300 |
D3 |
P2 |
4 |
$ 32 |
300 |
D1 |
P1 |
5 |
$ 12 |
200 |
D4 |
P1 |
6 |
$ 80 |
100 |
D2 |
P3 |
7 |
$ 43 |
200 |
D1 |
P3 |
8 |
$ 23 |
100 |
D1 |
P2 |
9 |
$ 21 |
100 |
D1 |
P3 |
10 |
$ 45 |
100 |
D2 |
P2 |
$ 756 |
Scenario 4
If you do not select either checkbox, the system consolidates the journal entry rows by G/L accounts only.
JE # |
Amount |
G/L Account |
Distribution Rule |
Project |
1 |
$ 30 |
100 |
D1 |
P2 |
2 |
$ 20 |
300 |
D3 |
P1 |
3 |
$ 450 |
300 |
D3 |
P2 |
4 |
$ 32 |
300 |
D1 |
P1 |
5 |
$ 12 |
200 |
D4 |
P1 |
6 |
$ 80 |
100 |
D2 |
P3 |
7 |
$ 43 |
200 |
D1 |
P3 |
8 |
$ 23 |
100 |
D1 |
P2 |
9 |
$ 21 |
100 |
D1 |
P3 |
10 |
$ 45 |
100 |
D2 |
P2 |
$ 756 |
JE # |
Amount |
G/L Account |
1 |
$ 199 |
100 |
2 |
$ 55 |
200 |
3 |
$ 502 |
300 |
$ 756 |