Notifications
Announcements
No record found.
Hello,
We have the ability to export entities to our BYOD and I was wondering which entities can I use to calculate the average cost for our items in inventory?
Hi ewallace,
I'm not able to understand what exactly you are looking for. The average cost is calculated in Dynamics 365 when posting inventory transactions.
We need to calculate an average cost per item by vendor and warehouse location in our external reporting outside of the D365 UI. Our reporting stack looks like this....D365 ----> BYOD ----> data transformation in the BYOD ----> a Tableau report that joins data from the BYOD with data from other systems.
I'm trying to find a data entity or set of entities I can export to my BYOD that either already contains an average cost statistic or contains columns that allows me to calculate an average cost value in SQL. I'm having a difficult time finding which entity or entities contain this information? Would you happen to know which entity or entities I could use?
There is no standard entity containing the average cost or able to calculate it. You would need to develop your own data entity for that purpose.
Thanks for the reply Andre. Not sure if I have the rights to construct new entities and I'm under the impression that custom entities cannot be published to a BYOD (correct me if I'm wrong). Would you know which entities would contain the pieces I need? My plan is to publish those entities and then perform my joins and calculations on the BYOD server.
Custom entities can be published to BYOD without any problems. You just need to point custom date entities to tables that have pretended information.
Thanks Nuno - do you happen to have any links on how to do that?
Do I just create a table in my BYOD without any data and matching column names from my new table to the custom entity? How would I go about pointing the custom entity to the new BYOD table in the D365 UI?
1. You need to create a custom entity that is mapped to average cost tables in D365.
2. Publish that data entity in D365.
3 . Add Custom data entity to your BYOD export job.
for 1, you need a dev machine
Check learn.microsoft.com/.../data-entities
Thanks - so I guess this goes back to my original question. Do you know which data points from which entities I can combine together to allow me to calculate average cost?
You need a data entity that exposed the same logic of Table InventSum under method averageCostPrice()
It's a simple calculation, but not a direct field.
Thanks I understand that. Do you know the names of any entity or entities that may expose the fields needed to make the calculation?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 503 Most Valuable Professional
André Arnaud de Cal... 434 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
