Skip to main content

Notifications

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

Trade agreements for sales data entiy excel addon

(0) ShareShare
ReportReport
Posted on by 1,367

Hi, 

Could anyone confirm if it's possible to create sales trade agreements via data entities? I see it's not possible with the excel add-on and the entity named Open sales price journal lines V2 seems to be related but lacks lots of fields that exist on the functional form for trade agreements, plus there is no entity to create the journals. 

Therefore, my conclusion is that there are no standard entities to create sales trade agreemetns and the excel add-on can't be used either. Could someone confirm or present an alternative, please? 

Thanks, 

Patricia 

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Trade agreements for sales data entiy excel addon

    Hi, I think its Open sales price journal lines V2 Data entity only. How about extending this data entity to add missing fields?

    community.dynamics.com/.../unable-to-see-data-entity-for-trade-agreement-in-d365-update9

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,979 Super User 2025 Season 1 on at
    RE: Trade agreements for sales data entiy excel addon

    Hi Patricia,

    There is a workaround for using trade agreement journal lines in Excel. You can create a journal and one line. Then when reopening the lines, the data entity for e.g. sales or purchase agreement lines becomes visible and available to use.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans