Create balance sheets as well as income statements according to the Accounting Act.
Current Version: 24.2.0.1as of Business Central 24. For older BC versions, downgrades are available. AppSource Name: NAVAX Balance
Manual
Creation date: 2024/11/25 The current version of this manual can be found at:
☰ Contents
General
NAVAX Balance NAVAX Balance extends Microsoft Dynamics 365 Business Central with the ability to create balance sheets as well as income statements according to the Accounting Act...
Role Center Integration NAVAX Balance is integrated into the Finance, Accountant and Accounting Manager roles in the Finance group, but can be accessed from any role via the Search function...
Setup
Balance Groups In the Balance Groups page you can set up groups to combine G/L Accounts. The groups can then be used in different balance schedules...
Working with the App
Balance Schedules In the Balance Schedules page, you set up the balance sheet and the income statement...
Edit Balance Schedule In the Balance Schedule page you can set up the lines of the balance schedule...
Balance Preview Via the Balance Preview, the balance schedule can be calculated and displayed without printing it...
Print Balance The balance schedule can be printed via the action Print Balance resp. Print Balance incl. Difference...
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 / NAVAX Balance / General NAVAX Balance
NAVAX 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
NAVAX Balance is integrated into the Finance, Accountant and Accounting Manager roles in the Finance group, but can be accessed from any role via the Search function.
For more information, see General, Role Center Integration.
Fields, actions, pages and reports originating from the extension are labled with NCB.
The search terms "navaxbalance", "nvxb", "ncb" and "navax" are recognized by "Tell me what you want to do".
Note
NAVAX Balance was developed with the prefix NCB resp. NVXB.
NCB resp. NVXB stands for NAVAX Consulting resp. NAVAXBalance.
Permission Sets
The following permission sets are available for the NAVAX Balance:
Name
Description
NVXB
NAVAX Balance
You need these permissions to use the NAVAX Balance.
Docs / NAVAX Balance / General Role Center Integration
NAVAX Balance is integrated into the Finance, Accountant and Accounting Manager roles in the Finance group, but can be accessed from any role via the Search function.
Here you can open the Balance Groups and the Balance Schedules.
Docs / NAVAX Balance / Setup Balance Groups
In the Balance Groups page you can set up groups to combine G/L Accounts. The groups can then be used in different balance schedules.
Fields
Code
Specifies the code for the group.
Description
Specifies a description for the group.
No. of G/L Accounts
Specifies the number of G/L Accounts that are assigned to the group.
Actions
Add G/L Accounts
Adds selected G/L Accounts to the group.
Note
Only G/L Accounts of the type Posting are transferred.
Account Assignment
View or set up the G/L Accounts that are assigned to the group.
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 Account Assignments
Checks which G/L Accounts are assigned to which groups and which G/L Accounts have not yet been assigned to a group.
Options
Only G/L Accounts without assignment
Specifies whether an overview of all G/L Accounts that have not yet been assigned to a group should be displayed.
Only multiple-assigned G/L Accounts
Specifies whether an overview of all G/L Accounts that are assigned to multiple groups should be displayed. G/L Accounts can be assigned to several groups, for example, if they must be displayed in the assets or liabilities when the balance is turned.
Show Balance Groups
Specifies whether an overview of all assigned groups should be displayed.
Docs / NAVAX Balance / Working with the App Balance Schedules
In the Balance Schedules page, you set up the balance sheet and the income statement.
You can create as many balance schedules as you need. For example, you can create a balance sheet with the legally required minimum structure and additional balance sheets with a different structure and statistical accounts.
The lines of the balance schedule are set up via the Edit Balance Schedule action.
For more information, see Working with the App, 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.
Docs / NAVAX Balance / Working with the App Edit Balance Schedule
In the Balance Schedule page you can set up the lines of the balance schedule.
To do this, select the balance schedule that you want to edit in the Name field.
For more information, see Working with the App, 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 balance groups 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:
Group
Select a Balance Group.
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 Group or 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 Group or Account are considered.
Group-Total
Here you can add up different Balance Groups. In contrast to the Group 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 Group-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 Group and 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 Group-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 Group or 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 Group, Account and Group-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.
Displays a list of all G/L Accounts that are not included in the current schedule.
Copy from
Copies the settings from another schedule and adds it to the current schedule.
Docs / NAVAX Balance / Working with the App Balance Preview
Via the 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.
For more information, see Working with the App, Balance Schedules.
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.
Open the balance schedule overview in a new Excel workbook. This creates an Excel workbook on your device.
Update Excel 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 / NAVAX Balance / Working with the App Print Balance
The balance schedule can be printed via the action Print Balance resp. Print Balance incl. Difference.
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.
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.
Request License
The license can be requested or checked via the Current Status action. 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 granted.
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)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
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.
The following Granules are required for an On-Premises installation:
70714575 NCB Balance by NAVAX
1010860 Extension Base by NAVAX
External Addresses
https://www.navax.app
For licensing, calling the online help and performing some actions, access to https://www.navax.app must be granted.
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)
CRL Servers In addition, the following CRL Servers must also be accessible for the certificate check: https://certificates.godaddy.com/* http://crl.godaddy.com/* or their IP: 192.124.249.36
Docs / NAVAX Balance / Appendix Release Notes
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Version 24.2.0.1
as of Business Central 24 2024/10/14
Note
This version is also available as a downgrade version for Business Central 21, 20 and 14.
Modifications
Texts that cause a line break during printing are now printed entirely.
Version 24.2.0.0
as of Business Central 24 2024/10/10
New Product Name
The NCB Balance extension has been renamed to NAVAX Balance.
Improvements
The Balance Classifications have been renamed to Balance Groups.
Corrections
In the Balance Preview, there were problems with the page refresh in certain constellations.
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.
Version 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.
Version 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.
NAVAX Balance
Here you can open the Balance Groups and the Balance Schedules.
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.
