Data entity computed columns

(2) Share

Report

Posted on by MacNeg

137

Hello,

I am trying to extract list of items with columns for total open sales orders, open purchase orders, open production orders and total on hand inventory. I searched for existing data entities and did not find this information. I am wondering if I create a new data entity using inventtable as primary data source, is it better to add the open count fields as computed columns using data entity methods or create separate views with computed columns using view methods - then add these views as data sources in the data entity? I am new to X++ :)

Thanks!

Joseph

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,800 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Joseph,

Thanks for asking your question. In case you will create methods using T-SQL on the data entity, a view is created on the SQL server. The performance will be similar by creating additional views or creating computed columns.

Was this reply helpful? Yes No