Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Import time registration using custom DIXF entity

Posted on by 5

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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    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.

  • 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 Profile Picture
    Gunjan Bhattachayya 35,421 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans