@Jobourgoin

How to Override Lookup on a Form in X++

Feb 5, 2025 · 2 min read · When working with Dynamics 365 for Finance and Operations (D365FO), you may need to customize the lookup behavior on a form. This can be done by overriding the default lookup method using X++ extensions. In this article, we'll walk through the proces...

Get Tax Amount per Line in X++

Sep 5, 2024 · 1 min read · Getting the tax amount for each line in a report requires a bit of X++ coding. Here’s how to do it! 🖥️💡 📝 Example: Sales Invoice Report In this example, we’re adding the tax amount to the Sales Invoice report. 📌 Step 1: Modify the Data Provider C...

Increase row height dynamically in Excel

Mar 4, 2024 · 1 min read · This is the procedure to solve Excel row height not adjusting when larger chunks of text needs to be printed. The first step is to make sure your print area is set up. Select the print area using the columns. Next step is to get the exact width of...

How to add line numbers

Feb 16, 2024 · 1 min read · The goal here is to have the first line number be 1 and increase by 1 per record. This is done from the format First, add a root Data Collection Enter the following configuration: On the cell where you want the line number, paste this: LineNum.Co...

How to manage currency formats

Jan 29, 2024 · 1 min read · In my case, on the sales order confirmation, all of the numbers had to be formatted based on the country of the customer. The customers came from 3 different places. en-US, fr-CA, en-CA. All three have different number formats. In the case of currenc...