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

Error The Object File cannot be used with this version of the program in NAV 2013.

Hi all,

While exporting the objects in FOB format we sometime get the below error that says -

"The Object File cannot be used with this version of the program."

I got this error while trying export objects from NAV 2013 installed and trying to export the objects in FOB Format .

 it was due to some exported objects of NAV 2013 lying at the same path.

Once i removed those higher version FOB files from the location i was able to take backup on that location.

Thanks Saurav Sir for your post.

----Error---------While running the RTC from development Environment in navision 2017.

Hi All,

This is the error which have faced During run the RTC from development in 2013R2.

So, I thought To share the Solution which have done.

--------------------------

Microsoft Dynamics NAV

---------------------------

The company name must be specified if the server and instance are specified.

---------------------------

OK   

Solution:-

1. Open Tools-Option-defined the name under company.

2. Then It will show an error while run the object from development Environment. 

---------------------------

Microsoft Dynamics NAV

---------------------------

The client version does not match the server version. You can only connect to a server with a matching version.

Client version: 7.0.33781.0

Server version: 7.1.35473.0

---------------------------

OK   

3. That's a Common  issue. For this You Can follow  my previous blog's  link as below:

http://blogs.anandnavconsultant.com/2017/02/the-client-version-does-not-match.html

Hope,This information will help Someone.

Thanks for reading my blog:

http://blogs.anandnavconsultant.com

The client version does not match the server version....(Error while run the any obj from developement environment)

The client version does not match the server version....

I receive the error message when I try to run an object from the Microsoft Dynamics NAV Development Environment or activate the Debugger.

—————————
Microsoft Dynamics NAV
—————————
The client version does not match the server version. You can only connect to a server with a matching version.

Client version: {ClientVersionNumber}

Server version: {ServerVersionNumber}
—————————
OK
—————————

Solution:

To run an object you just download protocol handler n run it as administrator.

Run protocol handler As administrator:

Then do mapping after after activate or deactivate.

Then close this & again run the abject from development environment.

Now,you can run report as below:

Error while opening RTC 2017: You do not have the following permissions on CodeUnit ApplicationManagement: Execute

Error: 

You do not have the following permissions on CodeUnit ApplicationManagement?

Execute in NAV 2017?

With new installation of MS Dynamics NAV 2017, you have stuck on this Error to resolve it follow :
Open Powershell of MS Dynamics NAV 2017.

Type this command by replacing your domain ID in line 1

$objUser = New-Object System.Security.Principal.NTAccount(" ")
$strSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier])
$strSID.Value

Press Enter you will receive SID ,Please copy it.



Open your SSMS SQL Server Management Studio.
and select the DB and click on New Querry at the TOP. and Paste this Querry.
Put in your SSID and run the querry.


DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50), @USERSIDTXT varchar(50)
SELECT NEWID()
SET @USERNAME = 'YMI\VE00'
SET @USERSID = NEWID()
SET @USERSIDTXT = CONVERT(VARCHAR(50), @USERSID)
SET @WINDOWSSID = 'S-1-5-21-1840235955-2410550965-3881810730-44149'

INSERT INTO [dbo].[User]
([User Security ID],[User Name],[Full Name],[State],[Expiry Date],[Windows Security ID],[Change Password],[License Type]
,[Authentication Email],[Contact Email])

VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'','VE00@global.com')

INSERT INTO [dbo].[User Property]

([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date],
[Authentication Object ID])

VALUES

(@USERSID,'','','','','1753-01-01 00:00:00.000','')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])
VALUES
(@USERSID,'SUPER','')
GO



Now Start your NAV 2017 RTC and enjoy the stuff.

Get your Complete CODE here

$objUser = New-Object System.Security.Principal.NTAccount("YourDomain\Your ID")
$strSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier])
$strSID.Value

USE [DATABASE NAME]
DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50), @USERSIDTXT varchar(50)

SELECT NEWID()
SET @USERNAME = 'YourDomain\Your ID'
SET @USERSID = NEWID()
SET @USERSIDTXT = CONVERT(VARCHAR(50), @USERSID)
SET @WINDOWSSID = 'Your SSID'

INSERT INTO [dbo].[User]

([User Security ID],[User Name],[Full Name],[State],[Expiry Date],[Windows Security ID],[Change Password],[License Type]
,[Authentication Email])
VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'')

INSERT INTO [dbo].[User Property]
([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date],
[Authentication Object ID])

VALUES
(@USERSID,'','','','','1753-01-01 00:00:00.000','')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])

VALUES
(@USERSID,'SUPER','')
GO