Quick and Easy: D365FO VendPackingSlipTrans Entity

Although D365FO Entities has over 2000+ entities available out of the box, for my surprise it lacks a very important entity: Vendor Packing Slips. In this post I'll show my solution to have Vendor Packing Slips transactions available by odata and/or DMF. Note: If you try to create the entity by using the Data Entity Wizard you won't be able to use neither VendPackingSlipJour/Trans as DataSource as they lack of a proper sequence number. You will get the infamous "The natural key for the table xxxxxxx was not found".


You can take the path of extending the table by adding a sequence number or you can follow my example. Solution: Use the Purchase Order table as Datasource and build the query to VendPackingSlipTrans.


Specifically, you need to relation PurchTable->VendPackingSlipJour->VendPackingSlipTrans. Make sure your Entity looks like the image below


Finally add relevant fields out of the datasources, for example:


Now you can test it

And that's it, quick and easy as I promised :)

Comments

Post a Comment

Popular posts from this blog

Monitoring Batch Job Errors in D365FO using Application Insights

Image
While Dynamics 365 Finance and Operations (D365FO) includes native integration with Application Insights , the out-of-the-box capabilities still have limitations—especially when it comes to monitoring the real-time status of internal processes like batch jobs. Although batch job task exceptions are tracked , they don’t always reflect the current status of a batch job. Tasks may have failed and later been retried successfully, meaning the job is actually healthy by the time we query it—yet the historical exceptions remain in telemetry. In this post, I’ll show an alternative technique that extends the telemetry pipeline by programmatically sending custom metrics and structured data to App Insights . We’ll walk through a lightweight batch class that scans for failed batch jobs across all companies and pushes that data into App Insights as both a metric and JSON payload , enabling Kusto-based analysis, dashboards, and alerts. This approach is flexible and can easily be adapte...
Read more

Infamous "The natural key for some table was not found" solved once and for all

Image
Data entities in Dynamics 365 for Finance and Operations (D365FO) are awesome, as long as you can use the wizard to create them. Quite often you will find that some tables throw the infamous "The natural key was not found". This is because many tables actually don't have unique indexes - for many reason - but here I'll present a general solution to create any entity - read-only entities - in very simple steps.  Capture when trying to create an entity for InventTrans table In this example I'll create an entity for the InventTrans table as this table doesn't have an unique index.  Step 1: Use the wizard to create an entity but select any know table that happens to have unique indexes. In this case I'll select InventTable.  In the next screen Deselect all the fields and click Finish. You will end up with an entity with a single datasource Step 2:  In this step we need to create a View that is based on the table that we want to expose as an entity - in this ca...
Read more

Visualizing F&O telemetry data with Grafana

Image
  Following up on my previous post, I explored alternative ways to visualize telemetry emitted by Finance & Operations environments. Azure Data Explorer is a powerful option, but I wanted something more oriented toward dashboards. Azure Managed Grafana integrates well with Application Insights and turned out to be a good fit. Below is a step-by-step breakdown of how I connected Application Insights to Grafana to visualize batch job errors using a custom metric. Prerequisites To follow these steps, make sure you have: An Application Insights instance receiving telemetry from your F&O environment An Azure Managed Grafana workspace in your Azure subscription Sufficient permissions to query logs and create dashboards Step 1: Build the KQL query in Application Insights Start in the Logs blade of your Application Insights resource. The teleme...
Read more