SalesOrder and SalesLine combine in DIXF AX 2012

(0) Share

Report

Posted on by SII1MNL

1,295

Hi,

I would like to ask some questions regarding Import of data combining Sales Order header and Sales Order Line Table. Since it is standard and I want to create a custom Entity, Is it possible to combine 2 tables using standard Sales Order and Sales Lines using the Standard Table? and how it is created? Thank you.

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can develop a composite entity: http://axhelper.com/?p=4215

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

HI Nikolaos,

It means I need to create a customized Sales Order Table and Sales Order Line? Can I use the Standard SOH and SOL? but it gives me error saying: "Cannot create a record in Entity (DMFEntity). Entity name: Sales order header, DMFSalesTableEntity.

The record already exists." Please help me. Thank you.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi, most likely you can use the existing entities or create a new one. The entity name must be unique.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

Ho about the Display Menu Item should it be also unique? Thank you so much.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi,

yes, all objects must have unique names. You can't have two menu items with the same name.

Whenever you add your own objects to the system, you should use your own prefix in the naming.

For example if your prefix was ABC, then your entity could be ABCMyEntity.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

Hi I am able to create the composite Entity but right after generate source mapping and preview file it show error. Can someone tell me if should I sync the tables? Thank you.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Whenever you have issues in your dev system, it's good to start by doing a full x++ build, generate CIL and synchronize the database. And I recommend to run this automatically each night.

Let us know if it solved your issue.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

Hi Nikolaos,

I will do full X++ build generate CIL and Sync Database and I will inform you once the issue has been solved. Thank you.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

Hi Nikolaos,

after full build, generate CIL and Sync Database here is the the message now.

I tried only the simplest columns I need. Please help me. Thank you.

Ivan

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

At least in D365FO only XML format is supported for composite entities. You seem to be using CSV.

Could you try with XML and see if it helps?

Anyway "No rows available for preview" is just a warning, not an error. So it can also be that you don't need to worry about it.

Was this reply helpful? Yes No