web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Contract Obligation Li...
Finance | Project Operations, Human Resources, ...
Answered

Contract Obligation Line data population

(0) ShareShare
ReportReport
Posted on by Mohan_AX 106

Dear AX Experts,

The below Issue I am seeing in AX 2012 R2 version.

We have updated ToDate value as "12/31/2020" for contract Obligations using SQL query. But the Obligation Lines are not created for year 2020 .

Where as if we enter same value through AX UI the Obligation lines are created.

Can some one please suggest if there is a way to populate the lines.

Note: I tried DB sync and compiling of both ContractObligation and ObligationLine forms and tables and restarted AOS.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

    Hi Mohan,

    Can you explain the business problem? You are mentioning an update on a ToData field and records are not created. Do you need to create new records or update existing records? Do you get any errors?

    What do you mean with SQL query? Are you manipulating data directly using SQL? If so, for what reason? Can't you use an AX 2012 class or job to do your task?

  • Verified answer
    Mohan_AX Profile Picture
    Mohan_AX 106 on at

    Thank you Andre for quick response.

    Our business requires contracts in AX extended till end of 2020 , so one of my counterpart updated Contract Obligations ToDate value from "12/31/2019" to "12/31/2020" using SQL query (he is unaware of X++ job).

    If we update ToDate from AX UI , it will automatically creates Obligation Lines and Invoicing Schedule till the end of the period (in our case it's till 12/31/2020). As the date was updated through SQL we are not seeing any Lines or schedule populated for Obligations.

    Now I created X++ job and tested and the lines and schedule creating correct, but this process consuming much time as there are 36k records need to be updated.

    So I wonder if there is any alternate way to handle this and populate the Lines and Schedule.

    Please let me know if more details are needed.

    Thanks

    Mohan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 657

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 615 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 356

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans