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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 R3 - DMF - Cus...
Microsoft Dynamics AX (Archived)

AX 2012 R3 - DMF - Customer Records not updated on Custom fields

(0) ShareShare
ReportReport
Posted on by AsimKhanAfridi 285

Hi all,

I am trying to update a Customer Master, with Custom fields. I have built the Mapping in relevant Staging and Target. Entity is Validated fine at Source and Target. Further seeing the staging table depicts that it has an Old execution data (My recent execution was 52 and it has data for 45).

How can I ensure that my latest execution is loaded in Staging? (Although getting the staging data at front-end shows an infolog telling that Staging data is done right!?!)

I will appreciate any clues.

Thanks,

-Asim

*This post is locked for comments

I have the same question (0)
  • AsimKhanAfridi Profile Picture
    AsimKhanAfridi 285 on at

    And when I try to see the Staging error log for Stage = Target, I see following.

    Results. Record ('003AKP') . A record with RecId 0 does not exist.

    Results. Record ('003AKP') . Account  does not exist.

    Results. Record ('003AKP') . Update has been cancelled.

    Results. Record ('005AKA') . A record with RecId 0 does not exist.

    Results. Record ('005AKA') . Account  does not exist.

    Results. Record ('005AKA') . Update has been cancelled.

    Results. Record ('008ALB') . A record with RecId 0 does not exist.

    Results. Record ('008ALB') . Account  does not exist.

    Results. Record ('008ALB') . Update has been cancelled.

    Results. Record ('029BAI') . A record with RecId 0 does not exist.

    Results. Record ('029BAI') . Account  does not exist.

    Results. Record ('029BAI') . Update has been cancelled.

    Results. Record ('030BAR') . A record with RecId 0 does not exist.

    Results. Record ('030BAR') . Account  does not exist.

    Results. Record ('030BAR') . Update has been cancelled.

    Results. Record ('075CHI') . A record with RecId 0 does not exist.

    Results. Record ('075CHI') . Account  does not exist.

    Results. Record ('075CHI') . Update has been cancelled.

    Results. Record ('100DOD') . A record with RecId 0 does not exist.

    Results. Record ('100DOD') . Account  does not exist.

    Results. Record ('100DOD') . Update has been cancelled.

    Results. Record ('139FUR') . A record with RecId 0 does not exist.

    Results. Record ('139FUR') . Account  does not exist.

    Results. Record ('139FUR') . Update has been cancelled.

    Results. Record ('544VIL') . A record with RecId 0 does not exist.

    Results. Record ('544VIL') . Account  does not exist.

    Results. Record ('544VIL') . Update has been cancelled.

    Data written to target 'Customer' ('0' records created, '1404' records updated)

    All these records exist in the system.

    Please provide any feedback on what I may be missing here.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Seems to be refresh issue.

    Refresh the cache and perform CIL Compilation

    Please create new processing group and then execute the entity

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi,

    The errors can come from a related table also used in the Customer entity. The Customers (CustTable) itself has been updated as stated in the last line.

    Can you tell me if you added new fields on the CustTable or another related table? Did you also checked the DMFCustomer query to see if your new fields are also added here?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    And more: You could use the AX debugger to find out which table(s) causes the error(s). Set a breakpoint at the add method of the class Info.

  • Suggested answer
    Haseeb Profile Picture
    Haseeb 95 on at

    Hi,

    I came across this error too. In fact this is not a data related issue. Please check your licence configuration. You're possibly mapping a field that's not enabled on the licence. In my case it was AccountBalance. You can run the below code and see if it takes the update then.

    static void CLearCustomerEntityState(Args _args)
{
    DMFCustomerEntity cust;
    int counter;
    ;
        counter = 0;
    while select forUpdate cust where cust.TransferStatus == 2
    {
        ttsBegin;
        cust.AccountBalance = 0;
        cust.update();
        ttsCommit;

        counter++;
    }
    info(strFmt("Cleared : %1",counter));

}


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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans