How to export data using TextBuilder in Business central.
Apr18

How to export data using TextBuilder in Business central.

Today we will see how we can data from business central table using new data type Text Builder. To check how this data type work build small program as below which pick up data from customer table and export the data in text file. pageextension 50101 CustomerMasterExtension extends “Customer List” { actions { addlast(General) { action(DataExport) … Continue Reading Ammolh Saallvi’s Article on their blog How to...

Read More
How to change Customer Name on Open Sales Order in business central
Apr12

How to change Customer Name on Open Sales Order in business central

With the release business central Wave 1 2022 lot of new features has been added to improve the user interaction with application. This feature is small improvements in business central which allows to changes the name of customer on open sales document. This change of name will be applicable for that document only. This change of name is controlled by setup on sales & receivables… Continue Reading Ammolh Saallvi’s...

Read More
How to define multiple layouts for report in Business Central
Apr04

How to define multiple layouts for report in Business Central

With the release of business central V20 lot of new features are introduced and one of the features in you can define multiple layouts for reports while developing In earlier days we are defining multiple layouts as below. Now with the new release new rendering section is added while creating report in AL development In the above rendering section we can define multiple… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Business Central Wave 1 2022 Released
Apr02

Business Central Wave 1 2022 Released

With the new dawn of 1st April Microsoft released Business Central Wave 1 2022. The product DVD will be downloaded from following URL Business Central Wave 1 2022 Few features of Business Central you can visit this link Business Central Wave 2 2022 Features Stay tuned for more detail. Continue Reading Ammolh Saallvi’s Article on their blog Business Central Wave 1 2022 Released With the new dawn of 1st April Microsoft released...

Read More
Preview Environment for Business Central 2022 Wave 1 (BC20)
Mar11

Preview Environment for Business Central 2022 Wave 1 (BC20)

So with new year major version of business central is about to release and in context of that Microsoft released preview version of business central 2022 Wave 1 (BC 20). This preview version only possible to create for Sandbox and non production environment. How to get this preview environment to get the hands on the new release On the cloud version of business central one can… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to change primary key in Business Central Table
Feb02

How to change primary key in Business Central Table

Recently one of my customer asked me to add few more fields on primary key and I was looking at the customer like he asked something which is daunting task to be done with business central as everybody aware of that we can not change the primary key fields when table is already having data as while deploying the app it throws an error as below Even I tried using Force sync also but… Continue Reading Ammolh Saallvi’s...

Read More
What is planned for Business Central Wave 2 2022 release
Jan26

What is planned for Business Central Wave 2 2022 release

As we are gearing up for new release of business central and already the buzz is started for new version . Here I will list few upcoming features which I am looking forward in new version. In-Client Performance Profiler Demo tool and demo data for manufacturing scenarios Users can export report datasets to XML Introduce copy link option in the Share menu Guided tour that… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Business Central and Fonts on Reports
Nov02

Business Central and Fonts on Reports

Today morning there was issue raised by my consultant stating that text on business central reports showing weird characters as below. Though these reports was working well on On-Premise but after uploading to cloud it started showing those weird characters. After checking report layout found that using the same fonts which is available on cloud version of business central… Continue Reading Ammolh Saallvi’s Article on...

Read More
What’s New in Business Central Wave 2 2021
Oct19

What’s New in Business Central Wave 2 2021

Do you remember this post of mine where in I mention Microsoft hosting an event for launch of Business Central Wave 2 2021. Yesterday this event gone live and all the recordings are available to view till 31st December 2021.As like the most event this event is not live and all sessions are recorded and there will be no chat room or live Q & A sessions. You can view the session by… Continue Reading Ammolh Saallvi’s...

Read More
Microsoft Business central Event 2021 Wave 2
Oct15

Microsoft Business central Event 2021 Wave 2

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. If you are looking more insight for those features then Microsoft will host an event on 18th October 2021 You can join this session by registering it here. Join the Event This event will have following on agenda Make sure to… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
App Installation Permission Denied in Business Central
Oct14

App Installation Permission Denied in Business Central

Yesterday we were installing PTE app on production environment and it throw an error as below. We are juggled by seeing this message and thinking why it is showing an error message when we are uploading extension by using administrator login which is global administrator. To overcome this error there is new permission set has been introduced in business central wave 1 2021… Continue Reading Ammolh Saallvi’s Article on...

Read More
Business Central allows to change App Name Publisher of app.
Oct13

Business Central allows to change App Name Publisher of app.

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. Can we change App name and/ or publisher name to meet marketing branding ? If you ask me till V18 it was not possible to change that and in V19 it is possible. Lets see how it works. Here is my app.json file Publish the app

Read More
Address Control in Business Central.
Oct11

Address Control in Business Central.

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. There is new feature added in business central to control address where country/region code is used. New option added on general ledger setup to control country/region code that means if this field is checked and if user change the… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to use Excel to update data in Business Central.
Oct07

How to use Excel to update data in Business Central.

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. Now days if you interacting with customer users sometimes customer want to update data from excel to the application directly. This situation occurs when customer have different resource to update the master data and those people actually… Continue Reading Ammolh Saallvi’s Article...

Read More
How to gain more control on setup while posting transaction in business central.
Oct06

How to gain more control on setup while posting transaction in business central.

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. One of the important areas in business central is posting group which connect different module with finance management and user can see required values in chart of account after posting the transaction in actual time. Sometime it happens user… Continue Reading Ammolh Saallvi’s...

Read More
How to get insights for Error Message in business central
Oct05

How to get insights for Error Message in business central

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. Whenever there is an error from application and if we need to have help from partner or MS then we need to have detailed information about that error and prior to BC V19 we need to collect those information from different sources. In BC V19 now… Continue Reading Ammolh...

Read More
How to Force Sync extension of customer specific environment in business central
Oct04

How to Force Sync extension of customer specific environment in business central

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers. Till business central version V18 we are mentioning schemaUpdateMode in launch.json to specify how the data in app should behave when extension is published. In this property we were mentioning ForceSyncRecreateSynchronize (This is… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to allow your app to debug in business central
Oct03

How to allow your app to debug in business central

With the release of Business Central Wave 2 2021 aka BCV19 new version of AL language is also published. Do you remember this post where in I explain the use of showmycode property from app.json file. With this property we have only one option either we allowed to debug and download your app or vice versa. Now with new version of AL language this property has been deprecated and new… Continue Reading Ammolh Saallvi’s...

Read More
Microsoft Business Central 2021 Wave 2 released
Oct02

Microsoft Business Central 2021 Wave 2 released

Microsoft releases business central 2021 Wave 2 (BC 19) on 1st October 2021 . This version is available on CloudOn DockerOn Premise To check I tried to create new sandbox on cloud environment and it is readily available on my region too,. Apart from this to get more detail and understanding on new version Microsoft already scheduled a launch event with breakout session… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to modify table data in business central
Sep29

How to modify table data in business central

This week one of the customer post few transaction and found that one of the field user enter some wrong information. In ideal situation user need to reverse the transaction and post correct transaction which is safest approach. But do you remember those old days where we have access to the table and can modify the data but with business central this ability no more available . I just… Continue Reading Ammolh Saallvi’s...

Read More
How to Post Transactions using Configuration Package in business central
Sep19

How to Post Transactions using Configuration Package in business central

Two days back one of the customer asked me is there any way that I can post sales transactions using configuration package and I said yes it is possible to do that by using processing rules in configuration package. Today’s blog post will explain how it is possible. In this blog post we will see how we can post sales transaction using configuration package. Step 1:- Create configuration… Continue Reading Ammolh...

Read More
How to Extend Preview Posting in business central
Sep17

How to Extend Preview Posting in business central

Do you know one of the great feature provided by Navision called as Preview posting. When posting journals or documents with a large number of entries, accountants want to make sure that the posting will be correct beforehand. Previewing the posting helps prevent the need for corrections, making accountants more productive. In upcoming version of Business Central Wave 2 2021 preview… Continue Reading Ammolh Saallvi’s...

Read More
How to Setup default document line type for Sales transaction in business central
Sep16

How to Setup default document line type for Sales transaction in business central

This is one of new feature going to be in October release of Business central. On Sales transaction user need to select the line type such as Item, G/L Account ,Fixed asset etc. but sometime users says can we have default type as Item on every new sales orders rather than selection . With upcoming business central version it is possible to set default line type as setup. Go to… Continue Reading Ammolh Saallvi’s Article on...

Read More
Business Central Wave 2 2021 Preview available
Sep08

Business Central Wave 2 2021 Preview available

The preview of Business Central 2021 Wave 2 (release 19) was released It is only possible to create Sandbox preview and non-production environments; the preview environments are for demonstration purposes only and to have their functionality tested, they are removed at most thirty days after the official release of the product. Now lets get ready to explore new… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
What is planned for Business Central Wave 2 2021 release
Aug24

What is planned for Business Central Wave 2 2021 release

As we are gearing up for new release of business central and already the buzz is started for new version . Here I will list few upcoming features which I am looking forward in new version. Following features I am looking forward. Richer access control for extension source in cloud environments Add additional columns through personalization in various pages to gain more insight

Read More
How to execute mathematical function in business central
Jul12

How to execute mathematical function in business central

Are you looking for for running some mathematical function in business central then may be this blog post is interesting for you. In business central new system code unit is provided to execute some important mathematical function. Build one simple page to show few expressions as below One can determine following values from this codeunit. MethodRemarksPiReturns… Continue Reading Ammolh Saallvi’s Article on their blog How...

Read More
How to add keys in Base table of Business Central
Apr25

How to add keys in Base table of Business Central

With the release of Wave 1 2021 lot of new feature introduced . One of the new feature is that partners now can add keys in base table with customized field which was not possible earlier Today we will see how we can do that First Lets see what is happening is earlier version of business central. In earlier version we can only add the keys with the field added on table… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Microsoft Dynamics 365 Business Central 2021 Virtual Event
Mar14

Microsoft Dynamics 365 Business Central 2021 Virtual Event

Get Ready for yet another virtual launch of business central Wave 1 2021 and it is streamed on 13th April 2021 This will a free virtual event for everyone from reselling partners, consultants, and ISV partners. You can join from following link https://events1.social27.com/msdyn365bclaunchevent2021w1/auth/register Lets drive more deep in Business central with this event and… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to restore environment in business central
Feb15

How to restore environment in business central

Have you guys remember my tweet regarding the restoration of environment .Following is the tweet If you still not follow me on then please follow me on twitter for more updates So in month of November 2020 I faced this problem as due to some issue production environment got hanged and user abruptly close the session .Post that data in some tables got messy and couldn’t recover… Continue Reading Ammolh Saallvi’s...

Read More
Upcoming New Features with Business Central
Jan31

Upcoming New Features with Business Central

Recently Microsoft releases plan for major version of Microsoft Dynamics 365. This blog post actually focused on those features which I am looking forward to and may be every one in community. Lets Start Partners can add keys to base tables and table extension Does anybody remembered this points which I raised in year 2017 on GitHub and finally this is going to add in April 2021… Continue Reading Ammolh Saallvi’s Article...

Read More
How to kill session in Business Central
Nov27

How to kill session in Business Central

Recently faced a problem of table locking which goes in not responding stage and finally user close the tab ,but when user opens the session again it actually messed up the critical data (It seems unimaginable force was roaming that time when this happens). Eventually after trying couple of days for data correction I need to contact Microsoft to restore the database. When this happening… Continue Reading Ammolh Saallvi’s...

Read More
How to check financial journals in background in business central
Nov14

How to check financial journals in background in business central

With the release of Business Central Wave 1 2020  new feature added to check validation in background for financial journals As of now this feature is need to enabled from Feature management This features will helpful to financial users to check the issue before posting. Before this feature we have Test Report and Preview Posting to check the issues before posting. Advantage… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to add XML comments in AL Code :- Business Central
Oct30

How to add XML comments in AL Code :- Business Central

With the release of Business Central Wave 1 2020 XML comments is available in AL code. If you would like to add documentation to your code then you can use XML documentation .The documentation comment must immediately before the object such as codeunit,table,functions etc. The syntax for adding XML comments in your code is triple slashes /// followed by one of the supported XML… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to Delete extension data in business central
Oct25

How to Delete extension data in business central

With the release of Business Central Wave 1 2020 new feature added to delete the extension data from production or sandbox. Prior to that we can uninstall the extension but data still there for the extension. This feature will be useful when 1) Application is not in use. 2) Customer have desire to reinstall the extension data from scratch. Let see how to uninstall and delete… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to Copy Journal Line to Posted General Journal in Business Central
Oct21

How to Copy Journal Line to Posted General Journal in Business Central

With the release of Business Central Wave 1 2020 new feature added to copy the general journal to posted general journal. As you aware that whenever you post the journal entry the entries get deleted after posted the transaction. Now whenever accountant need to reverse the entries then they need to enter the same entries again with opposite sign. With this new version of business… Continue Reading Ammolh...

Read More
How to Use SetLoadFields in Business Central for performance
Oct18

How to Use SetLoadFields in Business Central for performance

With the release of Business Central Wave 1 2020 the partial records capability is available. The partial records capability is allows for loading a subset of normal table fields when accessing the data source based on SQL. To access the data source we use GET ,FIND NEXT. When we use these methods then runtime it load all fields and will hamper the performance while fetching the… Continue Reading Ammolh Saallvi’s Article...

Read More
Business Central Launch Event October 21 2020
Oct07

Business Central Launch Event October 21 2020

With the release of new version of business central One more virtual session is coming up for Business Central with fully loaded content for released version Following are session to be present virtually and of course on demand Register your self here Events No Description Stay tuned for more updates and Don’t Miss it Continue Reading Ammolh Saallvi’s Article on their blog Business Central Launch Event October 21 2020 With...

Read More
Use of implicit ‘with’ will be removed in the future :-Business Central
Oct05

Use of implicit ‘with’ will be removed in the future :-Business Central

Though above warning was informed by MS long time back but it has introduced in latest version of AL. With the update of new version of AL extension this warning is populated in AL code. Once you update above AL language version then you will find below warning Now this warning will become error in near future that means we need to correct it anyhow . If your app… Continue Reading Ammolh Saallvi’s Article on their blog Use...

Read More
The ID Range ‘[50000..99999] is not valid : Business Central
Oct02

The ID Range ‘[50000..99999] is not valid : Business Central

Today morning I update AL extension with the latest version as below After update I found following issue for Per Tenant app and was not able to find any clue for this issue To resolve the issue decided to roll back to latest update and it works fine but it is not giving the latest updates for AL Then I decided to ask our beloved community MVP

Read More
Business Central Wave 2 2020 Released
Oct02

Business Central Wave 2 2020 Released

With the new dawn of 1st October Microsoft released Business Central Wave 2 2020. This version is available for following W1 Version21 Localized versionIndia localization in Preview The product DVD will be downloaded from following URL Business Central Wave 2 2020 Few features of Business Central you can visit this link Business Central Wave 2 2020… Continue Reading Ammolh Saallvi’s Article on their blog Business Central...

Read More
Cumulative Update for Business Central September 2020
Sep09

Cumulative Update for Business Central September 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.5 MS Dynamics 365 Business Central 2019 Release Wave 2(15.10) :- CU 15.10 Business Central Spring Release (BC16) :- CU16 Warning Before you install a cumulative… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Cumulative Update Summary September 2020
Sep07

Cumulative Update Summary September 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 33 :- NAV2018CU33 Microsoft Dynamics NAV 2017 CU46 :- NAV2017CU46 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the cumulative update… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to build Multiline Instruction in Business Central
Sep06

How to build Multiline Instruction in Business Central

Few days back one of my customer ask me can you display text in bulleted format on page. Today I will show how I achieved this with very simple way. Created one page as follows with one field to display instruction in multiline format On the field set the multiline property to true. To display to instruction on bullet format created instruction variable as follows… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Cumulative Update for Business Central August 2020
Aug15

Cumulative Update for Business Central August 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.4 MS Dynamics 365 Business Central 2019 Release Wave 2(15.9) :- CU 15.9 Business Central Spring Release (BC14) :- CU15 Warning Before you install a cumulative… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Cumulative Update Summary August 2020
Aug10

Cumulative Update Summary August 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 32 :- NAV2018CU32 Microsoft Dynamics NAV 2016 CU 58 :- NAV2016CU58 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the cumulative update… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to Create Custom Event in Business Central
Jul28

How to Create Custom Event in Business Central

Looking at the subject there are lot of blogs available but I am writing this based on one of the request from my colleague. Everybody aware of that whenever you developed an app it need to be extensible and if anybody would like to add or modify any field or additional routing we need to have events which can extend the base functionality. Step 1 :- Simple Quick action to add event in… Continue Reading Ammolh Saallvi’s...

Read More
How to create Custom Notification in Business Central
Jul27

How to create Custom Notification in Business Central

This blog post I am writing based on request of one of the follower. Even though notification is not new business central world but today we will see how we will write custom notification and get notified for certain validations. To create notifications I added following simple scenario that when my page get opened it should show some notification. Lets see how we can do… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to Setup SMTP Mail Using Gmail in Business Central
Jul22

How to Setup SMTP Mail Using Gmail in Business Central

Recently I encounter this issue as one of the customer would like to set up Gmail as service provided for SMTP mail in business central. So I started the regular way how we started setting up SMTP and encounter the following issue. Initial Setup :- Did the initial setup with required details and while key in I key in the regular password which used while signing in Gmail.

Read More
How to convert long code into Procedure in AL/Business Central.
Jul16

How to convert long code into Procedure in AL/Business Central.

With the different code actions it is very easy to convert your long code into procedures. Just a small tip to convert to your long code into smaller procedures. To enable to code actions Hope this will help you. Stay tuned for more. Continue Reading Ammolh Saallvi’s Article on their blog How to convert long code into Procedure in AL/Business Central. With the different code actions it is very easy to convert your long code into...

Read More
Cumulative Update for Business Central July 2020
Jul10

Cumulative Update for Business Central July 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.3 MS Dynamics 365 Business Central 2019 Release Wave 2(15.8) :- CU 15.8 Business Central Spring Release (BC14) :- CU14 Warning Before you install a cumulative update… Continue Reading Ammolh Saallvi’s Article on...

Read More