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

    TOP CONTRIBUTOR
    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
    Lehman's
    Dalton OH
    ------------------------------


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