BYODb - TRUNCATE instead of DELETE from external DB, when systems has only one DATAAREAID.
When running a full export of an entity to BYOD, the process will first delete the data from the BYOD db, will then re-insert the data. The statement is: DELETE T1 FROM ***Staging T1 WHERE T1.DATAAREAID = '***' AND T1.PARTITION = 'initial'. In case of large tables, this delete is very expensive....
Requires Data Entity for unsettled transactions table CustTransOpen and VendTransOpen.
No data entity for the two tables , CustTransOpen and VendTransOpen, for unsettled transactions. We need to use the data entities for these tables to display unsettled transactions in Power BI. These tables are used in the following forms in D365FO. (a) Table : CustTransOpen Menu path : Acc...
View obsolete data entities in all data projects
Currently you can only view obsolete data entities in the data entities page in the Data Management workspace. (System administration > Workspaces > Data Management > Data entities tile> filter for obsolete). It would be incredibly useful to see what data entities are obsolete in all data proje...
ContactsV2Entity using Standard MSFT Inheritance via Module. Customer and Vendor Contact Person
Importing of Customer and Vendor Contacts Via DMF data entity is lacking in its structure. There can be 1:N Customers OR Vendors to a ContactPerson ContactPerson table has CustAccount, but it is never used in the smmContactPersonV2Entity [ContactsV2] Data Entity for loading of Contacts. Why isn...
DMF Export Projects that are setup as recurring can overlap if they take too long
If I setup a BYOD export job with DMF, and schedule it to run say, every hour, but for some reason one of the exports takes over 1 hour, then a second instance of the same job kicks off regardless. This then attempts to export the same data but with slightly less resources. This will undoubtedly ...
Document Management: Support for uploading fields larger than 50Mb
Uploading file via Document Management is not possible for large files (>50MB) even if file size is increased. (Microsoft internal reference 212463).
When importing a data entity (General journal entity) process should be stop and lines should stay in Sttaging if there is one record with any error
When importing a general journal file via DMF (General journal entity), if one line contains validation errors, the invalid line stays in the staging area, but the rest of the lines are successfully imported. This behavior is not desired, and all lines (with and without errors) should stay in th...
Fix Defect: Enable Quantity for Budget Account Entry Import
The Budget Account Entry data entity includes the quantity field. This field can be exported using data management and can be mapped for import, but it is ignored during import.
We consider this a defect, but Microsoft closed our ticket claiming that it was as designed and ...
Create entity in Data Management for Matching Policy
If a Company wants different matching policy for ex. internal vs external vendors and/or sales items you now have to go in to each seperate LE and change Matching Policy. It would be faster to copy the settings between legal entities using Data Management (if this was an available entity). Can...