Supply chain | Supply Chain Management, Commerce

Trade agreement update price

(1) Share

Report

Posted on by CU11092048-0

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 ?

	Period	1-02	2-02	3-02	4-02	…	1-04	2-04	3-04	4-04
current price	IT01 price = 1,5 eu									infinity
new price	IT01 price = 2 eu									infinity

I have the same question (0)

All responses (6)

Answers (0)

AR-01121610-0 4,967 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU11092048-0 26 on at

Like (0)

Report
Copy link

Link copied!

Thx andreasraithel

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 ?

Was this reply helpful? Yes No
Suggested answer

Laurens vd Tang 4,225 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Guy Terry 28,943 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AR-01121610-0 4,967 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
asedawy 119 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No