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 :
Small and medium business | Business Central, N...
Suggested Answer

Import Journals

(0) ShareShare
ReportReport
Posted on by 30

Is there a way to get to a list of import journals made during a given month or year under a given user ID?  

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    61,204 Super User 2026 Season 1 on at

    Which version are you using?

    You can use Analysis mode from April onwards.

    https://youtu.be/LgxOQ_kXhpw

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,165 Moderator on at

    What exactly do you define as an import journal?

  • Suggested answer
    YUN ZHU Profile Picture
    99,090 Super User 2026 Season 1 on at

    Hi, I don't know what journals you mentioned, take General Journals as an example:
    Data audit fields have been added on all tables, I think you can use these fields, then filter to get your results.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-system-fields#audit

    pastedimage1678059771157v1.png

    Finally you can export all data using Open in Excel.

    pastedimage1678059855451v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Carlyman470 Profile Picture
    30 on at

    We utilize import journals thru Excel quite a bit at the end of the month - we find it is easier to do this than use re-occurring general journals.  One import might have 100 lines worth of journal entries and while you can go to Posted Journal Entries and see every line/Document No, does Business Central use some identifier for the whole import journal.  For example IMPJ**** to identify one of our imported journals.  

    I'm not sure what version of Business Central we are using.  Where within Business Central is it identified?  

    [quote user="Carlyman470"]

    Is there a way to get to a list of import journals made during a given month or year under a given user ID?  

    [/quote]
  • Carlyman470 Profile Picture
    30 on at

    I'm not sure what version of Business Central we are using - where would I find it?

  • Suggested answer
    YUN ZHU Profile Picture
    99,090 Super User 2026 Season 1 on at

    Hi, You can see the version you are currently using with the method below.

    pastedimage1678061244760v1.png

    pastedimage1678061252718v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Carlyman470 Profile Picture
    30 on at

    We import thru Excel many of our journal entries each month - we find this easier to maintain than setting up recurring entries.  Wondering if Business Central identifies each imported jouranal with something like IMPJ**** so if we want to quickly go back and look at what we imported, we can find the entry again instead of going through Process\Find Entries\G/L Entry.  

  • Suggested answer
    YUN ZHU Profile Picture
    99,090 Super User 2026 Season 1 on at

    Hi, I think you can use Batch, or No. Series in Batch to distinguish the content you import.

    pastedimage1678062183996v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    11,417 Super User 2026 Season 1 on at

    HI

    you can easily obtain a list of the import journals made during a particular month or year with a specific user ID using the 'Journal - Import' page.

    To view the list of import journals do the following:

    Go to the search bar and search for "Journal - Import".

    Click on the "Journal - Import" link that appears.

    On the Journal - Import page, use the "Filter" box on the left-hand side to set the desired filters for the import journals you wish to view. You can filter by user ID, publication date and other criteria.

    Once the filters have been set, click on the 'Apply Filter' button to display the list of import journals that match the set criteria.

    To view further details on a specific import journal, click on the journal row to open it.

    You can also use the 'Export' button to export the list of import journals to Excel or another format for further analysis or reporting.

    By using the Journal - Import page and setting the appropriate filters, you can quickly and easily view the list of import journals made during a specific time period with a specific user ID in Microsoft Dynamics 365 Business Central.

    DAniele

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,993 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,116 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans