From the Microsoft Dynamics 365 Business Central blogs: SecretText; Account schedules; Power BI integration; Item returns

In this week's Dynamics 365 Business Central blog roundup:

• Introducing the new SecretText data type
• Account schedules Excel refreshable reports
• Get valuable business insights with Power BI integration in Business Central
• How to return items with directed put-away

Dynamics 365 Business Central: introducing the new SecretText data type

Writing on his blog, Stefano Demiliani noted that Microsoft Dynamics 365 Business Central 2023 Wave 2 release (version 23) and the new AL language version 12 introduces a new data type called SecretText. This new data type can be used to protect secrets in AL code from being revealed through debugging. 

In his blog post, Demiliani explained more about the SecretText type and stated that although you can assign a SecretText variable a text variable, you can't implicitly convert a text type to a SecretText. After providing more information about the new SecretText data type, Demiliani stated that you can immediately start using this new data type in your extension code if you want to handle secrets in AL code and protect them from debugging (without marking methods as nondebuggable).

Account schedules Excel refreshable reports

Writing on the TenSoft blog, Jason Ochipa stated that the account schedules in D365BC are available in an almost printable format, particularly if you know how to export the account schedules and refresh them with your own formatting.

However, Ochipa noted that sometimes, you need the raw data quickly in a pivot table format or a Power BI refreshable report for data analysis. In his blog post, Ochipa explained where to get this data so you can select the account schedules you want to expose to Excel or Power BI.

By default, it just includes the ones that come with the standard out of the box. If you have any custom ones, which most of the companies do, you will need to add it here.

Next, Ochipa explained what to do to create a pivot table after you set this up and you've selected the account schedules that you want to expose. He stated that this is a quick way to get your account schedules into Excel in more of a pivot table format.

Get valuable business insights with Power BI integration in Business Central

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login