How to resolve resolve GL inconsistency issue in MS Dynamics NAV 2017?

Procedure to resolve GL Inconsistency Issue :- 

Stpe 1. Create new Code Unit with below code.

FOB For Codeunit

Text File For Codeunit

Step 2. Add Below code in CU 12 Function Finish posting.

Step 3. After modification in code, close nav window client.

Step 4.Run CU 50099 single instance and window client will run.

Step 5.Do the activity which is causing GL Inconsistency.

Step 6.After facing issue again run CU 50099.

Step 5.It will  show the all entries that entries that are going to be insert in GL and causing inconsistency

Cumulative Update 06 for Microsoft Dynamics NAV 2017 with latest Build 16585

Hi ,

The latest update have been released for Microsoft Dynamics NAV 2017 which includes hotfixes.

According to Microsoft ,this cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

It may be necessary to update your license after implementing this hotfix.

For a list of cumulative updates released for Microsoft Dynamics NAV 2017, see released cumulative updates for Microsoft Dynamics NAV 2017. 

Link to see the overview :-

Overview of this hotfix

Direct Link To Download CU 06 For MS Dynamics NAV 2017

Direct download Link

Top Must Know facts about MS Dynamics NAV

Hi All,

This post is dedicated is to increase the skills in MS Dynamics NAV I will update this page on regular

basis.

 I hope this series will help you all NAV Developer to improve Technical and Funtional both.

1. Data Caption Property of Table 

This property you can see on all masters and transactional pages in navision.

You are viewing the Customer name and No. on top of Page using this property only.

To check this you can see the Property of Table 18 DataCaption on NAV.

2. Master Table Exception

All master table like Vendor , Customer , Item all have first field No. governed by Number Series

Only Eception is GL Account Table which is not governed by Number Series.

3. Item Tracing Page 6520

There is a page in MS Dynamics NAV with ID 6520 which provide us the details about the Serial No.

 of a Item and all its ledgers related to this particular Item.

what is Navision ?
how many version are there is Navision?
How many objects are there in Navision?
Single Instance Codeunit and its Example?
Difference between Nav 13 ,13R2,2016?
what is Fact box?
Purchase line & primary key
Set range & Set filter
tableView in navision.
Get Set in nav
Autosplit key
Pages  ,report n table
Example of Auto Split key
Web Services
Visibilty Condition to hide fields
how to transfer data from 1 table to another table.
Locktable ,Why use
powershell instance ,how its works?
set filter setrange
dataitem link ,n data item view
ILE & value Entry relation
ledger primary key
Posting Routunes purchase line to posted ship
Xml port & export to excel
Rdlc property
basis of grouping
report trigger
instaalltion type
cost cutting
runmodel & page runmodel
job queue exmple
Sum index field exmple
delayed insert property
report flow
primary n seconday key,how itx wrks
flow fields n flow filters, exmple
Soap n o data differences
find n find last, find all difference
use of dimensions
onafter get current record n on after get record
Difference between 2 tier n 3 tier
Set currrent key n Get function
internal data flow in sales n purchase
16 featurs on RTC for Clint