Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / the problem of sequenc...
Finance forum

the problem of sequence of journal batch number

(0) ShareShare
ReportReport
Posted on by 212

I want to create a general journal by "General Ledger -> General Journal -> New ",


but when I click the "New" button, the Journal Batch Number is created as "00480", There has alerady been the "00480" in the system,


so I can't create any new general journal.


I think the next Journal number should start from 00620 as the below picture. ( or start with 006XX)


can you tell me how to fix the journal number which is created automatically?

3681.newjournal.png

  • elijahporch Profile Picture
    5 on at
    RE: the problem of sequence of journal batch number

    Great information

    The link has moved, but I want to make sure others find this

    dynamicsmanuals.com/.../

  • RongYan Profile Picture
    212 on at
    RE: the problem of sequence of journal batch number

    Hi Ties Philippi  & Others

    thanks very much!

    After I delete the sequence in the status list by "alt+delete", I can get the right sequence number now.

    It's not work that delete the sequence in the table brower, the error is that "there is line data you can not delete", maybe it needs change some business data. So I selected the easy way as above.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: the problem of sequence of journal batch number

    Do you really need continuous journal batch numbers?

    For journal vouchers, I can understand that some countries require continuous journal voucher numbers but the journals itself can usually have any number as long as it is not a duplicate.

    Also consider that over time you have to 'clean' the journal batch numbers. Otherwise, they will just grow and make your system slow.

    Best regards,

    Ludwig

  • qianwang Profile Picture
    7,153 on at
    RE: the problem of sequence of journal batch number

    Hi RongYan,

    Have you solved this issue?

    Is your environment a VHD?

    If so, please try to clear the option ‘Continuous’ in related Journal batch number sequences form. If the system becomes normal after doing this step, you can select the option ‘Continuous’ again.

    Regards,

    QianQW

  • Ties Philippi Profile Picture
    960 on at
    RE: the problem of sequence of journal batch number

    This is true.

    Though number 480 for journal batch relates to a contoso environment, have had that error so many times that it was actually the inspiration for the post.

  • Suggested answer
    Satish Panwar Profile Picture
    14,651 Moderator on at
    RE: the problem of sequence of journal batch number

    Hi RongYan,

    What Ties mentioned will help resolve the issue. Do know this can't be replicated all the time and happens occasionally with continuous number sequences. If you are able to replicate this consistently after clearing the record, open case with MS.

    Thanks,

    Satish Panwar

  • Verified answer
    Ties Philippi Profile Picture
    960 on at
    RE: the problem of sequence of journal batch number

    Hi RongYan,

    https://www.dynamicsmanuals.com/blog/cannot-create-a-record-in-ledger-journal-table-ledgerjournaltable

    Above is the explanation.

    Tl;Dr version press alt and delete to remove the number from the status list of the journal batch number sequence.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,027 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans