web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,904 Super User 2025 Season 2 on at
    UPM: Error using data entity: Open trade agreement journal line - Pricing management
    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
    UPM: Error using data entity: Open trade agreement journal line - Pricing management
    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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 334 Super User 2025 Season 2

#2
Danny Bilodeau Profile Picture

Danny Bilodeau 216 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans