Consolidation of Journal Entry Rows by Projects and Distribution Rules

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.

Sample Data
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

Summary Output
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.

Sample Data
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

Summary Output
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.

Sample Data
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

Summary Output
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.

Sample Data
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

Summary Output
JE #	Amount	G/L Account
1	$ 199	100
2	$ 55	200
3	$ 502	300
	$ 756

More Information

Asset Master Data Window - Fixed Assets Tab: Cost Accounting Subtab