More than 30 Points you must think before designing any RDLC Reports in MS Dynamics NAV 2017

Hi,

This post is related with RDLC Report Defination Language in C/AL so before Designing you must

know the reason why and whom and How you will create Reports in MS Dynamics NAV 2017.

So my readers will be able to resolve many problems and concepts which anyone can use in their

daily development process.

25. We can pick Year , Month and Date Difference From Posting Date in NAV.

Using 

= Year(Fields!PostingDate.Value) Further you can also use this as grouping in RDLC.

24. We can use Format in TextBox & also Use HTML in TextBox in NAV

You can use HTML Format in Reports using Textbox If you need help in it you can comment below.

23. Use Of Exit Funtion in Source Expression

You may use  Exit Function also in Data Source of DataItem of RDLC Reporting

22. PrintOnlyIfDetail

Most of you might be knowing it can be used to save unwanted dataset in Report so can be used to improve the timing issue.

21. Use Matrix Report

20. Use conversion Function in RDLC Reporting to convert Format of Expression

19. What is the use of Dataset (Fields!Expression,"Dataset Result")?

It Defines the scope of Field Expression to complete the Result.

18. Use of Function in RDLC 

Check where Code.BlankZero Defination is Given in Report in Report Properties.

17. We can also use Date Function in RDLC Reports

16. We can use year for Grouping in RDLC Reports

15. INLine IF (IIF) and Switch Case can be used in expression of Row and textboxes

14. We can change Expression of Text Box on Behalf of conditions

13. Filling row with color even odd as per requirement.

You can use it in visibility expression

=Iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")

You can change the Color of BackGround on Behalf of grouping in MS Dynamics NAV.

12. We can insert Row No. in Table using inbuilt function ROWNUBER in RDLC

11. We can repeat header in RDLC Report on every page using static property

10. We can use top n property present in Filters of tablix property to calculate top N customer Item Vendor Report.

9. You can put images in MS Dynamics NAV Report and according to conditions.

8. You can Dynamically break a Tablix and remove last Line from tablix easily using RowNumber Inbuilt Function in RDLC.

=Int((RowNumber(Nothing)-1)/25) 

So these are the points which are possible in MS Dynamics NAV if any any of the above point you need practical session you can comment me or directly message me from my blog I will update you with my blog.

Thanks to all my readers.

Happy Independence Day 2017 to all Indians.

How to use Update Propagation Property in NAV

Hi,

This post is bridge between a blog which I liked the most to describe the functionality of MS

Dynamics NAV from 2015 version.

What is Updatepropagation property in MS Dynamics NAV?

To reduce the customization in the page of MS Dynamics NAV we can use this property , you will 

find this property on Sub Page as shown below in screen.

With the use of this property you dont need to use Currpage.Update on various triggers.

Where we can use this property?

This property is majorly used while calculating Lines Column in document on Header for eg.

Sales Header .

TO view about this in practical you can go to this Link.

Details about Update Propagation Property from NAV 2015 Onwards

How to use email Item Record Table and Mail Management Codeunit

Hi All,

Thanks to Saurabh Sir for provoking me to write this blog. I thanks him for providing new

information as much as possible. I had followed his blog and re - writing this blog with variables and

screenshots which were not available there. So it will be better to understand few consultants like me

slow learner.

To go directly to Link click here Saurav Dhyani

I had applied the same solution you can view the screenshot and download my solution from Here

Download Codeunit 50000

Download Report 50000

Download Page 22 Customer List

Remove the objects present already on these ids and before importing these objects.

This report is using the concept of Open Field present on Customer Ledger Entries and calculating

the sum of amounts in navision RDLC Reports.

Codeunit is using TempBlob Record Table also to customize the requirement.

How To Setup VAT Value Added Tax in MS Dynamics NAV 2017 ?

Dear All,

As we Know GCC countries are soon going to implement VAT Taxation System in their countries so

I just want to share some important steps for you all.

This is a summarised step and I hope it will help you out all for successful implementation and

