D365 F&O

 Hi, I have came across issues like customer provide data for upload into D365 in their own excel format which usually never matched as per the template of D365 Data management framework. So then comes some tool which can help in coping the data form customer provided template to DMF template. Here assumption is atleast header names of customer provided tempate should match with D365 DMF template. You can use my attached macros file for copying data. https://1drv.ms/x/s!AoYLueqi3KQhngYTaKlV_wITw-mD?e=89OxDH

Problem while importing Data Entity ales order lines V2  Line through - Data Management.  Issue -  The file for entity Sales order lines V2 has 1 error(s) '0' 'Sales order lines V2' record(s) inserted in staging solution -  Step 1 - Go to  your Project and click on -ViewMap - Step 2 - click on Mapping Details. Step 3 - click on the Check box - auto for the field - InventtoryLotId Step 4 - Prepare the data for import in Sales order lines V2. Enjoy DAX'n