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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Released Products V2 I...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Released Products V2 Import error

(0) ShareShare
ReportReport
Posted on by Moh Imran Siddiqui 92

Hi, 

When i try import the released products i am getting an error 

First i downloaded the released products V2 entity 

Second I changed Sales price and import the file getting below error

"The column in entity Released products V2 has incorrect data. Please correct the data and try the import again.
'0' 'Released products V2' record(s) inserted in staging"

pastedimage1634227046682v1.png

Let us know how shall we resolve this issue 

I have the same question (0)
  • AR-01121610-0 Profile Picture
    AR-01121610-0 4,965 Moderator on at
    RE: Released Products V2 Import error

    Hy,

    you can get more detail information about the error when you go to "view staging data" and then to the line with the error status. Here you usally can see the root couse of the error.

    What is the error message there? 

  • Suggested answer
    Twdownie Profile Picture
    Twdownie 207 on at
    RE: Released Products V2 Import error

    Imran,

    I do not know the cause of this but have found a work around if the products are created but not released.  Release them manually in the All Products form to the relevant legal entity then update the data with you Release Products V2 sheet.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,545 Super User 2025 Season 2 on at
    RE: Released Products V2 Import error

    Hi Imran,

    Your screenshot shows that there are no records in the staging inserted. In that case, the error is in your source file. Can you check for emply lines at the end of the file and also if the decimal separator for the sales price is correct?

  • Community Member Profile Picture
    Community Member on at
    RE: Released Products V2 Import error

    Hi Imran,

    I have the same issue and cannot locate the faulty column. Did you manage to solve it?

    Thanks,

  • Suggested answer
    AliceBarendregt Profile Picture
    AliceBarendregt 1,470 on at
    RE: Released Products V2 Import error

    Hi all,

    The above issue is a known Microsoft bug. It will be resolved by means of applying the quality update that is available as part of version 10.0.21.

  • Community Member Profile Picture
    Community Member on at
    RE: Released Products V2 Import error

    Refreshing the data entity list worked for me.

  • Taric Profile Picture
    Taric 75 on at
    RE: Released Products V2 Import error

    Hi, 

    i tried to refresh the data entity list, but without success. 

    We are already on Version 10.0.22 but the error still exists. Does anyone know the issue, or should i contact MS to look further into it? 

    BR
    Amel 

  • Moh Imran Siddiqui Profile Picture
    Moh Imran Siddiqui 92 on at
    RE: Released Products V2 Import error

    Thanks issue has been resolved after upgrading d365fo to 10.0.22

  • GertV007 Profile Picture
    GertV007 27 on at
    RE: Released Products V2 Import error

    Dear Amel,

    In our case, the Import failed from Excel file into staging, due to incorrect date in one of the date fields.

    Issues that gave your error, and that I know about are:

    * Empty rows below the excel data.Remove any excel rows that you do not need and save again.

    * Incorrect numerical values into a number field. here look at the way you see them in your Excel field. left or right alligned. left usually not good for a numerical value.

    * incorrect date value in a date field.

    I hope this helps.

  • Shakir Shabbir Profile Picture
    Shakir Shabbir 76 on at
    RE: Released Products V2 Import error

    The most possible cause of the error may not be the column itself and that it could be more relatable issue with a flat CSV file.

    For example, see below (Data file):

    pastedimage1654016331421v3.png

    In this file, there were around 3000 records, but these three highlighted records had an issue and that was related to number field going in place of a date field (because of a comma in the preceding column, which shifted the data to 1 column rightwards) - The system was giving a deceiving error "The column REASONTEXT has incorrect data, while it was nothing wrong in the RESONTEXT column":

    pastedimage1654016362499v4.png

    So, perform a sanity check on the input file and load again.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 760

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 250 Super User 2025 Season 2

#3
Sagar Suman Profile Picture

Sagar Suman 208 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans