web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Sales Order DIXF

(0) ShareShare
ReportReport
Posted on by 1,295

Hi,

I would like to ask some question regarding DIXF import of Sales Order.

Recently I created a DIXF for Sales Order (Combining SalesTable, SalesLine and MarkUpTrans) which is successful. since the MarkupTrans must have atleast 5 records per line(Which I made it by creating 5 classes for MarkupTrans). 

So here is my issue:

* The list of records I created in the text file the sales ID must created manually by passing through class ( this.GenerateSalesId(this.ParmStagingToTarget) ) for example I have 10 records and there are 2 header records and must have 5 records for salesline. ( which I have another reference field (customized field) ) so I can make it grouping to have atleast 2 sales id for the 10 records. So now I set the salesid Mandatory to "No" and it gives me an error which is I need to fill it up but I want to pass it through the class ( this.GenerateSalesId(This.ParmStagingToTarget)). so from the processing group and modify datasource of my entity I need to set the SalesID to "Auto Generate" which I don't want to make it Autogenerate. Now every line has unique salesId instead of grouping it by 2 so that I will only have 2 salesid and 5 records for salesline. 

Question: Is it still possible to do like this? I would like to have someone to guide me what will be the best practice to do it since the primary key for the entity table is the SalesID. 

Thank you.

Ivan.

I have the same question (0)

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans