List of Eliminated or ObsoleteTables in NAV 2013

Table number	Table name
88	BOM Journal Template
89	BOM Journal Line
234	BOM Journal Batch
355	Ledger Entry Dimension
356	Journal Line Dimension
357	Document Dimension
358	Production Document Dimension
359	Posted Document Dimension
361	G/L Budget Dimension
389	Service Contract Dimension
473	Job Queue Response
700	BA Database
701	BA Db. Company
702	BA Db. Schedule
703	BA Db. Overview Line
704	BA Db. Numbered List
705	BA Db. Numbered List Value
706	BA Db. Dimension
707	BA Db. Dimension Relation
708	BA Db. Dimension Level
709	BA Db. Cube
710	BA Db. Cube Table Relation
711	BA Db. Cube Measure
712	BA Db. Cube Function
713	BA Db. Cube Dimension
714	BA Db. Virtual Cube
715	BA Db. Virtual Cube Member
716	BA Db. Virtual Cube Calc.
720	BA Advanced Setup
5106	Document Dimension Archive
5112	E-Mail Logging Semaphore
5113	Search Result
5114	Search Delimiter
5115	Search Detail
5116	Search Result Detail
5117	Search Word
5118	Search Word Detail
5500	Production Schedule Setup
5648	FA Allocation Dimension
6800	Employee Portal Setup
6804	EP Group
6805	EP Web Part Request
6806	EP WP Request Table Tab
6807	EP WP Request Tab Field
6809	EP WP Request Table Action
6810	EP WPR Table Edit Criteria
6811	EP WP Request Table
6813	EP WPR Table Action Filter
6815	EP WPR Header/Line Connection
6822	EP WP Request Table Sort Key
6824	EP WPR Header Create Criterion
6825	EP Temporary Filter
6827	EP WPR Field Lookup
6828	EP WPR Field Lookup Condition
6829	EP WPR Field Lookup Mapping
6832	EP WPR Table Filter Field
6833	EP WPR Table Filter Key
6835	EP SharePoint Image Path
6836	EP Search Table
6837	EP Search Field
6838	EP Search Display Field
6839	EP Search Configuration
6840	EP Group/User
6841	EP User Login
6842	EP User
6843	EP Search Result
6850	EP Caption
6870	EP Appln. Server Setup
6872	EP Trusted Site
7135	Item Budget Dimension
8000	Notification Setup
8001	Notification
8002	Notification Worksheet Batch
8003	Notification Worksheet Line
8004	Notification Line
8005	Notification Log Entry
8700	Mobile User
8701	Mobile Group
8702	Mobile Group User
8703	Mobile Document Group
8704	Mobile Document Type
8705	Mobile Document Queue
8706	Mobile Language
8707	Mobile User Windows Login
8708	Mobile Option Field Setup
8709	Mobile Option Field Caption
8710	Mobile Document Schema
8711	Mobile Document Type Schedule
8725	Mobile Sales Setup
8726	Mobile Customer Price
8727	Mobile Sales Activity
9801	Property Store
99008500	Inbound Sales Document Header
99008501	Inbound Sales Document Line
99008502	Inbound Purch. Document Header
99008503	Inbound Purchase Document Line
99008504	Inbound Product Catalog Hdr.
99008505	Inbound Product Catalog Line
99008506	Outbound Sales Document Header
99008507	Outbound Sales Document Line
99008508	Outbound Purch. Document Hdr.
99008509	Outbound Purch. Document Line
99008510	Outbound Product Catalog Line
99008511	Outbound Document
99008512	BizTalk Management Setup
99008513	BizTalk Partner Setup Header
99008514	BizTalk Partner Agreement
99008515	BizTalk Comment Line
99008516	BizTalk Partner Setup Line
99008517	BizTalk Request
99008518	BizTalk Suspended Queue
99008519	BizTalk Technical Notification
99008520	Agreement Type
99008521	BizTalk Message Check
99008522	BizTalk Doc. Receipt Check
99008532	BizTalk Partner Currency Map
99008533	BizTalk Reservation Entry
99008534	Outbound Product Catalog Hdr.
2000000002	User
2000000003	Member Of
2000000054	Windows Login
2000000061	User Menu Level

What's New in Microsoft Dynamics Reports in NAV 2015

In previous versions of Microsoft Dynamics NAV, you could only design the layout of reports by using Visual Studio

Report Designer or Microsoft SQL Server Report Builder. With Microsoft Dynamics NAV 2015, you can design

report layouts by using Microsoft Word 2013. Word report layouts are built on Word custom XML parts that 

dynamically map a report dataset into a report at runtime.

Customizing and Managing Report Layouts from the Microsoft Dynamics NAV Clients

You can customize Word and RDLC report layouts from the Microsoft Dynamics NAV Windows client and Microsoft 

Dynamics NAV Web client by using Word 2013 and SQL Server Report Builder, respectively. This enables users can

make variations of layouts, and then use the variations when viewing and printing reports as needed.

There are the  following new report functions have been added in Microsoft Dynamics NAV 2015 to support new report 

layout implementation.

SAVEASXML:                  Saves a report as an .xml file on the computer that is running Microsoft Dynamics NAV Server.

WORDXMLPART:            Returns the report data structure as structured XML that is compatible with Word Custom XML parts.

WORDLAYOUT:               Gets the Word report layout that is used on a report and returns it as a data stream.

RDLCLAYOUT:                Gets the RDLC layout that is used on a report and returns it as a data stream.

HASCUSTOMLAYOUT:    A function in codeunit 1 that determines whether a report has an active custom Word layout or RDLC layout at run time.

MERGEDOCUMENT:        A function in codeunit 1 that loads the custom Word layout that is active on report and renders it in the targeted format, such as Word, PDF.

REPORTGETCUSTOMRDLC : A function in codeunit 1 that loads the proper custom RDLC layout for a report at run time and uses the layout to render the report.

We can design the Layout in Word

Output will be shown below

How to Identify Client Type from C/AL Code

The following Microsoft Dynamics NAV clients interact with the Microsoft Dynamics NAV database through Microsoft Dynamics NAV Server:

• Microsoft Dynamics NAV Windows client
• Microsoft Dynamics NAV Web client 

If we have to differentiate development for Windows Client and Web Client then how to identify the client from 

c/AL code?

We have 2 functions available in Codeunit 419 - File Management called IsWindowsClient and IsWebClient.

How to send Documents as Email in NAV2015

 We have an option for sending attachments as email is available from Microsoft Dynamics NAV2015. 

We can see in sales invoices, sales credit memos, sales orders, sales quotes, reminders, and finance charge memos, as well as some posted documents. 

The option is available in the ribbon and called Email or Post and email depending on the context. 

It displays a dialog that lets you attach the document together with a short message and send this as email directly from Microsoft Dynamics NAV. 

In Microsoft Dynamics NAV Windows client you can decide to modify the email more in your default mail program. 

The default email sender address is based on the settings in the SMTP Mail Setup window. 

If SMTP is not configured or Outlook is not available, the .pdf file will open instead.

How to Stop Negative Inventory in NAV2013 R2

In earlier versions we have to customize NAV to achieve this but NAV2013R2 brings this feature as standard.

We can set up that outbound posting that brings inventory below zero is blocked. 

This can be set up per item or for all items. 

This setup is in the Inventory Setup, we can put a check mark in Prevent Negative Inventory field

 which specifies if you can post transactions that will bring inventory levels below zero.

The selection that you make in this field indicates the value in the Prevent Negative Inventory 

field on individual item cards. The values will either be Default (Yes) or Default (No), 

which you can change.

I know have setup this for all Items i.e., in Inventory Setup and when I try to post an Item which has

 in sufficient Inventory then I got below error.

Microsoft Dynamics NAV

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

You have insufficient quantity of Item 1000 on inventory.

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

OK

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

One or more filters are not valid and will be ignored Message in NAVISION RTC

Today I tried to run (Preview) a Report with Date Filter and I got below confirmation message

Microsoft Dynamics NAV
---------------------------
One or more filters are not valid and will be ignored. Do you want to continue?
---------------------------
No   Yes
---------------------------

Then I found that this is because of Wrong date format entered in Birth Date filter.
Date format in My system is set to DDMMYY and I entered as MMDDYY.

But this behavior is different in Classic Client (NAV2009R2).

I tried to enter same MMDDYY format in classic client Birth Date filed.

But It gives an error message as shown below
---------------------------
Microsoft Dynamics NAV Classic
---------------------------
'013150' is not a valid date.
---------------------------
OK 
---------------------------

How to Update/Modify Data in All Companies in the current database

We have Table 2000000006 – Company,which contains the list of companies exists in the database.
And also we have CHANGECOMPANY Function

Redirects references to table data from one company to another.

[Ok :=] Record.CHANGECOMPANY([CompanyName])

We can create a ProcessingOnly report to update the data in all companies using above table and function.

Ex: If I have to Update "Allow Posting From" and "Allow Posting To" field of General Ledger Setup table in all companies then:

1. Create a Processing Only report with Company as dataitem

2. write below code in Company - OnAfterGetRecord() trigger

   

GLSetup.CHANGECOMPANY(Name);

GLSetup.MODIFYALL("Allow Posting From",010213D);

GLSetup.MODIFYALL("Allow Posting To",280213D);

//You can use variables in Request Form for From Date and To Date

Here GLSetup is global variable of record type variable with General Ledger Setup table.