NAVISION - Common Errors & It's Solution

Error's & it's solution:

#1 Error

G/L inconsistency error in nav 2013,2015,2016

single instance codeunit in navision

This error occurs when (Debit Amount and Credit Amount) or (Add.-Currency Debit Amount or Add.-Currency Credit Amount) does not match.mostly because of rounding issue. 

Solution:

Download the below object Codeunit 50099 and modify Codeunit 12 .

Object Download

when you hit the G/L inconsistancy error . Press Ok and Run Codeunit 50099.








#X Error

Solution:

This message is for C/AL programmers:

The call to member SaveAs failed. Microsoft Excel returned the following message:

SaveAs method of Workbook class failed

Solution:
Create Desktop Folder in  the below path
·Windows 2008 Server x64 (64 bit)

  C:\Windows\SysWOW64\config\systemprofile\Desktop
·Windows 2008 Server x86 (32 bit)
  C:\Windows\System32\config\systemprofile\Desktop

#2 Error

You cannot print in a report where the property 'ProcessingOnly' is set to 'Yes'.

Solution:

Delete All the sections.

#3 Error
This message is for C/AL programmers:
This Automation variable has not been instantiated.
You can instantiate it by either creating or assigning it.
Solution:

Pass the Parameter TRUE in below function

IF NOT CREATE(XlsApp,TRUE) THEN;

#4 Error

The following SQL Server error or errors occurred when accessing the Item Ledger Entry table:15336,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Object '"GP_NAV_PROD_TEST_HRMS_20160210"."dbo"."Cronus$Item Ledger Entry"' cannot be renamed because the object participates in enforced dependencies.

SQL:
{CALL [sp_rename](?, ?, ?)}
#3 Error

Take Object backup (Export the Table Item ledger entry)
Open the mentioned table object in Object Designer and disable SIFT Maintence flags
Save and compile the object
In SSMS open the Views section for the database and delete any views that remain for this table
Re-import the original NAV Table Item ledger entry

#3 Error
Create a new company
Solution:
EG: NAV 2015

Open Microsoft Dynamics NAV 2015 Administration Shell as Administrator
execute the below command
New-NAVCompany -CompanyName "DEMO" -ServerInstance DynamicsNAV80 -Confirm