Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

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.

All responses (2)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 307,097 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Zaid,

This is not possible. The application and development environment are separated. You can't change AOT objects anymore like it was possible in AX 2012 and before.

The property is managed in Visual Studio. You can only set a value for your tables. Standard Microsoft models are locked and this property is not open for accepting another value using a table extension.
Martin Dráb 240,742 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I replied to an identical question four days ago. It was created by another user, but both the title and the content are the same. Here is a link: How to change table property automatically by creating batch job or by using X++ in D365FO..