upgrade your system to access VAT in MS Dynamics NAV 2017.

What is VAT Value Added TAX?

The Esteem Included Expense, or VAT, in the European Union is a general, comprehensively 

construct utilization impose surveyed with respect to the esteem added to merchandise and ventures.

 It applies pretty much to all products and enterprises that are purchased and sold for utilize or 

utilization in the European Union. Subsequently, merchandise which are sold for fare or 

administrations which are sold to clients abroad are regularly not subject to VAT. Then again imports 

are saddled to keep the framework reasonable for EU makers so they can contend on square with 

terms on the European market with providers arranged outside the Union. 

Esteem included duty is 

a general duty that applies, on a fundamental level, to all business exercises including the generation 

and dissemination of products and the arrangement of administrations. Be that as it may, if the yearly 

turnover of this individual is not as much as a specific point of confinement (the limit), which 

contrasts as per the Part Express, the individual does not need to charge VAT on their deals.

How to Setup VAT in MS Dynamics NAV 2017 ?

Step 1.

Create a new vendor.

Define gen. bus. posting group, VAT BUSINESS Posting Groups For Customer And Vendor

and Vendor Posting Group.

Step 2.

Create an item,Gen. Product Posting Group,Vat Product Posting Group,Inventory Posting Group.

Step 3.

Create Purchase Invoice and now Setup VAT Posting Setup,

Create new Code and define VAT & Percentage define Accounts also for sales and purchase.

Step 4.

Create a customer and define

Gen. Bus Posting Grp

VAT Bus. Posting Grp

Customer Posting Group

 Step 5.

Create a sales Invoice and post the invoice.

Step 6.

Check for VAT Entries.

Step 7.

Now check for Reporting VAT

You have to search for VAT Statement in search bar.

Create a new statement

EDIIT VAT Statement

Row No.

Setup For Sales And Purchase VAT Statement here

Now run this batch report to settle VAT amount in Chart of Accounts.

Report Name

Calc. and Post VAT Settlement

No Start Date

Enter Ending Date

Posting Date

Provide a document No.

Provide a Settlement No.

Run this report.

Step 8.

Check VAT Entries.

Types of Tables in Microsoft Dynamics Navision 2017

Summary of Tables in MS Dynamics NAV 2017

Hi,
These are the tables that are used in MS Dynamics NAV. It is a summary of the post for all tables present in MS Dynamics NAV. You will learn about these and hope you will enjoy too.

What are tables?

Tables are the collection of records and it is the heart of any database because it contains all the 

values and data for further manipulation of records.

To implement any solution you first need to learn how to store the data in an accurate way. So to get 

the logical output you must check this blog for bettter understanding.

1. Master Tables

2. Journal Tables

3. Document Tables

4. Document History Tables

5. Setup Tables

6. Supplemental Tables

7. Subsidiary Tables

8. Ledger Tables

9. Register Tables

Grouping In Export To Excel Report Without Layout in MS Dynamics NAV 2017

Grouping In Report with Code in A/L

Hi All,

Today I Got a Requirement for Excel Buffer Report in Navision and with Grouping of Location 

Code in Item Ledger Entry.

Typically it was tough requirement , but thanks to MS Dynamics Community and Saurabh Dhyani Sir

for his valuable time which shared a most important thing and rarest blog of Navision.

Direct Link For Grouping of Reports via Coding in MS Dynamics NAV

I had used the same method  in MS Dynamics NAV 2017. I am Sharing my FOB with you all to 

download and understand the issue better.

Download by clicking the Here..

Useful Points about this Report

1. We can use grouping via C/AL Code.

2. We can arrange the Function via boolean Field.

3. Use of Exit Function in MS Dynamics NAV.

How to do dynamic implementation of decimal place in RDLC Reports?

Dear All,

Today  I had requirement from report in RDLC to implement dynamics Decimal Places. Initially it was to realise but I followed report 206 and once again I got my solution done soon.

For those who still not understand check the red screen there we have dynamic decimal place Value.

Solution :-

To implement this we have to use custom decimal formatting in RDLC reports and in that we had to define Format Value.

For Reference see the screen Shot.

This post also explain to juniors when you need to use Format Value in RDLC Reporting.

Thanks for your time to read my blog post.

How NAV Calculate Unit cost of items in NAV?

How to Calculate Unit cost in Reports of NAV?

Using the below code MS Dynamics NAV Calculates Unit Cost in Report of 746.

ItemRec.RESET;

ItemRec.SETRANGE(ItemRec."No.","No.");

ItemRec.SETFILTER(ItemRec."Date Filter",'%1..%2',0D,CALCDATE('-1D',SDate));

IF ItemRec.FINDFIRST THEN;

ItemCostMgt.CalculateAverageCost(ItemRec,AverageCost,AverageCostACY);

AverageCost := ROUND(AverageCost,GLSetup."Unit-Amount Rounding Precision");

How to Select Boolean Field from page in Nav 2017?

Hi All,

This is code which works very dynamic in selection of boolean field.

We have to create a boolean field in the desired table.

Upgrading from NAV 4.0, NAV 5.0, NAV 2009 SP1, NAV 2009 R2 to NAV 2017

Download Upgrade document For MS Dynamics NAV

If we are upgrading from one of these below versions then

• Microsoft Dynamics NAV 2009 SP1
• 
  
• Microsoft Dynamics NAV 2009 R2
• 
  
• Microsoft Dynamics NAV 5.0
• 
  
• Microsoft Dynamics NAV 4.0

Use the following links given below to upgrade to NAV 2013 first & then follow the above steps to

 upgrade to NAV 2017:

1. NAV 2013 Upgrade Part I - TextFormatUpgrade2013 Tool

https://saurav-nav.blogspot.in/2012/11/nav-2013-upgrade-part-i.html

2. NAV 2013 Upgrade Part II - Upgrading the Standard Objects

https://saurav-nav.blogspot.in/2012/11/nav-2013-upgrade-part-ii-upgrading.html

3. NAV 2013 Upgrade Part III - Data Upgrading

https://saurav-nav.blogspot.in/2012/12/nav-2013-upgrade-part-iii-data-upgrading.html

4. NAV 2013 Upgrade Part IV - SQL Migration

https://saurav-nav.blogspot.in/2012/12/nav-2013-upgrade-part-iv-sql-migration.html

**Another useful link for SQL Migration:

https://saurav-nav.blogspot.in/2014/09/how-to-restore-native-backup-to-sql.html

Workflow status Field on journals in NAV 2017.

Hi All,

This was one of my finding which I had done on implementation of Approval status Field in MS 

Dynamics NAV 2017.

In all journals we have workflow but we cant find out which lines are sent for approval nd which are 

approved or rejected.

To get this functionality developed I had put this code on Validate trigger of Status Field in NAV 

table ID 454 Approval Entry.

I had added Field on NAV Table 81 which changing its value acording to the status field on this table.

I hope this post will help many of the NAV developers I am also attaching the FOB in the Post below.

Download the Fob Now

Summary of Pages Article provided by Microsoft

This post is related to the summary I followed from article provided by Microsoft. You can Download the complete article from here.

Microsoft Link for PDF

Note 1 :-

Expression properties let you easily control the same behavior of several controls at the same time. By binding the same property, such as Visible, to the

same Boolean variable, you can toggle visibility of multiple controls from a single line of code. Do not forget to set the IncludeInDataset variable property to Yes.

Note 2 :-

Note 3 :-

You can define both the OnAction trigger and the RunObject property.If you define both, the client runs both the object that is defined in the RunObject

property, and the C/AL code that is defined in the OnAction trigger.

Note 4 :-

Linking Pages and Page Parts

SubPageView Sets a specific table view that is applied to the page part.You can choose the key, the sorting order, and the table filter that are applied to the page part.

SubPageLink Sets up a link between the main page, and the page part. The link lets you filter the page part by field values on the main page, and to apply additional page filters.

NAV Tech Days 2017

16 & 17 november 2017, Antwerp (Belgium)

Welcome to one of the most awaited event for Nav. You can register from below link.

https://www.navtechdays.com/2017/register

Few mentioned events and hints about this Tech days

Pre-conference workshops

Making Visual Studio Code in MS Dynamcis NAV 2017,Dynamics NAV with Power BI, Extensions with VS Code to implement in real transactions. 

Event Sessions
– Building dedicated Mobile Experiences
– SaaSification guidelines
– Deep dive into the new development tools

Some Important Links
About
https://www.navtechdays.com/2017/about

Sessions

https://www.navtechdays.com/2017/sessions

Speakers

https://www.navtechdays.com/2017/speakers

Stay tuned !

@NAVTechDays

Some imporant points Summary Post 2 Tables from

Hi,

You can have a look for Tables in MS Dynamics NAV from the below link. I am summarising the

concept below. If you like then do comment and subscribe to my blog post.

Tables by microsoft.

Note 1.

RECORDID Datatype :- It Stores RECORD ID and Primary key values.

Note 2.

ExtendedDataType property

When you select the Phone No. field without closing the No. -

Property window, notice that now the Phone No. – Property window is shown.

By selecting a value in the ExtendedDataType property, you will change the layout

and behavior of controls on a page. Use the value to add an icon next to an input

field to indicate whether the field relates to a phone number, email address, or URL.

Note 3.

Why we use Field Groups in Navision?

Note: If you do not define any Field Groups for the drop-down control, by

default, you will only see data from two fields in the source table: the primary key

and description fields, because these are indexed automatically.

Note 4.

Up to 40 keys can be associated to a table, and the first on the list is the primary

key. All other keys are secondary keys and optional.

The primary key is composed of up to 20 fields in a record. The combination of

values in fields in the primary key makes it possible for Microsoft SQL Server to

perform a unique identification of each record. The primary key determines the

logical order in which records are stored, regardless of their physical placement on

a disk.

Secondary keys are used to view records in an order that differs from the one in

which they are sorted, according to the primary key fields.

Note 5.

Note: The field ID that is specified in the TableRelation property must be in

the primary key of the table that is specified by the table ID in the property. If the

specified field is not the first field in the primary key, the other fields that are listed

before it in the key must be filtered to one value.

Note 6.

7 types of flowfields Sum, Average,Lookup,Exist,Min, Max,Count

Note 7.

SumIndexFields

A SumIndexField is a decimal field that can be attached to a key definition. This is

the fundamental feature of the Microsoft Dynamics NAV that constructs the basis

for FlowFields. SumIndexFields enable fast calculation of numeric columns in

tables,

Note 8.
Each key can have at most 20 SumIndexFields. During database design, a decimal field can

be associated with a key as a SumIndexField.

The type of SumIndexField must be numeric (Decimal, BigInteger, Integer or Duration).

How to print a next line in RDLC report using AL Code in MS Dynamics Navision?

There is requirement from my client to add all dimensions in RDLC layout with next line to be printed with new line. So I had to handle all things using Cal code.

Procedure :-

Define 2 CHAR variables.

Initialise these 2 variables.

Assign with format in CAL and add this copy dimension in dataitem and put it in RDLC layout your result will be shown as follows

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

How to integrate OneNote in MS Dynamics NAV 2017?

Hi All,

Today I am giving you a solution to implement MS Dynamics NAV 2017 with OneNote. It was a requirement from one of my client so to implement I had taken help from other blogs you can check them here.

Saurabh Dhyani Sir Link.

olofsimren Link

MSDN Link

Dynamcis Community Blog

I followed he same Solution and here I am summarising all steps I hope it will be a help to my NAV Community as far.

Open the Profiles Page from Search Bar.

Now Select the Option present on Jobs Card Page You may look for another pages also.

Thanks for you time.

Why we should use BEGIN END in our conditional Looping

This post is related to my one mistake so I just want to share it with all. This post will help my 

readers to understand how the conditional statement works in Navision and what is the impact of 

BEGIN END on all the Conditions.

For this I am using two scenarios of Code as shown in screenshot.

Image 1

Image 2

Image 3

Now in all the screen if you run the debugger it will show you the real facts.

Screen 1 and 3 are same in both the scenarios and working.

it will check all the three conditions.

Screen 2 is showing difference that whenever the IF condition before Begin is checked then either the

 whole code will be run else whole code will not be run by AL.

I hope it will be helpful to all developers of NAVISION. If you like my post then please share and 

comment.

FORMAT Date in NAV 2017

How to Format Date in MS Dynamics NAV 2017 using C/AL Code?

We generally use Format for two reasons in MS Dynamics NAV :-

1. To convert Integer Type Data in String Format.

FORMAT(Integer Type DATA);

2. To Format Date Type Variable in Navision to convert it into desired date Form.

FORMAT(TODAY,0,4)

Today I got a requirement from my client to change the Indian Date format in DDMMYYYY only

for Example 02052017. So to get this done I had used these formulas and format available in Navision.

For Dates, the Regional and Language Options in Windows is used to select the actual format that is used. The table below shows the Fields that will be used to build the various formats. This table, incidentally, corresponds to the Regional setting for a European country/region.
Date	Format	Example
<Closing><Day,2>-<Month,2>-<Year>	0	05-04-03
<Closing><Day,2>-<Month,2>-<Year>	1	05-04-03
<Day,2><Month,2><Year><Closing>D	2	050403D
<Closing><Year>-<Month,2>-<Day,2>	3	03-04-05
<Closing><Day>. <Month Text> <Year4>	4	5. April 2003
<Closing><Day,2><Month,2><Year>	5	050403
<Closing><Year><Month,2><Day,2>	6	030405
<Day,2><Filler Character, >. <Month Text,3> <Year4>	7	5. Apr 2003
XML format	9	2003-04-05
The following table shows how these formats will change if the Regional and Language Options is set to "United States."
US Date	Format	Example
<Closing><Month,2>/<Day,2>/<Year>	0	04/05/03
<Closing><Month,2>/<Day,2>/<Year>	1	04/05/03
<Month,2><Day,2><Year><Closing>D	2	040503D
<Closing><Year>/<Month,2>/<Day,2>	3	03/04/05
<Month Text> <Closing><Day>, <Year4>	4	April 5, 2003
<Closing><Month,2><Day,2><Year>	5	040503
<Closing><Year><Month,2><Day,2>	6	030405
<Day,2><Filler Character, >. <Month Text,3> <Year4>	7	5. Apr 2003

I hope this post will help in major development of NAVISION.

For more information kindly refer to :-

Format Date Suggestion on Dynamics User

 

7 Doubts You Should Clarify About Multiple Language Solution In NAV

Is your Solution MULTI Language Acceptable?

Hi All,

This post is about  providing your solution of Nav to be implemented in multi langauages.

While creating reports in NAV we have many a times used Hard Code Error  which resolves solutions but the long term impact of such cases I want to share with my readers.

So the summarise post is below :- 

How to achieve Multi Language Implementation Solution?

We must provide every error , message , confirmation in TEXT CONSTANT and we must provide another language in Caption ML Property of NAV.

More about property is Here.

Where we must use it?

1. Object Name

2. Function Name

3. Function Variable

4.Option Type 

5.Control Names.

 Comment,CAPTIONML,OPTIONML,Instruction,Instruction Tool ML.

Rules :-

Always use text constants and avoid hard code while defining ERROR,MESSAGE,CONFIRM,STRMENU,OPTION,DATEFORMULA

Alway try to use FIELDCAPTION,TABLECAPTION,STRSUBSTNO to retrieve caption values for comparing object names.

Thanks.

Please subscribe our post and follow us below to getmore valuable updates to develop MS Dynamics NAV Solutions.