web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Data entity shows different data for a virtual field; via DMF and Odata endpoint

(0) ShareShare
ReportReport
Posted on by 3
Hello,

I have created a virtual field in a custom order line data entity. When i export the data entity via DMF, it shows correct data (integer value 1) for the virtual field, but when i hit its Odata endpoint, the value in the virtual field is incorrect (integer value 0).

The virtual field is basically the difference of total invoiced quantity and quantity returned for an order line. 

I assumed that the virtual field is not generating correct data for an integer value, so I hard-coded an integer value (integer value 20) as an experiment to my assumption. To my surprise, the hard-coded value is generated correct for both DMF and Odata.

Any thoughts will be highly appreciated.

EDIT: I have debugged the postLoad method of the data entity and it sets the correct/expected value in the virtual field. However, in its Odata call, the data is displayed incorrectly.
I have the same question (0)
  • Martin Dráb Profile Picture
    238,050 Most Valuable Professional on at
    Don't forget that F&O/VS comes with a debugfer, which you can (and should) use to collect  ore information about your problem.
  • Community member Profile Picture
    3 on at
    Thanks Martin for your suggestion.

    I have updated the description to inform that I have already debugged and in the postLoad method, correct/expected value is set. However, in the Odata call, the data is displayed incorrectly.
  • Layan Jwei Profile Picture
    8,133 Super User 2025 Season 2 on at
    Hi Community User,

     So I'm assuming in your postLoad you have sth like this:
    Virtual= total invoiced quantity - returned quantity

    So when you debugged via DMF what was the value of the total invoiced quantity and returned quantity?

    Then when u called odata and debugged, what was their values?
    I mean which field is causing the wrong value based on your debugging.

    Also if you could share ur code with us please.
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • André Arnaud de Calavon Profile Picture
    301,360 Super User 2025 Season 2 on at
    Hi Community User, 

    When you retrieve information via OData and Data Management export, did you use all the fields? Did you also include the total invoiced quantity and quantity returned fields?

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.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 678 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 407 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 283 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans