Current Version: 24.2.0.0as of Business Central 24. For older BC versions, downgrades are available. AppSource Name: NAVAX G/L Application
Manual
Creation date: 2024/11/22 The current version of this manual can be found at:
☰ Contents
General
NAVAX G/L Application The NAVAX G/L Application adds G/L Application for selected G/L Accounts to Microsoft Dynamics 365 Business Central...
Setup
Source Code Setup The source codes for the GLA G/L Application are set up in the Source Code Setup page...
G/L Accounts In order for the G/L Application to be active and entries can be applied, the application method for the G/L Account must be set. If the G/L Application is active, detailed G/L Entries are created for the G/L Account or G/L Entries when they are posted...
Tasks
Apply G/L Entries A G/L Entry Application can be performed either by posting via a Journal or, for G/L Entries that have already been posted but are still open, directly via the G/L Entries page...
Unapply G/L Entries If necessary, an application can be unapplied again via the GLA Unapply Entries action in the G/L Entries page (or directly in the GLA Detailed G/L Entries page). This opens the GLA Unapply G/L Entries page and displays all applied entries...
Reports and Analysis
G/L Account - Balance to Date The GLA G/L Account - Balance to Date report shows a detailed balance for selected G/L Accounts where an GLA Application Method is set. The report can, for example, be used at the close of an accounting period or fiscal year...
Archive
G/L Entries The following fields and actions are available in the G/L Entries...
Applied G/L Entries The GLA Applied G/L Entries page shows the entry or entries that have been applied to a selected G/L Entry...
Detailed G/L Entries The GLA Detailed G/L Entries page shows not only the original G/L Entry, but also any changes made by the entry application...
Appendix
Date Compress General Ledger
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...
Information for Developers
Installation Notes
Release Notes
Docs / NAVAX G/L Application / General NAVAX G/L Application
The NAVAX G/L Application adds G/L Application for selected G/L Accounts to Microsoft Dynamics 365 Business Central.
Navigation
Fields, actions, pages and reports originating from the NAVAX G/L Application extension are labled with GLA.
The search terms "g/l application", "gla", "nvxgla", "ncgla" and "navax" are recognized by "Tell me what you want to do".
Note
The NAVAX G/L Application was developed with the prefix NCGLA resp. NVXGLA.
NCGLA resp. NVXGLA stands for NAVAX Consulting resp. NAVAXG/LApplication.
Permission Sets
The following permission sets are available for the NAVAX G/L Application:
Name
Description
NVXGLA
NAVAX G/L Application
You need these permissions to use the NAVAX G/L Application.
The source codes for the GLA G/L Application are set up in the Source Code Setup page.
All relevant codes can be found in the General group.
Fields
GLA Apply G/L Entries
Specifies the code assigned to entries that are posted from the G/L Entry Application.
For more information, see Tasks, Apply G/L Entries.
GLA Unapply G/L Entries
Specifies the code assigned to entries that are posted when unapplying a G/L Entry Application.
For more information, see Tasks, Unapply G/L Entries.
Docs / NAVAX G/L Application / Setup G/L Accounts
In order for the G/L Application to be active and entries can be applied, the application method for the G/L Account must be set. If the G/L Application is active, detailed G/L Entries are created for the G/L Account or G/L Entries when they are posted.
Fields
GLA Application Method
Specifies whether the G/L Application is active for this G/L Account and G/L Entries could be applied.
If you change the field to Manual, detailed G/L Entries will be created for all existing G/L Entries of the G/L Account for which detailed G/L Entries do not yet exist. For new G/L Entries, a detailed G/L Entry is automatically created when posting to the G/L Account. The detailed G/L Entries are created with Entry Type = Initial Entry.
If you set the field to " ", any detailed G/L Entries that may exist will not be deleted, but they will then be irrelevant to this G/L Account.
Note
You can set the field to Manual or " " at any time. Whenever you set the field to Manual, the missing detailed G/L Entries are created for the new G/L Entries that have been added in the meantime.
A G/L Entry Application can be performed either by posting via a Journal or, for G/L Entries that have already been posted but are still open, directly via the G/L Entries page.
The GLA Application Method field in the G/L Account determines whether the G/L Application is active for this G/L Account and G/L Entries could be applied.
For more information, see Setup, G/L Accounts.
By default, the GLA G/L Application is integrated into the following journals:
General Journals
Cash Receipt Journals
Payment Journals
Sales Journals
Purchase Journals
Note
Via a individual programming, the G/L Application can also be made available in other journals. In this case, contact your Microsoft Dynamics 365 Business Central Partner directly.
For more information, see Appendix, Information for Developers.
To apply G/L Entries in a Journal
To be able to apply G/L Entries, a G/L Account with active G/L Application must be specified in the journal line.
The G/L Account can be specified as Account or as Bal. Account.
If a G/L Account with active G/L Application is specified as Account and as Bal. Account, the G/L Account that is specified as Account will be used.
For the Application the Amount (LCY) field is used.
It is possible to specify a currency code in the journal line.
The G/L Application in a journal line can be done either by a document number, or by a Application ID.
Note
GLA G/L Application provides separate fields (GLA Applies-to ID, GLA Applies-to Doc. Type and GLA Applies-to Doc. No.) for the application in the journals. This makes the G/L Application independent of the Customer/Vendor Application and makes it possible to carry out a G/L Application and a Customer/Vendor Application in one journal line at the same time.
Apply with document number
On the journal line, enter the relevant information about the entry to be applied.
Using the GLA Applies-to Doc. No. field (hidden by default), you can open the GLA Apply G/L Entries page and select the G/L Entry you want to apply to.
Post the journal.
Apply with Application ID
On the journal line, enter the relevant information about the entry to be applied.
Choose the GLA Apply G/L Entries action.
This opens the GLA Apply G/L Entries page showing the open entries for the G/L Account.
Select the open entries that you want to be applied with the posting and then choose the Set Applies-to ID action.
Note
If an ID already exists for the journal line, it will be used. If no ID has been assigned yet, a new ID will be determined automatically.
The ID for the application is stored in the journal line in the GLA Applies-to ID field (hidden by default) and can also be assigned manually.
Note that the selection of the open entries will be reset if you change the ID in the journal line.
It is possible to apply a G/L Entry across several journal lines (same GLA Applies-to ID in several lines).
If the GLA Applies-to ID field is changed in a journal line, the GLA Applies-to ID of the G/L Entry is reset if there are no further lines in the journal for the application.
For each line in the GLA Amount to Apply field, enter the amount you want to apply to the individual entry.
If you do not enter an amount, the maximum amount is applied.
Choose the OK button.
Post the journal.
To apply already posted G/L Entries
The G/L Entry Application can be performed for already posted but still open G/L Entries in the G/L Entries page using the GLA Apply Entries action.
Select the G/L Entry you want to apply.
Choose the GLA Apply Entries action.
This opens the GLA Apply G/L Entries page showing the open entries for the G/L Account.
Note
The same page is opened as when applying G/L Entries in a Journal.
But additionally, the Post Application and Preview Posting actions are also available now.
Select the open entries that you want the G/L Entry to be applied to, and then choose the Set Applies-to ID action.
Note
Compared to the Customer/Vendor Application, the G/L Application allows you to apply directly from the older posting date to the more recent posting date.
For each line in the GLA Amount to Apply field, enter the amount you want to apply to the individual entry.
If you do not enter an amount, the maximum amount is applied.
Choose the Post Application action.
The GLA Post Application page opens where you can specify the settings to be used for the application or to create the entries for the application.
Journal Template Name
Specifies the name of the journal template that is used for the posting.
The field is only available if Journal Templ. Name Mandatory is activated in the General Ledger Setup.
Journal Batch Name
Specifies the name of the journal batch that is used for the posting.
The field is only available if Journal Templ. Name Mandatory is activated in the General Ledger Setup.
Document No.
Defaults to the document number of the G/L Entry you want to apply.
Posting Date
Defaults to the posting date of the open entry that has the most recent posting date.
Choose the OK button to post the application.
If the posted application has resulted in closed G/L Entries, the GLA Open field is cleared for these entries.
If necessary, an application can be unapplied again via the GLA Unapply Entries action in the G/L Entries page (or directly in the GLA Detailed G/L Entries page). This opens the GLA Unapply G/L Entries page and displays all applied entries.
To unapply the application of one (or more) applied entries, the following actions are available in the page:
Unapply
Unapplies the selected (marked) entries.
Important
If an entry has been applied by more than one application entry, you must unapply the latest application entry first.
Preview Unapply
Preview how unapplying the selected entries will look like.
Note
When you unapply an application, correcting entries that are identical to the original entry but with opposite sign in the amount field are created and posted for all entries and the entries that were previously closed by the application are reopened.
Thus, when an application is unapplied, only the application between the two G/L Entries is cancelled, but not the posting itself.
If, for example, a payment is posted and applied to an open G/L Entry, a later unapplying does not reverse the posting or the G/L Entry of the payment. In this case, both G/L Entries are marked as Open after the application has been unapplied and both also have an open Remaining Amount.
Docs / NAVAX G/L Application / Reports and Analysis G/L Account - Balance to Date
The GLA G/L Account - Balance to Date report shows a detailed balance for selected G/L Accounts where an GLA Application Method is set. The report can, for example, be used at the close of an accounting period or fiscal year.
Options
Ending Date
Specifies the last date until which information in the report is shown. If left blank, the report shows information until the present time.
New Page per G/L Account
Specifies whether each G/L Account balance should be printed on a separate page.
Include Unapplied Entries after Ending Date
Specifies whether the report should include entries that are closed on the ending date but that have been unapplied afterwards.
Show G/L Accounts with Zero Balance
Specifies if the report should include G/L Accounts with a balance of 0. By default, the report only includes G/L Accounts with a positive or negative balance.
Standard Shading
Specifies whether to use the standard Business Central shading where all entries are shaded, or whether to shade only entries with a variance between the Original Amount and the Remaining Amount.
The GLA Detailed G/L Entries page shows not only the original G/L Entry, but also any changes made by the entry application.
Fields
Posting Date
Specifies the posting date of the detailed G/L Entry.
Entry Type
Specifies the entry type of the detailed G/L Entry.
Options:
Initial Entry
Shows the original G/L Entry.
Application
Indicates that two or more G/L Entries have been applied to each other.
Document Type
Specifies the document type of the detailed G/L Entry.
Document No.
Specifies the document number of the transaction that created the entry.
G/L Account No.
Specifies the G/L Account number to which the entry is posted.
Amount
Specifies the amount of the detailed G/L Entry.
Debit Amount
Specifies the total of the entries that represent debits.
Credit Amount
Specifies the total of the entries that represent credits.
User ID
Specifies the ID of the user who posted the entry.
Source Code
Specifies the source code that specifies where the entry was created.
Reason Code
Specifies the reason code, a supplementary source code that enables you to trace the entry.
Unapplied
Specifies whether the entry has been unapplied (undone) via the Unapply G/L Entries page.
Unapplied by Entry No.
Specifies the number of the correcting entry, if the original entry has been unapplied.
G/L Entry No.
Specifies the entry number of the G/L Entry that the detailed G/L Entry line was created for.
For more information, see Archive, G/L Entries.
Entry No.
Specifies the number assigned to the entry.
Actions
Unapply Entries
Unselect one or more entries that you want to unapply this record.
For more information, see Tasks, Unapply G/L Entries.
Find entries...
Find entries and documents that exist for the document number and posting date on the selected document.
Docs / NAVAX G/L Application / Appendix Date Compress General Ledger
Important
Detailed G/L Entries are not covered by the standard date compression in Business Central. For this reason, the call to the standard Date Compress General Ledger report (ID: 98, Name: Date Compress General Ledger) has been blocked by the NAVAX G/L Application extension and the GLA Date Compress General Ledger report (ID: 0714676, Name: NVXGLA Date Compress G/L) must be used instead.
When calling the standard report, an attempt is made to automatically call up the GLA Date Compress General Ledger report. If the automatic call fails, a message will be displayed and the standard report will be terminated.
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.
Docs / NAVAX G/L Application / Appendix Information for Developers
Additional Journals
By default, the NAVAX G/L Application is already integrated into some journals via pageextensions.
The code is identical in all journals.
Thus, the NAVAX G/L Application can also be made available in other journals with little effort via individual programming.
Below is the code for the integration using the General Journal as an example.
pageextension 70714681 "NVXGLA General Journal" extends "General Journal"
{
ContextSensitiveHelpPage = 'Journal';
layout
{
modify("Account Type")
{
trigger OnAfterValidate();
begin
NVXGLAEnableApplyGLEntriesAction();
end;
}
modify("Bal. Account Type")
{
trigger OnAfterValidate();
begin
NVXGLAEnableApplyGLEntriesAction();
end;
}
addafter("Applies-to ID")
{
field("NVXGLA Applies-to Doc. Type"; Rec."NVXGLA Applies-to Doc. Type")
{
ApplicationArea = All;
ToolTip = 'Specifies the type of the posted document that this document or journal line will be applied to when you post.';
Visible = false;
}
field("NVXGLA Applies-to Doc. No."; Rec."NVXGLA Applies-to Doc. No.")
{
ApplicationArea = All;
ToolTip = 'Specifies the number of the posted document that this document or journal line will be applied to when you post.';
Visible = false;
}
field("NVXGLA Applies-to ID"; Rec."NVXGLA Applies-to ID")
{
ApplicationArea = All;
ToolTip = 'Specifies the ID of entries that will be applied to when you choose the ''GLA Apply G/L Entries'' action.';
Visible = false;
}
}
}
actions
{
addafter("Apply Entries")
{
action(NVXGLAApplyEntriesAction)
{
ApplicationArea = All;
Caption = 'GLA Apply G/L Entries';
Ellipsis = true;
Enabled = NVXGLAApplyGLEntriesActionEnabled;
Image = ApplyEntries;
RunObject = Codeunit "NVXGLA Gen. Jnl.-Apply";
ShortCutKey = 'Alt+F11';
ToolTip = 'Apply the amount on a journal line to one or multiple G/L Entries.';
}
}
addafter("Apply Entries_Promoted")
{
actionref(NVXGLAApplyEntriesAction_Promoted; NVXGLAApplyEntriesAction)
{
}
}
}
var
NVXGLAApplyGLEntriesActionEnabled: Boolean;
trigger OnAfterGetRecord()
begin
NVXGLAEnableApplyGLEntriesAction();
end;
trigger OnAfterGetCurrRecord();
begin
NVXGLAEnableApplyGLEntriesAction();
end;
trigger OnNewRecord(BelowxRec: Boolean);
begin
NVXGLAEnableApplyGLEntriesAction();
end;
local procedure NVXGLAEnableApplyGLEntriesAction()
begin
NVXGLAApplyGLEntriesActionEnabled :=
(Rec."Account Type" = Rec."Account Type"::"G/L Account") or
(Rec."Bal. Account Type" = Rec."Bal. Account Type"::"G/L Account");
end;
}
The following Granules are required for an On-Premises installation:
1011130 NCGLA GL Application 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
It is now possible to apply a G/L Entry across several journal lines (same GLA Applies-to ID in several lines). Until now, only the first line was considered in this case.
If the GLA Applies-to ID field is changed in a journal line, the GLA Applies-to ID of the G/L Entry is only reset if there are no further lines in the journal for the application.
The field Journal Templ. Name Mandatory from the General Ledger Setup is now considered.
Corrections
The GLA Applies-to ID field in the journals was not determined correctly in certain constellations by the Renumber Document Numbers action.
If a GLA Applies-to ID was already set for an G/L Entry (e.g. from a journal line), this ID was deleted when the Apply G/L Entries page was opened for the entry via the G/L Entries page.
Version 21.1.5.0
as of Business Central 21 2024/06/18
Modifications
Changes for developers resp. the extensibility of the app.
The applying of already posted G/L Entries aborted with an error message.
Version 18.1.0.1
as of Business Central 18 2021/09/14
Corrections
If errors were displayed in the Posting Preview and the Posting Preview was called again afterwards, the error message "The record in table Gen. Journal Line already exists." was displayed.
If the G/L Account for the application was specified as Bal. Account and an amount was also specified, the filter on positive for the open entries was set incorrectly when selecting them via the GLA Applies-to Doc. No. field.
NAVAX G/L Application
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.
