Business Central Adding New GL Accounts in Reports
Following versions of Balance Sheet and Income Statement reports are available:
- BALANS-DEF – Balance Sheet overview
- BALANS-DET – Balance Sheet Detailed (with G/L accounts listed)
- RESULT-DEF – Income Statement overview
- RESULT-DET – Income Statement Detailed (with G/L accounts listed)
After a new G/L account is created in Business Central you need to add it in Balance Sheet or Income Statement Reports.
In Searchbox type Account schedules and then choose the related link
Adding G/L account in Balance Sheet Detailed report
When you open Account Schedule list mark BALANS-DET report
Select Process/Edit Account Schedule
Where you will place G/L account depends of G/L account number and the column “Totaling” e.g.
– 20* means this row includes G/L accounts starting with 20 => from 200000 to 209999
– 285*..289* includes G/L accounts starting with 285 till accounts starting with 289 => from 285000 to 288999
– 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
Example: Adding G/L account 400000
– Select line Handelsvorderingen, with Totaling 40*
– On the top of the page select Insert/Insert G/L Accounts…
– In G/L Account List select the G/L Account you want to add, in this example 400000
– G/L Account is now added
– You need to add G/L Account number in Description field
G/L Account added | G/L Account Number added in Description field |
– 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
Adding G/L account in Income Statement Detailed report
When you open Account Schedule page mark RESULT-DET report
Select Process/Edit Account Schedule
Select the line where you are adding G/L Account
On the upper menu select Insert/Insert G/L Accounts…
– In G/L Account List select the G/L Account you want to add
– G/L Account is now added and you need to type its number in Description field
– 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
– When you have added G/L Account in Income Statement make sure you have checked following:
- for added G/L Accounts in column Show choose “If Any Column Not Zero”
- for added Income G/L Accounts (starting with 7*) check Column “Show Opposite Sign”