• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Business Central
  • Dynamics NAV
    • NAV 2018
    • NAV 2017
    • NAV 2016
    • NAV 2013
  • Others
    • About
    • Privacy Policy
    • Disclaimer
    • Contact Us

Navision Planet

This Blog is intended to help Microsoft Dynamics NAV / Business Central ERP developers as well as users. If you just go through these blogs you will understand what I have told is correct. The Blog will continuously get update with latest news. This Blog is handled by a group of Microsoft Certified Partners as well as Business Solution Specialists in Microsoft Dynamics NAV and Dynamics 365 Business Central. Feel free to mail us for any doubts.

  • LS Retail
  • Help Topics
    • Finance Module
    • Manufacturing Module
    • Warehouse Module
    • Administration
  • Navision Developer
  • GST
  • D365 Business Central
  • CU Update
    • Download Business Central

INCONSISTENCY ERROR IN NAVISION

INCONSISTENCY Error in Navision Occur because of the following reason.

Posting invoices writes to the G/L entries and the total must ALWAYS be 0.
Somewhere an amount is written but it has no opposite to make the total 0.
This means that there is a problem with some customization of the code.

This is a trick I use whenever I do try to solve and see why you the db is getting CONSISTENT Error.
I create the following CU.

OBJECT Codeunit 50000 Single Instance CU
{
OBJECT-PROPERTIES
{
Date=10/11/07;
Time=[ 2:50:02 PM];
Modified=Yes;
Version List=MOD01;
}
PROPERTIES
{
SingleInstance=Yes;
OnRun=BEGIN
IF NOT StoreToTemp THEN BEGIN
StoreToTemp := TRUE;
END ELSE
FORM.RUNMODAL(0,TempGLEntry);
END;

}
CODE
{
VAR
TempGLEntry@1000000000 : TEMPORARY Record 17;
StoreToTemp@1000000001 : Boolean;

PROCEDURE InsertGL@1000000000(GLEntry@1000000000 : Record 17);
BEGIN
IF StoreToTemp THEN BEGIN
TempGLEntry := GLEntry;
IF NOT TempGLEntry.INSERT THEN BEGIN
TempGLEntry.DELETEALL;
TempGLEntry.INSERT;
END;
END;
END;

BEGIN
END.
}
}

And in CU 12 I add the following Code in function FinishCodeunit

FinishCodeunit()
WITH GenJnlLine DO BEGIN
IF GLEntryTmp.FIND(‘-‘) THEN BEGIN
REPEAT
GLEntry := GLEntryTmp;
IF GLSetup.”Additional Reporting Currency” = ” THEN BEGIN
GLEntry.”Additional-Currency Amount” := 0;
GLEntry.”Add.-Currency Debit Amount” := 0;
GLEntry.”Add.-Currency Credit Amount” := 0;
END;
GLEntry.INSERT;
//MOD01 Start
SingleCU.InsertGL(GLEntry);
//MOD01 End
IF NOT InsertFAAllocDim(GLEntry.”Entry No.”) THEN

Once you’ve made the changes. You run the SinleInstanceCU Once.
Then do what ever you do to get the consistency error.
Then Run the SingleInstanceCU again.
You’ll see a list of GL lines. You will see why the transaction is not balanced.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Subscribe

  • Email
  • Facebook
  • Twitter

Our Topics

Administration Analysis Reports Business Central Developer Toolkit Docker Dynamics NAV Beta Download Dynamics NAV Release Error Message Finance Module GST Human Resource Login Error LS Retail LS Retail 2013 Manufacturing Module Microsoft Certified Trainers (MCTs) Microsoft Dynamics Business Central Microsoft Dynamics NAV 2009 Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2015 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2018 MSDyn365BC NAV 2016 Navision Certification Navision Developer Navision Introduction Navision Modules Navision Retail Navision Tips And Tricks Powershell Purchase Order Sales Module SQL Server Useful Sites Visual Studio Code Warehouse Module

Footer

Recent Post

  • Business Central Complete Version List and Direct Download
  • You do not have access to Microsoft Dynamics NAV or D 365 Business Central Error
  • Dynamics NAV Versions List

Search

Contact : support@navisionplanet.com for Microsoft Dynamics NAV (Navision ) and LS Retail Development or Functional support for any modules

 

Editors News Letter


New Microsoft Dynamics NAV Technical Blog opened the Navision Planet Team

MIBUTECH

https://www.mibutech.blogspot.com

Copyright © 2023 Navision Planet