Announcements
No record found.
How I can add computed column in my custom data entity where i want to add syscomputedcolumn to export Phone number, the phone number should be customer phone number or company phone number.
Hi Muhammad,
You can find information about how to create computed columns or virtual fields as part of the documentation: Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Docs
What is in your case the difference between the customer and company phone number? What is the business logic to determine which one to pick?
Is there any out of box implementation to get customer phone number using SysComputedColumn?
The Customers V3 is having an implementation for the primary phone number. I don't know out of the blind if this is via data sources bound fields or a virtual field/computed column. You can check it in a development environment yourself.
You can get customer phone number from Customer V3 entity. You can also try with entity Party contacts V3 that have data for contact information for Parts in D365FO.
How we can use joins using SysComputedColumn instead of SQL injected queries?
What do you mean? Injecting a piece is SQL code to a view definition is what computed columns are for. If this is not what you want to do, then you don't want to use computed columns.
Of course, you can use joins in SQL code.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 517 Super User 2026 Season 1
Giorgio Bonacorsi 440
Adis 266 Super User 2026 Season 1
