How to add OrderAccount from Free Text Invoice to Open Customer Invoices list page?

(1) Share

Report

Posted on by Raed Salah Bzour

138

Hi everyone,

I'm working on a customization in D365 F&O and I need some guidance on the best approach.

Requirement:
I want to add the Customer Account (OrderAccount) field to the Open Customer Invoices list page (CustOpenInvoicesListPage), showing the same value as the Customer Account field in the Free Text Invoice form (CustFreeInvoice), because the existing customer account represents the invoice account.

My Questions:

What is the best practice approach for this?

Should I use a display method, query join, or physical field?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 305,536 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Raed,

As you mentioned, there are different ways to achieve this. All options have pros and cons.

Display method:

- This is calculated row-by-row which has a performance penalty.

- You can't search or filter on a display field.

+ It is not consuming additional database storage.

Query join

= The data is retrieved set-based from the database which will be a smaller performance impact compared to a display method.

+ You can filter on the physical field from the joined table.

+ It is not consuming additional database storage.

Physical field

- You need additional coding to populate the value of the field.

- It is consuming additional database storage.

+ You can filter on the physical field from the joined table.

+ It has no performance impact when retrieving data from the database.

Was this reply helpful? Yes No