Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

The field 'JournalNum' is not present in source

Posted on by 10

Hi all,

having problem running .csv file in DIEF. Getting the following message "The field 'JournalNum' is not present in source". Not a programmer and am struggling to get what I would consider a fairly simple task of uploading a General Journal to work. Have also tried the AX Dynamics Add-in for Excel with no luck also. All the You Tube videos make it look so seamless !

Any help/ideas would be appreciated

Paul

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The field 'JournalNum' is not present in source

    Hello Paul,

    Good to hear that things worked.

    Would you be so kind and verify the answer to get this thread completed?

    About the copy&paste experience:

    MS is working on that but not for AX2012 or earlier versions. If you upgrade to D365FO you can copy&paste records in a number of grids. Not into GL journals yet but I expect that this will become available in the very near future.

    Best regards,

    Ludwig

  • Highsun Profile Picture
    Highsun 10 on at
    RE: The field 'JournalNum' is not present in source

    Much appreciated Ludwig. This solution did work thank you. I still find this process to get a General Journal into AX unnecessarily convoluted. Use to ERP systems that allow you to copy and paste

    regards

    Paul

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The field 'JournalNum' is not present in source

    Hello Paul,

    The message indicates that you have not provided the journal number into which you want to import your lines.

    Can you please double check your templates used for uploading the journal and the lines?

    What might help you here is this blog post that illustrates this process:

    cloudblogs.microsoft.com/.../

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans