June 2024 – Pardaan.com

Sharepoint Service to Service Authorization. Integration with Business Central. No user permissions.

I think integrating Sharepoint into Business Central is a fairly common request. The standard library already supports some level of Sharepoint/OneDrive integration out of the box, but it is quite limited. What if we need more advanced logic? In that case, we can use Sharepoint Interfaces…

28 June 2024

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: How to convert Text to Hexadecimal in AL

Today I would like to talk about how to convert Text to Hexadecimal in AL. The hexadecimal number system is a type of number system, that has a base value equal to 16. Hexadecimal numbers are represented by only 16 symbols. These symbols or values are…

27 June 2024

Dynamics NAV & BC Tips & tricks

I have never seen Business Central integrate with Excel like this!

Join me in a hack to explore a different type of integration between Business Central Excel. I spend a few days on a kind of “what if” exercise, check out the result in this video: Source : Hougaard.com Read more...

26 June 2024

Dynamics NAV & BC Tips & tricks

Optimizing Sales Order Reservations in Business Central: Focusing on Item Ledger Entries

When working with Dynamics 365 Business Central, ensuring efficient and accurate reservations of sales order lines can sometimes be a challenge. I faced this issue myself when I needed a way to reserve items only from available inventory, without pulling from other sources like purchase orders…

25 June 2024

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: How to set dimension via standard API and Can we do it via Power Automate?

Today I would like to briefly talk about how to set dimension via standard API and can we do it in Power Automate? Dimensions are values that categorize entries so you can track and analyze them on documents, such as sales orders. Dimensions can, for example,…

24 June 2024

Dynamics NAV & BC

Select with partially matching index: can we make it faster?

Let's assume we want to select a set of customer ledger entries based on two values: salesperson code and the payment reference. Or any subset of records from any other table that satisfies two criteria: the table is large enough, so the query can benefit from…

24 June 2024

Dynamics NAV & BC Tips & tricks

Lock timeouts and deadlocks

A long time ago (in a galaxy far away) I published some blog posts with a deeper overview of the Business Central's ReadIsolation property and its relation to SQL Server transaction isolation levels. I left a few open ends at that time, promising to return to…

21 June 2024