the form "Delayed receipts" is made up of 1 view which is related to query involving two tables:
| Table |
Range |
Value |
| PurchLine |
|
|
| |
PurchStatus |
Backorder |
| |
IsDeleted |
No |
| |
RemainPurchPhysical |
!0 |
| PurchTable |
|
|
| |
DocumentState |
Approved/Confirmed |
So, to achieve the same result, you need to use data entities of PurchaseOrderLineV2, PurchaseOrderHeaderV2
Go to the Common Module > Office Integration > Excel Workbook Designer.
Then select the PurchaseOrderLineV2 entity and add relevant fields, click on Create Blank Workbook.
After adding the PurchaseOrderLineV2, you need to add PurchaseOrderHeaderV2 (explained in given blog), then put necessary filters as given at first table. Then Click on Refresh, it will showcase all the relevant data as per requirement.
You can take hint from this blog on how to add data from PO lines and PO headers.
Important note: Since this framework is using the Excel add-in, it allows to make the changes and update back to D365, so make sure to lock this file with password so that no changes are allowed here.
Please try using this process and let us know the results. Hope this will give you desired result.
Regards,
Neeraj Kumar
If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
