Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Trade agreement update...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Trade agreement update price

(1) ShareShare
ReportReport
Posted on by CU11092048-0 26
Hi,
 
I have below cases:
I have price for iteam: IT01 in period: 01.02 to infinity
In 20.03 i receive new price (higher lower doesn't matter) form period: 01.04 to infinity
trade agreement, release productetc  a way that the system takes the price from the price list that was posted last one (not the lowest) ? 
It's possible on D365fo ?
 
 Period1-022-023-024-02…1-042-043-044-04
current priceIT01 price = 1,5 eu        infinity
new price IT01 price = 2 eu        infinity
  • asedawy Profile Picture
    asedawy 117 on at
    Trade agreement update price
    Hi,
     
    You can check the category price rule function in the retail and commerce module. It has an option to automatically close previous trade agreements that were previously created from the same category price rule line.
     
    Thanks
  • andreasraithel Profile Picture
    andreasraithel 4,839 Super User 2024 Season 2 on at
    Trade agreement update price
    Hy,
    how to best update the prices (also dsicounts, ...) on trade agreement depends on how the price update comes to you.
     
    Do you get a price file, you could bring this to the Data entity format for the OpenSalesPriceJournalLinesV2 entity to be imprted using DMF.
    Or as mentioned before you can use / Open in Excel / to modify existing records in unposted journals.
    Futhermore when you have changes per percentage (e.g. in- or decrease prices by xx percent) you can do this within the trade agreement itsself.
    Using / copy and revise / can manipulate existing journal lines e.g. to set new / form date / and / to date /.
     
    Hope this helps.
     
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
     
  • Guy Terry Profile Picture
    Guy Terry 28,647 Super User 2024 Season 2 on at
    Trade agreement update price
    You will need to set a To Date on the prices which were created on 01.02.
     
    The easiest way to do this is probably to use the Select button to bring all of the Prices that need updating in to the Journal. Enter a To Date of 31.03 on the first line only. Then use the Open in Excel function to bring all of the lines in to Excel.
     
    In Excel, copy the 31.03 date on to all lines, and Publish.
  • Suggested answer
    lvdtang Profile Picture
    lvdtang 1,956 on at
    Trade agreement update price
    Good day,
     
    I think the best would be to create two lines:
     
    - One with 'To date' 3/192/204
    - One with 'From date 3/20/2024
     
     
     
    Best regards,
     
    Laurens van der Tang
  • CU11092048-0 Profile Picture
    CU11092048-0 26 on at
    Trade agreement update price
     
    but you have mean that date should be update every time manualy ?
     its a lot of iteams to close period always manualy...
    find next I have off, but system awlways take lower price.
    Generaly this is the simpe case.

    I  have other with one item and two prices depends of quantity 1-100pcs one price, 101- infinity secound price
    And general problem is that you dont know when you receive new price for iteam that is reason why period for date is always to infinity....
    Take last one posted, will be the best way update price. but how to set up ?
  • andreasraithel Profile Picture
    andreasraithel 4,839 Super User 2024 Season 2 on at
    Trade agreement update price
    Hy,
     
    best approach is to use the / to date / in the trade agreement to mark the old price to be not longer valid after the / to date /.
    So the / from date / and / to date / should be handled to have a unique price finding.
     
    Besife that the / find next / switch can be used stop searching for further trade agreements lines when multiple trade agreement lines exist.
     
    Hope this 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans