How to add new field added to entity to staging table

(0) Share

Report

Posted on by lfulk

Can someone explain how to get the new field that I added to an entity through an extension into the staging table? Ultimately I need the value in BYODB.

I added the field InterCompanyOriginalSalesId from PurchTable to PurchPurchaseOrderHeaderV2Entity as szInterCompanyOriginalSalesId through an extension and now can see it in the entity when looking at the odata query urls.

How do I get this field added to the staging table for that entity: PurchPurchaseOrderHeaderV2Staging? I assume I need to extend that table but I'm unclear how to add the fields so that they get mapped to the entity correctly. TIA!

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

You need to create a table extension (just like you created a data entity extension).

Then simply add a field with same data type and name than your new entity field.

Once done, and everything is built and synced, you need to refresh entity list in D365, and Generate mapping for this entity in the Data entities form.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi lfulk,

You will need to add the new field to an extension of PurchPurchaseOrderHeaderV2Staging table, like Nikolaos mentioned. You can check how SalesOrderHeaderV2Entity has an extension SalesOrderHeaderV2Entity.RevRec and the corresponding staging table the new fields added to the entity in the table extension SalesOrderHeaderV2Staging.RevRec.

Was this reply helpful? Yes No
lfulk 97 on at

Like (0)

Report
Copy link

Link copied!

Hi nmaenpaa, I really appreciate your quick response. Can you clarify what you mean by this?

you need to refresh entity list in D365, and Generate mapping for this entity in the Data entities form.

Is that just creating a new export project and adding the entity? I see the field in the mapping details that were automatically generated?

I tried this and it seemed to work well for the purchase orders entity. However, when I did this for another entity (Purchase Orders) that we had added a custom field to, it now errors with: Export execution failed for entity Production orders: Export failed while copying data from staging to target. I've since deleted my extension of the staging table and rebuilt and synced to database but it's still erroring when trying to export to excel.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (2)

Report
Copy link

Link copied!

Hi lfulk,

For refreshing entity list, please do the following -

1. Go to Workspaces > Data Management.

2. Open “Framework parameters”.

3. Under “Data import/export framework parameters”, select fast tab “Entity Settings” and click on “Refresh Entity List”.

For the error with production orders, can you go to Workspaces > Data Management and open Data entities? Here you can click on "Modify target mapping". On the form you can check the mappings and you can also generate mappings from scratch using the "Generate mapping" button. You can review if there are any errors in mapping which is causing this issue.

Was this reply helpful? Yes No
Moiz Shaikh 27 on at

Like (0)

Report
Copy link

Link copied!

Super

Was this reply helpful? Yes No