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

I have the same question (0)

All responses (7)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi allowwdit and allowedit on create are set as yes on staging and on dataentity its auto

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Pete Alberts 3,542 on at

Like (0)

Report
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:

Was this reply helpful? Yes No