Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

How to update Base sales prices

Posted on by 45
Hello,
 
I know how to update trade agreements via Excel: one can export the trade agreement journal lines to Excel, edit them and publish them back. Then, one can validate the journal lines and post them.
 
Is there a similar way to update the Base sales prices?
I have to modify some 10000 lines...
 
Any help would be welcome.
  • Verified answer
    IA-11061332-0 Profile Picture
    IA-11061332-0 45 on at
    How to update Base sales prices
    Thank you everyone for your suggestions.
     
    Indeed, one can use the "Released products V2" option with Excel.
    Then, one must go to "Design" and add a field "SalesPrice – Sales price".
    "Update"/"Refresh".
    After that, one may modify the data as needed and publish it.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    How to update Base sales prices
    In ReleasedProductsV2, PURCHASEPRICE AND SALESPRICE are your base price fields.
  • Suggested answer
    IA-11061332-0 Profile Picture
    IA-11061332-0 45 on at
    How to update Base sales prices
    Partial solution I used :
     
    One can paste values from Excel for multiple rows / columns.
    But the list should not be very long. I did it by slices of 500 items.
    So, first, you filter the list of products to have a slice of 500 items. 
    Then, you click the little "edit" pencil over the field you want to change and you paste a list of 500 values that has been previously copied from the Excel file. Of course, the items should be in the exactly same order in Dynamics and in Excel.
    If it worked, you will se a popup containing two buttons - "Save" and "Discard". If you are happy with what you see, press "Save". The records are saved one by one.
  • Martin Dráb Profile Picture
    Martin Dráb 230,030 Most Valuable Professional on at
    How to update Base sales prices
    Moved to the Finance forum, which is one of the F&O forums (and the most active one).
     
    I agree that locating the right forum isn't easy and I provided this feedback to Microsoft, but I don't know if they're going to change anything.
  • IA-11061332-0 Profile Picture
    IA-11061332-0 45 on at
    How to update Base sales prices
    Hello, 
     
    1. We are using Dynamics 365 Finance and Operations and I don't see the forum with this name.
    2. Yes, there is the possibility to use "released products v2", but where are the cost and base sales prices there? I cannot fnd the corresponding fields...
  • Suggested answer
    How to update Base sales prices
    You can use the "released products v2" (EcoResReleasedProductV2Entity) or use the Excel add-in behind the released products form.
  • Suggested answer
    RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    How to update Base sales prices
    Hi,
     
    We analyzed your requirements and based on the information you provided, we determined that the product you are using is Dynamics 365 Supply Chain Management, is this correct?
     
    If you are not using D365 Supply Chain Management. Would you be able to provide more information about this issue? For example, which product you are using, etc. This will help us to better understand your needs.
     
    If you are using D365 Supply Chain Management. We recommend you post this question in Dynamics 365 Supply Chain forum, where your problem will be noticed by many experts in the field, and you will get a more effective solution.
    The link to the forum is as follows.
    https://community.dynamics.com/forums/thread/?groupid=c00f5b89-7ad3-4ff0-a9e1-b24eb68b291e
     
     
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans