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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Steps to import Trade ...
Finance forum

Steps to import Trade Agreements into Dynamics 365

(0) ShareShare
ReportReport
Posted on by Donal 270

Does anyone have steps to import Trade Agreements into Dynamics 365.

Trying to use  Open purchase line discount journal lines data entity but  it keeps complaining with error;

The data value violates integrity constraints.

Staging log details: Error column: TRADEAGREEMENTJOURNALNUMBER

Tried to r/c the Price/discount journal number > to see View details and link to the number sequence as I want to try and disable it, but there is no 'View details' option

Can anyone help?

Categories:
Data Integration
I have the same question (0)
  • Sukrut Parab Profile Picture
    Sukrut Parab 71,741 Moderator on at

    Take a look at the this link

    community.dynamics.com/.../215786

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,430 Super User 2026 Season 1 on at

    Hi Donal,

    Are you using this entity with the Data Management Import projects or the Excel add-in? Possibly, you didn't specify a trade agreement journal number. This error can occur if no data is provided for mandatory columns.

  • MATTGUO Profile Picture
    MATTGUO 22,353 Moderator on at

    Hi Donal,

    The number sequence of TRADEAGREEMENTJOURNALNUMBER is called "Price/discount journal number" in AR parameters.

  • Donal Profile Picture
    Donal 270 on at

    Hi Andre,

    Yes I saw your earlier post about this (Oct 2016)

    I have a few questions;

    1) I have been using the data entity - Open purchase line discount journal lines - is this correct?  OR should I be using - Open purchase price journal lines  ?

    2) In Proc and sourcing > Prices and discounts > Trade agreement journals - I try disable the number sequence for the TRADEAGREEMENTJOURNALNUMBER, however this is not listed in Procurement and sourcing parameteres > Number sequences - why not ?? If I r/c the value and select View details it just blinks or takes me to a blank TA Journals form

    3) The Excel ADD-in option is not available in the TA Journals workspace -  Help  !!!

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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

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