Skip to content
(+40)732-833-213[email protected]
Search
FacebookLinkedin
Andrei Lungu
Nav Erp Development
Andrei Lungu
  • Home
  • Sample Projects
  • About me
  • Home
  • Sample Projects
  • About me
May282019

Multicolumn OR filter in MS Dynamics NAV / Business Central

Business Central, Microsoft Dynamics NAVBy AndreiMay 28, 2019Leave a comment

So, you need to retrieve from the database all customers with the Name = ‘John’ OR the Email = ‘[email protected]’ in order to make something with each record from the resulting dataset. In other words you need to use a Multicolumn OR filter. What is the best way to do this in NAV? Please do…

Details
Mar252019

Nav Tip: Temporary Data Item in Combination with SaveValues Property in Report – Platform Bug

Microsoft Dynamics NAVBy AndreiMarch 25, 2019Leave a comment

Context Few days ago I created a NAV Report that did some checks and processing. After this, it uses a Temporary Data Item to print values in the layout for the user to see what records are updated or have issues. Because of the complexity of the checks and processing I had to use a…

Details
Mar242019

How to Add Long Text on Last Page of RDLC Invoice Document in NAV / Business Central

Business Central, Design Patterns, Microsoft Dynamics NAVBy AndreiMarch 24, 2019Leave a comment

Context of the issue I recently needed to add a very long text (about half of page with Terms and Conditions of Sale) only on the last page of a RDLC Invoice Document (using Visual Studio Report Designer to create report documents for NAV). The last page had to contain only this text and not…

Details
Feb122019

Count the Number of Records in NAV/Business Central

Business Central, Microsoft Dynamics NAV, NAV ALBy AndreiFebruary 12, 2019Leave a comment

Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post. COUNT function can be used in NAV to find out how many records with certain filters you have in the database. Let’s take a simple example…

Details
Feb12019

Using REST Web Service to Import Json Data in Business Central

Business Central, Json, Microsoft Dynamics NAV, NAV AL, Web ServiceBy AndreiFebruary 1, 2019Leave a comment

Because I didn’t write on the blog since a long time, today I will demonstrate how you can use the AL language in Microsoft Business Central to import data exposed by a REST Web Service in JSon format. As usual, I created a practical example to demonstrate better the concepts. What REST Web Service we…

Details
12345…
67891011
12

Join my newsletter to receive new posts through email

Microsoft Dynamics NAV Blogs
Categories
  • Algorithms
  • Applications
  • Business
  • Business Central
  • C# Exercises
  • Design Patterns
  • Excel
  • Excel Formulas
  • Excel VBA
  • Finance and Accounting
  • Json
  • Microsoft Dynamics NAV
  • NAV AL
  • Powershell
  • Python Scripting
  • Sample Projects
  • Uncategorized
  • Video Tutorials
  • Web Service
  • XML

Developed by Mircea

Go to Top
316 Shares
Share316
Tweet
Pin
+1
Share