Linenum in custom entity D365 x++

(0) Share

Report

Posted on by Community Member

Hi expert

1. I have created a custom entity and i have added a field called linenum(extends tradelinenum) . I want this field to incremented each time a new record is imported. How can I achieve it.

Some facts about my data entity

1. It's a set based entity. I have overridden copystaging to target method

2. I can set the auto increment property on linenum . Reason linenum is a part of the index on entity and staging table and linenum is set as noneditable and mandatory. Noneditable fields can't be set as autogenerated in the entity mapping.

3. I tried to override the insert method on the staging table but it dint work.

Please advise how can I achieve this.

Categories:

Development / Customization / SDK

Data Integration

All responses (7)

Answers (0)

Suggested answer

Pete Alberts 3,542 on at

Like (0)

Report
RE: Linenum in custom entity D365 x++

Firstly - forget about the staging table. Don't edit anything there. You should only update the staging table from the data entity (that option when you right click on the data entity top node).

You did not mention the properties on the actual table. I assume it is AllowEdit-No, AllowEditOnCreate-Yes and Mandatory-Yes.

Then do the following:

On the mapped field in the data entity - leave everything standard, except set Mandatory to No.

Then write your code pre-super() in insertEntityDataSource().

The code should be something like this:
Community Member on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

Yes I tried and it works and I am aware of it. However i am finding ways to generate linenum via code.
Community Member on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

Hi allowwdit and allowedit on create are set as yes on staging and on dataentity its auto
Pete Alberts 3,542 on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

So the field is non-editable and mandatory on table? A quick work around will be to change mandatory to "no".

Then I do not think what you are trying to achieve is possible with a Data Entity that supports set-based sql operations.

I haven't overridden methods on the staging table - I am quite sure that logic is meant to be on the Data Entity.

I can assist with exactly where you need to place the LineNum generation code - but first please confirm the Allow Edit, Allow Edit on Create and Mandatory properties on the table as well as the Data Entity.
Sukrut Parab 71,687 Moderator on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

Writing while loop with in copytargettostaging method does not make sense because you are not doing set based operation. Anyways you said this is custom entity then what if you make this field editable and set autogenerated ? Did you try that ?
Community Member on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

Hi sukrut

In postgetstagingdata method I am doing some data mapping like item I receive in file I update it with item in d365(update staging table) using insertrecordset and updaterecordset. In copyTargettostaging I am using while to loop through staging table and create some orders. Why while loop in copytargettostaging ? Because I receive flat file(header and line in one row) and also I have to do some logic before I insert data in target .
Sukrut Parab 71,687 Moderator on at

Like (0)

Report

RE: Linenum in custom entity D365 x++

What logic you wrote in copystatingtoTarget method ? Are you inserting data in table through insert_recordset statements ?