Skip to main content

Posts

How SQL Profiler can save your day by Identifying Lengthy Processes in Microsoft Dynamics NAV / Business Central

Problem Statement: While building customization for Microsoft Dynamics NAV / Business Central ERP, at times the customization is so heavy that we as developers do not realize how much load we put on the SQL Database which the backbone of the system.
One example of this situation is, I had built a system that can create a Cash Receipt during accepting Payment in terms of Cash from the Customer by temporary passing an entry through the Cash Receipt Journal. There was also a Payment Application code that applied(reconciled) the Payments and the Invoices of the Customer that ran posting of any financial entry concerning that specific Customer.
During this attempt of creating Cash Receipt, the posting would block the Customer, Customer Ledger Entries and G/L Entries Tables which was as per design. And it wouldn't allow anyone to make an entry during this period and it would take approximately 20-30 seconds.
To get out of the Deadlock, I was forced to restart the NAV Server Instance thr…
Recent posts

How Optimizing Microsoft Dynamics NAV / Business Central Can Save You From Trouble.

Problem Statement:
After my client's implementation in NAV, the system was working smooth and flawlessly. An important issue was that the client couldn't close their books due to the change in Business Processes and even the customization was evolving as per the changing Business Process. This lead to serious slowing down of the system, filtering and finding records was a pain.

When all the options ran out, we default to calling the Microsoft Support for help!
They suggested upgrading the NAV CU versions which was way painful as all the data needed to migrate and again the system would face a downtime which my client couldn't afford!!
Out of nowhere we were suggested reindexing the tables in NAV which were impacted the most as a periodic activity. Pre-requisites:Microsoft SQL Server Management Studio (SSMS)Microsoft Dynamics NAVUnderstanding of SQLUnderstanding of NAV Server Instance  Reference:https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management…

Suggest Vendor Payments feature in Payment Journal - Business Central

Introduction: In this blog, I will be attempting to highlight on Suggest Vendor Payment functionality in Payment Journals.
Pre-requisites: Microsoft Dynamics Business Central
Microsoft Dynamics NAV
Demonstration:Last Payment Date: This date is the latest date which can be appeared on Vendor Ledger Entries for making the Payment. Entries that have Due Date or Discount Date before the Last Payment Date will be included in Suggest functionality.

Find Payment Discounts: Find all the Payments which will have discounts. If this field is TRUE then Suggest Vendor Payment functionality will include Payments with Discounts as well as Payments without Discounts.
Use Vendor Priority: While making payments, if you want to prepare the entries priority wise, then you will need to set the priority of Vendor under the Payments section.


By default, the priority is set to 0.
If Vendor priority is not set which means that the Vendor Payments are to be processed in Alphabetically FCFS fashion.

Available Amount…

Exploring Microsoft Forms

Introduction: In this blog, I will be attempting to explore Microsoft Forms completely.
Pre-requisites: Microsoft Office 365
Microsoft Forms
Demonstration: 1. Navigating to Microsoft Forms Pro:

2. Template:

Templates are a ready-made format for the forms. You can make additions or deletions as per your requirement.

3. Creation of New Form:
Creation of Forms includes making a form with the respective title, description, theme, and a logo.

Adding questions to Microsoft Forms:
Adding questions can be of different types. It can also include all the validations, making questions mandatory and set-up a subtitle for the question in case more information is needed on it. Also, each question can have an image to convey the overall gist of the question.






4. Sharing Link:
Sharing a form can be a very easy task. A form can be shared through an Email, Microsoft Flow, Link Sharing and QR Code generation.

How Item Substitution In NAV / Business Central Can Ease Your Pain.

Introduction: Most of the businesses have the requirements of Item Substitution. What this means in business terms is that, if the item to be sold is not available then you can sell a different or substitute item instead of that item.
There are few conditions based upon which we can decide whether we can do item substitution or not.

Let us see and learn Item substitution in detail.
Pre-requisites: Microsoft Dynamics NAV / Business Central
Demonstration:
The use case for Item Substitution would be that a Customer wants to have a conference room Chairs & Table Set within 3 days.
The Customer likes the Product and selects it. But, generally, manufacturing & assembly takes over a week and we do not keep the Stock. We produce the set as an when needed.
Goto Items > Select Tall Tiles as the Layout.

We will be substituting Items as shown in the screenshot.

1. Setting Up Item substitution:

Goto Items > Select Item which will be substituted by some other Item
Goto Item Card > Nav…