Import time registration using custom DIXF entity

(0) Share

Report

Posted on by Meshal.Binyarbua

I create custom entity to import time registration for employees to target table JmgTermReg and I done that easily but I have problem on clock in/out does not display in calculate form for any one of employees. I believe that JmgTermReg is not only table involved when import time registration and there others tables like JmgAttendanceRegistration, JmgStampTrans and JmgStampTransJournal.

How can make custom entity to insert data to more than one table at same time.

I use AX 2012 R3

Thank you in advance.

All responses (3)

Answers (1)

Verified answer

André Arnaud de Cal... 293,041 Super User 2025 Season 1 on at

Like (0)

Report

RE: Import time registration using custom DIXF entity

Hi Meshal,

When you go to the target entity form, you can enable the execution logic for insert and update methods. Then on the processing group you can also enable it. In that case the custom entity will call the insert logic when copying the staging records to the target.
Meshal.Binyarbua 5 on at

Like (0)

Report

RE: Import time registration using custom DIXF entity

Hi Gunjan

I really understanding most of how custom entity work. In customer entity it take payment id from paymentMethod table and put it in customer table not create new payment.

In my case when i use manually time registration it is updated 6 tables :

- JmgTermReg

- JmgAttendanceRegistration

- JmgTimecardTable

- JmgTimecardTran

- JmgStampJournalTable

- JmgStampJournalTrans

It seeming when insert new record to JmgTermReg it run insert function that found in JmgTermReg and that function update all another tables.

any way to like this using custom entity.

thank you agine
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Import time registration using custom DIXF entity

Hi Meshal,

You can take a look at creating a custom entity manually here.

You can take an example of Customer entity in which data insertion into multiple tables is handled.