Finance | Project Operations, Human Resources, ...

GL data entity extension import

(0) Share

Report

Posted on by Johnny

6,478

Hello,

I have extended GL data entity with one field.

Export works fine.

During import I want to update LedgerJournalTRans table's field based on some logic,

In which method should I write the code?

I copied events related to mapEntityToDataSource method and insertEnttyDataSource, but during import I can't see those executed.

Breakpoint is not hit, nothing happens.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can write in any of the above methods. mapEntityToDataSource is called for each datasource on the entity, so you can try to write in it . If you are break point it not hitting thats a different problem but these methods must be getting called during import. Which entity you are using ?

Was this reply helpful? Yes No
Johnny 6,478 on at

Like (0)

Report

Hi Sukrut,

I added just an infolog to see and nothing was displayed.

I'm using Standard LedgerJournalEntity

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

LedgerJournalEntity does set based operation , check if the set based operation is enabled on the entity . copyCustomStagingToTarget method gets called when you import through this entity , you can take a look at this method and see how records are inserted and updated and use COC to handle your scenario.

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Hi Johnny,

You need to use COC to extend the mapEntityToDataSource method,

I create a test field, and update LedgerJournalTRans table’s RCashDocRepresPersonId field with the test field.

Please refer to the following code:

[ExtensionOf(tableStr(LedgerJournalEntity))] final class LedgerJournalEntity_Extension { public void mapEntityToDataSource(DataEntityRuntimeContext entityCtx, DataEntityDataSourceRuntimeContext dataSourceCtx) { next mapEntityToDataSource(entityCtx, dataSourceCtx); if (dataSourceCtx.name() == "LedgerJournalTRans") { LedgerJournalTRans ds = dataSourceCtx.getBuffer(); ds.RCashDocRepresPersonId=this.test; } } }

Was this reply helpful? Yes No
fspafj 257 on at

Like (0)

Report

Hi MATTGUO,

I am also trying to update value for a mandatory field xxx in the target data source by using a test field in the mapEntityToDataSource method similarly with your example code above.

However after importing the source file successfully into staging table, error occured while writing into target with below message:

Results.Field 'xxx' must be filled in.

Results.Validations failed while writing entity record.

I have built the project, model and synced database but the error still occured. What could be the reason for this error?

Thanks in advance.

Was this reply helpful? Yes No

Join the conversation

Community site session details

GL data entity extension import

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

GL data entity extension import

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates