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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Import failed in D365 f&O with error: Results. The value '11956' in field 'Reference table ID' is not found in the related table 'External code'. Results. validateField failed on field 'EcoResReleasedProductVariantExternalCo

(0) ShareShare
ReportReport
Posted on by

Hi All ,

I am tying to import data from excel file to the data entity 'External codes for Released products varient' - " Dtata Management " Dynamics 365 finance and opertions.

Import failed with error: 

Results. The value '11956' in field 'Reference table ID' is not found in the related table 'External code'.
Results. validateField failed on field 'EcoResReleasedProductVariantExternalCodeEntity.ExtCodeTableTableId'.

Could anyone assist me with the solution for the above error.

Regards

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    moved to the d365 forum

  • André Arnaud de Calavon Profile Picture
    308,167 Super User 2026 Season 2 on at

    Hi HHQD365,

    Can you indicate what contents you have in your source file? Is this error coming from the source to staging or staging to target step?

  • Community Member Profile Picture
    on at

    Hi Andre,

    Thanks for coming back.

    The content fields of my excel sheet are:

    Field name:             Value:

    ITEMNUMBER -    D0004

    RELEASEDPRODUCTVARIANTEXTERNALCODECLASSID -BLA

    PRODUCTCONFIGURATIONID

    PRODUCTCOLORID

    PRODUCTSTYLEID

    PRODUCTSIZEID - 000120

    EXTERNALCODE - 11956

    steps:

    i am getting when import file is executed and failed in Data management.

    the error is from source to staging

    the initial error was :

    Results. Field 'Reference' must be filled in.

    Results. validateWrite failed on data source 'ExtCodeValueTable (ExtCodeValueTable)'

    Thanks and regards

  • Community Member Profile Picture
    on at

    Hi Andre,

    Thanks for coming back.

    The content fields of my excel sheet are:

    Field name:             Value:

    ITEMNUMBER -    D0004

    RELEASEDPRODUCTVARIANTEXTERNALCODECLASSID -BLA

    PRODUCTCONFIGURATIONID

    PRODUCTCOLORID

    PRODUCTSTYLEID

    PRODUCTSIZEID - 000120

    EXTERNALCODE - 11956

    steps:

    i am getting when import file is executed and failed in Data management.

    the error is from source to staging

    forgot to add: I can able to see the data into the staging table but it is not exported to Target.

    I am not sure the error is from Source to staging or Staging to target.

    the initial error was :

    Results. Field 'Reference' must be filled in.

    Results. validateWrite failed on data source 'ExtCodeValueTable (ExtCodeValueTable)'

    Thanks and regards

  • Suggested answer
    Sergei Minozhenko Profile Picture
    23,099 on at

    Hi,

    Most likely you are missing related record in ExtCodeTable for value "BLA". Have you imported value "BLA" via "External code classes for released product variants" entity to D365?

  • Community Member Profile Picture
    on at

    Hi Sergei,

    Thanks for suggestion.

    I will import value "BLA" via "External code classes for released product variants" entity to D365 and try again.

    I will update you with the feedback.

    Thanks and regards

  • Community Member Profile Picture
    on at

    Hi Sergei,

    I tried but this time the error is changed to

    Results. Field 'Reference' must be filled in.

    Results. validateWrite failed on data source 'ExtCodeValueTable (ExtCodeValueTable)'

    Regards

  • Suggested answer
    TracyXing Profile Picture
    Microsoft Employee on at

    This should be a bug

  • Suggested answer
    Rahul Mohta Profile Picture
    21,046 on at

    ensure external codes are imported first and the reference is provided and suggest if it helps

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287 Super User 2026 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 232 Most Valuable Professional

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 222

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans