D365 Finance & Operations and Dynamics AX Forum

DMF/DIXF: How to include MCRCustTable in Customer entity

  • 1.  DMF/DIXF: How to include MCRCustTable in Customer entity

    Posted Aug 20, 2019 09:56 AM
    #AX2012 #Technical #DataManagement

    I'm importing customers using DMF (a.k.a. DIXF), and I need to include MCRCustTable in the import process, but I have yet to get it working.

    MCRCustTable is related to CustTable by CustTable.RecId == MCRCustTable.CustTable.  I think this is what is making it challenging for me.

    I've tried creating a custom entity based on the MCRCustTable​​​​, with a "generate" method to lookup the custtable recid.  That resulted in only the last record inserted having a record in the MCRCustTable for some odd reason.

    I've tried adding the MCRCustTable to the DMFCustomerTargetEntity (with the default relation).  That results in the first record importing with a value of zero in the CustTable field and the rest hitting an error: "Cannot create a record in Customers (MCRCustTable). Reference: 0, lha.
    The record already exists."

    Does anyone have any suggestions on how to make this work?

    Thanks in advance.

    Daniel Zook
    Director of IT
    Dalton OH

If you've found this thread useful, dive deeper into User Group community content by role