Import of Sales Agreements

(0) Share

Report

Posted on by Ronald Richter

Hi all,

we have the necessity to Import sales agreements. I have not found a standard entity and AX brings up an error when I try to generate a new entity using the wizzard (tables with inheritance can are not supported by the wizzard).

Has anyone done this Import already?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

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

Like (0)

Report

Hi Ronald,

I have not had the requirement yet to import this table.

The wizard does not support to create entities when the table is inherited. In this case you can create the Staging table (and possible data types for enums), Target query and DMF class manually from scratch. It is a bit more work, but it is possible.

Was this reply helpful? Yes No
Ronald Richter on at

Like (0)

Report

Hi Andre,

thanks for your reply - I'am afraid that there will be no other way...

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

Like (0)

Report

Hi Ronald,

I had this problem with another inherited table in the past. I managed to create the objects manually.

Probably you can use a target entity with type Table, but that will import directly into the table without staging. Then also there is no possibility to update existing records.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Ronald;

I have the same request to import the sales agreements. I already started to create my dmf table and Query with SalesAgreementHeader, but i am not sur about the way to do it .

I want to ask you if have you successfully finished your DMF . Do you some idea to help me? Thanks

Was this reply helpful? Yes No
Suggested answer

Ronald Richter on at

Like (0)

Report

Hi Mohanad,

we tried it using DIXF but the problem was the inheritance of the tables. Hence we used conventional means by implementing in X++.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ronald;

Thanks for your answer. It's mean you create your own DMF table, Query and Class for agreement header and another DMF for the lines.

May you indicate which table you used?

Best Regardes

Was this reply helpful? Yes No
Ronald Richter on at

Like (1)

Report

Hi Mohanad,

no we didn't use DMF because it doesn't work with inherited tables. We implemented it as a casual X++-class using file I/O

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi we have the same requirement, I am planning to create a custom service and expose it, do you have any X++ code to import the Sales Agreements?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Experts,

We have the necessity to import paystatementbenefit(table name:PayrollPayStatement BenefitLine) using DMF. since the table is inherited from (PayrollPayStatementLine) we tried creating DMF objects manually and when we tried to import data from staging to target I getting following error message.

"Cannot edit a record in Pay statement lines (PayrollPayStatementLine).

The operation cannot be completed, since the record was not selected for update. Remember TTSBEGIN/TTSCOMMIT as well as the FORUPDATE clause"

Please suggest me how we can successfully import data for table inheritance

Thanks and Regards,

Karthik

Was this reply helpful? Yes No
Nour Desoki 555 on at

Like (0)

Report

Hello Andre ,

i want to know how to create DIXF objects manually to do this task ??

Was this reply helpful? Yes No