Using partial records in Business Central (SetLoadFields)

Business Central allows us to set or select the fields that will be initially loaded when the record is retrieved from its data source, improving the performance of objects such as OData pages and reports, and particularly beneficial when using table extensions in the application.

Source : Ivan Singleton
Read more…

Dynamics 365 Business Central: breaking change when adding a return value to a procedure

I’ve received a request from a partner asking why adding a return value to a procedure in a Dynamics 365 Business Central extension that previously had no return value is considered a breaking change during AppSource validation.

Source : Stefano Demiliani
Read more…

Business Central 2022 wave 2 (BC21) new features 1

Launch in a specific company from Visual Studio Code (startupCompany parameter)
Read more…

Switch companies across environments
Read more…

View size of text, code fields in page inspection
Read more…

ApplicationArea on fields defaults to page value
Read more…

Enable NoImplicitWith feature by default (New feature setting in app.json file)
Read more…

New command to generate or update AL permission set
Read more…

Record tooltip has new primary key indicator (PKx – the order of the field in the key)
Read more…

See the primary key for table fields in IntelliSense (PKx – the order of the field in the key in the IntelliSense list)
Read more…

Promoted action groups, action references, and ShowAs Property (New Modern Action Bar)
Read more…

Financial reporting replaces account schedules (Account Schedules -> Financial Reports)
Read more…

Exclude temporary records when debugging record writes (“breakOnRecordWrite”:”ExcludeTemporary”)
Read more…

Exclude Try functions when debugging errors (“breakOnError”: “ExcludeTry”)
Read more…

Resource exposure policies for apps are on by default (“allowDebugging”: true, “allowDownloadingSource”: true, “includeSourceInSymbolFile”: true)
Read more…

Use option access syntax in formulas (18 -> Database::Customer)
Read more…

Make entry of variant codes required (Variant Mandatory if Exists)
Read more…

Use new dedicated APIs for financial reporting (Advanced APIs -> reportsFinance/beta)
Read more…

Choose the report layout on request page (Select a report layout before printing)
Read more…

Developers can write faster upgrade code (New DataTransfer data type)
Read more…

New Company Badge (System Indicator)
Read more…

Configure OneDrive integration (New assisted setup: Connect your files to the cloud)
Read more…

New VAT Date field on documents and entries
Read more…

More document lines are searchable (Posted and non-posted document lines)
Read more…

Apply resource exposure policy to DEV extensions (“resourceExposurePolicy”:”applyToDevExtension”)
Read more…

View SQL locks during AL debugging (Locks in Database Statistics)
Read more…

Easily access setup pages for new apps (How to add primary setup object)
Read more…

Source : Dynamics 365 Lab

Dynamics 365 Business Central 2022 Wave 2: introducing the new DataTransfer data type

I’ve talked some days ago about some UI improvements in the Dynamics 365 Business Central 2022 Wave 2 release (version 21). You can read the details here. There’s another quite hidden feature that I love a lot in this new release (not yet documented) and it’s related to the availability of a new construct for writing faster upgrade code.

Source : Stefano Demiliani
Read more…

Upload Files to SFTP via Powershell

I was asked how to upload files to SFTP from Business Central, there are several ways to do it and several posts published about it for Business Central.

In this case, without going through other Azure services, PowerApps etc., it is possible to do it directly and simply via Powershell and, given that the previous post on Powershell was quite successful, I also report this functionality in the blog.

Source : Roberto Stefanetti
Read more…