web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Import journals with r...
Microsoft Dynamics AX (Archived)

Import journals with reason code with DIXF

(0) ShareShare
ReportReport
Posted on by In AX2012 in the In... 499

Hi

I am making work around to understand Customisation in DIXF.

Below are my Entity details which i have selected for My Processing group.

2084.DIXF.PNG

My Problem here is i want to import journals along with the Reason code and Reason comment

(These reason code and comments will be entered in excel file which will be imported.)

through My DIXF Import reason code and reason comment should be inserted into ReasonTableRef(Table) and the related recid should be inserted into LedgerJournalTrans.ReasonRefRecID as below is the relation between LedgerJournalTrans and ReasonTableRef Tables.

LedgerJournalTrans.ReasonRefRecID == ReasonTableRef.RecId

Please help me with any link or steps to achieve this

,

Thanks

*This post is locked for comments

I have the same question (0)
  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    You can do all of it, just with one additional method in your DMF Entity class.

    Refer to the class method DMFInventTableEntityClass.generateItemGroupId() and try to understand the if and else block here.

    A very similar structure. (Creating data in another table, and referencing that in the present table)

    From the moment you get it, your Job is done in a matter of minutes. Ask if you have any question in the suggested method.

  • In AX2012 in the InventOnHandItemListPage I need to be able to f Profile Picture
    In AX2012 in the In... 499 on at

    Hi Crispin

    Thank you very much for the quick response

    but,there is no if else code in your above said DMFInventTableEntityClass.generateItemGroupId().

    Only below code is there

    public container generateItemGroupId(boolean _stagingToTarget = true)

    {

       return conNull();

    }

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,735 Moderator on at

    HI Raghu ,

    Refer this thread with similar requirement .

    community.dynamics.com/.../231540

  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    Beg your pardon! I referred to a customized example..

    You can check DMFInventItemBarcodeEntityClass.GenerateInventDim() method, where either inventDim is found / generated, and is used as a reference in the Entity table.

  • In AX2012 in the InventOnHandItemListPage I need to be able to f Profile Picture
    In AX2012 in the In... 499 on at

    Hi Crispin

    I could not understand, probably i need further help,

    I just want to bring to your notice that there is another class with name DMFReasonTableEntityClass.

    Can this class be of any help ?

  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    I don't see that class in my System (probably it is customized).

    But you will have to process that along with the Journal Import, so it has to be in your same Journal Import Entity class..

  • Verified answer
    Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    To get a good understanding of the generate** methods, I recommend this robscode.onl/x-dmf-custom-generate-method-r2r3

    If you have any specific question on this article, please ask. Happy to answer

  • Verified answer
    In AX2012 in the InventOnHandItemListPage I need to be able to f Profile Picture
    In AX2012 in the In... 499 on at

    Hi Crispin

    Thanks for your help with the link given by i got further understanding.

    I Observed DMFLedgerBalanceEntityClass.generateServiceCodeTable()

    In similar way i created DMFLedgerBalanceEntityClass.generateReasonCodeTable()

    and was able to insert records into ReasonTableRef Table

    reasonTableRef.RecId = ReasonTableRef::createReasonTableRef(entity.Reason,entity.ReasonComment);

    and I map the records into Target.

    My requirement was achieved.

    Regards

    Raghu.

  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    Excellent, you did it the most Standard way.

    Feedback appreciated.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans