Showing posts with the label Tips & TricksShow all

How to convert Date to DateTime in Business Central [AL- VsCode]?

I have to assign a "Date" Value to a "DateTime" variable. How do I convert the "Date" to a "DateTime"? There are two ways to achieve this, Using CREATEDATETIME procedure Using EVALUATE procedure Using CREATDATETIME Procedure: Use…

Read more

RDLC Report Designer Tutorial and Basic Setup [using RDLC Report Builder] for Business Central

In this  rdlc report designer tutorial , I will discuss the basic setup for the rdlc report in  Report Builder . Microsoft Report Builder is a tool to build paginated reports used by the Microsoft reporting system. RDLC Stands for  Report Definition Language Client-Sid…

Read more

Designing table in NAV - Most important tips

Recently I wrote a change order for a client. Their requirement was to track revision with different vendors and revision include multiple fields. Also, the client provided a list of fields they want to track. The guy who gave requirements was a technical guy and he g…

Read more

Join tables in Excel | Merge table in Excel

When we work on multiple tables in excel, sometimes we need to join two tables based on some values common to both tables. There are tables with Header and Line relationships like sales header and sales line, invoice header and invoice line, we need or want to join th…

Read more

Date Format in RDLC report | RDLC report in NAV

How to convert a date into a specific date format in RDLC report?  In RDLC report when we set a date field in a report it displays either full DateTime or it shows in a different style than we desire. We could solve this kind of situation in different ways. In my ca…

Read more

How to convert .fob file into .txt file in NAV

How to convert .fob file into .txt file in Microsoft Dynamics NAV? How to change '.fob' backup file to '.txt' file or how can I view contents of a .fob file is a common question for new developer of Microsoft Dynamics NAV. When we export objects fr…

Read more

Convert Column into Row | Tips & Tricks

Converting Column into Row or Cell Converting column into row is useful many times while working with Database, CSV file or in Microsoft Dynamics NAV . We have columns of data in Excel sheet and we just want to convert a specific column into cell. In case of Micr…

Read more

How to find duplicate rows in excel

Find Duplicate rows in Excel  We use excel for different data processing and one of the major requirement is finding repeating data. We can easily remove duplicate data using remove duplicate in excel but finding unique or duplicate value is quite tricky. This list …

Read more
–>