From the Microsoft Dynamics 365 Business Central blogs: Fast data clearing; Reporting; Production order calendars; Barcode printing, scanning

In this review of the Dynamics 365 Business Central blogs:

• Don't just delete, truncate: A deep dive into blazing-fast data clearing
• Level up reporting with new Power BI apps
• How to update your production order calendars
• Barcode printing and scanning

Don't just delete, truncate: a deep dive into blazing-fast data clearing in Business Central

On the CloudFronts blog, Raviraj Hirve wrote that if you've ever worked with data in Business Central, you've probably used the Delete or DeleteAll commands. 

Hirve noted that they work, but when you're trying to clean up huge amounts of data, such as old ledger entries, archived sales orders, or temporary import tables, they can be painfully slow.

He pointed out that there's a much faster option: the truncate table command, which is basically the hidden shortcut for clearing out large tables quickly.

Hirve stated that the truncate table command is a SQL command that wipes a table clean almost instantly. Instead of deleting each row one at a time, it clears out the data pages all at once. He added that because it doesn't log every deletion, it runs much faster than delete. He then explained how to execute this command directly from an AL codeunit. He also discussed the differences between the truncate table and Delete/DeleteAll.

Level up reporting with new Power BI apps in Business Central

Writing on the Stoneridge Software blog, Makenzie Romich explored the challenge of bridging the gap between raw numbers and actionable insights. Challenges, such as disconnected systems, complex reporting setups, and limited data visibility, can cause problems. This is where you can use Power BI apps for D365BC.