web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Angus138 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

Categories:
Financial Management
Retail
Other
I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    below thread might help you

    community.dynamics.com/.../245416

  • Angus138 Profile Picture
    Angus138 75 on at

    Hello Kunal,

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

  • MATTGUO Profile Picture
    MATTGUO 22,349 Moderator on at

    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
    Angus138 75 on at

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

  • MATTGUO Profile Picture
    MATTGUO 22,349 Moderator on at

    The link supplied by Kunalis also applies to D365 FO.

    You can also test it to verify it.

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans