Open item management for selected G/L Accounts. Current Version: 21.1.4.1as of Business Central 21. For older BC versions, downgrades are available.
Manual
Creation date: 2024/04/26 The current version of this manual can be found at:
☰ Contents
General
NCGLA G/L Application NCGLA G/L Application adds open item management for selected G/L Accounts to Microsoft Dynamics 365 Business Central...
Setup
Source Code Setup The source codes for the NCGLA G/L Application are set up in the Source Code Setup page...
G/L Accounts In order for the open item management to be active and entries can be applied, the application method for the G/L Account must be set...
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 NCGLA Unapply Entries action in the G/L Entries page (or directly in the NCGLA Detailed G/L Entries page). This opens the NCGLA Unapply G/L Entries page and displays all applied entries...
Reports and Analysis
G/L Account - Balance to Date The NCGLA G/L Account - Balance to Date report shows a detailed balance for selected G/L Accounts where an NCGLA 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 NCGLA 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 NCGLA 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 / NCGLA G/L Application / General NCGLA G/L Application
NCGLA G/L Application adds open item management for selected G/L Accounts to Microsoft Dynamics 365 Business Central.
Navigation
Fields, actions, pages and reports originating from the NCGLA G/L Application extension are identified by the abbreviation NCGLA. This additional labeling makes them clearly distinguishable from other extensions (which may use similar names and designations).
NCGLA stands for NAVAX Consulting G/LApplication.
The search terms "nvxgla", "ncgla" and "navax" are recognized by "Tell me what you want to do".
This allows very fast access to the individual areas of the NCGLA G/L Application.
Permission Sets
The following permission sets are available for the NCGLA G/L Application:
Name
Description
NVXGLA
NCGLA G/L Application
You need these permissions to use the NCGLA G/L Application.
The source codes for the NCGLA G/L Application are set up in the Source Code Setup page.
All relevant codes can be found in the General group.
Fields
NCGLA 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.
NCGLA 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 / NCGLA G/L Application / Setup G/L Accounts
In order for the open item management to be active and entries can be applied, the application method for the G/L Account must be set.
If the open item management is active, detailed G/L Entries are created for the G/L Account or G/L Entries when they are posted.
The following fields and actions are available in the G/L Accounts.
Fields
NCGLA Application Method
Specifies whether the open item management 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 NCGLA Application Method field in the G/L Account determines whether the open item management 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 NCGLA 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 open item management 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 open item management 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
NCGLA G/L Application provides separate fields (NCGLA Applies-to ID, NCGLA Applies-to Doc. Type and NCGLA 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 NCGLA Applies-to Doc. No. field (hidden by default), you can open the NCGLA 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 NCGLA Apply G/L Entries action.
This opens the NCGLA 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 NCGLA 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.
For each line in the NCGLA 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 NCGLA Apply Entries action.
Select the G/L Entry you want to apply.
Choose the NCGLA Apply Entries action.
This opens the NCGLA Apply G/L Entries page showing the open entries for the G/L Account.
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 NCGLA 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 NCGLA Post Application page opens where you can specify the settings to be used for the application or to create the entries for the application.
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 NCGLA Open field is cleared for these entries.
If necessary, an application can be unapplied again via the NCGLA Unapply Entries action in the G/L Entries page (or directly in the NCGLA Detailed G/L Entries page). This opens the NCGLA 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 / NCGLA G/L Application / Reports and Analysis G/L Account - Balance to Date
The NCGLA G/L Account - Balance to Date report shows a detailed balance for selected G/L Accounts where an NCGLA 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 NCGLA 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 / NCGLA 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 NCGLA G/L Application extension and the NCGLA 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 NCGLA 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.
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.
Docs / NCGLA G/L Application / Appendix Information for Developers
Additional Journals
By default, the NCGLA G/L Application is already integrated into some journals via pageextensions.
The code is identical in all journals.
Thus, the NCGLA 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 ''NCGLA Apply G/L Entries'' action.';
Visible = false;
}
}
}
actions
{
addafter("Apply Entries")
{
action(NVXGLAApplyEntriesAction)
{
ApplicationArea = All;
Caption = 'NCGLA 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 applying of already posted G/L Entries aborted with an error message.
NCGLA 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 NCGLA Applies-to Doc. No. field.
NCGLA 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.
