Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Trade agreement journa...
Finance forum

Trade agreement journal price effective time overlapping

(0) ShareShare
ReportReport
Posted on by 75

Hello experts,

We are using the follow version of D365 FO:

Installed product version : Microsoft Dynamics 365 for Finance and Operations (8.1)

Installed platform version : Update23 (7.0.5126.41341)

and now we are facing a problem that would like to have an answer from you all great experts in this community.

The situation is that, the customer use "trade agreement journals" to update the retail price in their POS. Now there's two journal updated:

1. Journal #1 with item A's price $100 effective from 1 April, and no end date. 

2. Journal #2 with same item, but price $90 effective from 2 April to 5 April. 

the question is between 2 April and 5 April, which price will be effective for this item. 

I would really love to know the logic behind. 

THANK YOU SO MUCH

  • MATTGUO Profile Picture
    22,319 Moderator on at
    RE: Trade agreement journal price effective time overlapping

    The link supplied by Kunalis also applies to D365 FO.

    You can also test it to verify it.

  • Angus138 Profile Picture
    75 on at
    RE: Trade agreement journal price effective time overlapping

    This logic also works in D365 FO, the latest version?

  • MATTGUO Profile Picture
    22,319 Moderator on at
    RE: Trade agreement journal price effective time overlapping

    Hi Angus138,
    If you check find next for journal 1, $90 will be applied during 2 April and 5 April.
    If you donot check next for journal 1, $100 will be applied.
    Both of the journals are applied during this period, it will check the earlier date journal.
    If the find next is checked, it will apply the lower price journal.
    If not, it will use the first search result.
    Please use specific date range.

  • Angus138 Profile Picture
    75 on at
    RE: Trade agreement journal price effective time overlapping

    Hello Kunal,

    Thank you so much for your reply. It really solved my problem. Thank you.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Trade agreement journal price effective time overlapping

    below thread might help you

    community.dynamics.com/.../245416

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans