Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Fail to publish data on Excel-addin

Posted on by 475

Hi guys,

I tried to update Sell Price on Item Master via excel add-in. However, all records are failed to published and the error message does not help enough to find the solution.

Could you please advise what the exact error here?

Many thanks

Kylie

pastedimage1592440061690v1.png

  • Ett Profile Picture
    Ett 475 on at
    RE: Fail to publish data on Excel-addin

    Hi Ludwig,

    We are using both Sales trade agreement (to specific customer group) and Item sale price (if sales trade agreement is invalid, system will use Item sell price).

    Many thanks

    Ett

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fail to publish data on Excel-addin

    Hi Ett,

    Do you make use of trade agreements?

    It might be an option to upload the prices into this form then there is no direct touchpoint to the item form/tables.

    Best regards,

    Ludwig

  • Ett Profile Picture
    Ett 475 on at
    RE: Fail to publish data on Excel-addin

    I prepared data as follow. However, after I uploaded these data, other Item configurations such as Tracking dimension, search name have gone.

    Can anyone explain me and let me know the solution?

    Many thanks

    Ett

    pastedimage1592874408865v1.png

  • Ett Profile Picture
    Ett 475 on at
    RE: Fail to publish data on Excel-addin

    Hi ALL,

    I uploaded Item sell price via DIXF, Entity name: Item.

    My data include: DisplayProductNumber, Itemid, SalesPrice, Date, SalesPriceUnit.

    It worked well, price is updated. However, other previous setup at Item level such as Tracking dimension, ProductDimension and Searchname have gone. That's is terrible. Luckily I only work on Test and Dev.

    Do you guy know whether is a safer way to upload price?

    Ett

    Many thanks

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Fail to publish data on Excel-addin

    Hello ETT,

    Couple of suggestions already provided on this thread.

    Appreciate if you kindly go through and update the status in the Forum.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fail to publish data on Excel-addin

    Hi Ett,

    So, the upload did not work at all.

    Can you provide more details how you tried doing the upload? What entity you used and how you prepared your data?

    Many thanks,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Fail to publish data on Excel-addin

    Hello ETT,

    Can you check which data entity is showing in excel add-ins for uploading the item sale price? Is it "Released products V2" entity or anything else?

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Ett Profile Picture
    Ett 475 on at
    RE: Fail to publish data on Excel-addin

    Hi Ludwig,

    Thanks for your reply. I tried to update prices for some items, but the same error happened.

    Please advise me which entity is suitable to import item price.

    Many thanks

    Ett

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fail to publish data on Excel-addin

    Hi ETT,

    You tried to update a lot of data (>2700 records).

    Have you tried if the update works on a subset of them?

    That is, can you update 1, 2 or 3 prices with the Excel addin?

    If this does not work as well, then have a look at the data management framework and try using this one for your price update.

    Best regards,

    Ludwig

  • Ett Profile Picture
    Ett 475 on at
    RE: Fail to publish data on Excel-addin

    Hi Blue WANG,

    I did Compile into.Net FrameworkCIL from System Admin and try to publish again, it doesnt work at all. I got same error.

    Kylie

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans