780
Hi All,.
I have a business requirement where need to to import multiple purchase order using Data management. But the problem is here, when we import the purchase order, value is the created date time field is always current date time. Is there any way to override the value or we can import using data management.
Thanks
Naveen
Data management won't allow to map system fields and won't import these fields. However, using x++ class, it is possible by overwrite method.
table.overwriteSystemfields(true);
table.(fieldNum(asuTMSLicensePlate,CreatedDateTime)) = CreatedDateTime passed
Hi Naveen,
The system field, no matter what the requirements are, it is best not to change it.
Your best bet is to add a new field yourself and sync it.
As stated before, it's probably a bad design idea, however, technically it should be possible. Here is an example https://community.dynamics.com/ax/b/amirsaxspace/posts/how-to-update-the-system-fields-of-the-table-like-modifieddatetime how you can do it via x++ code and obviously you can implement it on the data entity.
This field tells when the record was created in the D365FO system.
If you want to know when the corresponding purchase order was created in some other system, you need to use some other field - perhaps even create your own.
What is the business requirement where this information is needed?
Hi Naveen,
CreatedDateTime field cannot be updated as it is a system field and read-only. It should not be updated as well because this field acts as a timestamp during record audits. I don't suggest playing around with this field.
But, if there is no other option, you can use SQL scripts to update the field. But I DO NOT RECOMMEND THIS.
Share
Report
All responses (
Answers (
