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.

All responses (12)

Answers (1)

SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

Hi Nikolaos,

Is there any solution for this? or additional logic for this? I used the Sales Order Header and Lines and since everything went smoothly until not able to insert into staging. :(

Ivan
SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

Hi Nikolaus,

No rows available for preview in XML and when I cclick get staging data it shows this info:
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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.
SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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
SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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.
SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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.
SII1MNL 1,295 on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: SalesOrder and SalesLine combine in DIXF AX 2012

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