Last modified by Dunja Bjelogrlic on 2021/02/11 15:47
Show last authors
1 Following versions of Balance Sheet and Income Statement reports are available:
2
3 * BALANS-DEF – Balance Sheet overview
4 * BALANS-DET – Balance Sheet Detailed (with G/L accounts listed)
5 * RESULT-DEF – Income Statement overview
6 * RESULT-DET – Income Statement Detailed (with G/L accounts listed)
7
8 After a new G/L account is created in Business Central you need to add it in Balance Sheet or Income Statement Reports.
9
10 In Searchbox type Account schedules and then choose the related link
11
12 [[image:1.png||height="151" width="535"]]
13
14
15 //**Adding G/L account in Balance Sheet Detailed report**//
16
17 When you open Account Schedule list mark BALANS-DET report
18
19 Select Process/Edit Account Schedule
20
21 [[image:2.png]]
22
23
24 Where you will place G/L account depends of G/L account number and the column “Totaling” e.g.
25
26 – **20*** means this row includes G/L accounts starting with 20 => from 200000 to 209999
27
28 – **285*..289*** includes G/L accounts starting with 285 till accounts starting with 289 => from 285000 to 288999
29
30 – **440*|442*..445*** includes G/L accounts starting with 440 or G/L accounts starting with 442 till G/L accounts starting with 445 => from 440000 to 440999 or from 442000 to 444999
31
32
33 //__Example: Adding G/L account 400000__//
34
35 – Select line Handelsvorderingen, with Totaling 40*
36
37 [[image:3.png]]
38
39
40 – On the top of the page select Insert/Insert G/L Accounts…
41
42 [[image:4.png]]
43
44 – In G/L Account List select the G/L Account you want to add, in this example 400000
45
46 – G/L Account is now added
47
48 – You need to add G/L Account number in Description field
49
50 (% style="height:155px; width:903px" %)
51 |(% style="width:460px" %)(((
52 [[image:5.png||height="65" width="434"]]
53
54
55 // G/L Account added//
56 )))|(% style="width:439px" %)(((
57 [[image:6.png||height="62" width="399"]]
58
59
60 // G/L Account Number added in Description field//
61 )))
62
63 – Select line with added G/L Account and on the upper menu select Process/Indent until it is aligned with all the other G/L Accounts listed
64
65 [[image:7.png]]
66
67
68 //**Adding G/L account in Income Statement Detailed report**//
69
70 When you open Account Schedule page mark RESULT-DET report
71
72 Select Process/Edit Account Schedule
73
74 [[image:8.png]]
75
76
77 Select the line where you are adding G/L Account
78
79 On the upper menu select Insert/Insert G/L Accounts…
80
81 [[image:9.png]]
82
83
84 – In G/L Account List select the G/L Account you want to add
85
86 – G/L Account is now added and you need to type its number in Description field
87
88 – Select line with added G/L Account and on the upper menu select Process/Indent until it is aligned with all the other G/L Accounts listed
89
90 – When you have added G/L Account in Income Statement make sure you have checked following:
91
92 * for added G/L Accounts in column Show choose “If Any Column Not Zero”
93
94 [[image:10.png]]
95
96
97 * for added Income G/L Accounts (starting with 7*) check Column “Show Opposite Sign”
98
99 [[image:11.png||height="114" width="232"]]