Author: Ammolh Saallvi

I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development. Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs. Certifications:- Microsoft Certified Technology Specialist -Dynamics Microsoft Sure Step Certified Professional Moderator at DUG Forum Specialties: • ERP Implementation • Client/Server Programming • Coding, Testing, troubleshooting and documentation. • Database Tuning and SQL • Database Performance • Debugging large programs • Project Management and Resource Management.

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

ForceSync
Recreate
Synchronize (This is default value ).

As well as this schema update is used for testing and development and should not be used in production environment as it can disturb your data if the obsolete field is not properly handled.

With the new version of business central new option added as below to sync the schema as below.

Add :- The add option will warn you if schemas are incompatible and will not apply the changes.
Force :- Force sync will overwrite the current schema with the new version without warning. Force sync can lead the data loss.

Please carefully use these options it can lead the data loss and without testing on sandbox don’t apply on production environment.

Hopefully you will find this usefule.

Stay tuned for more.

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 property has been introduced resourceExposurePolicy where in we get leverage to control your app from debug ,download the app file.

This property will be automatically added when new project is created as below.

If you can see in this property we have three options which can be used to control the app and your IP.

AllowDebugging :- Allow to control the debugging of your app when it is published. The default setting is true.
AllowDownloadingSource :- Allow to control the download of your app source code .The default setting is false.
IncludeSourceInSymbolFile: Allow to control symbol to be included in the source code of package. The default setting is false.

Can I add resourceExposurePolicy and showmycode property together ?

With the introduction of this new property in app.json file we can not use showmycode property as it will show an error and warning as below.

Hopefully this will help us to control our IP and provide more security on our app.

Stay tuned for more.

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

Cloud
On Docker
On 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 .You can register here Business Central Launch Event

For On premise version you can download from following link

Business central On-Premise Version Download

New Version for AL language also available to update.

Stay turned for more updates and keep exploring..

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 build one small extension to modify the data in the table where in we can modify the posted data .

Important: It is not recommended to change data in the tables directly as it will cause inconsistency in database and make database vulnerable.

Just check following video to check small amount of work I did.

Additionally I found blog from Volodymyr Dvernytskyi for Data Editor .Please have a look into it.

Let me know your feedback.

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 package for table sales header and sales line.

Step 2 :- Select required fields in each table .

I select required fields as below in each table as below

Step 3 :- Set the parent table id against Sales Line Table

Step 4 :- Set up the processing rules.

Select table 36 and click on table –> Processing rules.

Step 5:- Set up Action and processing filters.

In Processing rules select desire action as below and set up processing filters.

I set filter for document type =order and set action as Ship

Filters

Action

Step 6 :- Export the package in excel

Step 7 :- Add the required data in excel file

Step 8 :-Import the data back in package

Step 9 :- Apply the package

Step 10 :- Navigate to posted shipment to check the posted shipment.

That’s it so now we don’t need to write xmlport and code unit to import data and post.

Isn’t that cool ???

Stay tuned for more.

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 posting is extended to show more details and it is also setup based.

To setup the preview posting navigate to General Ledger Setup

If Posting preview type is selected as standard then it gives an overview of entries group by type.

Posting Preview type :- Standard

Posting preview type :- Extended

In the above screenshot one more option provided to see the Hierarchical View

After selecting the option Show Hierarchical View

Hopefully this feature will help accountant

Stay tuned for more.

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 Sales & receivables setup and select document Default line type as below

Select the desire value from dropdown list and go to sales order to create new transaction.

May be this small change will make difference for end users

Stay tuned for more features for upcoming versions.

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 features with Wave 2 2021

Stay tuned for more.

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.

Method	Remarks
Pi	Returns the value of pi.
E	Returns the value of E.
Abs	Returns the absolute value of a Decimal number.
Acos	Returns the angle whose cosine is the specified number.
Asin	Returns the angle whose sine is the specified number.
Atan	Returns the angle whose tangent is the specified number.
Pow	Returns a specified number raised to the specified power.
SQRT	Returns the square root of a specified number.
Floor	Returns the largest integral value less than or equal to the specified decimal number.
Exp	Returns e raised to the specified power.
Ceiling	Returns the smallest integral value that is greater than or equal to the specified decimal number.

Hopefully you find this helpful to you.

Stay tuned for more updates.

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this: