How to change table property automatically by creating batch job or by using X++ in D365FO.

Posted on by Zaid Khan

Hi Friends,

Please tell me

How can I automate the process of changing a table property (e.g., 'Allow Retention') to 'No' or 'Yes' in Dynamics 365 Finance and Operations using X++ or by creating a batch job?

I'm working with D365 FO and need to update the 'Allow Retention property to 'No' or 'Yes' of a specific table or tables at once automatically. The goal is to toggle this property between 'No' and 'Yes' based on certain conditions.

Could you provide guidance on:

Creating a batch job that automates this property change. What classes and methods should I use, and how should I structure the job to ensure it runs periodically or based on a trigger?

Using X++ to programmatically modify the table property. What code would be necessary to locate the table, update the property, and save the change?

I'd appreciate recommendations.

Thanks.