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 / Supply chain | Supply Chain Management, Commerce / UPM: Error using data ...
Supply chain | Supply Chain Management, Commerce
Answered

UPM: Error using data entity: Open trade agreement journal line - Pricing management

(3) ShareShare
ReportReport
Posted on by MP-21101100-0 17
Data entity: Open trade agreement journal line - Pricing management
 

I am trying to import trade agreements using the data entity ‘Open trade agreement journal line – Pricing management’.

However, I’m getting the following error message:

 

Results. Error executing code: The field with ID '0' does not exist in table 'GUPOpenTradeAgreementJournalLineEntity'.

 

I’m encountering this error across multiple different environments. Has anyone experienced this before?

 

Thanks in advance!

Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • Danny Bilodeau Profile Picture
    Danny Bilodeau 4,918 Super User 2025 Season 2 on at
    Suggest you try creating a journal manually, create the header not the lines. Then use this number for all the lines in your journal and import in that journal.  Test with one journal first just to validate that this is the issue. 
     
    If that was the issue, you might have to include another entity " Trade agreement journal - Pricing management" to create the header before the lines are imported.
  • Verified answer
    MP-21101100-0 Profile Picture
    MP-21101100-0 17 on at
    It seems the issue was caused by the number of attributes used.
     
     
    In they system, we support 15 attributes per attribute group. But in the data entities for trade agreement journals, we only support 7 attribtues in header and 7 attributes in line. We are working on that and we will release a new set of data entities in 10.0.47 to address this issue, and improve the performance for the exporting and importing.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 303 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 173 Super User 2025 Season 2

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 93 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans