Dynamics Community Forum Thread Details

Sales Order DIXF

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.

Quick Links

Leaderboard