Finance | Project Operations, Human Resources, ...

Creation of Composite Data Entity "Trade allowance agreements"

(0) Share

Report

Posted on by Deepak K

Dear Team,

Could you please help me in providing the input to automate the creation of "Trade allowance agreements"?

I'm having data related to "Trade allowance agreements" in Excel files, using which I would like to automate the creation of "Trade allowance agreements" in D365 F&O. Using OData service is ruled out due to this Composite Data Type. If I'm not wrong the only available option is using Data Management Import. Had tried multiple times to Import one record which is failing. Below are my trails

When tried to import the record using XML in Data Management Framework of D365 F&O. I'm getting the error "Package execution failed please check event log in DMF service box-"

I'm not sure where to find the exact error as it is the Cloud version of Dynamics AX. Confused about finding in DMF Service box ???
If the record is successfully created using import. Can I automate the process? Do we have any out of the D365 Service for Import the recording using XML files? If Yes Please suggest. As I'm not able to find the right source/documentation
Tried using Power Automate D365 F&O "Create Record" action to create the record. Failed in the first instance with the error "Error: insert/update/delete not allowed for an entity with ReadOnly = Yes" for all the TAM entities
Initially tried using OData Service then after a while reading more blogs realized that "Composite Data Entities" can't be created using OData Service integrations

Please do let me know if you need further information

Thanks

Deepak

I have the same question (0)

All responses (27)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Deepak,

1) If you go to the execution details, you can find error logs and also go to the staging details to find possible errors per record.

2) You can read the documentation about recurring integrations using data management here: docs.microsoft.com/.../recurring-integrations

3) If you get this error, then indeed the entities are not set to all CRUD rights using Odata. Then you can only read existing records. However, you can develop new entities which would support both read and write.

4) Odata indeed doesn't support the composite entities, but you can actually call the individual entities. For the trade allowance it will not work as you encountered that they are designed with read-only for public access (Odata).

If the you can't find more detailed errors, you can first try to export existing data and analyze what columns are filled to build your import files.

Was this reply helpful? Yes No
Deepak K 15 on at

Like (0)

Report
Thanks for your quick response André Arnaud de Calavon.

I have got the above error information from the same location. (Job History --> View Execution Log --> Log Text) Wich is not effective to resolve the issue. PFA the screenshot. Please do let me know if we have any other option to view the completed error details. I hope if we have the error details we can easily fix the issue with the uploaded file. I have been using the exported file with data for import the new record by removing the Trade allowance ID, even after that, it is failing (attached the import file). Do I need to add all the entities with the fields in XML manually and then import it? Currently, the import file is having only the following entities

"TAMTRADEALLOWANCEAGREEMENTHEADERENTITY"

"TAMTRADEALLOWANCEAGREEMENTPRODUCTENTITY"

"TAMTRADEALLOWANCEAGREEMENTFUNDENTITY"

"TAMTRADEALLOWANCEAGREEMENTMERCHANDISINGEVENTENTITY"

"TAMTRADEALLOWANCEAGREEMENTMERCHANDISINGEVENTFUNDENTITY"

"TAMTRADEALLOWANCEAGREEMENTMERCHANDISINGEVENTPRODUCTENTITY"

"TAMTRADEALLOWANCEAGREEMENTMERCHANDISINGEVENTDISCOUNTENTITY"

"TAMTRADEALLOWANCEAGREEMENTMERCHANDISINGEVENTLUMPSUMENTITY"

"TAMTradeAllowanceAgreementMerchandisingEventBillBackEntity" (Based on error I have added this entity manually. Does the letter casing matters? )

I'm confused with the "Add File" and "Add Template" in "Import". For the current process, I'm using "Add file Option. Do we have any template or file that I see as a reference to create the record? Using the recurring integrations technique can I directly upload the file if I have a proper Template? Why I'm asking this as in one of the scenario when I'm uploading the file I had to manually map the AGREEMENTID with Source and destination, as mapping can't be done while automating the process. Correct me if my assumption is wrong.

SS_5F00_D365.docx Master_5F00_Import.xml

Was this reply helpful? Yes No
Deepak K 15 on at

Like (0)

Report

Hi André Arnaud de Calavon,

I'm able to find the staging logs which has the following error.

"Number sequence is not set
Issue exists in auto generation of number sequence
Issue exist in generate staging data
'0' 'Trade allowance agreements' record(s) inserted in staging"

I have set "AgreementId" to Auto in Mapping details. Attached is the file that I had used as a sample (which is an export of the Trade allowance agreement record). Please help me in finding the right template/file for import, from the past few days I'm not able to find the right articles for importing a "Trade allowance Agreement records" in D365 F&O. If we resolve the file/template issue can we use the same file in the recurring integrations technique for creating new records as an automation process (or) It is only for manual upload of XML Files to create "Composite Data Entity" records i.e. Trade Allowance Agreement. Please suggest.

Thanks

Deepak

TAA_5F00_WithoutNumber.xml

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Deepak,

Did you setup a number sequence on the Trade allowance management parameters form?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

As Andre suggested, please check if you have set up the number sequence for Trade agreements.

About your other question "can we use the same file in the recurring integrations technique for creating new records as an automation process (or) It is only for manual upload of XML Files", you can use it for both manual and automatic import.

Was this reply helpful? Yes No
Deepak K 15 on at

Like (0)

Report

Thanksnmaenpaafor the response.As of now when I'm creating New Trade Allowance Agreement records the number/ID is being generated automatically. Do we need to check any other configuration to confirm you the query that you have ? I'm not able to find the "Tade Allowance Agreement ID" sequence (Number starts with --> TAXXXXXXX) in the following location : Organization administration => Number sequences => Number sequences. Am I missing something? Can you please guide me to find the location to validate it?

Thanks

Deepak

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

For the number sequence setup you need two things:

1) Create a number sequence in Organization administration => Number sequences => Number sequences

2) In Trade Allowance Parameters form, Number sequences tab, select the newly created number sequence for the Trade allowance id

(I'm not 100% sure if step 2 is the correct place but please try).

Was this reply helpful? Yes No
Deepak K 15 on at

Like (0)

Report

I'm able to find it Please find the attached document for the screenshot. Sorry, I'm a bit confused by the statement "select the newly created number sequence for the Trade allowance id". Where ever I'm creating a new record the number is auto-generating.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

For the second point, did you find the parameters form? And the number sequences tab page?

There is one row on that tab page, called "Trade allowance id". And next to it is a field which specifies which number sequence to use on Trade allowance id. That's what you need to check.

Was this reply helpful? Yes No
Deepak K 15 on at

Like (0)

Report

nmaenpaa I'm able to find the number sequence tab please refer to the screenshot below. I hope this is what you are looking at. Do I need to use the newly generated sequence number "10361" to import the file?

Was this reply helpful? Yes No