Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Update fields on Order Product

(0) ShareShare
ReportReport
Posted on by 1,324

Is there ANY way to update fields on the order product?? I'm trying via export for re-import and via workflow and it does not seem to work. 

*This post is locked for comments

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    When you click "+" in that subgrid, will you see a new window/tab where you will provide order product details? If yes, the script should be added to the order product form

    On the other hand, if you are creating those orders from quotes.. I'm guessing you'll still need a plugin.

  • epark06 Profile Picture
    epark06 1,324 on at
    RE: Update fields on Order Product

    [quote user="Alex Shlega"]

    Hey,

     it might, but it seems, you can't create an entity and add a lookup field which will be referencing order details (at least I could not do it yesterday).

     BTW, in 365, you can add an order line directly into the subgrid and edit it there.

     Are you always using a specific form in the 2015 version? If yes, you could probably just add javascript there (to the form "onsave", for example) to copy field value from the out-of-the-box field to the new field

    [/quote]

    The fields are on the Order Product entity, but we use the Order Product grid that is on the Order form. Does the javascript belong on the Order form?

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    Hey,

     it might, but it seems, you can't create an entity and add a lookup field which will be referencing order details (at least I could not do it yesterday).

     BTW, in 365, you can add an order line directly into the subgrid and edit it there.

     Are you always using a specific form in the 2015 version? If yes, you could probably just add javascript there (to the form "onsave", for example) to copy field value from the out-of-the-box field to the new field

  • epark06 Profile Picture
    epark06 1,324 on at
    RE: Update fields on Order Product

    [quote user="Alex Shlega"]

    Here is another link mentioning the business rules/workflow for order products(not that it helps any more, but just FYI)

    crmtipoftheday.com/.../no-workflows-for-you-opportunity-product

    [/quote]

    Hi Alex, what if I created a new entity called "Order Product Detail" and relate it to the Order Product. Then could I create a workflow to update the Order Product Detail entity based on values from the Order Product? 

    [View:https://community.dynamics.com/crm/f/117/t/234051#:750:50]

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    Here is another link mentioning the business rules/workflow for order products(not that it helps any more, but just FYI)

    crmtipoftheday.com/.../no-workflows-for-you-opportunity-product

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    It is there in 365:) Then the only choice is a plugin, it seems.

  • epark06 Profile Picture
    epark06 1,324 on at
    RE: Update fields on Order Product

    [quote user="Alex Shlega"]

    Did you try creating a business rule (scope = entity)? It should work for the new records..

    For the existing records, you might still need some sort of "mass update" initially. Are you getting any errors when trying excel import? I just tried(on a different version, though), and it worked just fine.

    [/quote]

    Thanks for your help Alex, but I don't see it enabled for order products. I did run an excel import and it seems to be working. But I will need to update this field multiple times a day.

    0576.orderproduct.png

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    Did you try creating a business rule (scope = entity)? It should work for the new records..

    For the existing records, you might still need some sort of "mass update" initially. Are you getting any errors when trying excel import? I just tried(on a different version, though), and it worked just fine.

  • epark06 Profile Picture
    epark06 1,324 on at
    RE: Update fields on Order Product

    [quote user="Alex Shlega"]

    Are you familiar with plugin development? If not, it might not be worth it.. but you should probably start here:

    msdn.microsoft.com/.../gg328490.aspx

    On the other hand, are you trying to setup a process or is it a one-time update? Could you clarify what you are trying to do?

    [/quote]

    I'm trying to setup a process. There is a field on the order product. I just want to copy those values onto another field on the order product.

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Update fields on Order Product

    Are you familiar with plugin development? If not, it might not be worth it.. but you should probably start here:

    msdn.microsoft.com/.../gg328490.aspx

    On the other hand, are you trying to setup a process or is it a one-time update? Could you clarify what you are trying to do?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans