Save manual as PDF or print  


NCGLA G/L Adjustment (NAV)


Open item management for selected G/L Accounts.

Current Version: 9.01 Dynamics NAV 2018. For older NAV versions, downgrades are available.


Note

NCGLA G/L Adjustment is available for Microsoft Dynamics 365 Business Central as an extension under the product name NAVAX G/L Application. For more information, see [Docs] NAVAX G/L Application


Manual


Creation date: 2024/11/25
The current version of this manual can be found at:

https://www.navax.app/help.php?AppID=NAV_NCGLA&L=en


☰ Contents



Appendix

  • Release Notes
  • Upgrade to Business Central
    This topic is for developers and describes the steps required to transfer the data from the old C/AL version (NAV AddOn) to the new AL version (BC Extension)...

Docs  /  NCGLA G/L Adjustment (NAV)  /  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.

Note

NCGLA G/L Adjustment is available for Microsoft Dynamics 365 Business Central as an extension under the product name NCGLA G/L Application. For more information, see [Docs]NCGLA G/L Application

NCGLA Update

The following update codeunits are available: All files needed for the updates can be downloaded here: NAV_NCGLA_Update_20220526.zip

NCGLA 9.01

Dynamics NAV 2018

  • Note

    This version is also available as a downgrade version for for older Dynamics NAV versions.

    Corrections
  • In der Page Navigate konnte man nicht über das Flowfield der Detaillierten Sachposten auf die Sachpostenpage wechseln. Es kam die Feldermeldung, dass die Metadaten für die Page 0 nicht gefunden wurde.
  • Wenn in der Page der Detaillierten Sachposten auf das Buchungsdatum gefiltert wurde, stürzte der NAV Client ab.

NCGLA 9.00

Dynamics NAV 2017

    Modifications
  • Beim Ausgleich von Sachposten mit verschiedenen Buchungsdaten war es nicht möglich vom Älteren Buchungsdatum auf das Jüngere Buchungsdatum direkt auszugleichen. Das galt einerseits für Ausgleich Buchen aus den Sachposten als auch für das Buchen von Fibu.-Buch. Blättern mit Ausgleichs-ID oder Ausgleich mit Belegart und Ausgleich mit Belegnr.. Diese Funktionalität von der Kreditorenposten-/Debitorenposten-Ausgleichslogik wurde in die Sachposten-Ausgleichslogik übernommen, hat aber hier keinen Nutzen, da es nur eine Sicherheitsanpassung für die Skonto-Berechnung bei den Kreditoren- und Debitorenposten war.

NCGLA 8.00.1

Dynamics NAV 2015

    Corrections
  • In der Codeunit 12 war in der Funktion FinishPosting eine falsche Variable angegeben (GLEntry statt GlobalGLEntry). Betrifft nur die Version für NAV 2013 R2 und NAV 2015.

NCGLA 8.00

Dynamics NAV 2015

    Improvements
  • Eine Funktion für die Erstellung von Standardrollen wurde in Codeunit 1011200 zur Verfügung gestellt. Der Name der Codeunit 1011200 wurde in NCGLA Functions umbenannt.

    • Modifications
  • Bestehende Felder in Standardtabellen enthalten nun den Präfix NCGLA. Einzelne Feldnamen wurden geändert.
  • Die NCGLA Objekte enthalten nun den Präfix NCGLA. Einzelne Objektnamen wurden geändert.
  • Die User ID und die damit zusammenhängenden Felder und Variablen wurden auf 50 Stellen erweitert.

    • Corrections
  • In der Tabelle Gen. Journal line war eine Teilfunktionalität nicht enthalten. Diese wurde hinzugefügt. Betrifft nur die Version für NAV 2013.

NCGLA 7.02

Dynamics NAV 2013

    Modifications
  • Der Fehlertext bei Ausgleichsbuchungen, obwohl keine Ausgleichskonten ausgewählt worden sind, wurde geändert.
  • Aktualisierung des Status Detaillierte Sachposten im DropDown, im Block Buchen (unter Kontenplan => Konto), wenn man detaillierte Sachposten erzeugen möchte, Ja wählt, und dann das folgende Fenster es werden detaillierte Sachposten erzeugt. Möchten Sie den Vorgang fortsetzen? mit Nein bestätigt.

    • Corrections
  • Für die NAV Versionen ab NAV 2013 R2 wurde die Fehlerbehebung für die Lücke in der laufenden Nummer der Sachposten nicht als eigener Hotfix sondern unmittelbar mit dieser Version bereitsgestellt.

NCGLA 7.00.1

Dynamics NAV 2013

    Corrections
  • Hotfix nur für NAV 2013: In gewissen Konstellationen wurde eine Lücke in der laufenden Nummer der Sachposten erzeugt. In CodeUnit 12 – Gen. InI.-Post Line, PostDtIdGLEntries wurden 4 Zeilen entfernt: 
    IF GLEntryInserted THEN BEGIN
  SaveEntryNo := NextEntryNo;
  NextEntryNo := NextEntryNo + 1;
END;

NCGLA 7.00

Dynamics NAV 2013

    Modifications
  • Die Funktionalität für die Verwaltung von offenen Posten in der Finanzbuchhaltung wurde als eigenes AddOn mit dem Namen NC G/L Adjustment zur Verfügung gestellt.

Docs  /  NCGLA G/L Adjustment (NAV)  /  Appendix
Upgrade to Business Central

This topic is for developers and describes the steps required to transfer the data from the old C/AL version (NAV AddOn) to the new AL version (BC Extension).

Important

The following describes the upgrade of a solution without customizations. If customizations exist in the old solution, separate extensions must be created for the customizations.

Prerequisites for the Upgrade

  • Minimum NCGLA 8.00 Older versions of NCGLA must first be updated in NAV.

Files for the upgrade

All files needed in each step for the upgrade can be downloaded here: NCGLA_UpgradeToBC_20230607.zip

Preparation 1: Rename old tables in the NAV database

The tables of the old solution are already in the NAV database in the 1000000 object range. In order to bring the table structure of the old solution on a uniform basis and to avoid naming conflicts with the tables of the new solution, the old tables must be updated and renamed. To do this, import the NCGLA_UpgradeToBC_Step1_RenameOldTables.fob file with Replace All. The old tables are then marked with OLD_. The code, variables and functions and all TableRelations to the standard objects were also removed from the old tables.

Preparation 2: Rename old fields in the standard tables of the NAV database

The fields of the old solution are already in the standard tables of the NAV database in the 1000000 range. In order to bring the field structure of the old solution on a uniform basis and to avoid naming conflicts with the fields of the new solution, the old fields must be updated and renamed.

Important

The changed standard tables can be found in the file NCGLA_UpgradeToBC_Step2_RenameOldFields.fob. Import the objects into a separate database, which has no customizations. The objects are based on a Microsoft Dynamics 365 Business Central "Spring 2019" (Version 14.0) AT version.
After you import the objects into a separate database, the fields of the old solution (marked with OLD_NCGLA) must be copied from the separate database to the NAV database.

The following fields must be copied:
Table 15 G/L Account
  • Field No. 1011200
Table 17 G/L Entry
  • Field No. 1011200 to Field No. 1011209
Table 242 Source Code Setup
  • Field No. 1011200 to Field No. 1011101

APPLICATION UPGRADE

All steps described refer to this document: [Microsoft Docs] Business Central - Upgrading Customized C/AL Application to Microsoft Base Application Version 19. Preparations and steps 1-2 must be performed for each installation.

Task 3: Move code customizations to extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-3-move-code-customizations-to-extensions The current NCGLA G/L Application represents the target app, so there is nothing else to do in step 3.

Task 4: Create empty System, Base, and customization extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-4-create-empty-system-base-and-customization-extensions In step 4, empty apps are created, which subsequently take ownership of old C/AL tables. Use the file NAVAX Consulting GmbH_NCGLA Customization_14.0.0.app here. For each further change to the data structure of the standard application or NAVAX NCGLA G/L Application, separate upgrade apps and conversion routines must be created.

Task 5: Create table migration extension

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-5-create-table-migration-extension In Task 5 a "Table migration Extension" is created, which contains all tables of the old C/AL solution (incl. NCGLA). This is necessary so that data from the old C/AL tables can be transferred to the new AL apps (system and NCGLA). In the second version of the "Table migration Extension", a reference to the provided app "NCGLA Customization" must be added to the migration.json file: 
migration.json
{
    "apprules": [
        {
            "id": "63ca2fa4-4f03-4f2b-a480-172fef340d3f"
        },
        {
            "id": "437dbf0e-84ff-417a-965d-ed2bb9650972"
        },
        {
            "id": "32aae6c3-aefd-43e3-ba3c-359e9e93a45d"
        }
    ]
}

Task 10: Publish DestinationAppsForMigrations extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-10-publish-destinationappsformigrations-extensions In step 10, the app "NCGLA Customization 14.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCGLA Customization_14.0.0.app here.

Task 12: Install DestinationAppsForMigration and move tables

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-12-install-destinationappsformigration-and-move-tables In step 12, the "NCGLA Customization 14.0.0.0" app is installed.

Task 13: Publish final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-13-publish-final-extensions In step 13, the app "NCGLA Customization 19.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCGLA Customization_19.0.0.app here.

Task 14: Synchronize final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-14-synchronize-final-extensions In step 14, the "NCGLA Customization 19.0.0.0" app is synchronized.

Task 17: Upgrade and install final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-17-upgrade-and-install-final-extensions In step 17, the "NCGLA Customization 19.0.0.0" app is installed with the Start-NAVAppDataUpgrade command. The upgrade to BC19 can be completed, there are no other special considerations regarding NCGLA G/L Application.

After the upgrade

Once the upgrade is complete, the data from the old NCGLA G/L Application system can be prepared for transfer to the new version. For this purpose, the app "NCGLA G/L Application by NAVAX 14.0.0.0" must be installed. Use the file NAVAX Consulting GmbH_NCGLA GL Application by NAVAX_14.0.0.0.app here. This app contains only the data structure and no NCGLA G/L Application application code. After the installation, the upgrade routine can be started via the page NCGLA Upgrade, which can be found via the search. The upgrade routine only needs to be started in one company and runs automatically across all companies in the database. Please note that the date format of the client (region settings) is used when converting the date filters. The NCGLA G/L Application data is now prepared for the new version. The last step is to publish the latest version of NCGLA G/L Application and install it using the Start-NAVAppDataUpgrade command. The two apps "NCGLA Customization 14.0.0.0" and "NCGLA Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the app "NCGLA G/L Application by NAVAX 14.0.0.0".
  Save manual as PDF or print  
DE|EN Imprint