Have you ever asked anyone (or have you been asked by someone) “What is No. of Blank Lines Field on G/L Account card used for in Dynamics NAV?” Did you manage to answer with confidence that you are 100% right? Or did you hesitate? Yes, the field “No. of Blank Lines” sounds quite self-explanatory – it’s supposed to print as many blank lines as you defined in the field when printing Chart of Accounts report, right? And default answer you would: It’s only used when printing the Chart of Accounts. This way it knows how many blank lines should be inserted on the report for it to look “nice”.
According to help files:
No. of Blank Lines Field
The G/L Account Table
Here you can enter the number of blank lines that you want inserted before this account in the chart of accounts.
The Report Designer uses this field to determine how many blank lines to put between various accounts when printing.
No. of Blank Lines, New Page and Indentation define the layout of the chart of accounts.
Report designer uses this field when printing… Which report (or reports)? Where do you print it from? Is this field created for only one report? Or are there any other reports that will be affected by the change in this field?
Let’s find out. If we would search with function “Where-Used” in Dynamics NAV Developer Toolkit, we would get a list of reports, where this field is used:
- Report 1 Chart of Accounts
- Report 6 Trial Balance
- Report 7 Trial Balance/Previous Year
- Report 8 Budget
- Report 9 Trial Balance/Budget
- Report 10 Closing Trial Balance
- Report 16 G/L Consolidation Eliminations
- Report 17 Consolidated Trial Balance
- Report 18 Consolidated Trial Balance (4)
- Report 36 Fiscal Year Balance
- Report 37 Balance Comp. – Prev. Year
- Report 38 Trial Balance by Period
So, if someone asks you, which reports are using this field – now you should know!
Let’s run through one more example, just to confirm, how “No. of Blank Lines” field works.
If we have 0 in “No. of Blank Lines” field on G/L Account card,
and print Trial Balance report,
we will get:
However, if you have 5 in “No. of Blank Lines” field,
and print same Trial Balance report again, you will get: