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

Telemetry and Monitory with Applications Insights and Dynamics 365 F&O

Image
Telemetry and Monitory with Applications Insights and Dynamics 365 F&O With version 10.0.39 Applications Insights integrations is GA. Hence, here is a very simple example how to start using this great feature and start monitoring the performance of your application.  For more about D365FO and Application Insights integration:  Monitoring and telemetry using Application Insights - Finance & Operations | Dynamics 365 | Microsoft Learn Dynamics 365 Finance and Operations - Monitoring and Telemetry using Application Insights -TechTalk (youtube.com) In this example we will monitor the execution time of a batch job. In particular, we will use a metric to analyze the execution over time.  // Create a class file and paste this code class SlowBatchJobClass extends RunBaseBatch implements BatchRetryable { [SysEntryPointAttribute] public void run() { int maxWaitInSeconds = 20; // Maximum wait time in seconds           SysApplicationInsightsTelemetryLogger logger =
Read more
Image
Distributed Printing Architecture with Power Platform  Going back to posting after a long period. Now I have started a new blog where I'll be posting content related to my work with Microsoft technology, and how you can combine Dynamics 365 + Power Platform + Azure to solve virtually any problem in a reliable and robust architecture. In this first post I'll share how to build an architecture for unattended distributed printing from Power Apps. Although there are other options (look at PCF controls ) I found this architecture simple and reliable. This solution will serve to customers looking to: Use network shared printers across their organization. Serve multiple users allowing them to distribute their printing task according to specific business rules (ex. some group will only print on 'Printer 01') Rely on the SO to print as you can use the print command Access your local resources (printers) in a secure way To connect from the canvas app to the A
Read more

Creating a DMF data package from files stored in an Azure blob storage

Image
Dynamics 365 for Finance and Operations support different scenarios for data integration.  Each scenario is listed on the following documentation: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/integration-overview One of the most common scenarios is when a large number of records need to be imported in D365FO. These record normally are coming from a third-party application as batches. If we follow the documentation guidelines for this scenario, the recommended pattern to be applied is Batch Data API For this kind of pattern we have the following API available:  Recurring Integration API  Data Management API  Many people uses the Recurring Integration API, however, I found it lacks of features (like asking for the task status) and also I haven't seen any further investment to improve it. For these reasons I choose to use the Data Management API.   Data Management API is a robust API and their specification can be found here: Data management pac
Read more