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 country/region code then it will clear the values from related fields like city ,state and zip code.

Navigate to General Ledger Setup.

If the option is not ticked then following is behavior

If the option ins general ledger setup is ticked then it will not clear the address fields.

Hopefully it will help in controlling the address.

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.

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

List of trusted partner apps

Profiling AL performance with snapshot debugger

Transactional installation and sync of extensions on-premises

Restarting environments

Unhindered data entry across rows

Decimal separator on numeric keypad matches region setting

Discovering reports and administration areas in Role Explorer

Copying environments of different types

Do let me know yours…

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 and I am looking forward to it as it is not supported and I have restructure the app.

Report Extensibility

This feature is everybody awaiting because if we need to change in any base app report then we need to copy that report ,make changes and use report substitution to display the customize report. Looking forward for new report extension object where in one can change layout and dataset.

Dimension Correction

In Year 2016 I wrote this blog post for updating the dimension and not it is going to be add as feature in Business central. This will help end users for updating the incorrect dimensions.

Above all it from April 2021 onwards Business Central will be available in India

Apart from above lot of new features are added in upcoming version of business central

Administration

Improve the reliability of the database export operation for larger databases with more companies

Improvements for the Delegated Administrators

Reassign an environment from one Azure Active Directory organization to another (through Microsoft Support)

Application

Assisted setup helps move the task of adjusting item costs to the background

Automatic creation of lot and serial number information cards

Bank reconciliation improvements

Changes in synchronization between contact and customer

Define lot sizes for various stages of production

More control over settings for default dimensions

Payment reconciliation journal improvements

Simplified bank statement file import

Better with Microsoft 365

Look up Business Central contacts from within Microsoft Teams

Enablement of Word merge in Business Central

Support cloud printing using Microsoft Universal Print


Modern development tools

Extension validation on upgrade

Interface – obsolete support

Return record link instead of name when using lookups

For more information please visit here on official sites of Microsoft

Stay tuned for more updates.

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

Image

Register your self here

https://events1.social27.com/msdyn365bclaunchevent/page/pre-signup

Stay tuned for more updates and Don’t Miss it

Business Central Wave 2 2020 Upcoming Features

By writing this I feel that clock is running faster and till the time we are utilizing the features of Wave 1 2020 more new features are planned and about to release in upcoming version Wave 2 2020.

There are plenty of features are planned for Wave 2 2020 but will list here what are the features I am looking for.

  1. Database access intent changed to read-only for frequently used reports As business required faster access to the information so to speed up default database access change to Read-only.
  2. Notify users of high-risk changes in selected setup fields :- This features means we can make list of fields from master table and get notified when someone changes.
  3. Business Central in Microsoft Teams :-Integrate Microsoft team with Business Central.
  4. Page Inspector supports temporary tables :- With this update, the inspection pane now displays valuable record information also for pages that are implemented to use temporary tables. Information about the current record is displayed in a consistent way and is not different from inspecting pages that use physical source tables.
  5. Data audit system fields are added to every table :- Four New Field will be added in every tables to track the transactions log.
    1. SystemLastModifiedOn
    2. SystemLastModifiedBy
    3. SystemCreatedBy
    4. SystemCreatedOn
  6. Attach to user session when debugging in sandbox :-Currently, when you debug with the Visual Studio Code AL debugger, you cannot attach to a user session, making it much harder to troubleshoot issues that are dependent on users and user permissions. This feature enables attaching to an active user session on the sandbox.
  7. Debug extension installation and upgrade code :- It is currently not possible to debug extension install or upgrade code by just adding breakpoints and deploying a new application. Instead, some workaround is required to manually trigger the install and upgrade code, possibly commenting out upgrade tags and so on, making it tedious to properly test install and upgrade during development, as well as to troubleshoot issues.

For More information on Planned features please check this link

What New and Planned for Dynamics 365 Business Central

Hope this will help you

Stay tuned for more updates.

How to find Table Relation in Business Central.

With the release of business central new property is introduced to find the table relation of given field. This property is called as’ Relation’ which returns integer value

Lets see how we can find that .

To make it created one page extension and added one action button to display the value of table of given field.

If you see the highlighted area where in I have used relation property to find table id of CITY field of customer table.

Output of this simple code as follows

Hope this will help you

Stay tuned for more..

How to get Table Information in Business Central 2020 Wave 1

With the release of Business Central 2020 Wave 1 lot of new features has been added to make product more prominent.

One of the future added is to get all table information such as no of records, size in KB etc.

If you remember correctly in old version we have same screen which shows all the relevant information regarding tables as below

How to get same screen in business central

Hope this will help you to have information

Stay tuned for more.

Business Central 2020 Wave 1

Microsoft reveals plan for business central with upcoming release 2020 Wave 1

This release comes with lot of new enhancement and features which will make business central more fun to work with.Listing few of them features.


AL interfaces
https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/al-interfaces
Look up events and insert event subscriber in codehttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/lookup-events-insert-event-subscriber-code
Ability to refactor a field from a table to a table extensionhttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/ability-refactor-field-table-table-extension
Application version for aliasing base applicationhttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/application-version-aliasing-base-application
Enhanced customer and vendor document layouthttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/enhanced-customer-vendor-document-layout
Multiple languageshttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/multiple-languages
Expanded country and regional availabilityhttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/expanded-country-regional-availability
Migrate data from Business Central 14.x on-premises to Business Central 15.x onlinehttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/migrate-data-business-central-14.x-on-premises-business-central-15.x-online
Disable export of data to Excelhttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/disable-export-data-excel
Improved load time for pageshttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/improved-load-time-pages
Improvements to data entryhttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/improvements-data-entry

Unhide parts on a page
https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/unhide-parts-page

Import profiles and UI customizations
https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/import-profiles-ui-customizations
Business Central integration with Common Data Servicehttps://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/business-central-integration-common-data-service

Collapse and expand document lines
https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/collapse-expand-document-lines

Looking forward for this change.

For more details visit

https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/planned-features