Create balance sheets as well as income statements according to the Accounting Act. Current Version: 21.1.7.1as of Business Central 21. For older BC versions, downgrades are available.
Manual
Creation date: 2024/04/27 The current version of this manual can be found at:
☰ Contents
General
NCB Balance NCB Balance extends Microsoft Dynamics 365 Business Central with the ability to create balance sheets as well as income statements according to the Accounting Act...
Setup
Balance Classifications Balance Classifications can be used to group G/L Accounts together...
Check Balance Classification Assignments The NCB Check Balance Classification Assignments report can be used to check which G/L Accounts are assigned to which Balance Classifications and which G/L Accounts have not yet been assigned to a Balance Classification...
Balance Schedules In the Balance Schedules page, you set up the balance sheet and income statement...
Edit Balance Schedule The lines of the balance schedule are set up in the NCB Balance Schedule page...
Reports and Analysis
Balance Preview Via the NCB Balance Preview, the balance schedule can be calculated and displayed without printing it...
Print Balance The balance schedule can be printed via the Print NCB Balance or Print NCB Balance incl. Difference report...
Appendix
NAVAX License Management The NAVAX License Management page (in older versions NAVAX License Overview or NCEX License Overview) displays the current license status of the NAVAX extensions...
Installation Notes
Release Notes
Docs / NCB Balance / General NCB Balance
NCB Balance extends Microsoft Dynamics 365 Business Central with the ability to create balance sheets as well as income statements according to the Accounting Act.
Navigation
NCB Balance is integrated in the Profiles (Roles) Finance, Accountant and Accounting Manager in the Finance group after the Account Schedules.
Fields, actions, pages and reports originating from the NCB Balance extension are identified by the abbreviation NCB. This additional labeling makes them clearly distinguishable from other extensions (which may use similar names and designations).
NCB stands for NAVAX Consulting Balance.
The search terms "nvxb", "ncb" and "navax" are recognized by "Tell me what you want to do".
This allows very fast access to the individual areas of the NCB Balance.
Permission Sets
The following permission sets are available for the NCB Balance:
Name
Description
NVXB
NCB Balance
You need these permissions to use the NCB Balance.
Balance Classifications can be used to group G/L Accounts together.
The classifications can then be used in different balance schedules.
Fields
Code
Specifies the code for the classification.
Description
Specifies a description for the classification.
No. of G/L Accounts
Specifies the number of assigned G/L Accounts of the classification.
Actions
Add G/L Accounts
Adds selected G/L Accounts to the classification.
Note
Only G/L Accounts of the type Posting are transferred.
Assigned G/L Accounts
View or set up the G/L Accounts assigned to the classification.
Note
If you set the Show Opposite Signfield on an assigned G/L Account, balances with negative signs are displayed as positive (and vice versa balances with positive signs as negative).
Check Classification Assignments
Checks which G/L Accounts are assigned to which Balance Classifications and which G/L Accounts have not yet been assigned to a Balance Classification. A report request window opens where you can specify what to include on the print-out.
For more information, see Setup, Check Balance Classification Assignments.
The NCB Check Balance Classification Assignments report can be used to check which G/L Accounts are assigned to which Balance Classifications and which G/L Accounts have not yet been assigned to a Balance Classification.
Options
Only G/L Accounts without Classification
Select the check box if you want to see an overview of G/L Accounts that have not been assigned to a classification.
Only multiple used G/L Accounts
Select the check box if you want to see an overview of G/L Accounts assigned to multiple classifications. G/L Accounts can be assigned to several classifications, for example, if they must be displayed in the assets or liabilities when the balance is turned.
Show Classifications
Select the check box if you want to view an overview of the assigned classifications.
Docs / NCB Balance / Setup Balance Schedules
In the Balance Schedules page, you set up the balance sheet and income statement.
You can create any number of balance schedules, each with a unique name.
For example, you can create a balance sheet and income statement with the legal minimum classifications and another structure, with statistical accounts.
The lines of the balance schedule are set up via the Edit Balance Schedule action.
For more information, see Setup, Edit Balance Schedule.
Fields
Name
Specifies the name of the balance schedule.
Description
Specifies a description for the balance schedule.
Consecutive Numbering
Specifies whether hidden lines and lines without balance should be ignored by the automatic numbering when creating or printing the balance schedule.
If a balance schedule is evaluated or printed, the lines are automatically numbered.
To ensure that the same number is always assigned to a line for different evaluation periods, hidden lines and lines without a balance are also taken into account by default.
As a result, there are gaps in the numbering.
If this field is set, these lines will no longer be taken into account.
Actions
Edit Balance Schedule
Opens the balance schedule based on the current balance schedule name.
For more information, see Setup, Edit Balance Schedule.
Prepare to print the balance. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Print incl. Difference
Prepare to print the balance incl. difference. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Docs / NCB Balance / Setup Edit Balance Schedule
The lines of the balance schedule are set up in the NCB Balance Schedule page.
To do this, select the balance schedule that you want to edit in the Name field.
For more information, see Setup, Balance Schedules.
A balance schedule consists of the 3 areas Assets, Liabilities and Income Statement.
The Area field determines which area is to be displayed or which lines are to be edited.
Fields
Row No.
Specifies a row number which can be used in other lines in a Formula (field Totaling Type).
You can also assign a row number more than once. This allows you, for example, to add together several classifications located in different positions in one formula.
Tip
Use letters in row numbers (e.g. A0003, R4711, etc.) to clearly distinguish between rubric numbers and values in formula.
Description
Specifies a description for the line.
Numbering
Specifies the numbering type.
For example, the first time you select A-B-C (Upper), that line is marked with A, the next one with B, and so on. The other options work in exactly the same way.
No Numbering
Specifies that no numbering should be done for this line.
Totaling Type
Determines which type of calculation should be performed for the line.
Options:
Classification
Select a Classification.
G/L Account
Select one or more G/L Accounts from the Chart of Accounts in Financial Accounting.
All Income Accounts
All G/L Accounts that are marked as Income Statement in the Income/Balance field are calculated in total. This option is needed for the current period result (Liabilities).
Formula
This option allows you to perform calculations with the row numbers.
End-Total
This option calculates up to this line the cumulative value of all previous lines with Totaling Type Classification or G/L Account.
Begin-End-Total
At the first occurrence of Begin-End-Total, the sum of all previous lines is calculated. The next occurrence of Begin-End-Total calculates the sum of the values since the last Begin-End-Total line, and so on.
Only lines with the Totaling Type Classification or G/L Account are considered.
Classification-Total
Here you can add up different classifications. In contrast to the Classification option, no G/L Accounts are listed and the calculated total is not included again in the overall result.
Note
Lines with Totaling Type Formula, End-Total, Begin-End-Total, and Classification-Total have no effect on the total Assets/Liabilities.
Totaling
Depending on the Totaling Type field, select the valid values here.
Thereof Line
Specifies whether this is a Thereof Line whose value is not automatically included in the total lines.
The display is automatically indented by a further level. Lines with Totaling Type Classification and G/L Account can be defined as a Thereof Line.
No Total View
Specifies whether the automatic display as a total line (right-justified with separator lines) should be suppressed.
This selection affects the Formula, End-Total, Begin-End-Total, and Classification-Total Totaling Types.
Hide
Specifies which information of this line should be hidden.
Options:
Empty (default setting)
The line will be printed only if the value is <> 0.
Detailed G/L Account Lines
The G/L Accounts of this line are hidden or not printed.
Line Incl. Detailed G/L Account Lines
All G/L Accounts and the line itself are hidden or not printed.
Never
The line is always displayed.
For Totaling Type Classification or G/L Account, the final result line of the totaling is also always displayed, even if there are no detailed G/L Account lines and the amount is therefore 0.
No Assets/Liabilities Switch
Indicates whether no asset/liability switch should be made.
By default, an account defined in Assets is displayed only if it has a positive balance. In the liabilities, only those with a negative balance are displayed.
If you activate this field, the line will be displayed where it is defined, regardless of the balance. (e.g. negative balances of depreciation accounts if you use indirect depreciation for assets).
Note that the negative or positive balance definition always refers to the actual balance in Financial Accounting. The Show Opposite Sign field has no effect on this function.
The setting in this field affects the Classification, G/L Account and Classification-Total Totaling Types.
Row No. Assets/Liabilities Switch
Specifies whether the asset/liability switch should be made based on another line. In this case, specify the Row No. of the line that should control the switch of the current line. Only lines located before the current line can be accessed.
Show Opposite Sign
Specifies whether the sign of the result in this line should be reversed. The setting is ignored for Totaling Type Formula.
Income Base
Specifies whether the selected line should be used as the basis for the income statement.
This field is used as a reference point (100% basis) in the income statement. All other lines are calculated in relation to this as a percentage.
For example, you can specify the line Operating performance as the basis.
A multiple selection is possible - the sum of the lines for which the income base is set forms the calculation basis.
Income Balance at Date
Indicates whether the Balance at Date and not the Net Change should be used in the selected line.
Thus, not only profit and loss accounts but also balance sheet accounts can be evaluated in the income statement.
Orientation
Specifies the orientation for the line.
New Page
Specifies whether a page break should occur before the current line.
Bold
Specifies whether to print the line in bold or not. With Automatic, only automatically generated total lines are printed in bold.
The setting does not affect the Detailed G/L Account Lines.
Italic
Specifies whether to print the line in italics.
Underline
Specifies whether to underline the line when printing.
Prepare to print the balance. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Print incl. Difference
Prepare to print the balance incl. difference. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Not incl. Accounts
Displays a list of all G/L Accounts that are not yet included in the current schedule.
Copy from
Copies the settings from another schedule and adds it to the current schedule.
Docs / NCB Balance / Reports and Analysis Balance Preview
Via the NCB Balance Preview, the balance schedule can be calculated and displayed without printing it.
To do this, select the balance schedule that you want to be calculated in the Name field.
After the filters and settings have been made, the preview can be recalculated via the Update Preview action.
Filter, Fields
Balance Current Year To
Specifies the date of the current year up to which the balance should be considered.
Balance Previous Year To
Specifies the date of the previous year up to which the balance should be considered.
Income Current Year From
Specifies the date of the current year from which the income statements should be considered.
Income Current Year To
Specifies the date of the current year up to which the income statements should be considered.
Income Previous Year From
Specifies the date of the previous year from which the income statements should be considered.
Income Previous Year To
Specifies the date of the previous year up to which the income statements should be considered.
Global Dimension 1 Filter
Specifies a filter that will be used to filter or calculate the values.
Global Dimension 2 Filter
Specifies a filter that will be used to filter or calculate the values.
Business Unit Filter
Specifies a filter that will be used to filter or calculate the values.
Options, Fields
Hide Detailed G/L Account Lines
Specifies whether the G/L Accounts should be displayed or not.
Rounding Factor
Specifies the factor that should be used to round the results in the balance.
Journal Preview, Fields
Calculate Journal
Specifies that a journal should be included in the printout which has already entered a balance sheet or income statement but has not yet been posted.
Journal Template Name
Specifies the name of the journal template.
Journal Batch Name
Specifies the name of the journal.
Fields
Row No.
Displays the row number for the line.
Description
Displays the description for the line.
G/L Account No.
Displays the G/L Account No. for the line.
Current Year
Displays the result of the line for the current year.
Current Year %
Displays the result of the line for the current year in percent.
Previous Year
Displays the result of the line for the previous year.
Previous Year %
Displays the result of the line for the previous year in percent.
Difference
Displays the difference.
Difference %
Displays the difference in percent.
Actions
Update Preview
Updates the preview based on recent changes.
Print
Prepare to print the balance. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Print incl. Difference
Prepare to print the balance incl. difference. A report request window opens where you can specify what to include on the print-out.
For more information, see Reports and Analysis, Balance Preview.
Create New Workbook
Open the balance schedule overview in a new Excel workbook. This creates an Excel workbook on your device.
Update Copy Of Existing Workbook
Refresh the data in the copy of the existing Excel workbook, and download it to your device. You must specify the workbook that you want to update.
Docs / NCB Balance / Reports and Analysis Print Balance
The balance schedule can be printed via the Print NCB Balance or Print NCB Balance incl. Difference report.
To do this, select the balance schedule that you want to print in the Name field.
Filter, Fields
Balance Current Year To
Specifies the date of the current year up to which the balance should be considered.
Balance Previous Year To
Specifies the date of the previous year up to which the balance should be considered.
Income Current Year From
Specifies the date of the current year from which the income statements should be considered.
Income Current Year To
Specifies the date of the current year up to which the income statements should be considered.
Income Previous Year From
Specifies the date of the previous year from which the income statements should be considered.
Income Previous Year To
Specifies the date of the previous year up to which the income statements should be considered.
Global Dimension 1 Filter
Specifies a filter that will be used to filter or calculate the values.
Global Dimension 2 Filter
Specifies a filter that will be used to filter or calculate the values.
Business Unit Filter
Specifies a filter that will be used to filter or calculate the values.
Options, Fields
Hide Detailed G/L Account Lines
Specifies whether the G/L Accounts should be displayed or not.
Rounding Factor
Specifies the factor that should be used to round the results in the balance.
Hide Assets
Specifies whether the assets should be displayed or not.
Hide Liabilities
Specifies whether the liabilities should be displayed or not.
Hide Income Statement
Specifies whether the income statements should be displayed or not.
Show Schedule Name
Specifies whether the name of the balance schedule should be displayed.
Journal Preview, Fields
Calculate Journal
Specifies that a journal should be included in the printout which has already entered a balance sheet or income statement but has not yet been posted.
The NAVAX License Management page (in older versions "NAVAX License Overview" or "NCEX License Overview") displays the current license status of the NAVAX extensions.
In order for a NAVAX extension to be displayed in this page, the corresponding setup of the extension must first be opened.
Note
Changes as of Version xx.1.16.0
The NAVAX License Management page now supports automatic adding of NAVAX extensions. NAVAX extensions that use this system no longer need to have the corresponding extension setup opened first to be displayed in this page.
Fields
Name
Specifies the name of the Extension.
License Status
Specifies the current license status of the Extension.
Serial No.
Specifies the serial number of the Extension.
Version
Specifies the currently installed version of the Extension.
Trial Version
A NAVAX extension can be tested or used free of charge for 30 days after installation. After that, the extension can only be used with a valid license.
Note
Changes as of Version xx.1.4.0
The licensing of a NAVAX extension is only necessary in the production environment. In the sandbox environment, NAVAX extensions can be tested unlimited.
Request License
The license can be requested or checked via the Current Status action (in older versions What's New?). This opens a window.
The following example shows the NAVAX extension Excel Report Builder.
Fill in the fields in the window and then click Send License Request.
Please note that the licensing process may take some time.
In the next few days you will receive an email with further information.
Note
For licensing, calling the online help and performing some actions, access to https://www.navax.app must be allowed.
Public IP from www.navax.app for setting firewall access: 94.136.22.236, Port: TCP/443
Checking the connection to https://www.navax.app using PS: Test-NetConnection navax.app -port 443 (PS must be performed with the M-Tier service user)
Activate/Update License
As soon as the licensing has been completed, you will receive an email and the license can be activated via the Update License action.
The license is company independent. So it does not matter in which company the action is called.
Note
The licence must be updated once a year via the Update License action.
The update is only possible or necessary within the last 30 days before the license expires, or afterwards. Within the last 30 days before the license expires, notes are displayed.
If the Automatic License Renewal is enabled, the Update License action is called automatically before the license expires. Note that the setting is only active after the license has been activated via the action.
This action can be used to open the Microsoft AppSource ratings page for the extension.
We would be very happy if you submit your rating and let us know about your experience with the Extension.
When selecting the Area in the NCB Balance Schedule and in the NCB Balance Preview, there were problems with the page refresh in certain constellations.
NCB 21.1.6.0
as of Business Central 21 2022/12/12
Improvements
NCB Balance is now also available as a downgrade version for Business Central 14.
If Never is selected in the Hide field for Totaling Type Classification or G/L Account, the final result line of the totaling is now displayed even if there are no detailed G/L Account lines and the amount is therefore 0.
Corrections
The Bold setting in the balance schedule lines only affected the preview and not the printout.
NCB 21.1.5.0
as of Business Central 21 2022/10/18
Business Central Update
Improvements
Print NCB Balance Classification Plan has been renamed to NCB Check Balance Classification Assignments.
The Row No. Assets/Liabilities Switch field has been added to the balance schedule lines.
This can be used to control whether the asset/liability switch should be made based on another line.
The Bold field in the balance schedule lines has been changed. Different settings are now available.